Import tools and commands

PolicyCenter provides both command prompt tools and web services APIs to support loading data from staging tables to operational tables in the database.

Table import web service – The TableImportAPI web service provides table import functionality. This web service provides asynchronous methods, which return immediately and perform the command as a batch process. For example, deleteExcludedRowsFromStagingTablesAsBatchProcess. The web service methods return the identifier of the batch process that is running the command. Use the MaintenanceToolsAPI web service method batchProcessStatusByID to check for completion of the batch process.
Table import command prompt tools – The table_import command prompt tool provides synchronous and asynchronous options to support importing data from staging tables into operational tables. To run the command asynchronously, add the -batch option. Asynchronous commands return immediately and perform the command as a batch process. For a list of options, run the following command from PolicyCenter/admin/bin and view the built-in help.
```
table_import –help
```

PolicyCenter also provides tools to load data from CSV files to the staging tables for zone data.

Zone staging table import web service – The ZoneImportAPI web service provides functionality to import CSV data into the zone staging tables. All tools are provided as synchronous methods, which do not return until the command completes.
Zone staging table import command prompt tools – The zone_import command prompt tool provides synchronous options to import CSV data into the zone staging tables. For a list of options, run the following command from PolicyCenter/admin/bin and view the built-in help.
```
zone_import –help
```