To upload or enter flow data into Mapistry, scroll down to the Records Section, located at the bottom of your site's Mapistry dashboard, select "Water: Flow Log", click on the three dots on the right, and select "Upload Flow Logs". You can then upload a file with your flow log data, or enter it manually in the template provided
The general process and mechanism to upload Flow Log data is similar to the Sampling Results Upload process.
Either click on "Upload data from file" to navigate to the file from the locations on your computer or simply drag and drop the file you want to upload into this view.
Confirm the name of the sheet for the lab data you want to upload and then click continue
When prompted, confirm if your file has header rows
Match the fields (columns) from your file to the Mapistry Database Fields, use "ignore this column" if the data is not one of the required fields (marked with * below). At this stage, any changes made to the Match will persist through future uploads. It is not necessary to click the Confirm Mapping button. The following is a list of the Mapistry Database fields you may match your columns to
- Date of Discharge *
- Discharge Location * (tied to the monitoring locations set in your site map)
- Person reporting discharge *
- Volume (gallons) (required if Rate of discharge is not provided)
- Hours of discharge (if no number provided, 24 hours is assumed)
- Rate of discharge (required if Volume is not provided)
- Rate of discharge units (required if Rate of discharge is provided)
Note: you may enter values either as a volume (Volume) or flow (Rate of discharge) - specify the appropriate units in the corresponding field
For the following categories match the row names to the Mapistry Database Name, (note, the program will remember previous matches, making each future match faster and easier).
- Discharge Location
- Rate of discharge units
TIP- type in the match field to search the list
Update any wrongly mapped items to the correct match
Once everything is matched appropriately, click "Review" in the bottom left corner
Reviewing the Data
At this stage, any changes to the matching are temporal and will be applied only to that individual line item in that individual upload. To improve bulk matching for future uploads, use the back button and follow the matching sequence above to match everything correctly.
Use the "Only show rows with problems" or "Show modifications" toggles at the top to narrow down the data you need to review/correct, if needed.
Tip: Hovering over a red cell will display help text to let you know what the error is/how to correct it
You can also hover over fields with an information (i) icon for more information
If everything looks good, select continue. You will be asked if you are ready to submit if so, click YES otherwise, click No to return to the editor. Any rows with errors (red cells) remaining after your review will be excluded from the upload.
Once submitted, a message will confirm the data has been uploaded
Flow Log Data Manual Entry Option
You may also enter flow log data manually in the template provided once you navigate to "Water: Flow Log", click on the three dots on the right, and select "Upload Flow Logs". Below the upload file option, you'll see a table interface with a template where you can manually enter the data you wish to upload.
Data validation for the fields in this option are the same as described in the Upload option above. Remember, flow can be entered as volume or rate for the corresponding date. Both volume and rate cannot be entered for the same date. If entering volume, the hours of discharge will be assumed to be 24-hr unless a specific duration is provided. Press click continue after you have entered the flow data and follow the instructions on the screen, similar to the last steps of the Uplaod Option above to submit the data.
End of Article
If you have any questions regarding the Water Suite or need further assistance, please e-mail email@example.com or call (800) 553-7420 ext. 1.