Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

DMR XML Upload

The DMR XML Upload  screen allows the user to upload a DMR XML file that contains sampling data for a single reporting period. After a valid file is uploaded, the data is inserted into the draft DMR. The user can then edit and correct the data if needed using the regular DMR data entry screens, review errors and violations that will be generated upon submission, and submit the DMR.

...

If the Save to Draft DMR button becomes available, at least one DMR measurement was mapped successfully and you can proceed. If none of the data could be mapped, the button will not become available. Review the errors, adjust the XML file, and try again. Use the information below to help identify mapping errors. 

XML Format

The best approach for developing the XML file format for upload is to begin by downloading a XML DMR requirements file from the DMR List screen. Then use the instructions below to determine the best way to populate the file with the DMR values. Many of the values in the XML file are not used and can be omitted. See the link to the XML schema at the top of this page.

The system uses the following XML elements to populate the DMR:

Permit and Report Identification Elements

XML Element PathElement Description
eDMR/Submission/Facility/Report/ReportIdentification/PermitNumber
The permit to which the submission relates
eDMR/Submission/Facility/Report/ReportIdentification/ReportStartDate and ReportEndDate
The first and last day of the reporting period to which the submission relates
eDMR/Submission/Facility/Report/ReportIdentification/MonitoringLocationGroup and monitoringLocationName attribute
the Monitoring Point or Limit Set Name (e.g. 001A, 002B)

...

XML Element PathElement Description
PermitRequirementforIndividual/StatisticalBaseCode
The statistical base code for the limit such as "Maximum Daily". The text must match exactly with the statistical base code description associated with the reporting requirement in the System.
PermitRequirementforIndividual/LimitValue
The permit limit. If not a numeric value, it can be either "(Report)" or "(Optional").
PermitRequirementforIndividual/LimitValue
The permit limit. If not a numeric value, it can be either "(Report)" or "(Optional").
PermitRequirementforIndividual/LimitUnit

 The unit related to the permit limit (e.g. "mg/L", "MGD").

IndividualResult/MeasurementQualifier
Less than or greater than sign, if applicable for the reported DMR value.
IndividualResult/MeasurementValue
The reported DMR value ("0.00004", or "*T" if a no discharge code is applicable).
IndividualResult/MonitoringStartDate
The date when the Daily DMR value sample was taken.
IndividualResult/ResultComment/Comments
A text comment related to the reported value.

Example XML File

The following example shows a valid XML file containing one Summary and one Daily result. The portions highlighted in Bold Red would be inserted by the reporter to indicate the DMR values to insert into the DMR daily and summary forms.

...