Home : Products : Hach WIMS : Hach WIMS Client : Documentation : Main Menu : Design : Spread Reports : eDMR / eReport : Wisconsin eDMR Upload Instructions
Q13084 - HOWTO: Wisconsin eDMR Upload Instructions

Open Internet Explorer and go to http://dnr.wi.gov/topic/switchboard/

Enter your login credentials and click the Login button.  Note:  You must obtain a WAMS UserID and Password from the State.  Click the Request a Wisconsin User ID and Password link to get more information on obtaining a UserID/password. 

After clicking [Login], the following screen will be displayed:

Click on TIMAH WASTEWATER TREATMENT FACILITY on the eDMR row.  Select the Wastewater Discharge Monitoring Long Report for the apporpriate month, then click [Doenload XML File].

 

Click the [Save] button.

 

Browse to the c:\OPS32\EDMR\source folder then click [Save}.  When the file has been downloaded, you will see:

Click [Close] and then either Logout of the DNR's website or minimize the window.  We are done with the website for a while.  Now you need to log in to OPS 32.

Select Spread Reports from the Report Pac menu.  Select the eDMR report, set the dates to the proper month, set "Output To" to eDMR then click [OK].

After clicking [OK] the following screen will appear. 

Click the Browse button, [...], browse to the "c:\OPSSQL\EDMR\Source" folder.

Click on the source file for the appropriated reporting period then click [Open}.  Click [Proceed].

When the process is finished you will see the following message:

Make note of the file name and location of the file you just created.  Click [Close] then close the Spread Report Print window.

Close OPS 32 and return to the DNR Website.

Click [Upload XML File]. Click the [Browse...] button and the Choose File window will be displayed.

Browse to the c;\OPS32\EDMR\Output folder and select the file to be uploaded.  Click [Open] and the next screen will be displayed.

Click [Upload] to upload the file.  When it is finished, the message below will be displayed.

Click [OK].  Your data has now been uploaded to the DNR Website.  And you should see the screen below.  Notice the Status has been updated to "In Progress."

Select the Wastewater Discharge Monitoring Long Report fo rthe appropriate month, then click [Edit Form].

In an email from Gail Mills @ the DNR, the following instructions were given which outline the steps needed to be done to complete the submittal process:

  • click the validate button (the validation process calculates and displays the summary data; daily maximum, monthly average, etc.)
  • compare the summary values to any limits in place and enter the number of violations (hopefully zero) in the boxes to the right of the permit limits
  • enter any comments if that information wasn't already entered by the upload process
  • enter LODs/LOQs/lab certification numbers if that information wasn't already entered by the upload process
  • enter a capital Y in the QC Exceedance row if there were any problems
  • save
  • validate
  • submit
  • print, sign, and mail the Certification sheet to the address listed (should be the same address you have been mailing paper DMRs to)

Once the Certification Shee is received, information is entered in the database, and the file loads that evening.  The an e-mail is sent acknoledging successful submission of the eDMR.

 

After you are done validating your report, a separate window will appear:

You will also see the Certification page displayed.  Click [Print] then complete the form and sign it.  This is the form that needs to be mailed to the DNR as mentiond in the instructions above. 

Click the [Logout] button and you're finished!

 

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 6/28/2010 4:06 PM.
Last Modified on 3/12/2013 8:38 AM.
Last Modified by Scott Dorner.
Article has been viewed 8558 times.
Rated 5 out of 10 based on 4 votes.
Print Article
Email Article