Re: [GNC] Auto commit with auto save?

[David T. via gnucash-user]

Nope and nope. Sorry. 

It seems to me that leaving GnuCash open and running a con job against the open 
app is a recipe for troubles just like the ones you have encountered. You could 
tell the script to abort if it found the lock file, but that would require you 
to close the app every night, which you're not doing now. 

⁣David T. ​

On May 7, 2023, 9:25 PM, at 9:25 PM, "David G. Pickett"  
wrote:
>Any suggestions on a) how a shell script tells that the auto save is
>incomplete, b) even if it knew, what it could do about it?
>
>
>-Original Message-
>From: David T. 
>To: David G. Pickett 
>Cc: gnucash-user@gnucash.org
>Sent: Sun, May 7, 2023 1:28 am
>Subject: Re: [GNC] Auto commit with auto save?
>
>I agree that it would be nice to have some visual cue that a
>transaction has been edited but not saved; that would be useful. I'm
>honestly not sure why that hasn't been implemented. 
>
>The app does throw a dialog onscreen when a user tries to save with an
>open transaction. Unfortunately, the message is generic, and a user is
>forced to look through the open tabs and try to figure out which
>register holds this transaction. Others have commented on this in the
>past. 
>
>If I recall correctly, you were having trouble because you have a cron
>job set up to retrieve quotes at a specified time each day, and this
>job causes the file to close dirty if there is an open transaction. The
>problem in this case, is that this cron job doesn't have necessary
>fault testing and tolerance. I'd suggest working on ensuring that this
>cron job was properly set up to handle your specific situation. 
>
>David T. On May 6, 2023, at 9:02 PM, "David G. Pickett via
>gnucash-user"  wrote:
>"Don't do that!" does not prevent data loss from human error, which for
>this app behavior is too easy to create and not realize.
>
>
>If the commit was automatic every time you modified a transaction when
>the new state was valid, then I would not leave the tab in an
>uncommitted state, but that is not how it was devised.  I leave because
>it looks fine.  There is no indication of an uncommitted transaction I
>can see.  In terms of human factors, one might go to another tab for
>information to complete a transaction, so we do not want to prevent the
>user leaving a tab with an uncommitted, possibly invalid transaction. 
>Maybe we should color the tab red while in this state?  Or pop up a
>dialog if it persists a bit too long, or if auto save fires on its
>timer?  But the user may have left, trusting in auto save, so I suggest
>an auto commit if valid on auto save.
>
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>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.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Yahoo JSON - throwing unauthorized error

[john]

If it includes sufficient warnings about working on a copy and voiding your 
warranty, sure.

Regards,
John Ralls


> On May 7, 2023, at 6:02 PM, Bruce Schuck  wrote:
> 
> To the maintainers of the Wiki, would this be something perhaps helpful to 
> include in the section about stocks and commodities?
> 
> I can also add 'xmlstarlet' commands as an alternative to manually editing 
> the file.
> 
> - Bruce S.
> 
> On 05/07/23 15:12:21 EDT Bruce Schuck bschuck at asgard-systems.com wrote:
> 
> > Last time I switched en-masse (alphavantage to yahoo_json) I manually
> > edited my foobar.gnucash file. Worked like a charm.
> 
> ** Create a backup ** of foobar.gnucash before following these steps.
> Replace 'vim' with your preferred editor.
> 
> ~$ cp /foobar.gnucash /tmp/foobar.gnucash.gz
> ~$ cd /tmp
> /tmp $ gunzip foobar.gnucash
> /tmp $ vim foobar.gnucash
> 
> In vim, change lines
> 
> alphavantage
> 
> to
> 
> yahoo_json
> 
> Save and exit
> 
> /tmp $ gzip foobar.gnucash
> /tmp $ cp foobar.gnucash.gz /foobar.gnucash
> 
> > Run GnuCash, confirm quote sources for a random few securities.
> 
> > There is also a handy tool for editing XML files on the fly,
> > xmlstarlet. It can also be used to modify the uncompressed
> > .gnucash file.
> 
> - Bruce S.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Transaction Report Advance Portfolio - Options - Account List

[john]

