The following pre-requisites format and conditions are needed before importing tank monitor readings via Tank Monitor:
Expand |
---|
title | Tank Monitor File Format |
---|
|
Import Fields | Description |
---|
customerid | Customer ID |
customerid ti ti ti ti | Reading Date and Time | ts_cat_ |
1 2 3 4 level dau serialnum baseserialno serialnum | Tank Monitor Serial Number | baseserialno | N/A | base_ |
temp temp | Inside Temperature | ta_ |
ltankcrit ltankcrit | T or F (true or false) | tx_ |
nosensor lnoxmit location access tankserialnum tankserialnum | Tank Serial Number | ts_ |
capacity capacity | Tank Capacity | address_ |
bi bi |
Expand |
---|
title | Tank Monitor Import Conditions |
---|
|
The following conditions should be properly setup: - The Customer – Site combination should be matched. This means that Customer No [ts_cat_1] and Tank Monitor Serial number [tx_serialnum] should exist in Tank Management. If not, Customer[ts_cat_1] and Tank Serial number[ts_serialnum] will be used.
- tx_nosensor and tx_lnoxmit should be equal to False.
- ts_cat_1 should not be Blank.
- rpt_date_ti should not be in Invalid format or Blank
- Tank Monitor rpt_date_ti should not yet exists in event history
- Record with rpt_date_ti to be import should not be earlier than the site's latest Tank Monitor Reading Event
- rpt_date_ti of the records to import should have a corresponding clock reading
|
- On the Menu panel, click the Tank Monitor menu. This will open the Import Wesroc Tank Monitor Reading screen.
- Click Browse button. This will open the Open File screen. Select the CSV file for import.
![](/download/attachments/20316320/image2016-4-21%209%3A57%3A44.png?version=1&modificationDate=1461204069823&api=v2&effects=border-simple,shadow-kn)
- The CSV file should contain the following mappings:
- Enter email address to Exception Reports Emailed To field. This field is required.
...
5. Once the import is successful, this message below will display.
![](/download/attachments/20316320/image2016-4-21%2010%3A40%3A41.png?version=1&modificationDate=1461206646820&api=v2&effects=border-simple,shadow-kn)
Otherwise, this is the message that will display. If import is not successful, an exception report email will be sent to the email address indicated on Exception Reports Emailed To field.
...