Re: [GNC] Transaction Report Shortcomings

2024-05-01 Thread Christopher Lam
Hi,
See Sorting/Show Account Description. This is a bug which will be fixed
tomorrow.
https://code.gnucash.org/builds/win32/stable/
HTH

On Wed, 1 May 2024 at 22:07, Paul Kroitor  wrote:

> Is there a way to get the Transaction Report to show Account Description
> rather than Account Name in the group header lines (not the detail lines)?
>
>
>
> I have a number of expense accounts that have identical subaccounts, for
> example House-1:Property Tax and House-2:Property Tax. In the CoA, the Name
> for these sub-accounts is just Prop Tax, but the Description is House-1
> Property Tax.
>
>
>
> The problem is that Transaction Reports (when set to primary key = Account
> Name) become confusing because there become several groups simply titled
> Prop Tax with no further distinction. It would be better if it could
> somehow
> more clearly show the account hierarchy - Quicken's Itemized Categories
> report is great at this with it's collapsable tree design - but just
> showing
> the full account name would be a good start.
>
>
>
> In some reports I can choose to show the Account Description (full name),
> but the Transaction Report doesn't seem to have this option.
>
>
>
> Or perhaps I should look at approaching this from the other direction and
> look for an Income / Expense report showing full detail lines?
>
>
>
> Paul
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Finance::Quote PreRelease 1.61_03

2024-05-01 Thread Fred Tydeman
Running: sudo make install
worked.  I was able to get stock quotes again.  So thank you.

Trying:
  cpan
  cpanm
  locate cpan
Gets nothing on my linux.

  dnf list cpan*
gets: cpanspec.noarch


On Wed, May 1, 2024 at 8:07 PM Bruce Schuck 
wrote:

> On 5/1/24 7:39 PM, Fred Tydeman wrote:
>
> > On my Linux systems, after some searching, I found that I needed: dnf
> > install perl-ExtUtils-MakeMake* to get me started. Running perl
> > Makefile.PL got me several warnings of other missing perl files.
> > After doing a bunch of dnf install perl-... for them, 'make' and
> > 'make test' ran But, 'make install' failed due to permission issues.
> > Does it need 'su' to do the install?
>
> People not familiar with the "manual" method of installing should use
> cpan or cpanm. To install an interim release
>
> "cpanm BPSCHUCK/Finance-Quote-1.61_03.tar.gz" or "cpan
> BPSCHUCK/Finance-Quote-1.61_03.tar.gz".
>
> Depending how cpan(m) is configured, super user permissions may or may
> not be required. Typically when running cpan or cpanm, the install
> process will ask for the user's sudo password to install modules.
>
> When I would install using the "perl Makefile.PL; make; make test; make
> install" steps, I would become root or use sudo to execute "make
> install". But again, most people should utilize cpan or cpanm. The
> install tool provided by GnuCash utilizes CPAN.
>
> There is a brief overview of installing modules at
> https://www.cpan.org/modules/INSTALL.html which doesn't mention the
> legacy "perl Makefile.PL" method. As I mentioned in my post though, "For
> those who are comfortable with the interim releases". Comfortable being
> the operative word.
>
> Bruce S
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Finance::Quote PreRelease 1.61_03

2024-05-01 Thread Bruce Schuck

On 5/1/24 7:39 PM, Fred Tydeman wrote:


On my Linux systems, after some searching, I found that I needed: dnf
install perl-ExtUtils-MakeMake* to get me started. Running perl 
Makefile.PL got me several warnings of other missing perl files. 
After doing a bunch of dnf install perl-... for them, 'make' and 
'make test' ran But, 'make install' failed due to permission issues. 
Does it need 'su' to do the install?


People not familiar with the "manual" method of installing should use
cpan or cpanm. To install an interim release

"cpanm BPSCHUCK/Finance-Quote-1.61_03.tar.gz" or "cpan
BPSCHUCK/Finance-Quote-1.61_03.tar.gz".

