Import Time Varying Data from CSV Dialog

This dialog is a generic importer for time varying data. You can identify a column containing time information, or set a start time and timestep for the data. For each column of time varying data a unit type can be set.

The dialog is displayed if you right click on a Time Varying Data or Time Varying Data Event and choose Import | from generic CSV file from the popup menu.

See Importing Time Varying Data for further details.

ClosedShow me

 

Dialog description

Item Description
Relative times

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)
Set Times

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.

When importing from standard logger format, the start date-time and timestep fields should be automatically set from the file header.

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.

Field

Description

Start Date

Start Time

Date and time of first reading to be imported.

These fields are disabled when the Relative times option is checked.

End Date

End Time

Date and time of last data reading to be imported.

Check the Set End Times option to set an end date and time. If these are not set data will be imported from the start date-time to the end of the timeseries.

These fields are disabled when the Relative times option is checked.

Timestep

Interval between data readings.

Step Units

Units of timestep interval.

First Cell

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.

Get profile name from file

(overrides setting below)

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

Add / Delete

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

Data Series parameters

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

InfoAsset Manager 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.

Unit 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.

Grid Window The file being imported is displayed in the grid window.
Load Config

Loads previously saved settings from a .cfg file.

Save Config

Saves the current dialog settings to a configuration (.cfg) file.

Importing Time Varying Data