Here's the format and conditions when importing tank monitor readings:
Import Fields
Description
Example Values
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
ts_cat_1
Customer Number
0000000020
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
baseserialno
N/A
27327
base_temp
Inside Temperature
65
ta_ltankcrit
T or F (true or false). Automatic site order will be created when this is set to True.
T
tx_nosensor
No Sensor
F
tx_lnoxmit
No Transmit
F
ts_location
N/A
0001-Fort Wayne
ts_access
N/A
LPG
ts_tankserialnum
Tank Serial Number
tank01
ts_capacity
Tank Capacity
1000
address_bi
Address
1611 Plummer Street
city_bi
City
Los Angeles
state_bi
State
CA
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 Blank
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
rpt_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. See above File format for the correct mappings.
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 completed, a message will display based on the import status.
A. When the import is successful, this message below will display.
The following site details will be also added/updated:
a. Site Order will be automatically created if ta_ltankcrit = T.
b. The Tank Monitor Reading (Event-021) event will be automatically created and displayed on the grid.
c. 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.
C. If Import fails, the message below will be displayed followed by the import log containing why it failed.
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.
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.
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.
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.