Re: [GNC] GNU Cash on a Central Computer

[randix]

fixed it, thanks.

that explains my question re dropbox usage.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Error with Asset Chart report

[D. via gnucash-user]

Further to this: you asked whether the problem occurs with level All. 
Interestingly, this option does result in the error occurring again. 

However, when All is selected, the default report triggers the error with a 
different option number and a different number of iterations. This time, the 
erroneous value is indicated as '11', and it only occurs once. When 6 is 
selected, increasing the number of slices changes the number of times the error 
is iterated, although there isn't an apparent correlation between the slices 
shown and the number of errors. In other words, when I increase the number of 
slices by one (from the default 8 to 9), the added slice in the display is not 
at the seventh level, but the error is now repeated twice. The iterations do 
not change with the All setting; they remain at 1 regardless of the number of 
slices. 

I've looked at this more extensively now. I tried other "Slice-based" reports, 
under the assumption that their logic would cause similar results. I include my 
observed results below. I list the setting, followed by the error iteration in 
parentheses when the default settings are used, with only the depth value 
changed. In all cases, the All error was for option 11, and the 6 error was for 
option 7.

Asset Chart (resulting tab is titled "Assets Over Time"): All (1)   6 (6)
Asset Piechart (resulting tab is titled "Assets"): All (0)   6 (5)
Liability Chart (resulting tab is titled "Liabilities Over Time"): All (1)    6 
(2)
Liability Piechart (resulting tab is titled "Liabilities"): All (1)  6 (2)

It is interesting that the Asset Piechart didn't trigger any errors with the 
All setting. That was the only clean version. 

I will note that when I initially ran the Liability reports, I received no 
errors. This was because I didn't have any liabilities accounts at level 7. To 
verify this, I added dummy levels to one of the liabilities to reach level 7, 
and the errors started up. Further, I am confident that the number of 
iterations for the error is directly related to the number of level 6 accounts 
with level 7 children. When I add a parallel set of dummy accounts down to 
level 7 on another branch in Liabilities, the error iteration goes up by one.

The mere presence of the level 7 account triggers errors. It didn't matter 
whether the dummy accounts had transactions in them, or whether the account was 
displayed in the resulting report. However, if the level 7 accounts are all 
empty, the error only triggers once. Adding a transaction to one of the dummy 
accounts increases the iteration to two, and adding to the other dummy also 
increases the iteration.  This suggests that there is some relation between the 
number of seventh level slices to be displayed (as opposed to simply existing), 
but a base problem with that level on principle. 

David


 Original Message 
From: Adrien Monteleone 
Sent: Sun Dec 06 15:22:14 EST 2020
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Error with Asset Chart report

I have about a dozen or more level-6 asset accounts. I don't have 
anything greater than level-6.

Can you reproduce if you try level-All? (there'd still be a bug in the 
level-6 option of course)

Regards,
Adrien

On 12/6/20 2:17 PM, D. via gnucash-user wrote:
> Adrien,
> 
> Does your CoA have accounts deep enough to trigger level 6? I can trigger the 
> error consistently whenever I select a set of accounts that includes accounts 
> below the sixth, and then make it go away simply by selecting accounts that 
> don't range below that depth.

___
gnucash-user mailing list
gnucash-user@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.

___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Error with Asset Chart report

[Adrien Monteleone]

That is quite interesting.

As noted, I don't have any >6 level Asset (or Liability) accounts. But I 
do have level-7 Expense accounts. I tried the Expense Chart & Expense 
Pie Charts, and both execute without errors for both All and '6' 
options. (and yes, those level-7 accounts have many transactions in them)


Now, this could still be an OS specific thing, but if those two work for 
you, perhaps Chris could merge the code from them to the other offending 
charts/reports.


I see he made a change to not report deeper than '6' but I haven't 
received clarification if that is just for the option '6' or for 'All' 
as well. (which would render reporting/charting deeper than level-6 
impossible.)


I'll see about creating some dummy level-7 asset accounts and try to 
trigger the error.


Regards,
Adrien

On 12/7/20 11:05 AM, D. via gnucash-user wrote:

Further to this: you asked whether the problem occurs with level All. 
Interestingly, this option does result in the error occurring again.

However, when All is selected, the default report triggers the error with a 
different option number and a different number of iterations. This time, the 
erroneous value is indicated as '11', and it only occurs once. When 6 is 
selected, increasing the number of slices changes the number of times the error 
is iterated, although there isn't an apparent correlation between the slices 
shown and the number of errors. In other words, when I increase the number of 
slices by one (from the default 8 to 9), the added slice in the display is not 
at the seventh level, but the error is now repeated twice. The iterations do 
not change with the All setting; they remain at 1 regardless of the number of 
slices.

I've looked at this more extensively now. I tried other "Slice-based" reports, 
under the assumption that their logic would cause similar results. I include my observed 
results below. I list the setting, followed by the error iteration in parentheses when 
the default settings are used, with only the depth value changed. In all cases, the All 
error was for option 11, and the 6 error was for option 7.

Asset Chart (resulting tab is titled "Assets Over Time"): All (1)   6 (6)
Asset Piechart (resulting tab is titled "Assets"): All (0)   6 (5)
Liability Chart (resulting tab is titled "Liabilities Over Time"): All (1)    6 
(2)
Liability Piechart (resulting tab is titled "Liabilities"): All (1)  6 (2)

It is interesting that the Asset Piechart didn't trigger any errors with the 
All setting. That was the only clean version.

I will note that when I initially ran the Liability reports, I received no 
errors. This was because I didn't have any liabilities accounts at level 7. To 
verify this, I added dummy levels to one of the liabilities to reach level 7, 
and the errors started up. Further, I am confident that the number of 
iterations for the error is directly related to the number of level 6 accounts 
with level 7 children. When I add a parallel set of dummy accounts down to 
level 7 on another branch in Liabilities, the error iteration goes up by one.

The mere presence of the level 7 account triggers errors. It didn't matter 
whether the dummy accounts had transactions in them, or whether the account was 
displayed in the resulting report. However, if the level 7 accounts are all 
empty, the error only triggers once. Adding a transaction to one of the dummy 
accounts increases the iteration to two, and adding to the other dummy also 
increases the iteration.  This suggests that there is some relation between the 
number of seventh level slices to be displayed (as opposed to simply existing), 
but a base problem with that level on principle.


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Error with Asset Chart report

[Adrien Monteleone]

I created several level-7 and level-8 asset accounts and put a 
transaction in one at level-8.


I then tried both the Bar & Pie charts, both using '6' and 'All' options 
and all executed properly without errors.


Perhaps something is amiss with one (or more) your accounts at that depth?

Maybe the type of asset account makes a difference. I created my tests 
as standard type Asset. (not any of the special types like AR, Stock, 
Fund, etc.)


Regards,
Adrien

On 12/7/20 11:23 AM, Adrien Monteleone wrote:

That is quite interesting.

As noted, I don't have any >6 level Asset (or Liability) accounts. But I 
do have level-7 Expense accounts. I tried the Expense Chart & Expense 
Pie Charts, and both execute without errors for both All and '6' 
options. (and yes, those level-7 accounts have many transactions in them)


Now, this could still be an OS specific thing, but if those two work for 
you, perhaps Chris could merge the code from them to the other offending 
charts/reports.


I see he made a change to not report deeper than '6' but I haven't 
received clarification if that is just for the option '6' or for 'All' 
as well. (which would render reporting/charting deeper than level-6 
impossible.)


I'll see about creating some dummy level-7 asset accounts and try to 
trigger the error.


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Error with Asset Chart report

[David T. via gnucash-user]

Odd.

I don't think it has to do with the account type, since I replicated the 
problem for both assets and liabilities accounts.


I don't believe my accounts have something in them that could generate 
this error. I've been able to create a brand new file with an account 
structure and just a few transactions in it that (on my machine) exhibit 
these errors. I attach that test file here. For me, this file generates 
errors when I run either the Asset Chart or the Liability Chart reports.


To reiterate, I am running Windows 10 with Gnucash 4.2 (nightly build 
from 2020-11-21). I predict that you will not see any errors on your 
Mac. I wonder if another Windows user experiences this problem with this 
file.


David


*From:* Adrien Monteleone
*Sent:* Mon Dec 07 12:31:07 EST 2020
*To:* gnucash-u...@lists.gnucash.org
*Subject:* Re: [GNC] Error with Asset Chart report

I created several level-7 and level-8 asset accounts and put a
transaction in one at level-8.

I then tried both the Bar & Pie charts, both using '6' and 'All' options
and all executed properly without errors.

Perhaps something is amiss with one (or more) your accounts at that depth?

Maybe the type of asset account makes a difference. I created my tests
as standard type Asset. (not any of the special types like AR, Stock,
Fund, etc.)

Regards,
Adrien

On 12/7/20 11:23 AM, Adrien Monteleone wrote:

   That is quite interesting. As noted, I don't have any >6 level Asset
   (or Liability) accounts. But I do have level-7 Expense accounts. I
   tried the Expense Chart & Expense Pie Charts, and both execute
   without errors for both All and '6' options. (and yes, those level-7
   accounts have many transactions in them) Now, this could still be an
   OS specific thing, but if those two work for you, perhaps Chris
   could merge the code from them to the other offending
   charts/reports. I see he made a change to not report deeper than '6'
   but I haven't received clarification if that is just for the option
   '6' or for 'All' as well. (which would render reporting/charting
   deeper than level-6 impossible.) I'll see about creating some dummy
   level-7 asset accounts and try to trigger the error. 





gnucash-user mailing list
gnucash-user@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 
seehttps://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.



Level Best.gnucash
Description: application/gnucash
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Error with Asset Chart report

[David T. via gnucash-user]

Thank you. Yes. At least now I know that it's not just my personal 
electromagnetic signature causing the problem.


As for the levels on display, if you've followed the thread (and even my 
eyes glaze over reading through it), you will know that I am quite 
puzzled about this error.


David T.

On 12/7/2020 2:59 PM, David H wrote:

You mean this error :-)

Running on Gnucash 4.2 on Win 10 Pro.  If I click the error it 
re-displays, click again and it shows the chart but only levels 4 & 6 ??


Cheers David H.


On Tue, 8 Dec 2020 at 04:47, David T. via gnucash-user 
mailto:gnucash-user@gnucash.org>> wrote:


Odd.

I don't think it has to do with the account type, since I
replicated the
problem for both assets and liabilities accounts.

I don't believe my accounts have something in them that could
generate
this error. I've been able to create a brand new file with an account
structure and just a few transactions in it that (on my machine)
exhibit
these errors. I attach that test file here. For me, this file
generates
errors when I run either the Asset Chart or the Liability Chart
reports.

To reiterate, I am running Windows 10 with Gnucash 4.2 (nightly build
from 2020-11-21). I predict that you will not see any errors on your
Mac. I wonder if another Windows user experiences this problem
with this
file.

David


*From:* Adrien Monteleone
*Sent:* Mon Dec 07 12:31:07 EST 2020
*To:* gnucash-u...@lists.gnucash.org

*Subject:* Re: [GNC] Error with Asset Chart report

I created several level-7 and level-8 asset accounts and put a
transaction in one at level-8.

I then tried both the Bar & Pie charts, both using '6' and 'All'
options
and all executed properly without errors.

Perhaps something is amiss with one (or more) your accounts at
that depth?

Maybe the type of asset account makes a difference. I created my tests
as standard type Asset. (not any of the special types like AR, Stock,
Fund, etc.)

Regards,
Adrien

On 12/7/20 11:23 AM, Adrien Monteleone wrote:

    That is quite interesting. As noted, I don't have any >6 level
Asset
    (or Liability) accounts. But I do have level-7 Expense accounts. I
    tried the Expense Chart & Expense Pie Charts, and both execute
    without errors for both All and '6' options. (and yes, those
level-7
    accounts have many transactions in them) Now, this could still
be an
    OS specific thing, but if those two work for you, perhaps Chris
    could merge the code from them to the other offending
    charts/reports. I see he made a change to not report deeper
than '6'
    but I haven't received clarification if that is just for the
option
    '6' or for 'All' as well. (which would render reporting/charting
    deeper than level-6 impossible.) I'll see about creating some
dummy
    level-7 asset accounts and try to trigger the error.




gnucash-user mailing list
gnucash-user@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
seehttps://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.

___
gnucash-user mailing list
gnucash-user@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.


___
gnucash-user mailing list
gnucash-user@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 

Re: [GNC] Error with Asset Chart report

[David H]

I did wonder about that sig :-)  Initially I got a "no txns" error from the
report options, had to change the report currency to US$ - I don't normally
bother with running reports, never had much use for them even with all the
accounts I've got.  It would seem to suggest that perhaps a different
report version has maybe been packaged up with the Windows installer
version.  Will try on MacOS Big Sur as well and also see if I can compare
the report sources and see if they are different

Will advise further.

Cheers David H.


On Tue, 8 Dec 2020 at 06:08, David T.  wrote:

> Thank you. Yes. At least now I know that it's not just my personal
> electromagnetic signature causing the problem.
>
> As for the levels on display, if you've followed the thread (and even my
> eyes glaze over reading through it), you will know that I am quite puzzled
> about this error.
>
> David T.
> On 12/7/2020 2:59 PM, David H wrote:
>
> You mean this error :-)
>
> Running on Gnucash 4.2 on Win 10 Pro.  If I click the error it
> re-displays, click again and it shows the chart but only levels 4 & 6 ??
>
> Cheers David H.
>
>
> On Tue, 8 Dec 2020 at 04:47, David T. via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
>> Odd.
>>
>> I don't think it has to do with the account type, since I replicated the
>> problem for both assets and liabilities accounts.
>>
>> I don't believe my accounts have something in them that could generate
>> this error. I've been able to create a brand new file with an account
>> structure and just a few transactions in it that (on my machine) exhibit
>> these errors. I attach that test file here. For me, this file generates
>> errors when I run either the Asset Chart or the Liability Chart reports.
>>
>> To reiterate, I am running Windows 10 with Gnucash 4.2 (nightly build
>> from 2020-11-21). I predict that you will not see any errors on your
>> Mac. I wonder if another Windows user experiences this problem with this
>> file.
>>
>> David
>>
>> 
>> *From:* Adrien Monteleone
>> *Sent:* Mon Dec 07 12:31:07 EST 2020
>> *To:* gnucash-u...@lists.gnucash.org
>> *Subject:* Re: [GNC] Error with Asset Chart report
>>
>> I created several level-7 and level-8 asset accounts and put a
>> transaction in one at level-8.
>>
>> I then tried both the Bar & Pie charts, both using '6' and 'All' options
>> and all executed properly without errors.
>>
>> Perhaps something is amiss with one (or more) your accounts at that depth?
>>
>> Maybe the type of asset account makes a difference. I created my tests
>> as standard type Asset. (not any of the special types like AR, Stock,
>> Fund, etc.)
>>
>> Regards,
>> Adrien
>>
>> On 12/7/20 11:23 AM, Adrien Monteleone wrote:
>>
>> That is quite interesting. As noted, I don't have any >6 level Asset
>> (or Liability) accounts. But I do have level-7 Expense accounts. I
>> tried the Expense Chart & Expense Pie Charts, and both execute
>> without errors for both All and '6' options. (and yes, those level-7
>> accounts have many transactions in them) Now, this could still be an
>> OS specific thing, but if those two work for you, perhaps Chris
>> could merge the code from them to the other offending
>> charts/reports. I see he made a change to not report deeper than '6'
>> but I haven't received clarification if that is just for the option
>> '6' or for 'All' as well. (which would render reporting/charting
>> deeper than level-6 impossible.) I'll see about creating some dummy
>> level-7 asset accounts and try to trigger the error.
>>
>>
>> 
>>
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user  <
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>> If you are using Nabble or Gmane, please seehttps://
>> wiki.gnucash.org/wiki/Mailing_Lists  <
>> 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.
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@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.
>>
>
___
gnucash-user mailing list
gnucash-user@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.g

Re: [GNC] Error with Asset Chart report

[David H]

And also using the Flatpak version 4.2 on Ubuntu.  I'm guessing Adrien
compiles his own version - maybe that's why he doesn't see the error, I
always download the compiled version and install it ???

Cheers David H.

On Tue, 8 Dec 2020 at 06:43, David H  wrote:

> Ha ha - same result on MacOS Big Sur - see attached...
>
> Cheers David H.
>
> On Tue, 8 Dec 2020 at 06:08, David T.  wrote:
>
>> Thank you. Yes. At least now I know that it's not just my personal
>> electromagnetic signature causing the problem.
>>
>> As for the levels on display, if you've followed the thread (and even my
>> eyes glaze over reading through it), you will know that I am quite puzzled
>> about this error.
>>
>> David T.
>> On 12/7/2020 2:59 PM, David H wrote:
>>
>> You mean this error :-)
>>
>> Running on Gnucash 4.2 on Win 10 Pro.  If I click the error it
>> re-displays, click again and it shows the chart but only levels 4 & 6 ??
>>
>> Cheers David H.
>>
>>
>> On Tue, 8 Dec 2020 at 04:47, David T. via gnucash-user <
>> gnucash-user@gnucash.org> wrote:
>>
>>> Odd.
>>>
>>> I don't think it has to do with the account type, since I replicated the
>>> problem for both assets and liabilities accounts.
>>>
>>> I don't believe my accounts have something in them that could generate
>>> this error. I've been able to create a brand new file with an account
>>> structure and just a few transactions in it that (on my machine) exhibit
>>> these errors. I attach that test file here. For me, this file generates
>>> errors when I run either the Asset Chart or the Liability Chart reports.
>>>
>>> To reiterate, I am running Windows 10 with Gnucash 4.2 (nightly build
>>> from 2020-11-21). I predict that you will not see any errors on your
>>> Mac. I wonder if another Windows user experiences this problem with this
>>> file.
>>>
>>> David
>>>
>>> 
>>> *From:* Adrien Monteleone
>>> *Sent:* Mon Dec 07 12:31:07 EST 2020
>>> *To:* gnucash-u...@lists.gnucash.org
>>> *Subject:* Re: [GNC] Error with Asset Chart report
>>>
>>> I created several level-7 and level-8 asset accounts and put a
>>> transaction in one at level-8.
>>>
>>> I then tried both the Bar & Pie charts, both using '6' and 'All' options
>>> and all executed properly without errors.
>>>
>>> Perhaps something is amiss with one (or more) your accounts at that
>>> depth?
>>>
>>> Maybe the type of asset account makes a difference. I created my tests
>>> as standard type Asset. (not any of the special types like AR, Stock,
>>> Fund, etc.)
>>>
>>> Regards,
>>> Adrien
>>>
>>> On 12/7/20 11:23 AM, Adrien Monteleone wrote:
>>>
>>> That is quite interesting. As noted, I don't have any >6 level Asset
>>> (or Liability) accounts. But I do have level-7 Expense accounts. I
>>> tried the Expense Chart & Expense Pie Charts, and both execute
>>> without errors for both All and '6' options. (and yes, those level-7
>>> accounts have many transactions in them) Now, this could still be an
>>> OS specific thing, but if those two work for you, perhaps Chris
>>> could merge the code from them to the other offending
>>> charts/reports. I see he made a change to not report deeper than '6'
>>> but I haven't received clarification if that is just for the option
>>> '6' or for 'All' as well. (which would render reporting/charting
>>> deeper than level-6 impossible.) I'll see about creating some dummy
>>> level-7 asset accounts and try to trigger the error.
>>>
>>>
>>> 
>>>
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user  <
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>>> If you are using Nabble or Gmane, please seehttps://
>>> wiki.gnucash.org/wiki/Mailing_Lists  <
>>> 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.
>>>
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@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.
>>>
>>
___
gnucash-user mailing list
gnucash-user@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 thi

[GNC] bulk operations?

[Weiwu Zhang]

This issue comes up regularly with new users. The short answer to the 
question is,  "no, there is not a bulk edit."


Instead of discouraging people to ask this because it's already discussed 
and some suggestions are already archived, I feel starting the 
conversation again is the only way to call out the importance of this 
feature so we might have a formal solution that we can put into the 
document section. Gnucash cuts into the prosumer market where users do 
need such "advanced" features.


In fact I'm a bit disheartened that this question stopped reappearing 
sincer 2017. Previously it showed up roughly yearly. It might be a 
sign that there are less new users discovering gnucash, instead of 
people being more mature and stopped asking without searching into the 
archives.


The following is just an exmaple in 2017, the last year people still asked 
for this.


On Sun, May 7, 2017 at 8:07, Eric Theise wrote:


Suppose I'm in the "Search Results" window resulting from an "Edit >
Find..." operation. Is there any way to apply a change to every
transaction that appears?



Say that, due to history and multiple credit card accounts, a
grocer's Description appears as "HI HO", "hi ho grocery", "hi-ho
market", and permutations thereof. Is there any way to standardize
the name for everything in the result set besides manually changing
each line?



I'd also like to be able to perform bulk operations against
"Imbalance-USD" transactions.



If it's not possible through the GUI, how about via issuing SQL
statements to a database backend?


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] bulk operations?

[Samantha Payn]

I’d find a “batch post invoice” function enormously helpful. I have a foreign 
currency client who insists on a separate invoice for each (sometimes 
inconsequential) amount and the multiple clicks to post the invoice and confirm 
the exchange rate for each one are time consuming.
Currently the quickest I’ve got it is to create each invoice but not post it, 
then use “find invoice” criteria to call all the invoices up, highlight them 
all and then click “post” which prompts the exchange rate dialogue (for every 
invoice). I use “fetch rate” for the first invoice, and just “accept rate” for 
all the others, but that’s still three clicks per invoice (I think).
Please could Santa bring me a “batch post invoice” function for Christmas?
Samantha PAYN
Mob: +44 7977 150053

> On 7 Dec 2020, at 22:01, Weiwu Zhang  wrote:
> 
> This issue comes up regularly with new users. The short answer to the 
> question is,  "no, there is not a bulk edit."
> 
> Instead of discouraging people to ask this because it's already discussed and 
> some suggestions are already archived, I feel starting the conversation again 
> is the only way to call out the importance of this feature so we might have a 
> formal solution that we can put into the document section. Gnucash cuts into 
> the prosumer market where users do need such "advanced" features.
> 
> In fact I'm a bit disheartened that this question stopped reappearing sincer 
> 2017. Previously it showed up roughly yearly. It might be a sign that there 
> are less new users discovering gnucash, instead of people being more mature 
> and stopped asking without searching into the archives.
> 
> The following is just an exmaple in 2017, the last year people still asked 
> for this.
> 
>> On Sun, May 7, 2017 at 8:07, Eric Theise wrote:
>> 
>> Suppose I'm in the "Search Results" window resulting from an "Edit >
>> Find..." operation. Is there any way to apply a change to every
>> transaction that appears?
> 
>> Say that, due to history and multiple credit card accounts, a
>> grocer's Description appears as "HI HO", "hi ho grocery", "hi-ho
>> market", and permutations thereof. Is there any way to standardize
>> the name for everything in the result set besides manually changing
>> each line?
> 
>> I'd also like to be able to perform bulk operations against
>> "Imbalance-USD" transactions.
> 
>> If it's not possible through the GUI, how about via issuing SQL
>> statements to a database backend?
> 
> ___
> gnucash-user mailing list
> gnucash-user@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.
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Error with Asset Chart report

[Adrien Monteleone]

Not on Mac. I use the standard bundle. I've built on Ubuntu in the past 
for testing but haven't done so in some time.


Regards,
Adrien

On 12/7/20 3:11 PM, David H wrote:

And also using the Flatpak version 4.2 on Ubuntu.  I'm guessing Adrien
compiles his own version - maybe that's why he doesn't see the error, I
always download the compiled version and install it ???


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] bulk operations?

[Adrien Monteleone]

Samantha, you can import invoice data.

Thus, if you have a way to easily create that data in a spreadsheet, you 
can save it as CSV, then import them to GnuCash.


See the Help/Guide about importing business data for the required columns.

I'm not certain if it works well with a foreign currency however.

Regards,
Adrien

On 12/7/20 4:11 PM, Samantha Payn wrote:

I’d find a “batch post invoice” function enormously helpful. I have a foreign 
currency client who insists on a separate invoice for each (sometimes 
inconsequential) amount and the multiple clicks to post the invoice and confirm 
the exchange rate for each one are time consuming.
Currently the quickest I’ve got it is to create each invoice but not post it, 
then use “find invoice” criteria to call all the invoices up, highlight them 
all and then click “post” which prompts the exchange rate dialogue (for every 
invoice). I use “fetch rate” for the first invoice, and just “accept rate” for 
all the others, but that’s still three clicks per invoice (I think).
Please could Santa bring me a “batch post invoice” function for Christmas?


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] bulk operations?

[Adrien Monteleone]

