System Administrator users can import a list of areas from a file in CSV format. You need to use the correct field names for the import process to create new areas it finds in the file. Existing areas are not changed.

This import process creates a new area for each Area Name that doesn’t already exist. Alternatively it can identify new areas by using the Area Code values.

Field Names

Fields can be added in any order to the csv file but must use the defined names below.

Field values can be blank except where noted. Extra fields in the file will be ignored.

Field Name

Comments

Required?

Area Name

Cannot be blank.

This is the name of the area/district/riding/county.

Short Name

Optional.

A shorter version of the name. Example: use MA for Massachusetts.

Area Code

Optional - unless used as the identifier when importing

This is a string of characters or numbers.

Examples include: riding numbers, FIPS codes, etc.

(if used for identification during import)

Where do I find this feature?

It is found in the Elections - Customize module. It is below the grid list of areas in the Areas tab.

note

Import Areas feature first implemented in build 12.2.2.2

Import Areas feature first implemented in build 12.2.2.2

What does the Import Module look like?

This is an example of the Import Areas module in Flow.

Where did my imported Areas go?

If you don’t see the imported areas in the grid above the import tool - the grid may be filtered by an election event. To change this select the blank election event option in the dropdown list near the top right of the grid. This option shows you new areas that are not yet used in a specific election event.

Who Can Access This?

Currently only users in the Global content group with a System Admin security level can use this feature.

Available Data Sets

We have a number of data sets available for you to download and use to import that are already using the correct format. If you are creating your own CSV file to import these may be helpful as a sample to confirm file formatting.

U.S. Data

50 States plus 5 other areas with FIPS codes:

3,232 U.S. county names with FIPS codes:

3,232 U.S. county names with state name prefix and FIPS codes:

3,232 U.S. county names with state name suffix and FIPS codes:

Canadian Data

English

338 Federal Ridings sorted by Name:

Français

338 Federal Ridings sorted by Name: