[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