Updating Time Series Data

Closed

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

Overview of the update function

Introduction

InfoWorks ICM 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:

Carrying out 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:

  1. Open the current view of the desired TSDB.
  2. The Observed or Forecast Page of the Time Series Database is displayed.
  3. 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 select Update data from the context menu, or
      • Right-click anywhere on a row (data stream) in the Observed or Forecast page and select Show time series data from the context menu. 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.
      3. Tip

      Manual update of time series databases can be permissioned and therefore may not be available to users who have not been granted rights to perform this operation.

      Tip

      It is possible to make individual data streams not updatable by enabling their External update disabled option in the Observed or Forecast page of the time series database.

    This displays the Update Time Series Data dialog.

  4. 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: This option is not available with an Autodesk InfoWorks - ICM Ultimate licence.

    IMPORTANT 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 InfoWorks ICM 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.

  5. Click OK to save the changes.
    1. 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.
    2. 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.

  1. Open the current view of the desired TSDB.
  2. The Time Series Data Grid is displayed.
  3. Click Update data.
    Tip

    Manual update of time series databases 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 can be easily identified by a R/O caption in the grid title bar.

    This displays the Update Time Series Data dialog.

  4. 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).

    Note: This option is not available with an Autodesk InfoWorks - ICM Ultimate licence.

  5. Click OK to save the changes.
    1. 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.
    2. 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 TSDB updates

It is possible to disable updates to TSDBs in InfoWorks ICM.

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 databases can only contain one stream and only one data source, this means that spatial TSDB data can always be manually updated.

Scalar TSDBs, 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 Time Series Database. (This option applies to both manual and automatic updates). As a result:

Time Series Database Objects

Update Time Series Data Dialog

Time Series Database

Spatial Time Series Database

User Permissions at action level