New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Export data as CSV with nightly backup #713

Open
fmcpherson opened this Issue Dec 19, 2017 · 2 comments

Comments

Projects
None yet
4 participants
@fmcpherson

fmcpherson commented Dec 19, 2017

Monica needs an easy way to back up data. It currently has an Export Data function that is designed for a use case of someone moving from the hosted version of Monica to the personal version and assumes the person doing it has MySQL experience because the data is in SQL format.

The ideal solution would be an export to a CSV file that could be scheduled to occur nightly. Further, the data should be encrypted, as should all of Monica's data, but encryption could be a later release. For now the primary importance is providing simple backup to protect from data loss.

@djaiss djaiss changed the title from Back Up Data to Export data as CSV with nightly backup Dec 19, 2017

@hexnet

This comment has been minimized.

Contributor

hexnet commented Dec 31, 2017

When you say, ideally a CSV, would an SQL dump still not be better so you can import this data back into a Monica instance?
The project utilises task scheduling so could dump a tar gzipped archive passworded using a password specified in Account Settings.
Furthering on from this, to provide help from physical data loss, a destination (SFTP/S3/email) for the file to be delivered to.

@saulpw

This comment has been minimized.

saulpw commented Nov 26, 2018

I would like a way to export as .csv or .tsv or .json, so I can import it into other tools. The existing .sql that I get from monicahq.com is okay but it needs CREATE TABLE statements so I don't have to stand up a monica instance to use the data.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment