If a record can't be added because Import and Validate detects that it contains one or more fields with data that don't satisfy the constraints set for the fields of the destination table, then Add Record will fail. If you specified Progress Fields in the Source table during the Import Setup, then you will be able to track failed records.
You can move to [Input] tab to find the Source records that failed. If the WhenProcessed field is not empty, this indicates the record has been processed. If the ProcessedOK field contains 0 or OK, the record was processed successfully. If it contains a numeric value or error text, then you will have to fix the value in the the appropriate field(s).
After having fixed the failed records, you will have to try again to import. If there are just a few fixes you can remember easily, and the dataset , then you can go to the [Import] tab, move to each record and press [Process Record].
f your Source table contains many records, then do the following
SELECT * FROM MyTable WHERE WhenProcessed Is Null;
4. If you go back [Input] tab you will see only a part of the original table's records show up: the ones which have an empty WhenProcessed field.
5. Switch to the [Import] tab and start processing.
|Tutorials on how to work with Import and Validate|