Here's the format and conditions when importing tank monitor readings:
| Expand |
|---|
| title | Wesroc CSV File Format |
|---|
|
| Import Fields | Description | Example Values |
|---|
| customerid | Customer ID | 550 | | base_id_ti | N/A | 23800000 | | tx_num_ti | N/A | 1 | | rpt_date_ti | Reading Date and Time | 6/26/2019 | | ts_cat_1 | Customer Number | 0000000020 | | ts_cat_2 | N/A | 10 | | ts_cat_3 | N/A | 10 | | ts_cat_4 | N/A | 10 | | tk_level | Percent Left | 50 | | tk_w_dau | N/A | 0.1 | | tx_serialnum | Tank Monitor Serial Number | tank01 | | baseserialno | N/A | 27327 | | base_temp | Inside Temperature | 65 | | ta_ltankcrit | T or F (true or false). Automatic site order will be created when this is set to True. | T | | tx_nosensor | No Sensor | F | | tx_lnoxmit | No Transmit | F | | ts_location | N/A | 0001-Fort Wayne | | ts_access | N/A | LPG | | ts_tankserialnum | Tank Serial Number | tank01 | | ts_capacity | Tank Capacity | 1000 | | address_bi | Address | 1611 Plummer Street | | city_bi | City | Los Angeles | | state_bi | State | CA |
|
...