Re: ROOT Type accounts

[Colin Law]

On 31 October 2016 at 06:39, David T. via gnucash-devel <
gnucash-devel@gnucash.org> wrote:

> OK, so I deleted these entries in the file. Now, when I open the file in
> GnuCash, the progress bar does a little "zippy back and forth” thing while
> loading the user data that I haven’t seen before. Also, there is new empty
> top level account with a guid as its name. This guid doesn’t appear in
> accounts, splits, or transactions, however. Not sure what to do differently.
>

If the extraneous root accounts were not doing any harm then I would just
leave them and not worry about it.

Colin


>
> Maybe it’s not important?
>
> David
>
> > On Oct 29, 2016, at 5:54 PM, Geert Janssens 
> wrote:
> >
> > On Saturday 29 October 2016 17:33:40 David T. wrote:
> >> OK, so I opened the SQLite file in GnuCash, went to the COA and
> >> selected Check and Repair All. No change, unfortunately.
> >>
> > Yes, that's what I meant - check & repair should be the place to handle
> > this, but it currently doesn't.
> >
> > I see the way I replied to you could be interpreted differently. Sorry
> > about that.
> >
> >> I will try removing the rows manually and see what happens! This, of
> >> course is on a copy of my real data file. ;)
> >>
> > Wise, very wise :)
> >
> > Geert
>
>
> ___
> gnucash-devel mailing list
> gnucash-devel@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: ROOT Type accounts

[David T. via gnucash-devel]

OK, so I deleted these entries in the file. Now, when I open the file in 
GnuCash, the progress bar does a little "zippy back and forth” thing while 
loading the user data that I haven’t seen before. Also, there is new empty top 
level account with a guid as its name. This guid doesn’t appear in accounts, 
splits, or transactions, however. Not sure what to do differently.

Maybe it’s not important?

David

> On Oct 29, 2016, at 5:54 PM, Geert Janssens  
> wrote:
> 
> On Saturday 29 October 2016 17:33:40 David T. wrote:
>> OK, so I opened the SQLite file in GnuCash, went to the COA and
>> selected Check and Repair All. No change, unfortunately.
>> 
> Yes, that's what I meant - check & repair should be the place to handle 
> this, but it currently doesn't.
> 
> I see the way I replied to you could be interpreted differently. Sorry 
> about that.
> 
>> I will try removing the rows manually and see what happens! This, of
>> course is on a copy of my real data file. ;)
>> 
> Wise, very wise :)
> 
> Geert


___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: ROOT Type accounts

[Alex Aycinena]

>
>
>
> -- Forwarded message --
> From: Geert Janssens <geert.gnuc...@kobaltwit.be>
> To: "David T." <sunfis...@yahoo.com>
> Cc: gnucash-devel@gnucash.org
> Date: Sat, 29 Oct 2016 14:54:35 +0200
> Subject: Re: ROOT Type accounts
> On Saturday 29 October 2016 17:33:40 David T. wrote:
> > OK, so I opened the SQLite file in GnuCash, went to the COA and
> > selected Check and Repair All. No change, unfortunately.
> >
> Yes, that's what I meant - check & repair should be the place to handle
> this, but it currently doesn't.
>
> I see the way I replied to you could be interpreted differently. Sorry
> about that.
>
> > I will try removing the rows manually and see what happens! This, of
> > course is on a copy of my real data file. ;)
> >
> Wise, very wise :)
>
> Geert
>


Also, I'm curious if saving the file as xml and then recreating the SQLite
file from the xml might clean it up, if it was initially created by a bug
that has since been fixed. Might be easier than messing around with
manually removing the rows, if it works.

Alex
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: ROOT Type accounts

[Geert Janssens]

On Saturday 29 October 2016 17:33:40 David T. wrote:
> OK, so I opened the SQLite file in GnuCash, went to the COA and
> selected Check and Repair All. No change, unfortunately.
> 
Yes, that's what I meant - check & repair should be the place to handle 
this, but it currently doesn't.

I see the way I replied to you could be interpreted differently. Sorry 
about that.

> I will try removing the rows manually and see what happens! This, of
> course is on a copy of my real data file. ;)
> 
Wise, very wise :)

Geert
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: ROOT Type accounts

[David T. via gnucash-devel]

OK, so I opened the SQLite file in GnuCash, went to the COA and selected Check 
and Repair All. No change, unfortunately.

I will try removing the rows manually and see what happens! This, of course is 
on a copy of my real data file. ;)

David

> On Oct 29, 2016, at 5:13 PM, Geert Janssens  
> wrote:
> 
> On Saturday 29 October 2016 15:14:55 David T. via gnucash-devel wrote:
>> Hi,
>> 
>> I am digging around in the SQL database, and I am noticing that the
>> accounts table for my data has 46 ROOT type entries.
>> 
>> Checking in GnuCash, I have 6 top level accounts (Assets, Equity,
>> Expenses, Income, Liabilities, and Special Accounts).
>> 
>> Back in the SQL, only one of the 46 has a name entry (“Root account”);
>> the remainder have nothing in the name field. Examining the entries a
>> little closer, I see that these empty root accounts seem to form a
>> single chain whose commodity for each is ‘template’. I am curious
>> what these other 45 ROOT accounts might be.
>> 
>> What is this chain, what purpose does it serve, and is it supposed to
>> be there?
>> 
>> TIA,
>> David
> 
> These root accounts shouldn't be there. They are the side effect of a 
> bug that got fixed some time back. I can't immediately find the details 
> of this. In principle only one root account should be there and the 
> others can be removed (provided no other account is referring to these 
> bogus root accounts). Ideally the check & repair function should handle 
> this.
> 
> Regards,
> 
> Geert
> 


___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: ROOT Type accounts

[Geert Janssens]

On Saturday 29 October 2016 15:14:55 David T. via gnucash-devel wrote:
> Hi,
> 
> I am digging around in the SQL database, and I am noticing that the
> accounts table for my data has 46 ROOT type entries.
> 
> Checking in GnuCash, I have 6 top level accounts (Assets, Equity,
> Expenses, Income, Liabilities, and Special Accounts).
> 
> Back in the SQL, only one of the 46 has a name entry (“Root account”);
> the remainder have nothing in the name field. Examining the entries a
> little closer, I see that these empty root accounts seem to form a
> single chain whose commodity for each is ‘template’. I am curious
> what these other 45 ROOT accounts might be.
> 
> What is this chain, what purpose does it serve, and is it supposed to
> be there?
> 
> TIA,
> David

These root accounts shouldn't be there. They are the side effect of a 
bug that got fixed some time back. I can't immediately find the details 
of this. In principle only one root account should be there and the 
others can be removed (provided no other account is referring to these 
bogus root accounts). Ideally the check & repair function should handle 
this.

Regards,

Geert


___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

ROOT Type accounts

[David T. via gnucash-devel]

Hi,

I am digging around in the SQL database, and I am noticing that the accounts 
table for my data has 46 ROOT type entries. 

Checking in GnuCash, I have 6 top level accounts (Assets, Equity, Expenses, 
Income, Liabilities, and Special Accounts). 

Back in the SQL, only one of the 46 has a name entry (“Root account”); the 
remainder have nothing in the name field. Examining the entries a little 
closer, I see that these empty root accounts seem to form a single chain whose 
commodity for each is ‘template’. I am curious what these other 45 ROOT 
accounts might be. 

What is this chain, what purpose does it serve, and is it supposed to be there?

TIA,
David
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel