RDB2CSV, what is it?
This program will convert .rdb files, generated by TIA portal or Wincc flexible runtime of Siemens,
to a comma separated values file, that you can use with a spreadsheet program.
The .rdb file is actually an SQLite database file.
Prerequisites:
It is made in visual studio 2008 and you need to have the 2.0 .net framework or higher installed.
The SQLite DLL must ALWAYS be in the same directory as the .exe file.
Usage.
Click on "Browse .RDB file" to open a RDB file that is NOT in use!!
Make always a backup of your .rdb file.
Then, make a selection if you wish to add the time in date time format, standard in a .rdb file, these fields aren't used, as the time in ms is already the time reference.
Then click "Open file and import data", please wait a while, processing a big amount of data can take some time.
Once the data is loaded, and you can see the values in the RAW DATA table, you can export this using the Export to csv button.
We always talk about a comma separeted values file, but according to your regional settings, this can change.
For me, Excel is using ";" sign to process csv file, so I added a feature that you can choose to save the file with a different delimiter -> ';' or ","
This program will convert .rdb files, generated by TIA portal or Wincc flexible runtime of Siemens,
to a comma separated values file, that you can use with a spreadsheet program.
The .rdb file is actually an SQLite database file.
Prerequisites:
It is made in visual studio 2008 and you need to have the 2.0 .net framework or higher installed.
The SQLite DLL must ALWAYS be in the same directory as the .exe file.
Usage.
Click on "Browse .RDB file" to open a RDB file that is NOT in use!!
Make always a backup of your .rdb file.
Then, make a selection if you wish to add the time in date time format, standard in a .rdb file, these fields aren't used, as the time in ms is already the time reference.
Then click "Open file and import data", please wait a while, processing a big amount of data can take some time.
Once the data is loaded, and you can see the values in the RAW DATA table, you can export this using the Export to csv button.
We always talk about a comma separeted values file, but according to your regional settings, this can change.
For me, Excel is using ";" sign to process csv file, so I added a feature that you can choose to save the file with a different delimiter -> ';' or ","
RDB 2 CSV
You are using the software at your own risk, by downloading you agree with the Terms.
Open source.
In the future I will make the sourcecode available for download.
So you can look & change the code by yourself.
The die hards can decompile the .exe for now ;-), or just write their own solution.
Big fat warning.
Industrial processes are very critical, corrupt data can cause damage, therefore this program shall only be used for hobby, or educational use, and not for real industrial applications.
Similar projects.
Note that on github, you can find also a logviewer for wincc flex, with graph functionality.
It has also a .csv export function. https://github.com/yuriqdev/WinCCflexLogViewer
I did not worked on that project.
Change log:
-V1.0 - initial version 2018
-V1.1 - update on 7/01/2020 -> In the open file dialog, setting "AutoUpgradeEnabled" set to false.
In windows 10, when in windows unconnected networkdrives are present, windows can slow down the application.
Disabling this setting will use the old version (windows xp style) of the open file dialog, and will load faster.
-V1.2 - update on 19/02/2020 - The conversion from ms to date was off by two day's (hours and seconds where correctly converted) . This has been fixed in this version.
-V1.3 - update on 4/05/2020 - This version is compiled for .net version 4. - 32bit
This is comptible with windows 10. Logic inside is the same as version 1.2.
V1.4 - update on 24/11/2021 - This version has been changed to be compatible with alarm logs, when the ms conversion is checked.
-V1.0 - initial version 2018
-V1.1 - update on 7/01/2020 -> In the open file dialog, setting "AutoUpgradeEnabled" set to false.
In windows 10, when in windows unconnected networkdrives are present, windows can slow down the application.
Disabling this setting will use the old version (windows xp style) of the open file dialog, and will load faster.
-V1.2 - update on 19/02/2020 - The conversion from ms to date was off by two day's (hours and seconds where correctly converted) . This has been fixed in this version.
-V1.3 - update on 4/05/2020 - This version is compiled for .net version 4. - 32bit
This is comptible with windows 10. Logic inside is the same as version 1.2.
V1.4 - update on 24/11/2021 - This version has been changed to be compatible with alarm logs, when the ms conversion is checked.