Electronic Data Deliverable File

<< Click to Display Table of Contents >>

Electronic Data Deliverable File

An Electronic Data Deliverable (EDD) is an electronic, tabular format for sharing, manipulating, and using data. An EDD may be distributed in the format of a Microsoft Excel workbook, Microsoft Access database, ASCII file, CSV file, text (*.txt) file, zip file, and in certain cases, XML file format.

 

EQuIS EDD Conventions

 

An EDD file follows a consistent design meant to organize information in a useful format and typically contains header row(s) that define what each column (field) in the EDD represents and in what format that data should be entered. The column headers in EQuIS EDD tables contain the data field names from the associated EQuIS database Schema. The first row defines the data in each column, and the second row indicates the data type and length. The second row also contains a tool tip with more detail on the column content. Both of these rows start with the "#" sign, which indicates that these are comment rows and do not contain data. These comment header rows will not be uploaded into the EQuIS database and are only in the file to provide context to the user/reader. Thus, some EDDs are created without any header rows (analytical data from laboratories typically does not have header information).

 

To help understand data connections and assist with data population, criteria for certain fields are denoted by the following conventions:

Red and Underlined text indicates a Primary Key field.

Red text indicates a required field.

Blue text indicates a field linked to a Reference table (e.g., look-up or valid value).

 

Example EDDs

 

The example below shows a small portion of an EDD that has two header rows, indicated by the '#' symbol.

 

EDP_EDD_Example2

 

 

Location_v1 EQEDD Format

40091-EDD_Location_v1

 

Open an EDD File

 

Open EDP by clicking the EDP button edp_icon (located in the Import group of the Home ribbon). Load an EQuIS 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."

EDP_Load_data_file

 

Open and Append a Data File

 

The EQuIS EDP Load and Append function allows users to load and append data from multiple EDDs into a single EDD for further use and editing.

1.Launch EDP edp_icon.

2.Select a format file EDP_Format_icon.

3.Load an EDD EDP_EDD_icon.

4.To Load and Append the data, right-click on the section (also referred to as the table).

EDP_Load_data_file2

5.Select Load and Append File Data.

6.Select the file name. The data will load.

7.Export the data to an EDD or to Excel Microsoft_Excel_icon.

 

 

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.