Configuring an Export Map

The next step in integrating UltraCart with UPS WorldShip is to configure an export map so that tracking information and quickly be exported from UPS WorldShip and imported into UltraCart. First, start the UPS WorldShip software and select the Connection Assistant from the UPS OnLine Connect menu.

Figure 362 - Opening the Connection Assistant
Select "Create a new map for Export" and then click the Next button.

Figure 363 - Creating a new map
Next, choose "Shipment" as the Export Data Type and click the next button.

Figure 364 - Choosing the Export Data Type
On the third step, select "By File", enter "c:\upsimport\export.csv" in the Currently Selected File field, enter "UltraCartExport" in the DSN field, select "Microsoft Text Driver" in the ODBC Drivers list, and click the Next button.

Figure 365 - Configuring Data Source
On the next screen, select New Map, enter "UltraCartExport" in the New Map Name field, and click the Next button.

Figure 366 - Naming Export Map
On the next screen, simply click the "Finish" button. This will cause an "ODBC Text Setup" dialog to appear like the one in the figure below. Simply click the OK button on this dialog.

Figure 367 - Configuring ODBC Text Setup
The next step is to configure the columns that UPS will export into the text file. First click on the "Package" tab, click the "Tracking Number" field in the left hand list, and then click the "Add" button. At this point your screen should look like the figure below.

Figure 368 - Adding first column to export
After adding the tracking number, the next step is to add information about the ship to address. Click on the "Ship To" tab and then click the "Add All Columns" button. At this point your screen should look like the figure below.

Figure 369 - Adding Ship To Columns to Export
The final step in the configuration of the export file contents is to select "Overwrite existing file" and "Include header row". The header row is very important because it allows UltraCart to determine the meaning of each column in the export file. After selecting the two options, click the OK button.

Figure 370 - Export Header Option
At this point, the export map is complete. The next section details exporting information using the newly created map.