Importing a zone data file

To import zone data, use the zone_import command. The zone_import command imports data in CSV format from specified files into database staging tables for zone data. It is only possible to import zone data for a single country at a time. The zone data files that you import must contain zone data for a single country only. To load zone data for multiple countries, use the command multiple times with different, country-specific zone data files each time.

After you use the zone_import command to import zone data, set the PolicyCenter server run level to MAINTENANCE. Then, move the data from the staging tables to the production tables by using the table_import command. See table_import command for more information on the table_import command. Finally, set the PolicyCenter server run level back to MULTIUSER.

Guidewire expects that you import address zone data upon first installing PolicyCenter, and then at infrequent intervals thereafter as you receive data updates.

Import a zone data file

Procedure

  1. Start the PolicyCenter server.
  2. Clear the zone data staging tables.

    If you have multiple countries defined, you can include the -country countryCode option to clear staging zone data only for the country you want to load:

    • zone_import -password password -clearstaging [-country countrycode]

    The PolicyCenter administration command prompt tools all require that you enter the password of an administrative user for the tool to work. The use of a user name is optional.

  3. Load the zone data file into the staging tables:
    • zone_import -password password -country countrycode -import filename
  4. Clear existing zone data in production. Perform this step if zone data already exists for the country whose data you intend to load.
    • zone_import -password password [-country countrycode] -clearproduction
  5. Set the PolicyCenter server run level to MAINTENANCE:
    • system_tools -password password -maintenance
  6. Load zone data from the staging tables into production:
    • table_import -server url -password password -integritycheckandload -zonedataonly
  7. Set the server run level back to MULTIUSER:
    • system_tools -password password -multiuser