Re: Price Retrieval Failure, Part 2

[D via gnucash-user]

John,

A little patience; I am honestly grasping at straws.

Given that I consistently have troubles that others can't replicate or don't 
experience, I am looking for some way to get back to what others have. That 
means trying to figure out what has been put in, and taking it back out again, 
to get back to ground zero, as it were.

In that vein, my question had to do with files that Gnucash has put in, that I 
have not explicitly, directly asked it to create. My data files are items I 
explicitly and directly asked to be created. I know about them, and can move 
them aside on my own.

Files in ~/ Library/Application Support/Gnucash are not things I have directly 
created. Although those items are a result of my actions (like saving a 
report), I didn't directly say "Gnucash, please create a file in that hidden 
folder, and call it saved-reports-2.4 ," for example. Ditto for the preferences 
file. I appreciate the leads.

Now, to start digging in to the whole Perl problem...

David

On February 10, 2018, at 8:41 PM, John Ralls  wrote:



> On Feb 9, 2018, at 9:52 PM, D  wrote:
> 
> Sorry to be replying to my own message, but it also occurs to me that, in 
> addition to Gnucash, Finance::Quote gets installed. Given that my troubles in 
> this instance are intimately linked to F::Q, what steps might I take to 
> ensure that IT gets removed as well?I
> 
> David
> 
> On February 10, 2018, at 10:49 AM, D via gnucash-user 
>  wrote:
> 
> John,
> 
> Thank you for clarifying. I'll note that Gnucash does put stuff into 
> ~/Library/Application Support/Gnucash as well, so there is at least one thing 
> that gets installed.
> 
> I asked this question because I am still observing several "idiosyncrasies" 
> on my system that no one else seems to be experiencing (such as this 
> retrieval problem and my ongoing inability to get custom reports to load). 
> Because I am experiencing such problems, it suggests a problem unique to my 
> computer, and I was looking for a way to ensure that I was starting with a 
> truly clean slate.
> 
> If I delete Gnucash.app and move (or delete) ~/Library/Application 
> Support/Gnucash, will that create a completely empty Gnucash environment, or 
> is there another system location that needs cleaning?I

David,

GnuCash writes stuff to ~/Library/Application Support/Gnucash when it runs, 
mostly to save state but also to save things like saved report configurations. 
It also writes out your data files and their associated logs to wherever you 
tell it to. Where do you draw the line for what’s “installation”?

GnuCash doesn’t install F::Q, that’s a separate, optional, step using perl’s 
cpan module. Unfortunately uninstalling modules installed with cpan isn’t easy, 
I suggest that you google “cpan uninstall” and look through the different 
approaches to find one that you’re comfortable with.

There’s one other place GnuCash stores user state: 
~/Library/Preferences/org.gnucash.Gnucash.plist, which you can simply remove or 
move aside to get a default set of preferences the next time you start GnuCash.

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
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: Price Retrieval Failure, Part 2

[Geert Janssens]

Op zaterdag 10 februari 2018 16:38:58 CET schreef John Ralls:
> > On Feb 9, 2018, at 9:52 PM, D  wrote:
> > 
> > Sorry to be replying to my own message, but it also occurs to me that, in
> > addition to Gnucash, Finance::Quote gets installed. Given that my
> > troubles in this instance are intimately linked to F::Q, what steps might
> > I take to ensure that IT gets removed as well?I
> > 
> > David
> > 
> > On February 10, 2018, at 10:49 AM, D via gnucash-user
> >  wrote:
> > 
> > John,
> > 
> > Thank you for clarifying. I'll note that Gnucash does put stuff into
> > ~/Library/Application Support/Gnucash as well, so there is at least one
> > thing that gets installed.
> > 
> > I asked this question because I am still observing several
> > "idiosyncrasies" on my system that no one else seems to be experiencing
> > (such as this retrieval problem and my ongoing inability to get custom
> > reports to load). Because I am experiencing such problems, it suggests a
> > problem unique to my computer, and I was looking for a way to ensure that
> > I was starting with a truly clean slate.
> > 
> > If I delete Gnucash.app and move (or delete) ~/Library/Application
> > Support/Gnucash, will that create a completely empty Gnucash environment,
> > or is there another system location that needs cleaning?I
> David,
> 
> GnuCash writes stuff to ~/Library/Application Support/Gnucash when it runs,
> mostly to save state but also to save things like saved report
> configurations. It also writes out your data files and their associated
> logs to wherever you tell it to. Where do you draw the line for what’s
> “installation”?
> 
Warning: more technical consideration ahead!

This is probably why XDG proposes a user_data_dir and a user_config_dir. The 
former is for the application to store any user data (like window sizes and 
positions, saved reports,...), the latter should be for files such as 
config.user, log.conf and any custom reports written  by the user. Gnucash can 
do whatever with the files in the former, but should never alter anything in 
the latter.
Unfortunately the XDG specification doesn't seem to map very well to the way 
OS X handles things, where both types of data are stored in Library/
Application Support/
And also on Windows gtk maps both locations on one directory.

However in all cases it surprises me gnucash would remove config.user or files 
it didn't add there by itself from the Application Support directories. If 
this is really the case, that would need changing.

Geert


___
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: Price Retrieval Failure, Part 2

[John Ralls]

