EDD Data File

<< Click to Display Table of Contents >>

EQuIS 7  >>  EDP > EDP Format Files, Open, Data Review, Tools, EDP Professional and EDP Enterprise > Open >

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 tab). Load an EDP Format file by selecting the Format button EDP_Format_icon located in the Open group of the Home tab. To open a data file, click the EDD button EDP_EDD_icon 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."

 

EDP_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.

 

40071-efweddmultifile

 

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.