EDD Data File

<< Click to Display Table of Contents >>

EDD Data File

The EDD (Electronic Data Deliverable) Data File is the file that contains the data to be checked by EDP. It may be a .txt or .csv file; alternatively, complete Microsoft Excel .xls files may also be loaded. Data files can come from a variety of sources, for example, a laboratory, a data provider or a remote sampling device.


Opening an EDD Data File


Open EDP by clicking the EDP button edp_icon (located in the Import group of the Home ribbon). Load an EDP Format file by selecting the Format button EDP_Format_icon located in the Open group of the Home ribbon. To open a data file, click the EDD button EDP_EDD_icon located in the Open group of the Home ribbon.


When multiple sections exist within a given Format, the data file selected is loaded into the currently selected section. For example, in the EFWEDD (4-File) Format, the format EFW2FSample is the first format listed. A data file selected through EDD will be loaded into this format, regardless of whether it is appropriate for the format or not.


An alternate method of opening a data file is to right-click the desired section name in the left Item pane and select "Load Data File."




Opening and Appending a Data File


To append a new data file to an existing data file already loaded into EDP, right-click the appropriate section name in the left Item pane and select Load and Append Data file.


Loading Microsoft Excel (.xls) Data


In many instances, particularly for field data or any other data that may be manually entered, data is often entered into a Microsoft Excel spreadsheet.




Rather than requiring each individual worksheet to be saved as a text file or csv file, the entire spreadsheet (.xls) may be loaded into EDP. Workbooks that contain multiple worksheets with names reflecting individual section names (e.g., EFW2LabSMP}) will be loaded into the corresponding section(s). Other worksheets in the workbook will be ignored. It is imperative to properly name the worksheets so that the data is uploaded into the correct section.


Loading .zip Files


In addition to .txt, .csv, and .xls files, EDP can open .zip files. By default, EDP uses the following logic to import files from a .zip file:

Process each file in the .zip (or worksheet in the .xls).

Process each section in the format (i.e., LOC, SMP, TST, etc).

If the file/worksheet name contains the section name, then load that file/worksheet into that section.


Clearing a Format

All data rows may be cleared from any format by right-clicking on the format name in the left Item page and selecting Clear Table. All data from all sections can be cleared by clicking the Clear button EDP_Clear_Data_icon located in the Data group on the Home tab.


Data Checking


Data checking is a background process that occurs while the data file is being loaded. This simplifies the data checking process; all that is required is to load a data file. After loading, quality of the data based on the checking defined in the Format file is instantly available.