GNOME Bugzilla – Bug 562848
it is unclear how to go back to xml backend from sql backend
Last modified: 2018-06-29 22:13:18 UTC
Hi, this issue should probably be fixed alongside bug 562841. There is no obvious way to go back from an SQL backend to an XML backend. In fact, I thought "Save as" would do that, but it defaulted to sqlite for file format. Overwriting an XML file will get gnucash to export SQL to XML, though, as I found out later. I think the best way would be an option to explicitly specify the backend in the "Save As" dialog. Regards Rolf
*** Bug 562841 has been marked as a duplicate of this bug. ***
*How* should it be integrated? How should the GUI look like instead? The save dialog is the stock Gtk dialog where we can't easily change the GUI. Feel free to submit a patch; otherwise this won't happen.
We could use the Gtk save widget and embed it in a dialog along with the db connection information. This could also allow a selection between sqlite3 and xml storage. The same thing would be done for the open dialog.
I am increasing the importance for this to critical because of a potential for data loss Start up a dbi-enabled gnucash from svn. Try to save your data back to XML by overwriting an old xml file you have for the purpose. You'll be warned that the file exists and if you want to do that. Everything will seem smooth sailing. But when you close and reopen that XML file, you'll see that while the account structure apparently has survived intact, your splits did not. All accounts are at 0. Somebody please verify.
(In reply to comment #4) > I am increasing the importance for this to critical because of a potential for > data loss > > Start up a dbi-enabled gnucash from svn. Try to save your data back to XML by > overwriting an old xml file you have for the purpose. You'll be warned that > the file exists and if you want to do that. Everything will seem smooth > sailing. But when you close and reopen that XML file, you'll see that while > the account structure apparently has survived intact, your splits did not. All > accounts are at 0. > > Somebody please verify. I cannot reproduce that with r17897. Also, please open a separate bug if saving a copy of an sqlite file fails in certain circumstances. Lowering this one again.
Implemented in trunk r17989
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=562848. Please update any external references or bookmarks.