Not able to sync logbook to other system due to encryption/hashing

[navelso]

Hi,

we have been using VisionApp for a long time and have had a synchronisation of the logbook to our racktables. This is a very useful function for us.

In 2015 the details column in the logs table has some kind of encryption or hashing.

We need the possibility to turn off the encryption/hashing or some other way to access the logs directly for sync. What will you suggest?

[DevOma]

Would it be useful for you if we add a export of the logs by command line? All data is serialized to prevent changes of the scheme with any new data so it could not be turned off...

[navelso]

Possibly I could use that, provided the export could be done with a few options, not a full export each time. As a minimum one must be able to choose which brand of log to export and to set a time frame.

Is there no way to get this out in clear text via SQL?

[DevOma]

I think not - I have an idea that I can check - SQL Server can use .NET - perhaps it is possible to deserialize inside SQL - but I never tried that before - I will have a look, else I try to integrate export of logs with some options for the next patch

[navelso]

Have you been able to take a look at this?

[DevOma]

Export of logs is implemented for Patch4 - at the moment Prio1 is reintegrate MultiEdit - is nearly finished but not tested so far

After that I will investigate some time in this

[navelso]

Hi,

would really appreciate a solution to this problem.

[DevOma]

I spend some time on this topic - but it's not working correctly - SQL server seems not be able to load serialization objects from dll

[navelso]

Hi, any progress on this issue?

[DevOma]

As I told you - direct access from sql is not possible - did you try to use the export from command line?