Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

District Import Criteria

Please use the template spreadsheet containing  template spreadsheet containing the fields in the proper format (listed in the table below).  If you are not using the template spreadsheet and are creating a spreadsheet of your own, the field names on the spreadsheet must exactly match the Field names listed below.  The field names are case sensitive and must be entered exactly as shown below making sure to include the spaces between words.  Please note, the fields specified below as "Required field" are the only fields that must appear in the spreadsheet.  All other fields are optional.  

Field   

Format

Definition

IRN

Numeric

The district's IRN number. 
NAMEMaximum length is ?? characters. No maximum number of charactersDistrict name

STREET1

Maximum
length is ?? characters.No maximum number of charactersDistrict's street address 
STREET2Maximum length is ?? characters.No maximum number of charactersDistrict's second address line
CITY

Maximum length is ?? characters.Alphanumeric Characters

Identifies District's city
STATE

Maximum length is ?? characters.Two character abbreviation

Identifies district's state
ZIP_CODE

Numeric

Identifies district's zip code
PHONE_NUMBER(XXX)XXX-XXXX Numeric without dashes

Identifies district's phone number.

USAS_URL

https://districtUSASURL

District's USAS URL
USPS_URL

https://districtUSPSURL

District's USPS URL 

...