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

Postal codes - write corrected

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 Tools^TMto 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.