> On May 7, 2023, at 1:17 AM, Martin Booth via gnucash-user 
>  wrote:
> 
> 
> I am running GNUCash - 5.1 flatpak on debian 11.I have been using GC for 
> 15years now and the Advance Portfolio report does not list all the COA or 
> highlight the selected accounts the report is based on unlike earlier 
> versions > 4.xx. This also applies to the investment portfolio report
> 
> Selecting Reports>>Assets & Liabilities>>Advance Portfolio>> report runs fine
> I want to change this report so that I can run the report from each 
> investment broker selected from COA. 
> 
> Selecting Reports>>Advance Portfolio>>options>>accounts
> It fails to list all the COA, it only lists Assets and the sub accounts under 
> this e.g. fixed assets and current assets and I have retirement assets but 
> not list my investment assets .
> It also does not list which accounts the report is based on and it fails to 
> show equity, expenses or liabilities as previous versions of GC.
> Therefore I cannot select/filter the report by investment broker as previous 
> GC versions.
> I ran my report on GC 4.13 and I can create and amend the report with all COA 
> listed in the default Advanced Portfolio options (GC 4.13 running my VM), but 
> the current release 5.1 does not show all the accounts and it cannot be 
> modified. 

As part of rewriting the options code I fixed a bug in the Advance Portfolio 
Report: The accounts presented for selection are filtered to Asset, Stock, and 
Mutual Fund, and the default selection is all accounts of type stock and mutual 
fund. Makes sense, right? It had been in the report code all along but the 
implementation of the account option tree view didn't work right so you got the 
whole CoA. Now it works. Great, right? Not quite. The problem is that the 
accounts page in the options does a recursive search and it filters out parent 
accounts that aren't one of those types so if you have stock accounts under, 
for example, a Bank account they won't display on the selector. The initial 
query that loads the report does the filtering only on the leaf accounts so it 
gets all of the stock and mutual fund accounts, but if you open Options the 
GtkTreeView drops them--even if you don't visit that page on the options dialog.

This was first reported in https://bugs.gnucash.org/show_bug.cgi?id=798796

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Yahoo JSON - throwing unauthorized error

[Bruce Schuck]

To the maintainers of the Wiki, would this be something perhaps helpful 
to include in the section about stocks and commodities?


I can also add 'xmlstarlet' commands as an alternative to manually 
editing the file.


- Bruce S.

On 05/07/23 15:12:21 EDT Bruce Schuck bschuck at asgard-systems.com wrote:

> Last time I switched en-masse (alphavantage to yahoo_json) I manually
> edited my foobar.gnucash file. Worked like a charm.

** Create a backup ** of foobar.gnucash before following these steps.
Replace 'vim' with your preferred editor.

~$ cp /foobar.gnucash /tmp/foobar.gnucash.gz
~$ cd /tmp
/tmp $ gunzip foobar.gnucash
/tmp $ vim foobar.gnucash

In vim, change lines

alphavantage

to

yahoo_json

Save and exit

/tmp $ gzip foobar.gnucash
/tmp $ cp foobar.gnucash.gz /foobar.gnucash

> Run GnuCash, confirm quote sources for a random few securities.

> There is also a handy tool for editing XML files on the fly,
> xmlstarlet. It can also be used to modify the uncompressed
> .gnucash file.

- Bruce S.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Transaction Report Advance Portfolio - Options - Account List

[Murugan Muruganandam]

martin

The accounts selection windows is scrollable, it is not visible but you can 
scroll to see all the accounts.

to check, you can click on select all button , which will display the full COA




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Martin Booth via gnucash-user 
Sent: Sunday, May 7, 2023 4:17 AM
To: gnucash-user@gnucash.org 
Subject: [GNC] Transaction Report Advance Portfolio - Options - Account List


I am running GNUCash - 5.1 flatpak on debian 11.I have been using GC for 
15years now and the Advance Portfolio report does not list all the COA or 
highlight the selected accounts the report is based on unlike earlier versions 
> 4.xx. This also applies to the investment portfolio report

Selecting Reports>>Assets & Liabilities>>Advance Portfolio>> report runs fine
I want to change this report so that I can run the report from each investment 
broker selected from COA.

Selecting Reports>>Advance Portfolio>>options>>accounts
It fails to list all the COA, it only lists Assets and the sub accounts under 
this e.g. fixed assets and current assets and I have retirement assets but not 
list my investment assets .
It also does not list which accounts the report is based on and it fails to 
show equity, expenses or liabilities as previous versions of GC.
Therefore I cannot select/filter the report by investment broker as previous GC 
versions.
I ran my report on GC 4.13 and I can create and amend the report with all COA 
listed in the default Advanced Portfolio options (GC 4.13 running my VM), but 
the current release 5.1 does not show all the accounts and it cannot be 
modified.

I believe this will apply to other users so I will submit a bug report.
thanks,Martin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Yahoo JSON - throwing unauthorized error

[Bruce Schuck]

On 5/7/23 11:33, David G. Pickett wrote:

I have previously posted my mystery regarding why I am stuck 1.5301 
even after downloading and installing later versions!  I went to 
flatpak to get later releases than the Ubuntu base.  I guess I can 
start doing uninstall hacks using synaptics!  If it is not broke 



