Skip to content
English
  • There are no suggestions because the search field is empty.

Troubleshooting EDD Errors

Summary

This guide explains how to identify and correct errors when an EDD import results in a "Fixup Required" status. It applies to sample point, field, and lab EDD imports, because they all use the same error review process. It walks through how to review the errors, what the common errors mean, and how to resubmit a corrected file.

Note that data results will not appear in ENFOS if an EDD is in Fixup Required status. Data will appear on the Results page when the errors are corrected, and the EDD is in Lab status.

Reviewing the Errors

There are two ways to review the errors.

Option 1: View the full error list.

  1. Click the EDD's reference link (reference ID).
  2. Scroll to the Errors section to see a list of all errors. The table shows the error level, type, line number in the file, column, and a descriptive message.
  3. Download the list for a .CSV output.

Note: A line number of 0 means every line in the EDD has that error.

Option 2: View the data in the fixup screen.

  1. Open the fixup screen. An EDD that goes into Fixup Required opens this screen automatically right after uploading. If you have navigated away, return to it from the EDD's Actions dropdown by selecting View.
  2. Review your data in columns and rows. Error cells are highlighted in red, and warnings are highlighted in orange.
  3. Hover over a red cell to see a tooltip explaining the specific error (e.g., "Invalid Date Type" or "'DTW' is not a Valid Value").
  4. Use the error dropdown to see the types of errors present.

Note: The fixup screen is useful for diagnosing what is wrong, but it does not list the exact errors, and you cannot fix errors in bulk there.

Common Errors

  • Missing required or conditional data: The importer must add the missing data before resubmitting.
  • Invalid value (VVL): A value does not match the accepted list. Requests for additions should go to the Data Administrator, or be added by a user with that access.
  • Invalid date format: Ensure dates are in MM/dd/yyyy format.
  • Duplicate keys: The importer must correct the duplicate entries before resubmitting.
  • Node path is incorrect or does not exist: Confirm that the node path name matches exactly as it appears in ENFOS.
  • Warnings: The error file may include a warning in the Level column (shown in orange). Warnings typically indicate a field has not been mapped to global values in ENFOS and do not affect the success of the EDD import. Only red (required) errors must be fixed before an EDD can move to Lab status.

Correcting and Re-importing

  1. Correct the errors in your source file outside ENFOS. You can check valid values by clicking the link in the EDD Format guide.
  2. Reimport the corrected EDD.
    • Note: When you reimport a file with the same name, ENFOS prompts you to overwrite the existing EDD. Choosing yes updates the data with your corrected file. The original errored file is saved in the Documents section as an audit copy, and the corrected file becomes the file of record.
  3. Once the corrected file imports successfully, the EDD moves out of Fixup Required to Lab status. The EDD history audits the changes over time.

Common Questions

What does "Fixup Required" mean? The system detected errors in your uploaded file and could not process it. The data has not been loaded successfully. You need to correct the errors before it can be accepted and viewed on the Results page.

Where can I find the list of valid values for a field? Navigate to the EDD Format page for your import type. If a field uses a predefined list, there is a "Yes" link in the VVL column. Clicking the link shows all accepted values for that field.

Troubleshooting Tips

  • Node path errors: Confirm the node path name matches exactly what appears in ENFOS, including spacing and characters.
  • Date formats: Excel can revert date formats when files are saved as .CSV. Confirm dates are in MM/dd/yyyy format before resubmitting.
  • Special characters: Save EDD files in .CSV UTF-8 format to avoid errors caused by special characters.