Updating Time Series Data

TSD functionality is only available if the TSD option is enabled on your licence.

Time series data can be updated from external data sources. The following updates are supported:

Manual update of streams
Manual update of data sources
Automatic update of data sources (This option is not available in only available in InfoAsset Manager)

InfoAsset Manager users can perform manual updates, i.e. on demand updates. A manual update can be a latest update or a ranged update.

Latest updates are also referred to as Optimistic updates. Optimistic updates load time series data with a time-stamp later that the most recent time-stamp. On the other hand, ranged updates, also known as Pessimistic updates, load time series data within a specified time range, possibly overwriting existing data.

Instructions on how to implement manual updates are described in the section below:

Perform a manual update

Manual updates are updates implemented at the user's request. Since updating time series data can be a resource intensive process, it may prevent users from carrying out other tasks. Therefore, manual update of time series data may be delegated to a background process. It is possible to perform the update in the foreground but this is not recommended. Please refer to the sections below for further details.

The configuration of manual updates depends on the type of the time series data:

Manual update for Scalar time series data

Open the current view of the desired Scalar TSD object.
The Observed or Forecast Page of the Scalar TSD is displayed.
At this stage it is possible to update a single data stream or a data source (and all its data streams):
1. To update a single data stream, right-click anywhere on a row (data stream) in the Observed or Forecast page and, from the popup select:
  - Update data.
  or
  - Show time series data. Click Update data on the Time Series Data Grid that is subsequently displayed.
2. To update a data source and all its associated data streams, right-click anywhere on a row (data source) in the Data Sources page and select Update data from the context menu.
This displays the Update Time Series Data dialog.
In this dialog, configure settings for the manual update as required. Ensure that the Perform the update in a background process (recommended) option is set to the desired state (checked or unchecked).

Note: If Perform the update in a background process is checked, then updating from an "access" external data source can only be done by selecting an agent that has a 32-bit version of the software installed. If Perform the update in a background process is unchecked, updating from an "access" external data source can only be done in a 32-bit version of InfoWorks ICM. This is due to incompatibility of JET databases with x64 applications.
Click OK to save the changes.
- The update is carried out if the Perform the update in a background process (recommended) option is unchecked in the Update Time Series Data dialog. The grid is updated with the recent updates.
- If the Perform the update in a background process (recommended) option is checked, the Schedule Job(s) dialog is displayed:
  1. Select when to run the updates and click OK.
  2. If the Time Series Data Grid was not in focus during the update, click Apply updates to refresh the window with the updated data (otherwise the window will be automatically refreshed) once the update is complete.
The scalar time series data is updated.

Manual update for Spatial time series data

Open the current view of the desired Spatial TSD object.
The Time Series Data Grid is displayed.
Click Update data.
Tip: Manual update of spatial time series data can be permissioned and therefore may not be available to users who have not been granted rights to perform this operation. If this is the case the time series data grid will be read-only. Read-only time series data includes the R/O caption in the grid title bar.

This displays the Update Time Series Data dialog.
In this dialog, configure settings for the manual update as required and ensure that the Perform the update in a background process (recommended) option is set to the desired state (checked or unchecked).
Click OK to save the changes.
- The update is carried out if the Perform the update in a background process (recommended) option is unchecked in the Update Time Series Data dialog. The grid is updated with the recent updates.
- If the Perform the update in a background process (recommended) option has been checked, the Schedule Job(s) dialog is displayed:
  1. Select when to run the updates and click on OK.
  2. If the Time Series Data Grid was not in focus during the update, click on the Apply updates button to refresh the window with the updated data (otherwise the window will be automatically refreshed) once the update is complete.
The spatial time series data is updated.

Disabling TSD updates

It is possible to disable updates to TSD objects in InfoAsset Manager.

Disabling manual updates

There are two types of manual updates:

Manual update of data streams
Manual update of data sources

Data sources can always be manually updated, regardless if automatic updates are enabled or disabled. In other words, manual data source updates cannot be disabled. As spatial time series data can only contain one stream and only one data source, this means that spatial TSD objects can always be manually updated.

Scalar TSD objects, on the other hand, can have many streams and data sources defined. Manual update can be disabled for a data stream when you check the External update disabled option for that data stream in the Observed or Forecast page of the Scalar TSD. (This option applies to both manual and automatic updates). As a result:

The Update data button of the Time Series Data Grid becomes unavailable (greyed out).
The Update data context menu option of the Observed or Forecast page of the Scalar TSD becomes unavailable (greyed out).