The following Here's the format and conditions are needed before when importing tank monitor readings:
...
Expand |
---|
title | Tank Monitor File Format |
---|
|
Import Fields | Description |
---|
customerid | Customer ID | base_id_ti | N/A | tx_num_ti | N/A | rpt_date_ti | Reading Date and Time | ts_cat_1 | Customer Number | ts_cat_2 | N/A | ts_cat_3 | N/A | ts_cat_4 | N/A | tk_level | Percent Left | tk_w_dau | N/A | tx_serialnum | Tank Monitor Serial Number | baseserialno | N/A | base_temp | Inside Temperature | ta_ltankcrit | T or F (true or false) | tx_nosensor | No Sensor | tx_lnoxmit | No Transmit | ts_location | N/A | ts_access | N/A | ts_tankserialnum | Tank Serial Number | ts_capacity | Tank Capacity | address_bi | Address | city_bi | City | state_bi | State |
|
Expand |
---|
title | Tank Monitor Import Conditions |
---|
|
The following conditions should be properly setup for successful import: - 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.
...