FAQ   |   Knowledgebase   |   Downloads   |   Blog

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

Post a comment!
  1. Formatting options
       
     
     
     
     
       

Risk Assessment Offer
An ODRA (Office Deployment Risk Assessment) can discover what your real risks are - and you may qualify for a free one.
Learn More »
ACF Program
ConverterTechnology offers application compatibility program services. Hit your Windows 7 deployment goals without fear.
Read More »
CertificationsMore On Microsoft