Still partly my bad. When I push interim releases to CPAN/PAUSE I have 
to remember to use the 1.dd_dd format instead of 1.. Otherwise the 
distro gets indexed as an official release.



Switching all my securities to Alphadvantage was tiresome, as the
gui was no responsive to the keyboard, but I found the source could
be found using page up.
Last time I switched en-masse (alphavantage to yahoo_json) I manually 
edited my foobar.gnucash file. Worked like a charm.


** Create a backup ** of foobar.gnucash before following these steps. 
Replace 'vim' with your preferred editor.


~$ cp /foobar.gnucash /tmp/foobar.gnucash.gz
~$ cd /tmp
/tmp $ gunzip foobar.gnucash
/tmp $ vim foobar.gnucash

In vim, change lines

alphavantage

to

yahoo_json

Save and exit

/tmp $ gzip foobar.gnucash
/tmp $ cp foobar.gnucash.gz /foobar.gnucash

Run GnuCash, confirm quote sources for a random few securities.

There is also a handy tool for editing XML files on the fly, xmlstarlet. 
It can also be used to modify the uncompressed .gnucash file.


- Bruce S.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Turn of drop list when entering data in memo/description line

[Carsten Hütter]

Am 05.05.23 um 15:42 schrieb Geert Janssens:

Op donderdag 4 mei 2023 21:40:14 CEST schreef Carsten Hütter: >
[...]

>

The releases on the other hand are found on flathub. And while not obvious
from their website you can install older versions from there as well from the
command line.

Our wiki explains how you can do this:
https://wiki.gnucash.org/wiki/Flatpak#Getting_Older_Releaseses


Thanks. Got it. That's nice. But sadly, I get the following reply:

carsten@carsten-HP:~$ flatpak update --commit
511cf18127561c55b5999121c6b301ca1e90d6cc988a00701257606df7fae86f
org.gnucash.GnuCash
Looking for updates…
Fehler: Server returned status 404: Not Found
carsten@carsten-HP:~$

404 error. Not found. Even after the "flatpak remote-info --log flathub 
org.gnucash.GnuCash" command showed the correct package:


 Commit:
511cf18127561c55b5999121c6b301ca1e90d6cc988a00701257606df7fae86f
Subject: Release GnuCash 4.14 (b2942403)
   Date: 2023-03-25 23:27:27 +

So, in my case, on my system (Ubuntu 22.04), there is some kind of issue 
with this procedure...




[...]



Regards

Carsten

PS: Thanks for all your effort and dedication here! Bedankt voor je 
inzet en je bijdragen!



gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Yahoo JSON - throwing unauthorized error

[David G. Pickett via gnucash-user]

I have previously posted my mystery regarding why I am stuck 1.5301 even after 
downloading and installing later versions!  I went to flatpak to get later 
releases than the Ubuntu base.  I guess I can start doing uninstall hacks using 
synaptics!  If it is not broke 


-Original Message-
From: Bruce Schuck 
To: gnucash-user@gnucash.org 
Cc: dgpick...@aol.com
Sent: Sat, May 6, 2023 9:16 pm
Subject: Re: [GNC] Yahoo JSON - throwing unauthorized error

> Switching all my securities to Alphadvantage was tiresome, as the
> gui was no responsive to the keyboard, but I found the source could be found
> using page up.  Some display at the security editor main screen or
> somewhere would help to see which is running quotes where, how many
> currently owned. I have many stocks not currently owned, and so they
> should not be quoted.  I got more info out of an strace.  Having the
> security editor sort each list might be much nicer, too.  Ditto for the
> portfolio report.  Most reports in this world sort left to right, for
> some silly reason.

This has been a problem with AlphaVantage since they started throttling 
responses for those using the free API key.

> Now it is so slow, and while some work, it locks up on some security.
> Maybe it needs a timeout error?  I resolves the host name over and over.
> Eventually only perl is running, and then nothing.  It takes a long
> time just to get to "Found Finance::Quote version 1.5301." 

Hmm... how did 1.5301 get into a flatpak? The official F::Q releases are 
1.xx with only 2 digits following the major release number. Crap... 
looks like my screw-up. I uploaded 1.5301 instead of 1.53_01, which was 
a pre-release of 1.54. I did the same for 1.5402 today and it's 
currently being deleted. Juggling too many tasks at once. Sorry all.

As stated in another thread pertaining to this issue, find the proper 
YahooJSON.pm file and edit it changing

my $YIND_URL_HEAD = 
'https://query1.finance.yahoo.com/v7/finance/quote?symbols=';

to

my $YIND_URL_HEAD = 
'https://query1.finance.yahoo.com/v6/finance/quote?symbols=';

