On Tue, Feb 02, 2021 at 09:44:44AM -0500, Derek Atkins wrote: > 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? > > > > Try saving it as XML, and then opening it, and then Save-As Sqlite > Yes, that works, thanks Derek. I suppose it's not too onerous as I only do it once a year! :-)
-- 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.