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). | 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 |
|
|
- 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.
Image Added
3. Enter an email address to Exception Reports Emailed To field. This field is required.
Image Added
4. Click Import toolbar button. The message below will display indicating that the importing is in progress.
Image Added
5. Once the import is completed, a message will display based on the import status.
A. When the import is successful, this message below will display.
Image Added
The following site details will be also added/updated:
i. Site Order will be automatically created if ta_ltankcrit = T.
Image Added
ii. The Tank Monitor Reading (Event-021) event will be also created and displayed on the grid.
Image Added
iii. Fields in Site and Details tab will be recomputed:
- Run Out Date
- Forecasted Delivery
- Next Delivery Degree Day
- Estimated Gallons and Percentage
- DD Between Deliveries
- Burn Rate
B. If import is not successful, an exception report email will be sent to the email address indicated on Exception Reports Emailed To field.
Image Added
C. If Import fails, the message below will be displayed followed by the import log containing why it failed.
Image Added
Image Added
Expand |
---|
|
Expand |
---|
title | Tank Monitor Import Conditions |
---|
|
The following conditions should be properly setup for successful import:
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.tx_nosensor and tx_lnoxmit should be equal to False.ts_cat_1 should not be Blank.rpt_date_ti should not be in Invalid format or BlankTank Monitor rpt_date_ti should not yet exists in event historyRecord with rpt_date_ti to be import should not be earlier than the site's latest Tank Monitor Reading Eventrpt_date_ti of the records to import should have a corresponding clock reading |
- 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.
Image Modified
|
...
- Enter email address to Exception Reports Emailed To field. This field is required.
Image Modified
4. Click Import toolbar button. The message below will display indicating that the importing is in progress. Image Modified
5. Once the import is successful, this message below will display. Image Modified
Otherwise, this is the message that will display. If import is not successful, an exception report email will be sent to the email address indicated on Exception Reports Emailed To field. Image Modified
If Import fails, the message below will be displayed followed by the import log containing why it failed. Image Modified
Image Modified
|
Expand |
---|
|
- On the Menu panel, click the Tank Monitor menu. This will open the Import Wesroc Tank Monitor Reading screen.
![](/download/attachments/20316320/image2016-4-21%2010%3A38%3A37.png?version=1&modificationDate=1461206522660&api=v2&effects=border-simple,shadow-kn) - Click Browse button. This will open the Open File screen. Select the CSV file for import.
![](/download/attachments/20316320/image2016-4-21%209%3A57%3A44.png?version=1&modificationDate=1461204069823&api=v2&effects=border-simple,shadow-kn) - Enter email address to Exception Reports Emailed To field. This field is required.
![](/download/attachments/20316320/image2016-4-21%209%3A58%3A21.png?version=1&modificationDate=1461204107137&api=v2&effects=border-simple,shadow-kn)
4. Click Import toolbar button. The message below will display indicating that the importing is in progress. ![](/download/attachments/20316320/image2016-4-21%2010%3A1%3A38.png?version=1&modificationDate=1461204303853&api=v2&effects=border-simple,shadow-kn)
5. Once the import is successful, this message below will display. ![](/download/attachments/20316320/image2016-4-21%2010%3A40%3A41.png?version=1&modificationDate=1461206646820&api=v2&effects=border-simple,shadow-kn)
Otherwise, this is the message that will display. If import is not successful, an exception report email will be sent to the email address indicated on Exception Reports Emailed To field. ![](/download/attachments/20316320/image2016-4-21%2010%3A4%3A45.png?version=1&modificationDate=1461204490957&api=v2&effects=border-simple,shadow-kn)
If Import fails, the message below will be displayed followed by the import log containing why it failed. ![](/download/attachments/20316320/image2016-4-21%2010%3A42%3A16.png?version=1&modificationDate=1461206741653&api=v2&effects=border-simple,shadow-kn)
![](/download/attachments/20316320/image2016-4-21%2010%3A42%3A39.png?version=1&modificationDate=1461206764117&api=v2&effects=border-simple,shadow-kn)
|
...