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:
- The EAutoImport.dat and EAutoExport.dat files can be 'copied' from the original workstation (or a working workstation).
- The files must be placed in the appropriate WorldShip sub folder (installation path varies from install to install)……. […/ImpExp/Shipment/ ] typical.
- 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?
Open the Import/Export Menu in WorldShip, to eAutoExport to verify the user pointing to the ODBC.