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

Importing Field and Lab Data (EDDs)

Summary

This guide explains how to import field and laboratory data using Electronic Data Deliverables (EDDs). It covers how to select the correct data type (Field Data vs. Lab Data), the supported EDD formats, how to import through the user interface (UI), and how to read the import status. To submit EDDs by email instead of the UI, see the Uploading EDDs by Email article. Sample points and the required valid values (VVLs) must exist in ENFOS before you import data.

EDD Formats

Field EDD formats:

  • ENFOS Field: A single file used for current and historical data migration.
  • EDMAN (Field Data): An import file for field data typically used with EQuIS.

Laboratory EDD formats:

  • ENFOS EDD: A single file format used for current and historical data migration.
  • EDMAN (No QC): A three-file format whose files are tied together by foreign keys. Includes EDMAN Sample, EDMAN Test Result, and EDMAN Batch.
  • EDMAN (With QC): Contains QC data. A three-file format whose files are tied together by foreign keys. Includes EDMAN Sample, EDMAN Test Result + QC, and EDMAN Batch.
  • EFW EDD: A three-file format whose files are tied together by foreign keys. Includes EFW Field Sample, EFW Lab Test, and EFW Lab Result.

For the multi-file formats (EDMAN No QC, EDMAN With QC, and EFW EDD), the files depend on one another through those foreign keys, so all files in the set must be imported together.

Importing EDDs in the User Interface

  1. Navigate to the site (level 17) or AOC (level 20) in the hierarchy.
  2. Go to Inventory > Scientific Data > Imports.
  3. In the first dropdown, select the type of data you are importing: Field Data for field measurements or EDD for laboratory results.
  4. In the second dropdown, select the specific EDD format that matches your file.
  5. To view the EDD format and download a blank .CSV template, click EDD Format.
    • Note: The EDD format and relevant valid values can also be downloaded.
  6. Populate the .CSV file with your field or lab data.
  7. To load a completed EDD to ENFOS, return to Scientific Data > Imports, select the data type and EDD format from the two dropdown menus, then click Add.
  8. Click Choose File to select your populated file, and click Save to run the import.
  9. Once processed, the imported EDD appears in the import list for the site or AOC.
    • If successful, the EDD will show in Lab status.
    • If there are errors, the EDD will show in Fixup Required status until the errors are addressed the and EDD is rerun.

Common Questions

What is the difference between the "EDD" and "Field Data" options in the dropdown? The EDD option is used for importing laboratory data. The Field Data option is used for importing data collected in the field, such as water levels or field parameters.

Where can I find the correct format for my file? After selecting the data type and format, click the EDD Format button to see a guide with all required columns, data types, and formatting rules for that specific EDD.

How do I know my EDD was imported successfully? A successful EDD moves to Lab status. An EDD in Fixup Required status contains errors and has not been loaded.

Can I overwrite an EDD I already submitted? Yes. Importing an EDD with the same file name will prompt ENFOS to overwrite an existing EDD, moving the original file to the Documents section for that EDD's reference ID.

Troubleshooting Tips

  • Import fails or requires fixup: Check the Errors section of the import summary to see precise errors, such as invalid data types or missing required values. Correct the errors in your source file and re-upload. See the Troubleshooting EDD Errors article for detail.
  • Date formats: Excel can revert date formats when files are saved as .CSV. Confirm dates are in MM/dd/yyyy format before importing.
  • Special characters: Save all EDD files in .CSV UTF-8 format to avoid errors caused by special characters.