Create Map for Importing to UPS

(COM or PPS users with UPS WorldShip Integration)

In this procedure, you will map Eagle for Windows (E4W) fields to their corresponding fields in UPS Online WorldShip (UOWS) so that you can import information from Eagle for Windows to UOWS. This procedure is performed in UOWS.

  1. Start UPS Online Worldship (UOWS) as you normally would.

  2. From the UOWS menu, select "UPS OnLine Connect" / "Connection Assistant." The Connection Assistant dialog displays.

  3. Select the "Create a new map for Import" radio button.

 

  1. Click the "Next" button. The "Connection Assistant – Select the Data Type – Step 2 of 5" dialog displays.

  2. Select "Shipment" from the "Import Data Types" drop-down list, and click Next.

  

  1. From the "Connection Assistant – Data Source – Step 3 of 5" dialog that displays, select "By Known ODBC Source" in the "Select the Data Source" section, and select "E4WExport" in the "ODBC Sources" section. Then click Next.

  1. From the "Connection Assistant – Select a Name for Map – Step 4 of 5" dialog that displays, select "New Map" in the "Select New Map or New Map based on Existing Map" section, and type "E4W-TO-UPS" in the "New Map Name" field. Then click Next.

  

  1. In the "Connection Assistant – Prepare the Map -  Step 5 of 5" dialog, simply click Finish.

  2. In the "Edit E4W To UPS Import Map" dialog that displays, the fields in the left column represent the Eagle for Windows (E4W) fields, while the fields in the right column represent the UPS Online WorldShip (UOWS) fields. Follow the steps below to map the Eagle for Windows fields to the corresponding UOWS fields.

    1.  In the ODBC Tables box, select "e4w.txt" from the drop-down list.

    2. In the left column, under Column Name, click "Order Number" to select it.

    3. In the Worldship Fields box, select "Package" from the drop-down list.

    4. In the right column, under Field, click "Reference 2" to select it.

    5. Click "Connect" to establish the mapping between the ORDERNUMBER and Reference 2 fields.

Notice after you press Connect that both of the mapped items now have a visual indicator (the chain link) to signify that they are mapped to each other. The mapping also shows at the bottom of the screen in the "What you have mapped so far" section.

    1. Map the remaining fields on the screen by using the following table. For example, to map the first row in the table, leave "e4w.txt" in the ODBC Tables field, click Company in the Column Name column (on the left), select Ship To in the Worldship Fields List, click Company Or Name in the Field column (on the right), and click Connect.

ODBC Tables

Column Name

WorldShip Fields List

Field

e4w.txt

Company

Ship To

Company Or Name

e4w.txt

Attention

Ship To

Attention

e4w.txt

Street

Ship To

Street Address

e4w.txt

Address2

Ship To

Room / Floor / Address2

e4w.txt

Address3

Ship To

Department / Address 3

e4w.txt

Country

Ship To

Country

e4w.txt

Zip

Ship To

Postal / Zip Code

e4w.txt

City

Ship To

City

e4w.txt

State

Ship To

State

e4w.txt

Phone

Ship To

Telephone

e4w.txt

FAX

Ship To

 Fax Number

e4w.txt

ServiceCode

Shipment Information

Service Type

e4w.txt

CustomsDescriptionOfGoods

Shipment Information

Description Of Goods

  1. When finished mapping all items in the table, scroll to the top of the list in the left column, click "Order Number" to select it, and click "Define Key."

You must click Define Key before proceeding!

Your screen should now look similar to the following:

 

  1. If you made any mistakes mapping the fields, locate the mistake in the list at the bottom of the screen, click it, and click the "Disconnect" button. Then remap the item. Press OK when you are certain you’ve mapped all the fields correctly. When asked if you want to import data now, choose "NO".

  2. Proceed to the topic "Create Map for Exporting to Eagle for Windows."

Submit Your Comments on This Help Topic