Data File Upload Procedures

Data File Uploads Procedures

Overview

When the submit button on the eMOR workbook is pressed, two data files are created. These data files are saved in the Data_File_Uploads folder (subfolder of eMOR folder) and are to be uploaded, one each, into two different databases.

The first file to be uploaded is the PWSS data file which contains each individual piece of data that has been entered into the eMOR workbook. This file is to be uploaded into the PWSS database. For this you will log in with your NCID user name and password.
The second file to upload is the Lab-to-State data file. This file contains summary data such as the max turbidity, minimum entry point residual disinfectant, number of samples, etc. This file is to be uploaded into the Lab-to-State database from which our compliance routines will be run. This is where you will log in using the Lab-to-State user name and password and, ultimately, certify the data is correct using the Lab-to-State pin.

PWSS Upload Procedure

1. 
   With an active internet connection, the workbook will automatically launch the NCDENR website for logging into the Public Water Supply Section Data File Uploads application. Once there, log in using your NCID user name for account and your NCID password.
   

2. 
   Next, enter the PWSID for your system without dashes. For example, you could enter NC0464010, or nc0464010, or 0464010, but not 04-64-010.
   

3. 
   Select the appropriate facility from the drop down menu.
   

4. 
   Browse to the file to be uploaded. This file will be found in the Data_File_Uploads folder (subfolder of eMOR) and the name will begin with “PWSS”, corresponding to the PWSS database to which it is to be uploaded.
   

5. 
   Once the PWSID and the upload file name have been entered via browsing, press the Upload File button.
   

6. 
   Next, you will receive the status of the upload. You should save a copy of this page, either hard copy or electronic, and then, in most cases, proceed to Lab-to-State, the second database, by pressing the Yes button.
   

Lab-to-State Upload Procedure

1. 
   Log in using your Lab-to-State user name and password.
   

2. 
   After logging in, you will be directed to the Home/Job Listing page, where you can see a list of all previously uploaded files. Here you should select Upload and Validate link located on the left of the page.
   

3. 
   Select CSV-File from the file format drop down menu. This is critical. The file will not upload if CSV-File is not selected.
   

4. 
   Browse to the Lab-to-State file to be uploaded. Once again, this file will be found in the Data_File_Uploads folder (subfolder of eMOR) and the name will begin with “LabToState”.
   

5. 
   Once you have selected CSV-File as the File Format and selected the appropriate file to upload, press the OK (or Process) button. Note, there is no need to provide a notification email address unless there is a secondary address that you would like to receive the confirmation email.
   

6. 
   At this point, you will receive a status notification pertaining to the job generation as shown below. This does not mean that the files have been uploaded to the database yet. Before this can happen, you should review the information and certify that the information is correct. Only then should the file be uploaded. To complete the process, select the Home/Job Listing link located on the left of the page.
   

7. 
   Select the specific job that you are going to review and certify, usually, the first one in the list.
   

8. 
   Right click on the View Report link located on the left of the page and choose “Open in New Tab”. This will allow you to review the generation report without leaving the main site.
   

9. 
   The record count will vary depending on the plant configuration and operation. You are only concerned with error counts. If you have no error counts, close this tab and proceed to Step 10. If there are error counts, close this tab and go back to the Home/Job Listing page and begin at step 2 again. If there are still error counts, notify the Surface Water Rule Manager. Please note the record count will vary depending upon the plant configuration and operation.
   

10. 
    From the Job Detail page, right click on the MDBP Summary XML - View link located on the left of the page and choose “Open in New Tab”. This will allow you to review the summary report without leaving the main site.
    

11. 
    The summary report is where you are to review the data and verify that the information submitted is correct. The number of summaries depends on the plant configuration and operation. Once satisfied that the data contained in the summary is correct and consistent with what was contained in the eMOR workbook, close this tab and return to the Job Detail page.
    

12. 
    If you are ready to certify the data (i.e. sign the report), check the box that says, “I agree”, enter your Lab-to-State pin, and press the Submit Files button.
    

13. 
    At this point, you will see messaging indicating the status of the submittal.
    

14. 
    This completes the file upload procedure. As a result of this process, you will receive a total of three emails indicating the status of upload. The first email will be received after Step 6 which will provide the job generation status.
    

You will receive another email after Step 11 indicating that status of the file certification and submittal.

Finally, you will receive one more email on the day following the submittal indicating the status of each record submitted. Each record will fall into one of three categories, “accepted”, “rejected”, or “changed”. Only records that are in the “rejected” category require any follow-up action, that being notifying the Surface Water Rule Manager.