> On Feb 9, 2018, at 9:52 PM, D  wrote:
> 
> Sorry to be replying to my own message, but it also occurs to me that, in 
> addition to Gnucash, Finance::Quote gets installed. Given that my troubles in 
> this instance are intimately linked to F::Q, what steps might I take to 
> ensure that IT gets removed as well?I
> 
> David
> 
> On February 10, 2018, at 10:49 AM, D via gnucash-user 
>  wrote:
> 
> John,
> 
> Thank you for clarifying. I'll note that Gnucash does put stuff into 
> ~/Library/Application Support/Gnucash as well, so there is at least one thing 
> that gets installed.
> 
> I asked this question because I am still observing several "idiosyncrasies" 
> on my system that no one else seems to be experiencing (such as this 
> retrieval problem and my ongoing inability to get custom reports to load). 
> Because I am experiencing such problems, it suggests a problem unique to my 
> computer, and I was looking for a way to ensure that I was starting with a 
> truly clean slate.
> 
> If I delete Gnucash.app and move (or delete) ~/Library/Application 
> Support/Gnucash, will that create a completely empty Gnucash environment, or 
> is there another system location that needs cleaning?I

David,

GnuCash writes stuff to ~/Library/Application Support/Gnucash when it runs, 
mostly to save state but also to save things like saved report configurations. 
It also writes out your data files and their associated logs to wherever you 
tell it to. Where do you draw the line for what’s “installation”?

GnuCash doesn’t install F::Q, that’s a separate, optional, step using perl’s 
cpan module. Unfortunately uninstalling modules installed with cpan isn’t easy, 
I suggest that you google “cpan uninstall” and look through the different 
approaches to find one that you’re comfortable with.

There’s one other place GnuCash stores user state: 
~/Library/Preferences/org.gnucash.Gnucash.plist, which you can simply remove or 
move aside to get a default set of preferences the next time you start GnuCash.

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
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: Price Retrieval Failure, Part 2

[Geert Janssens]

Op vrijdag 9 februari 2018 06:14:03 CET schreef David T.:
> Geert mentioned that the Alphavantage settings will be incorporated into
> 3.0; when is that slated for release? Is the feature active on 2.7.4—and
> should I try using that (*he shudders*)?
> 
Yes, 2.7.4 comes with this change, but I don't recommend to use it for 
anything but testing. We hope to release 3.0 end of March. That will depend on 
which issues will still pop up during the next weeks though.

Geert


___
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: Price Retrieval Failure, Part 2

[Geert Janssens]

Op vrijdag 9 februari 2018 05:40:22 CET schreef David T.:
> Unfortunately, adding these lines to my config.user did not result in any
> further information.  I am stumped, and disappointed.
> 
I tried it myself on OS X now and indeed it doesn't work as it does on linux. 
Sorry about that.

Attached you will find an adjusted version that does work on my OS X box (which 
is pretty old).

It will print a warning on the console stating either the key is not set or 
what it is set to. To find 
this message you have to open Console and search for "ALPHAVANTAGE" after you 
have started 
gnucash.

Does this reveal the requested information ?

> 
> It seems that an upgrade of GnuCash not only tanks one’s customized
> environment file in the application bundle (understandable), but also any
> additional files that a user might have put into the DOT_GNUCASH_DIR
> folder—like, custom scheme reports, or a config.user file that a user might
> have created in vain attempts to get said custom reports to load into their
> personal installation of GnuCash. I find this circumstance to be rather
> troubling, as the files that a user has put into this folder should not be
> summarily sent to the executioner by the next version of the application.
> This is especially troubling given that the authorized methods for creating
> and using custom scheme reports (as convoluted and sensitive as they are)
> specifically directs such reports to be placed into this folder. If *I*
> were to have written a custom report for GnuCash (as opposed to simply
> copying someone else’s work to my own system) I would be pretty ticked off
> to find my work discarded this way. Thank goodness I had backups, but
> really, one shouldn’t have to restore from a backup on this. 
> 

Indeed. And on linux this doesn't happen. So if this is the case on OS X, 
that's a bug.

Geert
(use-modules (gnucash main))
(let ((api-key (getenv "ALPHAVANTAGE_API_KEY")))
  (if (not api-key)
  (gnc:warn "ALPHAVANTAGE_API_KEY is not set")
  (gnc:warn (string-append
  "ALPHAVANTAGE_API_KEY is set to '"
   (getenv "ALPHAVANTAGE_API_KEY") "'")
  )
  )
)
___
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: Price Retrieval Failure, Part 2

[D via gnucash-user]

Sorry to be replying to my own message, but it also occurs to me that, in 
addition to Gnucash, Finance::Quote gets installed. Given that my troubles in 
this instance are intimately linked to F::Q, what steps might I take to ensure 
that IT gets removed as well?I

David

On February 10, 2018, at 10:49 AM, D via gnucash-user 
 wrote:

John,

Thank you for clarifying. I'll note that Gnucash does put stuff into 
~/Library/Application Support/Gnucash as well, so there is at least one thing 
that gets installed.

I asked this question because I am still observing several "idiosyncrasies" on 
my system that no one else seems to be experiencing (such as this retrieval 
problem and my ongoing inability to get custom reports to load). Because I am 
experiencing such problems, it suggests a problem unique to my computer, and I 
was looking for a way to ensure that I was starting with a truly clean slate.

If I delete Gnucash.app and move (or delete) ~/Library/Application 
Support/Gnucash, will that create a completely empty Gnucash environment, or is 
there another system location that needs cleaning?I

Also, is the internalized Alphavantage setting active in 2.7.4?

David

On February 9, 2018, at 8:35 PM, John Ralls  wrote:

GnuCash on the Mac doesn’t install anything. You drag the bundle to wherever 
you like, and you can have as many as you like. If you want to try a “fresh 
installation” (shouldn’t make any difference, nothing in the bundle should 
change with use) just open up the dmg and drag Gnucash.app somewhere else.

The variables in the environment file are overridden by those variables being 
set in the launcher script (Gnucash.app/Contents/MacOS/Gnucash). In 2.7.4 and 
later there is no launcher script and the code that writes the environment file 
is changed to use paths relative to {GNC_HOME}.

