[GNC] New to GnuCash SQLite on Windows: I have questions

[David Carlson]

I would like to add a question to Tom's list.  Is there any way to easily
make periodic backups of SQLite data files?

On Tue, Apr 19, 2022 at 8:21 PM Derek Atkins <derek at ihtfp.com> wrote:

> Hi,
>
> On Tue, April 19, 2022 7:55 pm, Tom Browder wrote:
> > I just updated my MS Windows GnuCash version to 4.10 and see the new
> > option
> > to save my GnuCash xml file in SQLite format. In general, I like it!
> >
> > However, I had a few moments of panic when Windows wanted to save the
> file
> > without a name change.  I also forgot the changes in the SQLite file are
> > done without notice.
> > (When I first started withGnuCash on Windows, I was able to unzip the xml
> > file and save it unzipped as "myGnuCash.gnucash" successfully so I get
> > version control over a text file for readable diffs.)
> >
> > 1. Is there any way to get GnuCash to save its file, by default, with an
> > appropriate suffix other than "gnucash?"
>
> Sure, tell it to do that.  It only adds ".gnucash" by default, but it
> won't override what you tell it.
>
> > 2. Is there any hope of some kind of "commit" button to use with the
> > SQLite
> > version?
>
> The benefit of the SQL backend is that it writes all changes when you
> commit (enter) a transaction.  So no, there will not be a "Save" button.
> The "commit" button is the "Enter" key (or exiting out of a transaction
> edit).
>
> > 3. I assume the binary SQLite file is usable with a binary copy from
> > Windows, is that true?
>
> I'm not sure I understand this question, but the SQLite data file is
> usable from any platform.
>
> > 4. Is there any Perl program on Windows to convert the xml file to
> SQLite?
> > Is there one on Linux?
>
> No.  Open the XML in GnuCash and then File -> Save As to save it as SQLite.
>
> > My immediate goal is to continue using my xml fille on Windows as the
> > master data source until I'm comfortable with the SQLite version. During
> > that time, I will periodically produce an SQLite version as a read-only
> > one
> > to experiment with on Linux.
> >
> > I would love to do that automatically.
>
> You mean without using File -> Save As?
>
> > I have briefly looked at the (ugh) Python support and may go down that
> > route, but not until I've looked at compiling from github on Linux and
> > looked at what's available.
>
> Yes, you may be able to use the Python bindings to open the XML file and
> SaveAs SQL.  I've never tried it.
>
> > Thanks for any help or suggestions.
> >
> > -Tom
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>        Derek Atkins                 617-623-3745
>        derek at ihtfp.com             www.ihtfp.com
>        Computer and Internet Security Consultant
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
>


-- 
David Carlson