Im using OPC UA and the internal datalogger. Im copying the files from the PLC and convert the datalogger.db file to a .CSV file.
My problem is that the timestamp is in 19 digit and not 13 digit format as SQlite shall have. How do I convert the timestamp?
The datalogger “raw” timestamp format was discussed here:
Forum - PLCnext Community PLCnext Technology from Phoenix Contact is a unique, open ecosystem for modern automation that is capable of meeting all the challenges of the IoT world.
That refers to an earlier conversation, which is here:
Hello,</p>\nI am testing the native datalogger in the PLCnext Engineer 2020.6. I have made the configuration in PLCnext Engineer and it seems to be working.</p>\nBut it is not clear the timestamp format presented in the database. The timestamp number in the database is like this: 5249009445093906144 (see picture attached).</p>\nWhat is the timestamp format saved in the database ? How can I convert it to data/time format ?</p>\nI have tried a lot of timestamp converter in internet but none of them recognized the format. I have tried to configure the Datalogger with RAW and ISO 8601 option, but the number format in Database was the same.</p>\nOther question about Dataloger is the difference of Sample Interval and Publish Interval. It is not clear for me. Could you explain me ?</p>\nThank you,</p>\nSidnei Marcondes</p>
… and that refers to an even earlier conversation, which is here:
Hello,</p>\nI am trying to launch the example of the datalogger-rt.</p>\nI have installed the datalogger service and the database is not created.</p>\nI have updated the firmware to version 2009.6 but I still can’t generate the database.</p>\nI think the code is same as the video tutorial but it doesn´t work.</p>\nIs the project source code available?</p>\nRegards,</p>
I hope that this information answers your question.