Constructing a CSV file for import

You can only import data for an entity type that already exists in the Guidewire data model. Each CSV-formatted file you import must have a heading that defines what the file contains and how to interpret it. The following example illustrates a very simple import file:

1: ADDRESS 
2: type,data-set,entityid,addresstype,addressline1,createuser
3: Address,0,ab:1001,home,1253 Paloma Ave.,import_tools
4: Address,0,ab:1002,business,325 S. Lake Ave.,import_tools

The import_tools command distinguishes between two types of information in an import file:

• Heading information
• Data information.

PolicyCenter treats any line that contains the string entityid as a heading.

PolicyCenter considers as data any line:

• Without an entityid string
• With comma delimited values
• With a value in its third comma-delimited field

In the example shown, the import_tools command treats line 2 as a heading and lines 3 – 4 as data. The import_tools command ignores line 1. If the command encounters a data line before a heading line, it returns an error.