Versions Compared

Key

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

DMR XML Upload

The DMR XML Upload  screen  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 confirm to the XML schema. The System uses the same XML schema as the predecessor system, E2conform to the XML schema. The XML schema can be found here. You can either built 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  titled XML Format   below for more information

The screen has two steps:

  1. Select and Validate File to Upload

  2. Review Validations and Save to Draft DMR

Step 1: Select and Validate File to Upload

  1. Browse for the XML file to upload.

  2. Click

...

  1. the Validate

...

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

Code Block
eDMR/Submission/Facility/Report/ReportIdentification/PermitNumber

The permit to which the submission relates

Code Block
eDMR/Submission/Facility/Report/ReportIdentification/ReportStartDate and ReportEndDate

The first and last day of the reporting period to which the submission relates

Code Block
eDMR/Submission/Facility/Report/ReportIdentification/
MonitoringLocationGroup and
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

Code Block
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.

Code Block
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.

Code Block
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.

Code Block
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  the  eDMR/Submission/Facility/Report/ReportIdentification/MonitoringLocationGroup/MonitoringData/SummaryofMonitoringResult  block  block. Each reported value must be contained within the  the  SummaryofMonitoringResult  block  block containing two child elements; a  PermitRequirementforSummary  element  element containing the limit to which the DMR value relates, and a  SummaryResult  block  block containing the reported DMR summary value. The  The  PermitRequirementforSummary  block  block is used by the System to identify the limit to which the reported value relates. The  The  SummaryResult  block  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

Code Block
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.

Code Block
PermitRequirementforSummary/LimitValue

The permit limit. If not a numeric value, it can be either "(Report)" or "(Optional").

Code Block
PermitRequirementforSummary/LimitUnit

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

Code Block
SummaryResult/MeasurementQualifier

Less than or greater than sign, if applicable for the reported DMR value.

Code Block
SummaryResult/MeasurementValue

The reported DMR value ("0.00004", or "*T" if a no discharge code is applicable).

Code Block
SummaryResult/ResultComment/Comments

A text comment related to the reported value.

Daily DMR Values

Daily DMR limits and values are located within the  the  eDMR/Submission/Facility/Report/ReportIdentification/MonitoringLocationGroup/MonitoringData/IndividualMonitoringResult  block  block.
Each reported value must be contained within the  the  IndividualMonitoringResult  block  block containing two child elements; a  PermitRequirementforIndividual  element  element containing the limit to which the DMR value relates, and a  IndividualResult  block  block containing the reported DMR daily value. The  The  PermitRequirementforIndividual  block  block is used by the System to identify the limit to which the reported value relates. The  The  IndividualMonitoringResult  block  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

Code Block
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.

Code Block
PermitRequirementforIndividual/LimitValue

The permit limit. If not a numeric value, it can be either "(Report)" or "(Optional").

Code Block
PermitRequirementforIndividual/LimitValue

The permit limit. If not a numeric value, it can be either "(Report)" or "(Optional").

Code Block
PermitRequirementforIndividual/LimitUnit
 The

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

Code Block
IndividualResult/MeasurementQualifier

Less than or greater than sign, if applicable for the reported DMR value.

Code Block
IndividualResult/MeasurementValue

The reported DMR value ("0.00004", or "*T" if a no discharge code is applicable).

Code Block
IndividualResult/MonitoringStartDate

The date when the Daily DMR value sample was taken.

Code Block
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.

Code Block
<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>&lt;</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>