Files for zone data import
Importing zone data into staging tables uses CSV files that contain data. A data file is specific to an individual country or region. Configuration files define the columns that the data files provide.
Zone data files supplied by Guidewire
PolicyCenter provides a collection of zone data files for various localities with small sets of zone data that you can load for development and testing purposes. The zone data files are in the following location in the Project window in Guidewire Studio™.
In the geodata folder, PolicyCenter stores the zone information in country-specific zone-config.xml files, with each file in its own specific country folder. For example, the zone-config.xml file that configures address-related information in Australia is in the following location in the Studio Project window.
Guidewire provides the US-Locations.txt and similar files for testing purposes to support autofill and autocomplete when users enter addresses. This data is provided on an as-is basis regarding data content. The provided zone data files are not complete and might not include recent changes.
Also, the formatting of individual data items in these files might not conform to your internal standards or the standards of third-party vendors that you use. For example, the names of streets and cities are formatted with mixed case letters but your standards may require all upper case letters.
The US-Locations.txt file contains information that does not conform to United States Postal Service (USPS) standards for bulk mailings. You can edit the US-Locations.txt file to conform to your particular address standards, and then import that version of the file.
Zone data configuration files
PolicyCenter provides sample zone data configuration files in subfolders of the following location in the Studio Project window.
These files specify the zone data columns, their order in the CSV data files, and the relationships among the zone data columns. To configure the address fields that you use and the structure of your addresses, edit these configuration files before importing zone data. For example, the configuration file for the US specifies that each line in the CSV data file must use the following format.
postalcode,state,city,countyData that follows the format is shown below.
94114,CA,San Francisco,San FranciscoSee also