All lookup values in an EDD being import MUST have a match in the appropriate lookup table. The most common field causing errors is QC Code however, you may encounter others like the missing Basis code shown below. You may also find multiple missing lookups and/or multiple pages* of problems, especially when importing data from a new lab or project.
After completing the initial steps to import an EDD file, you may see the EDIT IMPORT FILE form with errors or problems listed. If there are errors, they will be in the ImportProblem field on the form below .
In the case above, there is a value for "Basis" in the EDD file being imported that is not in the Basis table. To find the problem code, scroll right in this form until you find the Basis (or your problem) field and determine what the flagged value is. You will need to stop the import, correct the EDD file and try the import again.
If the problem is a missing value in one of the lookup tables, you will have to stop the import and add the missing value. You can add (or edit) the missing/incorrect lookup values from the EDITOR --> Manage Lookups and click on the button for the table with the problem. (You may have to click the Show More. in the MANAGE LOOKUPS form to find the specific lookup table button you need.)
Once all corrections have been made, try the import again.
* WARNING: Check the Access Record Counter in the lower left of the EDIT IMPORT FILE form highlighted above to see if there are additional error pages.