Quick fix seems to work.

New file with the quick fix uploaded to CPAN - 
https://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.54_03.tar.gz.

It can be installed in cpan as BPSCHUCK/Finance-Quote-1.54_03.tar.gz.


- Bruce S.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Auto commit with auto save?

[David G. Pickett via gnucash-user]

Any suggestions on a) how a shell script tells that the auto save is 
incomplete, b) even if it knew, what it could do about it?


-Original Message-
From: David T. 
To: David G. Pickett 
Cc: gnucash-user@gnucash.org
Sent: Sun, May 7, 2023 1:28 am
Subject: Re: [GNC] Auto commit with auto save?

I agree that it would be nice to have some visual cue that a transaction has 
been edited but not saved; that would be useful. I'm honestly not sure why that 
hasn't been implemented. 

The app does throw a dialog onscreen when a user tries to save with an open 
transaction. Unfortunately, the message is generic, and a user is forced to 
look through the open tabs and try to figure out which register holds this 
transaction. Others have commented on this in the past. 

If I recall correctly, you were having trouble because you have a cron job set 
up to retrieve quotes at a specified time each day, and this job causes the 
file to close dirty if there is an open transaction. The problem in this case, 
is that this cron job doesn't have necessary fault testing and tolerance. I'd 
suggest working on ensuring that this cron job was properly set up to handle 
your specific situation. 

David T. On May 6, 2023, at 9:02 PM, "David G. Pickett via gnucash-user" 
 wrote:
"Don't do that!" does not prevent data loss from human error, which for this 
app behavior is too easy to create and not realize.


If the commit was automatic every time you modified a transaction when the new 
state was valid, then I would not leave the tab in an uncommitted state, but 
that is not how it was devised.  I leave because it looks fine.  There is no 
indication of an uncommitted transaction I can see.  In terms of human factors, 
one might go to another tab for information to complete a transaction, so we do 
not want to prevent the user leaving a tab with an uncommitted, possibly 
invalid transaction.  Maybe we should color the tab red while in this state?  
Or pop up a dialog if it persists a bit too long, or if auto save fires on its 
timer?  But the user may have left, trusting in auto save, so I suggest an auto 
commit if valid on auto save.

gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Auto commit with auto save?

[David Carlson]

How about
*Bug 686051*  - Pending
transaction edits get "lost" (edit
)


On Sun, May 7, 2023 at 9:19 AM Stan Brown 
wrote:

> On 2023-05-06 22:28, David T. via gnucash-user wrote:
> > The app does throw a dialog onscreen when a user tries to save with
> > an open transaction. Unfortunately, the message is generic, and a
> > user is forced to look through the open tabs and try to figure out
> > which register holds this transaction. Others have commented on this
> > in the past.
> Has an enhancement request been submitted about this? It's an ongoing
> annoyance, and I can't understand why GC requires me to guess which of
> half a dozen pen registers contains the incomplete transaction.
>
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Auto commit with auto save?

[Stan Brown]

On 2023-05-06 22:28, David T. via gnucash-user wrote:
> The app does throw a dialog onscreen when a user tries to save with
> an open transaction. Unfortunately, the message is generic, and a
> user is forced to look through the open tabs and try to figure out
> which register holds this transaction. Others have commented on this
> in the past.
Has an enhancement request been submitted about this? It's an ongoing
annoyance, and I can't understand why GC requires me to guess which of
half a dozen pen registers contains the incomplete transaction.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

[GNC] Transaction Report Advance Portfolio - Options - Account List

[Martin Booth via gnucash-user]

I am running GNUCash - 5.1 flatpak on debian 11.I have been using GC for 
15years now and the Advance Portfolio report does not list all the COA or 
highlight the selected accounts the report is based on unlike earlier versions 
> 4.xx. This also applies to the investment portfolio report

Selecting Reports>>Assets & Liabilities>>Advance Portfolio>> report runs fine
I want to change this report so that I can run the report from each investment 
broker selected from COA. 

Selecting Reports>>Advance Portfolio>>options>>accounts
It fails to list all the COA, it only lists Assets and the sub accounts under 
this e.g. fixed assets and current assets and I have retirement assets but not 
list my investment assets .
It also does not list which accounts the report is based on and it fails to 
show equity, expenses or liabilities as previous versions of GC.
Therefore I cannot select/filter the report by investment broker as previous GC 
versions.
I ran my report on GC 4.13 and I can create and amend the report with all COA 
listed in the default Advanced Portfolio options (GC 4.13 running my VM), but 
the current release 5.1 does not show all the accounts and it cannot be 
modified. 

I believe this will apply to other users so I will submit a bug report.
thanks,Martin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.