[GNC] End of year, how to clone a set of accounts for the new year?

Chris Green cl at isbd.net
Tue Feb 2 10:03:35 EST 2021


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


More information about the gnucash-user mailing list