Getting Started- TSDB Manager
The prerequisites for the following steps are:
• TSDB Manager is installed successfully.
• The license file is installed properly.
Test Run with the Provided Sample
TSDB Manager installation folder contains a “Sample” folder, where the provided samples are
located.
Open the “[Link]” file.
Three folders are included in the zip file.
• Sample1 – “Time stamp”-based measurement sample data in CSV format with prepared
configuration file.
• Sample2 – “Measurement place”-based sample data in CSV format with prepared
configuration file.
• SampleSin – PSS®SINCAL sample database with prepared TSDB connection.
Create a new folder on your hard drive for saving the sample files above. Hereinafter this document
uses “C:\TSDI\” folder name as sample, but you must use your newly created directory name, where
the sample data was extracted. Copy all the sample folders under the created TSDI folder.
Open the “Sample1” folder, and find the parameter file “Sample1_config.xml”, which contains the
parameterization for the sample data.
The config file must be edited.
Check all the marked file path. “DB” folder, “LOG” folder under the “DB” folder, “sincal_data.csv” file
under the “Data” folder, all of them must be “Sample1” folder. Correct all the file path above.
Now, all the preparation has been done.
Double click on the desktop icon or start from the menu.
The following form appears:
The first action must be to select parameter file. Click on the button with “….” at the end of the first
line.
The file selection form appears:
Open the “Sample1” folder and choose the parameter file “Sample1_config.xml”.
Choose the appropriate file and open it.
When the parameter file is loaded, “Parameter file”, “TSDI database path” and the data in “Sources”
box will be filled. And the ”Parameters” box controls are also activated as shown in the picture
above.
At the first run the “Initialize Admin DB” button is enabled and “Process” button is disabled. This
state means the administrator database does not exist or is not initialized.
It must click on the “Initialize Admin DB” button for creating and initializing of administrator
database.
If the administrator database initialization was successful, the “Manage TSDI DB” and “Process”
buttons are enabled as next picture is shown.
If you click on the “Manage TSDI DB”, the next window appears.
Currently it’s empty, because after the initialization there is not any created TSDI database. The
created databases will be shown after a successful conversion process. The ”TSDI_Sample1.db” file
does not exist yet.
After the conversion process, the database file will be created under the file path shown the ”TSDI
database path” box.
The process uses the represented sources in the “Sources” box.
Click the “Process” button, and the conversion starts.
The messages of the conversion process are shown in the “Process Window” (see above).
When the process is finished, “Finish & Close” button is enabled.
Clicking the “Finish & Close” button, all the windows disappear. The process has finished.
Checking the created files are possible under the “DB” folder of the installation folder of the sample.
If the conversion process was successful, two databases are there “TSDBM_admin.db” and
“TSDI_Sample1.db”.
LOG file is also created, in the “LOG” subdirectory.
Each started process creates a new LOG file.
Managing Created TSDI Databases
Because the created TSDI databases are registered in the administrator database, it is important to
manage created databases in synchronous. Synchronous data management can be realized with
inbuilt data management.
Clicking on the “Manage TSDI DB” button, the “Manage TSDI databases” window appears.
The current software version supports the database deletion only. By clicking on “Delete” button the
selecrted database will be deleted (from the administrator database and the file system too).
The created TSDI file was deleted successfully.
"Sources“ Data Grid
The parameter XML can contain source definitions, which are loaded automatically into the
“Sources” data grid.
This data grid has a context menu with source modification functions.
Add Source
This paragraph shows the “Add Source” function.
The picture below shows the context menu, which can be activated by a right mouse click on the data
grid.
”Add Source” command opens a new window.
Note
This window behavior depends on the defined source type(s) in the parameter XML. The
sample below shows a CSV type source definition.
The first window contains the source type selection. Those source types are listed here, which are
defined in the parameter XML.
The second window is the source file definition.
Click the “….” Button and choose the Source file. If the file path has put on “Source File Name” box,
the ”Next” button is going to be activated.
The right setting of character coding is important, when source file contains non ASCII coded
characters.
For the correct number conversion, it is important to set the culture correctly, because the decimal
separator may differ from culture to culture.
Click the “Next”.
The third window is the setting of measurement data.
Choose the “Target Type” and click the “Finish”.
The new source is added to the “Sources” box.
If you would like to save the modifications, check the box “Save modifications”. The conversion start
will store the parameter XML modifications also.
All the preparation has done. Click the “Process” and try to convert. After the conversion, check the
created files.
Source Information
The “Info” command of the context menu opens a new window with information about the selected
source.
Update the Source File
The “Update File” command of the context menu can change the linked file to the source.
Clicking on “Update File”, a file selection window appears.
You can choose the latest source file in this window.
Click the “Process” button and convert with the latest source file. After the convertion, check the
created files.