Loading data using the loading utilities

This diagram illustrates the basic steps involved in the loading process.

1. The loading utilities require the WebSphere Commerce DTD file. If the DTD file is available, then go to the next step. Otherwise, use the DTDGenerator utility to generate a DTD file. The DTDGenerator uses a text file that contains the table names for which the description is required and the output DTD file name. The result will be a DTD file containing the description of the database tables.

2. The WebSphere Commerce XML data file needs to be resolved for unique keys. This requires the idresgen utility, which uses the DTD file and the generated WebSphere Commerce XML to produce the output XML data file with resolved identifiers.

3. The data from the resolved XML data file generated in the previous step is loaded into the WebSphere Commerce database using the massload utility. This utility uses the resolved XML file as the input and loads the data into the WebSphere Commerce database.
4. Managed files are loaded separately using the fileloader utility.