Clearing errors from staging tables

The data rows in staging tables must not contain errors that cause integrity checks to fail. You must correct the data in your zone data CSV files. Then, clear the staging tables and reload the data to the staging tables.

Example commands to delete all rows from the zone staging tables are shown below.

• Web service method example

  ZoneImportAPI.clearStagingTables()

• Command prompt tool example

  zone_import -password password -clearstaging

Example commands to delete all rows from the error table are shown below.

• Web service method example

  var batchProcessID = TableImportAPI.clearErrorTableAsBatchProcess()

• Command prompt tool example

  table_import -password password -clearerror