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.
The XML file must conform to the XML schema. The system uses the same XML schema as the predecessor system, E2. The XML schema can be found here. You can either build the XML file using your own software or you can download the XML requirements for a given DMR from the DMR List page and add the result values to the XML file. See the section titled XML Format below for more information
The screen has two steps:
- Select and Validate File to Upload
- Review Validations and Save to Draft DMR
Step 1: Select and Validate File to Upload
- Browse for the XML file to upload.
- Click the Validate button to upload the file and view validation errors, warnings, and messages.
Step 2: Review validations and Save to Draft 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 Path | Element 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) |
Daily and Summary DMR Value Elements
| XML Element Path | Element Description |
|---|---|
eDMR/Submission/Facility/Report/ReportIdentification/MonitoringLocationGroup/ParameterIdentification/ParameterCode | The five character parameter code used to uniquely identify a different constituent to be measured and reported. (e.g. 50050 = flow). If this value is omitted from the XML file, the System will attempt to look up the parameter code based on the ParameterName provided in the following XML element. |
eDMR/Submission/Facility/Report/ReportIdentification/MonitoringLocationGroup/ParameterIdentification/ParameterName | the name of the parameter that identifies the constituent to be measured and reported. (e.g. Flow, CBOD5, etc.). This value can be omitted from the XML file if a valid parameter code is provided in the previous ParameterCode element. |
eDMR/Submission/Facility/Report/ReportIdentification/MonitoringLocationGroup/ParameterIdentification/PCSLocationCode | The unique identifier indicating the location where the sample is taken (e.g. 1 = Final Effluent, G = Influent). If this value is omitted from the XML file, the System will attempt to look up the monitoring location code based on the MonitoringSiteDescription provided in the following XML element. |
eDMR/Submission/Facility/Report/ReportIdentification/MonitoringLocationGroup/ParameterIdentification/MonitoringSiteDescription | The name of the location where the sample is taken (Final Effluent, Influent). This value can be omitted from the XML file if a valid monitoring location code is provided in the previous PCSLocationCode element. |
Summary DMR Values
Summary DMR limits and values are located within the eDMR/Submission/Facility/Report/ReportIdentification/MonitoringLocationGroup/MonitoringData/SummaryofMonitoringResult block. Each reported value must be contained within the SummaryofMonitoringResult block containing two child elements; a PermitRequirementforSummary element containing the limit to which the DMR value relates, and a SummaryResult block containing the reported DMR summary value. The PermitRequirementforSummary block is used by the System to identify the limit to which the reported value relates. The SummaryResult block contains the values to be extracted from the XML file and inserted into the DMR summary form.
The following elements are relative to the SummaryofMonitoringResult parent element.
| XML Element Path | Element Description |
|---|---|
PermitRequirementforSummary/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. |
PermitRequirementforSummary/LimitValue | The permit limit. If not a numeric value, it can be either "(Report)" or "(Optional"). |
PermitRequirementforSummary/LimitUnit | The unit related to the permit limit (e.g. "mg/L", "MGD"). |
SummaryResult/MeasurementQualifier | Less than or greater than sign, if applicable for the reported DMR value. |
SummaryResult/MeasurementValue | The reported DMR value ("0.00004", or "*T" if a no discharge code is applicable). |
SummaryResult/ResultComment/Comments | A text comment related to the reported value. |
Daily DMR Values
Daily DMR limits and values are located within the eDMR/Submission/Facility/Report/ReportIdentification/MonitoringLocationGroup/MonitoringData/IndividualMonitoringResult block.
Each reported value must be contained within the IndividualMonitoringResult block containing two child elements; a PermitRequirementforIndividual element containing the limit to which the DMR value relates, and a IndividualResult block containing the reported DMR daily value. The PermitRequirementforIndividual block is used by the System to identify the limit to which the reported value relates. The IndividualMonitoringResult block contains the values to be extracted from the XML file and inserted into the DMR daily form.
The following elements are relative to the IndividualMonitoringResult parent element.
| XML Element Path | Element 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.
The values in bold black font indicate the data used by the System to identify the permit, reporting period, monitoring location, and parameter to which the values relate. These values are inserted automatically when XML is downloaded for a given DMR.
<eDMR xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="C:\Users\bgeake\Desktop\MiWaters-working\limits_and_DMRs\dmr_miwaters_v1.xsd">
<MetaData/>
<Receiver/>
<Sender>
<SenderName/>
</Sender>
<Submission submissionFileCreatedDate="2015-10-26" submissionID="-3984139229078496857">
<Facility>
<FacilityIdentification stateFacilityIdentifier="8513184271826325334" stateFacilitySystemAcronymName="MiWaters">
<FacilitySite>
<FacilitySiteName>Dundee WWTP</FacilitySiteName>
</FacilitySite>
<LocationAddress>
<LocationAddressText>596 Main Street</LocationAddressText>
<LocalityName>Dundee</LocalityName>
<CountyName>Monroe</CountyName>
<StateName>MI</StateName>
<CountryName>United States</CountryName>
<LocationZIPCode>48131</LocationZIPCode>
</LocationAddress>
</FacilityIdentification>
<Report>
<ReportIdentification>
<PermitNumber>MI0020401</PermitNumber>
<PermitteeName>Village of Dundee</PermitteeName>
<ReportStartDate>2015-09-01</ReportStartDate>
<ReportEndDate>2015-09-30</ReportEndDate>
</ReportIdentification>
<MonitoringLocationGroup monitoringLocationName="001A">
<LocationGroupIdentification monitoringLocationName="001A">
<StateMonitoringGroupID>001A</StateMonitoringGroupID>
<NoDischargeIndicator/>
</LocationGroupIdentification>
<MonitoringData>
<ParameterIdentification>
<StateMonitoringSiteID>001A</StateMonitoringSiteID>
<MonitoringSiteDescription>001A</MonitoringSiteDescription>
<PCSLocationCode>1</PCSLocationCode>
<ParameterCode>50050</ParameterCode>
<ParameterName>Flow</ParameterName>
<SupplementalParameterName2/>
<SupplementalParameterName3/>
<SupplementalParameterName4/>
<DisplaySequencyNo>10</DisplaySequencyNo>
<PermitSampleFrequency>Daily</PermitSampleFrequency>
<PermitSampleType>Report Total Daily Flow</PermitSampleType>
</ParameterIdentification>
<Laboratory>
<LabCertificationNumber>12345</LabCertificationNumber>
</Laboratory>
<SummaryofMonitoringResult>
<PermitRequirementforSummary>
<StatisticalBaseCode>Maximum Daily</StatisticalBaseCode>
<PCAmountIdentifier>1</PCAmountIdentifier>
<LimitValue>(report)</LimitValue>
<LimitUnit>MGD</LimitUnit>
</PermitRequirementforSummary>
<SummaryResult>
<StatisticalBaseCode/>
<MonitoringStartDate>2015-09-01</MonitoringStartDate>
<MonitoringEndDate>2015-09-30</MonitoringEndDate>
<MeasurementQualifier/>
<MeasurementValue>100</MeasurementValue>
<MeasurementUnit>MGD</MeasurementUnit>
<ExcursionIndicator>3</ExcursionIndicator>
<ActualSampleFrequency/>
<ActualSampleType/>
<PCAmountIdentifier>1</PCAmountIdentifier>
<ResultComment>
<Comments>My Summary Value Comment</Comments>
</ResultComment>
</SummaryResult>
</SummaryofMonitoringResult>
<IndividualMonitoringResult>
<PermitRequirementforIndividual>
<StatisticalBaseCode>Maximum Daily</StatisticalBaseCode>
<PCAmountIdentifier>1</PCAmountIdentifier>
<LimitValue>(report)</LimitValue>
<LimitUnit>MGD</LimitUnit>
</PermitRequirementforIndividual>
<IndividualResult>
<MonitoringStartDate>2015-09-01</MonitoringStartDate>
<MonitoringEndDate>2015-09-01</MonitoringEndDate>
<MeasurementQualifier><</MeasurementQualifier>
<MeasurementValue>3</MeasurementValue>
<MeasurementUnit>MGD</MeasurementUnit>
<ResultComment>
<Comments>My Individual Result Comment</Comments>
</ResultComment>
</IndividualResult>
</IndividualMonitoringResult>
</MonitoringData>
</MonitoringLocationGroup>
</Report>
</Facility>
<Certification>
<CertificationStatement>As the true and sole authorized user of this Personal Identification Number (PIN), I certify under penalty of law that I have personally examined and am familiar with the information submitted herein; and based on my inquiry of those individuals immediately responsible for obtaining the information, I believe the submitted information is true, accurate and complete. I am aware that there are significant penalties for submitting false information including the possibility of fine and imprisonment.</CertificationStatement>
<Certifier/>
<CertifierTitle/>
</Certification>
</Submission>
</eDMR>