I saw it a few months ago. People still ask. One new (at the time) 
volunteer offered to code it. I think it didn't get very far at the time 
due to complexity. (and other 'fish to fry' in the code, so to speak)


Regards,
Adrien

On 12/7/20 4:00 PM, Weiwu Zhang wrote:
This issue comes up regularly with new users. The short answer to the 
question is,  "no, there is not a bulk edit."


Instead of discouraging people to ask this because it's already 
discussed and some suggestions are already archived, I feel starting the 
conversation again is the only way to call out the importance of this 
feature so we might have a formal solution that we can put into the 
document section. Gnucash cuts into the prosumer market where users do 
need such "advanced" features.


In fact I'm a bit disheartened that this question stopped reappearing 
sincer 2017. Previously it showed up roughly yearly. It might be a sign 
that there are less new users discovering gnucash, instead of people 
being more mature and stopped asking without searching into the archives.


The following is just an exmaple in 2017, the last year people still 
asked for this.


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Error with Asset Chart report

[David H]

So you're not seeing this message at all ???

I'm using the bog standard download versions on MacOS Big Sur and Win 10
Pro and the flatpak version on Ubuntu 20.10 and see the error in all of
them with David T's test file

Cheers David H.

On Tue, 8 Dec 2020 at 08:21, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Not on Mac. I use the standard bundle. I've built on Ubuntu in the past
> for testing but haven't done so in some time.
>
> Regards,
> Adrien
>
> On 12/7/20 3:11 PM, David H wrote:
> > And also using the Flatpak version 4.2 on Ubuntu.  I'm guessing Adrien
> > compiles his own version - maybe that's why he doesn't see the error, I
> > always download the compiled version and install it ???
>
> ___
> gnucash-user mailing list
> gnucash-user@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.
>
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] bulk operations?

[Samantha Payn]

Thanks for the suggestion, Adrien. I’ve got entering the invoice data into 
Gnucash down to a fine art (especially with the recent “predictive text” input 
in my “product” fields! Thanks again for that, whoever it was!). It is 
specifically the step to confirm the exchange rate when posting an invoice 
which is the time consuming point.
Samantha Payn

> On 7 Dec 2020, at 22:25, Adrien Monteleone  
> wrote:
> 
> Samantha, you can import invoice data.
> 
> Thus, if you have a way to easily create that data in a spreadsheet, you can 
> save it as CSV, then import them to GnuCash.
> 
> See the Help/Guide about importing business data for the required columns.
> 
> I'm not certain if it works well with a foreign currency however.
> 
> Regards,
> Adrien
> 
>> On 12/7/20 4:11 PM, Samantha Payn wrote:
>> I’d find a “batch post invoice” function enormously helpful. I have a 
>> foreign currency client who insists on a separate invoice for each 
>> (sometimes inconsequential) amount and the multiple clicks to post the 
>> invoice and confirm the exchange rate for each one are time consuming.
>> Currently the quickest I’ve got it is to create each invoice but not post 
>> it, then use “find invoice” criteria to call all the invoices up, highlight 
>> them all and then click “post” which prompts the exchange rate dialogue (for 
>> every invoice). I use “fetch rate” for the first invoice, and just “accept 
>> rate” for all the others, but that’s still three clicks per invoice (I 
>> think).
>> Please could Santa bring me a “batch post invoice” function for Christmas?
> 
> ___
> gnucash-user mailing list
> gnucash-user@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.
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Error with Asset Chart report

[Adrien Monteleone]

No, but I am still on 4.1, about to jump to 4.2 and see if that makes a 
difference. (I normally have no reason for waiting, I've just been busy)


Regards,
Adrien

On 12/7/20 4:40 PM, David H wrote:

So you're not seeing this message at all ???

I'm using the bog standard download versions on MacOS Big Sur and Win 10
Pro and the flatpak version on Ubuntu 20.10 and see the error in all of
them with David T's test file


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] bulk operations?

[Christopher Lam]

But it's crucial to input the exchange rate - and IIUC you are encouraged
to use
https://www.gov.uk/government/publications/hmrc-exchange-rates-for-2020-monthly

On Mon, 7 Dec 2020 at 22:47, Samantha Payn 
wrote:

>
> Thanks for the suggestion, Adrien. I’ve got entering the invoice data into
> Gnucash down to a fine art (especially with the recent “predictive text”
> input in my “product” fields! Thanks again for that, whoever it was!). It
> is specifically the step to confirm the exchange rate when posting an
> invoice which is the time consuming point.
> Samantha Payn
>
> > On 7 Dec 2020, at 22:25, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> >
> > Samantha, you can import invoice data.
> >
> > Thus, if you have a way to easily create that data in a spreadsheet, you
> can save it as CSV, then import them to GnuCash.
> >
> > See the Help/Guide about importing business data for the required
> columns.
> >
> > I'm not certain if it works well with a foreign currency however.
> >
> > Regards,
> > Adrien
> >
> >> On 12/7/20 4:11 PM, Samantha Payn wrote:
> >> I’d find a “batch post invoice” function enormously helpful. I have a
> foreign currency client who insists on a separate invoice for each
> (sometimes inconsequential) amount and the multiple clicks to post the
> invoice and confirm the exchange rate for each one are time consuming.
> >> Currently the quickest I’ve got it is to create each invoice but not
> post it, then use “find invoice” criteria to call all the invoices up,
> highlight them all and then click “post” which prompts the exchange rate
> dialogue (for every invoice). I use “fetch rate” for the first invoice, and
> just “accept rate” for all the others, but that’s still three clicks per
> invoice (I think).
> >> Please could Santa bring me a “batch post invoice” function for
> Christmas?
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@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.
> ___
> gnucash-user mailing list
> gnucash-user@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.
>
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] bulk operations?

