Monitor Page – Exports & Assignments

Use these links to jump to step-by-step instructions on how to:

Export Reads, Billing Reads, Consumption Data and Exception History.
View a Consumption Graph
Print and Download Charts
Set or Edit a Flow Alert
Mark Favorites
Create Field Assignments
Schedule Valve Movements


Export Reads, Billing Reads, Consumption Data and Exception History

Get Reads, Billing Reads, Consumption for networked meters, Consumption across a Data Range and the Exception History for up to 150,000 meters per export. If more than 150,000 meters are selected, only data for the first 150,000 meters will be exported. An export can have up to 1,048,576 rows of data. When exporting Reads, Billing Reads and Consumption using the Monitor>Actions drop-down menu, use any combination of filters to select meters to include in a Data Export.

Once you export a file from the Monitor>Actions drop-down menu, the file remains available for download in the Export Data panel until a new export file is generated.

See Browser Downloads for more on downloading files on your computer.

  • Exporting Latest Reads creates CSV-format spreadsheet files that include meter reads, flow, account, location, service point, meter and endpoint data along with potential leak and backflow information.
  • Exporting Billing Reads creates CSV-format spreadsheet files that comply with the BEACON Billing Read Export Specification and can be used with billing systems.
  • Exporting Consumption (Networked Meters) data creates CSV-format spreadsheet files that include the day of the week, time flow was measured, total amount of flow, the flow unit of measure, and the number of meters with positive flow in each period. Consumption exports aggregate flow data so you can quickly see how much water is being used by a given set of registers over a selected range of dates. Includes networked meters only and excludes no flow and backflow intervals.
  • Date Range exports create CSV-format spreadsheet files that include AMI and AMR meter reads, flow, account, location, service point, meter and endpoint data along with potential leak and backflow information for a selected range of dates. Previously, Consumption (Date Range) was called Date Range.
  • Exception History Date Range exports CSV-format spreadsheet files that list the alerts from meters, encoders and endpoints along with the alert start and end dates. In the case of leak alerts for networked meters, the messages from these devices may differ slightly in timing from the BEACON AMA leak alerts calculated based on flow occurring during each interval for 24 hours. Additional fields provide location, meter, endpoint, account and billing information.

To export data, do the following:

          1. Click the Monitor tab.
          2. If desired, use filters to select meters of interest.
          3. Select Export Data from the Actions drop-down menu.

          4. In the Export Data menu, do one of the following:
            Select Latest Reads, click Start Data Export and save the resulting CSV-format file.
            • Select Billing Reads and proceed to steps 10-11.
            • Select Consumption (Networked Meters) and proceed to steps 5-9.
            • Select Date Range and proceed to steps 5-9.
            • Select Exception History Date Range and proceed to steps 5, 6, (skip step 7), 8, and 9 .

            Export Complete

            NOTE: The date and time shown in the Previous Export Results portion of the Export Data popup menu indicate when the previous export was performed.

            Click Previous Exports to get a list of the last five exports performed locally on your computer. To retrieve any of the export files, click the corresponding Download link on the right side of the screen.

            If you selected an export type that supports a Date Range:

          5. In the Export Options section, click anywhere in the Start Date field and use the Calendar to pick a start date.

          6. Click anywhere in the End Date field and use the Calendar to pick an end date.
          7. If desired, use the Read Interval and Unit drop-down menus to set read interval and unit of measure.
          8. Click Start Data Export.
          9. When the Export process is complete, download and save the resulting file. The file is in CSV (comma-separated values) format and can be opened in a spreadsheet program such as Microsoft® Excel®.If you selected Billing Reads:
          10. Click anywhere in the Billing Read Date field and use the Calendar to pick a date.

          11. Use the Read Time Tolerance drop-down menu to determine how far back in days the exporter will look. For example, setting the tolerance to 5 days will cause BEACON to export billing reads 5 days back from the date selected. A tolerance of “Today” exports billing reads from meters with reads from midnight “today” to the present. Previously, “Today” was labeled “24 Hours.”

        TIP: For best results, use the default setting of 72 hours.

      1. Export Options
        The Fieldsets drop-down menu let you select default and custom fieldsets that are public (available to anyone who can perform exports within your utility) and private (available only to the person who created the fieldset).

        Custom Field Set drop-down menu

        Show Advanced Options
        Clicking Show Advanced Options lets you use the Quoting drop-down menu to include or exclude quotes around cells in the file being exported.

        Quoting drop-down menu

        • Choose All to include quotes.
        • Choose Minimal to quote cells that contain an extra delimiter (Account_Full_Name: “jane,smith”) and Meter Size Unit symbols (Meter_Size_Description: “1””).
        • Choose None to exclude quotes.


        TIP: For consistent read times:
        • In a network environment where data is transmitted throughout the day, pick a Date prior to “Today.”
        • For Mobile and Manual reads, pick the completion date of when the route was read.

        • If you synchronized your billing system with BEACON using a Data Exchange file, and you changed the resolution of any of your meters before you export billing reads verify that your resolution changes have taken effect.


        When to Include Quotes

        When working with CSV files in spreadsheet programs such as Microsoft Excel® and Google Sheets, it is often desirable to put quotes around the data in each cell in the file. Putting quotes around the data forces the spreadsheet program to preserve the information between the quotes.

        For example, without quotes, the spreadsheet program might drop the leading zeros from a number like 0001234 and display it as 1234. With quotes, the spreadsheet program will display the leading zeroes, so “0001234” displays as 0001234. The quotes themselves will not be visible because the spreadsheet program knows to hide them.

        Note: Even when quoted, spreadsheet programs will drop trailing zeros from numbers. For example, 1234.75000 is displayed as 1234.75.

        When commas separate the first and last name in the Account_Full_Name column, quotes tell the spreadsheet program to treat the comma as it would any other character, not as a delimiter. In a comma-delimited file, putting a comma between a last and first name would normally create an extraneous column and disrupt the integrity of the data in your file by shifting all of the data over by a column, so that it does not align properly. In the table below, row 2 shows what could happen. Row 4 shows how using quotes mitigrates the issue.

        Adjacent Column Headers Account_Full_Name Billling_Address_Line1 Billing_City
        What you enter Smith,John 1234 Main St Milwaukee
        What gets displayed Smith John 1234 Main St
        What you enter “Smith,John” 1234 Main Street Milwaukee
        What gets displayed Smith, John 1234 Main Street Milwaukee


        When to Exclude Quotes

        If your billing system does not automatically ignore quotes, choose None. With None selected, BEACON still knows to “escape” full names that are separated by commas by automatically inserting a backslash into the appropriate cell. For example, when escaped Smith, John  becomes Smith\,John. This preserves the alignment of the data in your files.

 

 


 

