Import Time Varying Data from CSV Dialog

If checked, relative date and times will be used for the imported data. By default, this option is unchecked.

The following relative date /time formats are currently permitted:

• the existing number
• hh:mm:ss For example, 24:00:00 (hh can be greater than 23)
• hh:mm For example, 19:15 (hh can be greater than 23)
• n hh:mm:ss or nn hh:mm:ss or n hh:mm or nn hh:mm (where n is number of days, maximum is 99). For example, 15 19:15:36 (hh cannot be greater than 23)
• DD/MM/YYYY or MM/DD/YYYY or YYYY/MM/DD (where MM and YYYY must be all zeros), followed by a space, followed by hh:mm or hh:mm:ss For example, 15/00/0000 19:15:36 (hh cannot be greater than 23)

Used when importing files with no date-time column to specify the time range of data to be imported and the time interval between data values. It is also used to specify timestep and timesep units when using Relative times.

The fields can be manually edited by entering data directly. Alternatively, click on a cell in the grid at the bottom of the dialog and then on the * button next to the Cell field to add the current grid cell to the Cell field.

Can be used if the file to be imported contains a date-time column.

In the grid at the bottom of the dialog: click on the first cell containing valid date-time information and then on the * button next to the First cell field to add the current grid cell to the First cell field.

The full or partial name of the file being imported can be used as the profile ID (link label or node reference) for all data being imported.

Select which characters in the filename are to be used for the profile name(s). For example, when importing a file named Monitor1_001, enter From character of 8 and To character of 12 to import the profile name of 1_001. To use the full file name then specify a From character of 1 and a To character of 12

Use the Timeseries section to view and edit parameters for each data series in the file, which are displayed in the grid at the bottom of the dialog.

Use the arrow buttons to scroll between each data series.

Data series can be added or deleted for import purposes (the underlying file will not be edited).

Describes the data type of the currently viewed data series and the location in the file where the data starts.

Field	Description
Profile cell name	InfoWorks ICM uses the contents of the cell above the first value in a data column as the profile name in the event. If you want to use the different cell, then select the appropriate cell in the grid at the bottom of the dialog containing the identifier and click on the * button. Note The selected profile cell name will be overwritten if the Get profile name from file is specified.
Event Type	Type of data recorded
Unit	Unit of measurement
First Cell	Cell containing first valid time series value. In the grid at the bottom of the dialog: click on the first cell containing valid data values and then on the * button next to the First cell field to add the current grid cell to the First cell field.

Applies the current dialog settings to all files when importing a selection of multiple files.

If this option is unchecked, the import dialog will be displayed before the import of each file.

Note

When importing rainfall events, this option is only available if you have chosen the Import | Rainfall event | from multiple generic CSV files into one event option from the popup menu.

Loads previously saved settings from a .cfg file.