Scheduled Read Calendar

The Scheduled read calendar screen displays the scheduled read dates for each route and are used to determine the Next Scheduled Read Date as well as which NMIs to expect reads from on any given read date.

Important!  The Meter Data module must be installed for this screen to appear. Only user personas with roles that include the "View Scheduled Reads Calendar" grant can view this screen.

The table can be sorted by any column by clicking the desired column header. By default, the table is sorted by Read date (primary sort) and Route (secondary sort). The table consists of the following columns:

  • Route. A reading route that exists in MTS.
  • Read date. The scheduled read date for the route, displayed in local date format.
  • Updated date. The date and time the read date was inserted or modified, displayed in local date/time format.
  • Updated by. The MTS user who inserted or modified the read date.

Tip:  To filter the table, click the filter icon () to open a dialog box, where you can select any of the available known values listed by Route. You can also filter by Read dates by selecting a From date and a To date. The date range is reflected in the Read date column in the table.

To edit an existing scheduled read date that occurs in the future, use the following procedure:

  1. On the row that you want to edit, click Actions () and select Edit (). This option is not available for reads that have already occurred.
  2. In the dialog box that appears, select a Read date from the date picker.
  3. Click Update. The edited read date appears in the Scheduled read calendar table and automatically includes an Updated date value and an Updated by value.

To remove an existing scheduled read date that occurs in the future, use the following procedure:

  1. On the row that you want to remove, click Actions () and select Remove (). This option is not available for reads that have already occurred.
  2. In the dialog box that appears, click Remove to confirm the removal of the read date.

To add a new scheduled read date, use the following procedure:

  1. Click the Add icon () at the bottom of the screen.
  2. In the dialog box that appears, complete the following fields:
    • Route. From the drop-down menu, select an existing route.
    • Read date. Select a read date from the date picker.
  3. Click Update. The new scheduled read date appears in the Scheduled read calendar table and automatically includes an Updated date value and an Updated by value.

Important!  The options to edit, remove, add, and import scheduled read dates are available only to user personas with roles that include the "Create and Manage Scheduled Reads Calendar" grant.

To add or remove scheduled read dates in bulk, click the Action icon () in the page header and select Import. From here, you can select a local CSV file containing actions, routes, and read dates. The file must be in the following format:

<action>, <route_number>, <read_date>
<action>, <route_number>, <read_date>
<action>, <route_number>, <read_date>
<action>, <route_number>, <read_date>

The file may have up to 1,000 rows. A header row is not required. All fields are mandatory and must contain values in the following formats:

  • action = The action to take for that row. ADD_READDATE will insert a new scheduled read with the route_number and read_date. REMOVE_READDATE will remove the selected route_number and read_date. No changes can be made to past read dates.
  • route_number = An existing route in MTS.
  • read_date = DD/MM/YYYY date format.

For example, a schedule for routes 101 and 333 for the year 2020 could be formatted as follows:

ADD_READDATE, 101, 1/1/2020
ADD_READDATE, 101, 1/4/2020
ADD_READDATE, 101, 1/7/2020
REMOVE_READDATE, 101, 1/10/2020
ADD_READDATE, 101, 2/10/2020
ADD_READDATE, 333, 15/2/2020
ADD_READDATE, 333, 15/5/2020
ADD_READDATE, 333, 15/8/2020

This file will be validated and, if successful, the updates will be reflected in the Scheduled read calendar.