ID530 - UPS Integration Troubleshooting & FAQ

Before you complete an e-automate upgrade, please search the WorldShip Computer for these two files: EAutoExport.dat and EAutoImport.dat. These should be saved in a safe location before the upgrade just in case.

Server Move affecting UPS Integration:

1. The SQL login ID from the original server used in the integration must be manually deleted from the converted e-automate production database security section.

2. New SQL Login id to be used in the ODBC and WorldShip integration connection must be created on new server with the default schema _custom_placeholder on the converted e-automate production database .

3. The ODBC driver used in the integration on the WorldShip workstations must be updated and configured to point to the new server using the new login ID & password.

4. The EAutoImport & EAutoExport WorldShip import/export mapping logins must be updated in WorldShip with the new SQL user ID & password.


New WorldShip workstation added:

  1. The EAutoImport.dat and EAutoExport.dat files can be 'copied' from the original workstation (or a working workstation).
    1. The files must be placed in the appropriate WorldShip sub folder (installation path varies from install to install)……. […/ImpExp/Shipment/ ] typical.
    2. The ODBC DSN name used in the integration on the original/working workstations must be created on the new workstation. Note: DSN name is CaSE SenSaTivE! 

If the files are copied into the correct folder, but they do not show up in the WorldShip client as an option for Keyed Import or Export After Shipment Processing, then typically the DSN name is wrong (or the DSN user ID & password login connection isn't working.

New User on WorldShip Computer?

The new user must have the exact same ODBC USER DSN name created under their user profile. Remember, WorldShip stores a lot of the data on the user profile, which is why 90% of clients setup a domain user called ‘shipping’ so that they aren’t constantly having to reset the mapping etc.
To create the new user: look at that user's ODBC DSN configurations. There might be one called ‘WorldShip’ or something to that effect. If you see a WorldShip ODBC connection, then you need to create the exact same ODBC connection under the new user. Remember, the name is CAsE SensITive and has to match exactly.
Why doesn't the UPS Shipping Label Address Info match the SHIP TO info from the packing list/sales order?
Do you have your customer address imported into the WorldShip address book and/or are you using the pencil edit on either the sales order or the shipment in e-automate to change the ship to address?
ODBC Error State:

Open the Import/Export Menu in WorldShip, to eAutoExport to verify the user pointing to the ODBC.


We just received WordShip 2018 and since we are using the integration with e-automate and CEO Juice, I want to make sure its OK to install. Are there any known issues or things to be aware of prior or during the install?
There should be no problems, OK to update.  Please search the WorldShip computer for these two files (EAutoExport.dat and EAutoImport.dat) and save those files in a safe location before the upgrade just in case.
Let us know at if you run into any issues.
How many workstations are included in the fee?
The fee includes 2 workstations. Additional workstations are $75.00 each.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk