The Import Corrections command lets you import data corrections from an Excel workbook originally generated by Data Questions and revised by your client or colleague. Corrections are merged into the current database, replacing existing values.

It is recommended that you review the Excel workbook before importing corrections. Some things to look for:

• What changes (corrections) did the client make??
• Are there any comments with an implied, but unentered, data correction? For example, the comment "Date of birth should be 1/1/1970" implies that "1/1/1970" should be entered in the date of birth column. If there are any of these, enter the data correction.
• What data questions were not resolved? If there are any, decide how you want to handle these. For instance, you might go back to the client with these questions, or you may decide to ignore them.

ProVal expects you to import corrections into the same database (or a copy of the same database) used to generate the Excel workbook. In particular, it expects that the RecIDs for the records in the spreadsheet have not changed. 

To import the corrections, open the database, click Screen > Import Corrections, and select the Excel workbook file.​ Before saving the corrections to the database, ProVal will confirm how many corrections will be imported and how many will be ignored (e.g., because the correction is already reflected in the database). For details on corrections that were ignored, click the Warning Details button.

You can see the specifics of the imported corrections by reviewing the database's Change History.

Any errors associated with the corrected data will be removed from the database's error log. You can re-run Find Duplicates or Screen Data to verify that errors, in fact, have been resolved.