Re: [GNC] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?

2021-06-13 Thread Chris Good
Message: 9 Date: Sun, 13 Jun 2021 20:44:18 -0700 From: Jim DeLaHunt To: gnucash-user@gnucash.org Subject: Re: [GNC] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl? Message-ID: <96cbda1f-b16d-68be-da69-1e38fdf0e...@jdlh.com> Content-Type: text/plain;

Re: [GNC] Convincing the balance sheet report to not show sold stocks...

2021-06-13 Thread km22
I am also having this issue. I have a brokerage account and for each stock or bond I have set up a security and a "stock" account type for that security. Many of the positions have long been closed and reflect a zero balance in the register. However the "Balance Sheet" report is showing the row

Re: [GNC] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?

2021-06-13 Thread Jim DeLaHunt
On 2021-06-13 09:53, John Ralls wrote: On Jun 13, 2021, at 12:39 AM, Jim DeLaHunt wrote: ... [elided] ... Am I correct in guessing that GnuCash 4.5 internally invokes these scripts (maybe just gnc-fq-helper) as an argument to a perl command? If so, should the wiki page

Re: [GNC] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?

2021-06-13 Thread Jim DeLaHunt
On 2021-06-13 00:39, Jim DeLaHunt wrote: Am I correct in guessing that GnuCash 4.5 internally invokes these scripts (maybe just gnc-fq-helper) as an argument to a perl command? After a fairly quick read of the source code, I think the answer is, "Yes, for over 14 years". I see in

[GNC] Incorrect Trial Balance Amounts

2021-06-13 Thread Volker Englisch
Hi there, I would like to check if I'm doing something wrong or if I'm correct in my assumption that the Trial Balance report isn't displaying correct amounts in all cases. I'm using Ubuntu 20.04.2 LTS with GnuCash 3.8. I started keeping track of some stock and entered the number of shares

Re: [GNC] On a Mac, where are the database configuration details stored?

2021-06-13 Thread Peter West
Thanks John. I was looking for the way the connection is actually set up. At the moment, I have no password requirement for local connections (and no external connections.) If I want to add password validation to postgresql, what happens to my GnuCash connection? — Peter West

Re: [GNC] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?

2021-06-13 Thread Peter West
‘config’ is a subcommand of ‘launchctl’. Not having a common PATH for command-line and Finder execution is right royal pain, as I found many years ago. So way back when, I set up my environment.plist then, when Apple invalidated that, my launchctl environment, and I had forgotten about the

[GNC] Problem Editing Payment - Customer Job

2021-06-13 Thread Keith Fetterman
Hi, I am encountering a problem with GnuCash 4.5 where I can not edit an existing customer payment if the payment is for invoices that have a job associated with them. When I select “Edit payment” on an existing payment, I see a dialog overlaying the Process Payment dialog that says: You

Re: [GNC] On a Mac, where are the database configuration details stored?

2021-06-13 Thread John Ralls
> On Jun 13, 2021, at 4:09 AM, Peter West wrote: > > As it says, where can I find the details of the database connection? You mean for opening the most recently used book? In ~/Library/Preferences/org.gnucash.GnuCash.plist. You can read the values with e.g. defaults read

Re: [GNC] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?

2021-06-13 Thread John Ralls
> On Jun 13, 2021, at 12:39 AM, Jim DeLaHunt wrote: > > GnuCash ships with Helper Scripts which make it easier to work with > Finance::Quote. They are: gnc-fq-check, gnc-fq-dump, gnc-fq-helper, and > gnc-fq-update. Collectively, call them gc-fq-* . > > When running these Helper Scripts

Re: [GNC] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?

2021-06-13 Thread John Ralls
https://apple.stackexchange.com/questions/51677/how-to-set-path-for-finder-launched-applications has some details about using launchctl. It seems to be a bit fiddly and with setenv you have to run the command *once* after every reboot, meaning that after you boot you login, open a Terminal

Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS

2021-06-13 Thread John Ralls
> On Jun 12, 2021, at 11:49 PM, Jim DeLaHunt wrote: > > On 2021-06-12 20:49, John Ralls wrote: >> >>> On Jun 12, 2021, at 6:31 PM, Jim DeLaHunt wrote: >>> >>> On 2021-06-12 09:13, John Ralls wrote: >>> > On Jun 12, 2021, at 12:22 AM, Jim DeLaHunt wrote: > > OK, I can

