Using the XML Autoload Utility

Foreign Keys Requirement - Because data is inserted by an SQL transaction, before you use the XML AutoLoad Utility, foreign keys (dependencies) must already be in the database. For example, you cannot add Trading Partners and then a Trade Link for those new Trading Partners within the same XML input file; separate these two into two XML files.

Another example is Post Offices. You cannot add a new Post Office and then reference that new Post Office in a Trade Link within the same XML file. You must separate these into separate utility runs.

There are two exceptions to this rule. Application Partners and Contacts do not require their parent records added in a previous run of this utility because these records are direct siblings in the XML input format (their definition exists only within their parent record).

When entering data in Partner Manager be aware that case sensitivity can vary by Database Vendor and even by database instance. For example, Microsoft Access considers "Acme" to equal "ACME"; most other databases consider these fields unequal. Consult your Database Administrator to determine if your database is case sensitive and plan your database entries accordingly, especially if using Partner Manager to copy and merge functionality between database vendors.