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 revisionBoth sides next revision
dynamiczip:glossary:zip_address_import_source_file [2016/09/27 18:22] connidynamiczip:glossary:zip_address_import_source_file [2017/09/12 22:08] 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 [[dynamiczip:glossary:rate_and_boundary_database|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 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:
  
 USE DYNAMICS USE DYNAMICS
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