Re: [GNC] Is there a Save As command line option
Steve, One possibility is to use synchronized data bases using master-slave replication. I know this works with MySQL and it is a bit of a pain to set up but once it is going it is generally pretty good. Also a bit of a pain to restart if the replication gets out of sync. I have been meaning to setup scripts to do that but haven't yet got around to it. I keep several database on my laptop and desktop in sync automatically. Not sure about PostGRES or sqlite3 replication capability. Also if you have Dropbox or similar access you can store the GnuCash files in a Dropbox and access it from multiple devices. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Is there a Save As command line option
Hi. Only thing I can think of would be using the python bindings to load the xml and then save it as sql. I have no idea how you would do it, but I think it's your best bet. Good luck! -derek Sent using my mobile device. Please excuse any typos. On June 16, 2018 9:25:19 AM salex wrote: I've been using GnuCash for about 4 years on a Mac as the sole user with a custom sharing/archive procedure. The accounting book is for a Veterans of Foreign Wars (VFW) post which I volunteered to maintain. I now have a need to have another person to access and update the data. My current sharing procedure is: I do a "Save As" to sqlite3 file (then immedialtly reopen the XML version) Still leery of using SQL backends as the datastore (I'd rather use Postgres but have not tried that yet) I run a bash script on the mac that does a rsync of my gnucash directory (includes the sqlite3 version) to a debian server at the office. I usually do this about once a week (after a bank deposit and/or mini-reconcile with online banking) I have a Rails engine in our organization's web serve that can access the sqlite3 DB (read only) and provide custom reports, check registers and any thing else I want to write. I am training a new person to take over the accounting tasks, but will probably share some tasks. My plan was to use only the XML book on the debian server (I can get to it, and a windows machine at the office can get to it). Just have to remember to quit after any updates. If I'm not mistaken, GnuCash won't let you open a book that is open. I have a few obstacles. I can use cron to do a backup rsync to something offsite. I (me, not assistant - at least initially) have to do the "Save As" manually so the latest updates are available on the web site. (I also have to restart my Rails server after an update) I may be able to automate this some way, but not sure what way! That is why I was looking for a way the have a script do a "Save As" - that would be helpful. Just looking for any ideas were you are sharing a book on a server. Any comments on using Postgres as a shared environment would also be welcome. I can automate saving Postgres dumps. Steve Alex -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Is there a Save As command line option
I've been using GnuCash for about 4 years on a Mac as the sole user with a custom sharing/archive procedure. The accounting book is for a Veterans of Foreign Wars (VFW) post which I volunteered to maintain. I now have a need to have another person to access and update the data. My current sharing procedure is: I do a "Save As" to sqlite3 file (then immedialtly reopen the XML version) Still leery of using SQL backends as the datastore (I'd rather use Postgres but have not tried that yet) I run a bash script on the mac that does a rsync of my gnucash directory (includes the sqlite3 version) to a debian server at the office. I usually do this about once a week (after a bank deposit and/or mini-reconcile with online banking) I have a Rails engine in our organization's web serve that can access the sqlite3 DB (read only) and provide custom reports, check registers and any thing else I want to write. I am training a new person to take over the accounting tasks, but will probably share some tasks. My plan was to use only the XML book on the debian server (I can get to it, and a windows machine at the office can get to it). Just have to remember to quit after any updates. If I'm not mistaken, GnuCash won't let you open a book that is open. I have a few obstacles. I can use cron to do a backup rsync to something offsite. I (me, not assistant - at least initially) have to do the "Save As" manually so the latest updates are available on the web site. (I also have to restart my Rails server after an update) I may be able to automate this some way, but not sure what way! That is why I was looking for a way the have a script do a "Save As" - that would be helpful. Just looking for any ideas were you are sharing a book on a server. Any comments on using Postgres as a shared environment would also be welcome. I can automate saving Postgres dumps. Steve Alex -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
