CEDEN Data Checker Troubleshooting

Tips and Resources

• It is recommended that the Excel file that is being checked be closed while being checked.
• Definitions of each field are contained in the guidance document for the respective data category. These documents also specify whether a field requires controlled vocabulary and the names of the relevant lookup lists.
• The controlled vocabulary lookup lists can be accessed on the Lookup Lists page.

Troubleshooting Errors

• The error "[column heading] not found in [specified]Lookup table" (for example "DigestExtractMethod not found in DigestExtractLookUp table" or "Datum not found in VariableCodesLookUp table" means that a value used in the file is not on the LookUp List. To request new values, complete the Vocabulary Request Template
• Each reference to an unknown value will return an error. If you reference the same value (or values, in the case of constituents), this can make it difficult to identify the unique values that need to be requested through the new Vocabulary Request Template. Excel can remove your duplicates in the file of errors that is emailed to you.
• While on the "Errors" tab, select "Remove Duplicates" on the "Data" tab of Excel. Then specify to base the duplicates on the "Values" column.
• If your collection time is not five characters and in a text format, you will receive the error "Collection Time is not correct. It can not be blank and must be a text field in the format hh:mm not a date field." It can be challenging to get your times in the correct format. One way to do this is to:
  1. Highlight the columns of times in the worksheet;
  2. Copy the highlighted cells;
  3. Paste into a new Notepad file;
  4. Insert a new column next to the existing "Collection Time" column in your Excel file;
  5. Copy the "CollectionTime" heading and paste it into the header of the new column;
  6. Change the new column format to "text";
  7. Copy the times from the Notepad file;
  8. Paste the times into the new column using the "paste as values" option; and
  9. Delete the original "CollectionTime" column.
• Description of errors messages has been provided in report format. This list is continuously updated.