Open UPS Worldship and select Import/Export Date>Create/Edit Map
Images may vary depending on UPS WorldShip version
Under New Map (like above) select:
- Import from ODBC Database
- Shipment (from pull-down window)
- Name “UPS Import from Presidio”
- Click Create
- Select the ODBC driver created earlier and enter your credentials to connect.
The Map Fields window will appear (below).
Under ODBC Tables, Select: vwShipIntegrationSource
Connect the following fields using the Connect button. Some of the UPS WorldShip fields are found under Shipment Information
| ODBC Field | WorldShip Field |
| sLookUpJobSeq | Shipment Information::Reference 2 |
| sServiceCode | Shipment Information::Service Type |
| sBillingOption | Shipment Information::Billing Option |
| sShipToContactLastF | Ship To::Attention or other Contact Format Option |
| sShipToName1 | Ship To::Company or Name |
| sShipToAddress1 | Ship To::Address 1 |
| sShipToAddress2 | Ship To::Address 2 |
| sShipToCity | Ship To::City or Town |
| sShipToState | Ship To::State/Province/County |
| sShipToZip | Ship To::Postal Code |
| sShipToContactEMailAddr | Ship To::Email Address |
| sShipToContactPhone | Ship To::Telephone |
| sShip3rdPartyAcctUPS | Third Party::UPS Account Number |
| sBillToName1 | Third Party::Company or Name |
| sBillToAddress1 | Third Party::Address 1 |
| sBillToCity | Third Party::City or Town |
| sBillToState | Third Party::State/Province/County |
| sBillToZip | Third Party::Postal Code |
After the fields are mapped, Click sLookUpJobSeq then Define Primary Key for Import
The last step is to translate the Presidio Service Codes.
On the bottom of the Mapping screen under “What you have mapped so far”
- Click: vwShippingIntegrationSource::sServiceCode
- Click Edit on the right side of the screen
- Under Translations rename the External Field Service codes as shown below:
Click OK, OK and Close to complete the Import Setup.