UPS WorldShip Setup with the Enterprise Edition

In this Topic: Show

Overview

This article outlines the steps necessary to begin setting up the integration between the Enterprise Edition of the Order Manager and UPS WorldShip.

This article assumes that the Enterprise Edition of the Order Manager is up and running, i.e., the Order Manager database (store) file is installed successfully on a SQL server and the Order Manager program file has been installed on the computer where you wish to setup WorldShip.

After you complete the steps in this article, go to the document UPS WorldShip Setup Full Documentation. To complete the setup, follow the instructions in these sections of that topic:

3) Creating an Import Map in WorldShip

4) Creating an Export Map in WorldShip

5) Processing Orders in WorldShip

 

For troubleshooting tips, see the Troubleshooting section below.

Link WorldShip with the Order Manager

    1. Create a blank Access database. Name it "worldship.mdb" or something similar, and if possible, save it in your StoneEdge directory (e.g. C:\StoneEdge).

    2. Open the Access database. From the File drop-down menu, select Get External Data> Link Tables. The Link window opens.

  1. At the bottom of the Link window, click the Files of type drop-down list and select ODBC Databases. The Select Data Sources window opens.

  1. Under the Machine Data Sources tab, select the Order Manager database (store) file System DSN (this was created when you set up the OM Enterprise and points to your OM database on SQL server) click OK.
    1. If you are using SQL Authentication, you will also be prompted to encrypt your password.
    2. Click Save Password.

 

The Link Tables window opens.

  1. Holding the Ctrl or Shift button, select your orders table, typically "dbo.Orders," and dbo.ShippingMethods from the list of tables. Click OK.

  2. The database dialog box opens:

  1. From the File drop-down menu, select Get External Data> Import. The Import window opens.

 

  1. Browse to your Order Manger files (typically located in C:\StoneEdge) and select the SEOrdManEnt2002.mdb file. Click Import. The Import Objects window opens.

  1. On the Queries tab, select WorldShipOrdersSQL. Click OK. The files now shows up in your Queries list.

  1. Now, create a new System DSN for this Access database. Go to Control Panel> Administrative Tools> Data Sources. The ODBC Data Source Administrator window opens. On the System DSN tab click Add.

 

  1. The Create New Data Source window opens. Click Microsoft Access Driver (*.mdb) and click Finish.

  1. Type a name (any name will do) for the DSN in the Data Source Name field, and then click the Select button.

  1. The Select Database window opens. Select the location of the new database you created (e.g. "worldship.mdb") and click OK.

 

  1. Click OK in the ODBC Microsoft Access window. The DSN name will now appear in your ODBC Data Source Administrator window.

Next Steps

As mentioned at the beginning of this topic, it is necessary to finish setting up the integration between WorldShip and the Order Manager, by going to UPS WorldShip Setup Full Documentation and completing  the steps in the following sections, 3) Creating an Import Map in WorldShip, 4) Creating an Export Map in WorldShip, and 5) Processing Orders in WorldShip.

When those steps have been completed, the integration is complete.

Troubleshooting

ODBC errors may occur if the SQL Server is not configured properly. Creating a trusted connection between the server and the computers running World Ship may resolve some of the errors. For further assistance, contact Stone Edge Technologies Tech Support.

 

Created: 2/7/12

Updated: 6/24/12

Go to Top