|
Addresses In UPS System
Purpose: This document provides instructions for extracting government furnished information about shipping destination addresses stored in various United Parcel Services (UPS) databases. These instructions are furnished for the convenience of State and local government agencies to assist in the transition to new contracts in which UPS did not participate; the DGS did not prepare these instructions and encourages users to consult with their new shippers or UPS if they experience difficulties.
UPS WORLDSHIP®
- Click on Connection Assistant, then select Create New Map For Export.
- Click on Next, then Next again, then Select Data Source - By File.
- Click Browse and find the file C:\UPS\UOWS\UPSDB.MDB, select it, then click Open.
- Select the correct ODCB driver, then MS Text Driver (CSV or TXT).
- At the top (on the right), type in the Datasource Name (whatever you want it to be).
- Ignore the ID & Password it asks for and click Next.
- Select New Map, then give it a new map name (must be different from the name selected in step 5.
- Click Next, then Finish, then OK.
- You can specify the columns you wish to export here (like Company Name, etc.) or you can Add All Columns.
- Under Define CSV Filename, select Save In A:, give it a filename, then click Save.
- It will go back to the previous screen, then click OK.
- Click on Yes to Batch Export.
- It generally takes a little bit to compile then info, then a box will pop up, click Save to write to the floppy drive.
Look for file called UPSXPORT.CSV
UPS ONLINE®
There are several versions of the UPS Online program. You will need to determine which of the below versions works for you.
From the UPS Main Menu
- Put disk in a drive
- Choose Import/Export
- Choose Export
- Choose the "a drive" at the bottom right corner of screen
- Choose the Delimited csv file
- Select Retain Records on Export
- Choose Consignee and click on OK.
This will create the *online.csv * file. This is a comma delimited file so conversion can be done in the field by using Excel and following the steps in the Receiver Conversion in Excel instructions. *The file may create a file called default.csv instead, this is fine.*
- Minimize (-) UPS Online Office Screen.
- Click on MY COMPUTER.
- Click on C:\
- Click on UPS folder.
- Click on OFFICE folder.
- Click on IMPEXP folder.
- Click on UPSXPORT folder.
The UPSXPORT folder is a Microsoft Excel Spreadsheet. Now follow the RECEIVER CONVERSION IN EXCEL (version 5.0 or greater).
|