You’re right that GnuCash shouldn’t be overwriting files in GNC_DOT_DIR. I’ll 
have a look at that. 

Regards,
John Ralls

> On Feb 8, 2018, at 9:14 PM, David T. via gnucash-user 
>  wrote:
> 
> In reply to my own message, in the interest of trying to run a fresh 
> installation of GnuCash, I logged in to a different (new) Mac user account 
> and replicated the test there. In other words, I opened GnuCash and created a 
> simple file with AAPL and tried to retrieve prices. I receive the same error. 
> 
> Because GnuCash on the Mac installs the application bundle at the system 
> level, the environment file there is still invoked (a check in that account 
> confirms that this file is accessible in the new account), so I wonder 
> whether there is something going on there that causes my problem.
> 
> I don’t know whether this is a problem, but digging through the enviroment 
> file yields two variables with John’s folder structures:
> 
> GNC_DBD_DIR=/Users/john/Development/Gnucash-Build/Gnucash-2.6-Leopard/inst/lib/dbd
> XDG_DATA_DIRS=/Users/john/Development/Gnucash-Build/Gnucash-2.6-Leopard/inst/share;{XDG_DATA_DIRS};/usr/local/share;/usr/share
> 
> These should be removed, or scrubbed to be generically valid. 
> 
> At this point, I am at a loss for how to proceed.  
> 
> I would try for a “clean slate,” but I would have thought that downloading 
> and installing the newer version would have done that. Since I have been 
> using GnuCash so long, and have sporadically attempted to contribute to the 
> project, my machine has numerous development tools (git, SourceTree, etc.) 
> and GnuCash content (gnucash-docs, gnucash-htdocs) installed; I imagine I 
> could delete all of that as well, and try from there. Given how much trouble 
> it has been for me to get these development technologies to work, I am loathe 
> to take this step, however.
> 
> Geert mentioned that the Alphavantage settings will be incorporated into 3.0; 
> when is that slated for release? Is the feature active on 2.7.4—and should I 
> try using that (*he shudders*)? 
> 
> David
> 
>> On Feb 9, 2018, at 9:40 AM, David T. via gnucash-user 
>>  wrote:
>> 
>> Unfortunately, adding these lines to my config.user did not result in any 
>> further information.  I am stumped, and disappointed.
>> 
>> 
>> It seems that an upgrade of GnuCash not only tanks one’s customized 
>> environment file in the application bundle (understandable), but also any 
>> additional files that a user might have put into the DOT_GNUCASH_DIR 
>> folder—like, custom scheme reports, or a config.user file that a user might 
>> have created in vain attempts to get said custom reports to load into their 
>> personal installation of GnuCash. I find this circumstance to be rather 
>> troubling, as the files that a user has put into this folder should not be 
>> summarily sent to the executioner by the next version of the application. 
>> This is especially troubling given that the authorized methods for creating 
>> and using custom scheme reports (as convoluted and sensitive as they 

Re: Price Retrieval Failure, Part 2

[D via gnucash-user]

John,

Thank you for clarifying. I'll note that Gnucash does put stuff into 
~/Library/Application Support/Gnucash as well, so there is at least one thing 
that gets installed.

I asked this question because I am still observing several "idiosyncrasies" on 
my system that no one else seems to be experiencing (such as this retrieval 
problem and my ongoing inability to get custom reports to load). Because I am 
experiencing such problems, it suggests a problem unique to my computer, and I 
was looking for a way to ensure that I was starting with a truly clean slate.

If I delete Gnucash.app and move (or delete) ~/Library/Application 
Support/Gnucash, will that create a completely empty Gnucash environment, or is 
there another system location that needs cleaning?I

Also, is the internalized Alphavantage setting active in 2.7.4?

David

On February 9, 2018, at 8:35 PM, John Ralls  wrote:

GnuCash on the Mac doesn’t install anything. You drag the bundle to wherever 
you like, and you can have as many as you like. If you want to try a “fresh 
installation” (shouldn’t make any difference, nothing in the bundle should 
change with use) just open up the dmg and drag Gnucash.app somewhere else.

The variables in the environment file are overridden by those variables being 
set in the launcher script (Gnucash.app/Contents/MacOS/Gnucash). In 2.7.4 and 
later there is no launcher script and the code that writes the environment file 
is changed to use paths relative to {GNC_HOME}.

You’re right that GnuCash shouldn’t be overwriting files in GNC_DOT_DIR. I’ll 
have a look at that. 

Regards,
John Ralls

> On Feb 8, 2018, at 9:14 PM, David T. via gnucash-user 
>  wrote:
> 
> In reply to my own message, in the interest of trying to run a fresh 
> installation of GnuCash, I logged in to a different (new) Mac user account 
> and replicated the test there. In other words, I opened GnuCash and created a 
> simple file with AAPL and tried to retrieve prices. I receive the same error. 
> 
> Because GnuCash on the Mac installs the application bundle at the system 
> level, the environment file there is still invoked (a check in that account 
> confirms that this file is accessible in the new account), so I wonder 
> whether there is something going on there that causes my problem.
> 
> I don’t know whether this is a problem, but digging through the enviroment 
> file yields two variables with John’s folder structures:
> 
> GNC_DBD_DIR=/Users/john/Development/Gnucash-Build/Gnucash-2.6-Leopard/inst/lib/dbd
> XDG_DATA_DIRS=/Users/john/Development/Gnucash-Build/Gnucash-2.6-Leopard/inst/share;{XDG_DATA_DIRS};/usr/local/share;/usr/share
> 
> These should be removed, or scrubbed to be generically valid. 
> 
> At this point, I am at a loss for how to proceed.  
> 
> I would try for a “clean slate,” but I would have thought that downloading 
> and installing the newer version would have done that. Since I have been 
> using GnuCash so long, and have sporadically attempted to contribute to the 
> project, my machine has numerous development tools (git, SourceTree, etc.) 
> and GnuCash content (gnucash-docs, gnucash-htdocs) installed; I imagine I 
> could delete all of that as well, and try from there. Given how much trouble 
> it has been for me to get these development technologies to work, I am loathe 
> to take this step, however.
> 
> Geert mentioned that the Alphavantage settings will be incorporated into 3.0; 
> when is that slated for release? Is the feature active on 2.7.4—and should I 
> try using that (*he shudders*)? 
> 
> David
> 
>> On Feb 9, 2018, at 9:40 AM, David T. via gnucash-user 
>>  wrote:
>> 
>> Unfortunately, adding these lines to my config.user did not result in any 
>> further information.  I am stumped, and disappointed.
>> 
>> 
>> It seems that an upgrade of GnuCash not only tanks one’s customized 
>> environment file in the application bundle (understandable), but also any 
>> additional files that a user might have put into the DOT_GNUCASH_DIR 
>> folder—like, custom scheme reports, or a config.user file that a user might 
>> have created in vain attempts to get said custom reports to load into their 
>> personal installation of GnuCash. I find this circumstance to be rather 
>> troubling, as the files that a user has put into this folder should not be 
>> summarily sent to the executioner by the next version of the application. 
>> This is especially troubling given that the authorized methods for creating 
>> and using custom scheme reports (as convoluted and sensitive as they are) 
>> specifically directs such reports to be placed into this folder. If *I* were 
>> to have written a custom report for GnuCash (as opposed to simply copying 
>> someone else’s work to my own system) I would be pretty ticked off to find 
>> my work discarded this way. Thank goodness I had backups, but really, one 
>> shouldn’t have to restore from a backup 

Re: Price Retrieval Failure, Part 2

[John Ralls]

GnuCash on the Mac doesn’t install anything. You drag the bundle to wherever 
you like, and you can have as many as you like. If you want to try a “fresh 
installation” (shouldn’t make any difference, nothing in the bundle should 
change with use) just open up the dmg and drag Gnucash.app somewhere else.

The variables in the environment file are overridden by those variables being 
set in the launcher script (Gnucash.app/Contents/MacOS/Gnucash). In 2.7.4 and 
later there is no launcher script and the code that writes the environment file 
is changed to use paths relative to {GNC_HOME}.

You’re right that GnuCash shouldn’t be overwriting files in GNC_DOT_DIR. I’ll 
have a look at that. 

Regards,
John Ralls

> On Feb 8, 2018, at 9:14 PM, David T. via gnucash-user 
>  wrote:
> 
> In reply to my own message, in the interest of trying to run a fresh 
> installation of GnuCash, I logged in to a different (new) Mac user account 
> and replicated the test there. In other words, I opened GnuCash and created a 
> simple file with AAPL and tried to retrieve prices. I receive the same error. 
> 
> Because GnuCash on the Mac installs the application bundle at the system 
> level, the environment file there is still invoked (a check in that account 
> confirms that this file is accessible in the new account), so I wonder 
> whether there is something going on there that causes my problem.
> 
> I don’t know whether this is a problem, but digging through the enviroment 
> file yields two variables with John’s folder structures:
> 
> GNC_DBD_DIR=/Users/john/Development/Gnucash-Build/Gnucash-2.6-Leopard/inst/lib/dbd
> XDG_DATA_DIRS=/Users/john/Development/Gnucash-Build/Gnucash-2.6-Leopard/inst/share;{XDG_DATA_DIRS};/usr/local/share;/usr/share
> 
> These should be removed, or scrubbed to be generically valid. 
> 
> At this point, I am at a loss for how to proceed.  
> 
> I would try for a “clean slate,” but I would have thought that downloading 
> and installing the newer version would have done that. Since I have been 
> using GnuCash so long, and have sporadically attempted to contribute to the 
> project, my machine has numerous development tools (git, SourceTree, etc.) 
> and GnuCash content (gnucash-docs, gnucash-htdocs) installed; I imagine I 
> could delete all of that as well, and try from there. Given how much trouble 
> it has been for me to get these development technologies to work, I am loathe 
> to take this step, however.
> 
> Geert mentioned that the Alphavantage settings will be incorporated into 3.0; 
> when is that slated for release? Is the feature active on 2.7.4—and should I 
> try using that (*he shudders*)? 
> 
> David
> 
>> On Feb 9, 2018, at 9:40 AM, David T. via gnucash-user 
>>  wrote:
>> 
>> Unfortunately, adding these lines to my config.user did not result in any 
>> further information.  I am stumped, and disappointed.
>> 
>> 
>> It seems that an upgrade of GnuCash not only tanks one’s customized 
>> environment file in the application bundle (understandable), but also any 
>> additional files that a user might have put into the DOT_GNUCASH_DIR 
>> folder—like, custom scheme reports, or a config.user file that a user might 
>> have created in vain attempts to get said custom reports to load into their 
>> personal installation of GnuCash. I find this circumstance to be rather 
>> troubling, as the files that a user has put into this folder should not be 
>> summarily sent to the executioner by the next version of the application. 
>> This is especially troubling given that the authorized methods for creating 
>> and using custom scheme reports (as convoluted and sensitive as they are) 
>> specifically directs such reports to be placed into this folder. If *I* were 
>> to have written a custom report for GnuCash (as opposed to simply copying 
>> someone else’s work to my own system) I would be pretty ticked off to find 
>> my work discarded this way. Thank goodness I had backups, but really, one 
>> shouldn’t have to restore from a backup on this.
>> 
>> 
>> I have now created a simple file to test out price retrieval. I put one 
>> stock account that uses AAPL, a cash account and Equity, and created a 
>> simple buy transaction (to create one price entry). For me, this file fails 
>> in the same way. I attach it here, so that someone else can test it. If it 
>> works for you, then there is something about my Mac that F::Q doesn’t like. 
>> And then I am really up the creek, because it’s a big operating system out 
>> there…
>> 
>> David
>> 
>> 
>> 
>>> On Feb 8, 2018, at 11:40 PM, Geert Janssens  
>>> wrote:
>>> 
>>> David,
>>> 
>>> You can put the attached config.user file in your DOT_GNUCASH_DIR ($HOME/
>>> Library/Application Support/Gnucash)
>>> 
>>> If you then start gnucash from the command line, it should print out the 
>>> value 
>>> of your API key there, together with the version of Finance::Quote that 

Re: Price Retrieval Failure, Part 2

[David T. via gnucash-user]

In reply to my own message, in the interest of trying to run a fresh 
installation of GnuCash, I logged in to a different (new) Mac user account and 
replicated the test there. In other words, I opened GnuCash and created a 
simple file with AAPL and tried to retrieve prices. I receive the same error. 

Because GnuCash on the Mac installs the application bundle at the system level, 
the environment file there is still invoked (a check in that account confirms 
that this file is accessible in the new account), so I wonder whether there is 
something going on there that causes my problem.

I don’t know whether this is a problem, but digging through the enviroment file 
yields two variables with John’s folder structures:

GNC_DBD_DIR=/Users/john/Development/Gnucash-Build/Gnucash-2.6-Leopard/inst/lib/dbd
XDG_DATA_DIRS=/Users/john/Development/Gnucash-Build/Gnucash-2.6-Leopard/inst/share;{XDG_DATA_DIRS};/usr/local/share;/usr/share

These should be removed, or scrubbed to be generically valid. 

At this point, I am at a loss for how to proceed.  

I would try for a “clean slate,” but I would have thought that downloading and 
installing the newer version would have done that. Since I have been using 
GnuCash so long, and have sporadically attempted to contribute to the project, 
my machine has numerous development tools (git, SourceTree, etc.) and GnuCash 
content (gnucash-docs, gnucash-htdocs) installed; I imagine I could delete all 
of that as well, and try from there. Given how much trouble it has been for me 
to get these development technologies to work, I am loathe to take this step, 
however.

Geert mentioned that the Alphavantage settings will be incorporated into 3.0; 
when is that slated for release? Is the feature active on 2.7.4—and should I 
try using that (*he shudders*)? 

David

> On Feb 9, 2018, at 9:40 AM, David T. via gnucash-user 
>  wrote:
> 
> Unfortunately, adding these lines to my config.user did not result in any 
> further information.  I am stumped, and disappointed.
> 
> 
> It seems that an upgrade of GnuCash not only tanks one’s customized 
> environment file in the application bundle (understandable), but also any 
> additional files that a user might have put into the DOT_GNUCASH_DIR 
> folder—like, custom scheme reports, or a config.user file that a user might 
> have created in vain attempts to get said custom reports to load into their 
> personal installation of GnuCash. I find this circumstance to be rather 
> troubling, as the files that a user has put into this folder should not be 
> summarily sent to the executioner by the next version of the application. 
> This is especially troubling given that the authorized methods for creating 
> and using custom scheme reports (as convoluted and sensitive as they are) 
> specifically directs such reports to be placed into this folder. If *I* were 
> to have written a custom report for GnuCash (as opposed to simply copying 
> someone else’s work to my own system) I would be pretty ticked off to find my 
> work discarded this way. Thank goodness I had backups, but really, one 
> shouldn’t have to restore from a backup on this.
> 
> 
> I have now created a simple file to test out price retrieval. I put one stock 
> account that uses AAPL, a cash account and Equity, and created a simple buy 
> transaction (to create one price entry). For me, this file fails in the same 
> way. I attach it here, so that someone else can test it. If it works for you, 
> then there is something about my Mac that F::Q doesn’t like. And then I am 
> really up the creek, because it’s a big operating system out there…
> 
> David
> 
> 
> 
>> On Feb 8, 2018, at 11:40 PM, Geert Janssens  
>> wrote:
>> 
>> David,
>> 
>> You can put the attached config.user file in your DOT_GNUCASH_DIR ($HOME/
>> Library/Application Support/Gnucash)
>> 
>> If you then start gnucash from the command line, it should print out the 
>> value 
>> of your API key there, together with the version of Finance::Quote that got 
>> installed. Unless the OS X edition doesn't print this early boot 
>> information...
>> 
>> Regards,
>> 
>> Geert
> 
> ___
> 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 

Re: Price Retrieval Failure, Part 2

[David T. via gnucash-user]

Unfortunately, adding these lines to my config.user did not result in any 
further information.  I am stumped, and disappointed.


It seems that an upgrade of GnuCash not only tanks one’s customized environment 
file in the application bundle (understandable), but also any additional files 
that a user might have put into the DOT_GNUCASH_DIR folder—like, custom scheme 
reports, or a config.user file that a user might have created in vain attempts 
to get said custom reports to load into their personal installation of GnuCash. 
I find this circumstance to be rather troubling, as the files that a user has 
put into this folder should not be summarily sent to the executioner by the 
next version of the application. This is especially troubling given that the 
authorized methods for creating and using custom scheme reports (as convoluted 
and sensitive as they are) specifically directs such reports to be placed into 
this folder. If *I* were to have written a custom report for GnuCash (as 
opposed to simply copying someone else’s work to my own system) I would be 
pretty ticked off to find my work discarded this way. Thank goodness I had 
backups, but really, one shouldn’t have to restore from a backup on this.


I have now created a simple file to test out price retrieval. I put one stock 
account that uses AAPL, a cash account and Equity, and created a simple buy 
transaction (to create one price entry). For me, this file fails in the same 
way. I attach it here, so that someone else can test it. If it works for you, 
then there is something about my Mac that F::Q doesn’t like. And then I am 
really up the creek, because it’s a big operating system out there…

David



TestAlpha.gnucash
Description: Binary data


> On Feb 8, 2018, at 11:40 PM, Geert Janssens  
> wrote:
> 
> David,
> 
> You can put the attached config.user file in your DOT_GNUCASH_DIR ($HOME/
> Library/Application Support/Gnucash)
> 
> If you then start gnucash from the command line, it should print out the 
> value 
> of your API key there, together with the version of Finance::Quote that got 
> installed. Unless the OS X edition doesn't print this early boot 
> information...
> 
> Regards,
> 
> Geert

___
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: Price Retrieval Failure, Part 2

[David T. via gnucash-user]

Oh, and I mentioned this in the earlier thread, but it bears repeating: the 
Security Editor window has the option to display price source. 

As with the Chart of Accounts window, there is a selector arrow on the upper 
right corner which drops down a list of user-selectable co,lumns for display. 
Source is one of these.

Cheers,
David


> On Feb 8, 2018, at 10:33 PM, D via gnucash-user  
> wrote:
> 
> David,
> 
> Thanks, but that's not it. I have my security editor window set up so that it 
> shows the quote source, so I can see at a glance that every one of the 
> 100-plus securities is set to Alphavantage.
> 
> I think that tomorrow, when I have a little time, I'll create a small test 
> file with one security in it, and see what happens.
> 
> Thanks,
> David
> 
> On February 8, 2018, at 10:07 PM, David Reiser  wrote:
> 
> 
>> On Feb 8, 2018, at 9:52 AM, David T. via gnucash-user 
>>  wrote:
>> 
>> In thread 
>> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html 
>> , 
>> I noted that after upgrading my installation from 2.6.16 to 2.6.19 on my Mac 
>> (OS X 10.13.3), Price retrieval was failing with the generic error: "There 
>> was an unknown error while retrieving the price quotes.”
>> 
>> *** As I noted there: Finance::Quote works at the command line:
>> 
>> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
>> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" 
>> "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" 
>> "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
>> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" 
>> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" 
>> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" 
>> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" 
>> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
>> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
>> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" 
>> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" 
>> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" 
>> "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" 
>> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts”)
>> 
>> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
>> alphavantage AAPL
>> Finance::Quote fields Gnucash uses:
>>   symbol: AAPL <=== required
>> date: 02/08/2018   <=== recommended
>> currency: USD  <=== required
>> last: 160.1350 <=\   
>>  nav:  <=== one of these
>>price:  <=/
>> timezone:  <=== optional
>> 
>> *** As I noted earlier: I restored the following two lines to 
>> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:
>> 
>> # Set AlphaVantage API Key to allow Finance::Quote to work
>> ALPHAVANTAGE_API_KEY=8SET
>> 
>> It seems to me that somehow Gnucash.app is not reading or using the 
>> ALPHAVANTAGE_API_KEY that is stored in its environment file. Either that, or 
>> somehow my environment file is not properly configured. However, I do not 
>> see any way to test these hypotheses. 
>> 
>> Can anyone tell me how I might determine **FROM WITHIN GNUCASH.APP** whether 
>> the Alphavantage API key is being read, and what its value currently is? Is 
>> there any other way to troubleshoot this problem?
>> 
>> David
> 
> Depending on your holdings, I’d suggest you open every single security in the 
> security editor dialog and make sure that _none_ of them are set to retrieve 
> online quotes from yahoo.
> 
> Back when my investing time horizon was a few months rather than years, I 
> bought and sold stocks in a total of something like 200 companies. When the 
> yahoo quote retrieval apocalypse hit, it took me three trips through the list 
> of 200 companies to find the last stock that was set to use yahoo as a 
> source. That’s annoying when one has to open each security definition 
> individually to see if it is set to retrieve quotes and from where. Hmm, time 
> for an enhancement request to include online-quote-source in the security 
> editor main dialog list…
> 
> Dave
> --
> Dave Reiser
> dbrei...@icloud.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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember 

