Differences

This shows you the differences between two versions of the page.

--- dynamiczip:features:addressing:canadian_postal_code_import [2015/02/26 00:25] – external edit 127.0.0.1
+++ dynamiczip:features:addressing:canadian_postal_code_import [2020/06/09 17:57] – chuck
@@ Line 1: / Line 1: @@
 ====== Importing Canadian Postal Codes ======
-The [[dynamiczip:glossary:rate_and_boundary_database|Rate & Boundary Database]] does not include Canadian Postal Codes. As a result, [[dynamiczip:features:Zip Addressing]] will not work for Canadian Postal Codes unless you find another source for this data.
+The [[dynamiczip:glossary:rate_and_boundary_database|Rate & Boundary Database]] does not include Canadian Postal Codes. As a result, [[dynamiczip:features:Zip Addressing|ZipAddressing]] will not work for Canadian Postal Codes unless you find another source for this data.
-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 Complete which includes multiple city names for each postal code where appropriate.
+The recommended database is their Canada - 6-digit Postal Code Data, Basic Edition. When downloading, select the tab delimited option.
 To import this database into DynamicZip complete the following steps:
-  - Open the [[dynamiczip:windows:DZ Zip Address Import window]]
+  - Open the [[dynamiczip:windows:DZ Zip Address Import window]].
-  - Select Import From Other.
+  - Enter an Import Source name such as ZIPCODEDOWNLOAD.
-  - 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:windows:DZ Zip Address Import Setup window]].
-  - 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:windows:DZ Zip Address Import Setup window]]
+  - Enter a Description such as ZipCodeDownload.com.
-  - Enter a Description such as GreatData.com.
+  - Select a File Type of tab.
-  - Select a File Type of Comma.
+  - Enter 1 for the ZIP Code Position.
+  - Enter 2 for the State Position.
   - Enter 3 for the City Position.
-  - Leave the County Position blank.
+  - Leave the country code position field blank or zero since country code is not in the import file.
-  - Enter 2 for the State Position.
+    - 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:windows:dynamiczip_setup_window|DynamicZip Setup window]]. CA is the standard country code for Canada. Also select the check box next to the field in that window. Save your DynamicZip Setup options prior to importing Canada.
-  - Enter 1 for the ZIP Code Position.
+  - Click Save and close the [[dynamiczip:windows:DZ Zip Address Import Setup window]].
-  - Leave the Country Position blank. Alternately you can modify the import file to include another field containing the value desired for the country Canada.
+  - Select a group of states that includes the Canadian provinces you wish to import addresses for.
-  - Enter 4 for the Geocode Position. The combination of ZIP Code and Geocode create a unique key for the [[dynamiczip:tables:DZ Zip Address table]] By importing the Great Data sequence number value into the Geocode field, multiple cities can be imported that share a single Postal Code.
+  - Set the Report Level to Warning.
-  - Click Save and close the [[dynamiczip:windows:DZ Zip Address Import Setup window]]
+  - Select the checkbox to Automatically generate missing FIPS.
-  - Select Import on the [[dynamiczip:windows:DZ Zip Address Import window]]
+  - Select the checkbox to flag FIPS: Do not purge.
+  - Select the SQL Optimize checkbox.
+  - Select Import on the [[dynamiczip:windows:DZ Zip Address Import window]].
 If you are subject to tax in some provinces but not in all, please see [[dynamiczip:glossary:statewide_tax_schedule|Statewide Schedules]] for more information.
@@ Line 29: / Line 32: @@
 [[dynamiczip:Checklists]]
-\\