Json Export feature

[asbiin]

Json export is in preview mode. Tell us what you think about it.

This feature allows you to export all your data as a json file.
There is no import feature for now.

Found export in Settings > Export data of your application, like https://app.monicahq.com/settings/export.

[Neriderc]

Looking good! One of my concerns with Monica has been the "exit plan". What happens in 10 years (or 20) when I've accumulated all this data, but the software isn't being maintained and there aren't any viable forks? I have all this valuable data, but eventually I won't be able to access it anymore.

Having this export means I can at least be confident that I can take the data in a standard format and pull what I need from it, in a way that the SQL export may have allowed but I'm happier to see this JSON option appear.

One suggestion for user friendliness, I click the button to export and after 30 seconds I received a timeout error. I thought it hadn't worked, until I made my way back to the page and found it was running in the background, and eventually I could see a download link. I'd suggest maybe just triggering the background process and maybe show a message saying it has started, maybe add the process to the page without a refresh, something like that.

If it helps, I'm running the official docker image on a Raspberry Pi 4 (8GB).

[Brice187]

Import Option would be nice

[asbiin]

One suggestion for user friendliness, I click the button to export and after 30 seconds I received a timeout error. I thought it hadn't worked, until I made my way back to the page and found it was running in the background, and eventually I could see a download link. I'd suggest maybe just triggering the background process and maybe show a message saying it has started, maybe add the process to the page without a refresh, something like that.

SQL export can take some times. It's working well on a batched job (with a queue). When you have a queue, there is no timeout on the UI, the job will indeed run in the background, and the user will get a notification. But I understand that it would be nice to have a "refresh" button, or if the table can be refreshed automatically.

Thank you

[cstrat]

I am always a fan of being able to export data and like @Neriderc said, JSON is a great addition to the SQL export.

My instance also timed out after 30 seconds and I thought it wasn't working.
I am still waiting but it shows this when I navigate back.

Similar to @Neriderc I am running my own instance (supporting via Patreon).

[asbiin]

Json export seems to be memory-consuming. It's working well on batched job (with a queue). Definitely a good way to improve performances of your instance!

[cstrat]

Thanks for the continued development. Mine works, but I appear to have a stuck attempt.

Surely this doesn't matter, but it would be nice if I could clear this.

[jatls]

JSON Export worked a treat on a self-hosted instance. Even got an email notification when complete. Nice touch!

Is the roadmap to replace the SQL export with JSON? Or to have both available in to the future?

[asbiin]

I don't think we will maintain SQL export when JSON export is working 100%. SQL export current implementation is not reliable, it's limited to the exported data, it does not contain extra-resources like photos and documents, ...

[AndyYangUK]

Just tried it and it worked well. Can't wait for the import function when I inevitably mess up the install and have to start again!

[aluhrs13]

I really like this. I have scripts that make JSON from as much of my personal data as possible so I can transform them into different formats and search across sources. Import of course would be nice, but export is definitely appreciated.

[crazyboy24]

can you share that script?

[michaelhochleitner]

Love it! Opening and searching json is much more comfortable than sql.
To download the json I click on "Export to Json" then open my email inbox and wait for the email notification and then click the link in the email notification. At the first time using it I thought that the "Submitted" Status would automatically change when the download is ready. Refreshing the page is needed for the Status to update.

[ChargingBulle]

Both exports are not working for me

[wolf-rainer]

Same issue here.
See workarounfd from #5917 - even though FE showing failed, the exports are created and available from app container.

[fruwajek]

Hello,
on my instance, I hava the same problem, every export reported a bug.
I use Monica v 3.7.0 on Docker in my RPi with mariaDB.

Mariadb doesn't show any log about export data, someone have a solution of this problem?
Thanks.

[wolf-rainer]

Not sure about MariaDB, but maybe check the answer above:
Check if your exports in fact are successfully created and listed in the app container under /var/www/html/storage/app/public/exports/.

[wolf-rainer]

Also from me both thumbs up for JSON export!
Great feature!

Although having 'Failed' after ca. 30 seconds issue for both export types in GUI, the files ARE created and accessible in app container. (I'm running Monica 3.7.0 on Raspberry cluster Docker swarm).

JSON is so much easier to parse and reuse in any programming language.

[expionage]

+1 same issue.

I logged this as well as Issue #6441.

[teslazap]

I have a fresh official docker install and 1 contact

[kyeotic]

Is import feature planned?