Laboratory Data Entry System (LDES)

Data Transmittal Format

The Department realizes that facilities and laboratories do not all have the same capability in providing electronic records.  Therefore, there are a number of options for electronic submittal.  They are 1) tab-delimited text file, 2) XML (extensible markup language) format, and 3) web data entry form (public drinking water only).

1. Tab-Delimited text file: The sample, analysis, result, and memo information into a single record for each result. The file includes 1 batch record followed by combined records. This format does not allow samples to be submitted without analyses and results, and only allows for a single memo for each analysis. See the linked spreadsheet (Excel 97)  file for explanations of the fields and file structure. A sample file can be found at this link. This sample file imported in to Excel is also available at this link.
2. XML format: The Department has adopted "eXtended Markup Language" (XML) for data transfer in the future.  In order to use the XML file format, the tags for the markup language have been standardized into a XML schema.


3. Web data entry form: (for public drinking water results only): The web-based data entry form is now available for laboratories to enter public Safe Drinking Water Act samples. Click here for more information on entering these types of sample results directly via the web.

In addition, we have taken a couple of drinking water forms and mapped out on them the field names for both the tab-delimited and XML formats. Open the file forms.pdf to view what data on the form translates to in the electronic files.