Microsoft Dynamics AX integration with UPS Worldship. Part1 – Data import options

Recently, I have faced with the requirement to integrate Microsoft Dynamics AX 2012 R2 with UPS WorldShip. The most difficult part is to understand what kind of connections UPS WorldShip supports.

UPS Worldship has several options for data import:

a)      Keyboard Import (manual): A source file is needed. The best is a CSV file. An ODBC session has to be created to link the source file with Worldship. The file name must always be the same. A unique key (e.g., the order number) is needed. Worldship then searches the record in the source file. All missing information can then be entered manually.

b)      Batch import (half automatic): A source file is needed. The best is a CSV file. All orders are entered in the ERP system. The completeness of the record is required. Then you will need to export all the records at once, and Worldship prints all jobs in succession.

c)       Fully automatic import: An XML file as the source file is most suitable. You create the order in the ERP system and then save the XML file in a folder. In the Worldship you specify where this XML file can be found. After starting Auto Import, Worldship looks in this directory to see if there is a new file.

d)      Direct connection: Access the ERP system directly by using an ODBC interface. For this option, you have to know where to find the individual fields.

Further information can be found in the support documents on UPS site homepage https://www.ups.com/de/en/help-center/technology-support/worldship/support-documents.page?loc=en_DE

The information above will give you a start point.

Please refer to the link for the file format explanation which is suitable for UPS Microsoft Dynamics AX integration with UPS Worldship. Part2 – Export and import file formats