EDD Data File
Copyright © 2018 EarthSoft, Inc • Modified: 12 Dec 2018
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 (located in the Import group of the Home tab). Load an EDP Format file by selecting the Format button located in the Open group of the Home tab. To open a data file, click the EDD button located in the Open group of the Home tab.
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 located in the Data group on the Home tab.
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.