Note: File to import should include the header and values should be separated by a comma. Example File: Wesroc Sample Import 2.csv Import Fields | Description | Example Values | Importing Conditions/Notes |
---|
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 | - Must be a Valid Date
- rpt_date_ti of the records to import should have a corresponding clock reading
- 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
| ts_cat_1 | Customer Number | 0000000020 | Required - Used to Match to Tank Management Site | 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 | 1st Priority Used to Match to Tank Management Site > Tank Monitor Device - Customer No [ts_cat_1] and Tank Monitor Serial number [tx_serialnum]
| baseserialno | N/A | 27327 |
| base_temp | Inside Temperature | 65 |
| ta_ltankcrit | T or F (true or false). | T | Site order will be automatically created when this is set to True. | tx_nosensor | No Sensor | F | This value must be False to be considered a good reading. | tx_lnoxmit | No Transmit | F | This value must be False to be considered a good reading. | ts_location | N/A | 0001-Fort Wayne |
| ts_access | N/A | LPG |
| ts_tankserialnum | Tank Serial Number | tank01 | 2nd Priority Used to Match to Tank Management Site > Tank Device - Customer No [ts_cat_1] and Tank Serial number[ts_serialnum]
| ts_capacity | Tank Capacity | 1000 |
| address_bi | Address | 1611 Plummer Street |
| city_bi | City | Los Angeles |
| state_bi | State | CA |
|
|