Re: Price Retrieval Failure, Part 2

[Geert Janssens]

David,

You can put the attached config.user file in your DOT_GNUCASH_DIR ($HOME/
Library/Application Support/Gnucash)

If you then start gnucash from the command line, it should print out the value 
of your API key there, together with the version of Finance::Quote that got 
installed. Unless the OS X edition doesn't print this early boot 
information...

Regards,

Geert(let ((api-key (getenv "ALPHAVANTAGE_API_KEY")))
  (if (not api-key)
  (display "ALPHAVANTAGE_API_KEY is not set\n" (current-error-port))
  (display (string-append
  "ALPHAVANTAGE_API_KEY is set to '"
   (getenv "ALPHAVANTAGE_API_KEY")
   "'\n")
   (current-error-port)
  )
  )
)
___
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: Price Retrieval Failure, Part 2

[John Ralls]

David,

Sorry for the typos, I should have tested first. Then I would have realized 
that of course price-quotes.scm eats gnc-fq-helper’s stdout--that’s after all 
how it gets the quotes. Unfortunately it seems also to send stderr to /dev/null 
so that approach won’t work without changing price-quotes.scm.

Regards,
John Ralls

> On Feb 8, 2018, at 9:05 AM, David T.  wrote:
> 
> John,
> 
> Thanks for the suggestion. I inserted the line as you indicated (at line 324 
> in my copy of gnc-fq-helper), but didn’t get any output on the command line 
> after “Found Finance::Quote version 1.47”
> 
> I’m not much for perl, but I noticed your snippet had one ‘(‘, one  ‘{‘, and 
> two ‘}’. I tried it that way, and then I tried changing the last ‘}’ to ‘)’, 
> but that didn’t change anything. I also tried adding a semi-colon at the end 
> of the line, without effect. Heck, I even tried putting a Hello world print 
> statement, but that didn’t generate either. Either I am a bone fide idiot, or 
> there is something else going on here. I’ve got my money on the first, but I 
> hold out hope that it’s the second. Is it possible that I’ve latched on to 
> the wrong file somehow? Or that the command isn’t going to the standard 
> output?
> 
> David
> 
> P.S.: Should I be seeing:
> 
> /BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Common/ChunkCompression.cpp:50:
>  Error: unsupported compressor 8
> /BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Libraries/CompressData/CompressData.c:353:
>  Error: Unknown compression scheme encountered for file 
> '/System/Library/CoreServices/CoreTypes.bundle/Contents/Resources/Exceptions.plist'
> /BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Common/ChunkCompression.cpp:50:
>  Error: unsupported compressor 8
> /BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Libraries/CompressData/CompressData.c:353:
>  Error: Unknown compression scheme encountered for file 
> '/System/Library/CoreServices/CoreTypes.bundle/Contents/Library/AppExceptions.bundle/Exceptions.plist’
> 
> at the command line? This appears at startup before the F::Q note...
> 
>> On Feb 8, 2018, at 9:33 PM, John Ralls > > wrote:
>> 
>> 
>> 
>>> On Feb 8, 2018, at 6:52 AM, David T. via gnucash-user 
>>> > wrote:
>>> 
>>> In thread 
>>> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html 
>>>  
>>> >> >,
>>>  I noted that after upgrading my installation from 2.6.16 to 2.6.19 on my 
>>> Mac (OS X 10.13.3), Price retrieval was failing with the generic error: 
>>> "There was an unknown error while retrieving the price quotes.”
>>> 
>>> *** As I noted there: Finance::Quote works at the command line:
>>> 
>>> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
>>> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" 
>>> "asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" 
>>> "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
>>> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" 
>>> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" 
>>> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" 
>>> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" 
>>> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
>>> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
>>> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" 
>>> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" 
>>> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" 
>>> "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" 
>>> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts”)
>>> 
>>> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
>>> alphavantage AAPL
>>> Finance::Quote fields Gnucash uses:
>>>   symbol: AAPL <=== required
>>> date: 02/08/2018   <=== recommended
>>> currency: USD  <=== required
>>> last: 160.1350 <=\   
>>>  nav:  <=== one of these
>>>price:  <=/
>>> timezone:  <=== optional
>>> 
>>> *** As I noted earlier: I restored the following two lines to 
>>> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:
>>> 
>>> # Set AlphaVantage API Key to allow 

