User Tools

Site Tools


dynamiczip:glossary:zip_address_import_source_file

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
dynamiczip:glossary:zip_address_import_source_file [2017/09/12 22:08] connidynamiczip:glossary:zip_address_import_source_file [2018/09/25 22:05] conni
Line 31: Line 31:
   - Save the Excel file. (If you save it as an Excel spreadsheet, you will be able to open it again easily. However you must also save it as a Text file (tab or comma delimited) or as Formatted Text (space delimited) so that you can [[dynamiczip:features:import:Import Zip Addresses|import]] the results.   - Save the Excel file. (If you save it as an Excel spreadsheet, you will be able to open it again easily. However you must also save it as a Text file (tab or comma delimited) or as Formatted Text (space delimited) so that you can [[dynamiczip:features:import:Import Zip Addresses|import]] the results.
  
-When importing from a source other than the Rate & Boundary Database existing but obsolete ZIP Codes are NOT purged from the [[dynamiczip:tables:DZ Zip Address table]] If you want to clean out obsolete ZIP Codes, you will need to do that with a SQL Query. Here is an example SQL Query to use for that purpose:+When importing from a source other than the [[dynamiczip:glossary:zipsales_database|ZIPsales Database]] ZIP.txt file existing but obsolete ZIP Codes are NOT purged from the [[dynamiczip:tables:DZ Zip Address table]] If you want to clean out obsolete ZIP Codes, you will need to do that with a SQL Query. Here is an example SQL Query to use for that purpose:
  
 USE DYNAMICS USE DYNAMICS
Line 55: Line 55:
 WHERE KDGeoCode = '' -- Assuming that you did not import geocodes WHERE KDGeoCode = '' -- Assuming that you did not import geocodes
  
-Even when importing from a source other than the [[dynamiczip:glossary:rate_and_boundary_database|Rate & Boundary Database]] the DynamicZip setup option [[dynamiczip:windows:dz_naming_rules_window|Use Naming Rules for New Cities & Counties]] is effective. You should consider turning this option off while performing the [[dynamiczip:features:import:Import Zip Addresses|Zip Address Import]].+Even when importing from a source other than the [[dynamiczip:glossary:zipsales_database|ZIPsales Database]] ZIP.txt file, the DynamicZip setup option [[dynamiczip:windows:dz_naming_rules_window|Use Naming Rules for New Cities & Counties]]((This feature was discontinued in Build 74)) is effective. You should consider turning this option off while performing the [[dynamiczip:features:import:Import Zip Addresses|Zip Address Import]].
  
 ---- ----
dynamiczip/glossary/zip_address_import_source_file.txt · Last modified: 2018/09/25 22:06 by conni

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki