Re: [GNC] Error Retrieving Price Quotes - Windows 10

[Chris Good]

Hi Davy,

 

Looks to me like Bloomberg has changed their website so it no longer works 
unless you are using it interactively.

There’s probably not much Finance::Quote can do about it but it may be useful 
letting other people know about it by raising an issue at 
https://github.com/finance-quote/finance-quote/issues

 

I suggest you try to find another source for ALLAMAI:LX. Good luck.

 

Regards,

Chris Good

 

From: Davy Roid  
Sent: Wednesday, 17 June 2020 11:10 AM
To: Chris Good 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Error Retrieving Price Quotes - Windows 10

 

I am still running 3.10. It seems that I am getting the following error from 
bloomberg.pm   

 

When I try to run "perl gnc-fq-dump -v bloomberg ALLAMAI:LX", it returns 
something like

"Are you a Robot?"

"We've detected unusual activity from your computer network"
"To continue, please click the box below to let us know you're not a robot"

 

Any suggestions?

 

On Wed, Jun 17, 2020 at 8:55 AM Chris Good mailto:goodchri...@gmail.com> > wrote:

Message: 1
Date: Wed, 17 Jun 2020 00:37:43 +0800
From: Davy Roid mailto:davyr...@gmail.com> >
To: gnucash-user@gnucash.org  
Subject: [GNC] Error Retrieving Price Quotes - Windows 10
Message-ID:
mailto:camylkkeejncwfnut7xxhecjhv7y00anqpzk3o0eht3onefmt%...@mail.gmail.com> >
Content-Type: text/plain; charset="UTF-8"

I got the following errors while running gnucash --add-price-quotes (under
windows environment)

WARN  Could not kill child process: Access is denied.
ERROR  There was a system error while retrieving the price quotes.

The system was working perfectly fine the day before. I hard reset the PC
once as it was completely frozen.

Any idea how to fix it ?

Davy

Hi Davy,

Have you just upgraded to GnuCash 3.905?
It now gives an error message if you need an Alpha Vantage API key and the
args for getting quotes from a batch job have changed.
See
https://wiki.gnucash.org/wiki/Online_Quotes#Updating_enabled_Quotes_from_out
side_GnuCash

Try running Get Quotes from within GnuCash to see if there is an error msg.

See https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting

Regards, Chris Good

___
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] Get quotes problem with testing version 3.905

[Chris Good]

Message: 8
Date: Wed, 17 Jun 2020 08:53:24 +0930
From: John Bonnett 
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Get quotes problem with testing version 3.905
Message-ID: 
Content-Type: text/plain; charset=utf-8; format=flowed

Here is my previous email with the graphics replaced by some relevant text.
> I installed v3.905 to help with testing. I have a problem with getting 
> online quotes which worked fine with the latest release version. 
> Everything else has been OK so far.
>
> I get this message now:
>
ERROR:: ALPHAVANTAGE_API_KEY must be set for currency and quotes; see 
https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US
>
> Although that URL provides lots of good information, none of my active 
> stocks, for which I am trying to get online quotes, are using 
> Alphavantage. I do have some inactive/obsolete stocks which are 
> defaulting to Alphavantage. Most of my active stocks are from the 
> Australian exchange ASX. I have one on NASDAQ for which I am using 
> Yahoo-json but that does not seem to work and did not on the release 
> version either. Here are the versions in my About dialog:
>
Version 3.905

Build ID: 3.905+(2020-06-14)

Finance::Quote: 1.47

> Should I try to remove all reference to Alphavantage from even 
> inactive stocks?
>
> John Bonnett
>

Hi John,

If you haven't got a free Alpha Vantage API key and do have stocks that need
it, you either need to get an API key or untick 'Get Quotes' in the security
editor for those stocks using source alphavantage.
If you have accounts using multiple currencies, then you also need to untick
'Get Quotes' in the security editor for all the currencies if you don't want
exchange rates to be downloaded.

3.905 now gives you an error message rather that failing with an obscure
error msg.

See https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US

Regards, Chris Good

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

Re: [GNC] Error Retrieving Price Quotes - Windows 10

[Davy Roid]

I am still running 3.10. It seems that I am getting the following error
from bloomberg.pm

When I try to run "perl gnc-fq-dump -v bloomberg ALLAMAI:LX", it returns
something like
"Are you a Robot?"
"We've detected unusual activity from your computer network"
"To continue, please click the box below to let us know you're not a robot"

Any suggestions?

On Wed, Jun 17, 2020 at 8:55 AM Chris Good  wrote:

> Message: 1
> Date: Wed, 17 Jun 2020 00:37:43 +0800
> From: Davy Roid 
> To: gnucash-user@gnucash.org
> Subject: [GNC] Error Retrieving Price Quotes - Windows 10
> Message-ID:
> <
> camylkkeejncwfnut7xxhecjhv7y00anqpzk3o0eht3onefm...@mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> I got the following errors while running gnucash --add-price-quotes (under
> windows environment)
>
> WARN  Could not kill child process: Access is denied.
> ERROR  There was a system error while retrieving the price quotes.
>
> The system was working perfectly fine the day before. I hard reset the PC
> once as it was completely frozen.
>
> Any idea how to fix it ?
>
> Davy
>
> Hi Davy,
>
> Have you just upgraded to GnuCash 3.905?
> It now gives an error message if you need an Alpha Vantage API key and the
> args for getting quotes from a batch job have changed.
> See
>
> https://wiki.gnucash.org/wiki/Online_Quotes#Updating_enabled_Quotes_from_out
> side_GnuCash
>
> Try running Get Quotes from within GnuCash to see if there is an error msg.
>
> See https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting
>
> Regards, Chris Good
>
>
___
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 Bill: Bill ID vs Billing ID

[Adrien Monteleone]

Ah yes, I forgot that one.

I can see that keeping your own internal ID and the Vendor’s might be 
desirable. So there’s another case.


Fran,

In case you missed that point, the reason ‘InvoiceID’ is ‘optional’ is because 
if you leave it blank, GnuCash will use the rules from Properties > Counters I 
mentioned, to create one. But you can specify it exactly if you like in the 
import file.

Regards,
Adrien

> On Jun 16, 2020 w25d168, at 7:30 PM, Frank H. Ellenberger 
>  wrote:
> 
> https://bugs.gnucash.org/show_bug.cgi?id=797753


___
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] Price Database

[Chris Good]

Message: 6
Date: Tue, 16 Jun 2020 17:04:09 -0500
From: Les 
To: gnucash-user@gnucash.org
Subject: [GNC] Price Database
Message-ID: 
Content-Type: text/plain; charset=utf-8; format=flowed

Hi All:

For at least 2 weeks, I have been unable to obtain a quote for HKD (Hong 
Kong dollar).

Is anyone else having this problem?? Any suggestions?

Thanks,

Les

Linux Mint 19.3? GC 3.10 (Flatpak)

Hi Les,

Works for me (this is in Linux):

ALPHAVANTAGE_API_KEY=ATALQOFWCSKL2VZ4 ./gnc-fq-dump currency HKD AUD
1 HKD = 0.18765 AUD

See https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting

Regard, Chris Good

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

Re: [GNC] Error Retrieving Price Quotes - Windows 10

[Chris Good]

Message: 1
Date: Wed, 17 Jun 2020 00:37:43 +0800
From: Davy Roid 
To: gnucash-user@gnucash.org
Subject: [GNC] Error Retrieving Price Quotes - Windows 10
Message-ID:

Content-Type: text/plain; charset="UTF-8"

I got the following errors while running gnucash --add-price-quotes (under
windows environment)

WARN  Could not kill child process: Access is denied.
ERROR  There was a system error while retrieving the price quotes.

The system was working perfectly fine the day before. I hard reset the PC
once as it was completely frozen.

Any idea how to fix it ?

Davy

Hi Davy,

Have you just upgraded to GnuCash 3.905?
It now gives an error message if you need an Alpha Vantage API key and the
args for getting quotes from a batch job have changed.
See
https://wiki.gnucash.org/wiki/Online_Quotes#Updating_enabled_Quotes_from_out
side_GnuCash

Try running Get Quotes from within GnuCash to see if there is an error msg.

See https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting

Regards, Chris Good

___
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 Bill: Bill ID vs Billing ID

[Frank H. Ellenberger]

The problem is known: https://bugs.gnucash.org/show_bug.cgi?id=797753
But I got disrupted.

Please add any suggestions on the bug report.

Regards
Frank

Am 17.06.20 um 01:41 schrieb Fran_3 via gnucash-user:
> In 7.10.1 are the field definitions for a New Bill from a vendor... two of 
> them are...
> 
> Invoice Info - Invoice ID (optional) - the identification number of the 
> invoice as emitted by the vendor (IE: the vendor’s internal number for this 
> invoice).
> Billing Info - Billing ID (optional) - the vendor’s ID for the bill (e.g.: 
> their invoice #).
> This is confusing to me as follows...
> On Bills we receive from vendors we often find a number on the document we 
> use to identify it...1 - Vendor's Bill Number
>  
> along with the the dates often found on the document... like...2 - Date the 
> vendor created the Bill3 - Service Period Dates
> 4 - Due Date
> We consider 4 above to be the Billing ID in 7.10.1 above... aka the vendor's 
> ID for the bill... aka their invoice #
> So what is Invoice Info - Invoice ID  in 7.10.1?
> Thanks for any clarification. 

___
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 Bill: Bill ID vs Billing ID

[Adrien Monteleone]

Indeed, those two definitions (Invoice ID/Billing ID) are so similar as to be 
the same thing in probably most cases, especially for Vendors. I could see how 
they may be different from an AR perspective. (you may be importing invoices 
generated in an invoicing app that has its own numbering scheme, but want or 
need to use a different scheme in GnuCash and you import that invoice data into 
GnuCash for accounting purposes)

One place I can see a Vendor use for both is when something is a bill for a 
payment with a reference. For example, if you deal with a Vendor that employs a 
payment Factor, the original supplier will have one invoice# and the Factor 
might well have another. I guess you could use either field for either number, 
but by the definition, I’d think Invoice ID would be the original supplier’s 
invoice# and Billing ID would be the Factor’s invoice#, but that does seem a 
bit backwards in some respects considering how GnuCash uses them.

Personally, for Vendor bills I use Invoice ID as the Vendor’s Invoice# if any, 
or else let it auto-increment. I then use Billing ID as *my* account number 
with that Vendor. (since I don’t see any other place to put that info)

They are both somewhat free-form and you can use them for whatever real-world 
(or not) data you like.

The Invoice ID can be patterned and incremented according to Book rules. (See: 
File > Properties > Counters) That’s probably more useful for AR than AP, but 
I’m sure some use it for that also.

This will be the info put into the AR/AP registers as ’NUM’ and will be 
displayed on the ‘owner’ Report (Customer/Vendor Report or ’Statement of 
Account’) It is also I believe used to link payments, but I could be mistaken. 
That might be handled internally via GUID.

I also use the Opening Date as the date of the Vendor’s bill. (when they show 
it was created/opened/etc.) The due date is usually different. The service 
dates are almost always different or are for a time span, not just a date.

I vaguely recall a discussion about getting rid of ‘Opening Date’ as 
superfluous to ‘Invoice Date’ but I hope that doesn’t happen. With the move to 
accommodate Quotes in 4.0, I can imagine the need to know when you wrote the 
quote (Opening Date) and when it is posted as an agreed-to Invoice. (Invoice 
Date)

Regards,
Adrien

> On Jun 16, 2020 w25d168, at 6:41 PM, Fran_3 via gnucash-user 
>  wrote:
> 
> In 7.10.1 are the field definitions for a New Bill from a vendor... two of 
> them are...
> 
> Invoice Info - Invoice ID (optional) - the identification number of the 
> invoice as emitted by the vendor (IE: the vendor’s internal number for this 
> invoice).
> Billing Info - Billing ID (optional) - the vendor’s ID for the bill (e.g.: 
> their invoice #).
> This is confusing to me as follows...
> On Bills we receive from vendors we often find a number on the document we 
> use to identify it...1 - Vendor's Bill Number
> 
> along with the the dates often found on the document... like...2 - Date the 
> vendor created the Bill3 - Service Period Dates
> 4 - Due Date
> We consider 4 above to be the Billing ID in 7.10.1 above... aka the vendor's 
> ID for the bill... aka their invoice #
> So what is Invoice Info - Invoice ID  in 7.10.1?
> Thanks for any clarification.

___
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 Bill: Bill ID vs Billing ID

[Fran_3 via gnucash-user]

In 7.10.1 are the field definitions for a New Bill from a vendor... two of them 
are...

Invoice Info - Invoice ID (optional) - the identification number of the invoice 
as emitted by the vendor (IE: the vendor’s internal number for this invoice).
Billing Info - Billing ID (optional) - the vendor’s ID for the bill (e.g.: 
their invoice #).
This is confusing to me as follows...
On Bills we receive from vendors we often find a number on the document we use 
to identify it...1 - Vendor's Bill Number
 
along with the the dates often found on the document... like...2 - Date the 
vendor created the Bill3 - Service Period Dates
4 - Due Date
We consider 4 above to be the Billing ID in 7.10.1 above... aka the vendor's ID 
for the bill... aka their invoice #
So what is Invoice Info - Invoice ID  in 7.10.1?
Thanks for any clarification. 





___
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] Get quotes problem with testing version 3.905

[John Bonnett]

Here is my previous email with the graphics replaced by some relevant text.
I installed v3.905 to help with testing. I have a problem with getting 
online quotes which worked fine with the latest release version. 
Everything else has been OK so far.


I get this message now:

ERROR:: ALPHAVANTAGE_API_KEY must be set for currency and quotes; see 
https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US


Although that URL provides lots of good information, none of my active 
stocks, for which I am trying to get online quotes, are using 
Alphavantage. I do have some inactive/obsolete stocks which are 
defaulting to Alphavantage. Most of my active stocks are from the 
Australian exchange ASX. I have one on NASDAQ for which I am using 
Yahoo-json but that does not seem to work and did not on the release 
version either. Here are the versions in my About dialog:



Version 3.905

Build ID: 3.905+(2020-06-14)

Finance::Quote: 1.47

Should I try to remove all reference to Alphavantage from even 
inactive stocks?


John Bonnett



___
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] Training the classifier of imported transactions in GnuCash

[Cliff Kushler]

Hello All - 

Well, I answered my own question.  Previously I tried clicking on the field 
associated with the destination account in the transaction import window, with 
no luck.  I finally noticed the help button in the lower left corner, and 
immediately learned that you can double-click a transaction or select multiple 
transactions and right-click them to edit the destination account for all 
selected transactions.  Easy-peasy, and Gnucash immediately learned from the 
corrections. 

RTM!!!

Cliff

On Jun 15, 2020, at 12:30 PM, Cliff Kushler  wrote:

Hi Gio, 

Thanks for your quick response!  

Yes, I have been importing transactions for many years.  However, it seems that 
Gnucash is not getting any better - I have to correct transactions from the 
same source over and over again, month after month.  There is a window that 
appears during the import process (before the transactions are posted in the 
actual account registers) that shows all of the transactions to be imported, 
with check boxes labelled “A” (accept? not sure…), “U+R” (update & reconcile?) 
and “R” (reconcile).  However, I do not know of any way to correct the 
classification of a transaction while it is still in this window (which seems 
like the opportunity to train the classifier).  I end up correcting the 
transactions after they have posted in the account registers, and GnuCash does 
not seem to be learning from this.  

If you (or anyone) knows what I should be doing, please let me know - thanks! 

Cliff

On Jun 15, 2020, at 3:25 AM, Gio Bacareza mailto:gbacar...@gmail.com>> wrote:

Hi Cliff,

I also want to first say thanks to all the developers. I am a user and a fan. 
2nd, awesome to meet you Cliff. I love your products too.

I was also looking into an automated way of classifying transactions. I did a 
quick automl using google and have achieved 90%+ accuracy.

However, I wasn't able to use it because I think gnucash does its own and 
requires you to classify them upon import. After a few imports it also 
"learns." So subsequent imports will have these transfer accounts autopopulated.

I hope it helps.

gio



On Mon, Jun 15, 2020 at 5:11 PM Cliff Kushler mailto:ckush...@gmail.com>> wrote:
Hello - 

I am a long-time user and fan of GnuCash, and start by offering my gratitude to 
everyone who has contributed to it.  For what it’s worth, I am also a 
co-inventor of T9 and Swype, so perhaps I have contributed something to make 
your life easier too.  

My question is whether there is a tool, technique or strategy to improve the 
accuracy with which GnuCash assigns imported transactions to destination 
accounts.  I import large quantities of credit card transactions, and while 
many of them are assigned to the correct accounts, a very large number of 
repeat transactions (i.e. from the same vendor) are either repeatedly assigned 
to the same wrong category or simply left as “Imbalance-USD”.  I have not been 
able to identify a way to correct them while they are still displayed in the 
initial import window, although I suspect that would be the time to correct 
them.  I go through and manually correct them in the register after importing 
them, but this does not seem to help future classification accuracy.  

Any help would be much appreciated!  I probably should have asked this years 
ago…

Joy & Blessings,

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


-- 
cheers,

Gio


___
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] Price Database

[Les]

Hi All:

For at least 2 weeks, I have been unable to obtain a quote for HKD (Hong 
Kong dollar).


Is anyone else having this problem?  Any suggestions?

Thanks,

Les

Linux Mint 19.3  GC 3.10 (Flatpak)

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

Re: [GNC] Error Retrieving Price Quotes - Windows 10

[David Carlson]

It would be helpful to know what release  of GnuCash you are running and
when it last worked ok for you.

On Tue, Jun 16, 2020, 11:39 AM Davy Roid  wrote:

> I got the following errors while running gnucash --add-price-quotes (under
> windows environment)
>
> WARN  Could not kill child process: Access is denied.
> ERROR  There was a system error while retrieving the price quotes.
>
> The system was working perfectly fine the day before. I hard reset the PC
> once as it was completely frozen.
>
> Any idea how to fix it ?
>
> Davy
> ___
> 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] Trouble opening ancient files

[Adrien Monteleone]

I’d suspect if you walked a bit more slowly through the versions, you wouldn’t 
get that message, but I can’t say that with certainty. Maybe the Tracefile has 
more info. (see the wiki about finding the Tracefile on your system)

So you might have to step back from the original copy through the 2.x series.

Back then, each ‘x’ was a fairly major release. 2.0 --> 2.2 is more analogous 
to 2.x --> 3.x than to 3.0 --> 3.1 (The devs moved from a major.minor.bugfix 
number scheme to an major.minor_and_bugfix scheme

If you don’t go through the steps in order as recommended, you might not get 
certain file conversions along the way. You might be able to skip *some* 
‘bugfix’ releases, but you might still have to step through each ‘minor’ 
release.

Regards,
Adrien

> On Jun 16, 2020 w25d168, at 12:50 PM, Thomas Klausner  wrote:
> 
> On Tue, Jun 16, 2020 at 10:22:33AM -0400, Derek Atkins wrote:
>> This looks like it might be a GnuCash 1.2 or 1.4 binary datafile.  The
>> ability to read those old binary files was removed more than a decade ago.
>> 
>> You'll need to import that using something probably as old (new?) as 1.6
>> in order to convert it to XML, but you'll probably need a very old OS in
>> order to build it.
> 
> Ok, I didn't find such an old binary.
> 
> Does anyone still have such a binary running, or a Windows 2.0.x exe 
> somewhere?
> 
>> [snip]
>>> Any suggestions on how to get versions of these files that could be
>>> opened by gnucash 3.10?
>> 
>> These later XML files are also relatively old.  My guess, you'll
>> probably need to start with 1.6 (or maybe even 1.4 for the binary data)
>> and then keep on doing File -> Open /  File -> Save As to translate the
>> data files from version to version:
>> 
>> 1.4 -> 1.6 -> 1.8 (was there a 1.8?  I don't recall) -> 2.0 -> 2.2 ->
>> 2.4 -> 2.6 -> 3.x
>> 
>> Expect this to take a while.
> 
> Actually, this quite a bit easier than I expected. I downloaded the
> Windows 2.2.9 binary and opened the newer file and saved it, then 3.10
> could open it successfully. :)
> 
> Can you please fix this warning:
> 
> "This file/URL appears to be from a newer version of GnuCash. You must 
> upgrade your version of GnuCash to work with this data."
> 
> that appeared for this file?
> 
> Thanks,
> Thomas

___
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] Trouble opening ancient files

[Thomas Klausner]

On Tue, Jun 16, 2020 at 10:22:33AM -0400, Derek Atkins wrote:
> This looks like it might be a GnuCash 1.2 or 1.4 binary datafile.  The
> ability to read those old binary files was removed more than a decade ago.
> 
> You'll need to import that using something probably as old (new?) as 1.6
> in order to convert it to XML, but you'll probably need a very old OS in
> order to build it.

Ok, I didn't find such an old binary.

Does anyone still have such a binary running, or a Windows 2.0.x exe somewhere?

> [snip]
> > Any suggestions on how to get versions of these files that could be
> > opened by gnucash 3.10?
> 
> These later XML files are also relatively old.  My guess, you'll
> probably need to start with 1.6 (or maybe even 1.4 for the binary data)
> and then keep on doing File -> Open /  File -> Save As to translate the
> data files from version to version:
> 
> 1.4 -> 1.6 -> 1.8 (was there a 1.8?  I don't recall) -> 2.0 -> 2.2 ->
> 2.4 -> 2.6 -> 3.x
> 
> Expect this to take a while.

Actually, this quite a bit easier than I expected. I downloaded the
Windows 2.2.9 binary and opened the newer file and saved it, then 3.10
could open it successfully. :)

Can you please fix this warning:

"This file/URL appears to be from a newer version of GnuCash. You must upgrade 
your version of GnuCash to work with this data."

that appeared for this file?

Thanks,
 Thomas
___
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] Training the classifier of imported transactions in GnuCash

[Stephen M. Butler]

On 6/15/20 12:30 PM, Cliff Kushler wrote:
> Hi Gio, 
>
> Thanks for your quick response!  
>
> Yes, I have been importing transactions for many years.  However, it seems 
> that Gnucash is not getting any better - I have to correct transactions from 
> the same source over and over again, month after month.  There is a window 
> that appears during the import process (before the transactions are posted in 
> the actual account registers) that shows all of the transactions to be 
> imported, with check boxes labelled “A” (accept? not sure…), “U+R” (update & 
> reconcile?) and “R” (reconcile).  However, I do not know of any way to 
> correct the classification of a transaction while it is still in this window 
> (which seems like the opportunity to train the classifier).  I end up 
> correcting the transactions after they have posted in the account registers, 
> and GnuCash does not seem to be learning from this.  
>
> If you (or anyone) knows what I should be doing, please let me know - thanks! 


In that window, double click on a line that needs an update on the
"classification".  A window should pop-up that will allow you to select
the account to which that line should be assigned.

Doing this will "teach" the import how to make the assignments going
forward.  It might take a few iterations for it to "learn".


--Steve

>
> Cliff
>
> On Jun 15, 2020, at 3:25 AM, Gio Bacareza  wrote:
>
> Hi Cliff,
>
> I also want to first say thanks to all the developers. I am a user and a fan. 
> 2nd, awesome to meet you Cliff. I love your products too.
>
> I was also looking into an automated way of classifying transactions. I did a 
> quick automl using google and have achieved 90%+ accuracy.
>
> However, I wasn't able to use it because I think gnucash does its own and 
> requires you to classify them upon import. After a few imports it also 
> "learns." So subsequent imports will have these transfer accounts 
> autopopulated.
>
> I hope it helps.
>
> gio
>
>
>
> On Mon, Jun 15, 2020 at 5:11 PM Cliff Kushler  > wrote:
> Hello - 
>
> I am a long-time user and fan of GnuCash, and start by offering my gratitude 
> to everyone who has contributed to it.  For what it’s worth, I am also a 
> co-inventor of T9 and Swype, so perhaps I have contributed something to make 
> your life easier too.  
>
> My question is whether there is a tool, technique or strategy to improve the 
> accuracy with which GnuCash assigns imported transactions to destination 
> accounts.  I import large quantities of credit card transactions, and while 
> many of them are assigned to the correct accounts, a very large number of 
> repeat transactions (i.e. from the same vendor) are either repeatedly 
> assigned to the same wrong category or simply left as “Imbalance-USD”.  I 
> have not been able to identify a way to correct them while they are still 
> displayed in the initial import window, although I suspect that would be the 
> time to correct them.  I go through and manually correct them in the register 
> after importing them, but this does not seem to help future classification 
> accuracy.  
>
> Any help would be much appreciated!  I probably should have asked this years 
> ago…
>
> Joy & Blessings,
>
> Cliff Kushler
> ___
> 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.
>
>

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] Error Retrieving Price Quotes - Windows 10

[Davy Roid]

I got the following errors while running gnucash --add-price-quotes (under
windows environment)

WARN  Could not kill child process: Access is denied.
ERROR  There was a system error while retrieving the price quotes.

The system was working perfectly fine the day before. I hard reset the PC
once as it was completely frozen.

Any idea how to fix it ?

Davy
___
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] Trouble opening ancient files

[Matthew Forbis via gnucash-user]

Just because I was curious and had time on my hands, some digging into git 
looks like the binary file support was removed sometime during the development 
of 2.2, so the 2.0 series looks to be the last version that would read the old 
binary files.  In case anyone is curious, here is the commit:

https://github.com/Gnucash/gnucash/commit/89f37371d94ffe02af99b27e3a0dd30981263550#diff-8a2fc856d7cef71a3ac47d2f08469ec3

Matt




On Tuesday, June 16, 2020, 09:23:25 AM CDT, Derek Atkins  
wrote: 





Hi,

Thomas Klausner  writes:

> Hi!
>
> I have been using gnucash for a very long time, and recently I tried
> opening some of my first files -- but couldn't. Many old files worked,
> but not these two and their related .xac files.
>
> I see two different symptoms.
>
> One file has an timestamp from 2002. I don't recognize the file
> format, it's a binary format, but gzip cannot unpack it
> The error I get from gnucash (3.10) is:
>
> "No suitable backend was found for /path/to/file."
>
> A hexdump of the file starts with:
>
>   00 00 00 0a 00 00 00 04  00 00 00 ab 00 08 00 00  ||
> 0010  00 09 41 75 73 67 61 62  65 6e 00 00 00 00 04 31  |..Ausgaben.1|
> 0020  30 30 00 00 00 00 01 00  00 00 00 01 00 00 00 00  |00..|
> 0030  04 46 52 46 00 00 00 00  01 00 00 00 00 00 00 00  |.FRF|
> 0040  00 01 00 00 00 05 00 00  00 d6 00 08 00 00 00 06  ||
> 0050  45 73 73 65 6e 00 00 00  00 04 31 31 30 00 00 00  |Essen.110...|

This looks like it might be a GnuCash 1.2 or 1.4 binary datafile.  The
ability to read those old binary files was removed more than a decade ago.

You'll need to import that using something probably as old (new?) as 1.6
in order to convert it to XML, but you'll probably need a very old OS in
order to build it.

[snip]
> Any suggestions on how to get versions of these files that could be
> opened by gnucash 3.10?

These later XML files are also relatively old.  My guess, you'll
probably need to start with 1.6 (or maybe even 1.4 for the binary data)
and then keep on doing File -> Open /  File -> Save As to translate the
data files from version to version:

1.4 -> 1.6 -> 1.8 (was there a 1.8?  I don't recall) -> 2.0 -> 2.2 ->
2.4 -> 2.6 -> 3.x

Expect this to take a while.

> Thank you,
>  Thomas

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

-derek

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

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

[Derek Atkins]

Hi,

Thomas Klausner  writes:

> Hi!
>
> I have been using gnucash for a very long time, and recently I tried
> opening some of my first files -- but couldn't. Many old files worked,
> but not these two and their related .xac files.
>
> I see two different symptoms.
>
> One file has an timestamp from 2002. I don't recognize the file
> format, it's a binary format, but gzip cannot unpack it
> The error I get from gnucash (3.10) is:
>
> "No suitable backend was found for /path/to/file."
>
> A hexdump of the file starts with:
>
>   00 00 00 0a 00 00 00 04  00 00 00 ab 00 08 00 00  ||
> 0010  00 09 41 75 73 67 61 62  65 6e 00 00 00 00 04 31  |..Ausgaben.1|
> 0020  30 30 00 00 00 00 01 00  00 00 00 01 00 00 00 00  |00..|
> 0030  04 46 52 46 00 00 00 00  01 00 00 00 00 00 00 00  |.FRF|
> 0040  00 01 00 00 00 05 00 00  00 d6 00 08 00 00 00 06  ||
> 0050  45 73 73 65 6e 00 00 00  00 04 31 31 30 00 00 00  |Essen.110...|

This looks like it might be a GnuCash 1.2 or 1.4 binary datafile.  The
ability to read those old binary files was removed more than a decade ago.

You'll need to import that using something probably as old (new?) as 1.6
in order to convert it to XML, but you'll probably need a very old OS in
order to build it.

[snip]
> Any suggestions on how to get versions of these files that could be
> opened by gnucash 3.10?

These later XML files are also relatively old.  My guess, you'll
probably need to start with 1.6 (or maybe even 1.4 for the binary data)
and then keep on doing File -> Open /  File -> Save As to translate the
data files from version to version:

1.4 -> 1.6 -> 1.8 (was there a 1.8?  I don't recall) -> 2.0 -> 2.2 ->
2.4 -> 2.6 -> 3.x

Expect this to take a while.

> Thank you,
>  Thomas

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

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Get quotes problem with testing version 3.905

[John Bonnett]

I installed v3.905 to help with testing. I have a problem with getting 
online quotes which worked fine with the latest release version. 
Everything else has been OK so far.


I get this message now:

None of my active stocks, for which I am trying to get online quotes, 
are using Alphavantage. I do have some inactive/obsolete stocks which 
are defaulting to Alphavantage. Most of my active stocks are from the 
Australian exchange ASX. I have one on NASDAQ for which I am using 
Yahoo-json but that does not seem to work and did not on the release 
version either. Here is my About dialog


Should I try to remove all reference to Alphavantage from even inactive 
stocks?


John Bonnett

___
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] Trouble opening ancient files

[Chris Good]

Message: 5
Date: Mon, 15 Jun 2020 23:56:34 -0500
From: Adrien Monteleone 
To: GnuCash Users 
Subject: Re: [GNC] Trouble opening ancient files
Message-ID: <23fbb3da-53a4-47c1-99e4-b0a1cac1f...@lusfiber.net>
Content-Type: text/plain;   charset=utf-8

That first 2002 file is indeed ancient. (the 2005 file is no spring chicken
either)

For both cases, you?d have to find the ?newest? version of GnuCash that will
open each file, then upgrade GnuCash in steps (possibly some leaps skipping
bug-fix releases) and open each file with each version. At some point, file
conversions will be done so they are readable by newer versions, and not
backwards compatible.

Eventually you?ll arrive at the 3.x series and then you can jump to 3.10.

You?ll have to start this further back for the 2002 file and then eventually
you?ll be able to open up each with the same version.

You might get lucky and only have to make 2 or three steps.

Sorry I can?t help pinpoint a version to target to get started, or help with
which versions you can skip.

The wiki may provide some help if you dig, (as in reading old change logs)
otherwise maybe someone familiar with those older files can help with
specifics.

Regards,
Adrien

> On Jun 15, 2020 w25d167, at 3:49 PM, Thomas Klausner 
wrote:
> 
> Hi!
> 
> I have been using gnucash for a very long time, and recently I tried
> opening some of my first files -- but couldn't. Many old files worked,
> but not these two and their related .xac files.
> 
> I see two different symptoms.
> 
> One file has an timestamp from 2002. I don't recognize the file
> format, it's a binary format, but gzip cannot unpack it
> The error I get from gnucash (3.10) is:
> 
> "No suitable backend was found for /path/to/file."
> 
> A hexdump of the file starts with:
> 
>   00 00 00 0a 00 00 00 04  00 00 00 ab 00 08 00 00
||
> 0010  00 09 41 75 73 67 61 62  65 6e 00 00 00 00 04 31
|..Ausgaben.1|
> 0020  30 30 00 00 00 00 01 00  00 00 00 01 00 00 00 00
|00..|
> 0030  04 46 52 46 00 00 00 00  01 00 00 00 00 00 00 00
|.FRF|
> 0040  00 01 00 00 00 05 00 00  00 d6 00 08 00 00 00 06
||
> 0050  45 73 73 65 6e 00 00 00  00 04 31 31 30 00 00 00
|Essen.110...|
> 
> where I'm quite sure that "Ausgaben" is an account name and FRF is a
> unit of currency, so probably Account number 100 in the Unit of FRF.
> 
> 
> The second file has a timestamp from 2005. It is plaintext XML. The
> error from gnucash is:
> 
> "This file/URL appears to be from a newer version of GnuCash. You must
> upgrade your version of GnuCash to work with this data."
> 
> The file starts with:
> 
> --- begin quote ---
> 
> 
> 1
> 
> 61535f2d2589fccc34164e57b1255f25
> 1
> 38
> 1023
> 
>  NASDAQ
>  Fond
>  Fond
>  10
> 
> --- end quote ---
> 
> Then follows a gnc:pricedb and some accounts like
> 
> --- begin quote ---
> 
>  Ausgaben
>  be0508dcdbc39e35f677dd6f334d36e5
>  EXPENSE
>  
>ISO4217
>ATS
>  
>  100
>  100
>  Ausgaben
> 
> --- end quote ---
> 
> Any suggestions on how to get versions of these files that could be
> opened by gnucash 3.10?
> 
> Thank you,
> Thomas

Hi Thomas,

Maybe you're opening the wrong file...
GnuCash data files used to be .xac files.

See
https://wiki.gnucash.org/wiki/FAQ#Basics:_Filenames.2C_Directories.2C_...

Also
https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgra
de

Regards, Chris Good


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