How to read/open mdtxn files

Marco's Avatar

Marco

17 Dec, 2022 01:50 PM

Hi all,
I hope I posted this in the right spot.

I know that the mdtxn files used to synchronise the various devices are encrypted (as far as I understood with symmetric AES256), but obviously we have the password of our own data.
Is there a way to decrypt them and, if yes, once decrypted, to read them (xml? JSON? Etc.)?
I’m asking because I’m building my own reporting in Power BI, but every time I need to export the data manually in JSON and to do that I have to be in front of my laptop.

Leveraging instead the standard sync functionality I can update my reporting (almost) real time as soon as I enter a new transaction on my mobile app.

Any hint is appreciated
Thanks
Marco

  1. 1 Posted by Stuart Beesley ... on 17 Dec, 2022 04:33 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Hint 1. Toolbox advanced mode allows you to look inside these. Have a go….

    Hint 2. Look at the toolbox source code.

    Hint 3. Shout if you need more help?

  2. 2 Posted by Stuart Beesley ... on 17 Dec, 2022 04:33 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Hint 4. Toolbox can also decrypt your whole dataset in one go….

  3. 3 Posted by Marco on 18 Dec, 2022 10:19 AM

    Marco's Avatar

    Thank you Stuart, I’ll have a look
    Cheers
    Marco

  4. System closed this discussion on 19 Mar, 2023 10:20 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac