...
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).
Selecting Load Source Databaseopens the Source Database Importer (Figure 7). 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:
- Select the appropriate checkbox in the Apply Filter column
- Enter the text to be matched in the Search Text column
Only time series matching the search text for the selected metadata field 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 fields keys simultaneously, then only time series that match all search criteria will be imported.
Figure 7. Editor for importing and querying SDB files.
The loaded SDB files are listed under Source Database Result Files at the bottom of the Results Manager tree menu.
| Anchor | ||||
|---|---|---|---|---|
|
...
- 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.
- Export to Source DB – Database – exports results to a Source Database (*.sdb) file. Further details are provided below.
...
| 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:
- Export to New - create a new *.sdb file, or
- Append to Existing - append to an existing *.sdb file.
When appending to an existing file, duplicate time series are overwritten. Time series are considered to be duplicates if the following metadata fields match exactly:
- ScenarioName
- Timestep
- StartDate
- EndDate
- Site
- Structure
- Units