How to archive tag and alarm on memory card

Hi Clem_123456789,

On a Unified Panel, logging is always done using SQLite databases. The db3 files you mentioned are these databases. The easiest way to create CSV files from the databases is to use JavaScript on the panel itself. You can find code snippets that demonstrate how to do this on the TIA Portal. Just right click on any JavaScript code and select "Snippets > HMI Runtime > Alarm Logging > Export alarm log as CSV" or "Snippets > HMI Runtime >Tag Logging > Export tag log as CSV".

However, instead of exporting the data to CSV on the Panel, you can also read the SQLite databases and do what you want. All you need is a program that can read SQLite databases. However, since there is no written documentation about the structure of the database, you will have to figure it out yourself.

Here are just a few hints that might help you parse the SQLite databases for your own:

• The locations configured in the runtime settings are used to store a database that manages the logs and their segments. This database contains information about the logs, such as their location, the time the log was started, and so on.
• The databases for the different logs are located in the location configured for each log, in a subfolder named, for example, "HMI_RT_10_ALG6203".
• Reading a timestamp value from the database is a bit tricky because it is stored in the fileTime representation of DatePrecise, which is WinCC Unified specific. So SQLite - as far as I know - does not provide a built-in function to convert it.

Kind regards
Stefan