Here's the format and conditions 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
|
...