Updating Time Series Data

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

Available update types

Two different types of updates can be implemented:

• Automatic – update of time series data that occurs on a scheduled or triggered basis. These types of updates can only be invoked by the Data Loader and always perform a latest update.
  • Scheduled – update that occurs on regular basis according to a configured schedule.
  • Triggered – update that occurs in response to an external event, such as the modification of a file.
• Manual – update that occurs on demand, in response to a user request. These types of updates can only be invoked by the ICMLive Operator Client user and may perform either 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.

In addition to latest or ranged updates, batch updates are also provided. A batch update loads all the data from a CSV format input file (i.e. all times and all streams except those for which updates have specifically been disabled). Only the Batch CSV data source supports batch update and, conversely, any update carried out for a batch CSV data source is a batch update (i.e. any specified data stream or time range is ignored – all available data are loaded).

Instructions on how to implement all these update types are described in the sections 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.

To carry out a manual update for a TSD object

1. Open the Time Series Data Window for the desired time series data object.
2. Click Update data.
   Tip: Editing time series data can be permissioned in InfoWorks ICM and therefore may not be available to ICMLive Operator Client users who have not been granted rights to perform this operation. If this is the case the time series data window will be read-only. Read-only time series data can be easily identified by a R/O caption in the window title bar.

   This displays the Update Time Series Data dialog.

3. 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: When using the 64-bit version of InfoWorks ICM, it is not possible to perform updates as a background process when using a JET database as an external data source due to incompatibility with x64 applications.
4. Click OK to save the changes.
   • The update is carried out if the Perform the update in a background process (recommended) option is checked in the Update Time Series Data dialog. The window is updated with the recent updates.
   • If the Perform the update in a background process (recommended) option has been enabled, the Schedule Job(s) dialog is displayed:
     1. Select when to run the updates and click on OK.
     2. If the Time Series Data Window 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 time series data is updated.

Set up automatic updates

The configuration of automatic updates (scheduled or triggered) is implemented in InfoWorks ICM. See the InfoWorks ICM help for more information.

Disabling TSD updates

Updates to TSD objects can only be disabled in InfoWorks ICM. See the InfoWorks ICM help for more information.