[GNC] Unable to download more than 5 currency exchange rates

2020-04-26 Thread davygc
Again, I am new to GC. I am trying to setup the chart of account and is
facing a problem - unable to download more than 5 currencies exchange rate.
I did some experiments. I was unable to download the exchange rate after I
removed the Alpha Vantage API key. Therefore, I guess the exchange rate is
handled by Alpha Vantage. But on the other hand, I was able to download 5
currencies + 2 stock price through Alphavantage. When I disabled some of the
currencies, then I will be able to download the rest (still up to a total of
5).

It seems that the quote for exchange rate is not handled by Alphavantage.pm
and the cause of the problem is the limitation of 5 quote per minute.

Any suggestion?
Also, which script is responsible for downloading the exchange quote?

Thanks.





--
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] Trying to set up online banking

2020-04-26 Thread Frank H. Ellenberger
Hi Jean

Am 26.04.20 um 03:19 schrieb jean laroche:
> Are you on windows?

Gnucash & Aqbanking version?

> I have to say, I have not been able to setup the
> online banking thing in GC in windows.

Which Bank?
Did you follow John's instructions?

Frank
___
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] Unable to download more than 5 currency exchange rates

2020-04-26 Thread Frank H. Ellenberger
Hello,

Am 26.04.20 um 10:36 schrieb davygc:
> Again, I am new to GC.

Welcome here!
It is useful to tell us, which version of GnuCash and, in this case,
Finance::Quote you are running.

> I am trying to setup the chart of account and is
> facing a problem - unable to download more than 5 currencies exchange rate.
> I did some experiments. I was unable to download the exchange rate after I
> removed the Alpha Vantage API key. Therefore, I guess the exchange rate is
> handled by Alpha Vantage. But on the other hand, I was able to download 5
> currencies + 2 stock price through Alphavantage. When I disabled some of the
> currencies, then I will be able to download the rest (still up to a total of
> 5).
> 
> It seems that the quote for exchange rate is not handled by Alphavantage.pm
> and the cause of the problem is the limitation of 5 quote per minute.

See https://www.alphavantage.co/premium/

> Any suggestion?

IIRC, recent versions have a sufficient delay between the queries to
fulfill the limitation.

> Also, which script is responsible for downloading the exchange quote?

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

> Thanks.

Regards
Frank
___
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] Unable to download more than 5 currency exchange rates

2020-04-26 Thread Davy Roid
I am running GC 3.10 and online quote 1.49

On Sun, Apr 26, 2020, 17:40 Frank H. Ellenberger <
frank.h.ellenber...@gmail.com> wrote:

> Hello,
>
> Am 26.04.20 um 10:36 schrieb davygc:
> > Again, I am new to GC.
>
> Welcome here!
> It is useful to tell us, which version of GnuCash and, in this case,
> Finance::Quote you are running.
>
> > I am trying to setup the chart of account and is
> > facing a problem - unable to download more than 5 currencies exchange
> rate.
> > I did some experiments. I was unable to download the exchange rate after
> I
> > removed the Alpha Vantage API key. Therefore, I guess the exchange rate
> is
> > handled by Alpha Vantage. But on the other hand, I was able to download 5
> > currencies + 2 stock price through Alphavantage. When I disabled some of
> the
> > currencies, then I will be able to download the rest (still up to a
> total of
> > 5).
> >
> > It seems that the quote for exchange rate is not handled by
> Alphavantage.pm
> > and the cause of the problem is the limitation of 5 quote per minute.
>
> See https://www.alphavantage.co/premium/
>
> > Any suggestion?
>
> IIRC, recent versions have a sufficient delay between the queries to
> fulfill the limitation.
>
> > Also, which script is responsible for downloading the exchange quote?
>
> See https://wiki.gnucash.org/wiki/Online_Quotes
>
> > Thanks.
>
> Regards
> Frank
>
___
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 logs

2020-04-26 Thread farleykj
I see by the response(s) that it's not as simple as a setting.
However, there's no reason you couldn't do a move of the file(s) with some
sort of script. Depends on the operating system you're working under. For
example, if you're running on Windows, you could add a command or two to the
shortcut you use to start the program. In other words, the command called
for by the shortcut could be something like:

 ; MOVE \*.log 

You might need to use quotes and/or escape characters in the command
specification, depends on your particular situation.

In essence you're working as usual, then when you leave the program it does
a bit of "cleanup" for you.



-
Ken Farley
--
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] How to install Gnucash 3.8 on Debian 10 "buster"?

2020-04-26 Thread km22

As a follow up I have been running Gnucash 3.8 from the Debian testing
repo for a few months now.  I recently tried to update but get these
results:

[Quote1]

$ sudo apt list --upgradable

...

gnucash-common/testing 1:3.10-1 all [upgradable from: 1:3.8b-1]
gnucash/testing 1:3.10-1 amd64 [upgradable from: 1:3.8b-1+b1]
...

[/Quote1]


[Quote2]

$ sudo apt install gnucash
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 gnucash : Depends: libpython3.8 (>= 3.8.2) but it is not going to be
installed
E: Unable to correct problems, you have held broken packages.

[/Quote2]


Question: Is it normal for gnucash to change its Python version (here to
version 3.8) within a maintenance update (here to gnucash version 3.10)?

I ask because I am hesitant to update my python version for fear of
breaking my system - but just wanted to highlight whether this increase
in Python version is expected within the Gnucash version guidelines?

Thanks,
Ken


On 12/3/2020 10:48 pm, km22 wrote:


As a follow up, what I did is the following to update to 3.8 on my
Debian 10 system:

1) Created a file /etc/apt/apt.conf with the line:
APT::Default-Release "buster";

2) Ran sudo apt update. Then ran apt -t testing install gnucash

From the /var/log/apt/history.log file these were the packages that
were installed/updated:

Start-Date: 2020-03-10  00:14:47
Commandline: apt -t testing install gnucash
Requested-By: ken (1000)
Install: libgwenhywfar79:amd64 (5.1.3-1, automatic), gcc-10-base:amd64
(10-20200222-1, automatic), libhogweed5:amd64 (3.5.1+really3.5.1-2,
automatic), libgcc-s1:amd64 (10-20200222-1, automatic),
libnettle7:amd64 (3.5.1+really3.5.1-2, automatic), libffi7:amd64
(3.3-3, automatic), libaqbanking44:amd64 (6.0.1-2, automatic),
libgwengui-gtk3-0:amd64 (5.1.3-1, automatic)
Upgrade: cryptsetup-initramfs:amd64 (2:2.1.0-5+deb10u2, 2:2.2.2-3),
libgwenhywfar-data:amd64 (4.20.0-9, 5.1.3-1), cryptsetup-run:amd64
(2:2.1.0-5+deb10u2, 2:2.2.2-3), p11-kit-modules:amd64 (0.23.15-2,
0.23.20-1), gnucash:amd64 (1:3.4-1+b10, 1:3.8b-1+b1),
libboost-regex1.67.0:amd64 (1.67.0-13+deb10u1, 1.67.0-17),
libaqbanking-data:amd64 (5.7.8-3, 6.0.1-2), libgnutls30:amd64
(3.6.7-4+deb10u2, 3.6.12-2), libp11-kit0:amd64 (0.23.15-2, 0.23.20-1),
gnucash-common:amd64 (1:3.4-1, 1:3.8b-1), libtasn1-6:amd64 (4.13-3,
4.16.0-2), libstdc++6:amd64 (8.3.0-6, 10-20200222-1), cryptsetup:amd64
(2:2.1.0-5+deb10u2, 2:2.2.2-3), libxmlsec1:amd64 (1.2.27-2, 1.2.28-2)
End-Date: 2020-03-10  00:15:13