Depending how cpan(m) is configured, super user permissions may or may
not be required. Typically when running cpan or cpanm, the install
process will ask for the user's sudo password to install modules.

When I would install using the "perl Makefile.PL; make; make test; make
install" steps, I would become root or use sudo to execute "make
install". But again, most people should utilize cpan or cpanm. The
install tool provided by GnuCash utilizes CPAN.

There is a brief overview of installing modules at
https://www.cpan.org/modules/INSTALL.html which doesn't mention the
legacy "perl Makefile.PL" method. As I mentioned in my post though, "For 
those who are comfortable with the interim releases". Comfortable being 
the operative word.


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


Re: [GNC] Finance::Quote PreRelease 1.61_03

2024-05-01 Thread Fred Tydeman
On my Linux systems, after some searching, I found that I needed:
  dnf install perl-ExtUtils-MakeMake*
to get me started.
Running perl Makefile.PL
got me several warnings of other missing perl files.
After doing a bunch of dnf install perl-... for them,
'make' and
'make test' ran
But, 'make install' failed due to permission issues.
Does it need 'su' to do the install?



On Wed, May 1, 2024 at 7:09 PM Fred Tydeman  wrote:

> I am running Fedora Linux 26
> I downloaded the Finance::Quote.
> When I run:  perl Maklefile.pl
> I get:  Can't locate ExtUtils/MakeMaker.pm
> So, can you point me to more complete documentation?
>
> On Tue, Apr 30, 2024 at 8:00 PM Bruce Schuck 
> wrote:
>
>> A few more fixes and additions to Finance::Quote. For those who are
>> comfortable with the interim releases, 1.61_03 has been uploaded to CPAN.
>>
>>
>> https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.61_03.tar.gz
>>
>> Or just "BPSCHUCK/Finance-Quote-1.61_03.tar.gz" when installing via
>> "cpan" or "cpanm".
>>
>> The Fool.pm module has been fixed (but like Yahoo, who knows for how
>> long?), method "fool". For the time being, only returns data for
>> securities on NYSE, Nasdaq, and OTC exchanges.
>>
>> A new module for US traded stocks, StockData.pm, with default method
>> "stockdata". This requires an API token from https://www.stockdata.org/.
>> If passed in as an environment variable, set "STOCKDATA_API_KEY" to your
>> token. Once installed "perldoc Finance::Quote::StockData" will display
>> more information.
>>
>> I also discovered that the TwelveData module was not working because the
>> method "twelvedata" was not returning a value for price or last. This is
>> another module that requires an API, this one from
>> https://twelvedata.com/. Set environment variable "TWELVEDATA_API_KEY"
>> to your token. Once installed "perldoc Finance::Quote::TwelveData" will
>> display more information.
>>
>> Regards,
>>
>> Bruce S.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Finance::Quote PreRelease 1.61_03

2024-05-01 Thread Fred Tydeman
I am running Fedora Linux 26
I downloaded the Finance::Quote.
When I run:  perl Maklefile.pl
I get:  Can't locate ExtUtils/MakeMaker.pm
So, can you point me to more complete documentation?

On Tue, Apr 30, 2024 at 8:00 PM Bruce Schuck 
wrote:

> A few more fixes and additions to Finance::Quote. For those who are
> comfortable with the interim releases, 1.61_03 has been uploaded to CPAN.
>
>
> https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.61_03.tar.gz
>
> Or just "BPSCHUCK/Finance-Quote-1.61_03.tar.gz" when installing via
> "cpan" or "cpanm".
>
> The Fool.pm module has been fixed (but like Yahoo, who knows for how
> long?), method "fool". For the time being, only returns data for
> securities on NYSE, Nasdaq, and OTC exchanges.
>
> A new module for US traded stocks, StockData.pm, with default method
> "stockdata". This requires an API token from https://www.stockdata.org/.
> If passed in as an environment variable, set "STOCKDATA_API_KEY" to your
> token. Once installed "perldoc Finance::Quote::StockData" will display
> more information.
>
> I also discovered that the TwelveData module was not working because the
> method "twelvedata" was not returning a value for price or last. This is
> another module that requires an API, this one from
> https://twelvedata.com/. Set environment variable "TWELVEDATA_API_KEY"
> to your token. Once installed "perldoc Finance::Quote::TwelveData" will
> display more information.
>
> Regards,
>
> Bruce S.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Delay during data entry

2024-05-01 Thread David Carlson
Those of us who are still running versions as old as 4.8, possibly because
we are not ready to tackle setting up a flatpak in Linux still see horrible
response times.  It gets worse when the data file when loaded takes up over
half of the RAM in our machine or if we are running it in a virtual
machine.  My version 4.8 Gnucash instance takes about 11.3 Meg when saved
or 2.4 Gig of RAM when loaded in Linux Lite 6.6.  The entire virtual
machine has 8 Gig of RAM but every time I press enter it takes several
seconds before the curser returns, or 15 seconds or more when I execute
File >Save, which needs to be done every few minutes.  Some of the delay
comes from having too many registers open.  I realize most of my misery is
self inflicted, since I have now tried working on the same data in release
5.6.1 on a Windoze 10 machine with 32 Gig RAM, which almost keeps up with
my slow typing.  It is still going to take a while to revise my procedures
to get away from GnuCash release 4.8 and have the level of hardware and
software redundancy that I want to keep backups, etc.

On Wed, May 1, 2024 at 4:36 PM R Losey  wrote:

> I don't see any delays on either Windows (Win 10, 16G RAM), or my M1 iMac
> (Sonoma 14.4.1; 16G RAM), or or Linux (Ubunto 22.04LTS, 8G RAM). In all
> cases, the file is stored on my NAS with spinning hard drives (that is, not
> an SSD), and I am saving to a compressed file (I've not changed this since
> I started, so I assume that these are the default settings).  My file size
> is about 2.2M
>
> Could it be that you are saving to a SQL database? I remember reading here
> that (unlike the standard option) it saves after every transaction. Maybe
> the database is on a slowish drive?
>
> Otherwise, I don't know why there would be such a lengthy delay after doing
> an entry.
>
> I assume you've run the Check/Repair just to verify that there isn't some
> file problem?
>
>
>
> On Wed, May 1, 2024 at 12:00 AM AC  wrote:
>
> > Just as a curiosity what is going on under the hood that influences the
> > delay after entering data into a register row? I notice that after I
> > enter the details of a transaction into a register and commit the
> > changes (pressing enter or tabbing to next row) there is a 5 to 7 second
> > delay before I can enter the next transaction.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Delay during data entry

2024-05-01 Thread R Losey
I don't see any delays on either Windows (Win 10, 16G RAM), or my M1 iMac
(Sonoma 14.4.1; 16G RAM), or or Linux (Ubunto 22.04LTS, 8G RAM). In all
cases, the file is stored on my NAS with spinning hard drives (that is, not
an SSD), and I am saving to a compressed file (I've not changed this since
I started, so I assume that these are the default settings).  My file size
is about 2.2M

Could it be that you are saving to a SQL database? I remember reading here
that (unlike the standard option) it saves after every transaction. Maybe
the database is on a slowish drive?

Otherwise, I don't know why there would be such a lengthy delay after doing
an entry.

I assume you've run the Check/Repair just to verify that there isn't some
file problem?



On Wed, May 1, 2024 at 12:00 AM AC  wrote:

> Just as a curiosity what is going on under the hood that influences the
> delay after entering data into a register row? I notice that after I
> enter the details of a transaction into a register and commit the
> changes (pressing enter or tabbing to next row) there is a 5 to 7 second
> delay before I can enter the next transaction.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] POSSIBLE SPAM: Check amount in words error

