Exporting ICMLive Operator Client Results to Database

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

Exporting ICMLive Operator Client results to Database

To export results to database:

1. Open the Manifest object in InfoWorks ICM.
2. Configure the manifest.
3. Open the Database Export page.
4. Check the Enable database export box. This applies to the baseline simulation selected in the Choose the baseline sim field of the Setup page.
5. To enable the database export of variant runs, check the Export variants box.
6. In the Units section, specify the units in which the results are to be exported.
7. Drag and drop a Scalar time series data object in the Scalar time series data droptarget.
8. Drag and drop a selection list in the Selection list droptarget.
Tip: The use of a selection list is highly recommended as exporting all results fields for all objects for a large network with a large number of timesteps could easily take several hours / days.
Note: If you are exporting time varying results to a PI WebAPi database, a selection list must be specified.
9. Select the desired data source in the Data Source dropdown in the grid. This is automatically populated with the data sources available in the selected Scalar time series data object.
10. In the Table name dropdown, select a table name in the database that results are to be copied to.
11. Select an export type in the Export type dropdown. Available types are:
    • Time-varying results
    • Time-varying gauged results (not available when exporting results to a PI WebAPI database)
    • Default alert results (not available when exporting results to a PI WebAPI database)
    • Verification alert results (not available when exporting results to a PI WebAPI database)
12. Click in the Export mapping column for the selected data source. This opens the Database Export Field Mapping dialog where field mapping is configured.
13. If exporting results to a PI WebAPI database:
    • Click the Info tab.
    • Set the Date / Time field to Timetamp.
    • Select the network object, whose results you want to export, from the Object ID field.
    • Click the network object tab that contains the attribute want to export the results of.
    • Set the attribute (listed in the Internal Field column) to Value.
14. If exporting results to a JET, SQLServer, Oracle or ODBC database, for each object type tab (if appropriate), map the field(s) to be exported by selecting the external field(s) (= field(s) on the database).
15. Click OK. The Database Export Field Mapping dialog closes.
16. Validate the manifest. Any errors in the PI WebAPI database mapping will be highlighted in the Output window.
17. Export is automatically enabled by default for each row with its Enabled box checked in the grid on the Database Export page. If required, uncheck the box adjacent to some rows to disable their export. This may be useful if testing the export for individual rows (see Step 18 below).
18. Click Test Export to test the export. This is a quick way to test that the export is successful for the baseline simulation without having to generate runs from the ICMLive Operator Client, and to check that the exported fields are the desired ones. An HTML log file is displayed in a new window if the export fails.
19. Close the manifest object to save the changes.