You can save as XML, make your changes, then save as SQLite again. I've
bounced back and forth several times without issue.
You can also do an export to csv, make edits in a spreadsheet, then
import the corrected transactions, and just delete the Imbalance account
and all transactions in it.
(that would be the better option as directly changing the file outside
of GnuCash is not supported, though it may work)
Regards,
Adrien
On 1/31/21 2:26 PM, Jeff Rizzo wrote:
On 1/31/21 12:05 PM, Stephen M. Butler wrote:
PS If using a database back-end and you have experience as a database
admin or programmer then use the database tools to effect the
changes. Again, make that backup first and loop around as needed
until GnC looks good.
Yeah, since I'm using the sqlite back end I'd already thought about this
but was hoping there's a better way - I'll see how this goes. Last year
at the job I had at the time I had to scold the software designers every
time I came across an admin function that required going to the database
directly - because we all know how bad an idea it is. :)
_______________________________________________
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.
