This is the online manual of GRCTools, personal name and address management software.  Click here for details.




Postal codes - write corrected

GRCTools manual | Index

Purpose: to assign to the user-defined data file any corrected postal codes that the user has written to the filePddmmyyX.dbf, created when running Check postal code validity. This process should not be run unless Check postal code validity has already been run on the same file, and corrections made to the PddmmyyX.dbf file

The process Assess postal code validity creates a database containing postal codes which are considered by GRC ToolsTMto be, in some way, invalid. This file contains 2 empty fields: corr_pc and corr_coun. In corr_pc you can add a corrected value for the postal code, and in corr_coun a corrected value for the country code, in this way:

id field_name postal code country message corr_pc corr_coun company address address_2 city
19 testfile.pc 790231 France Postal code must be 5 digits long 79023   ... ... ... ...
38 testfile.pc 99001 France String 99 not allowed in postal code position 1 97001          
47 testfile.pc 1043 France Postal code must be 5 digits long   Belgium        
47 testfile.pc 1043 France Digit 5 in postal code must be NUMERIC   Belgium        
... ... ... ... ...            

If this is done, this process can be run to write the corrected data back to the data file.

Information required: You are required to specify the field in your database containing its unique identification code, or check the Check to use RECORD NUMBERS instead of ID box if this was the method used to create this correction file. You need to specify the name of the PddmmyyX.dbf file which contained the corrections, and also the names of the fields to which to write the corrected postal code and the corrected country code. Note: if you chose to check using record numbers instead of an ID, then you must not have changed the order of the records within the original file before running this process, otherwise the corrected data will be written back to the wrong record.