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 |
---|
|
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). Automatic site | T | Site order will be automatically created when this is set to True. | T | 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 Hiearchy |
---|
|
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. |
- 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.
...