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: 

  1. Export data from WorldShip (or Export to ODBC Database)
  2. Shipment (from pull-down window)
  3. Name “UPS Export to Presidio”
  4. Click Create
  5. Select the ODBC driver created earlier and enter your credentials to connect.

The Map Fields window will appear (below).  

Under ODBC Tables, Select:  tblUPSShipmentData

WorldShip FieldODBC Field 
 Shipment Information::Void Indicator siIsVOID
 Shipment Information::Service Type siServiceType
 Shipment Information::Shipment ID siShipmentID
 Shipment Information::Billable Weight siBillableWeight
 Shipment Information::Billing Option siBillingOption
 Shipment Information::Description of Goods siDescriptionOfGoods
 Shipment Information::Number of Packages siNumberOfPackages
 Shipment Information::Total Shipment Published Charge siTtlShipPubChg
 Shipment Information::Lead Tracking Number siLeadTrackingNumber
 Shipment Information::Shipper Number siShipperNumber
 Shipment Information::Package Type siPackageType
 Ship To::Attention stAttention
 Ship To::Company or Name stCompanyName
 Ship To::Address 1 stAddressLine1
 Ship To::Address 2 stAddressLine2
 Ship To::City or Town stCity
 Ship To::State/Province/County stState
 Ship To::Postal Code stZipCode
 Ship To::Telephone stTelephone
 Ship To::Fax Number stFAX
 Ship To::Country/Territory stCountry
 Ship To::Email Address stEMailAddr
 Package::Tracking Number pkgTrackingNumber
 Package::Reference 2 pkgPackageReference1
 Package::Package Type pkgPackageType
 Package::Weight pkgWeight
Click OK then Close to complete the export setup.