Here's the format and conditions when importing tank monitor readings:
| Expand |
|---|
| title | Pre-Requisite Setup before Importing |
|---|
|
The following should be setup/ready before the import: 1. Consumption Site - customer should have an existing consumption site. Customer Number is used as the mapping for ts_cat_1.  Image Added
2. Devices - consumption site should have an attached devices. Device Tank Monitor with Serial # (tx_serialnum) is paired with customer number where the combination is used as mapping for import.
Alternatively, a Tank Serial # can be matched if a Tank Monitor Serial # is not found.  Image Added
3. Clock Reading - a reading date entry should also exists in Clock Reading as this is being mapped as rpt_date_ti.  Image Added
The date should also not exist in Events tab of the Consumption Site.  Image Added
|
| Expand |
|---|
| title | Wesroc CSV File Format |
|---|
|
| 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 - This means that 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 |
|
| Expand |
|---|
| title | Import Matching to Site Hierarchy |
|---|
|
- 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.
|
| Expand |
|---|
| title | Pre-Requisite Setup before Importing |
|---|
|
The following should be setup/ready before the import: 1. Consumption Site - customer should have an existing consumption site. Customer Number is used as the mapping for ts_cat_1. Image Removed 2. Devices - consumption site should have an attached devices. Device Tank Monitor with Serial # (tx_serialnum) is paired with customer number where the combination is used as mapping for import.
Alternatively, a Tank Serial # can be matched if a Tank Monitor Serial # is not found. Image Removed 3. Clock Reading - a reading date entry should also exists in Clock Reading as this is being mapped as rpt_date_ti. Image Removed The date should also not exist in Events tab of the Consumption Site. Image Removed |
- 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. See above File format for the correct mappings.
...