Re: Price Retrieval Failure, Part 2

[David Reiser]

> On Feb 8, 2018, at 9:52 AM, David T. via gnucash-user 
>  wrote:
> 
> In thread 
> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html 
> , 
> I noted that after upgrading my installation from 2.6.16 to 2.6.19 on my Mac 
> (OS X 10.13.3), Price retrieval was failing with the generic error: "There 
> was an unknown error while retrieving the price quotes.”
> 
> *** As I noted there: Finance::Quote works at the command line:
> 
> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" 
> "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" 
> "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" 
> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" 
> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" 
> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" 
> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" 
> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" 
> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" 
> "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" 
> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts”)
> 
> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
> alphavantage AAPL
> Finance::Quote fields Gnucash uses:
>symbol: AAPL <=== required
>  date: 02/08/2018   <=== recommended
>  currency: USD  <=== required
>  last: 160.1350 <=\   
>   nav:  <=== one of these
> price:  <=/
>  timezone:  <=== optional
> 
> *** As I noted earlier: I restored the following two lines to 
> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:
> 
> # Set AlphaVantage API Key to allow Finance::Quote to work
> ALPHAVANTAGE_API_KEY=8SET
> 
> It seems to me that somehow Gnucash.app is not reading or using the 
> ALPHAVANTAGE_API_KEY that is stored in its environment file. Either that, or 
> somehow my environment file is not properly configured. However, I do not see 
> any way to test these hypotheses. 
> 
> Can anyone tell me how I might determine **FROM WITHIN GNUCASH.APP** whether 
> the Alphavantage API key is being read, and what its value currently is? Is 
> there any other way to troubleshoot this problem?
> 
> David

