Try saving it as XML, and then opening it, and then Save-As Sqlite -derek
On Tue, February 2, 2021 9:37 am, Chris Green wrote: > On Wed, Jan 20, 2021 at 08:07:07AM -0500, D. wrote: >> > Is there any easy way to create a set of empty copies of an existing >> > set of accounts so I can start the new year easily? >> >> File -> Export -> Export Accounts >> > Well, I have been trying to do this but it doesn't work. > > I am using gnucash with sqlite on Linux. > > The first problem is that one *always* gets the file lock issue if you > do this because the new database created by the export always has the > lock table in it. This isn't a big issue of course because you can > ignore the message or remove the lock table. > > However the saved accounts database is somehow broken. > > I have done the following:- > > Start gnucash with "gnucash general.gnucash" > > Select File->Export->Export Accounts > > Set the data format to sqlite3 > > Save as 'newyear' > > Quit from gnucash > > Run "gnucash newyear.gnucash" > > Click "Start anyway" when the lock file message pops up > > I then get a pop-up window saying "An error occurred while > processing /home/chris/pcc/2020/newyear.gnucash" > > > So how do I get this to work? > > -- > Chris Green > _______________________________________________ > 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. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant _______________________________________________ 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.