Welcome to the CEDEN Data Checker. The Checker validates several business rules, such as if the "PrepPreservationName" is "None" then the "PrepPreservationDate" is "01/Jan/1950 00:00" and ensures that where required, only approved controlled vocabulary values are used.
Currently, the CEDEN Data Checker is only accepting Chemistry and Field data templates. If you need to submit other data types, please contact one of the California Regional Data Centers.
To check your Chemistry and Field file, you must provide your name, email address, and file to be checked. Each file must have less than 5,000 rows of data (maximum number of results per file is 4,999).
The Checker will process your file and return a summary of results (a table of errors and a table of warnings with a count of each error or warning type). You can then click "View Results" to see the Excel row number and value that is causing each error/warning instance. You will also receive an email with an Excel file attached that contains a list of errors and warnings.
Address the errors and warnings that are appropriate to address by making changes to your original Excel file. Often, errors are caused by using unapproved vocabulary. See the Standard Names and Codes page to check for existing values or to request to add new values to CEDEN.
You may check your file as many times as you would like. Once the errors have been resolved, you will have the option of submitting your data so that it can be added to CEDEN.
Once submitted, the data are uploaded to the CEDEN Augmentation ‒ Field & Lab Chemistry Data website within three (3) months.