Depending on your holdings, I’d suggest you open every single security in the 
security editor dialog and make sure that _none_ of them are set to retrieve 
online quotes from yahoo.

Back when my investing time horizon was a few months rather than years, I 
bought and sold stocks in a total of something like 200 companies. When the 
yahoo quote retrieval apocalypse hit, it took me three trips through the list 
of 200 companies to find the last stock that was set to use yahoo as a source. 
That’s annoying when one has to open each security definition individually to 
see if it is set to retrieve quotes and from where. Hmm, time for an 
enhancement request to include online-quote-source in the security editor main 
dialog list…

Dave
--
Dave Reiser
dbrei...@icloud.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
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: Price Retrieval Failure, Part 2

[David T. via gnucash-user]

John,

Thanks for the suggestion. I inserted the line as you indicated (at line 324 in 
my copy of gnc-fq-helper), but didn’t get any output on the command line after 
“Found Finance::Quote version 1.47”

I’m not much for perl, but I noticed your snippet had one ‘(‘, one  ‘{‘, and 
two ‘}’. I tried it that way, and then I tried changing the last ‘}’ to ‘)’, 
but that didn’t change anything. I also tried adding a semi-colon at the end of 
the line, without effect. Heck, I even tried putting a Hello world print 
statement, but that didn’t generate either. Either I am a bone fide idiot, or 
there is something else going on here. I’ve got my money on the first, but I 
hold out hope that it’s the second. Is it possible that I’ve latched on to the 
wrong file somehow? Or that the command isn’t going to the standard output?

