User Tools

Site Tools


dynamiczip:features:addressing:canadian_postal_code_import

Differences

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

Link to this comparison view

Next revision
Previous revision
dynamiczip:features:addressing:canadian_postal_code_import [2015/02/26 00:25] – external edit 127.0.0.1dynamiczip: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: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: 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 namesuch 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 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 Position blank. Alternately you can modify the import file to include another field containing the value desired for the country Canada+  - Enter 2 for the City Position.  
-  - Enter for the Geocode Position. The combination of ZIP Code and Geocode create 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+  - Enter for the State Position.  
-  - Click Save and close the [[dynamiczip:windows:DZ Zip Address Import Setup window]] +  - Leave the country code position field blank/zero since country code is not in the import file.  
-  - Select Import on the [[dynamiczip:windows:DZ Zip Address Import window]] +    - If you want 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 to direct the import to automatically populate the country code field. Be sure to save your DynamicZip Setup options prior to importing Canada
 +  - Click Save and close the [[dynamiczip:windows:DZ Zip Address Import Setup window]]. 
 +  - Select a group of states that includes the Canadian provinces you wish to import addresses for. 
 +  - Set the Report Level to Warning. 
 +  - Select the checkbox to Automatically generate missing FIPS. 
 +  - Select the checkbox to flag FIPSDo not purge. 
 +  - Select the SQL Optimize checkbox. 
 +  - Select Import and then browse for and select the file being imported (such as "6-digit Basic.txt"). 
  
 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.  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]]  [[dynamiczip:Checklists]] 
  
- 
- 
-\\  
  
dynamiczip/features/addressing/canadian_postal_code_import.1424910352.txt.gz · Last modified: 2015/05/18 22:29 (external edit)

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki