| Info | ||
|---|---|---|
| ||
| Note: For simplicity, any loaded time series (*.res.csv or other formats) are called results. |
| Anchor | ||||
|---|---|---|---|---|
|
Results can be loaded into the Results Manager using:
...
These methods are described below.
Load Results Files
Loads all *.res.csv files in a specified folder (even if there are other time series in the folder). This is non-recursive, ie. it does not load files within sub-folders. The loaded files are listed under Loaded Result Files at the bottom of the tree menu.
Load Time Series
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 sources, there is no choice to only import some of the data columns.
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
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). The loaded SDB files are listed under Source Database Result Files at the bottom of the Results Manager tree menu.
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:
- Select the Apply Filter checkbox
- Enter the text to be matched in the Search Text field
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 | ||||
|---|---|---|---|---|
|
To export a result, result set or custom chart, right click on it in the tree menu panel and choose one of the export options from the contextual menu:
- Export Time Series – this allows you to save the result(s) as a *.res.csv file, which can then be re-imported for future use maintaining the same data structure.
- Export to Excel – opens the result(s) in Excel, allowing you to save a *.csv file. When exporting results using the tree menu descriptive headers and units are included in the export process.
- Export to Source Database – exports results to a Source Database (*.sdb) file. Further details are provided below.
For single results, most export methods allow you to export for either the Current Run only or All Runs. All Runs will export that result for all runs in the current session.
Also, for Time Series exports, there is an option to export either the Raw or Transformed results. The Transformed export will include the missing data value (-9999) for any results filtered by the transform applied, and will also export results as aggregated in the aggregation time step. Note that this applies only to configured Transforms not transforms applied using the Quick View Toolbar. Raw time series results export will include all results.
| Info | ||
|---|---|---|
| ||
| Note: When you right click on any entry in the tree menu, apart from a single result, you can choose to export data for all series beneath it. So to save all results for a scenario, right click on the scenario name. This will export results for a scenario, which is not the same as saving a run in your project. |
Export to Source Database
When exporting to a Source Database (*.sdb) file, the user has the option to:
...