Question I have is why was it necessary for gnucash to install
packages from the testing repo for packages such as cryptsetup
(various) or gcc-10-base?  Are these really necessary for gnucash?  I
want to maintain a system as close to the base Debian 10 as possible
so curious to understand why these other packages were required?

Thanks,

Ken



On 8/3/2020 11:09 pm, km22 wrote:

Hi all,

Can anyone advise a very simple and safe way of install gnucash 3.8
in Debian 10?

I've read posts like this:
https://unix.stackexchange.com/questions/107689/how-do-i-install-a-single-package-from-debian-testing-or-unstable-on-stable

But I am very reluctant to start messing with things like pinning or
temporarily enabling testing repo entirely for fear of breaking my
system.

Is there a simple way to install just gnucash 3.8 and dependencies as
a one-off without making riskier changes to my system?

Thanks,

Ken



On 2/3/2020 11:29 pm, km22 wrote:

Hi Andrea,

Thanks for the message.  Do you know whether there is a simple
command line operation I can run to install Gnucash 3.8 from Debian
10 testing repo?

I tried to google the solution but what I found seemed to suggest a
lot of modifications to the sources file or introducing a pinning
concept.  I only want to install this one package (and the necessary
dependencies) from testing, ideally without messing with the /etc/
files.

Thanks,
Ken



On 2/3/2020 2:08 am, Andrea Borgia wrote:

Il 01/03/20 16:39, km22 ha scritto:


I recently moved from Windows 7 (due to end of life) to Debian 10.  I
have gnucash 3.4 installed from the standard repo. However I think
this
version contains a bug as I cannot see any of the historical FX
prices I
stored in the Price Database. I think I need to move to a more recent
version.  I saw this wiki article:
https://wiki.gnucash.org/wiki/Debian
but no clues there on how to install the latest version 3.8. Can
anyone
here advise?


Hi, Ken.

If you're comfortable with using the "testing" distribution, then
GC 3.8 is already included, I am using it now.

If you prefer to continue using the "stable" distribution of
Debian, then you could try the "f

Re: [GNC] Gnucash logs

2020-04-26 Thread Stan Brown
Hopefully the developers will take note that this is not only
longstanding but fairly frequently requested -- and the present behavior
is a source of consternation to a significant proportion of new GC
users. The introduction of GC 4.x would be a great time to make this change.

Easy for me to say of course, but I don't think it would be that hard to
add a setting in the GUI and have whatever writes the logs and lock file
use that setting.

And I would urge strongly that the setting should default to the normal
location for temp files, not to the same location as the data file.
Again, I'm thinking of the new user who is surprised to find dozens or
even hundreds of extra files in the working directory after a long
session when getting acquainted with GC.  The normal location is %TEMP%
in Windows. I don't know what it is in other operating systems, but I'm
sure our developers do.

-- 
Regards,
Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
http://OakRoadSystems.com

On 2020-04-25 21:01, D. via gnucash-user wrote:
> Unfortunately, no. This is a long standing feature request. See:
> 
> https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/1470507-configuration-option-for-backup-location
> 
> David T.
> 
> 
>  Original Message 
> From: Tom Browder 
> Sent: Sat Apr 25 21:31:57 GMT+05:30 2020
> To: gnucash-user@gnucash.org
> Subject: [GNC] Gnucash logs
> 
> Is there any way to get Gnucash to write its logs in another directory
> to keep its working directory less cluttered?

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

2020-04-26 Thread Maf. King
On Sunday, 26 April 2020 15:38:41 BST Stan Brown wrote:

> 
> And I would urge strongly that the setting should default to the normal
> location for temp files, not to the same location as the data file.
> Again, I'm thinking of the new user who is surprised to find dozens or
> even hundreds of extra files in the working directory after a long
> session when getting acquainted with GC.  The normal location is %TEMP%
> in Windows. I don't know what it is in other operating systems, but I'm
> sure our developers do.
> 

Hi Stan,

just an observation.

/tmp on linux is usually world readable... not a great idea for a default 
place to write potentially sensitive financial info.

0.02
Maf.




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

2020-04-26 Thread Adrien Monteleone
The .log files are more like historical data snapshots than application info. 
Having them all in a subfolder would be nice with less clutter. I wouldn’t say 
they belong in a system temp folder. I don’t think I’ve ever seen any app put 
its lock files in a separate location from the file being used. Though, most 
prepend them with a “.” so they are not visible during normal use. There is 
some room for improvement on both counts though.

Regards,
Adrien

> On Apr 26, 2020 w18d117, at 9:38 AM, Stan Brown  
> wrote:
> 
> Hopefully the developers will take note that this is not only
> longstanding but fairly frequently requested -- and the present behavior
> is a source of consternation to a significant proportion of new GC
> users. The introduction of GC 4.x would be a great time to make this change.
> 
> Easy for me to say of course, but I don't think it would be that hard to
> add a setting in the GUI and have whatever writes the logs and lock file
> use that setting.
> 
> And I would urge strongly that the setting should default to the normal
> location for temp files, not to the same location as the data file.
> Again, I'm thinking of the new user who is surprised to find dozens or
> even hundreds of extra files in the working directory after a long
> session when getting acquainted with GC.  The normal location is %TEMP%
> in Windows. I don't know what it is in other operating systems, but I'm
> sure our developers do.

___
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] Reporting combinations of accounts

2020-04-26 Thread nrshing
Can I configure a report such that Amount reported = balance in account A +
50% of balance in account B?

Background: Like most couples, some of our income and expenditure is joint
(e.g. interest from joint bank accounts) and some is separate (e.g.
salaries). Once a year, we have to prepare two tax reports (one each). For
this purpose we divide the joint income and expenses 50:50 between us, and
add it to our separate income and expenditure. That is, each of us reports
100% of our separate income and expenditure, plus 50% of the joint.

To do this in GnuCash, I have set up three accounts for each category of
income or expenses that we have to report in the tax report form: two sole
accounts and one joint account. So now I need each GnuCash tax report to
show 100% of the balance in one sole account + 50% of the balance in the
joint account.

How do I do this?

I thought of splitting all transactions for joint accounts into two, 50% to
each of the corresponding sole accounts. However, this seems way too
complicated.

I also thought of doing a virtual transaction on the last day of the tax
year, transferring 50% of the balance of each joint account into each
corresponding sole account. It’s not as complicated, but is still a very
awkward workaround. There must be a more logical and intuitive way to
report.

Apologies if this has already been answered. I’ve tried searching for
previous questions & answers on this topic, but without success. 




--
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] How to install Gnucash 3.8 on Debian 10 "buster"?

2020-04-26 Thread John Ralls
GnuCash doesn't care what python it's linked against as long as it's >= 3.2.0.
The Debian packager linked GnuCash 3.10 against python 3.8 and set it as a
requirement in the .deb because that's what's on a fully up to date Debian 
testing.

If you're fearful of updates breaking your system you should use only Debian 
stable. The whole point of testing is to try out version upgrades to see what 
breaks.

Regards,
John Ralls

