Running the Partner Manager XML Autoload Utility

Edit online

About this task

The XML files created by the conversion map have to be loaded in the order they are listed above. Please note that you might have to run the conversion process several times before you get a clean run. Therefore is best to make a backup of your target database before loading any data. Perform the following steps for each file:

Procedure

  1. Copy file tm82.dtd from tmgr_vn.n\pmgr to the tpec2cm folder.
  2. Start program PMAutoload.exe in the pmgr folder.
  3. Select the appropriate XML input file using the Find button.
  4. Configure the destination database to match the one configured in the tpec2cm.mdq file.
  5. Select Validate Only; Do not change Database, Allow Add, Detailed Report, and Reject data that exceeds size.
  6. Click Begin.

Results

At this point the XML Autoload will validate the input file for format and content using the target database and any error are reported. Usually there are two types of errors:

  • ISA field values that are not supported by Trading Manager. Either update the TPEC2CMConfig.txt file or, using the Standards option in Partner Manager, add the unsupported values to Trading Manager.
  • Duplicate ISA Qual/ID combinations. This can happen when the new value for "IchgQual" in the TPEC2CM Configuration file is already used by some other partner. This can be resolved by either selecting a new value in the configuration file that is not used or changing the ISA information in TPEC for one of the duplicate partners.

Once the files are valid then proceed with the load by selecting "Run Load" in the XML Autoload. The most typical error during this step is:

  • Missing structure files in Trading Manager. Either the structure files have not been loaded into the target database of the TPEC system is using non-standard transaction-version/release combinations. The user must either load or create and load structure files indicated by the errors.