Re: [GNC] ofx/qfx import to V3

[DaveC49]

John,

For your info OFX import is working fine on Linux Mint/Ubuntu 16.04. The
only problem I had was that the previous automatic matching to accounts
seemed to have had the data cleared in the swap over to the V3 user
preferences files. After one import it had reestablished most of the
matching  account matches and worked fine.

David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconcile Window Vertical Scroll Bar

[John Ralls]

> On Apr 28, 2018, at 4:22 PM, Robin Chattopadhyay  wrote:
> 
> When the reconcile window is open, as I move the mouse to check the 'R' box
> and the pointer approaches the checkbox, the vertical scroll bar doubles in
> width and nearly covers up the checkbox.
> 
> This makes it difficult to click the checkbox and I end up clicking the
> scroll bar instead.
> 
> As the pointer moves away from the checkbox/scroll bar shared area, the
> scroll bar returns to it's original width.
> 
> My workaround has been to adjust the width of the Description column, which
> then widens the 'R' column so the checkbox isn't covered by the scroll bar.
> 
> This works, but the program doesn't remember the column widths from one
> time to the next. My question then... Is there a more permanent
> solution/workaround?
> 

https://bugzilla.gnome.org/show_bug.cgi?id=795101. Fixed for GnuCash 3.1, which 
will be released tomorrow.

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.

[GNC] Reconcile Window Vertical Scroll Bar

[Robin Chattopadhyay]

When the reconcile window is open, as I move the mouse to check the 'R' box
and the pointer approaches the checkbox, the vertical scroll bar doubles in
width and nearly covers up the checkbox.

This makes it difficult to click the checkbox and I end up clicking the
scroll bar instead.

As the pointer moves away from the checkbox/scroll bar shared area, the
scroll bar returns to it's original width.

My workaround has been to adjust the width of the Description column, which
then widens the 'R' column so the checkbox isn't covered by the scroll bar.

This works, but the program doesn't remember the column widths from one
time to the next. My question then... Is there a more permanent
solution/workaround?

Gnucash 3.0
Linux Mint 18.3

Thanks,
Robin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] new v3.0 install Ubuntu 18.04 LTS

[John Ralls]

There are some non-Windows issues too, so it's worth waiting.

Most people have their browsers set up to download to $HOME/Downloads, but 
wherever your browser sends the tarball is fine as long as you can find it.
Once it's downloaded just say
  tar -xf /path/to/gnucash-3.1.tar.bz2
from your home directory. Tar will create the gnucash-3.1 directory for you.

Regards,
John Ralls


> On Apr 28, 2018, at 3:18 PM, Dennis Powless  wrote:
> 
> I think I will, thanks.
> 
> Is 3.1 mostly for the windows issues or are there linux issues too?
> 
> I've noticed when I go to extract the file, it ask for the location, so I'll 
> create that folder on my home directory, then extract to it.
> 
> Dennis 
> 
> On Sat, Apr 28, 2018 at 6:03 PM, John Ralls  wrote:
> The most common place would be to your home directory. It will create a new 
> directory gnucash-3.0, so you'll adjust the tail of the cmake command to 
> ../gnucash-3.0.
> 
> I'm working on releasing 3.1 right now so you may want to wait a day and 
> build that release instead.
> 
> Regards,
> John Ralls
> 
> > On Apr 28, 2018, at 1:46 PM, Dennis Powless  wrote:
> > 
> > I can't seem to find where I extract the file to.  I dl the
> > gnucash-3.0.tar.bz2 file from the gnucash site.  I'm not clear where to
> > extract to...  should I send it to a gnucash folder in my home directory,
> > or does it need to be in the hidden folders someplace?  I see some
> > references state to extract to the desktop.
> > 
> > 
> > Thanks,
> > 
> > D
> > 
> > On Sat, Apr 28, 2018 at 12:37 PM, Geert Janssens  >> wrote:
> > 
> >> Op zaterdag 28 april 2018 18:18:50 CEST schreef Dennis Powless:
> >>> I was not able to install the swig2.0..  says it's not available and
> >>> there is something else.
> >>> 
> >>> I looked and found that swig2.0 is quite old and the newer version is
> >> 3.xxx
> >>> or something.
> >>> 
> >>> Do I need the newer version?
> >>> 
> >> swig3 will work fine as well.
> >> 
> >>> 
> >>> so, I DL the gnucase file then extract it do I need to create the
> >>> gnucase file?
> >> Typically extracting will create the directory for you. But you may need
> >> to
> >> adapt the exact commands a bit depending on the exact file and directory
> >> names
> >> you use on your system.
> >> 
> >>> 
> >>> I would then cd to the gnucase folder and run the second part of the
> >>> directions.
> >> 
> >> Yes, although the instructions mention a gnucash folder, not a gnucase one
> >> :)
> >> 
> >> 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 CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] new v3.0 install Ubuntu 18.04 LTS

[Dennis Powless]

I think I will, thanks.

Is 3.1 mostly for the windows issues or are there linux issues too?

I've noticed when I go to extract the file, it ask for the location, so
I'll create that folder on my home directory, then extract to it.

Dennis

On Sat, Apr 28, 2018 at 6:03 PM, John Ralls  wrote:

> The most common place would be to your home directory. It will create a
> new directory gnucash-3.0, so you'll adjust the tail of the cmake command
> to ../gnucash-3.0.
>
> I'm working on releasing 3.1 right now so you may want to wait a day and
> build that release instead.
>
> Regards,
> John Ralls
>
> > On Apr 28, 2018, at 1:46 PM, Dennis Powless  wrote:
> >
> > I can't seem to find where I extract the file to.  I dl the
> > gnucash-3.0.tar.bz2 file from the gnucash site.  I'm not clear where to
> > extract to...  should I send it to a gnucash folder in my home directory,
> > or does it need to be in the hidden folders someplace?  I see some
> > references state to extract to the desktop.
> >
> >
> > Thanks,
> >
> > D
> >
> > On Sat, Apr 28, 2018 at 12:37 PM, Geert Janssens <
> geert.gnuc...@kobaltwit.be
> >> wrote:
> >
> >> Op zaterdag 28 april 2018 18:18:50 CEST schreef Dennis Powless:
> >>> I was not able to install the swig2.0..  says it's not available
> and
> >>> there is something else.
> >>>
> >>> I looked and found that swig2.0 is quite old and the newer version is
> >> 3.xxx
> >>> or something.
> >>>
> >>> Do I need the newer version?
> >>>
> >> swig3 will work fine as well.
> >>
> >>>
> >>> so, I DL the gnucase file then extract it do I need to create the
> >>> gnucase file?
> >> Typically extracting will create the directory for you. But you may need
> >> to
> >> adapt the exact commands a bit depending on the exact file and directory
> >> names
> >> you use on your system.
> >>
> >>>
> >>> I would then cd to the gnucase folder and run the second part of the
> >>> directions.
> >>
> >> Yes, although the instructions mention a gnucash folder, not a gnucase
> one
> >> :)
> >>
> >> 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 CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] new v3.0 install Ubuntu 18.04 LTS

[John Ralls]