[Samantha Payn]

Yes, I agree that the exchange rate has to be input. Whether you fetch the rate 
(also permitted by HMRC as I understand it) or input the rate manually it still 
has to be confirmed for each invoice when posting in Gnucash. 

 Christopher Lam wrote 

>But it's crucial to input the exchange rate - and IIUC you are encouraged
>to use
>https://www.gov.uk/government/publications/hmrc-exchange-rates-for-2020-monthly
>
>On Mon, 7 Dec 2020 at 22:47, Samantha Payn 
>wrote:
>
>>
>> Thanks for the suggestion, Adrien. I’ve got entering the invoice data into
>> Gnucash down to a fine art (especially with the recent “predictive text”
>> input in my “product” fields! Thanks again for that, whoever it was!). It
>> is specifically the step to confirm the exchange rate when posting an
>> invoice which is the time consuming point.
>> Samantha Payn
>>
>> > On 7 Dec 2020, at 22:25, Adrien Monteleone <
>> adrien.montele...@lusfiber.net> wrote:
>> >
>> > Samantha, you can import invoice data.
>> >
>> > Thus, if you have a way to easily create that data in a spreadsheet, you
>> can save it as CSV, then import them to GnuCash.
>> >
>> > See the Help/Guide about importing business data for the required
>> columns.
>> >
>> > I'm not certain if it works well with a foreign currency however.
>> >
>> > Regards,
>> > Adrien
>> >
>> >> On 12/7/20 4:11 PM, Samantha Payn wrote:
>> >> I’d find a “batch post invoice” function enormously helpful. I have a
>> foreign currency client who insists on a separate invoice for each
>> (sometimes inconsequential) amount and the multiple clicks to post the
>> invoice and confirm the exchange rate for each one are time consuming.
>> >> Currently the quickest I’ve got it is to create each invoice but not
>> post it, then use “find invoice” criteria to call all the invoices up,
>> highlight them all and then click “post” which prompts the exchange rate
>> dialogue (for every invoice). I use “fetch rate” for the first invoice, and
>> just “accept rate” for all the others, but that’s still three clicks per
>> invoice (I think).
>> >> Please could Santa bring me a “batch post invoice” function for
>> Christmas?
>> >
>> > ___
>> > gnucash-user mailing list
>> > gnucash-user@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.
>> ___
>> gnucash-user mailing list
>> gnucash-user@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.
>>
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Error with Asset Chart report

[Adrien Monteleone]

Before installing 4.2, I tested with the sample file. It threw the 
errors as ya'll have indicated.


I re-assigned all of the higher level asset transactions to Level 7, and 
while it still threw the error, it only did so for one iteration with 
option '6' and did not throw it for option 'All'. (before this 
re-assignment, it iterated the error once for each transaction)


I also tested marking each of the intermediate level accounts as 
placeholders but this had no effect.


Again, I find it odd that the Expense Chart doesn't throw the error even 
with 7-8 levels deep with transactions. (and not all intermediary 
accounts empty or placeholders)


Regards,
Adrien

On 12/7/20 4:46 PM, Adrien Monteleone wrote:
No, but I am still on 4.1, about to jump to 4.2 and see if that makes a 
difference. (I normally have no reason for waiting, I've just been busy)


___
gnucash-user mailing list
gnucash-user@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.

[GNC] Fwd: gnucash fonts

[David Carlson]

Harold,

Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

-- Forwarded message -
From: Harold 
Date: Mon, Dec 7, 2020 at 4:10 PM
Subject: Re: [GNC] gnucash fonts
To: David Carlson 


David,
I dropped my resolution down one notch and it has helped. I don't
understand why this happened suddenly and just recently. I am not asking
you for the reason, just making a comment.
Harold

On Saturday, December 5, 2020, 10:57:23 AM CST, David Carlson <
david.carlson@gmail.com> wrote:


Harold,

Small text is often an artifact of desktop screen resolution.   Is GnuCash
showing different size than your other programs?

I am not sure where that is controlled in KDE.


On Sat, Dec 5, 2020, 8:36 AM Harold via gnucash-user <
gnucash-user@gnucash.org> wrote:

When I open Gnucash 4.2 in Linux PCLOS KDE, the fonts are too small. The
menu, the account names, and the register itself.

I have searched online and tried editing the style sheets but that doesn't
seem to help. Are style sheets just for reports???
How do I increase the size of the font in the register and its menu?
thanks,Harold

___
gnucash-user mailing list
gnucash-user@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.



-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

[GNC] bulk operations?

[flywire]

>* If it's not possible through the GUI, how about via issuing SQL
*>* statements to a database backend?*

*Seems reasonable.*
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] bulk operations?