View a Consumption Graph or Get a Map for a Single Location/Meter

  1. From the At a Glance, Monitor, Assets or Users page, enter one of the following in the Search box:

• Account Name

• Location ID

• Location Name

• Meter ID

• Meter S/N

• Service Address

  Press Return.

  1. Alternatively, from the Monitor page locate the Card of interest, click More and choose Hide Other Meters.
  2. Click the Graph button to display a Consumptions Graph.

  Click the Global button to get a map of the location.


Print a Usage Graph

  1. Click the Monitor tab
  2. Locate the desired account:
    • Use the filters on the left side of the screen.
    •  Enter the Account ID, Account Name or Meter ID into the Search box.
    •  Scroll through the endpoints list to find the Card.

Click the Print or Download button and select the desired action:

  1. Print Chart – A print preview windows opens so you can set the print details.
  2. Download PNG image – The image can be saved, printed or attached to an email.
  3. Download PDF document – The document can be saved, printed or attached to an email.

    Print Consumption Graph


Set or Edit a Flow and Leak Alert
Setting or editing flow and leak alerts that apply to the current meter. Changes made to an alert by an EyeOnWater user or by the utility will override previous alert settings.

      1. Click the Monitor tab.
      2. Locate the desired meter card:
        • Use the filters on the left side of the screen
        • Enter one of the following in the search field: Account Name, Endpoint S/N,
          Location ID, Location Name, Meter ID, or Service Address into the
          search field
        • Scroll through the endpoints list to find the card.
      3. Click the Set Alert button on the meter card to create a new alert, or click the Edit Alert button on the meter card to revise an existing alert and then do the following:

 

      1. In the Alert configuration menu, select either Continuous Flow or Intermittent Flow and click the next arrow.

        Screen Shot 2015-05-04 at 3.30.20 PM

      2. If Continuous Flow was selected, enter a number of gallons per hour to set a Maximum and a Minimum flow threshold and click the next arrow.

        Alert Thresholds

        If Intermittent Flow was selected, set a Maximum flow threshold and click the next arrow.

        Intermittent Flow Max alert

      1. Type the email address of the individual to get the alert notifications into the Add Email box and click the plus sign. Repeat this step as many times as needed to add all the desired email addresses.

        Screen Shot 2015-05-04 at 3.27.41 PM

