Deleting the data from a partially imported XML file

If the import task is interrupted for any reason (stopping the service during processing, system crash, power failure, etc.) it is possible that some, but not all, of the records contained in the import XML file would have been inserted into the OC_Import database. If this occurs the user must delete the existing records from the OC_Import database prior to reprocessing the import.

Use the following instructions to remove the incomplete date:

  1. View the log file for the import task that was partially imported.
  2. Record the Batch ID number.
  3. Open the SQL Query Analyzer.
  4. Select the OC_Import database.
  5. Delete the import records from the “Import” table that match the batch ID recorded in the log file.
  6. Create a new import task and import the XML file that had previously failed.