> On Jun 20, 2017, at 11:26 AM, Geert Janssens <geert.gnuc...@kobaltwit.be> > wrote: > > On dinsdag 20 juni 2017 18:06:17 CEST Adrien Monteleone wrote: >> I thought I had set this up with SQLite3, but this does make me question >> that. I tried looking for something that would tell me but I’m not seeing >> it. Certainly, trying to open the file directly, it is not uncompressed >> XML. > > You can always try to open it with a tool to edit sqlite files. Examples > would > be the command line tool sqlite3 on linux or the firefox extension SqLite > Manager.
Sorry, that was my next step. I was digging up an SQLite app when I read this. I didn’t know about that FF add-on though, thanks. It seems though, it can’t open this file, so I suspect it is XML. > > Another thing to try would be to uncompress the file using tools like 7-zip > (you probably have to add .gz as extension to the copy of your data file > first) and then check whether it looks like uncompressed xml. > Sure enough, I added .gz, then uncompressed, opened, and XML it is. >> >> Is there something in a log file or config file that might indicate which >> backend is presently in use? >> > The best indication is whether the save button on the toolbar enables when > you > make a change. If so, your file is xml (compressed or uncompressed). It is normally active after a change, yes. > >> And if it is XML, I don’t suppose I can switch can I? >> > Sure you can, just resave it using "Save As..." and select the sqlite file > format while saving. Sweet. Thanks! Working through this I noticed the file was named “2017.gnucash” which I though odd since I opened this book in 2016. I would have had no reason to name it “2017”. So I tried to name the new file “personal” and that was already existing. I opened that file, which was sqlite3, and the last transaction was Jan 17, 2017. I don’t recall this at all, but apparently on or shortly after 1/17/17, I did a Save As…, changed the name, and I guess I didn’t notice the file type bar at the top of the dialog window which is how I ended up with an XML format. Sorry for taking up your time, but thank you for helping me sort this out. Regards, Adrien > > Regards, > > Geert _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.