NOTE: To send the alert as an SMS text to a phone the phone number must be entered as an email address. For example: 5558675309@txt.att.net

    1. Set the interval for the reminder message (Day, 2 Days or 3 Days) and click the next arrow. Note: The default interval is Day. If an interval of Week or Month was set previously, it automatically updates to 3 Days.
    2. Verify that the alert is set correctly in the preview.
    3. Select the desired notification using the Start (send a notice at the start of a leak), Reminder (warns of an existing leak) and Stop (alerts you when a leak stops) tabs.

      Screen Shot 2015-05-04 at 3.27.52 PM

    4. When satisfied, click the Save button.

For 3″ and 4″ E-Series Ultrasonic meters connected with ORION Cellular LTE or LTE-M endpoints with sensors, click the Alerts button and then do the following to create a new alert or revise an existing alert:

Click any Alert type to toggle it on or off and open one of the following Alert configuration menus.

  • Low/High Flow Alert


  • TIP: To set a Leak alert, enter a high flow alert threshold in Above __ Gallons/hour and leave the low flow alert threshold value blank in Below __ Gallons/hour.

  • Water Pressure Alert

  • Average Water Temperature Alert




To configure the any of these alerts:

  1. Enable the alert by clicking the slider
  2. Enter flow alert thresholds.
  3. Click Add New and enter an email address.
  4. Click the plus (+) symbol to commit the entry.
  5. Repeat steps 2 and 3 as often as desired.

    Note: Email addresses must be entered for each alert.

  6. Click one of Day, 2 Days, 3 Days to set the Reminder Frequency.
  7. Activate the Alert by clicking Save.

Monitoring Continuous Flow (Leaks)
While the system lets you and your customers that are using EyeOnWater set leak alerts per meter, we recommend that utilities regularly monitor continuous flow to identify potential leaks* by doing one of the following:

* BEACON detects continuous flow, which may or may not represent an actual leak. We highly recommend investigating continuous flows at locations where flow is expected to be intermittent, because it represents a potential leak.

  • From the AAG page Flow Health module, click the Leak Detected arrow to jump to the Monitor page. The cards for all meters with potential leaks will be displayed ordered from highest to lowest total leak volume.

    screen-shot-2017-02-23-at-12-00-30-pm

  • From the Monitor page, set the Sort By menu to Leak Rate. Cards with potential leaks are displayed from highest to lowest total leak volume followed by cards for the rest of the meters in your portfolio.

    sort-by-leak-rate

To see the start dates for one or more leaks, do one of the following:

  1. From the AAG page Flow Health module, click the Leak Detected arrow to jump to the Monitor page. The cards for all meters with potential leaks are displayed in order from highest to lowest total leak volume.
  2. From the Monitor page, use the Actions drop-down menu to Export Data>Latest Reads.
  3. Open the file in a CSV editor such as Sublime Text (Windows and Mac OS) or NotePad++ (Windows), or import it into Excel using the procedure described here.The Start Date of each potential leak along with its volume are shown in the columns named Current Leak Start Date and Current Leak Rate (gal/hr), respectively.
    current-leak-in-sublime-text

    Sublime Text view.

    current-leak-excel

    Excel view.



Mark Favorites

    1. Click the Monitor tab.
    2. Locate the desired account:
      • Use the filters on the left side of the screen
      • Enter the Account ID, Account Name or Meter ID into the Search box
      • Scroll through the endpoints list to find the Card
    3.  Click the star in the upper left hand corner of the Card. Notice the account associated with the Card appears in the Favorites module on the At a Glance page.

      Click Favorites


 

Create Field Assignments

