Page History

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	Tank Monitor File Format	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

customerid


base_id_

ti

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

1	Customer Number	0000000020	Required - Used to Match to Tank Management Site
ts_cat_

2

2	N/A	10
ts_cat_

3

3	N/A	10
ts_cat_

4

4	N/A	10
tk_

level

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

]
baseserialno	N/A	27327
base_

temp

temp	Inside Temperature	65
ta_

ltankcrit
tx_nosensor
tx_lnoxmit
ts_location
ts_access
ts_tankserialnum
ts_capacity
address_bi
city_bi
state_bi

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 Select the CSV file for import. See above File format for the correct mappings.
Image Removed
The CSV file should contain the following 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

Expand

title	18.3

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

Expand

title	17.3

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.
Enter email address to Exception Reports Emailed To field. This field is required.

4. Click Import toolbar button. The message below will display indicating that the importing is in progress.

5. Once the import is successful, this message below will display.

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.

If Import fails, the message below will be displayed followed by the import log containing why it failed.

...

Page tree

Versions Compared

Old Version 7

New Version Current

Key