Versions Compared

Old Version 15

changes.mady.by.user Brian Kay

Saved on

compared with

New Version 16

changes.mady.by.user Jessica Real

Saved on

Key

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

...

Expand
titleWesroc CSV File Format
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

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 Numbertank01Used to Match to Tank Management Site
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 Numbertank01Used to Match to Tank Management Site
ts_capacity Tank Capacity1000
address_bi Address1611 Plummer Street
city_bi CityLos Angeles
state_biStateCA
Expand
titleImport Matching to Site HiearchyHierarchy
  • 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.
Expand
titleTank Monitor Pre-Requisite

The following should be set before import:

  1. XML File - the file should contain the header and values should be separated by a comma.Image Added
  2. Consumption Site
  3. Devices attached to consumption site
  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.

...