[Adrien Monteleone]

Writing to the db is considered risky at this time. (and not supported) 
Reading is fine though.


Regards,
Adrien

On 12/7/20 5:21 PM, flywire wrote:

* If it's not possible through the GUI, how about via issuing SQL

*>* statements to a database backend?*

*Seems reasonable.*


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] bulk operations?

[D. via gnucash-user]

Of course, one can edit the data using SQL (for a file stored in one of the 
database formats) or even a text editor (for an uncompressed XML file). Many do 
so.  But bear in mind that any edits made outside the Gnucash API may affect 
the reliability of your data set, or even corrupt the data. 

Personally, I've never found that these solutions were worth the time it took 
to set up. By the time I had, I could have just gone through and changed the 
entries manually. 

David T. 

[For the problem of varying descriptions that the OP mentioned, for example, 
I've found it quite simple to put a register in Basic mode, sort by 
Description, highlight my preferred version, copy it, and then paste it into 
each transaction by turn, using the down arrow to go to the next transaction. 
This is very rapid, since it immediately highlights the next entry for pasting.]


 Original Message 
From: flywire 
Sent: Mon Dec 07 18:21:01 EST 2020
To: Gnucash Users 
Subject: [GNC] bulk operations?

>* If it's not possible through the GUI, how about via issuing SQL
*>* statements to a database backend?*

*Seems reasonable.*
___
gnucash-user mailing list
gnucash-user@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.

___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] [GNC-dev] [MAINT] Planned server reboot Monday, Dec 7, 8:00pm US/EST

[Derek Atkins]

Reboot finished and everything should be back to normal.
Please let me know if you notice any issues.
Thanks!

-derek


On Sun, December 6, 2020 9:15 pm, Derek Atkins wrote:
> TL;DR: Unless I hear major objections, I plan to reboot the VM server
> tomorrow, Monday, Dec 7, around 8pm US/EST (0100 UTC Dec 8), in order to
> refresh / update some certificates.  Please let me know if this is an
> issue.
>
> Long Version:
>
> The GnuCash infrastructure uses a single-host OVirt VM platform for its
> production system.  Unfortunately, this means that certain system
> maintenance efforts require system reboots, and, unfortunately, replacing
> the certificates is one of those.  All the new certificates are in place
> so I should just need to reboot the system to allow it to take effect.
>
> The reason for the certificate update is two-fold:
>
> 1) Many of the certificates were set to expire next year (2021), so they
> would have to be renewed anyway.  Granted, this date was November 1, so I
> had most of the year to do it, but still, it had to be done within the
> next 11 months.
>
> 2) More importantly, the certificates were all using SHA1, and this was
> causing problems with e.g. remote-viewer complaining that the certificates
> were not secure.  This is JohnR and, after I update my own system this
> weekend, me.
>
> If I had a multi-server Ovirt setup (e.g. 3 hosts), then I could
> round-robin update them.  I migrate all the running VMs to the other two
> hosts and then I can safely take the third host down and do whatever I
> needed.  Then I bring it up again, let everything stabilize, and then move
> to the next one.  Alas, with a single host, I can't do this so I need to
> reboot.
>
> total downtime should be no more than 30 minutes, assuming of course I got
> everything right.  Also, I am *hoping* this will fix the remote-viewer
> issue, but I won't know for sure until after I reboot.
>
> If you all have any questions, concerns, or the timing is bad, please let
> me know.
>
> Thanks!
>
> -derek
>
> PS: For John, Frank, Geert, etc -- due to the certificate changes you will
> need to remove the old certificates from your browser trusted-cert cache
> first and then import the new ones.  Search for IHTFP.  If you don't
> remove it, it'll give you an error that the certificate changed but has
> the same Issuer/Serial#.  I'm sorry, but there's nothing I can do about
> that.
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> gnucash-devel mailing list
> gnucash-de...@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] bulk operations?

[Peter West]

There are a number of fields which are “descriptive” in one way or another, 
such that editing these fields outside Gnucash poses to risk to the integrity 
of the data. The developers know best which fields these are. A number of users 
have developed external means of editing databases (and I have done some ad hoc 
editing myself). It would be useful if the developers could list the database 
fields that are “safe”. I’m not suggesting this be put in the normal 
documentation, but that it be available somewhere for those who want to dig for 
it.
--
Peter West
p...@pbw.id.au
“After me comes he who is mightier than I, the strap of whose sandals I am not 
worthy to stoop down and untie.”

> On 8 Dec 2020, at 9:44 am, Adrien Monteleone  
> wrote:
> 
> Writing to the db is considered risky at this time. (and not supported) 
> Reading is fine though.
> 
> Regards,
> Adrien
> 
> On 12/7/20 5:21 PM, flywire wrote:
>>> * If it's not possible through the GUI, how about via issuing SQL
>> *>* statements to a database backend?*
>> *Seems reasonable.*
> 
> ___
> gnucash-user mailing list
> gnucash-user@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.

___
gnucash-user mailing list
gnucash-user@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.