Jump to content


origkds's Content

There have been 2 items by origkds (Search limited from 06-May 23)


By content type

See this member's

Sort by                Order  

#2618 Worldship Automatic Importing

Posted by origkds on 24 July 2009 - 03:27 PM in Shipping Issues & Calculation

I use a program called DBF Viewer 2000 and wrote a batch file that runs the following routine via Windows Scheduler automatically every minute.

call "C:\Program Files\DBF Viewer 2000\dbview.exe" /APPEND:C:\UPS\WSTD\ImpExp\Mom_Import.dbf,C:\UPS\WSTD\ImpExp\upsworld.dbf
Call "C:\Program Files\DBF Viewer 2000\dbview.exe" C:\UPS\WSTD\ImpExp\Mom_Import.dbf /DELETEDUPS
Call "C:\Program Files\DBF Viewer 2000\dbview.exe" C:\UPS\WSTD\ImpExp\Mom_Import.dbf /PACK

It appends records from upsworld.dbf to a file I named Mom_Import.dbf. It then removes duplicates and finally packs the file. I point the ODBC connector at Mom_Import instead of upsworld. Using the keyed import function in Worldship I scan the barcode on the packing slip and ship the package. There may be a better way to accomplish this task but with my limited programming skills this was the best I could muster. It has been working perfectly.

Note: I found that converting upsworld.dbf to a CVS file caused other problems like dropping the leading zero on zip codes from the East Coast. Also any record with a comma in any field would throw the record off by one field and make it unusable.



#2503 Mail Order Manager vs. Mailware

Posted by origkds on 04 May 2009 - 12:08 PM in MOM Alternatives

Are there any ex-MOM (Dydacomp) users out there that have made the change to Mailware? Any input would be greatly appreciated.