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

Compare with Current View Page History

« Previous Version 10 Next »

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


Import Fields

Description

customerid Customer ID
base_id_ti N/A
tx_num_ti N/A
rpt_date_ti Reading Date and Time
ts_cat_1 Customer Number
ts_cat_2 N/A
ts_cat_3 N/A
ts_cat_4 N/A
tk_level Percent Left
tk_w_dau N/A
tx_serialnum Tank Monitor Serial Number
baseserialno N/A
base_temp Inside Temperature
ta_ltankcrit T or F (true or false)
tx_nosensor No Sensor
tx_lnoxmit No Transmit
ts_location N/A
ts_access N/A
ts_tankserialnum Tank Serial Number
ts_capacity Tank Capacity
address_bi Address
city_bi City
state_biState

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.
  3. The CSV file should contain the following mappings:
  4. 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