dynamiczip:features:addressing:canadian_postal_code_import
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
dynamiczip:features:addressing:canadian_postal_code_import [2015/05/18 22:29] – conni | dynamiczip:features:addressing:canadian_postal_code_import [2020/06/09 18:03] (current) – chuck | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Importing Canadian Postal Codes ====== | ====== Importing Canadian Postal Codes ====== | ||
- | The [[dynamiczip: | + | The [[dynamiczip: |
- | One source of Canadian Postal Codes is [[http://www.greatdata.com|GreatData.com]]. The following are instructions regarding the use of this data. | + | One source of Canadian Postal Codes is [[https://zipcodedownload.com/]]. The following are instructions regarding the use of this data. |
- | The recommended database is their Canada | + | The recommended database is their Canada |
To import this database into DynamicZip complete the following steps: | To import this database into DynamicZip complete the following steps: | ||
- Open the [[dynamiczip: | - Open the [[dynamiczip: | ||
- | - Select | + | - Enter an Import |
- | - Enter a name, such as GREAT DATA, into the Import Source field. | + | |
- When you tab off the Import Source field you will be asked if you want to add this import source. Select Add to open the [[dynamiczip: | - When you tab off the Import Source field you will be asked if you want to add this import source. Select Add to open the [[dynamiczip: | ||
- | - Enter a Description such as GreatData.com. | + | - Enter a Description such as ZipCodeDownload.com. |
- | - Select a File Type of Comma. | + | - Select a File Type of tab. |
- | - Enter 3 for the City Position. | + | |
- | - Leave the County Position blank. | + | |
- | - Enter 2 for the State Position. | + | |
- Enter 1 for the ZIP Code Position. | - Enter 1 for the ZIP Code Position. | ||
- | - Leave the Country | + | - Enter 2 for the City Position. |
- | - Enter 4 for the Geocode | + | - Enter 3 for the State Position. |
+ | - Leave the country code position field blank/zero since country code is not in the import file. | ||
+ | - If you want a country code for your Canada addresses, enter the desired code in the Country Code Default for Canada field in the [[dynamiczip: | ||
- Click Save and close the [[dynamiczip: | - Click Save and close the [[dynamiczip: | ||
- | - Select | + | - Select |
+ | - Set the Report Level to Warning. | ||
+ | - Select the checkbox to Automatically generate missing FIPS. | ||
+ | - Select the checkbox to flag FIPS: Do not purge. | ||
+ | - Select the SQL Optimize checkbox. | ||
+ | - Select | ||
If you are subject to tax in some provinces but not in all, please see [[dynamiczip: | If you are subject to tax in some provinces but not in all, please see [[dynamiczip: | ||
Line 29: | Line 32: | ||
[[dynamiczip: | [[dynamiczip: | ||
- | |||
- | |||
- | \\ | ||
dynamiczip/features/addressing/canadian_postal_code_import.1431988183.txt.gz · Last modified: 2015/05/18 22:29 by conni