[GNC] On a Mac, where are the database configuration details stored?

2021-06-13 Thread Peter West
As it says, where can I find the details of the database connection? — Peter West p...@ehealth.id.au “…whoever says, ‘You fool!’ will be liable to the hell of fire.” ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription

Re: [GNC] GnuCash very slow to start up and quit

2021-06-13 Thread David Carlson
Speed depends on not only the factors that you have identified, but other factors as well. I have an instance of release 3.8 running in a Linux Lite environment within a Virtualbox on a laptop. Of course this hardware has its limits too. I happen to normally store my compressed XML datafile on

Re: [GNC] GnuCash very slow to start up and quit

2021-06-13 Thread Tim Hume
On Sunday, June 13th, 2021 at 18:28, Saša Janiška wrote: > Just wonder how does SQLite back-end compare with XML and whether you > recommend one over the other? (my XML is 20MB uncompressed and under > VCS). I just ran a test. My data file is 37 MByte in SQLite format, and 52 MByte when in XML

Re: [GNC] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?

2021-06-13 Thread Peter West
I think it is still true for Big Sur that the launchctl environment for Mac can be set with launchctl commands. To set the same env var in the launchctl environment as in your .profile environment, you can include in your .profile a function like this: set_env_var () { eval export

Re: [GNC] GnuCash very slow to start up and quit

2021-06-13 Thread Saša Janiška
On Sun, 13 Jun 2021 08:28:12 +0100 Chris Green wrote: > > Backend: SQLite database > > > Ditto Just wonder how does SQLite back-end compare with XML and whether you recommend one over the other? (my XML is 20MB uncompressed and under VCS). Sincerely, Gour -- As a lamp in a windless place

Re: [GNC] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?

2021-06-13 Thread Liz Dodd
On Sun, 13 Jun 2021 00:39:39 -0700 Jim DeLaHunt wrote: > GnuCash ships with Helper Scripts  which make it easier to work with > Finance::Quote. They are: gnc-fq-check, gnc-fq-dump, gnc-fq-helper, > and gnc-fq-update. Collectively, call them gc-fq-* . > > When running these Helper Scripts from

[GNC] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?

2021-06-13 Thread Jim DeLaHunt
GnuCash ships with Helper Scripts  which make it easier to work with Finance::Quote. They are: gnc-fq-check, gnc-fq-dump, gnc-fq-helper, and gnc-fq-update. Collectively, call them gc-fq-* . When running these Helper Scripts from a command prompt on MacOS and Linux, should they invoked as

Re: [GNC] GnuCash very slow to start up and quit

2021-06-13 Thread Tim Hume
On Sunday, June 13th, 2021 at 17:28, Chris Green wrote: > the difference must simply be down to the size of database. I create > a new accounts file each year, apart from anything else it keeps the > auditor happy (church accounts) and it certainly keeps it small. > Could you maybe split your

Re: [GNC] GnuCash very slow to start up and quit

2021-06-13 Thread Chris Green
On Sun, Jun 13, 2021 at 06:31:25AM +, Tim Hume wrote: > Hi, > > I've been using GnuCash for a number of years. I especially like how it > can handle foreign currencies - a feature that the commercial software > packages tend to charge extra for. > > But a continual annoyance is how slow

Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS

2021-06-13 Thread Jim DeLaHunt
On 2021-06-12 20:49, John Ralls wrote: On Jun 12, 2021, at 6:31 PM, Jim DeLaHunt wrote: On 2021-06-12 09:13, John Ralls wrote: On Jun 12, 2021, at 12:22 AM, Jim DeLaHunt wrote: OK, I can understand that the MacPorts installation of perl may be configured to look for perl packages in

[GNC] GnuCash very slow to start up and quit

2021-06-13 Thread Tim Hume
Hi, I've been using GnuCash for a number of years. I especially like how it can handle foreign currencies - a feature that the commercial software packages tend to charge extra for. But a continual annoyance is how slow GnuCash is at these operations: 1. Starting up (Takes more than a minute)

Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS

2021-06-13 Thread Jim DeLaHunt
On 2021-06-12 19:54, D. via gnucash-user wrote: Jim, I understand your complaint here, but it seems to me that the issue here is that MacPorts is prepending its directories into the environment path. Because they altered the path to prefer their own executables before the Apple supplied