Ways to import administrative data

Important: Never attempt to use SQL commands directly to modify the PolicyCenter operational database tables.

It is possible to import administrative data into Guidewire PolicyCenter by using the following mechanisms.

Mechanism

How                    

Description

PolicyCenter

Administration tab

Import and export administrative data files in XML format by using functionality available from the PolicyCenterAdministration tab. The import functionality provides warnings on collisions between incoming data and existing data and provides a mechanism for you to resolve the collisions.

For more information, see:

File import

import_tools

ImportToolsAPI

Use the import_tools command prompt tool to import one or more CSV or XML files containing administrative data. Use this command to import administrative data only. Guidewire does not support using the import_tools command to import other types of data.

It is also possible to use the ImportToolsAPI web service to import one or more XML files containing administrative data.

For more information, see:

File load

import directory

Load data from CSV files contained in the following directory:

configuration > config > import > gen

At initial database upgrade, starting from an empty database, PolicyCenter loads the administrative data contained in the files in this directory. These files include the default activity patterns, non-renewal question templates, and roles and role privileges.

You can add additional files to this directory for load at initial server startup. For details, see About the import directory.

IMPORTANT PolicyCenter loads files from the import > gen directory only if the database is empty, during the database upgrade at initial server start.

File load

Security directory

Load security zone data from file security-zones.xml, contained in the following directory:

    configuration > config > Security

For information on the syntax to use with this XML-formatted file, see Importing security zone data.

IMPORTANT PolicyCenter loads data from file security-zones.xml only if the database is empty, during the database upgrade at initial server start.

Staging tables

table_import

Use the table_import command prompt tool to import administrative data from staging tables into PolicyCenter database tables. For details, see table_import command.

PolicyCenter supports bulk data import from staging tables for loading zone data only.