The most common place would be to your home directory. It will create a new 
directory gnucash-3.0, so you'll adjust the tail of the cmake command to 
../gnucash-3.0.

I'm working on releasing 3.1 right now so you may want to wait a day and build 
that release instead.

Regards,
John Ralls

> On Apr 28, 2018, at 1:46 PM, Dennis Powless  wrote:
> 
> I can't seem to find where I extract the file to.  I dl the
> gnucash-3.0.tar.bz2 file from the gnucash site.  I'm not clear where to
> extract to...  should I send it to a gnucash folder in my home directory,
> or does it need to be in the hidden folders someplace?  I see some
> references state to extract to the desktop.
> 
> 
> Thanks,
> 
> D
> 
> On Sat, Apr 28, 2018 at 12:37 PM, Geert Janssens > wrote:
> 
>> Op zaterdag 28 april 2018 18:18:50 CEST schreef Dennis Powless:
>>> I was not able to install the swig2.0..  says it's not available and
>>> there is something else.
>>> 
>>> I looked and found that swig2.0 is quite old and the newer version is
>> 3.xxx
>>> or something.
>>> 
>>> Do I need the newer version?
>>> 
>> swig3 will work fine as well.
>> 
>>> 
>>> so, I DL the gnucase file then extract it do I need to create the
>>> gnucase file?
>> Typically extracting will create the directory for you. But you may need
>> to
>> adapt the exact commands a bit depending on the exact file and directory
>> names
>> you use on your system.
>> 
>>> 
>>> I would then cd to the gnucase folder and run the second part of the
>>> directions.
>> 
>> Yes, although the instructions mention a gnucash folder, not a gnucase one
>> :)
>> 
>> 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 CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] quotes - internal server error

[John Ralls]

I'm guess then that the problem is somewhere in your perl http stack. Unless 
you're comfortable with perl development the simplest thing to try next is to 
uninstall perl and re-run the "Install Online Quotes Tool" in the GnuCash 
folder of the Start Menu.

Regards,
John Ralls


> On Apr 28, 2018, at 12:28 PM, Anne Bartley  wrote:
> 
> Yes, it did include the listing of modules. I assumed the information of 
> interest was the version code so I didn't include the rest. 
> 
> Anne
> 
> -Original Message-
> From: John Ralls [mailto:jra...@ceridwen.us] 
> Sent: Saturday, Apr 28, 2018 3:12 PM
> To: Anne Bartley
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] quotes - internal server error
> 
> Hmm, something I missed from your first post: You said that "The reply to 
> [perl gnc-fq-check] is 1.47".
> It should return 
> ("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")
> 
> Did it, and you just elided the rest, or did it not return the listing of the 
> modules?
> 
> Regards,
> John Ralls
> 
> 
> 
>> On Apr 28, 2018, at 8:28 AM, Anne Bartley  wrote:
>> 
>> I tried the URL  and got good data going back to early December. I had 
>> already done something similar which suggested to me that the problem isn’t 
>> at Alphavantage.
>> 
>> I tried gnc-fq-update and got this reponse:
>> Database was generated on Sat, 18 Apr 2018 14:48:16 GMT
>> Date::Manip is up to date (6.61).
>> Finance::Quote is up to date (1.47).
>> 
>> I appreciate your help. I hope you’ll have another suggestion.
>> 
>> Anne
>> 
>> From: John Ralls [mailto:jra...@ceridwen.us] 
>> Sent: Saturday, Apr 28, 2018 11:12 AM
>> To: Anne Bartley
>> Cc: gnucash Users-List
>> Subject: Re: [GNC] quotes - internal server error
>> 
>> Please remember to copy the list on all replies.
>> 
>> I tried munging my key and found that alphavantage didn’t seem to care, so 
>> that’s probably not a source of the problem.
>> 
>> You could try the URL
>> https://www.alphavantage.co/query?function=TIME_SERIES_DAILY=compact=json=XXX=JNJ
>> 
>> In your browser, replacing XXX with your API key. You should get 
>> a several-mont JSON dump of JNJ price history.
>> 
>> If that works then I’d suspect that something is wrong with the networking 
>> setup in your perl installation. Running gnc-fq-update might help.
>> 
>> Regards,
>> John Ralls
>> 
>>> On Apr 28, 2018, at 7:49 AM, Anne Bartley  wrote:
>>> 
>>> Thanks for the reply.
>>> 
>>> I just tried again and it didn't work.
>>> 
>>> I've been trying this for two weeks. There hasn't been much complaint so 
>>> there must be something wrong with my system but I can't figure out what.
>>> 
>>> One possible source of error is the API key but if I try to get a new one 
>>> from Alphavantage it tells me that I already have one and gives me the one 
>>> that I'm using so it can't be wrong.
>>> 
>>> Is there something else I can do?
>>> 
>>> Thank you.
>>> 
>>> Anne
>>> 
>>> 
>>> -Original Message-
>>> From: John Ralls [mailto:jra...@ceridwen.us] 
>>> Sent: Saturday, Apr 28, 2018 10:32 AM
>>> To: Anne Bartley
>>> Cc: gnucash-user@gnucash.org
>>> Subject: Re: [GNC] quotes - internal server error
>>> 
>>> 
>>> 
>>> 
>>> On Apr 26, 2018, at 6:49 PM, Anne Bartley  wrote:
>>> 
>>> The last online quote I have is on April 11. A few days later, they stopped
>>> working, The message is always "Unable to retrieve quotes for these items:
>>> ."
>>> 
>>> 
>>> 
>>> I tried updating to F::Q 1.47 and gnucash 2.6.21.  I found the new online
>>> quote entry in preferences and set it to my alphavantage API key but it
>>> still didn't work. After much digging around, here's what I came with to
>>> try:
>>> 
>>> 
>>> 
>>> In a cmd window on Windows 10:
>>> 
>>> 
>>> 
>>> cd ..\..\Program Files (x86)\gnucash\bin
>>> 
>>> set ALPHAVANTAGE_API_KEY=[my api key]
>>> 
>>> perl gnc-fq-dump -v alphavantage JNJ
>>> 
>>> 
>>> 
>>> There's nothing useful in 

Re: [GNC] new v3.0 install Ubuntu 18.04 LTS

[Dennis Powless]

I can't seem to find where I extract the file to.  I dl the
gnucash-3.0.tar.bz2 file from the gnucash site.  I'm not clear where to
extract to...  should I send it to a gnucash folder in my home directory,
or does it need to be in the hidden folders someplace?  I see some
references state to extract to the desktop.


Thanks,

D

On Sat, Apr 28, 2018 at 12:37 PM, Geert Janssens  wrote:

> Op zaterdag 28 april 2018 18:18:50 CEST schreef Dennis Powless:
> > I was not able to install the swig2.0..  says it's not available and
> > there is something else.
> >
> > I looked and found that swig2.0 is quite old and the newer version is
> 3.xxx
> > or something.
> >
> > Do I need the newer version?
> >
> swig3 will work fine as well.
>
> >
> > so, I DL the gnucase file then extract it do I need to create the
> > gnucase file?
> Typically extracting will create the directory for you. But you may need
> to
> adapt the exact commands a bit depending on the exact file and directory
> names
> you use on your system.
>
> >
> > I would then cd to the gnucase folder and run the second part of the
> > directions.
>
> Yes, although the instructions mention a gnucash folder, not a gnucase one
> :)
>
> 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: [GNC] ofx/qfx import to V3