Utilities with ORION Mobile Read and ORION Field Application for Trimble Ranger handheld reading devices can collect the current reads, extended status and firmware version data from two-way ORION ME and ORION SE endpoints.

  1. Select meters to be assigned for reading by doing one of the following on the Monitor page:
    • Select Location>Cycle and choose a Cycle.
    • Select Location>Location Name and choose a location.
    • Select Location>Route and choose a Route.
    • Select Location>Zip and choose a ZIP code.
    • You can also use any of the filters on the Monitor page to select one or more meters.

  2. Use Actions>Create Field Assignments to open the Create Field Assignments menu.

  3. Use the Type drop-down menu to select one of three job types:
    • Collect Current Read – tells the reader to extract the latest read from the endpoint or meter.
    • Collect Extended Status – tells the reader to extract Extended Status messages from the selected endpoint(s). Extended Status messages include Endpoint Tamper, Encoder Communication Error, Encoder Removed, Endpoint Low Battery, Endpoint Programmed, Endpoint Magnetic Tamper, Meter Exceeding Max Flow and Meter/Endpoint Programmed.
    • Collect Firmware Version – tells the reader to extract the current firmware version of the selected endpoint(s).Note: When using ORION Mobile Read, send each assignment type separately. When using ORION Field Application for Trimble Ranger handheld reading devices, assignments to Collect Current Read are sent to the reader together with Collect Extended Status and Collect Firmware assignments.
  4. Use the Order By drop-down menu to select the desired read order.

    • Sequence–tells the reader to use a read sequence to determine the order to collect reads in.
    • Location–tells the reader to gather reads by location.
  5. Use the Assign To drop-down to assign the job to a user or leave blank to assign the job in Field Director later (requires the BEACON AMA Field Application Suite).Note: If a user in the drop-down menu is paired with a handheld device (using the Assets>Handheld tab), assignments will be sent directly to the handheld device. In addition, the user has to be work-order-enabled by Badger Meter personnel OR paired with a handheld device to be listed in the drop-down menu.Click the Field Director tab and login to manage and monitor meter reading assignments.
  6. Click Create to make the assignment. (The number of meters in the assignment is listed in the Create button.)
    Click Cancel to stop.


Schedule a Valve Position Change

  1. From the Monitor page, locate the desired account:
    • Use the filters on the left side of the screen.
    • Enter the Account ID, Account Name or Meter ID into the Search box
    • Scroll through the endpoints list to find the Card
  2. Click the Valve button on the Card to open the Schedule Valve Actuation popup menu.
  3. In the Schedule Valve Actuation popup menu, select the desired new valve position by clicking an icon.

    Schedule Actuation On Next Communication is toggled on by default.
    Click Specific Time and use the Date picker and time drop-down menu to schedule the actuation date and time. This lets you, for example, give a customer a deadline for paying their bill along with the ability to open their valve shortly thereafter.

  4. Click Next to see a confirmation of the schedule actuation movement time.
  5. Click Confirm to accept, Back to start over or X to cancel.
    The alert bar on the Monitor page card shows the scheduled valve actuation message.

Cancel a Scheduled Valve Position Change

  1. From the Monitor page card for the valve that is scheduled to change position, click View Details in the alert bar.
  2. In the Schedule Valve Position popup menu, click Cancel Position Change to cancel the position change and remove the message from the alert bar on the card.

 

After Activation

  • BEACON updates approximately two (2) minutes after scheduled actuation is complete.
  • For five (5) calendar days after a valve closes, endpoint communication accelerates to once every two (2) hours. When the valve is opened, the call-in schedule reverts back to normal.
  • The daily endpoint check-in time changes after a scheduled valve actuation. Select the Endpoint tab on an expanded meter card to see the Next Comm. (next endpoint communication) time.

    Important: For newly opened values, check the alert bar on the meter card for any Post Open Flow Action alerts that might indicate an unexpected flow condition.

Batch Valve Actuation

Use the Monitor>Actions drop-down menu and select Actuate Valves to open the Schedule Batch Valve Activation popup menu.

From this menu, you can:

  • Search for specific valves
  • Filter results based on the current or scheduled position movement
  • Select groups of valves to schedule position changes
  • Cancel scheduled actuations for multiple valves.
  • Search
    To search for specific valves, enter a Meter ID, Endpoint ID or Valve Serial Number in the search box and press enter.

    Filter and Display Valves
    To filter and display valves by position or schedule movement, click one or more of the icons.

  • Click √ to select valves you want to cancel. Then click Next to see the confirmation of the position change cancellation.
  • Click Cancel, then click Next.
  • Click Confirm to accept the cancellation. Actuation is cancelled immediately and the message is removed from the alert bars for the affected meters.
  • Cancel Batch Actuation

    You can cancel a scheduled batch actuation for any or all pending valves.

    1. From the Actions Actions drop-down menu on the Monitor page, select Actuate Valves to open the Schedule Batch Valve Actuation menu.
    2. Use the Filter By Position icon at the top of the widow to select valves that are pending actuation.
    3. Click √ to select valves you want to cancel. Then click Next to see the confirmation of the position change cancellation.
    4. Click Cancel, then click Next.
    5. Click Confirm to accept the cancellation. Actuation is cancelled immediately and the message is removed from the alert bars for the affected meters.
Tagged with: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Get Support

Knowledge Base

User Guide
Follow via Email

Enter your email address to get new content notifications by email.