Manual Update of Zip Codes via Import
Document Actions
New zip codes are occassionally added to areas. The directory product verifies zip codes when creating adherents or before a search, so if a new zip code is searched for, it will not return results. This administrative screen allows a directory administrator to upload new zip codes to the database to keep it up to date.
Notes:
- So far, this functionality only works for US codes.
- You may find the zip code latitude and longitude information in sites such as this.
The import zip codes functionality offers the ability to update the internal zip code list, allowing modifying existent records or adding new ones in the same process.
In the personal bar, click directory setup, later on this page click on Import Zip Codes (in Directory Configuration box), and this would lead you to the zipCodesImportForm page (which can only be used and accessed by admin users). At the bottom there is a link download csv template that will download a file containing a line that must always be the header of the file to import. The fields to import are those in that file (all required).
Description of each field which can be imported:
- ZIP_CODE: US codes must be any string containing five digits and these digits will be the zipCode attribute content (i.e. all non digit characters will be stripped out). If the code does not match the format, the record will be rejected and not imported.
- LONGITUDE: The longitude value for the zip code. It must be a negative value (for US) and if you need to put the number in decimal notation use a dot, not a comma.
- LATITUDE: The same than LONGITUDE, but in this case the value doesn't have to be negative.
General Formatting Rules for csv Files:
Important Note: for csv files, the file to import must use the character code Unicode (UTF-8)
Each zip code to import should be in a line containing the value for each field. Each field must be a string text, and fields must be coma separated.
Executing the import process:
After you have filled in the file to import, put the file's path in the input text box, or click browse and select the file.
Click on "go" button.
The application will display a result page showing the amount of successful records imported and a list of records that did not import. A record will not be imported if any of the fields are not filled in.