2024-05-01 Thread Sherman Yoder
I installed the latest nightly build on my Windows computer, and the 
problem corrected. But it remains on my Mac running Ventura 13.6.6. Are 
there nightly builds for Mac as well?


Sherman

On 4/30/24 7:48 PM, Sherman Yoder wrote:

Hello,

I upgraded to GnuCash 5.6+(2024-03-30), and since then the checks that
I have printed print with the amount in words as ***zero Thousand and
xx/100***. The cents are correct, but the dollars always print as "zero
Thousand."

Has anyone else run across this? I didn't discover it until I had a
couple of checks in the mail.

I'm running Windows 11. But today I printed from my iMac running
GnuCash 5.6, and it did the same.

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

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


Re: [GNC] Finance::Quote PreRelease 1.61_03

2024-05-01 Thread Bruce Schuck

On 5/1/24 7:25 AM PDT, Fred Tydeman wrote:


Can I apply this update to my older 4.14 Gnucash system on Linux?


Yes, recent and current releases of Finance::Quote are backwards 
compatible WRT to GnuCash. As a matter of fact I run GnuCash 4.8 on my 
primary Linux desktop at home and 4.8 on my OSX Catalina Macbook.


On 5/1/24 6:32 AM PDT, Fross, Michael wrote:

> Thanks Bruce.  I love the fact that you release updates as you and the
> team make fixes, and not wait for a larger rollup.  Much appreciated.

On 5/1/24 7:17 AM PDT, James Williams wrote:

> Thank-you for all your hard work on this, Bruce!

Much appreciated. I hope to get F::Q v1.62 done and uploaded to CPAN by 
the end of next week (May 11 or 12 give or take a couple days).


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


Re: [GNC] Finance::Quote PreRelease 1.61_03

2024-05-01 Thread Fred Tydeman
Can I apply this update to my older 4.14 Gnucash system on Linux?

On Tue, Apr 30, 2024 at 8:00 PM Bruce Schuck 
wrote:

> A few more fixes and additions to Finance::Quote. For those who are
> comfortable with the interim releases, 1.61_03 has been uploaded to CPAN.
>
>
> https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.61_03.tar.gz
>
> Or just "BPSCHUCK/Finance-Quote-1.61_03.tar.gz" when installing via
> "cpan" or "cpanm".
>
> The Fool.pm module has been fixed (but like Yahoo, who knows for how
> long?), method "fool". For the time being, only returns data for
> securities on NYSE, Nasdaq, and OTC exchanges.
>
> A new module for US traded stocks, StockData.pm, with default method
> "stockdata". This requires an API token from https://www.stockdata.org/.
> If passed in as an environment variable, set "STOCKDATA_API_KEY" to your
> token. Once installed "perldoc Finance::Quote::StockData" will display
> more information.
>
> I also discovered that the TwelveData module was not working because the
> method "twelvedata" was not returning a value for price or last. This is
> another module that requires an API, this one from
> https://twelvedata.com/. Set environment variable "TWELVEDATA_API_KEY"
> to your token. Once installed "perldoc Finance::Quote::TwelveData" will
> display more information.
>
> Regards,
>
> Bruce S.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Finance::Quote PreRelease 1.61_03

2024-05-01 Thread James Williams
 Thank-you for all your hard work on this, Bruce!

On Apr 30, 2024 at 7:59:34 PM, Bruce Schuck 
wrote:

> A few more fixes and additions to Finance::Quote. For those who are
> comfortable with the interim releases, 1.61_03 has been uploaded to CPAN.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Transaction Report Shortcomings

2024-05-01 Thread Paul Kroitor
Somehow I didn't notice that Show Full Account Name option does something in
that direction: the group header now shows "Expenses:Rental
Properties:House-1:Prop Tax" which does at least disambiguate but is still
pretty clunky. My Account Description fields do already contain exactly the
perfect descriptions -- I just can't see a way to show them!

Paul

-Original Message-
From: gnucash-user  On
Behalf Of Paul Kroitor
Sent: Wednesday, May 1, 2024 10:07 AM
To: 'Gnucash Users' 
Subject: [GNC] Transaction Report Shortcomings

Is there a way to get the Transaction Report to show Account Description
rather than Account Name in the group header lines (not the detail lines)?

 

I have a number of expense accounts that have identical subaccounts, for
example House-1:Property Tax and House-2:Property Tax. In the CoA, the Name
for these sub-accounts is just Prop Tax, but the Description is House-1
Property Tax.

 

The problem is that Transaction Reports (when set to primary key = Account
Name) become confusing because there become several groups simply titled
Prop Tax with no further distinction. It would be better if it could somehow
more clearly show the account hierarchy - Quicken's Itemized Categories
report is great at this with it's collapsable tree design - but just showing
the full account name would be a good start.

 

In some reports I can choose to show the Account Description (full name),
but the Transaction Report doesn't seem to have this option.

 

Or perhaps I should look at approaching this from the other direction and
look for an Income / Expense report showing full detail lines?

 

Paul 

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

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


[GNC] Transaction Report Shortcomings

2024-05-01 Thread Paul Kroitor
Is there a way to get the Transaction Report to show Account Description
rather than Account Name in the group header lines (not the detail lines)?

 

I have a number of expense accounts that have identical subaccounts, for
example House-1:Property Tax and House-2:Property Tax. In the CoA, the Name
for these sub-accounts is just Prop Tax, but the Description is House-1
Property Tax.

 

The problem is that Transaction Reports (when set to primary key = Account
Name) become confusing because there become several groups simply titled
Prop Tax with no further distinction. It would be better if it could somehow
more clearly show the account hierarchy - Quicken's Itemized Categories
report is great at this with it's collapsable tree design - but just showing
the full account name would be a good start.

 

In some reports I can choose to show the Account Description (full name),
but the Transaction Report doesn't seem to have this option.

 

Or perhaps I should look at approaching this from the other direction and
look for an Income / Expense report showing full detail lines?

 

Paul 

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


Re: [GNC] Finance::Quote PreRelease 1.61_03

2024-05-01 Thread Fross, Michael via gnucash-user
Thanks Bruce.  I love the fact that you release updates as you and the team
make fixes, and not wait for a larger rollup.  Much appreciated.

On Tue, Apr 30, 2024 at 10:00 PM Bruce Schuck 
wrote:

> A few more fixes and additions to Finance::Quote. For those who are
> comfortable with the interim releases, 1.61_03 has been uploaded to CPAN.
>
>
> https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.61_03.tar.gz
>
> Or just "BPSCHUCK/Finance-Quote-1.61_03.tar.gz" when installing via
> "cpan" or "cpanm".
>
> The Fool.pm module has been fixed (but like Yahoo, who knows for how
> long?), method "fool". For the time being, only returns data for
> securities on NYSE, Nasdaq, and OTC exchanges.
>
> A new module for US traded stocks, StockData.pm, with default method
> "stockdata". This requires an API token from https://www.stockdata.org/.
> If passed in as an environment variable, set "STOCKDATA_API_KEY" to your
> token. Once installed "perldoc Finance::Quote::StockData" will display
> more information.
>
> I also discovered that the TwelveData module was not working because the
> method "twelvedata" was not returning a value for price or last. This is
> another module that requires an API, this one from
> https://twelvedata.com/. Set environment variable "TWELVEDATA_API_KEY"
> to your token. Once installed "perldoc Finance::Quote::TwelveData" will
> display more information.
>
> Regards,
>
> Bruce S.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] [ERR-MAINT] GnuCash-Devel list config (and sub list) reverted to OLD config

2024-05-01 Thread Derek Atkins
Hi GnuCashers-

TL;DR:

As some of you may have noticed, email to GnuCash-Devel has been, well,
wonky.  The short version is that due to a cascade of issues and failures,
the list configuration was reverted to an old config, including the
subscription list.  This caused several hundred old subscriptions to
re-appear, and several hundred newer subscriptions to disappear. 
Unfortunately the only remedy is to re-subscribe to the list.

LONG VERSION

The GnuCash server is set up for a daily backup.  This backup creates an
LVM snapshot so the backup has a stable dataset during the ~4-hour backup
process.  When the backup finishes, the snapshots are removed.  All well
and good.

Unfortunately, at some point (unknown) there was a system failure during
that backup window which caused the snapshots to remain, and not get
cleaned up.  System failures like this happen frequently (mostly due to
the VM host spontaneously rebooting, which happens a couple times a year).
 However usually the system cleans up after the failure.  This time, for
some reason, that cleanup did not occur.

Simultaneously, the backup server email system wedged and stopped sending
out status emails, so I didn't get notified of the backup failures.

The leftover snapshot eventually filled up, which caused the gnucash-devel
list to fail to write out its config file in a catastrophic way.  This
resulted in a corrupted config.pck.  Mailman, "helpfully", reverted back
to its config.db, which was its configuration back in 2002.  This caused
the list to disappear, due to old old changes.

So why not revert to another backup?  Two reasons:

1. It's unclear exactly when this failure occurred, so there's not a good
way to know which backup to revert to.
2. Due to the snapshot failure, the backups were not running for way too
long.  The previous backup was from October 2023!

I apologize for all the inconveniences if you unsubscribed in the past and
somehow found yourself receiving gnucash-devel mail again.  I also
apologize for those who will have to re-subscribe because your
subscription was lost.

Going forward, I've made additional changes to recover if there is a
leftover snapshot to attempt to prevent this kind of failure.  I've also
been paying much closer attention to the daily log emails and backup logs
to keep this from happening again.

Thanks,

-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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Delay during data entry

2024-05-01 Thread David H
I also never see any significant delays - Win 10 / Gnucash 5.6 / XML
backend.

Cheers Dave H.

On Wed, 1 May 2024 at 15:29, William Prescott  wrote:

> For what it is worth, I don't see any delay at all. I have been using
> Gnucash for years and the data file is over a megabyte in size although
> that probably would only affect saving anyway. I have more than enough
> memory that entering transactions would not involve disk access. Even
> saving the file is much quicker than what you describe.
>
> I am running Gnucash 5.6.1 on MacOS 14.4.1 on an M1 Mac with 64 GB of RAM
> and ample SSD disk space. Helpful responses are more likely if one includes
> more information about the environment surrounding the problem. What
> hardware and operating system are you using?
>
> Best wishes,
> Will
>
> On 30 Apr 2024, at 22:49, AC  wrote:
>
> Just as a curiosity what is going on under the hood that influences the
> delay after entering data into a register row? I notice that after I enter
> the details of a transaction into a register and commit the changes
> (pressing enter or tabbing to next row) there is a 5 to 7 second delay
> before I can enter the next transaction.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Delay during data entry

2024-05-01 Thread sunfish62--- via gnucash-user
My 4.12 copy on my older Windows 10 laptop has had significant delays (2-4 
secs) for a couple of years now. I've chalked it up to my particular hardware 
configuration.

⁣David T. ​

On May 1, 2024, 8:28 AM, at 8:28 AM, David Carlson 
 wrote:
>The delay is much shorter in very recent releases such as 5.6.1.  The
>horsepower of your computer and the size of your RAM pool affects it
>too.
>
>On Wed, May 1, 2024 at 12:00 AM AC  wrote:
>
>> Just as a curiosity what is going on under the hood that influences
>the
>> delay after entering data into a register row? I notice that after I
>> enter the details of a transaction into a register and commit the
>> changes (pressing enter or tabbing to next row) there is a 5 to 7
>second
>> delay before I can enter the next transaction.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
>-- 
>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
>-
>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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.