You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 13 Next »

Here's the format and conditions when importing tank monitor readings:


Import Fields

Description

Example Values
customerid Customer ID550
base_id_ti N/A23800000
tx_num_ti N/A1
rpt_date_ti Reading Date and Time6/26/2019
ts_cat_1 Customer Number0000000020
ts_cat_2 N/A10
ts_cat_3 N/A10
ts_cat_4 N/A10
tk_level Percent Left50
tk_w_dau N/A0.1
tx_serialnum Tank Monitor Serial Numbertank01
baseserialno N/A27327
base_temp Inside Temperature65
ta_ltankcrit T or F (true or false). Automatic site order will be created when this is set to True.T
tx_nosensor No SensorF
tx_lnoxmit No TransmitF
ts_location N/A0001-Fort Wayne
ts_access N/ALPG
ts_tankserialnum Tank Serial Numbertank01
ts_capacity Tank Capacity1000
address_bi Address1611 Plummer Street
city_bi CityLos Angeles
state_biStateCA

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


  1. On the Menu panel, click the Tank Monitor menu. This will open the Import Wesroc Tank Monitor Reading screen.
  2. Click Browse button. This will open the Open File screen. Select the CSV file for import. See above File format for the correct mappings.

3. Enter an 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:

i. Site Order will be automatically created if ta_ltankcrit = T.

ii. The Tank Monitor Reading (Event-021) event will be also created and displayed on the grid.

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.

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


  1. On the Menu panel, click the Tank Monitor menu. This will open the Import Wesroc Tank Monitor Reading screen.
  2. Click Browse button. This will open the Open File screen. Select the CSV file for import.
  3. 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.

  1. On the Menu panel, click the Tank Monitor menu. This will open the Import Wesroc Tank Monitor Reading screen.
  2. Click Browse button. This will open the Open File screen. Select the CSV file for import.
  3. 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.

  1. On the Menu panel, click the Tank Monitor menu. This will open the Import Wesroc Tank Monitor Reading screen.
  2. Click Browse button. This will open the Open File screen. Select the CSV file for import.
  3. 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.

  1. On the Menu panel, click the Tank Monitor menu. This will open the Import Wesroc Tank Monitor Reading screen.
  2. Click Browse button. This will open the Open File screen. Select the CSV file for import.
  3. 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.

  • No labels