Versions Compared

Old Version 12

changes.mady.by.user Jessica Real

Saved on

compared with

New Version Current

changes.mady.by.user Brian Kay

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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


Expand
titlePre-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
titleWesroc 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 ValuesImporting Conditions/Notes
customerid Customer ID550
base_id_ti N/A23800000
tx_num_ti N/A1
rpt_date_ti Reading Date and Time6/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 Number0000000020

Required - Used to Match to Tank Management Site

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

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/A27327
base_temp Inside Temperature65
ta_ltankcrit T or F (true or false). Automatic site  TSite order will be automatically created when this is set to True.T
tx_nosensor No SensorFThis value must be False to be considered a good reading.
tx_lnoxmit No TransmitFThis value must be False to be considered a good reading.
ts_location N/A0001-Fort Wayne
ts_access N/ALPG
ts_tankserialnum Tank Serial Numbertank01

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 Capacity1000
address_bi Address1611 Plummer Street
city_bi CityLos Angeles
state_biStateCA
Expand
titleImport 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 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.

    ...

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

    ...