David

P.S.: Should I be seeing:

/BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Common/ChunkCompression.cpp:50:
 Error: unsupported compressor 8
/BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Libraries/CompressData/CompressData.c:353:
 Error: Unknown compression scheme encountered for file 
'/System/Library/CoreServices/CoreTypes.bundle/Contents/Resources/Exceptions.plist'
/BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Common/ChunkCompression.cpp:50:
 Error: unsupported compressor 8
/BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Libraries/CompressData/CompressData.c:353:
 Error: Unknown compression scheme encountered for file 
'/System/Library/CoreServices/CoreTypes.bundle/Contents/Library/AppExceptions.bundle/Exceptions.plist’

at the command line? This appears at startup before the F::Q note...

> On Feb 8, 2018, at 9:33 PM, John Ralls  wrote:
> 
> 
> 
>> On Feb 8, 2018, at 6:52 AM, David T. via gnucash-user 
>>  wrote:
>> 
>> In thread 
>> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html 
>> , 
>> I noted that after upgrading my installation from 2.6.16 to 2.6.19 on my Mac 
>> (OS X 10.13.3), Price retrieval was failing with the generic error: "There 
>> was an unknown error while retrieving the price quotes.”
>> 
>> *** As I noted there: Finance::Quote works at the command line:
>> 
>> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
>> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" 
>> "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" 
>> "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
>> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" 
>> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" 
>> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" 
>> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" 
>> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
>> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
>> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" 
>> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" 
>> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" 
>> "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" 
>> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts”)
>> 
>> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
>> alphavantage AAPL
>> Finance::Quote fields Gnucash uses:
>>   symbol: AAPL <=== required
>> date: 02/08/2018   <=== recommended
>> currency: USD  <=== required
>> last: 160.1350 <=\   
>>  nav:  <=== one of these
>>price:  <=/
>> timezone:  <=== optional
>> 
>> *** As I noted earlier: I restored the following two lines to 
>> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:
>> 
>> # Set AlphaVantage API Key to allow Finance::Quote to work
>> ALPHAVANTAGE_API_KEY=8SET
>> 
>> It seems to me that somehow Gnucash.app is not reading or using the 
>> ALPHAVANTAGE_API_KEY that is stored in its environment file. Either that, or 
>> somehow my environment file is not properly configured. However, I do not 
>> see any way to test these hypotheses. 
>> 
>> Can anyone tell me how I might determine **FROM WITHIN GNUCASH.APP** whether 
>> the Alphavantage API key is being read, and what its value currently is? Is 
>> there any other way to troubleshoot this problem?
> 
> David,
> 
> There’s no UI for examining the environment. I can only say that it works for 
> me on MacOS 10.13 and GnuCash 2.6.19.
> 
> If you’re willing to hack a bit you could add a 

