Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Loads any time series file type compatible with Source (refer to a complete list in Data file formats). Multiple files can be selected and imported at once. The imported files are listed under Loaded Time Series at the bottom of the tree menu. Just like data sources, if a file has multiple columns, all columns will be imported. Unlike data sourcesData Sources, there is no choice to only import some of the data columns.

A Source Database (.sdb) can also be loaded as a time series, but cannot be queried to filter the data loaded. To access this option see Load Source Database below.

To set units on loaded time series, select the time series file name. The right side of the Results Manager window will display the Unit Preferences options as shown in Figure 1 below. To select the preferred unit, click on 'no unit selected' and then choose from the list of available units.

Figure 1. Unit Preferences for Loaded Time Series



Anchor
Load Source Database
Load Source Database
Load Source Database

Loads a Source Database (SDB) file. The SDB is Source's binary file format for storing time series data and associated metadata (for details see the SDB file format documentation). A Source Database previously exported from Result Manager can be loaded using the 'Load Source Db' option in Results Manager. The newly loaded SDB files will be listed under Source Database Result Files at the bottom of the Results Manager tree menu. An SDB can also be loaded as a time series but this doesn't provide the ability to filter according to metadata tags keys (see SDB Importer Details). 

Image Removed


Anchor
SDB Importer Details
SDB Importer Details
SDB Importer Details

Selecting Load Source Databaseopens the Source Database Importer (Figure 2). Click the three dots "..." in Source Database Location field to navigate to and select an existing *.sdb file from your hard drive.

By default, all time series in the SDB file will be imported. However, the user can specify Search Criteria to import time series with specific metadata content. To filter the data based on the values of a particular Metadata Key:

  1. Select the Apply Filter checkbox
  2. Enter the text to be matched in the Search Text field

A detailed description of the metadata keys listed in Figure 2 can be found in the SDB file format documentation. Only time series matching the search text for the selected metadata key will be imported. A match occurs if all or part of a string is matched, and matches are not case sensitive. For example, the search text "Flow" could match "Downstream Flow" and "Inflow".

If the SDB is filtered on multiple metadata keys simultaneously, then only time series that match all search criteria will be imported.

Figure 2. Editor for importing and querying SDB files.

Anchor
ExportingResults
ExportingResults
Exporting results

...