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 |
|
|