origkds

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.