sql version

[Carpet Nailz]

I don't know how much work it would take, but what about a little widget
that, when you run it, splits off all transactions after 1/1/2011
00:00:00 into a new GnuCash file with the same acct structure and
starting balances as of 1/1/2001? Until one has finished with, say, 9x%
of 2010 transactions, one just continues with the old file. Once one
starts the new file, the widget could either update it as late 2010
transactions dribble in (e.g., April 15th in the US), or one could
manually make those few adjustments to the 2011 starting balances? (As I
understand it, for many business urposes, at least, closing transactions
are necessary at the end of the (fiscal) year anyway.

Does this make any sense?

On Fri, 2010-12-24 at 14:03 -0500, Anthony Dardis wrote:
> That would be slick!
> 
> I use the Opera browser's embedded mail program, and that's a constant  
> question: even though you *can* have 10 years of mail in the database, and  
> you might really want it all, it would be nice to have less. The best  
> archive suggestion I ever saw over there was pretty much the one Quicken  
> uses (used?): it makes a copy of your state at the backup time, then  
> closes out (deletes transactions older than a given date, sets starting  
> balances, etc.). So "moving an archive time line" is a matter of opening  
> an old file, which will have no effect on the current file. Looks like  
> Quicken really ought to implement this suggestion too!
> 
> 
> On Fri, 24 Dec 2010 13:48:40 -0500, Michelle Knight  
> <michelle at msknight.com> wrote:
> 
> > I do find myself wishing that I could do as I do with some e-mail systems
> > ...move an archive time line ... so that if I needed to adjust something  
> > a
> > couple of years ago, I can move the archive line back to that time  
> > period,
> > make the change, let everything re-calculate itself and then move the  
> > archive
> > line back forward again so there are only a certain number of items to  
> > handle.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.