> On Apr 26, 2020, at 7:33 AM, km22  wrote:
> 
> As a follow up I have been running Gnucash 3.8 from the Debian testing
> repo for a few months now.  I recently tried to update but get these
> results:
> 
> [Quote1]
> 
> $ sudo apt list --upgradable
> 
> ...
> 
> gnucash-common/testing 1:3.10-1 all [upgradable from: 1:3.8b-1]
> gnucash/testing 1:3.10-1 amd64 [upgradable from: 1:3.8b-1+b1]
> ...
> 
> [/Quote1]
> 
> 
> [Quote2]
> 
> $ sudo apt install gnucash
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> Some packages could not be installed. This may mean that you have
> requested an impossible situation or if you are using the unstable
> distribution that some required packages have not yet been created
> or been moved out of Incoming.
> The following information may help to resolve the situation:
> 
> The following packages have unmet dependencies:
>  gnucash : Depends: libpython3.8 (>= 3.8.2) but it is not going to be
> installed
> E: Unable to correct problems, you have held broken packages.
> 
> [/Quote2]
> 
> 
> Question: Is it normal for gnucash to change its Python version (here to
> version 3.8) within a maintenance update (here to gnucash version 3.10)?
> 
> I ask because I am hesitant to update my python version for fear of
> breaking my system - but just wanted to highlight whether this increase
> in Python version is expected within the Gnucash version guidelines?
> 
> Thanks,
> Ken
> 
> 
> On 12/3/2020 10:48 pm, km22 wrote:
>> 
>> As a follow up, what I did is the following to update to 3.8 on my
>> Debian 10 system:
>> 
>> 1) Created a file /etc/apt/apt.conf with the line:
>> APT::Default-Release "buster";
>> 
>> 2) Ran sudo apt update. Then ran apt -t testing install gnucash
>> 
>> From the /var/log/apt/history.log file these were the packages that
>> were installed/updated:
>> 
>> Start-Date: 2020-03-10  00:14:47
>> Commandline: apt -t testing install gnucash
>> Requested-By: ken (1000)
>> Install: libgwenhywfar79:amd64 (5.1.3-1, automatic), gcc-10-base:amd64
>> (10-20200222-1, automatic), libhogweed5:amd64 (3.5.1+really3.5.1-2,
>> automatic), libgcc-s1:amd64 (10-20200222-1, automatic),
>> libnettle7:amd64 (3.5.1+really3.5.1-2, automatic), libffi7:amd64
>> (3.3-3, automatic), libaqbanking44:amd64 (6.0.1-2, automatic),
>> libgwengui-gtk3-0:amd64 (5.1.3-1, automatic)
>> Upgrade: cryptsetup-initramfs:amd64 (2:2.1.0-5+deb10u2, 2:2.2.2-3),
>> libgwenhywfar-data:amd64 (4.20.0-9, 5.1.3-1), cryptsetup-run:amd64
>> (2:2.1.0-5+deb10u2, 2:2.2.2-3), p11-kit-modules:amd64 (0.23.15-2,
>> 0.23.20-1), gnucash:amd64 (1:3.4-1+b10, 1:3.8b-1+b1),
>> libboost-regex1.67.0:amd64 (1.67.0-13+deb10u1, 1.67.0-17),
>> libaqbanking-data:amd64 (5.7.8-3, 6.0.1-2), libgnutls30:amd64
>> (3.6.7-4+deb10u2, 3.6.12-2), libp11-kit0:amd64 (0.23.15-2, 0.23.20-1),
>> gnucash-common:amd64 (1:3.4-1, 1:3.8b-1), libtasn1-6:amd64 (4.13-3,
>> 4.16.0-2), libstdc++6:amd64 (8.3.0-6, 10-20200222-1), cryptsetup:amd64
>> (2:2.1.0-5+deb10u2, 2:2.2.2-3), libxmlsec1:amd64 (1.2.27-2, 1.2.28-2)
>> End-Date: 2020-03-10  00:15:13
>> 
>> Question I have is why was it necessary for gnucash to install
>> packages from the testing repo for packages such as cryptsetup
>> (various) or gcc-10-base?  Are these really necessary for gnucash?  I
>> want to maintain a system as close to the base Debian 10 as possible
>> so curious to understand why these other packages were required?
>> 
>> Thanks,
>> 
>> Ken
>> 
>> 
>> 
>> On 8/3/2020 11:09 pm, km22 wrote:
>>> Hi all,
>>> 
>>> Can anyone advise a very simple and safe way of install gnucash 3.8
>>> in Debian 10?
>>> 
>>> I've read posts like this:
>>> https://unix.stackexchange.com/questions/107689/how-do-i-install-a-single-package-from-debian-testing-or-unstable-on-stable
>>> 
>>> But I am very reluctant to start messing with things like pinning or
>>> temporarily enabling testing repo entirely for fear of breaking my
>>> system.
>>> 
>>> Is there a simple way to install just gnucash 3.8 and dependencies as
>>> a one-off without making riskier changes to my system?
>>> 
>>> Thanks,
>>> 
>>> Ken
>>> 
>>> 
>>> 
>>> On 2/3/2020 11:29 pm, km22 wrote:
 Hi Andrea,
 
 Thanks for the message.  Do you know whether there is a simple
 command line operation I can run to install Gnucash 3.8 from Debian
 10 testing repo?
 
 I tried to google the solution but what I found seemed to suggest a
 lot of modifications to the sources file or introducing a pinning
 concept.  I only want to install this one package (and the nece

[GNC] reload data files after hard drive failure

2020-04-26 Thread David Deno
My HDD was failing, so took to a local shop to have a new drive installed.
The tech was able to save all my gnucash files, over fifty of them. They
are in a temporary folder. After I install gnucash on the new system, how
do I get it to use these files?  What folder would I need to move them to
so that gnucash will recognize them?

Thanks
___
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] Trying to set up online banking

2020-04-26 Thread Janet Shelby
Thanks for that info John. My banks are major ones and both in the setup
dropdown list. One of them will not return any accounts, and the other says
my user name/password is wrong even though it is correct. I hunted on
google until I found a comment suggesting changing the setting under
special setup from 1.0 to 1.1 but still can get nowhere.

On Sat, Apr 25, 2020, 9:00 PM John Ralls  wrote:

>
>
> > On Apr 25, 2020, at 6:11 PM, Janet Shelby 
> wrote:
> >
> > Hello, I am a new user migrating from many years of Quicken. I would like
> > to use Gnucash if it will download banking transactions,  especially
> credit
> > card transactions.  The tool provided does not get successful results
> with
> > no instruction on what to do upon failure. I am an accountant but not an
> IT
> > specialist!  Can I get assistance here? Thanks.
>
> Check your bank's online banking setup page and make sure that it supports
> OFX DirectConnect. The alternative is OFX WebConnect which uses an
> Intuit-proprietary authentication mechanism that GnuCash's online banking
> library is unable to use.
>
> If it says that it does, go to https://www.ofxhome.com and search for the
> bank. If it's there just go to the page for it and check that it has
> validated recently. If it has then you should be able to use the bank
> selection in the AQBanking setup. If not then you'll have to try to set it
> up by hand using whatever information you can glean from the bank's
> website, which may not be much: It may just say that you need a certain
> version of Quicken and to go to the online banking tab in that program and
> select the bank.
>
> Regards,
> John Ralls
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Trying to set up online banking

2020-04-26 Thread David Reiser via gnucash-user
Some banks have separate login credentials for standard online banking vs 
directconnect transaction retrieval. Chase and Citibank both have multistep 
processes that require both adequate aqbanking setup and logging back into the 
standard bank web site, finding the query from the bank regarding the attempt 
to log in via direct connect, and doing something the bank considers to be 
adequate out-of-band confirmation of identity before connections from gnucash 
can work. After getting it to work once, it’ll usually work unchanged until the 
fake quicken version used for directconnect emulation ages out of the 
acceptable range. Now that quicken is subscription-only, the app version field 
might not matter, but there is no readily available documentation on the 
subject.
--
Dave Reiser
dbrei...@icloud.com





> On Apr 26, 2020, at 12:26 PM, Janet Shelby  wrote:
> 
> Thanks for that info John. My banks are major ones and both in the setup
> dropdown list. One of them will not return any accounts, and the other says
> my user name/password is wrong even though it is correct. I hunted on
> google until I found a comment suggesting changing the setting under
> special setup from 1.0 to 1.1 but still can get nowhere.
> 
> On Sat, Apr 25, 2020, 9:00 PM John Ralls  wrote:
> 
>> 
>> 
>>> On Apr 25, 2020, at 6:11 PM, Janet Shelby 
>> wrote:
>>> 
>>> Hello, I am a new user migrating from many years of Quicken. I would like
>>> to use Gnucash if it will download banking transactions,  especially
>> credit
>>> card transactions.  The tool provided does not get successful results
>> with
>>> no instruction on what to do upon failure. I am an accountant but not an
>> IT
>>> specialist!  Can I get assistance here? Thanks.
>> 
>> Check your bank's online banking setup page and make sure that it supports
>> OFX DirectConnect. The alternative is OFX WebConnect which uses an
>> Intuit-proprietary authentication mechanism that GnuCash's online banking
>> library is unable to use.
>> 
>> If it says that it does, go to https://www.ofxhome.com and search for the
>> bank. If it's there just go to the page for it and check that it has
>> validated recently. If it has then you should be able to use the bank
>> selection in the AQBanking setup. If not then you'll have to try to set it
>> up by hand using whatever information you can glean from the bank's
>> website, which may not be much: It may just say that you need a certain
>> version of Quicken and to go to the online banking tab in that program and
>> select the bank.
>> 
>> 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] reload data files after hard drive failure

2020-04-26 Thread Adrien Monteleone
Just place them in a similar folder to where they were before. Anywhere in your 
User’s data folder where you keep the rest of your personal (as opposed to 
system) files is fine.

You’ll probably have to use File > Open for each file the first time, then 
GnuCash will remember where they are.

Regards,
Adrien.

> On Apr 26, 2020 w18d117, at 10:53 AM, David Deno  wrote:
> 
> My HDD was failing, so took to a local shop to have a new drive installed.
> The tech was able to save all my gnucash files, over fifty of them. They
> are in a temporary folder. After I install gnucash on the new system, how
> do I get it to use these files?  What folder would I need to move them to
> so that gnucash will recognize them?


___
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] Trying to set up online banking

2020-04-26 Thread Janet Shelby
Thank you very much, this gives me a direction to pursue! I have not given
up yet, and really want to avoid the Quicken subscription fees!

On Sun, Apr 26, 2020, 9:50 AM David Reiser  wrote:

> Some banks have separate login credentials for standard online banking vs
> directconnect transaction retrieval. Chase and Citibank both have multistep
> processes that require both adequate aqbanking setup and logging back into
> the standard bank web site, finding the query from the bank regarding the
> attempt to log in via direct connect, and doing something the bank
> considers to be adequate out-of-band confirmation of identity before
> connections from gnucash can work. After getting it to work once, it’ll
> usually work unchanged until the fake quicken version used for
> directconnect emulation ages out of the acceptable range. Now that quicken
> is subscription-only, the app version field might not matter, but there is
> no readily available documentation on the subject.
> --
> Dave Reiser
> dbrei...@icloud.com
>
>
>
>
>
> > On Apr 26, 2020, at 12:26 PM, Janet Shelby 
> wrote:
> >
> > Thanks for that info John. My banks are major ones and both in the setup
> > dropdown list. One of them will not return any accounts, and the other
> says
> > my user name/password is wrong even though it is correct. I hunted on
> > google until I found a comment suggesting changing the setting under
> > special setup from 1.0 to 1.1 but still can get nowhere.
> >
> > On Sat, Apr 25, 2020, 9:00 PM John Ralls  wrote:
> >
> >>
> >>
> >>> On Apr 25, 2020, at 6:11 PM, Janet Shelby 
> >> wrote:
> >>>
> >>> Hello, I am a new user migrating from many years of Quicken. I would
> like
> >>> to use Gnucash if it will download banking transactions,  especially
> >> credit
> >>> card transactions.  The tool provided does not get successful results
> >> with
> >>> no instruction on what to do upon failure. I am an accountant but not
> an
> >> IT
> >>> specialist!  Can I get assistance here? Thanks.
> >>
> >> Check your bank's online banking setup page and make sure that it
> supports
> >> OFX DirectConnect. The alternative is OFX WebConnect which uses an
> >> Intuit-proprietary authentication mechanism that GnuCash's online
> banking
> >> library is unable to use.
> >>
> >> If it says that it does, go to https://www.ofxhome.com and search for
> the
> >> bank. If it's there just go to the page for it and check that it has
> >> validated recently. If it has then you should be able to use the bank
> >> selection in the AQBanking setup. If not then you'll have to try to set
> it
> >> up by hand using whatever information you can glean from the bank's
> >> website, which may not be much: It may just say that you need a certain
> >> version of Quicken and to go to the online banking tab in that program
> and
> >> select the bank.
> >>
> >> 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] Trying to set up online banking

2020-04-26 Thread jean laroche
Oh absolutely! I'm very familiar with how to setup the OFX stuff (I use 
ofxclient.py since I can't get aqbanking to work and I customized it for 
my needs).

It's definitely not an issue with the setup, it's a programming issue!
Everything starts well with the GC online banking setup wizard, I 
retrieve the account list, successfully (according to the UI) then when 
I want to continue with the

wizard, the "next" button is grayed out, and I'm stuck there.
This is with windows 8, and the latest GC (actually all recent versions 
of GC).


Where do I open a bug on this? I started a thread on the Dev list, 
asking if anybody else on windows had the same experience and got 
nowhere with it.

Jean


On 4/26/2020 2:12 AM, Frank H. Ellenberger wrote:

Hi Jean

Am 26.04.20 um 03:19 schrieb jean laroche:

Are you on windows?

Gnucash & Aqbanking version?


I have to say, I have not been able to setup the
online banking thing in GC in windows.

Which Bank?
Did you follow John's instructions?

Frank


___
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] Trying to set up online banking

2020-04-26 Thread John Ralls
Probably because nobody had the same experience. If the automagic account 
download didn't work then you have to set up the accounts manually in the 
AQBanking setup window using the Accounts tab.

Regards,
John Ralls


> On Apr 26, 2020, at 10:38 AM, jean laroche  wrote:
> 
> Oh absolutely! I'm very familiar with how to setup the OFX stuff (I use 
> ofxclient.py since I can't get aqbanking to work and I customized it for my 
> needs).
> It's definitely not an issue with the setup, it's a programming issue!
> Everything starts well with the GC online banking setup wizard, I retrieve 
> the account list, successfully (according to the UI) then when I want to 
> continue with the
> wizard, the "next" button is grayed out, and I'm stuck there.
> This is with windows 8, and the latest GC (actually all recent versions of 
> GC).
> 
> Where do I open a bug on this? I started a thread on the Dev list, asking if 
> anybody else on windows had the same experience and got nowhere with it.
> Jean
> 
> 
> On 4/26/2020 2:12 AM, Frank H. Ellenberger wrote:
>> Hi Jean
>> 
>> Am 26.04.20 um 03:19 schrieb jean laroche:
>>> Are you on windows?
>> Gnucash & Aqbanking version?
>> 
>>> I have to say, I have not been able to setup the
>>> online banking thing in GC in windows.
>> Which Bank?
>> Did you follow John's instructions?
>> 
>> Frank
> 
> ___
> 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] Trying to set up online banking

2020-04-26 Thread jean laroche
John, are you saying there's a way to setup the aqbanking without using 
the wizard? I completely missed that :(



On 4/26/2020 10:44 AM, John Ralls wrote:

Probably because nobody had the same experience. If the automagic account 
download didn't work then you have to set up the accounts manually in the 
AQBanking setup window using the Accounts tab.

Regards,
John Ralls



On Apr 26, 2020, at 10:38 AM, jean laroche  wrote:

Oh absolutely! I'm very familiar with how to setup the OFX stuff (I use 
ofxclient.py since I can't get aqbanking to work and I customized it for my 
needs).
It's definitely not an issue with the setup, it's a programming issue!
Everything starts well with the GC online banking setup wizard, I retrieve the 
account list, successfully (according to the UI) then when I want to continue 
with the
wizard, the "next" button is grayed out, and I'm stuck there.
This is with windows 8, and the latest GC (actually all recent versions of GC).

Where do I open a bug on this? I started a thread on the Dev list, asking if 
anybody else on windows had the same experience and got nowhere with it.
Jean


On 4/26/2020 2:12 AM, Frank H. Ellenberger wrote:

Hi Jean

Am 26.04.20 um 03:19 schrieb jean laroche:

Are you on windows?

Gnucash & Aqbanking version?


I have to say, I have not been able to setup the
online banking thing in GC in windows.

Which Bank?
Did you follow John's instructions?

Frank

___
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] Gnucash logs

2020-04-26 Thread Stan Brown


On 2020-04-26 07:46, Maf. King wrote:
> On Sunday, 26 April 2020 15:38:41 BST Stan Brown wrote:
>> And I would urge strongly that the setting should default to the normal
>> location for temp files, not to the same location as the data file.
>> Again, I'm thinking of the new user who is surprised to find dozens or
>> even hundreds of extra files in the working directory after a long
>> session when getting acquainted with GC.  The normal location is %TEMP%
>> in Windows. I don't know what it is in other operating systems, but I'm
>> sure our developers do.
>>
> 
> Hi Stan,
> 
> just an observation.
> 
> /tmp on linux is usually world readable... not a great idea for a default 
> place to write potentially sensitive financial info.

Hi, Maf!  I accept that it is as you say in Linux, but it does seem a
strange choice. Where do Linux apps put their temp files, if /tmp is not
suitable since it is world readable? Surely a best practice already
exists for such situations, no?

But in default of that I would support Adrien's proposal for a
subdirectory. Anything to avoid putting them in a folder where theyh get
in the way!

-- 
Regards,
Stan Brown
Tehachapi, CA, USA
https://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] Trying to set up online banking

2020-04-26 Thread David Reiser via gnucash-user
That would be because that other way is part of the native aqbanking realm. The 
settings files are stored in (usually) $HOME/.aqbanking/
Without at least one working example, it’s hard to edit the settings files 
directly, though.
--
Dave Reiser
dbrei...@icloud.com





> On Apr 26, 2020, at 1:55 PM, jean laroche  wrote:
> 
> John, are you saying there's a way to setup the aqbanking without using the 
> wizard? I completely missed that :(
> 
> 
> On 4/26/2020 10:44 AM, John Ralls wrote:
>> Probably because nobody had the same experience. If the automagic account 
>> download didn't work then you have to set up the accounts manually in the 
>> AQBanking setup window using the Accounts tab.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Apr 26, 2020, at 10:38 AM, jean laroche  wrote:
>>> 
>>> Oh absolutely! I'm very familiar with how to setup the OFX stuff (I use 
>>> ofxclient.py since I can't get aqbanking to work and I customized it for my 
>>> needs).
>>> It's definitely not an issue with the setup, it's a programming issue!
>>> Everything starts well with the GC online banking setup wizard, I retrieve 
>>> the account list, successfully (according to the UI) then when I want to 
>>> continue with the
>>> wizard, the "next" button is grayed out, and I'm stuck there.
>>> This is with windows 8, and the latest GC (actually all recent versions of 
>>> GC).
>>> 
>>> Where do I open a bug on this? I started a thread on the Dev list, asking 
>>> if anybody else on windows had the same experience and got nowhere with it.
>>> Jean
>>> 
>>> 
>>> On 4/26/2020 2:12 AM, Frank H. Ellenberger wrote:
 Hi Jean
 
 Am 26.04.20 um 03:19 schrieb jean laroche:
> Are you on windows?
 Gnucash & Aqbanking version?
 
> I have to say, I have not been able to setup the
> online banking thing in GC in windows.
 Which Bank?
 Did you follow John's instructions?
 
 Frank
>>> ___
>>> 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.


Re: [GNC] Gnucash logs

2020-04-26 Thread Nith Valley Organics
IIRC /tmp is wiped clean on every reboot.  At least on some versions of some 
OS(s).  So not a good place for log files.
A subdirectory of the directory in which the main file resides should be fine.

> On Apr 26, 2020, at 3:33 PM, Stan Brown  wrote:
> 
> 
> On 2020-04-26 07:46, Maf. King wrote:
>> On Sunday, 26 April 2020 15:38:41 BST Stan Brown wrote:
>>> And I would urge strongly that the setting should default to the normal
>>> location for temp files, not to the same location as the data file.
>>> Again, I'm thinking of the new user who is surprised to find dozens or
>>> even hundreds of extra files in the working directory after a long
>>> session when getting acquainted with GC.  The normal location is %TEMP%
>>> in Windows. I don't know what it is in other operating systems, but I'm
>>> sure our developers do.
>>> 
>> 
>> Hi Stan,
>> 
>> just an observation.
>> 
>> /tmp on linux is usually world readable... not a great idea for a default 
>> place to write potentially sensitive financial info.
> 
> Hi, Maf!  I accept that it is as you say in Linux, but it does seem a
> strange choice. Where do Linux apps put their temp files, if /tmp is not
> suitable since it is world readable? Surely a best practice already
> exists for such situations, no?
> 
> But in default of that I would support Adrien's proposal for a
> subdirectory. Anything to avoid putting them in a folder where theyh get
> in the way!
> 
> -- 
> Regards,
> Stan Brown
> Tehachapi, CA, USA
> https://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.

___
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] Trying to set up online banking

2020-04-26 Thread jean
Then, where do I file a bug report, is it a Gnucash bug, or a aqbanking 
bug? I would love to help fix this...

Jean

On 4/26/20 1:42 PM, David Reiser wrote:

That would be because that other way is part of the native aqbanking realm. The 
settings files are stored in (usually) $HOME/.aqbanking/
Without at least one working example, it’s hard to edit the settings files 
directly, though.
--
Dave Reiser
dbrei...@icloud.com






On Apr 26, 2020, at 1:55 PM, jean laroche  wrote:

John, are you saying there's a way to setup the aqbanking without using the 
wizard? I completely missed that :(


On 4/26/2020 10:44 AM, John Ralls wrote:

Probably because nobody had the same experience. If the automagic account 
download didn't work then you have to set up the accounts manually in the 
AQBanking setup window using the Accounts tab.

Regards,
John Ralls



On Apr 26, 2020, at 10:38 AM, jean laroche  wrote:

Oh absolutely! I'm very familiar with how to setup the OFX stuff (I use 
ofxclient.py since I can't get aqbanking to work and I customized it for my 
needs).
It's definitely not an issue with the setup, it's a programming issue!
Everything starts well with the GC online banking setup wizard, I retrieve the 
account list, successfully (according to the UI) then when I want to continue 
with the
wizard, the "next" button is grayed out, and I'm stuck there.
This is with windows 8, and the latest GC (actually all recent versions of GC).

Where do I open a bug on this? I started a thread on the Dev list, asking if 
anybody else on windows had the same experience and got nowhere with it.
Jean


On 4/26/2020 2:12 AM, Frank H. Ellenberger wrote:

Hi Jean

Am 26.04.20 um 03:19 schrieb jean laroche:

Are you on windows?

Gnucash & Aqbanking version?


I have to say, I have not been able to setup the
online banking thing in GC in windows.

Which Bank?
Did you follow John's instructions?

Frank

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


Re: [GNC] Why do Imported Transactions NEED to be Matched?

2020-04-26 Thread David Cousens
Tom

Please Reply to the gnucash-user@gnucash.org (Reply to List or Reply to All) 
mailing list rather than individual
contributors. The issue will get a wider response and the replies are then 
useful to all of the list participants.

I am not a major contributor to the development but I think you will find the 
main reason for having to associate the
external file names with the internal file names is that GnuCash does not use 
the account name strings internally for
referring to accounts in the code but uses GUIDs as a searches for the GUID is 
likely more rapid than a search for a
string. Therefore when the importer hits an account name you have entered in 
the transfer account column, and there is
not a mapping of that string to the GUID, the software currently does not know 
where to direct it.  A string search
through the whole account structure which has to match a series of sub-strings 
is likely to be fairly expensive in
computer time which is one possible reason the manual mapping was implemented.  
It should be just as efficient to map
the Quicken categories directly onto the GnuCash account structure.

In principle it is obviously possible to have GnuCash search through its list 
of account data structures for a match to
the entered string and construct that mapping, but that code doesn't exist at 
the moment. The best way to raise this is
using bugs.gnucash.org and to file a bug as a feature request against the 
program. This will at least get it on the
developer group's radar. 

After that it is a matter of priorities and someone with the requisite skill 
sets and knowledge
of the code picking it up and whether it can be implemented without too much of 
a computing time cost within the current
architecture of GnuCash. The core of GnuCash is quite old (circa 1998) and I 
think was originally written in a LISP
variant (Scheme) but it is very reliable. There are projects underway to 
convert the Scheme to C, C++, which fit in
around the fixing of bugs in the existing code, but this has to take place 
without impact on the core functionality so
progress is not necessarily all that rapid. Unless someone in the development 
team sees a way to implement this fairly
quickly and easily it may take some considerable time to be up and running. 
Both the development and documentation teams
are all volunteers and the resources to implement things we would like to see 
are not always available.

I wouldn't be
holding my breath. It is more productive to come to terms with the limitations 
in GnuCash and seek workarounds. The CSV
importer was recently completely rewritten and a rewrite of the documentation 
is underway. The Help manual component in
Ch 6  is largely complete. The Guide component which will address importing 
strategies and importing multiline
multisplit data is still being written.  Is your data CSV or QIF?

In a given data file, that mapping process should be a one off, but like many 
things with the importer, AFAIK the map is
probably only written to the data file when you successfully complete the 
import and if you don't do that or you start a
new data file, it will have no  mapping information stored, which is likely why 
you end up back at square one.

Are you
working with the full data file or have you pulled out a typical subset, e.g. 
one that has a transaction to each of the
accounts/categories in the heirarchy, to get the importer setup and the map 
file constructed?
 
If you do this first, you should then be able to import larger sections of the 
files with no problem. When I transferred
from MYOB around 12 years ago I brought it in initally a month at a time and 
then a year at a time once I had the
process sorted. If you go back through the gnucash-user archives you will find 
many references to initially splitting up
large imports into small maneagable chunks initially and then only increasing 
the size of the chunks when you have the
process running adequately. You will also find many discussions around 
importing Quicken data and optimal strategies.

I
also worked backwards importing the last year's data first, the next to last 
year's data, resetting the opening balances
to the accounts as I entered each batch of prior data. I still had my old 
version of MYOB accessible then so I was able
to generate the balance sheets at the start of each imported chunk which helped 
a lot.

David

On Sun, 2020-04-26 at 20:16 +1000, t...@sgml.net.au wrote:
> David,
> (This is not about matching during import.)
> Over the last six+ weeks I have been importing my Quicken ledger and for 
> various reasons I had to do it over and over
> again.
> Because I purchased Quicken 2007 (with no export facility) I needed to find a 
> way to get all transactions and all
> accounts used for the transactions.
> So I achieved the export of Quicken accounts and Quicken categories and 
> created an accounts list for GC. Then I
> exported all transactions from Quicken (and I had to split it into two 
> expor

Re: [GNC] Gnucash logs

2020-04-26 Thread David Cousens
Tom, Stan,

The log files are not just error logging files but a means of reconstructing
the current file just before a failure from the last backup file before
failure and the log files between them. Agreed it would be nice to have a
subfolder of the folder with the main GnuCash data file in it to keep these
separate. I always create my data files for mybooks in their own folder so I
only end up with the backups and the log files for the particular main data
file in that folder.  I think it is desirable to retain the direct
connection between the backup and log files and the main data file they
belong to.

When I do external backups, I backup both the main data file and the backup
and log files that i have chosen to retain not just the data file

David Cousens



-
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] Trying to set up online banking

2020-04-26 Thread flywire
https://wiki.gnucash.org/wiki/Bugzilla or more to the point, do your
research then https://bugs.gnucash.org/enter_bug.cgi?product=GnuCash
___
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] Why do Imported Transactions NEED to be Matched?

2020-04-26 Thread flywire
@Tom Seesink - Will you log that as an enhancement bug at
https://bugs.gnucash.org/enter_bug.cgi?product=GnuCash (Import - other)?
Please link back here.

@David Cousens, that excellent explanation about how the Import Matcher
works helps answer my question. The documentation needs to explain
the match is GUIDs rather than Transfer Accounts like other
financial software.

An enhancement bug fix will take too long. Is there any way of getting
GUIDs on the data? Perhaps reformatting it to QIF or OFX? Ultimately it is
stored in a table somewhere. Is the code the only place to find the details
on the import process?
___
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] Why do Imported Transactions NEED to be Matched?

2020-04-26 Thread Adrien Monteleone


> On Apr 26, 2020 w18d117, at 7:28 PM, flywire  wrote:
> 
> @Tom Seesink - Will you log that as an enhancement bug at
> https://bugs.gnucash.org/enter_bug.cgi?product=GnuCash (Import - other)?
> Please link back here.
> 
> @David Cousens, that excellent explanation about how the Import Matcher
> works helps answer my question. The documentation needs to explain
> the match is GUIDs rather than Transfer Accounts like other
> financial software.

Do you know other (including closed source) apps don’t use something similar? 
Why would a user normally need to know this implementation detail? If the 
import is done in small chunks, as advised (rather than one giant import with 
thousands of transactions) then the method behind the scenes isn’t an issue. Of 
course, GnuCash is open source, so anyone can go see for themselves that GUIDs 
are used without that fact being put in the docs.


> 
> An enhancement bug fix will take too long. Is there any way of getting
> GUIDs on the data? Perhaps reformatting it to QIF or OFX? Ultimately it is
> stored in a table somewhere. Is the code the only place to find the details
> on the import process?

There are many threads on this list discussing the process. Also, bugs which 
were addressed by the changes will have some discussion in them.

Until the docs are updated, this would be the only source of info other than 
the code itself.

Regards,
Adrien
___
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] Why do Imported Transactions NEED to be Matched?

2020-04-26 Thread flywire
> Do you know other (including closed source) apps don’t use something
similar?

I've used many other financial apps that just import Transfer Account
directly in as listed in the csv.

> Why would a user normally need to know this implementation detail?

Because it's counter-intuitive to load a Transfer Account field that is
exactly the same as the CoA in the GnuCash file and then have to match the
Transfer Account.

Agree that import works in small chunks (as posted previously). Does that
response cover any way of getting GUIDs on the data?
___
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] How to install Gnucash 3.8 on Debian 10 "buster"?

2020-04-26 Thread Frank H. Ellenberger
Hi,

Am 26.04.20 um 17:33 schrieb John Ralls:
> GnuCash doesn't care what python it's linked against as long as it's >= 3.2.0.
> The Debian packager linked GnuCash 3.10 against python 3.8 and set it as a
> requirement in the .deb because that's what's on a fully up to date Debian 
> testing.
> 
> If you're fearful of updates breaking your system you should use only Debian 
> stable. The whole point of testing is to try out version upgrades to see what 
> breaks.
> 
> Regards,
> John Ralls

a compromise would be to use backports:
https://wiki.gnucash.org/wiki/Debian#About_Debian_Releases_and_Release_Names

HTH
Frank
___
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] Why do Imported Transactions NEED to be Matched?

2020-04-26 Thread Stephen M. Butler
On 4/26/20 6:18 PM, flywire wrote:
>> Do you know other (including closed source) apps don’t use something
> similar?
>
> I've used many other financial apps that just import Transfer Account
> directly in as listed in the csv.
>
>> Why would a user normally need to know this implementation detail?
> Because it's counter-intuitive to load a Transfer Account field that is
> exactly the same as the CoA in the GnuCash file and then have to match the
> Transfer Account.


But that is the sweet idea -- use a short mnemonic and have it mapped
once.  I do this to encode a bunch of transactions for a non-profit I
manage.  Keeps from having to type in the entire account path.


> Agree that import works in small chunks (as posted previously). Does that
> response cover any way of getting GUIDs on the data?
> ___
> 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.


Re: [GNC] Why do Imported Transactions NEED to be Matched?

2020-04-26 Thread David Cousens
Unfortunately knowing the GUID's won't help as the importer currently doesn't
import them and use them directly only via that mapping process.



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


[GNC] Order listing in account by "Transfer"? Select and modify multiple?

2020-04-26 Thread flywire
This is a very old thread so how does it work now?

How can I sort Savings Account by Transfer account? The Sort by options
are: Date, Date of Entry, Statement Date, Number, Amount, Memo,
Description, Action and Notes.
___
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] Order listing in account by "Transfer"? Select and modify multiple?

2020-04-26 Thread David Carlson
I think that nothing has changed.  How would you sort a mixture of
transactions, some of which are splits to several other accounts, by
transfer account?

On Sun, Apr 26, 2020 at 10:09 PM flywire  wrote:

> This is a very old thread so how does it work now?
>
> How can I sort Savings Account by Transfer account? The Sort by options
> are: Date, Date of Entry, Statement Date, Number, Amount, Memo,
> Description, Action and Notes.
> ___
> 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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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] Trying to set up online banking

2020-04-26 Thread John Ralls
Jean,

Not exactly. There's two "wizards" at play here, the outer Online Banking Setup 
Assistant and the inner AQBanking setup dialog. That inner one has two tabs, 
Users and Accounts. The User one, when setting up an OFX DirectConnect user 
(and maybe for the HBCI/FinTS one, I don't know) includes the ability to 
download accounts once one has successfully set up the OFX DirectConnect 
parameters, but not all banks support it; it might also fail for other reasons. 
When it does work it populates the accounts for that bank and you can quit the 
AQBanking setup dialog and click next in the Online Banking Setup Assistant. If 
it doesn't work then no accounts are set up and you have to do so manually, and 
that's what the Accounts tab in the AQBanking setup dialog is for.

Regards,
John Ralls


> On Apr 26, 2020, at 10:55 AM, jean laroche  wrote:
> 
> John, are you saying there's a way to setup the aqbanking without using the 
> wizard? I completely missed that :(
> 
> 
> On 4/26/2020 10:44 AM, John Ralls wrote:
>> Probably because nobody had the same experience. If the automagic account 
>> download didn't work then you have to set up the accounts manually in the 
>> AQBanking setup window using the Accounts tab.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Apr 26, 2020, at 10:38 AM, jean laroche  wrote:
>>> 
>>> Oh absolutely! I'm very familiar with how to setup the OFX stuff (I use 
>>> ofxclient.py since I can't get aqbanking to work and I customized it for my 
>>> needs).
>>> It's definitely not an issue with the setup, it's a programming issue!
>>> Everything starts well with the GC online banking setup wizard, I retrieve 
>>> the account list, successfully (according to the UI) then when I want to 
>>> continue with the
>>> wizard, the "next" button is grayed out, and I'm stuck there.
>>> This is with windows 8, and the latest GC (actually all recent versions of 
>>> GC).
>>> 
>>> Where do I open a bug on this? I started a thread on the Dev list, asking 
>>> if anybody else on windows had the same experience and got nowhere with it.
>>> Jean
>>> 
>>> 
>>> On 4/26/2020 2:12 AM, Frank H. Ellenberger wrote:
 Hi Jean
 
 Am 26.04.20 um 03:19 schrieb jean laroche:
> Are you on windows?
 Gnucash & Aqbanking version?
 
> I have to say, I have not been able to setup the
> online banking thing in GC in windows.
 Which Bank?
 Did you follow John's instructions?
 
 Frank
>>> ___
>>> 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] Order listing in account by "Transfer"? Select and modify multiple?

2020-04-26 Thread flywire
By first transfer account. If you open the transfer account register it
would list all accounts it received transactions (including splits) from.

I'd be happy with filter.
___
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] Order listing in account by "Transfer"? Select and modify multiple?

2020-04-26 Thread Christopher Lam
Use the Transaction Report.

On Mon, 27 Apr 2020 at 03:40, flywire  wrote:

> By first transfer account. If you open the transfer account register it
> would list all accounts it received transactions (including splits) from.
>
> I'd be happy with filter.
> ___
> 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] Why do Imported Transactions NEED to be Matched?

2020-04-26 Thread David Cousens
A quick look through a copy of the data file suggests that it is somehow
incorporated in the data for the Bayesian matching for an account but I
can't be sure without looking through the code. I use Bayesian matching
rather than the older import name mapping which can be used optionally.

It is always possible to edit the datafile directly but that of course is
fraught with danger. If you do, work on a copy of your data file only.  I do
this a fair bit while working on the documentation, creating a simple
account structure in a new file, importing a couple of typical examples and
then looking at how it is stored.  Keeping the account structure simple
makes finding things a lot easier. A lot of the data is stored in the XML
data file as key-value pairs in a structure with  tags around
it.

I haven't explored the import mapping procedure at all yet in any detail so
I have no real idea of how it works. It was on the todo list to take a
closer look at how it functions. The following is an extract from one of my
import test files which I think  indicates how the mapping is stored within
the structure for each account:

  Acme Corp
  c39d8f38121b4ea0b6dcfbc65039ef77
  STOCK
  
ASX
ACM
  
  1
  

  import-map
  

  csv-account-map
  

*  Assets:Investments:Brokerage Account:Stock:Acme
Corp
  c39d8f38121b4ea0b6dcfbc65039ef77*

  

  

  
  f43d06a3681a42beaac15bfda775df7f


I think the bolded bit is where the string in the transfer field is mapped
onto the guid for an account.  You would need to create a similar structure
for each account which would be used as a transfer account, Note this is for
CSV importing only, QIF more than likely has its own import map structure
which i haven't explored at all.  I don't normally import QIF data as a
matter of course but have had my bank generate a couple I use for tesing the
importer while documenting it.

I honestly think it will be far simpler and less likely for you to end up
with a corrupted data file by just mapping the files the first time they
come up in the import matcher which will create these data structures
automatically. I am deliberately discouraging you. I would never attempt
this on my main accounting data files only on test files.

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] Order listing in account by "Transfer"? Select and modify multiple?

2020-04-26 Thread David Carlson
1.  Not sure which transfer is considered to be first when GnuCash doesn't
necessarily display them in the order entered, partly because some splits
are credits and some are debits.

2. What it i want a different selection than you want?

On Sun, Apr 26, 2020 at 10:41 PM flywire  wrote:

> By first transfer account. If you open the transfer account register it
> would list all accounts it received transactions (including splits) from.
>
> I'd be happy with filter.
> ___
> 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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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] Unable to download more than 5 currency exchange rates

2020-04-26 Thread Davy Roid
I learnt this from AlphaVantage.pm and it may not be the best solution.
Adding a sleep(13) statement right before the" my $reply = $us->request"
(at around line 262) in the Quote.pm will solve the problem.




On Sun, Apr 26, 2020, 16:38 davygc  wrote:

> Again, I am new to GC. I am trying to setup the chart of account and is
> facing a problem - unable to download more than 5 currencies exchange rate.
> I did some experiments. I was unable to download the exchange rate after I
> removed the Alpha Vantage API key. Therefore, I guess the exchange rate is
> handled by Alpha Vantage. But on the other hand, I was able to download 5
> currencies + 2 stock price through Alphavantage. When I disabled some of
> the
> currencies, then I will be able to download the rest (still up to a total
> of
> 5).
>
> It seems that the quote for exchange rate is not handled by Alphavantage.pm
> and the cause of the problem is the limitation of 5 quote per minute.
>
> Any suggestion?
> Also, which script is responsible for downloading the exchange quote?
>
> Thanks.
>
>
>
>
>
> --
> 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.
>
___
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] Order listing in account by "Transfer"? Select and modify multiple?

2020-04-26 Thread flywire
Fair point, they are relational tables.

>From the Savings Account To the Transfer would have to be displayed as
 or display the whole thing at splits level using a  single
transaction as a single split. Filtering anything with a specified Transfer
would still be useful.

As @Christopher Lam posted, seems the intention is to Use the Transaction
Report.
___
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] notify when new version is available?

2020-04-26 Thread Ed Love

Is this possible? It would be useful! I checked the FAQ but found nothing.

Thanks,

    Ed

___
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] notify when new version is available?

2020-04-26 Thread D. via gnucash-user
Every release is announced in this user list. Does that notification not reach 
you? 


 Original Message 
From: Ed Love 
Sent: Mon Apr 27 10:45:00 GMT+05:30 2020
To: Gnucash Users 
Subject: [GNC] notify when new version is available?

Is this possible? It would be useful! I checked the FAQ but found nothing.

Thanks,

     Ed

___
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] notify when new version is available?

2020-04-26 Thread Ed Love
For some reason, no. Is there any particular reason why there isn't an 
option in GC itself? It's a very popular way of doing it.


    Ed

On 27/04/2020 3:58 pm, D. wrote:
Every release is announced in this user list. Does that notification 
not reach you?


*From:* Ed Love
*Sent:* Mon Apr 27 10:45:00 GMT+05:30 2020
*To:* Gnucash Users
*Subject:* [GNC] notify when new version is available?

Is this possible? It would be useful! I checked the FAQ but found nothing.

Thanks,

      Ed



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 
seehttps://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] notify when new version is available?

2020-04-26 Thread Christopher Lam
because AFAIK this app which handles your personal data never accesses the
outside internet, otherwise many users will yell.

On Mon, 27 Apr 2020 at 06:09, Ed Love  wrote:

> For some reason, no. Is there any particular reason why there isn't an
> option in GC itself? It's a very popular way of doing it.
>
>  Ed
>
> On 27/04/2020 3:58 pm, D. wrote:
> > Every release is announced in this user list. Does that notification
> > not reach you?
> > 
> > *From:* Ed Love
> > *Sent:* Mon Apr 27 10:45:00 GMT+05:30 2020
> > *To:* Gnucash Users
> > *Subject:* [GNC] notify when new version is available?
> >
> > Is this possible? It would be useful! I checked the FAQ but found
> nothing.
> >
> > Thanks,
> >
> >   Ed
> >
> > 
> >
> > 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 seehttps://
> 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.


Re: [GNC] notify when new version is available?

2020-04-26 Thread Christopher Lam
oops. the Get-Quotes and AQBanking modules do access the outside world, but
these are "external" modules.

On Mon, 27 Apr 2020 at 06:18, Christopher Lam 
wrote:

> because AFAIK this app which handles your personal data never accesses the
> outside internet, otherwise many users will yell.
>
> On Mon, 27 Apr 2020 at 06:09, Ed Love  wrote:
>
>> For some reason, no. Is there any particular reason why there isn't an
>> option in GC itself? It's a very popular way of doing it.
>>
>>  Ed
>>
>> On 27/04/2020 3:58 pm, D. wrote:
>> > Every release is announced in this user list. Does that notification
>> > not reach you?
>> > 
>> > *From:* Ed Love
>> > *Sent:* Mon Apr 27 10:45:00 GMT+05:30 2020
>> > *To:* Gnucash Users
>> > *Subject:* [GNC] notify when new version is available?
>> >
>> > Is this possible? It would be useful! I checked the FAQ but found
>> nothing.
>> >
>> > Thanks,
>> >
>> >   Ed
>> >
>> > 
>> >
>> > 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 seehttps://
>> 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.


Re: [GNC] notify when new version is available?

2020-04-26 Thread Christopher Lam
The formal way is to submit a RFE in bugzilla...

On Mon, 27 Apr 2020 at 06:26, Ed Love  wrote:

> Hmmm ... how about an option? That way, both camps can be happy. I adore
> options, for that very reason. Users are't told you MUST or CANNOT do this,
> they have an ... option :)
> On 27/04/2020 4:18 pm, Christopher Lam wrote:
>
> because AFAIK this app which handles your personal data never accesses the
> outside internet, otherwise many users will yell.
>
> On Mon, 27 Apr 2020 at 06:09, Ed Love  wrote:
>
>> For some reason, no. Is there any particular reason why there isn't an
>> option in GC itself? It's a very popular way of doing it.
>>
>>  Ed
>>
>> On 27/04/2020 3:58 pm, D. wrote:
>> > Every release is announced in this user list. Does that notification
>> > not reach you?
>> > 
>> > *From:* Ed Love
>> > *Sent:* Mon Apr 27 10:45:00 GMT+05:30 2020
>> > *To:* Gnucash Users
>> > *Subject:* [GNC] notify when new version is available?
>> >
>> > Is this possible? It would be useful! I checked the FAQ but found
>> nothing.
>> >
>> > Thanks,
>> >
>> >   Ed
>> >
>> > 
>> >
>> > 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 seehttps://
>> 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.