[Deken via gnucash-user]

 David,
Thanks!
I was able to get and install the April 28 build. 
(https://code.gnucash.org/builds/win32/maint/gnucash-3.0-2018-04-28-git-3.0-116-gb761b5a0d+.setup.exe)
 Avast AV doesn't like either the installer or the installed executable to 
begin with but satisfies itself that both are malware free.

This version does import a QFX file, however I did still see some issues:
- the "Select an OFX/QFX file to process" dialog box had no apparent means of 
browsing to the file, nor of entering any sort of path to the file.  It did 
open the last location I imported from. So, to test, I moved the current import 
to that location - no problem.
- the import process seemed to be less adept at matching transactions than it 
has been previously, though without going back and testing a previous version I 
can't be completely certain.  However, I've been using Gnucash and this feature 
in particular for a long time and I'm pretty sure.  (I just went to check how 
long by opening an old Gnucash archive - the "File/Open" dialog box also does 
not allow browsing to another directory or entry of a path) (opened the oldest 
gnucash file I have available.  I've been using it since at least 2007 and this 
is the first issue I've experienced - huge thank you to all that have made that 
possible!)

 - I believe that a couple of transactions that were matched were also 
duplicated in the register.  The file auto-saved so I can't readily back out 
the changes to confirm this...

Thank you again.

Deken

 

-Original Message-
From: David Carlson 
To: dekenbluz 
Cc: Geert Janssens ; Gnucash Users 

Sent: Sat, Apr 28, 2018 3:12 pm
Subject: Re: [GNC] ofx/qfx import to V3



A moment ago I was able to refresh a link to 
https://code.gnucash.org/builds/win32/maint/ and see that there is now a build 
dated April 28.  Perhaps you had a temporary connection issue.



On Sat, Apr 28, 2018 at 12:36 PM, Deken via gnucash-user 
 wrote:

I'm willing to try but both the direct link and the link to the directory 
without the filename time out. I'm unable to download.

Deken








-Original Message-
From: Geert Janssens 
To: gnucash-user ; dekenbluz 
Cc: jralls 
Sent: Sat, Apr 28, 2018 12:37 pm
Subject: Re: [GNC] ofx/qfx import to V3

All the way down on the bug report was a link to a more recent gnucash build 
with plenty of fixes applied:
https://code.gnucash.org/builds/win32/maint/gnucash-3.0-2018-04-27-git-3.0-94-g74fd6e046+.setup.exe
Have you tried installing that one and test the ofx import stuff ?

Geert

Op zaterdag 28 april 2018 18:23:23 CEST schreef Deken via gnucash-user:
> Thank you, John. I reviewed
> https://bugzilla.gnome.org/show_bug.cgi?id=793461 and tried both the
> configuration change you suggested (adding the line 
> OFX_DTD_PATH={GNC_HOME}/share/libofx/dtd to
> GnuCash.app/Contents/Resources/etc/gnucash/environment), though I
> translated to 'Windows' as best I could.  It did not work - seemed to make
> no difference
> 
> I also tried replacing libofx-6.dll as suggested and supplied by "Bob" in
> comment 21.  That enabled me to import the QFX file but GNC still failed to
> complete the process, I wound up with both a balanced and an un-balanced
> transaction in the account's register.  And the unbalanced transaction
> would not delete when I tried to delete the transaction.
> 
> This is on Windows 7, on a machine that's in the process of being replaced -
> new Win10 machine due in next week, sometime.  Also, it's WAY too beautiful
> out to fight this today (60's & sunny in Rhode Island!  Finally!) So for
> me, for now, I'm rolling back to v2.6.19, which meets my needs.
> 
> Thank you for your time!
> 
> 
> On to the gardening projects...
> 
> 
>  Deken
> 
> 
> 
> -Original Message-
> From: John Ralls 
> To: dekenbluz 
> Cc: gnucash-user 
> Sent: Fri, Apr 27, 2018 2:58 pm
> Subject: Re: [GNC] ofx/qfx import to V3
> 
> > On Apr 27, 2018, at 11:02 AM, Deken via gnucash-user
> >  wrote:
> > 
> > New computer, new install of GNUCASH and went with the latest available,
> > v3.  Went to import a 'qfx' file, then a different 'ofx' file and got a
> > blank "List of downloaded transactions..." yet I was certain there should
> > be transactions to enter.  Uninstalled v3, installed v2.6.19 and re-tried
> > both imports.  Both worked.
> > 
> > The process doesn't appear to have changed.  Did I find some way to foul
> > it up?
> Probably not. See https://bugzilla.gnome.org/show_bug.cgi?id=793461.
> 
> Regards,
> John Ralls
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to 

Re: [GNC] quotes - internal server error

[John Ralls]

Hmm, something I missed from your first post: You said that "The reply to [perl 
gnc-fq-check] is 1.47".
It should return 
("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")

Did it, and you just elided the rest, or did it not return the listing of the 
modules?

Regards,
John Ralls



> On Apr 28, 2018, at 8:28 AM, Anne Bartley  wrote:
> 
> I tried the URL  and got good data going back to early December. I had 
> already done something similar which suggested to me that the problem isn’t 
> at Alphavantage.
>  
> I tried gnc-fq-update and got this reponse:
> Database was generated on Sat, 18 Apr 2018 14:48:16 GMT
> Date::Manip is up to date (6.61).
> Finance::Quote is up to date (1.47).
>  
> I appreciate your help. I hope you’ll have another suggestion.
>  
> Anne
>  
> From: John Ralls [mailto:jra...@ceridwen.us] 
> Sent: Saturday, Apr 28, 2018 11:12 AM
> To: Anne Bartley
> Cc: gnucash Users-List
> Subject: Re: [GNC] quotes - internal server error
>  
> Please remember to copy the list on all replies.
>  
> I tried munging my key and found that alphavantage didn’t seem to care, so 
> that’s probably not a source of the problem.
>  
> You could try the URL
> https://www.alphavantage.co/query?function=TIME_SERIES_DAILY=compact=json=XXX=JNJ
>  
> In your browser, replacing XXX with your API key. You should get 
> a several-mont JSON dump of JNJ price history.
>  
> If that works then I’d suspect that something is wrong with the networking 
> setup in your perl installation. Running gnc-fq-update might help.
>  
> Regards,
> John Ralls
>  
>> On Apr 28, 2018, at 7:49 AM, Anne Bartley  wrote:
>>  
>> Thanks for the reply.
>> 
>> I just tried again and it didn't work.
>> 
>> I've been trying this for two weeks. There hasn't been much complaint so 
>> there must be something wrong with my system but I can't figure out what.
>> 
>> One possible source of error is the API key but if I try to get a new one 
>> from Alphavantage it tells me that I already have one and gives me the one 
>> that I'm using so it can't be wrong.
>> 
>> Is there something else I can do?
>> 
>> Thank you.
>> 
>> Anne
>> 
>> 
>> -Original Message-
>> From: John Ralls [mailto:jra...@ceridwen.us] 
>> Sent: Saturday, Apr 28, 2018 10:32 AM
>> To: Anne Bartley
>> Cc: gnucash-user@gnucash.org
>> Subject: Re: [GNC] quotes - internal server error
>> 
>> 
>> 
>> 
>> On Apr 26, 2018, at 6:49 PM, Anne Bartley  wrote:
>> 
>> The last online quote I have is on April 11. A few days later, they stopped
>> working, The message is always "Unable to retrieve quotes for these items:
>> ."
>> 
>> 
>> 
>> I tried updating to F::Q 1.47 and gnucash 2.6.21.  I found the new online
>> quote entry in preferences and set it to my alphavantage API key but it
>> still didn't work. After much digging around, here's what I came with to
>> try:
>> 
>> 
>> 
>> In a cmd window on Windows 10:
>> 
>> 
>> 
>> cd ..\..\Program Files (x86)\gnucash\bin
>> 
>> set ALPHAVANTAGE_API_KEY=[my api key]
>> 
>> perl gnc-fq-dump -v alphavantage JNJ
>> 
>> 
>> 
>> There's nothing useful in what comes back. The errormsg is "Internal Server
>> Error"
>> 
>> 
>> 
>> I've done the following:
>> 
>> perl gnc-fq-check
>> 
>> perl -v
>> 
>> 
>> 
>> The reply to the first is 1.47. The reply to the second is "This is perl 5,
>> version 26, subversion 1. 
>> 
>> 
>> 
>> Can someone give me some advice on how to get quotes working again?
>> 
>> 
>> “Internal server error” usually means that the server you’re trying to 
>> connect to--i.e. alphavantage--had a problem with the request. It worked for 
>> me just now, so try again.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> ---
>> This email has been checked for viruses by AVG.
>> http://www.avg.com
>> 
>  
>  
> 
> Virus-free. www.avg.com

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:

Re: [GNC] ofx/qfx import to V3

[David Carlson]

A moment ago I was able to refresh a link to
https://code.gnucash.org/builds/win32/maint/ and see that there is now a
build dated April 28.  Perhaps you had a temporary connection issue.

On Sat, Apr 28, 2018 at 12:36 PM, Deken via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I'm willing to try but both the direct link and the link to the directory
> without the filename time out. I'm unable to download.
>
> Deken
>
>
>
>
>
>
>
> -Original Message-
> From: Geert Janssens 
> To: gnucash-user ; dekenbluz <
> dekenb...@netscape.net>
> Cc: jralls 
> Sent: Sat, Apr 28, 2018 12:37 pm
> Subject: Re: [GNC] ofx/qfx import to V3
>
> All the way down on the bug report was a link to a more recent gnucash
> build
> with plenty of fixes applied:
> https://code.gnucash.org/builds/win32/maint/gnucash-3.
> 0-2018-04-27-git-3.0-94-g74fd6e046+.setup.exe
> Have you tried installing that one and test the ofx import stuff ?
>
> Geert
>
> Op zaterdag 28 april 2018 18:23:23 CEST schreef Deken via gnucash-user:
> > Thank you, John. I reviewed
> > https://bugzilla.gnome.org/show_bug.cgi?id=793461 and tried both the
> > configuration change you suggested (adding the line
> > OFX_DTD_PATH={GNC_HOME}/share/libofx/dtd to
> > GnuCash.app/Contents/Resources/etc/gnucash/environment), though I
> > translated to 'Windows' as best I could.  It did not work - seemed to
> make
> > no difference
> >
> > I also tried replacing libofx-6.dll as suggested and supplied by "Bob" in
> > comment 21.  That enabled me to import the QFX file but GNC still failed
> to
> > complete the process, I wound up with both a balanced and an un-balanced
> > transaction in the account's register.  And the unbalanced transaction
> > would not delete when I tried to delete the transaction.
> >
> > This is on Windows 7, on a machine that's in the process of being
> replaced -
> > new Win10 machine due in next week, sometime.  Also, it's WAY too
> beautiful
> > out to fight this today (60's & sunny in Rhode Island!  Finally!) So for
> > me, for now, I'm rolling back to v2.6.19, which meets my needs.
> >
> > Thank you for your time!
> >
> >
> > On to the gardening projects...
> >
> >
> >  Deken
> >
> >
> >
> > -Original Message-
> > From: John Ralls 
> > To: dekenbluz 
> > Cc: gnucash-user 
> > Sent: Fri, Apr 27, 2018 2:58 pm
> > Subject: Re: [GNC] ofx/qfx import to V3
> >
> > > On Apr 27, 2018, at 11:02 AM, Deken via gnucash-user
> > >  wrote:
> > >
> > > New computer, new install of GNUCASH and went with the latest
> available,
> > > v3.  Went to import a 'qfx' file, then a different 'ofx' file and got a
> > > blank "List of downloaded transactions..." yet I was certain there
> should
> > > be transactions to enter.  Uninstalled v3, installed v2.6.19 and
> re-tried
> > > both imports.  Both worked.
> > >
> > > The process doesn't appear to have changed.  Did I find some way to
> foul
> > > it up?
> > Probably not. See https://bugzilla.gnome.org/show_bug.cgi?id=793461.
> >
> > 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.
>
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] SOLVED-Re: gnucash v2.6 new install can't open on lubuntu 16.04?

[vince]

Hello Geert,

Sorry, I only saw your email now. For some reason it never came through 
on the mailing list. I only saw it once I went on the forum.


Thank you so much! I did the
sudo /usr/bin/glib-compile-schemas /usr/share/glib-2.0/schemas as you 
suggested and gnucash is up and running.


I also checked if dconf is installed and found that according to 
synaptic a version called Dconf is installed which synaptic says is not 
connected with the older Debian package called dconf. So, not sure if 
I've got the correct version installed, but I've got gnucash working so 
all's well in my world.


Many thanks for your help.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] ofx/qfx import to V3

[Deken via gnucash-user]

I'm willing to try but both the direct link and the link to the directory 
without the filename time out. I'm unable to download.

Deken

 

 

 

-Original Message-
From: Geert Janssens 
To: gnucash-user ; dekenbluz 
Cc: jralls 
Sent: Sat, Apr 28, 2018 12:37 pm
Subject: Re: [GNC] ofx/qfx import to V3

All the way down on the bug report was a link to a more recent gnucash build 
with plenty of fixes applied:
https://code.gnucash.org/builds/win32/maint/gnucash-3.0-2018-04-27-git-3.0-94-g74fd6e046+.setup.exe
Have you tried installing that one and test the ofx import stuff ?

Geert

Op zaterdag 28 april 2018 18:23:23 CEST schreef Deken via gnucash-user:
> Thank you, John. I reviewed
> https://bugzilla.gnome.org/show_bug.cgi?id=793461 and tried both the
> configuration change you suggested (adding the line 
> OFX_DTD_PATH={GNC_HOME}/share/libofx/dtd to
> GnuCash.app/Contents/Resources/etc/gnucash/environment), though I
> translated to 'Windows' as best I could.  It did not work - seemed to make
> no difference
> 
> I also tried replacing libofx-6.dll as suggested and supplied by "Bob" in
> comment 21.  That enabled me to import the QFX file but GNC still failed to
> complete the process, I wound up with both a balanced and an un-balanced
> transaction in the account's register.  And the unbalanced transaction
> would not delete when I tried to delete the transaction.
> 
> This is on Windows 7, on a machine that's in the process of being replaced -
> new Win10 machine due in next week, sometime.  Also, it's WAY too beautiful
> out to fight this today (60's & sunny in Rhode Island!  Finally!) So for
> me, for now, I'm rolling back to v2.6.19, which meets my needs.
> 
> Thank you for your time!
> 
> 
> On to the gardening projects...
> 
> 
>  Deken
> 
> 
> 
> -Original Message-
> From: John Ralls 
> To: dekenbluz 
> Cc: gnucash-user 
> Sent: Fri, Apr 27, 2018 2:58 pm
> Subject: Re: [GNC] ofx/qfx import to V3
> 
> > On Apr 27, 2018, at 11:02 AM, Deken via gnucash-user
> >  wrote:
> > 
> > New computer, new install of GNUCASH and went with the latest available,
> > v3.  Went to import a 'qfx' file, then a different 'ofx' file and got a
> > blank "List of downloaded transactions..." yet I was certain there should
> > be transactions to enter.  Uninstalled v3, installed v2.6.19 and re-tried
> > both imports.  Both worked.
> > 
> > The process doesn't appear to have changed.  Did I find some way to foul
> > it up?
> Probably not. See https://bugzilla.gnome.org/show_bug.cgi?id=793461.
> 
> 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.





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] new v3.0 install Ubuntu 18.04 LTS

[Geert Janssens]

Op zaterdag 28 april 2018 18:18:50 CEST schreef Dennis Powless:
> I was not able to install the swig2.0..  says it's not available and
> there is something else.
> 
> I looked and found that swig2.0 is quite old and the newer version is 3.xxx
> or something.
> 
> Do I need the newer version?
> 
swig3 will work fine as well.

> 
> so, I DL the gnucase file then extract it do I need to create the
> gnucase file?
Typically extracting will create the directory for you. But you may need to 
adapt the exact commands a bit depending on the exact file and directory names 
you use on your system.

> 
> I would then cd to the gnucase folder and run the second part of the
> directions.

Yes, although the instructions mention a gnucash folder, not a gnucase one :)

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: [GNC] ofx/qfx import to V3

[Geert Janssens]

All the way down on the bug report was a link to a more recent gnucash build 
with plenty of fixes applied:
https://code.gnucash.org/builds/win32/maint/gnucash-3.0-2018-04-27-git-3.0-94-g74fd6e046+.setup.exe
Have you tried installing that one and test the ofx import stuff ?

Geert

Op zaterdag 28 april 2018 18:23:23 CEST schreef Deken via gnucash-user:
> Thank you, John. I reviewed
> https://bugzilla.gnome.org/show_bug.cgi?id=793461 and tried both the
> configuration change you suggested (adding the line 
> OFX_DTD_PATH={GNC_HOME}/share/libofx/dtd to
> GnuCash.app/Contents/Resources/etc/gnucash/environment), though I
> translated to 'Windows' as best I could.  It did not work - seemed to make
> no difference
> 
> I also tried replacing libofx-6.dll as suggested and supplied by "Bob" in
> comment 21.  That enabled me to import the QFX file but GNC still failed to
> complete the process, I wound up with both a balanced and an un-balanced
> transaction in the account's register.  And the unbalanced transaction
> would not delete when I tried to delete the transaction.
> 
> This is on Windows 7, on a machine that's in the process of being replaced -
> new Win10 machine due in next week, sometime.  Also, it's WAY too beautiful
> out to fight this today (60's & sunny in Rhode Island!  Finally!) So for
> me, for now, I'm rolling back to v2.6.19, which meets my needs.
> 
> Thank you for your time!
> 
> 
> On to the gardening projects...
> 
> 
>  Deken
> 
> 
> 
> -Original Message-
> From: John Ralls 
> To: dekenbluz 
> Cc: gnucash-user 
> Sent: Fri, Apr 27, 2018 2:58 pm
> Subject: Re: [GNC] ofx/qfx import to V3
> 
> > On Apr 27, 2018, at 11:02 AM, Deken via gnucash-user
> >  wrote:
> > 
> > New computer, new install of GNUCASH and went with the latest available,
> > v3.  Went to import a 'qfx' file, then a different 'ofx' file and got a
> > blank "List of downloaded transactions..." yet I was certain there should
> > be transactions to enter.  Uninstalled v3, installed v2.6.19 and re-tried
> > both imports.  Both worked.
> > 
> > The process doesn't appear to have changed.  Did I find some way to foul
> > it up?
> Probably not. See https://bugzilla.gnome.org/show_bug.cgi?id=793461.
> 
> 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.




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] new v3.0 install Ubuntu 18.04 LTS

[Dennis Powless]

I was not able to install the swig2.0..  says it's not available and
there is something else.

I looked and found that swig2.0 is quite old and the newer version is 3.xxx
or something.

Do I need the newer version?


so, I DL the gnucase file then extract it do I need to create the
gnucase file?

I would then cd to the gnucase folder and run the second part of the
directions.



D

On Sat, Apr 28, 2018 at 3:43 PM, Geert Janssens 
wrote:

> Op zaterdag 28 april 2018 16:33:21 CEST schreef Dennis Powless:
> > I just installed ubuntu 18.04 LTS on my dual boot machine.  I want to
> > install v 3.0 and the new ubuntu only has 2.6.19 in the software center.
> > What is the best method to get v3.0 installed instead of the older
> version?
> >
> > I see instructions here
> > https://wiki.gnucash.org/wiki/Building
> >
> > And scrolled down I see these instructions.  I'm assuming this will
> > work for 18.04LTS?
> > Ubuntu 16.04 LTS (Xenial Xerus)
> >
> > To build Gnucash 3.0 from source you need to install following packages:
> >
> > sudo apt-get install cmake
> > sudo apt-get install libtool libltdl-dev
> > sudo apt-get install libglib2.0-dev
> > sudo apt-get install icu-devtools libicu-dev
> > sudo apt-get install libboost-all-dev
> > sudo apt-get install guile-2.0 guile-2.0-dev
> > sudo apt-get install swig2.0
> > sudo apt-get install libxml++2.6-dev
> > sudo apt-get install libxslt1-dev
> > sudo apt-get install xsltproc
> > sudo apt-get install libgtest-dev
> > sudo apt-get install google-mock
> > sudo apt-get install gtk+3.0
> > sudo apt-get install libgtk-3-dev
> > sudo apt-get install libwebkit2gtk-4.0-37
> > sudo apt-get install libwebkit2gtk-4.0-dev
> > sudo apt-get install libdbi-dev
> >
> > mkdir build-cmakecd build-cmake
> > cmake -D CMAKE_INSTALL_PREFIX=/gnucash-cmake -D
> > WITH_AQBANKING=OFF -D WITH_OFX=OFF ../gnucash
> > make
> > sudo make install
> >
> >
> > I'm assuming I would then change the  with the downloaded gnucash
> > file, right?
>
> No. The target is where you want gnucash to be installed. The downloaded
> gnucash file should be extracted into a directory named "gnucash". And the
> cmake command as used in these instructions should be run from within a
> directory *next* to this "gnucash" directory, not from a directory
> *inside*
> it. You can read the generic instructions higher on that page to
> understand
> all the details.
>
> Good luck!
>
> 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: [GNC] new v3.0 install Ubuntu 18.04 LTS

[Geert Janssens]

Op zaterdag 28 april 2018 16:33:21 CEST schreef Dennis Powless:
> I just installed ubuntu 18.04 LTS on my dual boot machine.  I want to
> install v 3.0 and the new ubuntu only has 2.6.19 in the software center.
> What is the best method to get v3.0 installed instead of the older version?
> 
> I see instructions here
> https://wiki.gnucash.org/wiki/Building
> 
> And scrolled down I see these instructions.  I'm assuming this will
> work for 18.04LTS?
> Ubuntu 16.04 LTS (Xenial Xerus)
> 
> To build Gnucash 3.0 from source you need to install following packages:
> 
> sudo apt-get install cmake
> sudo apt-get install libtool libltdl-dev
> sudo apt-get install libglib2.0-dev
> sudo apt-get install icu-devtools libicu-dev
> sudo apt-get install libboost-all-dev
> sudo apt-get install guile-2.0 guile-2.0-dev
> sudo apt-get install swig2.0
> sudo apt-get install libxml++2.6-dev
> sudo apt-get install libxslt1-dev
> sudo apt-get install xsltproc
> sudo apt-get install libgtest-dev
> sudo apt-get install google-mock
> sudo apt-get install gtk+3.0
> sudo apt-get install libgtk-3-dev
> sudo apt-get install libwebkit2gtk-4.0-37
> sudo apt-get install libwebkit2gtk-4.0-dev
> sudo apt-get install libdbi-dev
> 
> mkdir build-cmakecd build-cmake
> cmake -D CMAKE_INSTALL_PREFIX=/gnucash-cmake -D
> WITH_AQBANKING=OFF -D WITH_OFX=OFF ../gnucash
> make
> sudo make install
> 
> 
> I'm assuming I would then change the  with the downloaded gnucash
> file, right?

No. The target is where you want gnucash to be installed. The downloaded 
gnucash file should be extracted into a directory named "gnucash". And the 
cmake command as used in these instructions should be run from within a 
directory *next* to this "gnucash" directory, not from a directory *inside* 
it. You can read the generic instructions higher on that page to understand 
all the details.

Good luck!

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: [GNC] quotes - internal server error

[John Ralls]

Please remember to copy the list on all replies.

I tried munging my key and found that alphavantage didn’t seem to care, so 
that’s probably not a source of the problem.

You could try the URL
https://www.alphavantage.co/query?function=TIME_SERIES_DAILY=compact=json=XXX=JNJ
 


In your browser, replacing XXX with your API key. You should get a 
several-mont JSON dump of JNJ price history.

If that works then I’d suspect that something is wrong with the networking 
setup in your perl installation. Running gnc-fq-update might help.

Regards,
John Ralls

> On Apr 28, 2018, at 7:49 AM, Anne Bartley  wrote:
> 
> Thanks for the reply.
> 
> I just tried again and it didn't work.
> 
> I've been trying this for two weeks. There hasn't been much complaint so 
> there must be something wrong with my system but I can't figure out what.
> 
> One possible source of error is the API key but if I try to get a new one 
> from Alphavantage it tells me that I already have one and gives me the one 
> that I'm using so it can't be wrong.
> 
> Is there something else I can do?
> 
> Thank you.
> 
> Anne
> 
> 
> -Original Message-
> From: John Ralls [mailto:jra...@ceridwen.us] 
> Sent: Saturday, Apr 28, 2018 10:32 AM
> To: Anne Bartley
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] quotes - internal server error
> 
> 
> 
>> On Apr 26, 2018, at 6:49 PM, Anne Bartley  wrote:
>> 
>> The last online quote I have is on April 11. A few days later, they stopped
>> working, The message is always "Unable to retrieve quotes for these items:
>> ."
>> 
>> 
>> 
>> I tried updating to F::Q 1.47 and gnucash 2.6.21.  I found the new online
>> quote entry in preferences and set it to my alphavantage API key but it
>> still didn't work. After much digging around, here's what I came with to
>> try:
>> 
>> 
>> 
>> In a cmd window on Windows 10:
>> 
>> 
>> 
>> cd ..\..\Program Files (x86)\gnucash\bin
>> 
>> set ALPHAVANTAGE_API_KEY=[my api key]
>> 
>> perl gnc-fq-dump -v alphavantage JNJ
>> 
>> 
>> 
>> There's nothing useful in what comes back. The errormsg is "Internal Server
>> Error"
>> 
>> 
>> 
>> I've done the following:
>> 
>> perl gnc-fq-check
>> 
>> perl -v
>> 
>> 
>> 
>> The reply to the first is 1.47. The reply to the second is "This is perl 5,
>> version 26, subversion 1. 
>> 
>> 
>> 
>> Can someone give me some advice on how to get quotes working again?
>> 
> 
> “Internal server error” usually means that the server you’re trying to 
> connect to--i.e. alphavantage--had a problem with the request. It worked for 
> me just now, so try again.
> 
> Regards,
> John Ralls
> 
> 
> ---
> This email has been checked for viruses by AVG.
> http://www.avg.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: [GNC] quotes - internal server error

[John Ralls]

> On Apr 26, 2018, at 6:49 PM, Anne Bartley  wrote:
> 
> The last online quote I have is on April 11. A few days later, they stopped
> working, The message is always "Unable to retrieve quotes for these items:
> ."
> 
> 
> 
> I tried updating to F::Q 1.47 and gnucash 2.6.21.  I found the new online
> quote entry in preferences and set it to my alphavantage API key but it
> still didn't work. After much digging around, here's what I came with to
> try:
> 
> 
> 
> In a cmd window on Windows 10:
> 
> 
> 
> cd ..\..\Program Files (x86)\gnucash\bin
> 
> set ALPHAVANTAGE_API_KEY=[my api key]
> 
> perl gnc-fq-dump -v alphavantage JNJ
> 
> 
> 
> There's nothing useful in what comes back. The errormsg is "Internal Server
> Error"
> 
> 
> 
> I've done the following:
> 
> perl gnc-fq-check
> 
> perl -v
> 
> 
> 
> The reply to the first is 1.47. The reply to the second is "This is perl 5,
> version 26, subversion 1. 
> 
> 
> 
> Can someone give me some advice on how to get quotes working again?
> 

“Internal server error” usually means that the server you’re trying to connect 
to--i.e. alphavantage--had a problem with the request. It worked for me just 
now, so try again.

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.

[GNC] new v3.0 install Ubuntu 18.04 LTS

[Dennis Powless]

I just installed ubuntu 18.04 LTS on my dual boot machine.  I want to
install v 3.0 and the new ubuntu only has 2.6.19 in the software center.
What is the best method to get v3.0 installed instead of the older version?

I see instructions here
https://wiki.gnucash.org/wiki/Building

And scrolled down I see these instructions.  I'm assuming this will
work for 18.04LTS?
Ubuntu 16.04 LTS (Xenial Xerus)

To build Gnucash 3.0 from source you need to install following packages:

sudo apt-get install cmake
sudo apt-get install libtool libltdl-dev
sudo apt-get install libglib2.0-dev
sudo apt-get install icu-devtools libicu-dev
sudo apt-get install libboost-all-dev
sudo apt-get install guile-2.0 guile-2.0-dev
sudo apt-get install swig2.0
sudo apt-get install libxml++2.6-dev
sudo apt-get install libxslt1-dev
sudo apt-get install xsltproc
sudo apt-get install libgtest-dev
sudo apt-get install google-mock
sudo apt-get install gtk+3.0
sudo apt-get install libgtk-3-dev
sudo apt-get install libwebkit2gtk-4.0-37
sudo apt-get install libwebkit2gtk-4.0-dev
sudo apt-get install libdbi-dev

mkdir build-cmakecd build-cmake
cmake -D CMAKE_INSTALL_PREFIX=/gnucash-cmake -D
WITH_AQBANKING=OFF -D WITH_OFX=OFF ../gnucash
make
sudo make install


I'm assuming I would then change the  with the downloaded gnucash
file, right?

Dennis
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash 3.0 Crashing

[Stan Brown]

On 2018-04-27 23:36, Bruce Michael wrote:
> I recently bought a new computer and then tried to access a file on Dropbox
> that had my accounting data.  The file was created with a previous version
> of Gnucash.  I installed v3.0 on the new computer and when i tried to
> access the file it said that it was locked and gave me the choice of
> opening it read-only, opening anyways, open another file or quitting.  I
> have tried the first two and when I due the program crashes.  Now, this
> message pops up whenever I try to open Gnucash and I cannot access my
> data.  I went to my old computer and I can still open the file with the
> previous version.  Does anyone have any suggestions?

I haven't seen any other answers to this.

Bruce, GnuCash creates a lock file when you open a data file, to prevent
two sessions from editing the same file at the same time. GnuCash
deletes the lock file when you close the data file. But if GnuCash
crashes, this does not happen, and the lock file remains.

Therefore, when you open GnuCash and it finds the lock file already
exists, that could mean that another GnuCash is running or that the
previous run crashed. GnuCash doesn't know which of those is true, and
it puts up the message. If you know that you have no other GnuCash
sessions running, then "Open anyway" is your appropriate choice.

I remember reading this in the Tutorial and Concepts Guide, but I can't
remember where. If you haven't read the Guide, you really ought to IMHO.



-- 
Regards,
Stan Brown
Tompkins County, New York, USA
http://BrownMath.com
http://OakRoadSystems.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: [GNC] accounts setup for a cooperation with members

[Mike or Penny Novack]

On 4/25/2018 8:50 AM, Martina di Vertacollini wrote:

Hi Everybody,

I am new to GnuCash and wish to set up the financial administration for
a cooperation with members/owners.

Can anybody help me with this?

--
Martina di Vertacollini
You problem is not "how to do this using gnucash" but "how to do this 
however the bookkeeping is done". In  other words, basic accounting for 
corporations << seek out a suitable text >>


That said, what kind of corporation* is this? A for profit? A 
non-profit? What jurisdiction are you operating in and what filings must 
you be able to do for this jurisdiction?


Michael D Novack

* For example, in the US there are different sorts of corporations. 
Since you refer to "members/owners" rather than "stockholders" could be 
one of the "pass through: sort like S corporations or LLCs.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] gnucash v2.6 new install can't open on lubuntu 16.04?

[Vince Hall]

 On 04/28/2018 09:12 AM, Colin Law wrote:

On 28 April 2018 at 08:03, vince  wrote:

> Hello the list,
> I've installed the above version of gnucash on lubuntu 16.04,(also a new
> install) and cannot get gnucash to open. This is on a older Dell precision
> workstation 390.
>
> The gnucash.trace report in /var says "* 08:22:27 OTHER 
> Settings schema 'org.gnucash.general' is not installed"
>
> This is something that's never happened before and I've used gnucash since
> ubuntu 7.04.
> I'm running the same version of gnucash on a netbook using Bodhi Linux v
> 4.5 and it's working perfectly!
>
> Any help or suggestions would really be appreciated.
>

Do you see any errors from
sudo apt-get update and sudo apt-get dist-upgrade

How did you install gnucash and what do the following commands show
which gnucash
apt-cache policy gnucash

Colin


Hello Colin,
Thanks so much for your quick reply.

To answer your questions. 1. No errors on update or dist-upgrade. 2. I
installed from the repository's using synaptic.
3. which gnucash = usr/bin/gnucash. 4. apt-cache policy gnucash =
Installed: 1:2.6.12-1
  Candidate: 1:2.6.12-1
  Version table:
 *** 1:2.6.12-1 500
500 http://za.archive.ubuntu.com/ubuntu xenial/universe amd64
Packages
100 /var/lib/dpkg/status

H
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] gnucash v2.6 new install can't open on lubuntu 16.04?

[Colin Law]

On 28 April 2018 at 09:24, vince  wrote:

> On 04/28/2018 09:12 AM, Colin Law wrote:
>
> On 28 April 2018 at 08:03, vince  wrote:
>
>> Hello the list,
>> I've installed the above version of gnucash on lubuntu 16.04,(also a new
>> install) and cannot get gnucash to open. This is on a older Dell precision
>> workstation 390.
>>
>> The gnucash.trace report in /var says "* 08:22:27 OTHER 
>> Settings schema 'org.gnucash.general' is not installed"
>>
>> This is something that's never happened before and I've used gnucash
>> since ubuntu 7.04.
>> I'm running the same version of gnucash on a netbook using Bodhi Linux v
>> 4.5 and it's working perfectly!
>>
>> Any help or suggestions would really be appreciated.
>>
>
> Do you see any errors from
> sudo apt-get update and sudo apt-get dist-upgrade
>
> How did you install gnucash and what do the following commands show
> which gnucash
> apt-cache policy gnucash
>
> Colin
>
>
> Hello Colin,
>
> A bit more information, or rather a question. when I called up "which
> gnucash" the file in usr/bin/gnucash showed owner as root. Is this correct
> or should I be the owner?
>

No, that is as it should be, the software itself is owned by root. Your
accounts file will be owned by you, but that will likely be in a subfolder
of your home directory.

Colin



>
> Vince
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash 3.0 Crashing

[Geert Janssens]

Op zaterdag 28 april 2018 05:36:50 CEST schreef Bruce Michael:
> I recently bought a new computer and then tried to access a file on Dropbox
> that had my accounting data.  The file was created with a previous version
> of Gnucash.  I installed v3.0 on the new computer and when i tried to
> access the file it said that it was locked and gave me the choice of
> opening it read-only, opening anyways, open another file or quitting.  I
> have tried the first two and when I due the program crashes.  Now, this
> message pops up whenever I try to open Gnucash and I cannot access my
> data.  I went to my old computer and I can still open the file with the
> previous version.  Does anyone have any suggestions?
> 
> Thanks,
> 
> Bruce
The "file is locked" message is what you get when gnucash can't close your 
file properly. And if gnucash crashes it obviously hasn't be able to do that. 
So after a crash this is a normal message.

There are several known crasher bugs in gnucash 3.0 on Windows. You could try 
again with a more recent nightly build
https://code.gnucash.org/builds/win32/maint/gnucash-3.0-2018-04-27-git-3.0-94-g74fd6e046+.setup.exe
This is not an official release, but  it has all the changes so far that will 
go into the next release. Most of those changes are directly addressing the 
windows issues.

Can you let us know how it works for you ?

Alternatively you can also choose to install the latest gnucash 2.6 release 
which is 2.6.21 which can be found on the Downloads page of the gnucash 
website.

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: [GNC] gnucash v2.6 new install can't open on lubuntu 16.04?

[vince]

On 04/28/2018 09:12 AM, Colin Law wrote:
On 28 April 2018 at 08:03, vince > wrote:


Hello the list,
I've installed the above version of gnucash on lubuntu 16.04,(also
a new install) and cannot get gnucash to open. This is on a older
Dell precision workstation 390.

The gnucash.trace report in /var says "* 08:22:27 OTHER 
Settings schema 'org.gnucash.general' is not installed"

This is something that's never happened before and I've used
gnucash since ubuntu 7.04.
I'm running the same version of gnucash on a netbook using Bodhi
Linux v 4.5 and it's working perfectly!

Any help or suggestions would really be appreciated.


Do you see any errors from
sudo apt-get update and sudo apt-get dist-upgrade

How did you install gnucash and what do the following commands show
which gnucash
apt-cache policy gnucash

Colin


Hello Colin,

A bit more information, or rather a question. when I called up "which 
gnucash" the file in usr/bin/gnucash showed owner as root. Is this 
correct or should I be the owner?


Vince
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Tool Bar 2.16.17 - Intel - Sorted!

[Geert Janssens]

Op woensdag 25 april 2018 16:17:01 CEST schreef Yvonne Mc Mahon:
> I’ve found it - of course!
> 
> Sorry for bothering you; I’m finding it a really good system - thank you!
> 
Nice to hear that, thank you.

Enjoy using gnucash :)

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: [GNC] gnucash v2.6 new install can't open on lubuntu 16.04?

[vince]

On 04/28/2018 09:12 AM, Colin Law wrote:
On 28 April 2018 at 08:03, vince > wrote:


Hello the list,
I've installed the above version of gnucash on lubuntu 16.04,(also
a new install) and cannot get gnucash to open. This is on a older
Dell precision workstation 390.

The gnucash.trace report in /var says "* 08:22:27 OTHER 
Settings schema 'org.gnucash.general' is not installed"

This is something that's never happened before and I've used
gnucash since ubuntu 7.04.
I'm running the same version of gnucash on a netbook using Bodhi
Linux v 4.5 and it's working perfectly!

Any help or suggestions would really be appreciated.


Do you see any errors from
sudo apt-get update and sudo apt-get dist-upgrade

How did you install gnucash and what do the following commands show
which gnucash
apt-cache policy gnucash

Colin


Hello Colin,
Thanks so much for your quick reply.

To answer your questions. 1. No errors on update or dist-upgrade. 2. I 
installed from the repository's using synaptic.
3. which gnucash = usr/bin/gnucash. 4. apt-cache policy gnucash = 
Installed: 1:2.6.12-1

  Candidate: 1:2.6.12-1
  Version table:
 *** 1:2.6.12-1 500
    500 http://za.archive.ubuntu.com/ubuntu xenial/universe amd64 
Packages

    100 /var/lib/dpkg/status

Hopefully this will throw some light on my problem.

I tried to open gnucash after doing the update and dist-upgrade, but no joy.

Vince
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Runtime error

[Anthony Marrian]

I'm currently running 2.6.21. Trying for 3.0 fails (as it's loading the data) 
with:

***
Microsoft Visual C++ Runtime Library

Runtime Error!

Program: c:\program files (x486)\gnucash\bin\gnucash.exe

This application has requested the Runtime to terminate it in an unusual way
***

Any ideas as to how to troubleshoot this? OS is Windows 10 Pro 64 bit
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Tool Bar 2.16.17 - Intel - Sorted!

[Yvonne Mc Mahon]

I’ve found it - of course!

Sorry for bothering you; I’m finding it a really good system - thank you!


> On 24 Apr 2018, at 20:31, Yvonne Mc Mahon  wrote:
> 
> Hi
> 
> I’m trying to create a new file for 2018.  On the You Tube tutorials it shows 
> a toolbar with File/Edit/View/Actions etc above the ‘Function’ bar of 
> Save/Close/Add Transaction etc. 
> 
> This toolbar is not showing on my version - how do I add it or where do I 
> find it please.  I will also need this to create P and Balance sheet 
> reports.
> 
> I have also downloaded the 3.0 version but still no Toolbar.
> 
> I look forward to your help - I’ve tried everything else!
> 
> Yvonne
> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] accounts setup for a cooperation with members

[Martina di Vertacollini]

   Hi Everybody,

   I am new to GnuCash and wish to set up the financial administration for
   a cooperation with members/owners.

   Can anybody help me with this?

   --
   Martina di Vertacollini
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] gnucash v2.6 new install can't open on lubuntu 16.04?

[Colin Law]

On 28 April 2018 at 08:03, vince  wrote:

> Hello the list,
> I've installed the above version of gnucash on lubuntu 16.04,(also a new
> install) and cannot get gnucash to open. This is on a older Dell precision
> workstation 390.
>
> The gnucash.trace report in /var says "* 08:22:27 OTHER 
> Settings schema 'org.gnucash.general' is not installed"
>
> This is something that's never happened before and I've used gnucash since
> ubuntu 7.04.
> I'm running the same version of gnucash on a netbook using Bodhi Linux v
> 4.5 and it's working perfectly!
>
> Any help or suggestions would really be appreciated.
>

Do you see any errors from
sudo apt-get update and sudo apt-get dist-upgrade

How did you install gnucash and what do the following commands show
which gnucash
apt-cache policy gnucash

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] gnucash v2.6 new install can't open on lubuntu 16.04?

[vince]

Hello the list,
I've installed the above version of gnucash on lubuntu 16.04,(also a new 
install) and cannot get gnucash to open. This is on a older Dell 
precision workstation 390.


The gnucash.trace report in /var says "* 08:22:27 OTHER  
Settings schema 'org.gnucash.general' is not installed"


This is something that's never happened before and I've used gnucash 
since ubuntu 7.04.
I'm running the same version of gnucash on a netbook using Bodhi Linux v 
4.5 and it's working perfectly!


Any help or suggestions would really be appreciated.

Vince



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