Versions Compared

Old Version 10

changes.mady.by.user Jessica Real

Saved on

compared with

New Version 11

changes.mady.by.user Jessica Real

Saved on

Key

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

...

Expand
titleFile Format
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
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.
    Image RemovedThe CSV file should contain the following mappings:See above File format for the correct mappings.
    Image Added
  3. Enter email address to Exception Reports Emailed To field. This field is required.

Image Added

4. Click Import toolbar button. The message below will display indicating that the importing is in progress.

Image Added

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. 

Image Added

The following site details will be also added/updated:

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

Image Added

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

Image Added

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.

Image Added

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

Image Added

Image Added


Expand
title18.3
  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.
    Image Added
  3. Enter email address to Exception Reports Emailed To field. This field is required.

Image Modified

4. Click Import toolbar button. The message below will display indicating that the importing is in progress.

Image Modified

5. Once the import is successful, this message below will display. 

Image Modified

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.

Image Modified

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

Image Modified

Image Modified

Expand
title17.3
  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.

...