FAQ   |   Knowledgebase   |   Request a demo  

Go Back

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.

Facebook Twitter DZone It! Digg It! StumbleUpon Technorati Del.icio.us NewsVine Reddit Blinklist Add diigo bookmark

App-Like MS Office Files Create Potential Risks
Read this informative, new whitepaper from Chris Davies
Download»
Challenges and Solutions in Enterprise Deployment Methods
Best practices and practical solutions discussed
Download»
CertificationsMore On Microsoft