Re: Price Retrieval Failure, Part 2

[John Ralls]

> On Feb 8, 2018, at 6:52 AM, David T. via gnucash-user 
>  wrote:
> 
> In thread 
> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html 
> , 
> I noted that after upgrading my installation from 2.6.16 to 2.6.19 on my Mac 
> (OS X 10.13.3), Price retrieval was failing with the generic error: "There 
> was an unknown error while retrieving the price quotes.”
> 
> *** As I noted there: Finance::Quote works at the command line:
> 
> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" 
> "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" 
> "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" 
> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" 
> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" 
> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" 
> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" 
> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" 
> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" 
> "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" 
> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts”)
> 
> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
> alphavantage AAPL
> Finance::Quote fields Gnucash uses:
>symbol: AAPL <=== required
>  date: 02/08/2018   <=== recommended
>  currency: USD  <=== required
>  last: 160.1350 <=\   
>   nav:  <=== one of these
> price:  <=/
>  timezone:  <=== optional
> 
> *** As I noted earlier: I restored the following two lines to 
> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:
> 
> # Set AlphaVantage API Key to allow Finance::Quote to work
> ALPHAVANTAGE_API_KEY=8SET
> 
> It seems to me that somehow Gnucash.app is not reading or using the 
> ALPHAVANTAGE_API_KEY that is stored in its environment file. Either that, or 
> somehow my environment file is not properly configured. However, I do not see 
> any way to test these hypotheses. 
> 
> Can anyone tell me how I might determine **FROM WITHIN GNUCASH.APP** whether 
> the Alphavantage API key is being read, and what its value currently is? Is 
> there any other way to troubleshoot this problem?

David,

There’s no UI for examining the environment. I can only say that it works for 
me on MacOS 10.13 and GnuCash 2.6.19.

If you’re willing to hack a bit you could add a snippet to 
GnuCash.app/Contents/Resources/bin/gnc-fq-helper to print out the value of the 
key:

  print (“Alphavantage Key: $ENV{‘ALPHAVANTAGE_API_KEY’}\n”}

Put it down at the bottom somewhere after the #Runtime comment. You’ll have to 
run GnuCash from the command line to see that output.

Geert pushed a commit last week that keeps the Alphavantage key in preferences 
instead of the environment file so that in 3.0 one won’t have to keep resetting 
the environment file.

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
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.