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

[Derek Atkins]

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 at 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
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant