Re: Reports very slow to open

2018-01-23 Thread David T. via gnucash-user 
Yes. 
https://bugzilla.gnome.org/show_bug.cgi?id=790789

 
 
  On Wed, Jan 24, 2018 at 11:37, David Carlson 
wrote:   OK, I missed the reference.  Has a bug been submitted?

David C

On Wed, Jan 24, 2018 at 12:32 AM, David T.  wrote:

David, 
Christopher is referring to a thread in which windows users reported that 
gnucash was imposing a substantial delay on the first run report. This is 
different from the general problem of slow report loading, I believe. 
As for the delay,  I have not seen anyone say that they have a fix. 
David T.

 
 
  On Wed, Jan 24, 2018 at 1:58, David Carlson 
wrote:   There has been a long standing problem with reports that need to 
process a
lot of records being slow to open for most every release in the 2.6 series
in Windows, if I recall.  However, if release 2.6.19 is now slow even with
simple reports, that is a new issue.  I think that the upcoming 3.0 series
will be substantially improved.

Do you have any memorized reports that are very simple to process, say a
balance report for a small number of accounts?  Are those slow to open too?

David C

On Tue, Jan 23, 2018 at 12:05 PM, Christopher Stubbs <
chrisastu...@outlook.com> wrote:

> Like Ron Burek (7 Jan 2018) I am running Gnucash 2.6.19 on Windows 10 pro,
> fully updated.
> When you try to open any report, transaction report, profit & loss etc,
> Gnucash goes into a long time wait mode with the blank report tab open,
> typically about 3 or 4 minutes, before the report actually opens. Once you
> have any report open then running another one is no problem.
> If you try to do anything else in Gnucash while you are waiting for the
> report to open you get the message "Gnucash is not responding" in the top
> ribbon and everything greys out.
> This is all totally reproducible every time, not just occasionally.
> This seems to have started to happen with 2.6.19 and the latest Windows 10
> update (KB4056892 in early January). I don't know if this is just
> coincidence.
> Anybody got any ideas about a fix?
>
> Thanks
>
> Chris Stubbs
> __ _
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/ mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
__ _
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/ mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  


  
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reports very slow to open

2018-01-23 Thread David Carlson 
OK, I missed the reference.  Has a bug been submitted?

David C

On Wed, Jan 24, 2018 at 12:32 AM, David T.  wrote:

> David,
>
> Christopher is referring to a thread in which windows users reported that
> gnucash was imposing a substantial delay on the first run report. This is
> different from the general problem of slow report loading, I believe.
>
> As for the delay,  I have not seen anyone say that they have a fix.
>
> David T.
>
>
>
> On Wed, Jan 24, 2018 at 1:58, David Carlson
>  wrote:
> There has been a long standing problem with reports that need to process a
> lot of records being slow to open for most every release in the 2.6 series
> in Windows, if I recall.  However, if release 2.6.19 is now slow even with
> simple reports, that is a new issue.  I think that the upcoming 3.0 series
> will be substantially improved.
>
> Do you have any memorized reports that are very simple to process, say a
> balance report for a small number of accounts?  Are those slow to open too?
>
> David C
>
> On Tue, Jan 23, 2018 at 12:05 PM, Christopher Stubbs <
> chrisastu...@outlook.com> wrote:
>
> > Like Ron Burek (7 Jan 2018) I am running Gnucash 2.6.19 on Windows 10
> pro,
> > fully updated.
> > When you try to open any report, transaction report, profit & loss etc,
> > Gnucash goes into a long time wait mode with the blank report tab open,
> > typically about 3 or 4 minutes, before the report actually opens. Once
> you
> > have any report open then running another one is no problem.
> > If you try to do anything else in Gnucash while you are waiting for the
> > report to open you get the message "Gnucash is not responding" in the top
> > ribbon and everything greys out.
> > This is all totally reproducible every time, not just occasionally.
> > This seems to have started to happen with 2.6.19 and the latest Windows
> 10
> > update (KB4056892 in early January). I don't know if this is just
> > coincidence.
> > Anybody got any ideas about a fix?
> >
> > Thanks
> >
> > Chris Stubbs
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reports very slow to open

2018-01-23 Thread David T. via gnucash-user 
David, 
Christopher is referring to a thread in which windows users reported that 
gnucash was imposing a substantial delay on the first run report. This is 
different from the general problem of slow report loading, I believe. 
As for the delay,  I have not seen anyone say that they have a fix. 
David T.

 
 
  On Wed, Jan 24, 2018 at 1:58, David Carlson 
wrote:   There has been a long standing problem with reports that need to 
process a
lot of records being slow to open for most every release in the 2.6 series
in Windows, if I recall.  However, if release 2.6.19 is now slow even with
simple reports, that is a new issue.  I think that the upcoming 3.0 series
will be substantially improved.

Do you have any memorized reports that are very simple to process, say a
balance report for a small number of accounts?  Are those slow to open too?

David C

On Tue, Jan 23, 2018 at 12:05 PM, Christopher Stubbs <
chrisastu...@outlook.com> wrote:

> Like Ron Burek (7 Jan 2018) I am running Gnucash 2.6.19 on Windows 10 pro,
> fully updated.
> When you try to open any report, transaction report, profit & loss etc,
> Gnucash goes into a long time wait mode with the blank report tab open,
> typically about 3 or 4 minutes, before the report actually opens. Once you
> have any report open then running another one is no problem.
> If you try to do anything else in Gnucash while you are waiting for the
> report to open you get the message "Gnucash is not responding" in the top
> ribbon and everything greys out.
> This is all totally reproducible every time, not just occasionally.
> This seems to have started to happen with 2.6.19 and the latest Windows 10
> update (KB4056892 in early January). I don't know if this is just
> coincidence.
> Anybody got any ideas about a fix?
>
> Thanks
>
> Chris Stubbs
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Price Retrieval Failure

2018-01-23 Thread David T. via gnucash-user 
David,
I know how to extract that information. 
My point is that it should be made readily available to a user ***from within 
gnucash***.
This is especially true given that it is possible for F::Q to work in one 
scenario (i.e., at the command line), but not the other. I will also note that 
there are many instances where a user has multiple versions of F::Q on their 
systems, with one version running at the command line, and the other in 
gnucash. 
So, really, for reliable debugging, you need to know exactly what gnucash 
thinks it is using. 

Documentation isn't the answer here, since F::Q is a separately maintained 
project. 
David T.
 
 
  On Wed, Jan 24, 2018 at 10:05, David Carlson 
wrote:   D

Some of that information is already available.  I know that the F::Q version 
appears in the console if GnuCash is started from the command line.  There are 
also instructions somewhere in the WIKI (I think) to run F::Q as a stand-alone. 
 Perhaps the answer is to have better documentation (which is dear to the 
hearts of some of us ;-) )

David C

On Tue, Jan 23, 2018 at 9:01 PM, D via gnucash-user  
wrote:

Derek,

I did edit the environment file.

This experience makes it clear to me that it would be nice if Gnucash had some 
way of showing F::Q information to the end user, like a screen showing the 
version installed, and maybe having buttons to trigger the various gnc- scripts 
and show the output. This would make debugging just a tad easier... (Note that 
I am not asking for better error messages, which certainly would be nice, but 
not likely, since finance quote isn't Gnucash).

David



On January 23, 2018, at 11:22 PM, Derek Atkins  wrote:

Did you update the environment file again after the upgrade? The update
process overwrites that file.

-derek
Sent using my mobile device. Please excuse any typos.



On January 23, 2018 1:08:36 PM D via gnucash-user
 wrote:

> Thanks. As I noted originally, my file was correctly configured and
> retrieving quotes from Alphavantage before the upgrade. Regardless, I had
> double checked that as well.
>
> Did you know that you can display the quote source for your securities on
> the main securities page? I didn't, before this.
>
> David
>
> On January 23, 2018, at 10:25 PM, david amaral  wrote:
>
> Verify security editor for your investments have get quotes checked
> and AlphaVantage  listed as source for each entry.
>
>
>
> From: David T. via gnucash-user 
> To: Gnucash Users 
> Sent: Tuesday, January 23, 2018 10:07 AM
> Subject: Price Retrieval Failure
>
>
> Hello,
>
>
> I recently upgraded from 2.6.16 to 2.6.19 on my Mac (OSX 10.13.2). In the
> prior setup, I had upgraded Finance::Quote to 1.47, added a shell variable
> for the Alphavantage key, added the same key to
> /Applications/Gnucash.app/ Contents/Resources/etc/ gnucash/environment,
> changed all my stocks to use other:alphavantage, and I was able to retrieve
> quotes.
>
>
> Upon upgrade, I find I am no longer able to retrieve AlphaVantage quotes.
> F::Q 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 alphavantage
> AAPL
>
> Finance::Quote fields Gnucash uses:
>
>     symbol: AAPL                <=== required
>
>       date: 01/23/2018          <=== recommended
>
>   currency: USD                  <=== required
>
>       last: 178.6400            <=\     
>
>       nav:                      <=== one of these
>
>     price:                      <=/       
>
>   timezone:                      <=== optional
>
>
> I have restored the following two lines into the aforementioned lines to
> /Applications/Gnucash.app/ Contents/Resources/etc/ gnucash/environment:
>
>
> # Set AlphaVantage API Key to allow Finance::Quote to work
>
> ALPHAVANTAGE_API_KEY=* ***8SET
>
>
> Unfortunately, I am getting the dreaded "There was an unknown error while
> retrieving the price quotes.”
>
>
> I

Re: Price Retrieval Failure

2018-01-23 Thread David Carlson 
D

Some of that information is already available.  I know that the F::Q
version appears in the console if GnuCash is started from the command
line.  There are also instructions somewhere in the WIKI (I think) to run
F::Q as a stand-alone.  Perhaps the answer is to have better documentation
(which is dear to the hearts of some of us ;-) )

David C

On Tue, Jan 23, 2018 at 9:01 PM, D via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Derek,
>
> I did edit the environment file.
>
> This experience makes it clear to me that it would be nice if Gnucash had
> some way of showing F::Q information to the end user, like a screen showing
> the version installed, and maybe having buttons to trigger the various gnc-
> scripts and show the output. This would make debugging just a tad easier...
> (Note that I am not asking for better error messages, which certainly would
> be nice, but not likely, since finance quote isn't Gnucash).
>
> David
>
>
>
> On January 23, 2018, at 11:22 PM, Derek Atkins  wrote:
>
> Did you update the environment file again after the upgrade? The update
> process overwrites that file.
>
> -derek
> Sent using my mobile device. Please excuse any typos.
>
>
>
> On January 23, 2018 1:08:36 PM D via gnucash-user
>  wrote:
>
> > Thanks. As I noted originally, my file was correctly configured and
> > retrieving quotes from Alphavantage before the upgrade. Regardless, I had
> > double checked that as well.
> >
> > Did you know that you can display the quote source for your securities on
> > the main securities page? I didn't, before this.
> >
> > David
> >
> > On January 23, 2018, at 10:25 PM, david amaral 
> wrote:
> >
> > Verify security editor for your investments have get quotes checked
> > and AlphaVantage  listed as source for each entry.
> >
> >
> >
> > From: David T. via gnucash-user 
> > To: Gnucash Users 
> > Sent: Tuesday, January 23, 2018 10:07 AM
> > Subject: Price Retrieval Failure
> >
> >
> > Hello,
> >
> >
> > I recently upgraded from 2.6.16 to 2.6.19 on my Mac (OSX 10.13.2). In the
> > prior setup, I had upgraded Finance::Quote to 1.47, added a shell
> variable
> > for the Alphavantage key, added the same key to
> > /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment,
> > changed all my stocks to use other:alphavantage, and I was able to
> retrieve
> > quotes.
> >
> >
> > Upon upgrade, I find I am no longer able to retrieve AlphaVantage quotes.
> > F::Q 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
> alphavantage
> > AAPL
> >
> > Finance::Quote fields Gnucash uses:
> >
> > symbol: AAPL<=== required
> >
> >   date: 01/23/2018  <=== recommended
> >
> >   currency: USD  <=== required
> >
> >   last: 178.6400<=\
> >
> >   nav:  <=== one of these
> >
> > price:  <=/
> >
> >   timezone:  <=== optional
> >
> >
> > I have restored the following two lines into the aforementioned lines to
> > /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:
> >
> >
> > # Set AlphaVantage API Key to allow Finance::Quote to work
> >
> > ALPHAVANTAGE_API_KEY=8SET
> >
> >
> > Unfortunately, I am getting the dreaded "There was an unknown error while
> > retrieving the price quotes.”
> >
> >
> > I welcome any reminders on what I have missed, or how to debug this
> further.
> >
> >
> > TIA,
> >
> > David T.
> >
> > ___
> >
> > gnucash-user mailing list
> >
> > gnucash-user@gnucash.org
> >
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >
> > -
> >
> > Please remember to CC this list on all your replies.
> >
> > You can do this by using Reply-To-List or Reply-All.
> >
> >
> >
> >

Re: Price Retrieval Failure

2018-01-23 Thread D via gnucash-user 
Derek,

I did edit the environment file.

This experience makes it clear to me that it would be nice if Gnucash had some 
way of showing F::Q information to the end user, like a screen showing the 
version installed, and maybe having buttons to trigger the various gnc- scripts 
and show the output. This would make debugging just a tad easier... (Note that 
I am not asking for better error messages, which certainly would be nice, but 
not likely, since finance quote isn't Gnucash).

David



On January 23, 2018, at 11:22 PM, Derek Atkins  wrote:

Did you update the environment file again after the upgrade? The update 
process overwrites that file.

-derek
Sent using my mobile device. Please excuse any typos.



On January 23, 2018 1:08:36 PM D via gnucash-user 
 wrote:

> Thanks. As I noted originally, my file was correctly configured and 
> retrieving quotes from Alphavantage before the upgrade. Regardless, I had 
> double checked that as well.
>
> Did you know that you can display the quote source for your securities on 
> the main securities page? I didn't, before this.
>
> David
>
> On January 23, 2018, at 10:25 PM, david amaral  wrote:
>
> Verify security editor for your investments have get quotes checked 
> and AlphaVantage  listed as source for each entry.
>
>
>
> From: David T. via gnucash-user 
> To: Gnucash Users 
> Sent: Tuesday, January 23, 2018 10:07 AM
> Subject: Price Retrieval Failure
>
>
> Hello,
>
>
> I recently upgraded from 2.6.16 to 2.6.19 on my Mac (OSX 10.13.2). In the 
> prior setup, I had upgraded Finance::Quote to 1.47, added a shell variable 
> for the Alphavantage key, added the same key to 
> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment, 
> changed all my stocks to use other:alphavantage, and I was able to retrieve 
> quotes.
>
>
> Upon upgrade, I find I am no longer able to retrieve AlphaVantage quotes. 
> F::Q 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 alphavantage 
> AAPL
>
> Finance::Quote fields Gnucash uses:
>
>     symbol: AAPL                <=== required
>
>       date: 01/23/2018          <=== recommended
>
>   currency: USD                  <=== required
>
>       last: 178.6400            <=\     
>
>       nav:                      <=== one of these
>
>     price:                      <=/       
>
>   timezone:                      <=== optional
>
>
> I have restored the following two lines into the aforementioned lines to 
> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:
>
>
> # Set AlphaVantage API Key to allow Finance::Quote to work
>
> ALPHAVANTAGE_API_KEY=8SET
>
>
> Unfortunately, I am getting the dreaded "There was an unknown error while 
> retrieving the price quotes.”
>
>
> I welcome any reminders on what I have missed, or how to debug this further.
>
>
> TIA,
>
> David T.
>
> ___
>
> gnucash-user mailing list
>
> gnucash-user@gnucash.org
>
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
> -
>
> Please remember to CC this list on all your replies.
>
> You can do this by using Reply-To-List or Reply-All.
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reports very slow to open

2018-01-23 Thread David Carlson 
There has been a long standing problem with reports that need to process a
lot of records being slow to open for most every release in the 2.6 series
in Windows, if I recall.  However, if release 2.6.19 is now slow even with
simple reports, that is a new issue.  I think that the upcoming 3.0 series
will be substantially improved.

Do you have any memorized reports that are very simple to process, say a
balance report for a small number of accounts?  Are those slow to open too?

David C

On Tue, Jan 23, 2018 at 12:05 PM, Christopher Stubbs <
chrisastu...@outlook.com> wrote:

> Like Ron Burek (7 Jan 2018) I am running Gnucash 2.6.19 on Windows 10 pro,
> fully updated.
> When you try to open any report, transaction report, profit & loss etc,
> Gnucash goes into a long time wait mode with the blank report tab open,
> typically about 3 or 4 minutes, before the report actually opens. Once you
> have any report open then running another one is no problem.
> If you try to do anything else in Gnucash while you are waiting for the
> report to open you get the message "Gnucash is not responding" in the top
> ribbon and everything greys out.
> This is all totally reproducible every time, not just occasionally.
> This seems to have started to happen with 2.6.19 and the latest Windows 10
> update (KB4056892 in early January). I don't know if this is just
> coincidence.
> Anybody got any ideas about a fix?
>
> Thanks
>
> Chris Stubbs
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Installation on Windows 10

2018-01-23 Thread David Carlson 
Glad you were able to resolve your write issue.  Why your AV is that
sensitive, I am not sure.  Did you have to whitelist all the other programs
that you use regularly?

Anyway, your comment about GnuCash doing unnecessary things like repeatedly
asking for random numbers in Windows is interesting.  I wonder if a
developer would suggest creating a bug report for that.

David C

On Tue, Jan 23, 2018 at 10:18 AM, Snarky Email  wrote:

>Got back to work on this and discovered that my antivirus (bitdefender)
>was blocking gnucash from writing files.  I had to whitelist the exe
>and it works.
>on a side note, I was using process monitor to try to figure out the
>issue and noticed that there are a lot of failed access to
>C:/dev/urandom.  On linux this is for random numbers, on windows it
>creates a fair amount of usless overhead.
>
>Sent: Monday, January 15, 2018 at 10:42 PM
>From: "Chris Smith" 
>To: No recipient address
>Cc: "Snarky Email" , gnucash-user@gnucash.org
>Subject: Re: Installation on Windows 10
>Try run in gnucash as administrator by right clicking on the icon and
>selecting "Run as administrator"
>
>What does that do?
>
>On Jan 15, 2018 9:13 PM, "David Carlson"
><[1]david.carlson@gmail.com> wrote:
>
>  Can you save other documents such as spreadsheets to that folder?
>  Is there
>  plenty of free space on your C: drive (like several GIG's)? is this
>  machine
>  owned by someone else such as your employer?
>  David C
>  On Mon, Jan 15, 2018 at 8:17 PM, Snarky Email
>  <[2]snarkyem...@gmx.com> wrote:
>  > David,
>  >
>  > I did create subfolder but the same error pops up.  I definetly
>  have full
>  > access to the folder and subfolder.  Is there any special first
>  time steps
>  > that I could be missing?
>  >
>  >
>  >
>  > *Sent:* Sunday, January 14, 2018 at 3:51 PM
>  > *From:* "David Carlson" <[3]david.carlson@gmail.com>
>  > *To:* "Snarky Email" <[4]snarkyem...@gmx.com>
>  > *Cc:* "Gnucash Users" <[5]gnucash-user@gnucash.org>
>  > *Subject:* Re: Installation on Windows 10
>  > Snarky,
>  >
>  > It does seem very odd that GnuCash is unable to write to that
>  folder.  Can
>  > you save other documents to that folder?
>  >
>  > I would recommend creating a special subfolder for GnuCash data
>  files as
>  > GnuCash will be creating a lot of temporary files in the same
>  folder.
>  >
>  > David C
>  >
>  >
>  > On Jan 14, 2018 12:52 PM, "Snarky Email" <[6]snarkyem...@gmx.com>
>  wrote:
>  >>
>  >>I installed gnucash on my Windows 10 system and the new file
>  setup
>  >>fails.  I am using defaults for a new account to practice/test
>  with.
>  >>When I try to save as xml I get this error:  GnuCash could not
>  write to
>  >>C:\Users\Joe\Documents\gnucashtest.gnucash.  That database may
>  be on a
>  >>read-only file system, or you may not have write permission
>  for the
>  >>directory."
>  >>I do have full access on the folder.
>  >>Any help would be appreciated.
>  >> ___
>  >> gnucash-user mailing list
>  >> [7]gnucash-user@gnucash.org
>  >> [8]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
>  [9]gnucash-user@gnucash.org
>  [10]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.
>
> References
>
>1. mailto:david.carlson@gmail.com
>2. mailto:snarkyem...@gmx.com
>3. mailto:david.carlson@gmail.com
>4. mailto:snarkyem...@gmx.com
>5. mailto:gnucash-user@gnucash.org
>6. mailto:snarkyem...@gmx.com
>7. mailto:gnucash-user@gnucash.org
>8. https://lists.gnucash.org/mailman/listinfo/gnucash-user
>9. mailto:gnucash-user@gnucash.org
>   10. https://lists.gnucash.org/mailman/listinfo/gnucash-user
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Price Retrieval Failure

2018-01-23 Thread Derek Atkins 
Did you update the environment file again after the upgrade? The update 
process overwrites that file.


-derek
Sent using my mobile device. Please excuse any typos.



On January 23, 2018 1:08:36 PM D via gnucash-user 
 wrote:


Thanks. As I noted originally, my file was correctly configured and 
retrieving quotes from Alphavantage before the upgrade. Regardless, I had 
double checked that as well.


Did you know that you can display the quote source for your securities on 
the main securities page? I didn't, before this.


David

On January 23, 2018, at 10:25 PM, david amaral  wrote:

Verify security editor for your investments have get quotes checked 
and AlphaVantage  listed as source for each entry.




From: David T. via gnucash-user 
To: Gnucash Users 
Sent: Tuesday, January 23, 2018 10:07 AM
Subject: Price Retrieval Failure


Hello,


I recently upgraded from 2.6.16 to 2.6.19 on my Mac (OSX 10.13.2). In the 
prior setup, I had upgraded Finance::Quote to 1.47, added a shell variable 
for the Alphavantage key, added the same key to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment, 
changed all my stocks to use other:alphavantage, and I was able to retrieve 
quotes.



Upon upgrade, I find I am no longer able to retrieve AlphaVantage quotes. 
F::Q 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 alphavantage 
AAPL


Finance::Quote fields Gnucash uses:

    symbol: AAPL                <=== required

      date: 01/23/2018          <=== recommended

  currency: USD                  <=== required

      last: 178.6400            <=\     

      nav:                      <=== one of these

    price:                      <=/       

  timezone:                      <=== optional


I have restored the following two lines into the aforementioned lines to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:



# Set AlphaVantage API Key to allow Finance::Quote to work

ALPHAVANTAGE_API_KEY=8SET


Unfortunately, I am getting the dreaded "There was an unknown error while 
retrieving the price quotes.”



I welcome any reminders on what I have missed, or how to debug this further.


TIA,

David T.

___

gnucash-user mailing list

gnucash-user@gnucash.org

https://lists.gnucash.org/mailman/listinfo/gnucash-user

-

Please remember to CC this list on all your replies.

You can do this by using Reply-To-List or Reply-All.



___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Price Retrieval Failure

2018-01-23 Thread D via gnucash-user 
Thanks. As I noted originally, my file was correctly configured and retrieving 
quotes from Alphavantage before the upgrade. Regardless, I had double checked 
that as well. 

Did you know that you can display the quote source for your securities on the 
main securities page? I didn't, before this.

David

On January 23, 2018, at 10:25 PM, david amaral  wrote:

Verify security editor for your investments have get quotes checked and 
AlphaVantage  listed as source for each entry.



From: David T. via gnucash-user 
To: Gnucash Users  
Sent: Tuesday, January 23, 2018 10:07 AM
Subject: Price Retrieval Failure


Hello,


I recently upgraded from 2.6.16 to 2.6.19 on my Mac (OSX 10.13.2). In the prior 
setup, I had upgraded Finance::Quote to 1.47, added a shell variable for the 
Alphavantage key, added the same key to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment, changed 
all my stocks to use other:alphavantage, and I was able to retrieve quotes.


Upon upgrade, I find I am no longer able to retrieve AlphaVantage quotes. F::Q 
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 alphavantage AAPL

Finance::Quote fields Gnucash uses:

    symbol: AAPL                <=== required

      date: 01/23/2018          <=== recommended

  currency: USD                  <=== required

      last: 178.6400            <=\      

      nav:                      <=== one of these

    price:                      <=/        

  timezone:                      <=== optional


I have restored the following two lines into the aforementioned lines to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:


# Set AlphaVantage API Key to allow Finance::Quote to work

ALPHAVANTAGE_API_KEY=8SET


Unfortunately, I am getting the dreaded "There was an unknown error while 
retrieving the price quotes.”


I welcome any reminders on what I have missed, or how to debug this further.


TIA,

David T.

___

gnucash-user mailing list

gnucash-user@gnucash.org

https://lists.gnucash.org/mailman/listinfo/gnucash-user

-

Please remember to CC this list on all your replies.

You can do this by using Reply-To-List or Reply-All.



___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Reports very slow to open

2018-01-23 Thread Christopher Stubbs 
Like Ron Burek (7 Jan 2018) I am running Gnucash 2.6.19 on Windows 10 pro, 
fully updated.
When you try to open any report, transaction report, profit & loss etc, Gnucash 
goes into a long time wait mode with the blank report tab open, typically about 
3 or 4 minutes, before the report actually opens. Once you have any report open 
then running another one is no problem.
If you try to do anything else in Gnucash while you are waiting for the report 
to open you get the message "Gnucash is not responding" in the top ribbon and 
everything greys out.
This is all totally reproducible every time, not just occasionally.
This seems to have started to happen with 2.6.19 and the latest Windows 10 
update (KB4056892 in early January). I don't know if this is just coincidence.
Anybody got any ideas about a fix?

Thanks

Chris Stubbs
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Price Retrieval Failure

2018-01-23 Thread david amaral via gnucash-user 
Verify security editor for your investments have get quotes checked and 
AlphaVantage  listed as source for each entry.

  From: David T. via gnucash-user 
 To: Gnucash Users  
 Sent: Tuesday, January 23, 2018 10:07 AM
 Subject: Price Retrieval Failure
   
Hello,

I recently upgraded from 2.6.16 to 2.6.19 on my Mac (OSX 10.13.2). In the prior 
setup, I had upgraded Finance::Quote to 1.47, added a shell variable for the 
Alphavantage key, added the same key to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment, changed 
all my stocks to use other:alphavantage, and I was able to retrieve quotes.

Upon upgrade, I find I am no longer able to retrieve AlphaVantage quotes. F::Q 
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 alphavantage AAPL
Finance::Quote fields Gnucash uses:
    symbol: AAPL                <=== required
      date: 01/23/2018          <=== recommended
  currency: USD                  <=== required
      last: 178.6400            <=\      
      nav:                      <=== one of these
    price:                      <=/        
  timezone:                      <=== optional

I have restored the following two lines into the aforementioned lines to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:

# Set AlphaVantage API Key to allow Finance::Quote to work
ALPHAVANTAGE_API_KEY=8SET

Unfortunately, I am getting the dreaded "There was an unknown error while 
retrieving the price quotes.”

I welcome any reminders on what I have missed, or how to debug this further.

TIA,
David T.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

   
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Price Retrieval Failure

2018-01-23 Thread David T. via gnucash-user 
Hello,

I recently upgraded from 2.6.16 to 2.6.19 on my Mac (OSX 10.13.2). In the prior 
setup, I had upgraded Finance::Quote to 1.47, added a shell variable for the 
Alphavantage key, added the same key to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment, changed 
all my stocks to use other:alphavantage, and I was able to retrieve quotes.

Upon upgrade, I find I am no longer able to retrieve AlphaVantage quotes. F::Q 
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 alphavantage AAPL
Finance::Quote fields Gnucash uses:
symbol: AAPL <=== required
  date: 01/23/2018   <=== recommended
  currency: USD  <=== required
  last: 178.6400 <=\   
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

I have restored the following two lines into the aforementioned lines to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:

# Set AlphaVantage API Key to allow Finance::Quote to work
ALPHAVANTAGE_API_KEY=8SET

Unfortunately, I am getting the dreaded "There was an unknown error while 
retrieving the price quotes.”

I welcome any reminders on what I have missed, or how to debug this further.

TIA,
David T.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Installation on Windows 10

2018-01-23 Thread Snarky Email 
   Got back to work on this and discovered that my antivirus (bitdefender)
   was blocking gnucash from writing files.  I had to whitelist the exe
   and it works.
   on a side note, I was using process monitor to try to figure out the
   issue and noticed that there are a lot of failed access to
   C:/dev/urandom.  On linux this is for random numbers, on windows it
   creates a fair amount of usless overhead.

   Sent: Monday, January 15, 2018 at 10:42 PM
   From: "Chris Smith" 
   To: No recipient address
   Cc: "Snarky Email" , gnucash-user@gnucash.org
   Subject: Re: Installation on Windows 10
   Try run in gnucash as administrator by right clicking on the icon and
   selecting "Run as administrator"

   What does that do?

   On Jan 15, 2018 9:13 PM, "David Carlson"
   <[1]david.carlson@gmail.com> wrote:

 Can you save other documents such as spreadsheets to that folder?
 Is there
 plenty of free space on your C: drive (like several GIG's)? is this
 machine
 owned by someone else such as your employer?
 David C
 On Mon, Jan 15, 2018 at 8:17 PM, Snarky Email
 <[2]snarkyem...@gmx.com> wrote:
 > David,
 >
 > I did create subfolder but the same error pops up.  I definetly
 have full
 > access to the folder and subfolder.  Is there any special first
 time steps
 > that I could be missing?
 >
 >
 >
 > *Sent:* Sunday, January 14, 2018 at 3:51 PM
 > *From:* "David Carlson" <[3]david.carlson@gmail.com>
 > *To:* "Snarky Email" <[4]snarkyem...@gmx.com>
 > *Cc:* "Gnucash Users" <[5]gnucash-user@gnucash.org>
 > *Subject:* Re: Installation on Windows 10
 > Snarky,
 >
 > It does seem very odd that GnuCash is unable to write to that
 folder.  Can
 > you save other documents to that folder?
 >
 > I would recommend creating a special subfolder for GnuCash data
 files as
 > GnuCash will be creating a lot of temporary files in the same
 folder.
 >
 > David C
 >
 >
 > On Jan 14, 2018 12:52 PM, "Snarky Email" <[6]snarkyem...@gmx.com>
 wrote:
 >>
 >>I installed gnucash on my Windows 10 system and the new file
 setup
 >>fails.  I am using defaults for a new account to practice/test
 with.
 >>When I try to save as xml I get this error:  GnuCash could not
 write to
 >>C:\Users\Joe\Documents\gnucashtest.gnucash.  That database may
 be on a
 >>read-only file system, or you may not have write permission
 for the
 >>directory."
 >>I do have full access on the folder.
 >>Any help would be appreciated.
 >> ___
 >> gnucash-user mailing list
 >> [7]gnucash-user@gnucash.org
 >> [8]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
 [9]gnucash-user@gnucash.org
 [10]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.

References

   1. mailto:david.carlson@gmail.com
   2. mailto:snarkyem...@gmx.com
   3. mailto:david.carlson@gmail.com
   4. mailto:snarkyem...@gmx.com
   5. mailto:gnucash-user@gnucash.org
   6. mailto:snarkyem...@gmx.com
   7. mailto:gnucash-user@gnucash.org
   8. https://lists.gnucash.org/mailman/listinfo/gnucash-user
   9. mailto:gnucash-user@gnucash.org
  10. https://lists.gnucash.org/mailman/listinfo/gnucash-user
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Are there plans for an export expansion?

2018-01-23 Thread Chris Good 
 Message: 16
Date: Tue, 23 Jan 2018 10:07:47 +0500
From: D 
To: Rick Copple , Gnucash Users

Subject: Re: Are there plans for an export expansion?
Message-ID: 
Content-Type: text/plain; charset=utf-8

Rick,

I can't speak for the developers, but I haven't heard anyone raise this
before, so I don't think it's on anyone's agenda.

That said, you might look at saving the file in SQL and using a database
query to extract the data you seek.

David

On January 23, 2018, at 9:29 AM, Rick Copple 
wrote:

Hi,

First time posting to this list. I've been using GNUCash for several
years now. Currently on a Lunbuntu computer, using GNUCash version
2.6.12. I use it for 4 different businesses, and aside from having no
inventory function (I track that in a spreadsheet), it serves my
purposes quite well. So, first off, thank you for having this program.
It does a great job and is pretty flexible in general.

I wanted to know if there was a plan for an export of the various lists
like vendor, customer, employee, etc. I see where they can be imported,
but no ability to export them. I've tried some of the solutions of
creating a transaction report, but I've not be able to get that to
include fields like addresses, phone #s, etc. Just the company name.

Related to that, it would be nice to be able to do a list report, which
could be used to export those same lists, a report that would allow for
listing all the fields in the different lists.

So, are there any plans for this feature? Thank you!


--
Rick Copple
Window Cleaning Specialist


Hi Rick,

I'm not at my computer but from memory you can use the Customer or Vendor
Summary. Select the required fields using the report options, then use
Ctrl-A to select everything, then copy and paste into a spreadsheet.

Regards, Chris Good
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reports Not Responding Windows 10

2018-01-23 Thread Christopher Lam 
Your account currency is R.
Your report currency is $.
Your data file has no R/$ price information. That's why.

Edit option, change report to R.

On 23 Jan 2018 16:52, "michaelwithms"  wrote:

I have installed Gnucash this morning. All fine except the reports do not
carry totals across . i am win10 user . please see screen shot





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reports Not Responding Windows 10

2018-01-23 Thread Maf. King 
On Tuesday, 23 January 2018 04:24:07 GMT michaelwithms wrote:
> I have installed Gnucash this morning. All fine except the reports do not
> carry totals across . i am win10 user . please see screen shot
> 
> 


Hi Michael,

My guess from your screenshot is that you have a currency issue.  Looks like 
the transactions are in R but the report is totalling to $

not sure how to suggest fixing this, beyond checking that your default currency 
and locale and each account all match.

Maf.
 
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Reports Not Responding Windows 10

2018-01-23 Thread michaelwithms 
I have installed Gnucash this morning. All fine except the reports do not
carry totals across . i am win10 user . please see screen shot
 




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.