Loading zone data into staging tables

Before you load zone data into staging tables, set up the zone data configuration files and the CSV files that contain the zone data. You must use a separate configuration file and CSV file for each country for which you need to load zone data. Before loading data into the staging tables, clear existing data from the tables.

Guidewire recommends that you load a complete set of zone data for a country rather than loading incremental changes to zone data. Incremental changes cause a non-linear growth in the time to import zone data and in the size of the zone link table. To reload data for a country for which zone data already exists, you must first clear the zone data for that country from the operational zone tables.

Example commands are shown below.

  • Web service method examples
    ZoneImportAPI.importToStaging("DE", "myzonedata.csv", clearStaging : true)
ZoneImportAPI.clearProductionTables("DE")
  • Command prompt tool examples
    zone_import -import myzonedata.csv -country DE -clearstaging -server http://myserver:8080/pc \
  -user myusername -password mypassword
zone_import -password password -clearproduction -country DE

See also