Re: [GNC] Gun shy?

[Peter West via gnucash-user]

The only problem I’ve seen is the lack of completion in the Description field 
of splits.

—
Peter West
p...@pbw.id.au
“For where your treasure is, there your heart will be also.”

> On 28 Jun 2023, at 3:57 pm, R Losey  wrote:
> 
> Thanks for all of the feedback. I guess before I do financial work this
> week, I'll update my GnuCash from 5.1 to 5.3
> 
> I'm glad it's working fine!
> 
> On Tue, Jun 27, 2023 at 4:09 PM David H  <mailto:hell...@gmail.com>> wrote:
> 
>> It's good and a lot more reliable than my banking apps lately :-)
>> 
>> On Wed, 28 Jun 2023 at 03:39, R Losey  wrote:
>> 
>>> (Heh) I wonder if we are all gun shy about downloading and installing
>>> GnuCash 5.3; I haven't seen anyone on this list say that they have used it
>>> and it is fine.
>>> 
>>> 
>>> 
>>> --
>>> _
>>> 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.
>>> 
>> 
> 
> -- 
> _
> Richard Losey
> rlo...@gmail.com <mailto:rlo...@gmail.com>
> Micah 6:8
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org <mailto: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] Description List

[Peter West via gnucash-user]

Wouldn’t this be a case where correcting the database or XML file would be a 
feasible solution?

—
Peter West
p...@pbw.id.au
“I am the bread of life; whoever comes to me shall not hunger, and whoever 
believes in me shall never thirst.”

> On 23 May 2023, at 2:29 pm, Adrien Monteleone 
>  wrote:
> 
> You can't. It is composed of all descriptions entered. If something is 
> spelled incorrectly, you can do a search for transactions that have that 
> misspelling in their description field, then correct them one by one.
> 
> Once a description no longer appears anywhere, such as a misspelling, it will 
> disappear from the drop down list.
> 
> Regards,
> Adrien
> 
> On 5/19/23 8:26 PM, Phillip Walsh wrote:
>> How can I edit the list that drops down in the Description column.
> 
> ___
> 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] GnuCash 5.0 Released

[Peter West via gnucash-user]

I have just noticed that the hash given in the release email for
Gnucash-Intel-5.0-2.dmg
is the correct hash for
Gnucash-Intel-5.0-1.dmg
which is the version which downloads from the first download link for Apple 
MacOS in the release email. The has I used was the one given for
Gnucash-Intel-5.0-1.dmg
on the SourceForge page.

Hence my confusion.

—
Peter West
p...@pbw.id.au
When he had said these things, he cried out with a loud voice, “Lazarus, come 
out.”



> On 27 Mar 2023, at 9:25 am, Peter West via gnucash-user 
>  wrote:
> 
> The sha256 hash for Gnucash-Intel-5.0-1.dmg is not equal to the value given 
> at SourceForge.
> 
> $ sha256 Gnucash-Intel-5.0-1.dmg 
> b43b61244e195f6f8c52f83430c08671e8a02f47a00f09e4295652ce9d57443a
> Gnucash-Intel-5.0-1.dmg FAIL
> c8ea60b2ccbeab5f6997a927939a0fad715fbbe494644e586c6c386bfec6857a NOT EQUAL TO
> b43b61244e195f6f8c52f83430c08671e8a02f47a00f09e4295652ce9d57443a
> 
> 
> —
> Peter West
> p...@pbw.id.au <mailto:p...@pbw.id.au>“Rejoice and be glad, for your reward 
> is great in heaven, for so they persecuted the prophets who were before you.”
> 
>> On 27 Mar 2023, at 7:09 am, John Ralls > <mailto:jra...@ceridwen.us>> wrote:
>> 
>> The GnuCash development team announces GnuCash 5.0.
>> 
>> New Features
>> 
>>   A new Stock Transaction Assistant to guide you through entering most 
>> investment transactions for stocks, bonds, and mutual funds. You can access 
>> it from Actions>Stock Assistant when the focus tab is the Accounts page or a 
>> Stock or Fund account register.
>>   A new Investment Lots report showing a graph of capital gains and losses 
>> in a period by investment lot. Note that if you don't use the View Lots 
>> dialog to manage capital gains and losses this report won't have anything to 
>> show you. Use Reports>Assets & Liabilities>Investment Lots to see the report.
>>   The Online Quotes facility has been completely rewritten and the old 
>> gnc-fq-check, gnc-fq-dump, and gnc-fq-helper programs have been replaced 
>> with finance-quote-wrapper. The functions performed by those programs may 
>> now be accomplished by passing commands to gnucash-cli -Q, see gnucash-cli 
>> --help for specifics. The perl module requirements have changed with the 
>> rewrite: The new version doesn't need Date::Manip but needs JSON::Parse 
>> instead. gnc-fq-update has been, er, updated to reflect that.
>>   A new tab on the New/Edit Account dialog called More Properties includes 
>> entries to set a high and low limit on an account. That's coupled to a new 
>> column that's available on the Accounts Page, Balance Limit. If you set a 
>> high or low limit and the account balance falls above or below the 
>> respective limit an indicator will be shown in the Balance Limit column.
>>   The description field quickfill in the register now displays a drop-down 
>> list of possible completions instead of just one inline completion.
>>   File import menu items for the MT940, MT942, and DTAUS formats is replaced 
>> with a single Import from AQBanking that supports importing any file format 
>> supported by AQBanking, including the frequently requested CAMT. (Note that 
>> some CAMT profiles are under the XML format.)
>>   The import matcher now permits editing descriptions, notes, and memo 
>> fields in the matcher window before creating the transactions. Right-click 
>> and select from the context menu.
>>   The report generated by the Print Invoice button on the Edit Invoice tab 
>> can now be configured as a book option at the bottom of the Business tab; 
>> this permits selecting a saved configuration of one of the standard invoice 
>> reports. Another option enables a delay, during which a dialog box will 
>> appear enabling the user to select a different report. Note: When saving a 
>> configuration make sure that the invoice number is not set or you'll get 
>> that particular invoice instead of the one that you pressed the button for.
>> 
>> Significant Code Changes
>> Deprecations (will be removed in GnuCash 6.0)
>> 
>>   _ (the alias for gettext. Use G_ instead)
>>   gnc:make-account-list-limited-option
>>   gnc:make-account-list-option
>>   gnc:make-account-sel-limited-option
>>   gnc:make-account-sel-option
>>   gnc:make-budget-option
>>   gnc:make-color-option
>>   gnc:make-commodity-option
>>   gnc:make-complex-boolean-option
>>   gnc:make-counter-format-option
>>   gnc:make-counter-option
>>   gnc:make-currency-option
>>   gnc:make-date-format-option
>>   gnc:make-font-option
>>   gnc:make-internal-option
>>   gn

Re: [GNC] GnuCash 5.0 Released

[Peter West via gnucash-user]

The sha256 hash for Gnucash-Intel-5.0-1.dmg is not equal to the value given at 
SourceForge.

$ sha256 Gnucash-Intel-5.0-1.dmg 
b43b61244e195f6f8c52f83430c08671e8a02f47a00f09e4295652ce9d57443a
Gnucash-Intel-5.0-1.dmg FAIL
c8ea60b2ccbeab5f6997a927939a0fad715fbbe494644e586c6c386bfec6857a NOT EQUAL TO
b43b61244e195f6f8c52f83430c08671e8a02f47a00f09e4295652ce9d57443a

 
—
Peter West
p...@pbw.id.au“Rejoice and be glad, for your reward is great in heaven, for so 
they persecuted the prophets who were before you.”

> On 27 Mar 2023, at 7:09 am, John Ralls  wrote:
> 
> The GnuCash development team announces GnuCash 5.0.
> 
> New Features
> 
>A new Stock Transaction Assistant to guide you through entering most 
> investment transactions for stocks, bonds, and mutual funds. You can access 
> it from Actions>Stock Assistant when the focus tab is the Accounts page or a 
> Stock or Fund account register.
>A new Investment Lots report showing a graph of capital gains and losses 
> in a period by investment lot. Note that if you don't use the View Lots 
> dialog to manage capital gains and losses this report won't have anything to 
> show you. Use Reports>Assets & Liabilities>Investment Lots to see the report.
>The Online Quotes facility has been completely rewritten and the old 
> gnc-fq-check, gnc-fq-dump, and gnc-fq-helper programs have been replaced with 
> finance-quote-wrapper. The functions performed by those programs may now be 
> accomplished by passing commands to gnucash-cli -Q, see gnucash-cli --help 
> for specifics. The perl module requirements have changed with the rewrite: 
> The new version doesn't need Date::Manip but needs JSON::Parse instead. 
> gnc-fq-update has been, er, updated to reflect that.
>A new tab on the New/Edit Account dialog called More Properties includes 
> entries to set a high and low limit on an account. That's coupled to a new 
> column that's available on the Accounts Page, Balance Limit. If you set a 
> high or low limit and the account balance falls above or below the respective 
> limit an indicator will be shown in the Balance Limit column.
>The description field quickfill in the register now displays a drop-down 
> list of possible completions instead of just one inline completion.
>File import menu items for the MT940, MT942, and DTAUS formats is replaced 
> with a single Import from AQBanking that supports importing any file format 
> supported by AQBanking, including the frequently requested CAMT. (Note that 
> some CAMT profiles are under the XML format.)
>The import matcher now permits editing descriptions, notes, and memo 
> fields in the matcher window before creating the transactions. Right-click 
> and select from the context menu.
>The report generated by the Print Invoice button on the Edit Invoice tab 
> can now be configured as a book option at the bottom of the Business tab; 
> this permits selecting a saved configuration of one of the standard invoice 
> reports. Another option enables a delay, during which a dialog box will 
> appear enabling the user to select a different report. Note: When saving a 
> configuration make sure that the invoice number is not set or you'll get that 
> particular invoice instead of the one that you pressed the button for.
> 
> Significant Code Changes
> Deprecations (will be removed in GnuCash 6.0)
> 
>_ (the alias for gettext. Use G_ instead)
>gnc:make-account-list-limited-option
>gnc:make-account-list-option
>gnc:make-account-sel-limited-option
>gnc:make-account-sel-option
>gnc:make-budget-option
>gnc:make-color-option
>gnc:make-commodity-option
>gnc:make-complex-boolean-option
>gnc:make-counter-format-option
>gnc:make-counter-option
>gnc:make-currency-option
>gnc:make-date-format-option
>gnc:make-font-option
>gnc:make-internal-option
>gnc:make-invoice-option
>gnc:make-list-option
>gnc:make-multichoice-callback-option
>gnc:make-multichoice-option
>gnc:make-number-plot-size-option
>gnc:make-number-range-option
>gnc:make-owner-option
>gnc:make-pixmap-option
>gnc:make-query-option
>gnc:make-radiobutton-option
>gnc:make-simple-boolean-option
>gnc:make-string-option
>gnc:make-taxtable-option
>gnc:make-text-option
>gnc:option-set-default-value
>gnc:option-set-value
>gnc:option-setter
>gnc:option-value
>gnc:register-option
>The invoice option to gnc:register-report-create-internal
> 
> Report and Book Options
> 
>This major change will affect everyone who has written custom reports in 
> Guile Scheme.
>The report and book options code has been completely rewritten in C++ 

Re: [GNC] Can a bank account have sub-accounts?

[Peter West via gnucash-user]

If you use a variant of envelope budgeting, your actual bank account can be a 
placeholder account, and every transaction against that account is actually 
recorded in one of the subaccounts. The total balance of all the subaccounts 
will show against the placeholder account. By using the OpenSubaccounts item in 
the menu for the placeholder, you will see a list of all of the transactions in 
the subaccounts. You cannot edit this list, but you can check the items against 
your bank statement. If you then uncheck ‘Placeholder account’ you will lose 
the grand total, but you will be able to edit, hence reconcile, the items in 
the ‘Open Subaccounts’ transaction display. After reconciliation you can 
recheck the ‘Placeholder Account’.

I haven’t actually tried this process during reconciliation, but perhaps 
someone else has, and can give you the pros and cons or suggest an alternative.

—
Peter West
p...@pbw.id.au
“Blessed are you when others revile you and persecute you and utter all kinds 
of evil against you falsely on my account.”




> On 14 Mar 2023, at 12:46 am, Murugan Muruganandam 
>  wrote:
> 
> hi Mort
> 
> The  expenses account can be granular and can be tracked separately.  for 
> Asset account unless you have separate bank accounts, you cannot separate it 
> in your accounting system.
> You can use sub accounts, but it would be a huge overhead for you to 
> reconcile your bank statement with individual buckets you have created.
> 
> 
> 
> 
> 
> Saludos Cordiales
> 
> 
> Murugan
> 
> 
> From: gnucash-user 
>  on behalf of 
> Mort Q 
> Sent: Monday, March 13, 2023 11:35 AM
> To: Robert Heller 
> Cc: gnucash-user@gnucash.org 
> Subject: Re: [GNC] Can a bank account have sub-accounts?
> 
> Hi Robert
> I do have lots of expense accounts for repairs, catering, office expenses,
> utilities, etc, and income accounts for fund raising, donations,
> memberships, etc. so we can track income and expenses easily.  The GnuCash
> reports really help people see where money is coming from and going to.
> That's one of the reasons I was thinking of having the sub accounts - the
> bank reports will be like an overall report but with the underlying break
> down of fund allocation.  Does that make sense?
> 
> Every transaction is double entry, I think (one account credited and the
> other debited) e.g. a bill payment will credit Liabilities:Accounts Payable
> and debit Assets:Current Assets:Bank Account.  Is that what you mean?
> 
> Thanks
> Mort
> 
> On Tue, 14 Mar 2023 at 00:05, Robert Heller  wrote:
> 
>> At Mon, 13 Mar 2023 23:55:05 +1000 Mort Q  wrote:
>> 
>>> 
>>> Hi all
>>> I act as Treasurer for a community organisation, and want to look for a
>> way
>>> that GnuCash can subdivide the money in the bank account into planned
>>> expenses e.g. a few members do ongoing fund raising for equipment, so
>> could
>>> I make a sub-account of the bank account called "Equipment enhancement"?
>>> When making a deposit, allocate that money to "Assets:Current Assets:Bank
>>> Account:Equipment Enhancement" instead of the currently-used
>>> "Assets:Current Assets:Bank Account".
>>> 
>>> Currently, we just have the one account called "Bank Account" in the
>> Assets
>>> tree, and I keep a separate spreadsheet with the allocation break up.  I
>>> have to remember to do the extra work to keep the spreadsheet up to date.
>>> In my previous life, I learnt that it was better to have a single point
>> of
>>> truth for data.
>>> 
>>> I am thinking I will end up with an account tree like
>>> Assets:
>>>   -Current Assets:
>>>-Accounts Receivable
>>>-Bank Account:  (will still need this to be reported on for
>> audits,
>>> etc, as a single account)
>>>  -General Funds
>>>  -Equipment Enhancement
>>>  -Saved for something else
>>>  -etc
>>> Does this make sense?  Or am I missing something?
>>> Or creating a nightmare that will come back and bite me when I try to do
>>> reports, etc later?
>>> 
>>> Clearly, I am not an accountant, and a self-taught GnuCash user.
>> 
>> Clearly :-).
>> 
>> You are not fully understanding double-entry bookkeeping and how GnuCash
>> works
>> and is generally meant to be used.
>> 
>> Yes, you can have sub-accounts under Bank Account, but probably should be
>> looking at creating a budget.
>> 
>> You should *also* create additional accounts for the vario

Re: [GNC] Schedule transaction for 2 Wednesday?

[Peter West via gnucash-user]

An offset or delay option would be needed to solve that one, I think.
—
Peter West
p...@pbw.id.au
“Blessed are you when others revile you and persecute you and utter all kinds 
of evil against you falsely on my account.”

> On 11 Mar 2023, at 2:09 am, David Carlson  wrote:
> 
> We must be having fun by now!  The only schedule that I have not been able
> to implement correctly every single time is the Friday after the second
> Thursday of the month, but then I really don't expect to get that one
> right.
> 
> On Fri, Mar 10, 2023 at 9:57 AM mjchurchil--- via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
>> I think Stephen Butler is right. I get a deposit every 3rd Wednesday and
>> gnucash gets it right every time. Don't remember the process to set it up,
>> but his sounds correct. gnucash 4.13. Mike
>>On Thursday, March 9, 2023 at 10:29:50 PM PST, Stephen M. Butler <
>> stephen.m.butle...@gmail.com> wrote:
>> 
>> Set it on the Frequency tab.
>> 
>> Frequency -- pick Monthly
>> Every ? months -- (enter 1 into that box)
>> On the {big drop down list}  -- Pick the '2nd Wed' from the list.
>> 
>> Stephen M Butler, PMP, PSM
>> stephen.m.butle...@gmail.com
>> kg...@arrl.net
>> 253-350-0166
>> ---
>> 
>> 
>> ___
>> 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.

Re: [GNC] Confusing version numbers

[Peter West via gnucash-user]

In the MacOS and linux universes, such things would be determined by the 
LC_COLLATE setting of locale, I think. Windows?
—
Peter West
p...@pbw.id.au
“Blessed are those who are persecuted for righteousness' sake, for theirs is 
the kingdom of heaven.”

> On 9 Mar 2023, at 7:31 pm, Geert Janssens  wrote:
> 
> Op donderdag 9 maart 2023 09:34:36 CET schreef aeg via gnucash-user:
>> The fact that 9 is less than 12 is not confusing to me, but sorting by
>> Windows File Explorer routinely puts 12 before 9, whereas 09 is always
>> correctly arranged before 12 (and before 900). From the
>> link, https://semver.org/ provided by LI Daobing, I now understand that
>> there is a conventional way of numbering software releases, but I remain
>> puzzled by the insistence that leading zeros must not be used. It is often
>> the case that the status quo can be seen to work, but it is my opinion
>> that, if an improvement can be made and the effort to do so is minimal, it
>> is normally worth making that improvement. I assume that's what drives the
>> developers to make evolutionary changes and introduce updates. I'd just
>> like to see a numbering system that works in all circumstances. Alan
> 
> Well, it's all context related.
> 
> On my linux desktop files get properly sorted already now with .9 appearing 
> before .12. 
> 
> In fact linux desktop environments have been properly sorting such version 
> numbers for 
> years. So I don't even notice this on the PC I use every day. Looks like the 
> Windows' file 
> manager does not have that feature (yet) or perhaps it's configurable 
> somewhere ?
> 
> Regards,
> 
> Geert
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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] No longer receiving the e-mail from the user group

[Peter West]

I have been getting a flood of dmarc reports regarding messages to me through 
my mail server that originate from 204.107.200.65 code.gnucash.org 
<http://code.gnucash.org/>. I'm not really au fait with dmarc reports, but 
there is a dkim failure and possibly an spf failure on the originating server.

There was a server problem recently, which is expected to be temporary, so I 
expect the mail server function was shifted to the stopgap server, and set up 
hurriedly. The mail to those of us who are still receiving gnucash messages is 
passing through a lenient server, while I suspect Ken’s server takes a dim view 
of mail without correct dkim, or possibly spf.

When the original server is bak online, the problem will probably go away.


—
Peter West
p...@pbw.id.au
“Blessed are the peacemakers, for they shall be called sons of God.”

> On 25 Feb 2023, at 9:41 am, Ken Pyzik  wrote:
> 
> It appears that as of earlier this week, I stopped receiving e-mail from the 
> group e-mail list.  Not sure what it is – but my suspicion is that is may be 
> getting rejected at the Microsoft server side of things (since I am an 
> outlook.com domain user).
> 
> Can anyone see if my suspicion is correct or if there are any other e-mail 
> servers affected?  Thanks to all.
> 
> Ken
> 
> Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows
> 
> ___
> 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] Postgress connection string for nonstandard port

[Peter West]

The OP said that that was not working (see his attached image.)


—
Peter West
p...@pbw.id.au
“Blessed are the peacemakers, for they shall be called sons of God.”

> On 23 Feb 2023, at 6:30 pm, Geert Janssens  wrote:
> 
> From what I read in the code you should be able to pass a custom port by 
> adding it in the hostname field, like so:
> 
> yourserver.xyz:6543
> 
> Regards,
> 
> Geert
> 
> Op donderdag 23 februari 2023 07:26:09 CET schreef Peter West:
> > Are you on Windows, Mac or linux? How do you invoke GnuCash? There will be
> > some sort of environment in which the invocation occurs from your end.
> >
> > —
> > Peter West
> > p...@pbw.id.au
> > “Blessed are the peacemakers, for they shall be called sons of God.”
> >
> > > On 23 Feb 2023, at 2:13 am, Bob Treumann  wrote:
> > >
> > >
> > >
> > > I could set it since I control the server, but I don't know where I would
> > > set it so that it would take effect before the connection attempt is
> > > made.
> > >
> > > On Tue, Feb 21, 2023 at 10:53 PM Peter West  > > <mailto:p...@pbw.id.au>> wrote: Is it possible for you to set the PGPORT
> > > environment variable?
> > >
> > >
> > > —
> > > Peter West
> > > p...@pbw.id.au <mailto:p...@pbw.id.au>
> > > “Blessed are the peacemakers, for they shall be called sons of God.”
> > >
> > >> On 22 Feb 2023, at 11:01 am, Peter West  > >> <mailto:p...@pbw.id.au>> wrote:
> > >>
> > >> I’m using the default port, so I can’t help there.
> > >>
> > >> “Database” refers to the database, in my case, gnucash.
> > >>
> > >>
> > >> —
> > >> Peter West
> > >> p...@pbw.id.au <mailto:p...@pbw.id.au>
> > >> “Blessed are the pure in heart, for they shall see God.”
> > >>
> > >>> On 22 Feb 2023, at 8:07 am, Bob Treumann  > >>> <mailto:bobt...@gmail.com>> wrote:
> > >>>
> > >>> I am running PG on an amazon server on a non standard port (6543).
> > >>>
> > >>> The connection setup on gnucash does not have a filed to input the port.
> > >>> I added the port to the end of the hostname, a style that has worked
> > >>> with
> > >>> other applications.
> > >>>
> > >>> There is a field to enter the "database", which in PG contains multiple
> > >>> schemas.
> > >>> The user is typically connected to a schema by a default path.
> > >>>
> > >>> My questions are:
> > >>> How do I define the port?
> > >>> Does "Database" refer to "Schema"?
> > >>>
> > >>> I would try every combination but the interface only gives me one
> > >>> chance.
> > >>> It gives a "cannot connect" message then closes.
> > >>>
> > >>>
> > >>> [image: image.png]
> > >>> ___
> > >>> gnucash-user mailing list
> > >>> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
> > >>> To update your subscription preferences or to unsubscribe:
> > >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > >>> <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 <mailto:gnucash-user@gnucash.org>
> > >> To update your subscription preferences or to unsubscribe:
> > >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > >> <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] Postgress connection string for nonstandard port

[Peter West]

Are you on Windows, Mac or linux? How do you invoke GnuCash? There will be some 
sort of environment in which the invocation occurs from your end.

—
Peter West
p...@pbw.id.au
“Blessed are the peacemakers, for they shall be called sons of God.”

> On 23 Feb 2023, at 2:13 am, Bob Treumann  wrote:
> 
> 
> 
> I could set it since I control the server, but I don't know where I would set 
> it so that it would take effect before the connection attempt is made.   
> 
> On Tue, Feb 21, 2023 at 10:53 PM Peter West  <mailto:p...@pbw.id.au>> wrote:
> Is it possible for you to set the PGPORT environment variable?
> 
> 
> —
> Peter West
> p...@pbw.id.au <mailto:p...@pbw.id.au>
> “Blessed are the peacemakers, for they shall be called sons of God.”
> 
>> On 22 Feb 2023, at 11:01 am, Peter West > <mailto:p...@pbw.id.au>> wrote:
>> 
>> I’m using the default port, so I can’t help there.
>> 
>> “Database” refers to the database, in my case, gnucash.
>> 
>> 
>> —
>> Peter West
>> p...@pbw.id.au <mailto:p...@pbw.id.au>
>> “Blessed are the pure in heart, for they shall see God.”
>> 
>>> On 22 Feb 2023, at 8:07 am, Bob Treumann >> <mailto:bobt...@gmail.com>> wrote:
>>> 
>>> I am running PG on an amazon server on a non standard port (6543).
>>> 
>>> The connection setup on gnucash does not have a filed to input the port.
>>> I added the port to the end of the hostname, a style that has worked with
>>> other applications.
>>> 
>>> There is a field to enter the "database", which in PG contains multiple
>>> schemas.
>>> The user is typically connected to a schema by a default path.
>>> 
>>> My questions are:
>>> How do I define the port?
>>> Does "Database" refer to "Schema"?
>>> 
>>> I would try every combination but the interface only gives me one chance.
>>> It gives a "cannot connect" message then closes.
>>> 
>>> 
>>> [image: image.png]
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>>> <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 <mailto:gnucash-user@gnucash.org>
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>> <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] Postgress connection string for nonstandard port

[Peter West]

Is it possible for you to set the PGPORT environment variable?


—
Peter West
p...@pbw.id.au
“Blessed are the peacemakers, for they shall be called sons of God.”

> On 22 Feb 2023, at 11:01 am, Peter West  wrote:
> 
> I’m using the default port, so I can’t help there.
> 
> “Database” refers to the database, in my case, gnucash.
> 
> 
> —
> Peter West
> p...@pbw.id.au
> “Blessed are the pure in heart, for they shall see God.”
> 
>> On 22 Feb 2023, at 8:07 am, Bob Treumann  wrote:
>> 
>> I am running PG on an amazon server on a non standard port (6543).
>> 
>> The connection setup on gnucash does not have a filed to input the port.
>> I added the port to the end of the hostname, a style that has worked with
>> other applications.
>> 
>> There is a field to enter the "database", which in PG contains multiple
>> schemas.
>> The user is typically connected to a schema by a default path.
>> 
>> My questions are:
>> How do I define the port?
>> Does "Database" refer to "Schema"?
>> 
>> I would try every combination but the interface only gives me one chance.
>> It gives a "cannot connect" message then closes.
>> 
>> 
>> [image: image.png]
>> ___
>> 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] Postgress connection string for nonstandard port

[Peter West]

I’m using the default port, so I can’t help there.

“Database” refers to the database, in my case, gnucash.


—
Peter West
p...@pbw.id.au
“Blessed are the pure in heart, for they shall see God.”

> On 22 Feb 2023, at 8:07 am, Bob Treumann  wrote:
> 
> I am running PG on an amazon server on a non standard port (6543).
> 
> The connection setup on gnucash does not have a filed to input the port.
> I added the port to the end of the hostname, a style that has worked with
> other applications.
> 
> There is a field to enter the "database", which in PG contains multiple
> schemas.
> The user is typically connected to a schema by a default path.
> 
> My questions are:
> How do I define the port?
> Does "Database" refer to "Schema"?
> 
> I would try every combination but the interface only gives me one chance.
> It gives a "cannot connect" message then closes.
> 
> 
> [image: image.png]
> ___
> 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] add note to transaction

[Peter West]

Those more knowledgeable can comment here, but I imagine that modifying the 
Note field in the underlying database would be harmless.


—
Peter West
p...@pbw.id.au
“If a kingdom is divided against itself, that kingdom cannot stand. And if a 
house is divided against itself, that house will not be able to stand.”

> On 29 Jan 2023, at 8:49 am, Derek Atkins  wrote:
> 
> You have to do each one individually, however you can copy-and-paste the
> note into each of them (one at a time) in a register in double-line mode. 
> So it should be pretty fast (once you have a register with only the
> transactions you need to modify).
> 
> -derek
> 
> On Sat, January 28, 2023 5:18 pm, Gary Holtum wrote:
>> I have several (dozens) of transactions that I would like to add a note
>> to.
>> The same note.
>> 
>> Is there a way to do it all at once or do I have to do each one
>> individually?
>> 
>> 
>> 
>> Gary Holtum
>> 
>> ___
>> 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.
>> 
> 
> 
> -- 
>   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.

___
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] exporting from gnucash to Excel

[Peter West]

How can this be enforced except by obliging you to use only software they 
(inland revenue?) endorse?

—
Peter West
p...@pbw.id.au
“Which is easier, to say to the paralytic, ‘Your sins are forgiven,’ or to say, 
‘Rise, take up your bed and walk’?”

> On 14 Jan 2023, at 6:40 am, Maf. King  wrote:
> 
> On Friday, 13 January 2023 04:45:20 GMT David T. via gnucash-user wrote:
>> Indeed.
>> 
>> I don't have to comply with this either, but it seems to me that "pressing a
>> button" to export to Excel provides exactly the same automated reliability
>> as CTRL-C/CTRL-V (two buttons, if you will) into Excel. The data in both
>> cases will have the same reliability.
>> 
> 
> You know that,  I know that.  The gubberment want "more automation" than 
> that.   
> 
> Because all the VAT fraud in the world happens when you make an honest error 
> copying 3 numbers between programs, not systematically at the point of data 
> entry...
> 
> It's digital, and only directly linked.  must be foolproof, so say the powers 
> that be
> 
> Hmmm.  >:-)
> 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
> -
> 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] Weird MacOS UI issue with windows cutoff on bottom and right

[Peter West]

It may not be relevant to this issue, but I have found the Monterey UI (12.6.2 
on an M1) to be extremely unstable. (Basically, it’s the biggest pile of junk 
Apple has ever dumped on a Mac of mine.) I reboot at least every three or four 
days, and sometimes a couple of times a day, to fix UI problems, generally 
involving the refusal of some UI elements to accept keyboard input, but also 
some oddities in the display of UI elements.m Only rebooting fixes the problem.


—
Peter West
p...@pbw.id.au
When the wine ran out, the mother of Jesus said to him, “They have no wine.”

> On 10 Jan 2023, at 8:56 am, R Losey  wrote:
> 
> I haven't noticed this problem... I'm running Monterey (12.6.2) and GnuCash
> 4.13. I haven't used the Edit Bill window, but I cannot say that I've seen
> it on other windows (at least, not so far).
> 
> 
> On Mon, Jan 9, 2023 at 1:24 AM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> 
>> Monterey, GnuCash 4.13
>> 
>> I noticed right away when 4.13 was released that there were some weird
>> issues with all GnuCash windows. I haven't managed to narrow down the
>> main window as it seems to be transient as the window is resized.
>> 
>> Some child windows though seem to be pretty consistent, at least on
>> first creation.
>> 
>> Attached is a screenshot of the Edit Bill dialog.
>> 
>> Notice the right side & bottom are cutoff.
>> 
>> In addition, the resize mouse pointer icon seems to become available as
>> if the window manager thinks the edges of the dialog are where they
>> should be, rather than where they are visible. (so 'out in space' on the
>> desktop)
>> 
>> Enlarging the window in either the right, bottom, or both directions can
>> be finessed to make the window appear not-cutoff, but this 'jumps' back
>> to cutoff if not exact. (If needed I can try to do a screen recording
>> showing this effect)
>> 
>> This is likely a GTK issue rather than GnuCash, but I'm curious if
>> anyone else has noticed this and if a dev can chime in on where I should
>> file this bug.
>> 
>> (there are other issues in this version with resizing windows and
>> placing them adjacent to each other, but I'll post about that separately
>> when I can reliably describe and screenshot/screencast the problem)
>> 
>> 
>> --
>> 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
>> -
>> 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.

___
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] Scary moment

[Peter West]

How are you accessing your file from the two different operating systems? Are 
you running a Linux VM on your Windows system? If so, are you accessing a 
common disc from both systems, or are you using a network file system to access 
the GnuCash data file?


—
Peter West
p...@pbw.id.au
And the angel said to them, “Fear not, for behold, I bring you good news of 
great joy that will be for all the people. For unto you is born this day in the 
city of David a Saviour, who is Christ the Lord. And this will be a sign for 
you: you will find a baby wrapped in swaddling cloths and lying in a manger.”

> On 31 Dec 2022, at 11:31 am, R Losey  wrote:
> 
> Versions are a little confusing Mac was running 4.12 until today; I am
> now on the current version.
> 
> I updated the Windows version earlier this week.
> 
> Linux GnuCash is older (4.), but I don't run the GUI there -
> usually just the gnucash-cli stock updates, which I updated on Thursday
> from whatever it was.
> 
> For now, I'm going to avoid running the gnucash-cli updates... I only
> caught the missing checks because of the tax work I was doing; I'm rather
> scared about what else may have been lost.
> 
> Also, I've closed and re-opened GnuCush on both Windows and Mac multiple
> times, and the transactions are there, like I expect (but I haven't run the
> stock price update)
> 
> 
> 
> 
> On Fri, Dec 30, 2022 at 7:25 PM Stan Brown 
> wrote:
> 
>> Are you using the current version? If so, it might be appropriate to
>> enter a bug report, mentioning each of the things you have checked for.
>> 
>> Stan Brown
>> Tehachapi, CA, USA
>> https://BrownMath.com
>> 
>> On 2022-12-30 17:23, R Losey wrote:
>>> Thanks, but I am aware of this. On Wed, after I entered the data, I
>>> re-ran the report, and verified that the checks now showed up.
>>> 
>>> On Friday, the checks were missing again.
>>> 
>>> The only thing I can think of that was different is that I was running
>>> price updates on Tue, Wed, and Thu via gnucash-cli.
>>> 
>>> 
>>> On Fri, Dec 30, 2022 at 7:11 PM Stan Brown >> <mailto:the_stan_br...@fastmail.fm>> wrote:
>>> 
>>>Good suggestions, Adrien. I have a fourth thought:
>>> 
>>>We don't know how Losey was doing the "workup", but if it involved a
>>>report, and some of the relevant transactions were in accounts
>> created
>>>after the last time the report was saved, then transactions in those
>>>accounts would not be picked up automatically. In that case, Losey
>>>should open the saved report configuration, click Edit » Report
>> Options,
>>>select all relevant accounts, and save the new configuration.
>>> 
>>>Stan Brown
>>>Tehachapi, CA, USA
>>>https://BrownMath.com <https://BrownMath.com>
>>> 
>>>On 2022-12-30 13:56, Adrien Monteleone wrote:
>>>> Another possibility:
>>>> 
>>>> The transactions ended up in a different account.
>>>> 
>>>> Do a Find from the Accounts tab from all sides of the transaction
>> and
>>>> see if they pop up when you think they are missing.
>>>> 
>>>> Also, check the Orphan and Imbalance accounts.
>>>> 
>>>> And another possibility:
>>>> 
>>>> You have a View Filter on the affected register(s).
>>>> 
>>>> The status bar indicates on the far right, if you are using a
>> filtered
>>>> view.
>>>> 
>>>> A third:
>>>> 
>>>> The dates are way off and aren't where you are looking. This may
>>>or may
>>>> not be combined with a filtered view. A Find using accounts,
>> amounts,
>>>> descriptions, et cetera should find them so you can correct the
>> dates.
>>>> 
>>>> Regards,
>>>> Adrien
>>>> 
>>>> On 12/30/22 10:43 AM, R Losey wrote:
>>>>> I was doing preliminary tax workup earlier this week,
>> 
> 
> 
> -- 
> _
> 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.

___
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] Date format for QIF file

[Peter West]

What date formats ARE supported by the GNC QIF import process? 29 December 2022 
is unambiguous, but apparently unsupported by GNC.

Happy 6th day of Christmas!

—
Peter West
p...@pbw.id.au
And the angel said to them, “Fear not, for behold, I bring you good news of 
great joy that will be for all the people. For unto you is born this day in the 
city of David a Saviour, who is Christ the Lord. And this will be a sign for 
you: you will find a baby wrapped in swaddling cloths and lying in a manger.”

> On 30 Dec 2022, at 4:55 am, Derek Atkins  wrote:
> 
> Not particularly.
> The issue is that 11/12 is ambiguous.  Is it November 12 or December 11?  
> Using a 2-digit year doesn't help.
> The best way is to ensure you have a day > 12 in the mix (and a year > 31). 
> So using 12/29/2022 should give you a unique format.
> You cannot use month names, only numbers.
> -derek
> Sent using my mobile device. Please excuse any typos.
> On December 29, 2022 14:35:09 m...@tgr66.me wrote:
> 
>> I’m developing QIF files to import my old investments. I get asked every 
>> time to confirm the date format (the entire import process is a bit long 
>> imo). The QIF specification says I ought to be able to enter a date using 
>> `dd month year`; for example: 29 December 2022. However, this results in an 
>> error in GnuCash.
>> 
>> Is there a format I can use in the files that GnuCash will accurately 
>> autodetect the correct format?
>> 
>> Thanks.
>> 
>> Tim
>> ___
>> 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] Feature request - prevent a transaction with todays date

[Peter West]

> On 28 Dec 2022, at 10:43 am, Dr. David Kirkby 
>  wrote:
> 
...
> I am still getting used to this software.  I don’t find it the most
> intuitive piece of software, but it will be beneficial to me. The other
> gripes that I have, are not ones that the developers want to fix
> 
> 3) No direct support for cryptocurrencies
> 
> I could probably fix the last myself if I built the software from the
> source code, but the first two are more tricky.

If you decide to try this, please let the list (or me) know. I may even be able 
to give you a hand, although I was never a C++ programmer. There is more C than 
C++, though.

—
Peter West
p...@pbw.id.au
And the angel said to them, “Fear not, for behold, I bring you good news of 
great joy that will be for all the people. For unto you is born this day in the 
city of David a Saviour, who is Christ the Lord. And this will be a sign for 
you: you will find a baby wrapped in swaddling cloths and lying in a manger.”



___
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] Account structure for tracking trip expenses

[Peter West]

I would like to have the trip fuel expenses, for example, also accumulate into 
the overall fuel expenses if possible.

Thanks

> On 19 Nov 2022, at 12:24 pm, Peter West  wrote:
> 
> How do folks here keep track of expenses for a particular event? For example, 
> a road trip with fuel, food and accommodation expenses, where I have a CoA 
> which has accounts for “normal” fuel, food and accommodation?
> 
> 
> —
> Peter West
> p...@pbw.id.au
> And he entered the temple and began to drive out those who sold, saying to 
> them, “It is written, My house shall be a house of prayer,’ but you have made 
> it a den of robbers.”
> 
> ___
> 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] Account structure for tracking trip expenses

[Peter West]

How do folks here keep track of expenses for a particular event? For example, a 
road trip with fuel, food and accommodation expenses, where I have a CoA which 
has accounts for “normal” fuel, food and accommodation?


—
Peter West
p...@pbw.id.au
And he entered the temple and began to drive out those who sold, saying to 
them, “It is written, My house shall be a house of prayer,’ but you have made 
it a den of robbers.”

___
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] Third party OFX/CVS providers

[Peter West]

The other great tool for processing pdfs is PDFBox. It’s a java jar file, so 
you need to have a reasonably recent JVM installed.

https://pdfbox.apache.org/ <https://pdfbox.apache.org/>

I’m still using version2.
Here are the commandline tools.
https://pdfbox.apache.org/2.0/commandline.html 
<https://pdfbox.apache.org/2.0/commandline.html>


I have a series of scripts for various types of manipulation and text 
extraction.

It is worth noting that people who naïvely believe that text extraction from a 
PDF is simple will get burnt if they are not checking the results. PDF files 
are not obliged to store their text in any particular order. Mostly they do, 
until they don’t.

I can post my scripts if anyone is interested.

There are also a number of other tools for linux that i access on  my Mac 
through MacPorts.

God bless you.

—
Peter West
p...@pbw.id.au
“The kingdom of heaven is like treasure hidden in a field, which a man found 
and covered up. Then in his joy he goes and sells all that he has and buys that 
field.”

> On 7 Aug 2022, at 2:52 am, Tom Browder  wrote:
> 
> On Sat, Aug 6, 2022 at 11:43 AM Glenn Fowler  wrote:
>> 
>> My scripts are in PowerShell. For GhostScript I'm just using CLI:
> 
> Thanks, Glenn, that's close to what I've found for Linux:
> 
>$ gs -sDEVICE=txtwrite -o output.txt input.pdf
> 
> It just needs some tweaking and post-conversion parsing (very bank
> specific). I'll see how my current PDF statements look after text
> conversion.
> 
> But I'll also keep looking at YNAB for a more general solution.
> 
> Cheers!
> 
> -Tom
> ___
> 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] Adding a new currency

[Peter West]

So cryptocurrencies will never be supported currencies, because 
cryptocurrencies will never be part of ISO-4217.

—
Peter West
p...@pbw.id.au
“And the rain fell, and the floods came, and the winds blew and beat against 
that house, and it fell, and great was the fall of it.”

> On 8 Jul 2022, at 2:51 am, john  wrote:
> 
> 
> 
>> On Jul 7, 2022, at 9:23 AM, Esteban Maringolo  wrote:
>> 
>> Hi,
>> 
>> Is it possible to manually add a new currency to the list of currencies?
>> 
>> I will take care of updating the exchange rate.
> 
> No. Currency in GnuCash is defined as "currencies recognized by ISO-4217". 
> Everything else is a commodity.
> 
> 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] Bitcoin Lightning payments

[Peter West]

The existing structure of 4217 codes will not work for crypto. It uses the 
two-letter country code plus one letter for the currency. (Do any of these 
conflict with he three letter country codes? As it happens, yes: BTN, CHE, MKD) 
All these codes are mnemonic. (There may be a few for which that is stretching 
the point, but not for lack of wanting a mnemonic.) One letter will not do for 
crypto; there are too many, and they are proliferating. The upshot is that 
whatever happens to crypto designations through ISO, the structure will be 
different.

One might select an otherwise unused first letter (X is the only contender) and 
provide two letters for designating the currency. That will severely restrict 
the mnemonic value of the code. There may well be competing schemes, but every 
exchange uses one – three or four letters from my observations – and that 
situation will soon enough resolve to a single set. Who knows what ISO will 
eventually come up with to accommodate crypto, except that it will not be the 
same structure?

Does GnuCash make ANY use of the internal structure of 4217 codes? If so, 
there’s a development problem right there. If not, things are easier. As we 
speak, exchanges are providing cross-currency quotations for both ISO 
currencies and crypto. How do they do it? As long as the crypto designators 
(like BTC, BUSD, ETH, DOGE) are distinct from the currency designators, the 
indicated currency is unambiguous.

If you wait for 4217, you’ll be waiting a long time.

Or so it seems to me.

—
Peter West
p...@pbw.id.au
And taking the five loaves and the two fish, he looked up to heaven and said a 
blessing over them. Then he broke the loaves and gave them to the disciples to 
set before the crowd.

> On 19 Jun 2022, at 7:32 am, Michael or Penny Novack 
>  wrote:
> 
…
> I'll reply not a a developer but as somebody whose done LOTS of software 
> design in my day.
> 
> a) If the developers did the job right, the ISO currency codes are not hard 
> coded but in "app data" read in when the program starts << that means they 
> can be changed without changing the code in any program, just data in a file.
> 
> b) NO, not a "lame excuse". Misunderstanding of what the ISO is/does. It sets 
> STANDARDS. In other words, "for currency X use ABX" (or whatever). Dr. David, 
> if there is no agreed standard for what the three letter currency code for 
> "bitcoin" is, what should the developers use? Should they simply use ANY 
> three characters not already in use for some currency that has an ISO 
> currency code? There are > 17 thousand three character codes possible and 
> only the order of a hundred or two in use. Whatever they pick the odds are 
> worse then 10,000:1 it won't agree with the code chosen by any other team of 
> software developers OR with what eventually become the standardized currency 
> code for bitcoin if/when the ISO chooses one.
> 
>Your beef should not be with the gnucash developers but with the ISO. You 
> bitcoin users need to lobby THEM to choose a code for bitcoin. Actually, 
> there are TWO standards you need them to choose. One one is the two character 
> prefix to be used when a currency that is not the currency of a nation state 
> (or union of states, like EU in EUR). Then the third character that means 
> "bitcoin".
> 
>Actually, there ARE several codes (competing codes) in use for 
> Bitcoin. Any of those might end up as the eventual code except BTC (which 
> violates ISO 4217 because BT is the code for an existing nation state). When 
> I was suggesting that a two character code first, note that "CC" (for 
> "cryptocurrency" will not do as "CC" already assigned as a "country code".

___
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] Bitcoin Lightning payments

[Peter West]

But you can’t then quotes for cross-currency values directly, because such 
quotes will be expressed in terms of the primary unit - BTC, for example.

—
Peter West
p...@pbw.id.au
“But when you give to the needy, do not let your left hand know what your right 
hand is doing, so that your giving may be in secret.”

> On 18 Jun 2022, at 4:36 pm, HSC  wrote:
> 
> 
> Unfortunately, the idea of pretending that 1$ = 1BTC doesn't work exactly as 
> it should, because the Spend/Receive fields don't accept entries smaller than 
> 0.01, even if smallest fraction for account is set to 1e-8.
> Neither does setting the decimal places to 8 in Preferences > Numbers > 
> Decimal places affect Spend/Receive fields. Even setting to 3 doesn't 
> increase them beyond 2 decimal places.
> GNC just blanks and ignores a number less than 0.01
> 
> That's tolerable, if we pretend that 1$ = 1 sat instead of 1 BTC, and round 
> the the milisats of fees to nearest 10, as if they are US cents.
> That should be close enough for the foreseeable.
> 
> HSC
> 
> --- Original Message ---
> On Saturday, June 18th, 2022 at 04:05, HSC  wrote:
> 
> 
>> 
> 
>> 
> 
>> 
> 
>> Thank you, Michael D Novack!
>> That's a great solution until GNC development catches up to the crypto 
>> world: we will keep separate GNC file for each cryptoasset.
>> 
> 
>> The remaining problem is that Bitcoin Lightning goes to 11 decimal places, 
>> and Ethereum I think goes to 16.
>> Will round up to 1 sat for now, since it's still of insignificant value, but 
>> eventually that will also need some improvement.
>> 
> 
>> Another thing is that moving from onchain Bitcoin to its Lightning layer 
>> channels and back is a Bitcoin transaction in itself, which involves an 
>> onchain fee to open the channel. (Subsequent instant txs in the LN channels 
>> are at most a few sats for substantial BTC amount, and small payments txs 
>> often cost less than 1 sat - a fraction of a US cent in value - as I 
>> mentioned.)
>> So, I guess Lightning layer bitcoins will have to be represented by some 
>> other fiat of the obscure ones that start with L perhaps.
>> 
> 
>> The other issue is exchanging BTC for USD stablecoins, such as USDC. Then 
>> would have to represent that USD with some other dollar, such as the CAD 
>> maybe?
>> 
> 
>> Might get error-prone. Since even Bitcoin is over a decade old now, seems 
>> that it would be useful for GNC to allow "user-defined non-ISO" currencies, 
>> such as "XBT" used for Bitcoin on some exchanges.
>> Seems unlikely that central banks will ever allow such currencies to become 
>> ISO.
>> 
> 
>> 
> 
>> HSC
>> 
> 
>> 
> 
>> --- Original Message ---
>> On Saturday, June 18th, 2022 at 02:56, gnucash-user-requ...@gnucash.org 
>> wrote:
>> 
> 
>> 
> 
>> 
> 
>>> Today's Topics:
>>> 
> 
>>> 1. Re: Bitcoin Lightning payments (Michael or Penny Novack)
>>> 2. Re: Online crypto value quote (David T.)
>>> 3. Re: Online crypto value quote (Geoff)
>>> 
> 
>>> --
>>> 
> 
>>> Message: 1
>>> Date: Fri, 17 Jun 2022 22:45:25 -0400
>>> From: Michael or Penny Novack stepbystepf...@comcast.net
>>> 
> 
>>> To: gnucash-user@gnucash.org
>>> Subject: Re: [GNC] Bitcoin Lightning payments
>>> Message-ID: 967b4023-8d76-dc43-9fbe-f00854c99...@comcast.net
>>> 
> 
>>> Content-Type: text/plain; charset=UTF-8; format=flowed
>>> 
> 
>>> On 6/17/2022 9:21 PM, HSC wrote:
>>> 
> 
>>>> Hello Everyone,
>>>> 
> 
>>>> Haven?t used GC a couple years, and trying to recollect how it all works.
>>>> 
> 
>>>> Current challenge is starting to work with payments and expenses that are 
>>>> exclusively in Bitcoin.
>>> 
> 
>>>> Has anyone experience with some commercial accounting software that 
>>>> handles Bitcoin in an easier way as a currency that it is?
>>> 
> 
>>> IF what you mean by "exclusively in bitcoin" is accounting JUST in
>>> bitcoin, you would not have to treat it as stock/commodity evaluated in
>>> some other currency. You could keep a set of books denominated in
>>> bitcoin. The lack of a currency symbol is an illusion, as they are just
>>> conventional symbols. Understand? In YOUR books "$" doesn't have to
>>> stand for dollars

Re: [GNC] Integration between Freshbooks and Gnucash?

[Peter West]

Are there similar documents for the scheme bindings?


—
Peter West
p...@pbw.id.au
Jesus said to him, “I am the way, and the truth, and the life. No one comes to 
the Father except through me.”

> On 17 May 2022, at 5:03 pm, Matteo Lasagni  wrote:
> 
> If you have some expertise with Python programming,
> you could  fetch invoices and bills from Freshbooks
> and update Gnucash  through the Python bindings.
> 
> You can double check the simple_invoice_insert.py example here:
> https://code.gnucash.org/docs/MAINT/group__python__bindings__examples.html
> 
> Be aware that Python bindings do not (yet) support all possible use cases
> which can be manually executed.
> 
> regards,
> Matteo
> 
> 
> On Tue, 17 May 2022 at 01:23, Glenn Fowler  wrote:
> 
>> I can say that spending the time to get the integration done whether CSV or
>> with an API call is definitely worth it. One-time work and you reap the
>> benefits forever.
>> I did the same for my application and I estimated it saves almost a hundred
>> hours of time a year. That's a 2 week vacation!
>> 
>> On Mon, May 16, 2022 at 4:48 PM Jim DeLaHunt 
>> wrote:
>> 
>>> Hello, GnuCash users?
>>> 
>>> I use a service called Freshbooks [1] to track the time I spend working
>>> in my sole proprietorship business, and to generate invoices to clients
>>> billing that time, and to accept payments. In the meantime I do my
>>> bookkeeping in GnuCash. Are there other GnuCash users who also use
>>> Freshbooks?
>>> 
>>> One tedious aspect of this combination is that I need to re-author my
>>> invoices in GnuCash after I author them in Freshbooks and send them to
>>> the customer. Also, if I buy something for a customer, I enter the
>>> bookkeeping transaction in GnuCash and then re-author it in Freshbooks
>>> so that I can bill the expense to my client. It would be nice to avoid
>>> this duplication.
>>> 
>>> Freshbooks has an API [2], which should let apps send data to and
>>> receive data from Freshbooks via HTTP calls and JSON data structures.
>>> They just launched an App Store [3] where vendors can advertise apps
>>> which integrate with Freshbooks. I do not see any apps there at the
>>> moment which mention GnuCash. But it should be possible to author such
>>> an app.
>>> 
>>> I am interested in an app connecting Freshbooks to GnuCash. My top
>>> priority is to be able to export invoice and payment data from
>>> Freshbooks to GnuCash without re-authoring. But more integration is also
>>> potentially useful for other people. If you are also interested, I would
>>> encourage you to let me know either directly or via this email list
>>> thread. You could also suggest such an app to Freshbooks [4]. It
>>> probably won't make anything happen soon, but registering the interest
>>> can't hurt. I am a developer, so I could potentially develop such an app
>>> — but realistically, it is far enough down my wish list that I won't get
>>> to it soon, unless I get encouragement.
>>> 
>>> Best regards,
>>>  —Jim DeLaHunt, Vancouver, Canada
>>> 
>>> [1] <https://www.freshbooks.com/>
>>> [2] <https://www.freshbooks.com/api/start>
>>> [3] <https://appstore.freshbooks.com/>
>>> [4] <https://appstore.freshbooks.com/>, click the "Suggest an App"
>> button
>>> 
>>> 
>>> ___
>>> 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.
>> 
> 
> 
> -- 
> 
> -
> Matteo Lasagni
> 
> 
> *"You

Re: [GNC] QFX file for Bank of American business account not

[Peter West]

> On 5 May 2022, at 7:40 am, Jean Laroche  wrote:
> 
> 
> cat stmt.qfx | sed -E "/ stmt_fixed.qfx
> 

For mac users:

cat stmt.qfx | gsed -E '/\|\|\/d' >stmt_fixed.qfx

This works with gsed, but not with macos sed. Getting a robust expression with 
macos sed is kinda messy. You’re probably better off using a perl one-liner.

cat stmt.qfx | perl -pe '$_ = "" if /\b(CARDNUM|CARDNAME|MCC)\b/‘ 
>stmt_fixed.qfx


—
Peter West
p...@ehealth.id.au
Then one of them, named Cleopas, answered him, “Are you the only visitor to 
Jerusalem who does not know the things that have happened there in these days?”


> I'm not a sed guru, so maybe there's a better/more robust way to do it. But 
> this should give you a temporary solution?
> 
> Jean
> 
> LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:39:13:E: 
> element "CARDNUM" undefined
> 
> (Above message occurred on Line 39, Column 14)
>  X ERROR: startElement: incoming_data should be empty! You are probably 
> using OpenSP <= 1.3.4.  The following data was lost: -50.00
> (Above message occurred on Line 39, Column 6)
> LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:40:14:E: 
> element "CARDNAME" undefined
> 
> (Above message occurred on Line 40, Column 15)
>  X ERROR: startElement: incoming_data should be empty! You are probably 
> using OpenSP <= 1.3.4.  The following data was lost: 9767
> (Above message occurred on Line 40, Column 6)
> LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:41:9:E: 
> element "MCC" undefined
> 

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

[Peter West]

Use File > Save as… to close GnuCash, and specify the location and file name 
(without the date.) That then becomes the file that you always open. The files 
with dates are the backups. If you take the earlier advice, you will set the 
number of backup files to keep in Preferences > General – Retain backup files.


—
Peter West
p...@ehealth.id.au
“Behold, this child is appointed for the fall and rising of many in Israel, and 
for a sign that is opposed (and a sword will pierce through your own soul 
also), so that thoughts from many hearts may be revealed.”

> On 4 Jan 2022, at 10:27 am, Steve Mortimer  wrote:
> 
> Adrien,
> 
> Here is what I have found out.  Each time the program is closed it adds that 
> date and time to the name of the file.  How can this be stopped?
> 
> I can change the name of the file so that there is only one date for the file 
> name and bring it up with all of the transactions in the file.  I close the 
> program and the file now has two dates showing on it.
> 
> Guess there is no original file on the computer.
> Steve
> 
>> Steve Mortimer <mailto:noahsark0...@att.net>
>> Monday, January 3, 2022 5:40 PM
>> Thanks.  Looking into this.
>> Steve
>> 
>> 
>> Adrien Monteleone <mailto:adrien.montele...@lusfiber.net>
>> Monday, January 3, 2022 4:12 PM
>> Steve,
>> 
>> I'll add that it appears you are opening backup files, not the main GnuCash 
>> file. The very long file names indicate this. So it seems you have backups 
>> of backups. If you find the main file, it might not have all the same 
>> transactions as whatever you are currently working in.
>> 
>> 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.
>> 
> 
> -- 
> Steve Mortimer
> 
> 2 Timothy 3:16-17 (ESV)
> All Scripture is breathed out by God and profitable for teaching, for 
> reproof, for correction, and for training in righteousness that the man of 
> God may be complete, equipped for every good work
> ___
> 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] Bitcoin is legal currency in El Salvador - why notadd BTC?

[Peter West]

I purchased cryptocurrency (in more than one form) specifically to use as a 
currency. Certain currencies (not including BTC, but that may be changing) are 
not readily traceable, and in this they function on the internet as cash does 
in everyday transactions.

BTW, if you don’t actively use and support cash, it won’t be available to you 
for very much longer. In Australia, it is illegal to use cash for transactions 
greater than $10,000. This amount can be readily reduced, and it will be.

It will become increasingly important to support cryptocurrency for 
transactions, irrespective of the “official’ designation of currencies.

Peter
—
Peter West
p...@ehealth.id.au <mailto:p...@ehealth.id.au>
“For behold, when the sound of your greeting came to my ears, the baby in my 
womb leaped for joy.”


> On 10 Dec 2021, at 1:01 pm, Frank H. Ellenberger 
>  wrote:
> 
> Hi Colin,
> 
> Am 10.12.21 um 03:37 schrieb Colin Arndt:
>> Considering this is an issue that regularly comes up on the list, it might 
>> save everyone some time if there were a statement or section on the Wiki. 
>> (Just searched around and didn’t find one). 
> 
> EExcellent idea! IMHO  you should name the page "Crypto Curerencies" and
> link it at least from https://wiki.gnucash.org/wiki/Using_GnuCash.
> 
>> I would be happy to contribute something incorporating John’s earlier 
>> comments: Bitcoin is not supported as a currency in GnuCash and will not be 
>> until it is added to [insert ISO standard he mentioned]. However, it can be 
>> added as a custom security with [lengthier version of the instructions I 
>> gave above]. 
> 
> https://bugs.gnucash.org/show_bug.cgi?id=690479 describes some aspects
> and links to others.
> 
>> Best,
>> Colin
> 
> 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.

___
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] save as sqlite3 error

[Peter West]

FWIW, I just tried to save my postgresql-based data as sqlite3 and GnuCash 
crashed.

Peter
—
Peter West
p...@ehealth.id.au
“And why do you not judge for yourselves what is right?”

> On 23 Oct 2021, at 11:42 am, Geoff  wrote:
> 
> Looks like that approach could work, but I'm afraid I don't know enough about 
> the inner workings of GnuCash to advise you authoritatively.
> 
> Good luck!
> 
> 
> Regards
> 
> Geoff
> =
> 
> On 22/10/2021 11:52 pm, Public Address wrote:
>> Thanks, interesting that deleting the “NULL” text and leaving it empty 
>> allowed it to go through.
>> “but direct database manipulation may void your GnuCash warranty.”
>> I was thinking about direct upload to the postgres table (creating my own 
>> guid and checking for duplication) but that doesn’t sound like a good idea?
>> Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986 
>> <https://go.microsoft.com/fwlink/?LinkId=550986>> for Windows
>> *From: *Geoff <mailto:cleanoutmys...@gmail.com 
>> <mailto:cleanoutmys...@gmail.com>>
>> *Sent: *20 October 2021 11:15
>> *To: *Public Address <mailto:public.addr...@hotmail.co.uk 
>> <mailto:public.addr...@hotmail.co.uk>>; David Carlson 
>> <mailto:david.carlson@gmail.com <mailto:david.carlson@gmail.com>>
>> *Cc: *gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
>> <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>>
>> *Subject: *Re: [GNC] save as sqlite3 error
>> That would do it - the schema prohibits NULLs.
>> I don't believe it is possible to import securities, it is not an option
>> on the Import menu.  Depending how many you have, you could consider:-
>> Learning to script AutoHotKey - https://www.autohotkey.com/ 
>> <https://www.autohotkey.com/> <https://www.autohotkey.com/ 
>> <https://www.autohotkey.com/>> - which is
>> excellent for automating Windows applications.
>> Or (big stretch) have a look at PieCash - the securities table is called
>> "commodities" -
>> https://github.com/sdementen/piecash/blob/master/piecash/core/commodity.py 
>> <https://github.com/sdementen/piecash/blob/master/piecash/core/commodity.py><https://github.com/sdementen/piecash/blob/master/piecash/core/commodity.py
>>  
>> <https://github.com/sdementen/piecash/blob/master/piecash/core/commodity.py>>
>>  - but direct database manipulation may void your GnuCash warranty.
>> I reckon you will probably find it quicker to type them in yourself -
>> you can import price data from CSV once the securities themselves are
>> set up.
>> Hope this helps.
>> Regards
>> Geoff
>> =
>> On 20/10/2021 7:25 pm, Public Address wrote:
>> > Thank you all.  Someone last night pointed me to the trace file.  I
>> > tried to save as sqlite3, failed then closed down.  The last lines are
>> > as follows:
>> >
>> > * 17:59:21 ERROR  gboolean qof_book_is_readonly(const
>> > QofBook*): assertion 'book != NULL' failed
>> > * 17:59:26 ERROR  [error_handler()] DBI error: 19: NOT
>> > NULL constraint failed: splits.memo
>> > * 17:59:26 ERROR 
>> > [GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
>> > INSERT INTO
>> > splits(guid,tx_guid,account_guid,memo,action,reconcile_state,reconcile_date,value_num,value_denom,quantity_num,quantity_denom)
>> >   > VALUES('[xxx]','[xxy]','[xxz]',NULL,'','c','2021-01-24
>> > 17:57:12',46353,100,46353,100)
>> > * 17:59:26 ERROR 
>> > [GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
>> > splits(guid,tx_guid,account_guid,memo,action,reconcile_state,reconcile_date,value_num,value_denom,quantity_num,quantity_denom)
>> >   > VALUES('[xxx]','[xxy]','[xxz]',NULL,'','c','2021-01-24
>> > 17:57:12',46353,100,46353,100)
>> >
>> > I am not sure how to look for transactions via the guid_tx, but I
>> > searched for 463.53.  I was then shown a split transaction view of a
>> > transaction that was put into the imbalance account.  The description
>> > was “NULL” where the rectangle is in the attached.  Some of my other
>> > imbalance entries had this entry, some did not.  So I removed them all
>> > and now it writes.
>> >
>> > I don't believe I put these “NULL”s in, I think gnucash did it so might
>> > be something to look into.
>> >
>> > Not sure if you saw my other question – can import securities (not the
>> > security transactions) or can I only add them via the GU

Re: [GNC] How do you do this - differentiate scheduled transaction versus no scheduled one

[Peter West]

FWIW, when I receive a bill to be paid at some future date, I put the amount in 
as a liability against the appropriate expense account. I then schedule the 
payment for that future date, both at my bank and in the scheduled payments 
editor. In that case, the entry is from my cash account against the the 
liability account. IANAA.

Peter
—
Peter West
p...@ehealth.id.au
“This generation is an evil generation.”

> On 15 Oct 2021, at 12:19 am, Kalpesh Patel  wrote:
> 
> A workflow questions for GNC users:
> 
> 
> 
> 1 - My habits when it comes to payments for example credit card, mortgage,
> other bills, etc. is to scheduled it out in advance from the appropriate
> institutions that hold my bank accounts, such as checking, savings, etc. at
> a future date but within due date. In the sub-account register for the bank
> account, I like to some-how want to be able to differentiate that I have
> already scheduled up a transaction versus other transaction that is needed
> to be scheduled out. What I was hoping would be that is in the reconcile
> column there would be able to put user defined character, rather than just
> limited to 'y', 'c' and 'n' so that I can actually sort out and see what is
> actually scheduled out and what is not in that account. It seems that this
> is not possible so what would be the best way to differentiate between two
> in the register? I do use scheduling to auto enter certain transactions but
> I still verify with the bank that transaction is actually scheduled and want
> to mark that it has been confirmed as such.
> 
> 
> 
> 2 - How should I be handling a transactions where for example my credit card
> credits my payment today but bank doesn't show the corresponding withdrawal
> transaction until 3 days later when the funds are actually withdrawn from
> the account. Currently one transaction will accept only one date for both
> side of the transactions but during import and reconcile time if I update +
> reconcile then the timestamp changes to whoever's transactions are
> reconciled last from the two accounts. This is somewhat super annoying
> because it re-arranges things in register so when you try to find an
> erroneous transaction of small amount, you cannot compare against the
> running ledger from the institution's on-line portal against entries in the
> register or the running total in the register entailing lots of manual
> back-and-forth in the register and possibly updating reconciled
> transactions.
> 
> 
> 
> 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.

___
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] Making the leap to latest

[Peter West]

I would disagree with “don’t upgrade unless entirely necessary." Open source 
software (OSS) requires a different approach. Proprietary software offers 
guarantees of the support lifetime of the software you purchase, paid for by 
your money. The resources for development and support are very limited and 
voluntary. The benefits of OSS come with some implied responsibilities.

Keep your software up-to-date.
Keep the installer for you current version of the software. When the 
next version is released, secure the backup of your date and install the new 
software. If something goes wrong, re-install the working version, restore your 
date, and report your problem. We recently had two successive install 
difficulties, for example. You don’t need to keep the dud installers, obviously.

Keep an eye on the mailing list, and offer your suggestions to other users if 
yo think you know how to fix their problems.

Peter
—
Peter West
p...@ehealth.id.au
“The one who hears you hears me, and the one who rejects you rejects me, and 
the one who rejects me rejects him who sent me.”


> On 3 Oct 2021, at 8:11 am, AC  wrote:
> 
> I agree don't upgrade if not absolutely necessary but I will likely be
> replacing this computer in a few months so starting from a newer
> installation is much more likely to happen in that case.
> 
> So you're saying I should be able to do three stages of 2.6.last,
> 3.x.last and then 4.x.last?
> 
> Are there any big changes to basic functionality from 2.6 to 4.x?  I'm
> making my way through the change logs but a lot of it is related to
> various features I don't use (at least that which I've read thus far).
> 
> 
> On 2021-10-02 15:06, Derek Atkins wrote:
>>> From 2.6.3 you will need to jump to 2.6.last, then 3.x, then 4.x
>> 
>> At every version you should load your data file and then save it.
>> 
>> While there is no requirement to upgrade, and "if it ain't broke, don't
>> fix it" may apply, if you have a system crash and need to rebuild your
>> system, it'll be easier to use recent versions.
>> 
>> -derek
>> Sent using my mobile device. Please excuse any typos.
>> On October 2, 2021 5:56:23 PM AC  wrote:
>> 
>>> Ok, I've been running along on 2.6.3 on Win 10.  No issues to date that
>>> I can see.
>>> 
>>> I know there's been various changes throughout the rest of the 2.x and
>>> 3.x series and we're now on 4.x which sparks some questions:
>>> 
>>> 
>>> Do I really need to update?  I only use the basis ledgers for standard
>>> banking accounts, credit cards, loans, mutual funds; scheduled
>>> transactions; and basic reports (typically just the standard transaction
>>> report when I need a list for taxes). I don't use online transactions,
>>> imports, or business features.  Can I assume that the basics still work
>>> the same way?
>>> 
>>> If it's better for me to go ahead and update how painful will it be to
>>> update?
>>> 
>>> I recall some suggestions previously about upgrading in increments and
>>> if that's the case how many increments am I going to need (hopefully not
>>> one for every point version)?
>>> 
>>> ___
>>> 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] ANNOUNCE: GnuCash 4.7 Released

[Peter West]

You need 4.7-2, I think.


> On 27 Sep 2021, at 9:05 am, Larry Fahnoe via gnucash-user 
>  wrote:
> 
> Hello,
> 
> Just downloaded Gnucash-Intel-4.7-1.dmg from GitHub but found that it 
> contains 4.6-1 from June 26
> 
> --Larry
> 
> Larry Fahnoe, Fahnoe Technology Consulting, fah...@fahnoetech.com 
> 
>Minneapolis, Minnesota   www.FahnoeTech.com 
> 
> 
> ‐‐‐ Original Message ‐‐‐
> 
> On Sunday, September 26th, 2021 at 2:35 PM, John Ralls  > wrote:
> 
>> The GnuCash development team announces GnuCash 4.7, the eighth release in 
>> the stable 4.x series
>> 
>> Compatibility Notice
>> 
>> In order to allow flatpak users to share preferences with installations 
>> outside of the sandbox we need to change the preference path from 
>> /org/gnucash to /org/gnucash/GnuCash. This release of GnuCash does that and 
>> it will automatically migrate existing preferences. It does not, however, 
>> continue to write preferences to the old path and it runs the migration only 
>> once. If you go back and forth between GnuCash 4.7 and an older versions 
>> you'll have two sets of preferences, one for GnuCash 4.7 and later and 
>> another for GnuCash 4.6 and earlier. This includes the file history list and 
>> last-opened file.
>> 
>> Between 4.6 and 4.7, the following bugfixes were accomplished:
>> 
>> Bug 87847 - RFE: Create a 'checkbox' cell type
>> 
>> Bug 766052 - Job report payments wrong when payment contains splits
>> 
>> Bug 797596 - New-owner - improved representation of payments with multiple 
>> non-APAR splits
>> 
>> Bug 798142 - Tax rate appears as a fraction
>> 
>> Bug 798180 - Update to macOS Big Sur 11.3 breaks Finance Quote
>> 
>> Bug 798205 - Some transactions dropped with no apparent cause or warnings 
>> for credit card ofx import
>> 
>> Do not exclude from import a transaction that has an FITID which matches an 
>> already existing split. This is because it (1) may be a coincidence and 
>> therefore the transaction needs to be added or (2) could be on a transfer 
>> from the account being imported to another bank account which has already 
>> been imported, and so needs to be matched, not added.
>> 
>> Bug 798208 - management fee transactions are ignored on OFX import
>> 
>> Bug 798211 - Equity statement double calculates unrealized gain
>> 
>> Bug 798219 - apply/OK truncates exchange rates from 4 to 2 decimal places; 
>> enter doesn't
>> 
>> Bug 798221 - Transfer funds between accounts with different currencies 
>> crashes Gnucash on macOS
>> 
>> Bug 798224 - Scheduled transactions are created with date-entered copied 
>> from the template transaction.
>> 
>> Bug 798229 - GncDate::c_formats is being created and destroyed twice 
>> resulting in a double free crash on every exit.
>> 
>> Bug 798234 - Cut Transaction discards the reference to the description/memo 
>> strings so that Paste Transaction will paste uninitialised data (or other 
>> strings)
>> 
>> Bug 798235 - Reconciliation Ending Balance not recalculated the 2nd and 
>> subsequent times Statement Date is updated.
>> 
>> Bug 798237 - Logging during XML file loading degrades performance 
>> significantly
>> 
>> Bug 798238 - "New security" dialog doesn't save the "Display symbol"
>> 
>> Bug 798250 - Gnucash permanent hang on save while loading report
>> 
>> Bug 798256 - Crash in recnFinishCB
>> 
>> Bug 798298 - Re-imported transactions no longer ignored
>> 
>> Bug 798303 - account list is sorted wrong by amount
>> 
>> Bug 798312 - Opening the help for dialogues in the wrong language.
>> 
>> The following fixes and improvements were not associated with bug reports:
>> 
>> Lots of memory-leaks plugged
>> 
>> Change the preferences path to org.gnucash.GnuCash to comply with flatpak 
>> requirements and migrate existing preferences to the new paths. This won't 
>> provide for automatic sync between a system-installed GnuCash and a flatpak 
>> one unless the system-installed one is GnuCash 4.7 or later. Please see the 
>> Wiki for more information and a procedure to convert your existing 
>> preferences.
>> 
>> Cleanup - minimal glib=2.56.1 - drop all conditionals on older versions
>> 
>> Add code to handle ofx files that include transfers between accounts
>> 
>> During transaction import, ignore splits whose account is not the 
>> destination account
>> 
>> Do not drop a potential match just because it has an online_id.
>> 
>> Now that we don't exclude from import a transaction with an FITID that 
>> matches an already existing transaction, if one accidentally re-imports a 
>> transaction, this allows it to be automatically matched against the 
>> previously imported transaction.
>> 
>> Add test for Transaction GetDate() in python bindings, pursuant to Bug 
>> 798284.
>> 
>> In find customer dialog, add a column for "Shipping Contact" parameter
>> 
>> Prep early splash screen messages for translation
>> 
>> Change text for SX preference 

[GNC] Paying expenses with cryptocurrency

[Peter West]

The recommended mode of dealing with crypto seems to be to record your crypto 
as a stock, and handle fluctuation in prices as you would for a stock. When you 
are investing crypto that makes sense. But what if you are using crypto for 
purchases? That is, if you are using cryptocurrency for the originally intended 
purpose?

Any ideas on how to record this?


—
Peter West
p...@ehealth.id.au
“For you are like whitewashed tombs, which outwardly appear beautiful, but 
within are full of dead people's bones and all uncleanness.”

___
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] Finance::Quote on Mac M1

[Peter West]

I try to ensure that my Finder-initiated processes share the same environment 
as my shell processes by loading envvars with launchctl setenv with every 
invocation of my .profile. In order to fully test that, I need to create an app 
that just reports its environment. I haven’t done that.

Incidentally, it would be useful if there were an option in GnuCash to report 
the environment.

Peter
—
Peter West
p...@ehealth.id.au
“On these two commandments depend all the Law and the Prophets.”

> On 22 Aug 2021, at 10:40 am, Peter West  wrote:
> 
> It also works with my MacPorts perl promoted above the system perl.
> 
> Maybe just not finding gnc-fq-check, if that was the case, was enough to 
> generate that message.
> 
> Peter
> —
> Peter West
> p...@ehealth.id.au
> “On these two commandments depend all the Law and the Prophets.”
> 
>> On 21 Aug 2021, at 2:30 am, Peter West  wrote:
>> 
>> It’s working, using the system perl.
>> 
>> When I started to tinker, I copies the gnc-* binaries from 
>> Contents/Resources/bin to my local directory, so that I could run them 
>> without having to delve into GnuCash.app. I renamed that bin to bin~, and 
>> forgot about it. Your mention of 
>> /Applications/Gnucash.app/Contents/Resources/bin sent me to have a look in 
>> there.
>> 
>> I’ll experiment with the MacPorts perl (currently 5.34, whereas system perl 
>> is 5.30) and let you know. Thanks for your patience, which I hope you still 
>> have.
>> 
>> Peter
>> 
>> —
>> Peter West
>> p...@ehealth.id.au <mailto:p...@ehealth.id.au>
>> “On these two commandments depend all the Law and the Prophets.”
>> 
>>> On 21 Aug 2021, at 1:54 am, John Ralls >> <mailto:jra...@ceridwen.us>> wrote:
>>> 
>>> That's what "Perl from other sources may or may not work and will 
>>> regardless require modifying 
>>> Gnucash.app/Contents/Resources/etc/gnucash/environment to set the perl path 
>>> and @INC so that GnuCash can find the right F::Q. If you insist on that 
>>> you're on your own." is about.
>>> 
>>> The issue is that when you launch from Finder there's no shell so GnuCash 
>>> can't see your MacPorts environment changes. Try launching GnuCash from a 
>>> shell window that does have the MacPorts environment.
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>>> On Aug 20, 2021, at 3:55 AM, Peter West >>> <mailto:p...@pbw.id.au>> wrote:
>>>> 
>>>> Doesn’t work for me.
>>>> 
>>>> Note: I’m assuming that the message Finance::Quote not installed properly, 
>>>> when Add is invoked in the security editor, means that it’s not installed 
>>>> properly.
>>>> 
>>>> I depend a lot on MacPorts. I’ve tried forcing the installation with 
>>>> MacPorts perl 5.34 foremost in my path, and with it (and all other perl 
>>>> binaries) relegated in my path. It makes no difference to the appearance 
>>>> of that message.
>>>> 
>>>> In each case I have checked the installation paths of perl. In the first 
>>>> the installation paths are in /opt/local, in the latter they are in /usr, 
>>>> /Library, /System, /Network and /usr/local.
>>>> 
>>>> Peter
>>>> —
>>>> Peter West
>>>> p...@ehealth.id.au <mailto:p...@ehealth.id.au>
>>>> “On these two commandments depend all the Law and the Prophets.”
>>>> 
>>>>> On 20 Aug 2021, at 2:21 pm, Colin  wrote:
>>>>> 
>>>>> Thank you John! I ran the commands you provided and Finance::Quote works 
>>>>> for the first time since I got my M1 MacBook Air! I’ve been watching the 
>>>>> Finance::Quote threads on the list the last few months, always hoping for 
>>>>> a solution I could manage to I implement to fix the issue. No doubt I 
>>>>> could have missed this if it was posted before, regardless you just made 
>>>>> my day.
>>>>> 
>>>>> For what it’s worth, my install of GnuCash was done the standard way - 
>>>>> downloading the DMG from the website. 
>>>>> 
>>>>> Also, to make the solution crystal clear to those who are not as good on 
>>>>> the command line, there was a typo in John’s most recent advice of the 
>>>>> commands to run. It is B::Keywords (capital K):
>>>>> 
>>>>> sudo cpan -i Test2; sudo cpan -f -i B::Keywords; sudo cpan -i 
>>>>

Re: [GNC] Finance::Quote on Mac M1

[Peter West]

It also works with my MacPorts perl promoted above the system perl.

Maybe just not finding gnc-fq-check, if that was the case, was enough to 
generate that message.

Peter
—
Peter West
p...@ehealth.id.au
“On these two commandments depend all the Law and the Prophets.”

> On 21 Aug 2021, at 2:30 am, Peter West  wrote:
> 
> It’s working, using the system perl.
> 
> When I started to tinker, I copies the gnc-* binaries from 
> Contents/Resources/bin to my local directory, so that I could run them 
> without having to delve into GnuCash.app. I renamed that bin to bin~, and 
> forgot about it. Your mention of 
> /Applications/Gnucash.app/Contents/Resources/bin sent me to have a look in 
> there.
> 
> I’ll experiment with the MacPorts perl (currently 5.34, whereas system perl 
> is 5.30) and let you know. Thanks for your patience, which I hope you still 
> have.
> 
> Peter
> 
> —
> Peter West
> p...@ehealth.id.au <mailto:p...@ehealth.id.au>
> “On these two commandments depend all the Law and the Prophets.”
> 
>> On 21 Aug 2021, at 1:54 am, John Ralls > <mailto:jra...@ceridwen.us>> wrote:
>> 
>> That's what "Perl from other sources may or may not work and will regardless 
>> require modifying Gnucash.app/Contents/Resources/etc/gnucash/environment to 
>> set the perl path and @INC so that GnuCash can find the right F::Q. If you 
>> insist on that you're on your own." is about.
>> 
>> The issue is that when you launch from Finder there's no shell so GnuCash 
>> can't see your MacPorts environment changes. Try launching GnuCash from a 
>> shell window that does have the MacPorts environment.
>> 
>> Regards,
>> John Ralls
>> 
>>> On Aug 20, 2021, at 3:55 AM, Peter West >> <mailto:p...@pbw.id.au>> wrote:
>>> 
>>> Doesn’t work for me.
>>> 
>>> Note: I’m assuming that the message Finance::Quote not installed properly, 
>>> when Add is invoked in the security editor, means that it’s not installed 
>>> properly.
>>> 
>>> I depend a lot on MacPorts. I’ve tried forcing the installation with 
>>> MacPorts perl 5.34 foremost in my path, and with it (and all other perl 
>>> binaries) relegated in my path. It makes no difference to the appearance of 
>>> that message.
>>> 
>>> In each case I have checked the installation paths of perl. In the first 
>>> the installation paths are in /opt/local, in the latter they are in /usr, 
>>> /Library, /System, /Network and /usr/local.
>>> 
>>> Peter
>>> —
>>> Peter West
>>> p...@ehealth.id.au <mailto:p...@ehealth.id.au>
>>> “On these two commandments depend all the Law and the Prophets.”
>>> 
>>>> On 20 Aug 2021, at 2:21 pm, Colin  wrote:
>>>> 
>>>> Thank you John! I ran the commands you provided and Finance::Quote works 
>>>> for the first time since I got my M1 MacBook Air! I’ve been watching the 
>>>> Finance::Quote threads on the list the last few months, always hoping for 
>>>> a solution I could manage to I implement to fix the issue. No doubt I 
>>>> could have missed this if it was posted before, regardless you just made 
>>>> my day.
>>>> 
>>>> For what it’s worth, my install of GnuCash was done the standard way - 
>>>> downloading the DMG from the website. 
>>>> 
>>>> Also, to make the solution crystal clear to those who are not as good on 
>>>> the command line, there was a typo in John’s most recent advice of the 
>>>> commands to run. It is B::Keywords (capital K):
>>>> 
>>>> sudo cpan -i Test2; sudo cpan -f -i B::Keywords; sudo cpan -i 
>>>> Finance::Quote
>>>> 
>>>> Very gratefully, 
>>>> Colin
>>>> 
>>>>> On Aug 19, 2021, at 8:36 PM, gnucash-user-requ...@gnucash.org wrote:
>>>>> 
>>>>> Message: 5
>>>>> Date: Thu, 19 Aug 2021 20:36:28 -0700
>>>>> From: John Ralls mailto:jra...@ceridwen.us>>
>>>>> To: davel...@mac.com <mailto:davel...@mac.com>
>>>>> Cc: Mailing List Gnucash >>>> <mailto:gnucash-user@gnucash.org>>
>>>>> Subject: Re: [GNC] Finance::Quote on Mac M1
>>>>> Message-ID: <4e108262-4136-47b2-ac7e-5ed553442...@ceridwen.us 
>>>>> <mailto:4e108262-4136-47b2-ac7e-5ed553442...@ceridwen.us>>
>>>>> Content-Type: text/plain; charset=utf-8
>>>>> 
>>>>> You didn't read my letter ver

Re: [GNC] Finance::Quote on Mac M1

[Peter West]

It’s working, using the system perl.

When I started to tinker, I copies the gnc-* binaries from 
Contents/Resources/bin to my local directory, so that I could run them without 
having to delve into GnuCash.app. I renamed that bin to bin~, and forgot about 
it. Your mention of /Applications/Gnucash.app/Contents/Resources/bin sent me to 
have a look in there.

I’ll experiment with the MacPorts perl (currently 5.34, whereas system perl is 
5.30) and let you know. Thanks for your patience, which I hope you still have.

Peter

—
Peter West
p...@ehealth.id.au
“On these two commandments depend all the Law and the Prophets.”

> On 21 Aug 2021, at 1:54 am, John Ralls  wrote:
> 
> That's what "Perl from other sources may or may not work and will regardless 
> require modifying Gnucash.app/Contents/Resources/etc/gnucash/environment to 
> set the perl path and @INC so that GnuCash can find the right F::Q. If you 
> insist on that you're on your own." is about.
> 
> The issue is that when you launch from Finder there's no shell so GnuCash 
> can't see your MacPorts environment changes. Try launching GnuCash from a 
> shell window that does have the MacPorts environment.
> 
> Regards,
> John Ralls
> 
>> On Aug 20, 2021, at 3:55 AM, Peter West  wrote:
>> 
>> Doesn’t work for me.
>> 
>> Note: I’m assuming that the message Finance::Quote not installed properly, 
>> when Add is invoked in the security editor, means that it’s not installed 
>> properly.
>> 
>> I depend a lot on MacPorts. I’ve tried forcing the installation with 
>> MacPorts perl 5.34 foremost in my path, and with it (and all other perl 
>> binaries) relegated in my path. It makes no difference to the appearance of 
>> that message.
>> 
>> In each case I have checked the installation paths of perl. In the first the 
>> installation paths are in /opt/local, in the latter they are in /usr, 
>> /Library, /System, /Network and /usr/local.
>> 
>> Peter
>> —
>> Peter West
>> p...@ehealth.id.au
>> “On these two commandments depend all the Law and the Prophets.”
>> 
>>> On 20 Aug 2021, at 2:21 pm, Colin  wrote:
>>> 
>>> Thank you John! I ran the commands you provided and Finance::Quote works 
>>> for the first time since I got my M1 MacBook Air! I’ve been watching the 
>>> Finance::Quote threads on the list the last few months, always hoping for a 
>>> solution I could manage to I implement to fix the issue. No doubt I could 
>>> have missed this if it was posted before, regardless you just made my day.
>>> 
>>> For what it’s worth, my install of GnuCash was done the standard way - 
>>> downloading the DMG from the website. 
>>> 
>>> Also, to make the solution crystal clear to those who are not as good on 
>>> the command line, there was a typo in John’s most recent advice of the 
>>> commands to run. It is B::Keywords (capital K):
>>> 
>>> sudo cpan -i Test2; sudo cpan -f -i B::Keywords; sudo cpan -i Finance::Quote
>>> 
>>> Very gratefully, 
>>> Colin
>>> 
>>>> On Aug 19, 2021, at 8:36 PM, gnucash-user-requ...@gnucash.org wrote:
>>>> 
>>>> Message: 5
>>>> Date: Thu, 19 Aug 2021 20:36:28 -0700
>>>> From: John Ralls mailto:jra...@ceridwen.us>>
>>>> To: davel...@mac.com <mailto:davel...@mac.com>
>>>> Cc: Mailing List Gnucash >>> <mailto:gnucash-user@gnucash.org>>
>>>> Subject: Re: [GNC] Finance::Quote on Mac M1
>>>> Message-ID: <4e108262-4136-47b2-ac7e-5ed553442...@ceridwen.us 
>>>> <mailto:4e108262-4136-47b2-ac7e-5ed553442...@ceridwen.us>>
>>>> Content-Type: text/plain;  charset=utf-8
>>>> 
>>>> You didn't read my letter very carefully: You should be able to get quotes 
>>>> now if you do `sudo cpan -i Test2; sudo cpan -f -i B::keywords; sudo cpan 
>>>> -i Finance::Quote`. The system perl is a universal binary and works in 
>>>> both native and Rosetta2 environments. Perl from other sources may or may 
>>>> not work and will regardless require modifying 
>>>> Gnucash.app/Contents/Resources/etc/gnucash/environment to set the perl 
>>>> path and @INC so that GnuCash can find the right F::Q. If you insist on 
>>>> that you're on your own.
>>>> 
>>>> As for a native M1 build, I haven't decided yet whether to do that before 
>>>> the next major nettle release. I really don't like pushing development 
>>>> software at ordinary users, it tends to make for unpleasant surprises. 
>

Re: [GNC] Finance::Quote on Mac M1

[Peter West]

Doesn’t work for me.

Note: I’m assuming that the message Finance::Quote not installed properly, when 
Add is invoked in the security editor, means that it’s not installed properly.

I depend a lot on MacPorts. I’ve tried forcing the installation with MacPorts 
perl 5.34 foremost in my path, and with it (and all other perl binaries) 
relegated in my path. It makes no difference to the appearance of that message.

In each case I have checked the installation paths of perl. In the first the 
installation paths are in /opt/local, in the latter they are in /usr, /Library, 
/System, /Network and /usr/local.

Peter
—
Peter West
p...@ehealth.id.au
“On these two commandments depend all the Law and the Prophets.”

> On 20 Aug 2021, at 2:21 pm, Colin  wrote:
> 
> Thank you John! I ran the commands you provided and Finance::Quote works for 
> the first time since I got my M1 MacBook Air! I’ve been watching the 
> Finance::Quote threads on the list the last few months, always hoping for a 
> solution I could manage to I implement to fix the issue. No doubt I could 
> have missed this if it was posted before, regardless you just made my day.
> 
> For what it’s worth, my install of GnuCash was done the standard way - 
> downloading the DMG from the website. 
> 
> Also, to make the solution crystal clear to those who are not as good on the 
> command line, there was a typo in John’s most recent advice of the commands 
> to run. It is B::Keywords (capital K):
> 
> sudo cpan -i Test2; sudo cpan -f -i B::Keywords; sudo cpan -i Finance::Quote
> 
> Very gratefully, 
> Colin
> 
>> On Aug 19, 2021, at 8:36 PM, gnucash-user-requ...@gnucash.org wrote:
>> 
>> Message: 5
>> Date: Thu, 19 Aug 2021 20:36:28 -0700
>> From: John Ralls mailto:jra...@ceridwen.us>>
>> To: davel...@mac.com <mailto:davel...@mac.com>
>> Cc: Mailing List Gnucash > <mailto:gnucash-user@gnucash.org>>
>> Subject: Re: [GNC] Finance::Quote on Mac M1
>> Message-ID: <4e108262-4136-47b2-ac7e-5ed553442...@ceridwen.us 
>> <mailto:4e108262-4136-47b2-ac7e-5ed553442...@ceridwen.us>>
>> Content-Type: text/plain;charset=utf-8
>> 
>> You didn't read my letter very carefully: You should be able to get quotes 
>> now if you do `sudo cpan -i Test2; sudo cpan -f -i B::keywords; sudo cpan -i 
>> Finance::Quote`. The system perl is a universal binary and works in both 
>> native and Rosetta2 environments. Perl from other sources may or may not 
>> work and will regardless require modifying 
>> Gnucash.app/Contents/Resources/etc/gnucash/environment to set the perl path 
>> and @INC so that GnuCash can find the right F::Q. If you insist on that 
>> you're on your own.
>> 
>> As for a native M1 build, I haven't decided yet whether to do that before 
>> the next major nettle release. I really don't like pushing development 
>> software at ordinary users, it tends to make for unpleasant surprises. 
>> Meanwhile GnuCash seems to work well under Rosetta2 so there's not a strong 
>> argument for doing a native build until nettle's ARM64 implementation is in 
>> a stable release.
>> 
>> 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] Finance::Quote on Mac M1

[Peter West]

Hi John,

I had already run into problems trying to build GnuCash on MacPorts. I was 
encouraged to try to build by reading 
<https://wiki.gnucash.org/wiki/MacOS/Quartz>.

Peter
—
Peter West
p...@ehealth.id.au
“For behold, when the sound of your greeting came to my ears, the baby in my 
womb leaped for joy.”

> On 17 Aug 2021, at 1:02 am, John Ralls  wrote:
> 
> 
> Support for gtk-osx is on its mailing list, 
> https://mail.gnome.org/mailman/listinfo/gtk-osx-users-list 
> <https://mail.gnome.org/mailman/listinfo/gtk-osx-users-list>, but before you 
> go there I'll remind you that one of gtk-osx's basic requirements is that you 
> must not have Homebrew or MacPorts visible to it.
> 
> Since you have MacPorts installed already the simplest way forward is to use 
> that to build GnuCash. 
> 
> That said there's no shared code between anything to do with GnuCash and perl 
> or any CPAN modules beyond the macOS SDK. Building GnuCash from source won't 
> help you get Finance::Quote going.
> 
> Regards,
> John Ralls
> 
>> On Aug 16, 2021, at 7:18 AM, Peter West > <mailto:p...@pbw.id.au>> wrote:
>> 
>> I removed the offending PREFIX line from jhbuildrc-custom, and immediately 
>> ran into a similar problem.
>> 
>> File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load
>>   execfile(filename, config)
>> File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in 
>> execfile
>>   exec(code, globals, locals)
>> File "/Users/gtkdev/.config/jhbuildrc", line 470, in 
>>   exec(compile(open(_user_rc, "rb").read(), _user_rc, 'exec'))
>> File "/Users/gtkdev/.config/jhbuildrc-custom", line 26, in 
>>   module_extra_env['icu'] = {'CXXFLAGS':os.environ['CXXFLAGS'] + ' 
>> -std=c++17'}
>> File 
>> "/opt/local/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/os.py",
>>  line 675, in __getitem__
>>   raise KeyError(key) from None
>> KeyError: 'CXXFLAGS'
>> jhbuild: could not load config file
>> 
>> In this one, there is obviously a default value, but the Error is 
>> propagating all the way up.
>> 
>> Peter
>> 
>> 
>> —
>> Peter West
>> p...@ehealth.id.au
>> “For behold, when the sound of your greeting came to my ears, the baby in my 
>> womb leaped for joy.”
>> 
>>> On 16 Aug 2021, at 8:21 pm, Peter West  wrote:
>>> 
>>> I’ve decided to go the whole hog and build GNC. Hopefully, I can get 
>>> M1-specific GNC and Finance::Quote working together without any mysterious 
>>> issues.
>>> 
>>> After gtk-osx-setup.sh, I try to run jhbuild bootstrap-gtk-osx, and it 
>>> fails immediately.
>>> 
>>> ~ 20:14:24$ jhbuild bootstrap-gtk-osx
>>> Loading .env environment variables...
>>> Traceback (most recent call last):
>>> File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load
>>>   execfile(filename, config)
>>> File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in 
>>> execfile
>>>   exec(code, globals, locals)
>>> File "/Users/gtkdev/.config/jhbuildrc", line 470, in 
>>>   exec(compile(open(_user_rc, "rb").read(), _user_rc, 'exec'))
>>> File "/Users/gtkdev/.config/jhbuildrc-custom", line 3, in 
>>>   prefix = os.environ['PREFIX']
>>> File 
>>> "/opt/local/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/os.py",
>>>  line 675, in __getitem__
>>>   raise KeyError(key) from None
>>> KeyError: 'PREFIX'
>>> jhbuild: could not load config file
>>> 
>>> 
>>> I'
>>> 
>>> The first thing in .config/jhbuildrc-custom is
>>> prefix = os.environ['PREFIX’]
>>> 
>>> So there is no envar PREFIX defined in my environment. That’s easy enough 
>>> to fix, but what is it supposed to be? Should this Error jusst be caught 
>>> and defaulted?
>>> 
>>> I don’t do python, so I don’t know how the error/exception process works.
>>> 
>>> Peter
>>> 
>>> —
>>> Peter West
>>> p...@ehealth.id.au <mailto:p...@ehealth.id.au> <mailto:p...@ehealth.id.au 
>>> <mailto:p...@ehealth.id.au>>
>>> “For behold, when the sound of your greeting came to my ears, the baby in 
>>> my womb leaped for joy.”
>>> 
>>>> On 4 Aug 2021, at 7:39 pm, Geoff >>> <mailto:cleanoutmys...@gmail.com> <mailto:cleanoutmy

Re: [GNC] Finance::Quote on Mac M1

[Peter West]

I removed the offending PREFIX line from jhbuildrc-custom, and immediately ran 
into a similar problem.

File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load
execfile(filename, config)
  File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in 
execfile
exec(code, globals, locals)
  File "/Users/gtkdev/.config/jhbuildrc", line 470, in 
exec(compile(open(_user_rc, "rb").read(), _user_rc, 'exec'))
  File "/Users/gtkdev/.config/jhbuildrc-custom", line 26, in 
module_extra_env['icu'] = {'CXXFLAGS':os.environ['CXXFLAGS'] + ' 
-std=c++17'}
  File 
"/opt/local/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/os.py",
 line 675, in __getitem__
raise KeyError(key) from None
KeyError: 'CXXFLAGS'
jhbuild: could not load config file

In this one, there is obviously a default value, but the Error is propagating 
all the way up.

Peter


—
Peter West
p...@ehealth.id.au
“For behold, when the sound of your greeting came to my ears, the baby in my 
womb leaped for joy.”

> On 16 Aug 2021, at 8:21 pm, Peter West  wrote:
> 
> I’ve decided to go the whole hog and build GNC. Hopefully, I can get 
> M1-specific GNC and Finance::Quote working together without any mysterious 
> issues.
> 
> After gtk-osx-setup.sh, I try to run jhbuild bootstrap-gtk-osx, and it fails 
> immediately.
> 
> ~ 20:14:24$ jhbuild bootstrap-gtk-osx
> Loading .env environment variables...
> Traceback (most recent call last):
>   File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load
> execfile(filename, config)
>   File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in 
> execfile
> exec(code, globals, locals)
>   File "/Users/gtkdev/.config/jhbuildrc", line 470, in 
> exec(compile(open(_user_rc, "rb").read(), _user_rc, 'exec'))
>   File "/Users/gtkdev/.config/jhbuildrc-custom", line 3, in 
> prefix = os.environ['PREFIX']
>   File 
> "/opt/local/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/os.py",
>  line 675, in __getitem__
> raise KeyError(key) from None
> KeyError: 'PREFIX'
> jhbuild: could not load config file
> 
> 
> I'
> 
> The first thing in .config/jhbuildrc-custom is
> prefix = os.environ['PREFIX’]
> 
> So there is no envar PREFIX defined in my environment. That’s easy enough to 
> fix, but what is it supposed to be? Should this Error jusst be caught and 
> defaulted?
> 
> I don’t do python, so I don’t know how the error/exception process works.
> 
> Peter
> 
> —
> Peter West
> p...@ehealth.id.au <mailto:p...@ehealth.id.au>
> “For behold, when the sound of your greeting came to my ears, the baby in my 
> womb leaped for joy.”
> 
>> On 4 Aug 2021, at 7:39 pm, Geoff > <mailto:cleanoutmys...@gmail.com>> wrote:
>> 
>> Yes, I don't like doing forced installations either, but this particular 
>> module isn't very important in the overall Finance::Quote scheme of events.
>> 
>> Here are two suggestions.
>> 
>> (1) Hack.  I'm not familiar with MAC directory structures, but I had a look 
>> at the particular test that is failing, and I reckon that if you create an 
>> empty file here it might just trick it into passing:
>> 
>> /System/Library/Perl/5.30/darwin-thread-multi-2level/CORE/keywords.h
>> 
>> 
>> (2) Manual install of B::Keywords without using CPAN:
>> (a) Download B-Keywords-1.22.tar.gz from here:
>> https://metacpan.org/pod/B::Keywords <https://metacpan.org/pod/B::Keywords>
>> 
>> (b) Unzip and untar it to a temp directory.
>> 
>> (c) From the command line in that directory:
>> perl Makefile.pl
>> gmake
>> gmake test
>> gmake install
>> 
>> [Excuse my MAC ignorance - hopefully you have gmake or an equivalent make 
>> command that will do the job.]
>> 
>> If either of those work, go back to CPAN and try to install Finance::Quote 
>> normally.
>> 
>> 
>> Good luck.
>> 
>> Geoff
>> =
>> 
>> On 4/08/2021 6:38 pm, Peter West wrote:
>>> It sill reports the same failure, even though I run
>>> sudo cpan -f -i B::Keywords
>>> —
>>> Peter West
>>> p...@ehealth.id.au <mailto:p...@ehealth.id.au>
>>> But immediately Jesus spoke to them, saying, “Take heart; it is I. Do not 
>>> be afraid.”
>>>> On 4 Aug 2021, at 5:53 pm, Geoff >>> <mailto:cleanoutmys...@gmail.com>> wrote:
>>>> 
>>>> Try and force the installation of B::Keywords:
>>>> 
>>>> cpa

Re: [GNC] Finance::Quote on Mac M1

[Peter West]

I’ve decided to go the whole hog and build GNC. Hopefully, I can get 
M1-specific GNC and Finance::Quote working together without any mysterious 
issues.

After gtk-osx-setup.sh, I try to run jhbuild bootstrap-gtk-osx, and it fails 
immediately.

~ 20:14:24$ jhbuild bootstrap-gtk-osx
Loading .env environment variables...
Traceback (most recent call last):
  File "/Users/gtkdev/Source/jhbuild/jhbuild/config.py", line 194, in load
execfile(filename, config)
  File "/Users/gtkdev/Source/jhbuild/jhbuild/utils/compat.py", line 67, in 
execfile
exec(code, globals, locals)
  File "/Users/gtkdev/.config/jhbuildrc", line 470, in 
exec(compile(open(_user_rc, "rb").read(), _user_rc, 'exec'))
  File "/Users/gtkdev/.config/jhbuildrc-custom", line 3, in 
prefix = os.environ['PREFIX']
  File 
"/opt/local/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/os.py",
 line 675, in __getitem__
raise KeyError(key) from None
KeyError: 'PREFIX'
jhbuild: could not load config file


I'

The first thing in .config/jhbuildrc-custom is
prefix = os.environ['PREFIX’]

So there is no envar PREFIX defined in my environment. That’s easy enough to 
fix, but what is it supposed to be? Should this Error jusst be caught and 
defaulted?

I don’t do python, so I don’t know how the error/exception process works.

Peter

—
Peter West
p...@ehealth.id.au
“For behold, when the sound of your greeting came to my ears, the baby in my 
womb leaped for joy.”

> On 4 Aug 2021, at 7:39 pm, Geoff  wrote:
> 
> Yes, I don't like doing forced installations either, but this particular 
> module isn't very important in the overall Finance::Quote scheme of events.
> 
> Here are two suggestions.
> 
> (1) Hack.  I'm not familiar with MAC directory structures, but I had a look 
> at the particular test that is failing, and I reckon that if you create an 
> empty file here it might just trick it into passing:
> 
> /System/Library/Perl/5.30/darwin-thread-multi-2level/CORE/keywords.h
> 
> 
> (2) Manual install of B::Keywords without using CPAN:
> (a) Download B-Keywords-1.22.tar.gz from here:
> https://metacpan.org/pod/B::Keywords
> 
> (b) Unzip and untar it to a temp directory.
> 
> (c) From the command line in that directory:
> perl Makefile.pl
> gmake
> gmake test
> gmake install
> 
> [Excuse my MAC ignorance - hopefully you have gmake or an equivalent make 
> command that will do the job.]
> 
> If either of those work, go back to CPAN and try to install Finance::Quote 
> normally.
> 
> 
> Good luck.
> 
> Geoff
> =
> 
> On 4/08/2021 6:38 pm, Peter West wrote:
>> It sill reports the same failure, even though I run
>> sudo cpan -f -i B::Keywords
>> —
>> Peter West
>> p...@ehealth.id.au <mailto:p...@ehealth.id.au>
>> But immediately Jesus spoke to them, saying, “Take heart; it is I. Do not be 
>> afraid.”
>>> On 4 Aug 2021, at 5:53 pm, Geoff >> <mailto:cleanoutmys...@gmail.com>> wrote:
>>> 
>>> Try and force the installation of B::Keywords:
>>> 
>>> cpan> force install B::Keywords
>>> 
>>> From: https://www.thegeekstuff.com/2013/06/cpan-force-install-perl-module/ 
>>> <https://www.thegeekstuff.com/2013/06/cpan-force-install-perl-module/>
>>> 
>>> If that works, try to reinstall Finance::Quote normally.
>>> 
>>> Fingers crossed.
>>> 
>>> Geoff
>>> =
>>> 
>>> On 4/08/2021 5:24 pm, Peter West wrote:
>>>> Here’s the output.
>>>> Rosie:.30/darwin-thread-multi-2level 16:53:50$ sudo cpan -i Finance::Quote
>>>> Password:
>>>> Loading internal logger. Log::Log4perl recommended for better logging
>>>> CPAN::SQLite not installed, trying to work without
>>>> Reading '/Users/pbw/.cpan/sources/authors/01mailrc.txt.gz'
>>>> DONE
>>>> Reading '/Users/pbw/.cpan/sources/modules/02packages.details.txt.gz'
>>>>   Database was generated on Wed, 04 Aug 2021 04:17:03 GMT
>>>> .
>>>>   New CPAN.pm version (v2.28) available.
>>>>   [Currently running version is v2.22]
>>>>   You might want to try
>>>> install CPAN
>>>> reload cpan
>>>>   to both upgrade CPAN.pm and run the new version without leaving
>>>>   the current session.
>>>> ...DONE
>>>> Reading '/Users/pbw/.cpan/sources/modules/03modlist.data.gz'
>>>> DONE
>>>> Running install for module 'Fi

Re: [GNC] M1 MacBook Pro

[Peter West]

Yes. Only Big Sur is available on the M1, as far as I know.


—
Peter West
p...@ehealth.id.au
“I do not say to you seven times, but seventy-seven times.”

> On 12 Aug 2021, at 11:58 pm, alanmagnus  wrote:
> 
> Thanks Peter. One more thing, are you using it on Big Sur?
> 
>> On 12 Aug 2021, at 09:55, Peter West  wrote:
>> 
>> It works on the M1 MacBook Air. I’m using it.
>> 
>> Peter
>> —
>> Peter West
>> p...@ehealth.id.au <mailto:p...@ehealth.id.au>
>> “I do not say to you seven times, but seventy-seven times.”
>> 
>>> On 12 Aug 2021, at 11:46 pm, alanmagnus >> <mailto:alanmag...@flowja.com>> wrote:
>>> 
>>> Does the latest release of Gnucash work on the new M1 MacBook Pro?
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org <mailto: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] M1 MacBook Pro

[Peter West]

It works on the M1 MacBook Air. I’m using it.

Peter
—
Peter West
p...@ehealth.id.au
“I do not say to you seven times, but seventy-seven times.”

> On 12 Aug 2021, at 11:46 pm, alanmagnus  wrote:
> 
> Does the latest release of Gnucash work on the new M1 MacBook Pro?
> ___
> 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] Finance::Quote on Mac M1

[Peter West]

It sill reports the same failure, even though I run
sudo cpan -f -i B::Keywords


—
Peter West
p...@ehealth.id.au
But immediately Jesus spoke to them, saying, “Take heart; it is I. Do not be 
afraid.”

> On 4 Aug 2021, at 5:53 pm, Geoff  wrote:
> 
> Try and force the installation of B::Keywords:
> 
> cpan> force install B::Keywords
> 
> From: https://www.thegeekstuff.com/2013/06/cpan-force-install-perl-module/
> 
> If that works, try to reinstall Finance::Quote normally.
> 
> Fingers crossed.
> 
> Geoff
> =
> 
> On 4/08/2021 5:24 pm, Peter West wrote:
>> Here’s the output.
>> Rosie:.30/darwin-thread-multi-2level 16:53:50$ sudo cpan -i Finance::Quote
>> Password:
>> Loading internal logger. Log::Log4perl recommended for better logging
>> CPAN::SQLite not installed, trying to work without
>> Reading '/Users/pbw/.cpan/sources/authors/01mailrc.txt.gz'
>> DONE
>> Reading '/Users/pbw/.cpan/sources/modules/02packages.details.txt.gz'
>>   Database was generated on Wed, 04 Aug 2021 04:17:03 GMT
>> .
>>   New CPAN.pm version (v2.28) available.
>>   [Currently running version is v2.22]
>>   You might want to try
>> install CPAN
>> reload cpan
>>   to both upgrade CPAN.pm and run the new version without leaving
>>   the current session.
>> ...DONE
>> Reading '/Users/pbw/.cpan/sources/modules/03modlist.data.gz'
>> DONE
>> Running install for module 'Finance::Quote'
>>   CPAN: Module::Signature security checks disabled because Module::Signature
>>   not installed.  Please consider installing the Module::Signature module.
>>   You may also need to be able to connect over the Internet to the public
>>   key servers like pool.sks-keyservers.net or pgp.mit.edu.
>> Checksum for 
>> /Users/pbw/.cpan/sources/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.51.tar.gz 
>> ok
>> Configuring B/BP/BPSCHUCK/Finance-Quote-1.51.tar.gz with Makefile.PL
>> CPAN::Reporter not installed.  No reports will be sent.
>> Checking if your kit is complete...
>> Looks good
>> Warning: prerequisite Test::Perl::Critic 0 not found.
>> Generating a Unix-style Makefile
>> Writing Makefile for Finance::Quote
>> Writing MYMETA.yml and MYMETA.json
>>   BPSCHUCK/Finance-Quote-1.51.tar.gz
>>   /usr/bin/perl Makefile.PL -- OK
>> Running make for B/BP/BPSCHUCK/Finance-Quote-1.51.tar.gz
>>  Unsatisfied dependencies detected during 
>> BPSCHUCK/Finance-Quote-1.51.tar.gz
>> Test::Perl::Critic [build_requires]
>> Running install for module 'Test::Perl::Critic'
>> Checksum for 
>> /Users/pbw/.cpan/sources/authors/id/P/PE/PETDANCE/Test-Perl-Critic-1.04.tar.gz
>>  ok
>> Configuring P/PE/PETDANCE/Test-Perl-Critic-1.04.tar.gz with Build.PL
>> Checking prerequisites...
>>   requires:
>> !  Perl::Critic is not installed
>> !  Perl::Critic::Utils is not installed
>> !  Perl::Critic::Violation is not installed
>> ERRORS/WARNINGS FOUND IN PREREQUISITES.  You may wish to install the versions
>> of the modules indicated above before proceeding with this installation
>> Created MYMETA.yml and MYMETA.json
>> Creating new 'Build' script for 'Test-Perl-Critic' version '1.04'
>>   PETDANCE/Test-Perl-Critic-1.04.tar.gz
>>   /usr/bin/perl Build.PL -- OK
>> Running Build for P/PE/PETDANCE/Test-Perl-Critic-1.04.tar.gz
>>  Unsatisfied dependencies detected during 
>>    PETDANCE/Test-Perl-Critic-1.04.tar.gz  
>> Perl::Critic [requires]
>> Perl::Critic::Utils [requires]
>> Perl::Critic::Violation [requires]
>> Running install for module 'Perl::Critic'
>> Checksum for 
>> /Users/pbw/.cpan/sources/authors/id/P/PE/PETDANCE/Perl-Critic-1.140.tar.gz ok
>> Configuring P/PE/PETDANCE/Perl-Critic-1.140.tar.gz with Build.PL
>> Checking prerequisites...
>>   requires:
>> !  B::Keywords is not installed
>> ERRORS/WARNINGS FOUND IN PREREQUISITES.  You may wish to install the versions
>> of the modules indicated above before proceeding with this installation
>> Created MYMETA.yml and MYMETA.json
>> Creating new 'Build' script for 'Perl-Critic' version '1.140'
>>   PETDANCE/Perl-Critic-1.140.tar.gz
>>   /usr/bin/perl Build.PL -- OK
>> Running Build for P/PE/PETDANCE/Perl-Critic-1.140.tar.gz
>>  Unsatisfied dependencies detected during 
>>  PETDANCE/Perl-Critic-1.140.tar.gz
>> B::Keywords [requires]
>> Running instal

Re: [GNC] Finance::Quote on Mac M1

[Peter West]

I thought about that, even though it’s against my religion.

I’ll let you know what happens.


—
Peter West
p...@ehealth.id.au
But immediately Jesus spoke to them, saying, “Take heart; it is I. Do not be 
afraid.”

> On 4 Aug 2021, at 5:53 pm, Geoff  wrote:
> 
> Try and force the installation of B::Keywords:
> 
> cpan> force install B::Keywords
> 
> From: https://www.thegeekstuff.com/2013/06/cpan-force-install-perl-module/
> 
> If that works, try to reinstall Finance::Quote normally.
> 
> Fingers crossed.
> 
> Geoff
> =
> 
> On 4/08/2021 5:24 pm, Peter West wrote:
>> Here’s the output.
>> Rosie:.30/darwin-thread-multi-2level 16:53:50$ sudo cpan -i Finance::Quote
>> Password:
>> Loading internal logger. Log::Log4perl recommended for better logging
>> CPAN::SQLite not installed, trying to work without
>> Reading '/Users/pbw/.cpan/sources/authors/01mailrc.txt.gz'
>> DONE
>> Reading '/Users/pbw/.cpan/sources/modules/02packages.details.txt.gz'
>>   Database was generated on Wed, 04 Aug 2021 04:17:03 GMT
>> .
>>   New CPAN.pm version (v2.28) available.
>>   [Currently running version is v2.22]
>>   You might want to try
>> install CPAN
>> reload cpan
>>   to both upgrade CPAN.pm and run the new version without leaving
>>   the current session.
>> ...DONE
>> Reading '/Users/pbw/.cpan/sources/modules/03modlist.data.gz'
>> DONE
>> Running install for module 'Finance::Quote'
>>   CPAN: Module::Signature security checks disabled because Module::Signature
>>   not installed.  Please consider installing the Module::Signature module.
>>   You may also need to be able to connect over the Internet to the public
>>   key servers like pool.sks-keyservers.net or pgp.mit.edu.
>> Checksum for 
>> /Users/pbw/.cpan/sources/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.51.tar.gz 
>> ok
>> Configuring B/BP/BPSCHUCK/Finance-Quote-1.51.tar.gz with Makefile.PL
>> CPAN::Reporter not installed.  No reports will be sent.
>> Checking if your kit is complete...
>> Looks good
>> Warning: prerequisite Test::Perl::Critic 0 not found.
>> Generating a Unix-style Makefile
>> Writing Makefile for Finance::Quote
>> Writing MYMETA.yml and MYMETA.json
>>   BPSCHUCK/Finance-Quote-1.51.tar.gz
>>   /usr/bin/perl Makefile.PL -- OK
>> Running make for B/BP/BPSCHUCK/Finance-Quote-1.51.tar.gz
>>  Unsatisfied dependencies detected during 
>> BPSCHUCK/Finance-Quote-1.51.tar.gz
>> Test::Perl::Critic [build_requires]
>> Running install for module 'Test::Perl::Critic'
>> Checksum for 
>> /Users/pbw/.cpan/sources/authors/id/P/PE/PETDANCE/Test-Perl-Critic-1.04.tar.gz
>>  ok
>> Configuring P/PE/PETDANCE/Test-Perl-Critic-1.04.tar.gz with Build.PL
>> Checking prerequisites...
>>   requires:
>> !  Perl::Critic is not installed
>> !  Perl::Critic::Utils is not installed
>> !  Perl::Critic::Violation is not installed
>> ERRORS/WARNINGS FOUND IN PREREQUISITES.  You may wish to install the versions
>> of the modules indicated above before proceeding with this installation
>> Created MYMETA.yml and MYMETA.json
>> Creating new 'Build' script for 'Test-Perl-Critic' version '1.04'
>>   PETDANCE/Test-Perl-Critic-1.04.tar.gz
>>   /usr/bin/perl Build.PL -- OK
>> Running Build for P/PE/PETDANCE/Test-Perl-Critic-1.04.tar.gz
>>  Unsatisfied dependencies detected during 
>>    PETDANCE/Test-Perl-Critic-1.04.tar.gz  
>> Perl::Critic [requires]
>> Perl::Critic::Utils [requires]
>> Perl::Critic::Violation [requires]
>> Running install for module 'Perl::Critic'
>> Checksum for 
>> /Users/pbw/.cpan/sources/authors/id/P/PE/PETDANCE/Perl-Critic-1.140.tar.gz ok
>> Configuring P/PE/PETDANCE/Perl-Critic-1.140.tar.gz with Build.PL
>> Checking prerequisites...
>>   requires:
>> !  B::Keywords is not installed
>> ERRORS/WARNINGS FOUND IN PREREQUISITES.  You may wish to install the versions
>> of the modules indicated above before proceeding with this installation
>> Created MYMETA.yml and MYMETA.json
>> Creating new 'Build' script for 'Perl-Critic' version '1.140'
>>   PETDANCE/Perl-Critic-1.140.tar.gz
>>   /usr/bin/perl Build.PL -- OK
>> Running Build for P/PE/PETDANCE/Perl-Critic-1.140.tar.gz
>>  Unsatisfied dependencies detected during 
>>  PETDANCE/Perl-Critic-1.140.tar.gz
>> B::Keywords [requires]
>

Re: [GNC] Finance::Quote on Mac M1

[Peter West]

 not required for 
installation
t/z_pod-coverage.t .. skipped: This test is only run for the module 
author
t/z_pod.t ... ok

Test Summary Report
---
t/11keywords.t(Wstat: 512 Tests: 0 Failed: 0)
  Non-zero exit status: 2
Files=8, Tests=15,  0 wallclock secs ( 0.02 usr  0.01 sys +  0.18 cusr  0.04 
csys =  0.25 CPU)
Result: FAIL
Failed 1/8 test programs. 0/15 subtests failed.
make: *** [test_dynamic] Error 255
  RURBAN/B-Keywords-1.22.tar.gz
  /usr/bin/make test -- NOT OK
//hint// to see the cpan-testers results for installing this module, try:
  reports RURBAN/B-Keywords-1.22.tar.gz
Stopping: 'install' failed for 'B::Keywords'.

> On 4 Aug 2021, at 5:06 pm, Geoff  wrote:
> 
> Hi Peter
> 
> How about sending through some diagnostics please?  Screenshot or error log.
> 
> Thanks
> 
> Geoff
> =
> 
> On 4/08/2021 5:03 pm, Peter West wrote:
>> I have been trying to get Finance::Quote installed on my Mac M1, without 
>> success. I have tried installing using
>> cpan -i Date::Manip
>> cpan -i Finance::Quote
>> Installing Date::Manip works, but Finance::Quote fails installing 
>> B::Keywords.
>> Any ideas?
>> —
>> Peter West
>> p...@ehealth.id.au
>> But immediately Jesus spoke to them, saying, “Take heart; it is I. Do not be 
>> afraid.”
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.

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

[GNC] Finance::Quote on Mac M1

[Peter West]

I have been trying to get Finance::Quote installed on my Mac M1, without 
success. I have tried installing using
cpan -i Date::Manip
cpan -i Finance::Quote

Installing Date::Manip works, but Finance::Quote fails installing B::Keywords.

Any ideas?


—
Peter West
p...@ehealth.id.au
But immediately Jesus spoke to them, saying, “Take heart; it is I. Do not be 
afraid.”

___
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] Simple Update Question

[Peter West]

Hi Sharon,

I’m CC this to the list, as I cannot answer it.

Peter
—
Peter West
p...@ehealth.id.au
But immediately Jesus spoke to them, saying, “Take heart; it is I. Do not be 
afraid.”

> On 2 Aug 2021, at 3:09 pm, sc  wrote:
> 
> Many thanks to Peter and Alan and Geoff for your responses to my question.  
> So I am now persuaded that it would be wise to upgrade my GnuCash 3.8.
> 
> I am using Windows 7 Home Premium on my Toshiba laptop computer. On the 
> GnuCash website, it says Version 4.6 is for Windows 8/10.  Uh oh, I wonder if 
> this means my Windows 7 is too old.
> For Windows 7 it says Version 3.11.  Maybe I'm not all that outdated after 
> all.
> 
> Am I right in thinking Version 3.11 is the best this computer can handle? 
> 
> Again, thank you for responding.   Sharon
> 
> On 7/28/2021 2:27 AM, Peter West wrote:
>> Hi Sharon,
>> 
>> Open source software is different from commercial software in that there is 
>> no contract, implied or otherwise, to support your use of one particular 
>> version of the software. Even with commercial software, there are limits to 
>> support, as you would have found if you you were running, say Microsoft XP, 
>> as your operating system. If commercial companies cannot maintain support 
>> for older versions beyond a few years, so much the less can open source.
>> 
>> 3.8 will continue to do what 3.8 does. But if you attempt something new at 
>> some time in the future, and run into a problem, when you report it you are 
>> likely to be told that the problem was fixed in 4.x (or 5.x) and you should 
>> upgrade. The longer you leave it, the more likely you are to have upgrade 
>> problems. If your problem has not been seen before, and if it is found to 
>> exist in the latest version, it is not going to be fixed in 3.8, and you 
>> will have to live with it.
>> 
>> All in all, it’s a good idea to keep up to date with updates. If you are 
>> receiving notices of updates, just keep an eye on the list for the following 
>> 3 or 4 weeks. Problems with the update process and with normal usage will 
>> surface in that time frame. After a month or so without reported problems, 
>> you can be confident of the update.
>> 
>> Peter
>> —
>> Peter West
>> p...@ehealth.id.au <mailto:p...@ehealth.id.au>
>> “Then the righteous will shine like the sun in the kingdom of their Father.”
>> 
>>> On 28 Jul 2021, at 1:23 am, sc >> <mailto:sc...@impulse.net>> wrote:
>>> 
>>> Hello.
>>> 
>>> I successfully transferred from Quicken to GnuCash years ago, with no 
>>> troubles.  I'm a home user, nothing complex.
>>> 
>>> Is there any reason I should upgrade from Version 3.8?  Are the changes 
>>> mostly for business folks or are there changes that a home user would enjoy?
>>> 
>>> Sharon
>>> 
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>>> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>>> If you are using Nabble or Gmane, please see 
>>> https://wiki.gnucash.org/wiki/Mailing_Lists 
>>> <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] Simple Update Question

[Peter West]

Hi Sharon,

Open source software is different from commercial software in that there is no 
contract, implied or otherwise, to support your use of one particular version 
of the software. Even with commercial software, there are limits to support, as 
you would have found if you you were running, say Microsoft XP, as your 
operating system. If commercial companies cannot maintain support for older 
versions beyond a few years, so much the less can open source.

3.8 will continue to do what 3.8 does. But if you attempt something new at some 
time in the future, and run into a problem, when you report it you are likely 
to be told that the problem was fixed in 4.x (or 5.x) and you should upgrade. 
The longer you leave it, the more likely you are to have upgrade problems. If 
your problem has not been seen before, and if it is found to exist in the 
latest version, it is not going to be fixed in 3.8, and you will have to live 
with it.

All in all, it’s a good idea to keep up to date with updates. If you are 
receiving notices of updates, just keep an eye on the list for the following 3 
or 4 weeks. Problems with the update process and with normal usage will surface 
in that time frame. After a month or so without reported problems, you can be 
confident of the update.

Peter
—
Peter West
p...@ehealth.id.au
“Then the righteous will shine like the sun in the kingdom of their Father.”

> On 28 Jul 2021, at 1:23 am, sc  wrote:
> 
> Hello.
> 
> I successfully transferred from Quicken to GnuCash years ago, with no 
> troubles.  I'm a home user, nothing complex.
> 
> Is there any reason I should upgrade from Version 3.8?  Are the changes 
> mostly for business folks or are there changes that a home user would enjoy?
> 
> Sharon
> 
> ___
> 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] Big problem GC 4.6 wiping history list? Mac OS Big Sur

[Peter West]

Same here so far, and I’m on M1 as well.

There’s some other variable in your setup.

peter
—
Peter West
p...@ehealth.id.au
And he said to them, “Go.”

> On 3 Jul 2021, at 9:29 pm, Robert Kesterson  wrote:
> 
> FYI I’m running GnuCash 4.6 on Big Sur and not having any issues.   All I did 
> was download it, open the DMG, and drag the GnuCash icon into the 
> applications folder.  It asked if I wanted to replace the existing version, I 
> said yes, it installed, and has been working fine since. 
> 
>> On Jul 3, 2021, at 6:14 AM, Anita Graves  wrote:
>> 
>> Hello everyone,
>> 
>> All I did to deserve this situation is download the latest version of GC 4.6 
>> on my mac using OS Big Sur.  That is all I did.  Now GC crashes and gives me 
>> the window you see.  
>> 
>> I back up to Time Machine but will that also include GC?  I haven’t checked 
>> to see if I can find the file on Time Machine but I will do so.  Meanwhile, 
>> I want to know if anyone else has experienced the same result from the 
>> simple innocent download of GC onto Mac Big Sur.
>> 
>> Thanks to everyone for any help you can possibly give.  I even deleted the 
>> GC4.6 and re-installed my 4.1 GC but I still receive the same as the 
>> attached screenshot. 
>> 
>> For sure, I do not know what I did to deserve this!
>> 
>> Anita
>> 
>>>> On 1 Jul 2021, at 7:36 PM, John Ralls  wrote:
>>>> 
>>>> 
>>>> 
>>>>> On Jun 28, 2021, at 11:52 PM, Anita Graves  
>>>>> wrote:
>>>> 
>>>> Please see the attached screenshot:
>>>> 
>>>> I don’t know what to do but I refuse to delete the file I need to work 
>>>> with, or any of the other files in the history list.  This all happened to 
>>>> me when I installed GC 4.6.  Before I was using 4.1.  Now, when I try to 
>>>> import a log file it gives the same screen.   Then GC crashes!
>>>> 
>>>> I am afraid to wipe all my history and all my work!
>>>> 
>>>> Thanks for your help and suggestions.
>>> 
>>> Your screenshot didn't make it onto the list, but if GnuCash is asking if 
>>> you want to delete a file from the history list that means that it can't 
>>> find the file. You'll want to investigate why that is, but rest assured 
>>> that GnuCash isn't offering to delete the file, just to remove it from the 
>>> history list. 
>>> 
>>> For the crash, please open a bug and attach the crash report from Console. 
>>> You can find instructions for finding the crash report at 
>>> https://wiki.gnucash.org/wiki/Stack_Trace#MacOSX. Write out what you did 
>>> leading up to the crash in the bug description.
>>> 
>>> Regards,
>>> John Ralls
>>> 
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

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

[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
p...@ehealth.id.au
“And if anyone forces you to go one mile, go with him two miles.”

> On 14 Jun 2021, at 3:11 am, John Ralls  wrote:
> 
> 
> 
>> 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 org.gnucash.Gnucash /org/gnucash/history/file0
> or all of them
>  defaults read org.gnucash.Gnucash | grep history
> 
> 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] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?

[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 problems of persisting the environment changes. 
The way I actually do it involves collecting all of the launchctl commands to a 
file, and executing each of them on login, via a simple LaunchAgent script.

Details are at 
http://www.pbw.id.au/blog/2013/11/setting-environment-variables-in-os-x-yosemite-and-mavericks/
 
<http://www.pbw.id.au/blog/2013/11/setting-environment-variables-in-os-x-yosemite-and-mavericks/>

If anyone wants a hand with this, let me know.

—
Peter West
p...@ehealth.id.au
“And if anyone forces you to go one mile, go with him two miles.”

> On 14 Jun 2021, at 2:43 am, John Ralls  wrote:
> 
> https://apple.stackexchange.com/questions/51677/how-to-set-path-for-finder-launched-applications
>  
> <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 session, run `launchctl setenv...`, 
> and kill the Dock. After that you can run GnuCash from Finder and it will use 
> the changed path, though the SO indicates that it works only on 10.7.
> 
> On newer versions of macOS there's `config` command that you run just once 
> then reboot, but it's not clear from the SO nor from launchctl(1) with what 
> version that was introduced; 10.12 is the earliest mentioned in the SO. Since 
> it's persistent make sure that you know how to undo it if you don't like the 
> results... if you screw it up badly enough that might mean booting to single 
> user. Definitely for experts only.
> 
> Regards,
> John Ralls
> 
> 
>> On Jun 13, 2021, at 2:01 AM, Peter West > <mailto:p...@pbw.id.au>> wrote:
>> 
>> 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 $1=\""$2"\"
>>   eval launchctl setenv "$1" \""$2"\"
>> }
>> 
>> Instead of
>> export PATH=blah
>> use
>> set_env_var PATH “blah”
>> 
>> I not sure about the timing of environment settings; that is, whether you 
>> can start up a shell and then immediately invoke, say, GnuCash, or whether 
>> you must log out and in to have the env vars in effect.
>> 
>> 
>> —
>> Peter West
>> p...@ehealth.id.au
>> “…whoever says, ‘You fool!’ will be liable to the hell of fire.”
>> 
>> 
>> 
>>> On 13 Jun 2021, at 6:23 pm, Liz Dodd  wrote:
>>> 
>>> On Sun, 13 Jun 2021 00:39:39 -0700
>>> Jim DeLaHunt mailto:list+gnuc...@jdlh.com> 
>>> <mailto:list+gnuc...@jdlh.com <mailto:list+gnuc...@jdlh.com>>> 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 a command prompt on MacOS and 
>>>> Linux, should they invoked as commands:
>>>> 
>>>> % gnc-fq-check
>>>> 
>>>> Or should they be invoked as an argument to a perl command:
>>>> 
>>>> % perl gnc-fq-check
>>>> 
>>>> ?
>>>> 
>>>> The wiki page
>>>> https://wiki.gnucash.org/wiki/Online_Quotes#Helper_Scripts says,
>>>> pretty clearly, the former:
>>>> 
>>>> "While unixoid operating systems use a shebang (#!) to associate perl 
>>>> scripts with the Perl interpreter, others, e.g. Windows, will fail….
>>>> C:\> gnc-fq-check [fails]…  
>>>> so use the following: … Prefix any gnc-fq-xxx perl script command
>>>> with perl and a space: …
>>>> perl gnc-fq-check …"
>>>> 
>>>> The perl invocation is described as a workaround needed on Windows 
>>>> because the shebang doesn't work. All the other examples show
>>>> invocation as a command, e.g.
>>>> 
>>>> $ gnc-fq-check
>>>

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

[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 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] Should the gnc-fq-* helper scripts be invoked as commands, or as an arg to perl?

[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 $1=\""$2"\"
eval launchctl setenv "$1" \""$2"\"
}

Instead of
export PATH=blah
use
set_env_var PATH “blah”

I not sure about the timing of environment settings; that is, whether you can 
start up a shell and then immediately invoke, say, GnuCash, or whether you must 
log out and in to have the env vars in effect.


—
Peter West
p...@ehealth.id.au
“…whoever says, ‘You fool!’ will be liable to the hell of fire.”



> On 13 Jun 2021, at 6:23 pm, Liz Dodd  wrote:
> 
> On Sun, 13 Jun 2021 00:39:39 -0700
> Jim DeLaHunt mailto:list+gnuc...@jdlh.com>> 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 a command prompt on MacOS and 
>> Linux, should they invoked as commands:
>> 
>> % gnc-fq-check
>> 
>> Or should they be invoked as an argument to a perl command:
>> 
>> % perl gnc-fq-check
>> 
>> ?
>> 
>> The wiki page
>> https://wiki.gnucash.org/wiki/Online_Quotes#Helper_Scripts says,
>> pretty clearly, the former:
>> 
>> "While unixoid operating systems use a shebang (#!) to associate perl 
>> scripts with the Perl interpreter, others, e.g. Windows, will fail….
>> C:\> gnc-fq-check [fails]…  
>> so use the following: … Prefix any gnc-fq-xxx perl script command
>> with perl and a space: …
>> perl gnc-fq-check …"
>> 
>> The perl invocation is described as a workaround needed on Windows 
>> because the shebang doesn't work. All the other examples show
>> invocation as a command, e.g.
>> 
>> $ gnc-fq-check
>> 
>> This makes a difference on Unixoid systems when there are multiple
>> Perl installations. Presumably command invocation of the helper
>> scripts will always obey the shebang and thus always run the same
>> Perl installation. But invocation as an argument to "perl" will run
>> whichever Perl installation the environment dictates.
>> 
>> 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
>> https://wiki.gnucash.org/wiki/Online_Quotes use the same invocation?
>> 
>> Best regards,
>>  —Jim DeLaHunt
>> 
> 
> I don't know the answer, but I think that if you could write it out for
> the wiki it would be good long term recording.
> 
> Liz
> ___
> 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 ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

[Peter West]

That’s a global setting though.

Peter
—
Peter West
p...@ehealth.id.au
“…unless your righteousness exceeds that of the scribes and Pharisees, you will 
never enter the kingdom of heaven.”

> On 2 Jun 2021, at 12:52 pm, D. via gnucash-user  
> wrote:
> 
> Of course, you can suppress zero balance accounts in the View menu, if that's 
> your preference...
> 
> 
>  Original Message 
> From: David Cousens 
> Sent: Tue Jun 01 18:46:57 EDT 2021
> To: John Morris , Gnucash Users 
> 
> Subject: Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS
> 
> John,
> 
> I agree. There is a case for not displaying the Imbalance accounts in the CoA
> tab if there are no entries to them, i.e. they are zero balance. This is an
> option in reports but not in the account tab. They can of course be left in 
> the
> CoA and hidden in the Account tab by editing the account and setting the 
> hidden
> flag but they then remain hidden even when new entries to them are created.
> 
> I would go further and hide them totally if the balance in them was zero and
> change either the background or the font color to a bright red or even 
> flashing
> red( that would clearly need to be optional) to  highlight them when they are
> present with a non-zero balance. 
> 
> Their usefulness to indicate incorrect entries would be enhanced if they are
> hidden when the balance is zero as their presence whether highlighted or not
> indicates an error.  Similarly with the orphan transactions created when an
> account with existing transactions to it has been deleted without moving the
> transactions to another account.
> 
> I would take a look at it but I am currently heavily involved in a physics
> project programming exercise at the moment. The change in behaviour from the
> previous version probably needs to be tracked down and, where possible fixed
> first, before adding any further enhancements to minimize conflicting changes.
> 
> David Cousens
> 
> On Tue, 2021-06-01 at 18:10 -0400, John Morris wrote:
>>> Actually you are given the opportunity to fix it during entry. When the
>>> Imbalance account appears in a transaction in the account column, all you
>>> have to do is click on it in the Account column and assign the correct
>>> account from the drop down list, before closing (pressing Enter) the
>>> transaction.
>> 
>> Unfortunately, by then the damage is already done. The Imbalance account has
>> been created and I must go and delete it yet again. I don’t like extra
>> accounts cluttering up my carefully designed CoA.
>> 
>> Best,
>> John
>> 
>> ___
>> 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.

___
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 ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

[Peter West]

I’m a fairly naive user, but I find the Imbalance-XXX and Orphan-XXX accounts 
(at top level in my CoA) extremely useful, and I understand why they are there. 
If I ever see a balance, I know I have to fix something, which is a good reason 
to have them at the top. I can’t comment on any changes that might have 
occurred in the behaviour of these accounts recently. However, in respect of 
the tidiness of the CoA, one possible solution is to create a special case for 
these accounts, such that they only display in the CoA listing when they have a 
non-zero balance.

Peter
—
Peter West
p...@ehealth.id.au
“…unless your righteousness exceeds that of the scribes and Pharisees, you will 
never enter the kingdom of heaven.”

> On 2 Jun 2021, at 11:22 am, Derek Atkins  wrote:
> 
> 
> On Tue, June 1, 2021 9:15 pm, Liz Dodd wrote:
>> On Tue, 01 Jun 2021 10:23:07 -0400
>> "D. via gnucash-user"  wrote:
>> 
>>> The question about imbalance entries goes back a long ways in
>>> GnuCash, and you can find discussions about it in the lists over the
>>> years.
>>> 
>>> Essentially, the debate boils down to this: is it better to allow a
>>> user to enter an imbalanced transaction and automatically create the
>>> balancing entry in a dummy account (Imbalance-XXX generically
>>> speaking), or should the program nag the user to balance the
>>> transaction every time? Gnucash choose the former many years ago, and
>>> has stuck with that model since.
>> 
>> It is a problem when you are not aware of how to enter transactions,
>> and press the Enter key, probably by habit.
>> Nevertheless I can still find myself with Imbalance entries although I
>> have been using Gnucash a long time.
> 
> Most of my Imbalance entries are a result of rounding errors in the
> scheduled transaction subsystem.  I'll get an extra $0.01 that gets put
> into Imbalance, until I get the statement and manually adjust the
> transaction.
> 
> In the steady-state, Imbalance account is (and should remain) empty.
> 
>> Liz
> 
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> -derek
> 
> -- 
>   Derek Atkins 617-623-3745
>   de...@ihtfp.com <mailto:de...@ihtfp.com> www.ihtfp.com 
> <http://www.ihtfp.com/>
>   Computer and Internet Security Consultant
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Command Line Args

[Peter West]

I’m on a Mac, and command line access is not available by default.

If I 
$ export PATH="$PATH:/Applications/Gnucash.app/Contents/MacOS”
then
$ Gnucash --help
Application Path /Applications/Gnucash.app/Contents/MacOS/Gnucash

(process:12007): gnc.gui-WARNING **: 10:10:34.704: [mac_set_languages()] 
Language list: en:en_AU:C:el_AU
Gnucash [options] [datafile] - GnuCash, accounting for personal and small 
business finance:

Common Options:
  -h [ --help ]   Show this help message
  -v [ --version ]Show GnuCash version
  --debug Enable debugging mode: provide deep detail in the
  logs.
  This is equivalent to: --log "=info" --log "qof=info"
  --log "gnc=info"
  --extra Enable extra/development/debugging features.
  --log arg   Log level overrides, of the form
  "modulename={debug,info,warn,crit,error}"
  Examples: "--log qof=debug" or "--log
  gnc.backend.file.sx=info"
  This can be invoked multiple times.
  --logto arg File to log into; defaults to "/tmp/gnucash.trace";
  can be "stderr" or "stdout".
  --gsettings-prefix arg  Set the prefix for gsettings schemas for gsettings
  queries. This can be useful to have a different
  settings tree while debugging.

Application Options:
  --nofileDo not load the last file opened
  --help-gtk  Show help for gtk options

Deprecated Options:
  --add-price-quotes  Add price quotes to given GnuCash datafile.
  Note this option has been deprecated and will be
  removed in GnuCash 5.0.
  Please use 'gnucash-cli --quotes get '
  instead.
  --namespace arg Regular expression determining which namespace
  commodities will be retrieved.
  Note this option has been deprecated and will be
  removed in GnuCash 5.0.
  Please use 'gnucash-cli --quotes get --namespace
   ' instead.


If I then
$ gnucash-cli --help
Application Path /Applications/Gnucash.app/Contents/MacOS/gnucash-cli

(process:12805): gnc.gui-WARNING **: 10:11:17.131: [mac_set_languages()] 
Language list: en:en_AU:C:el_AU
gnucash-cli [options] [datafile] - GnuCash, accounting for personal and small 
business finance:

Common Options:
  -h [ --help ]   Show this help message
  -v [ --version ]Show GnuCash version
  --debug Enable debugging mode: provide deep detail in the
  logs.
  This is equivalent to: --log "=info" --log "qof=info"
  --log "gnc=info"
  --extra Enable extra/development/debugging features.
  --log arg   Log level overrides, of the form
  "modulename={debug,info,warn,crit,error}"
  Examples: "--log qof=debug" or "--log
  gnc.backend.file.sx=info"
  This can be invoked multiple times.
  --logto arg File to log into; defaults to "/tmp/gnucash.trace";
  can be "stderr" or "stdout".
  --gsettings-prefix arg  Set the prefix for gsettings schemas for gsettings
  queries. This can be useful to have a different
  settings tree while debugging.

Price Quotes Retrieval Options:
  -Q [ --quotes ] arg Execute price quote related commands. Currently only
  one command is supported.

get: Fetch current quotes for all foreign
 currencies and stocks in the given GnuCash
 datafile.

  --namespace arg Regular expression determining which namespace
  commodities will be retrieved for

Report Generation Options:
  -R [ --report ] arg Execute report related commands. The following
  commands are supported.

list: Lists available reports.
show: Describe the options modified in the named
  report. A datafile may be specified to
  describe some saved options.
run: Run the named report in the given GnuCash
 datafile.

  --name arg  Name of the report to run

  --export-type arg   Specify export type

  --outpu

Re: [GNC] mortgage refinance

[Peter West]

> On 22 Mar 2021, at 12:13 am, Derek Atkins  wrote:
> 
> Peter,
> 
> On Sun, March 21, 2021 10:07 am, Peter West wrote:
>> What’s the other side of the new loan set-up? Cash at bank?
>> 
>> So
>> LiabilityLoan A  100,000 Cr
>> LiabilityLoan B  105,000 Cr
>> AssetBank105,000 Dr
> 
> This is wrong -- your Debits and Credits don't sum to zero.

Loan A is an existing loan, so that is just eh current balance on Loan A. I 
should have shown that somehow, but I was assuming an existing loan.


>> 
>> Then
>> AssetBank100,000 Cr  -> 5,000 Dr
>> LiabilityLoan A  100,000 Dr -> Zero balance
>> LiabilityLoan B  105,000 Dr
>> 
>> Like that?
> 
> I think I understand what you are trying to say, and *I'm* very confused
> by what you are saying!!!
> 
> -derek
> 
>> 
>> Peter
>> 
>> —
>> Peter West
>> p...@ehealth.id.au
>> “Now is the judgment of this world; now will the ruler of this world be
>> cast out.”
>> 
>>> On 21 Mar 2021, at 11:42 pm, D via gnucash-user
>>>  wrote:
>>> 
>>> New loan gets a new liability account. Transaction from new loan top old
>>> loan pays off old loan. Old loan goes to zero, is reconciled, and can be
>>> set as placeholder and hidden, if desired. Future transactions pay new
>>> loan.
>>> 
>>> On Mar 21, 2021, 09:26, at 09:26, Parker Graham  wrote:
>>>> Have mortgage set up in system but refinanced it and need help on how
>>>> to
>>>> payoff existing loan and set up new loan
>>>> 
>>>> ___
>>>> 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 <mailto:gnucash-user@gnucash.org>
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists 
>> <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.
>> 
> 
> 
> -- 
>   Derek Atkins 617-623-3745
>   de...@ihtfp.com <mailto:de...@ihtfp.com> www.ihtfp.com 
> <http://www.ihtfp.com/>
>   Computer and Internet Security Consultant

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

Re: [GNC] mortgage refinance

[Peter West]

What’s the other side of the new loan set-up? Cash at bank?

So
Liability   Loan A  100,000 Cr
Liability   Loan B  105,000 Cr
Asset   Bank105,000 Dr

Then
Asset   Bank100,000 Cr  -> 5,000 Dr
Liability   Loan A  100,000 Dr -> Zero balance
Liability   Loan B  105,000 Dr

Like that?

Peter

—
Peter West
p...@ehealth.id.au
“Now is the judgment of this world; now will the ruler of this world be cast 
out.”

> On 21 Mar 2021, at 11:42 pm, D via gnucash-user  
> wrote:
> 
> New loan gets a new liability account. Transaction from new loan top old loan 
> pays off old loan. Old loan goes to zero, is reconciled, and can be set as 
> placeholder and hidden, if desired. Future transactions pay new loan. 
> 
> On Mar 21, 2021, 09:26, at 09:26, Parker Graham  wrote:
>> Have mortgage set up in system but refinanced it and need help on how
>> to
>> payoff existing loan and set up new loan
>> 
>> ___
>> 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] weird price for LU0067412154

[Peter West]

I was kinda hoping there was someone else who was in the habit of pushing fixes 
through. Anyway, I submitted a pull request.


—
p...@ehealth.id.au
“…you refuse to come to me that you may have life.”

> On 20 Mar 2021, at 2:23 am, John Ralls  wrote:
> 
> This is all very good but it would be a heck of a lot more useful as an issue 
> or pull request at https://github.com/finance-quote/finance-quote.
> 
> Regards,
> John Ralls
> 
>> On Mar 18, 2021, at 10:35 PM, Peter West  wrote:
>> 
>> It works because there is now a linebreak in there within the text of the 
>> -0.21%. I wouldn’t rely on that.
>> 
>> Change the RE to
>> 
>> m[NAV> />([0-9]{2}/[0-9]{2}/[0-9]{4}).*([A-Z]{3}).([0-9\.]+).*Day 
>> Change[^%]*>([0-9\.\-]+)]
>> 
>> to stop the first ‘.*’ at ‘Day Change, and to stop the second ‘.*’ before it 
>> gobbles a % sign. Basically, you insert 'Day Change[^%]*’ after the ‘.*’ and 
>> before the ‘>’.
>> 
>> Peter
>> —
>> p...@ehealth.id.au
>> “…you refuse to come to me that you may have life.”
>> 
>>> On 19 Mar 2021, at 11:18 am, Geoff  wrote:
>>> 
>>> Hi Peter
>>> 
>>> This is the URL:
>>> 
>>> https://www.morningstar.co.uk/uk/funds/snapshot/snapshot.aspx?id=f0gbr04aoc
>>> 
>>> Note that Morningstar use their own Security IDs (f0gbr04aoc), the initial 
>>> lookup is via ISIN (LU0067412154) done from here:
>>> 
>>> https://www.morningstar.co.uk/uk/funds/SecuritySearchResults.aspx?search=LU0067412154
>>> 
>>> Hope this helps.
>>> 
>>> Regards
>>> 
>>> Geoff
>>> =
>>> 
>>> On 19/03/2021 11:00 am, Peter West wrote:
>>>> Can you provide the html again, as is, without any inserted linefeeds?
>>>> Peter
>>>> —
>>>> p...@ehealth.id.au
>>>> “…you refuse to come to me that you may have life.”
>>>>> On 19 Mar 2021, at 3:45 am, Andrea Borgia  wrote:
>>>>> 
>>>>> Il 18/03/21 14:41, D. via gnucash-user ha scritto:
>>>>>> Well, considering that the NAV in the example is "USD 2150.31" and the 
>>>>>> 5366.43 in the example actually represents the fund size, I'd imagine 
>>>>>> you should get the former as the NAV.
>>>>>> 
>>>>> Yes, and at the moment it is working again.
>>>>> 
>>>>> In the attached screenshot, first two runs are from the time of the 
>>>>> original post and the third one just now.
>>>>> 
>>>>> 
>>>>> 
>>>> ___
>>>> 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] weird price for LU0067412154

[Peter West]

It works because there is now a linebreak in there within the text of the 
-0.21%. I wouldn’t rely on that.

Change the RE to

m[NAV([0-9]{2}/[0-9]{2}/[0-9]{4}).*([A-Z]{3}).([0-9\.]+).*Day 
Change[^%]*>([0-9\.\-]+)]

to stop the first ‘.*’ at ‘Day Change, and to stop the second ‘.*’ before it 
gobbles a % sign. Basically, you insert 'Day Change[^%]*’ after the ‘.*’ and 
before the ‘>’.

Peter
—
p...@ehealth.id.au
“…you refuse to come to me that you may have life.”

> On 19 Mar 2021, at 11:18 am, Geoff  wrote:
> 
> Hi Peter
> 
> This is the URL:
> 
> https://www.morningstar.co.uk/uk/funds/snapshot/snapshot.aspx?id=f0gbr04aoc
> 
> Note that Morningstar use their own Security IDs (f0gbr04aoc), the initial 
> lookup is via ISIN (LU0067412154) done from here:
> 
> https://www.morningstar.co.uk/uk/funds/SecuritySearchResults.aspx?search=LU0067412154
> 
> Hope this helps.
> 
> Regards
> 
> Geoff
> =
> 
> On 19/03/2021 11:00 am, Peter West wrote:
>> Can you provide the html again, as is, without any inserted linefeeds?
>> Peter
>> —
>> p...@ehealth.id.au
>> “…you refuse to come to me that you may have life.”
>>> On 19 Mar 2021, at 3:45 am, Andrea Borgia  wrote:
>>> 
>>> Il 18/03/21 14:41, D. via gnucash-user ha scritto:
>>>> Well, considering that the NAV in the example is "USD 2150.31" and the 
>>>> 5366.43 in the example actually represents the fund size, I'd imagine you 
>>>> should get the former as the NAV.
>>>> 
>>> Yes, and at the moment it is working again.
>>> 
>>> In the attached screenshot, first two runs are from the time of the 
>>> original post and the third one just now.
>>> 
>>> 
>>> 
>> ___
>> 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] weird price for LU0067412154

[Peter West]

Can you provide the html again, as is, without any inserted linefeeds?

Peter
—
p...@ehealth.id.au
“…you refuse to come to me that you may have life.”

> On 19 Mar 2021, at 3:45 am, Andrea Borgia  wrote:
> 
> Il 18/03/21 14:41, D. via gnucash-user ha scritto:
>> Well, considering that the NAV in the example is "USD 2150.31" and the 
>> 5366.43 in the example actually represents the fund size, I'd imagine you 
>> should get the former as the NAV.
>> 
> Yes, and at the moment it is working again.
> 
> In the attached screenshot, first two runs are from the time of the original 
> post and the third one just now.
> 
> 
> 

___
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] weird price for LU0067412154

[Peter West]

If I take this HTML, get rid of all the linefeeds (so it becomes a single 
line), and feed it into a simple perl script that uses the RE to extract 
components, I get the following four values:

17/03/2021  USD  5366.43  2.40

which is what I expect from the RE.

What is it supposed to be getting?

Peter

—
p...@ehealth.id.au
“…you refuse to come to me that you may have life.”

> On 18 Mar 2021, at 5:27 pm, Geoff  wrote:
> 
> Firefox "View Source" reveals the following (I've inserted line breaks after 
> each td for legibility):
> 
> 
> NAV17/03/2021
>  
> USD 2150.31
> 
> 
> Day Change
>  
> 0.26%
> 
> 
> Morningstar Category™
>  
>  href="/uk/fundquickrank/default.aspx?category=EUCA000504" 
> style="width:100%!important;">China Equity
> 
> 
> 
> ISIN
>  
> LU0067412154
> 
> 
> Fund Size (Mil) />17/03/2021
>  
> USD 15667.00
> 
> 
> Share Class Size (Mil) />17/03/2021
>  
> USD 5366.43
> 
> 
> Max Initial Charge
>  
> 5.00%
> 
> 
> Ongoing Charge />11/03/2021
>   
> 2.40%
> 
> 
> 
> 
> IMHO it would be more maintainable to use individual expressions to extract 
> the 4 fields separately.
> 
> I don't use this data source and currently don't have time to fix it.
> 
> Geoff
> =
> 
> On 18/03/2021 3:22 pm, Peter West wrote:
>> Here’s the RE.
>> m[NAV> />([0-9]{2}/[0-9]{2}/[0-9]{4}).*([A-Z]{3}).([0-9\.]+).*>([0-9\.\-]+)]
>> There is no trailing modifier, so this has to be a single line in the html.
>> So it will start looking with the initial literal string including NAV and 
>> ending with the '’ which shows in pretty-print as ‘’. That won’t 
>> match if it’s actually like that, of course. What is the full raw html text 
>> of the  in which the $5356.02 appears?
>> —
>> p...@ehealth.id.au <mailto:p...@ehealth.id.au>
>> “…you refuse to come to me that you may have life.”
>>> On 18 Mar 2021, at 11:57 am, Peter West >> <mailto:p...@pbw.id.au>> wrote:
>>> 
>>> The pretty-printed elements from the Developer menu won’t be matched by the 
>>> RE. Can you see the raw html?
>>> 
>>> Peter
>>> —
>>> p...@ehealth.id.au <mailto:p...@ehealth.id.au>
>>> “…an hour is coming when all who are in the tombs will hear his voice and 
>>> come out…”
>>> 
>>>> On 18 Mar 2021, at 10:09 am, Geoff  wrote:
>>>> 
>>>> This looks like a problem with Finance Quote's MStaruk.pm module.  Did 
>>>> Morningstar change their web site recently?
>>>> 
>>>> Testing the recent Finance Quote v1.50 release candidate, without using 
>>>> any GnuCash code, I get the same results.
>>>> 
>>>> See attached screenshot - I think the problem lies with the long regular 
>>>> expression on line 160.  It contains a couple of "greedy" matches that are 
>>>> probably causing a match on the last decimal number (Share Class Size) 
>>>> instead of the first (NAV).
>>>> 
>>>> Geoff
>>>> =
>>>> 
>>>> On 18/03/2021 6:48 am, Andrea Borgia wrote:
>>>>> Il 17/03/21 20:32, Derek Atkins ha scritto:
>>>>>> The screenshot didn't make it through the email, most likely because you
>>>>>> sent it as an embedded image in HTML instead of as a text with 
>>>>>> attachment.
>>>>> Yes and I never had any issues before. Weird.
>>>>> My apologies.
>>>>>>> gnc-fq-dump morningstarch LU0067412154
>>>>>> When I run this, I get:
>>>>>> 
>>>>>> gnc-fq-dump morningstarch LU0067412154
>>>>>> Finance::Quote fields Gnucash uses:
>>>>>> symbol: LU0067412154 <=== required
>>>>>>   date: 03/17/2021   <=== recommended
>>>>>>   currency: USD  <=== required
>>>>>>   last: 2150.31  <=\
>>>>>>nav: 2150.31  <=== one of these
>>>>>>  price: 2150.31  <=/
>>>>>>   timezone:  <=== optional
>>>>>> 
>>>>>> 
>>>>>>> gnc-fq-dump mstaruk LU0067412154
>>>>>> This gives me different results:
>>>>>> 
>>>>>> gnc-fq-dump mstaruk LU0067412154
>>>>>> Finance::Quote fields Gnucash uses:
>>>

Re: [GNC] weird price for LU0067412154

[Peter West]

Here’s the RE.

m[NAV([0-9]{2}/[0-9]{2}/[0-9]{4}).*([A-Z]{3}).([0-9\.]+).*>([0-9\.\-]+)]

There is no trailing modifier, so this has to be a single line in the html.

So it will start looking with the initial literal string including NAV and 
ending with the '’ which shows in pretty-print as ‘’. That won’t 
match if it’s actually like that, of course. What is the full raw html text of 
the  in which the $5356.02 appears?


—
p...@ehealth.id.au
“…you refuse to come to me that you may have life.”

> On 18 Mar 2021, at 11:57 am, Peter West  wrote:
> 
> The pretty-printed elements from the Developer menu won’t be matched by the 
> RE. Can you see the raw html?
> 
> Peter
> —
> p...@ehealth.id.au
> “…an hour is coming when all who are in the tombs will hear his voice and 
> come out…”
> 
>> On 18 Mar 2021, at 10:09 am, Geoff  wrote:
>> 
>> This looks like a problem with Finance Quote's MStaruk.pm module.  Did 
>> Morningstar change their web site recently?
>> 
>> Testing the recent Finance Quote v1.50 release candidate, without using any 
>> GnuCash code, I get the same results.
>> 
>> See attached screenshot - I think the problem lies with the long regular 
>> expression on line 160.  It contains a couple of "greedy" matches that are 
>> probably causing a match on the last decimal number (Share Class Size) 
>> instead of the first (NAV).
>> 
>> Geoff
>> =
>> 
>> On 18/03/2021 6:48 am, Andrea Borgia wrote:
>>> Il 17/03/21 20:32, Derek Atkins ha scritto:
>>>> The screenshot didn't make it through the email, most likely because you
>>>> sent it as an embedded image in HTML instead of as a text with attachment.
>>> Yes and I never had any issues before. Weird.
>>> My apologies.
>>>>> gnc-fq-dump morningstarch LU0067412154
>>>> When I run this, I get:
>>>> 
>>>> gnc-fq-dump morningstarch LU0067412154
>>>> Finance::Quote fields Gnucash uses:
>>>> symbol: LU0067412154 <=== required
>>>>   date: 03/17/2021   <=== recommended
>>>>   currency: USD  <=== required
>>>>   last: 2150.31  <=\
>>>>nav: 2150.31  <=== one of these
>>>>  price: 2150.31  <=/
>>>>   timezone:  <=== optional
>>>> 
>>>> 
>>>>> gnc-fq-dump mstaruk LU0067412154
>>>> This gives me different results:
>>>> 
>>>> gnc-fq-dump mstaruk LU0067412154
>>>> Finance::Quote fields Gnucash uses:
>>>> symbol: LU0067412154 <=== required
>>>>   date: 03/17/2021   <=== recommended
>>>>   currency: USD  <=== required
>>>>   last: 5356.02  <=\
>>>>nav: 5356.02  <=== one of these
>>>>  price: 5356.02  <=/
>>>>   timezone:  <=== optional
>>>> 
>>>> So I would say the issue is upstream, possibly with the quote sources.
>>> Hmm, the UK site of MorningStar gives a totally reasonable value.
>>> That's why I asked.
>>> Pity, the screenshot of the website is missing as well.
>>> ___
>>> 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.

___
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] weird price for LU0067412154

[Peter West]

The pretty-printed elements from the Developer menu won’t be matched by the RE. 
Can you see the raw html?

Peter
—
p...@ehealth.id.au
“…an hour is coming when all who are in the tombs will hear his voice and come 
out…”

> On 18 Mar 2021, at 10:09 am, Geoff  wrote:
> 
> This looks like a problem with Finance Quote's MStaruk.pm module.  Did 
> Morningstar change their web site recently?
> 
> Testing the recent Finance Quote v1.50 release candidate, without using any 
> GnuCash code, I get the same results.
> 
> See attached screenshot - I think the problem lies with the long regular 
> expression on line 160.  It contains a couple of "greedy" matches that are 
> probably causing a match on the last decimal number (Share Class Size) 
> instead of the first (NAV).
> 
> Geoff
> =
> 
> On 18/03/2021 6:48 am, Andrea Borgia wrote:
>> Il 17/03/21 20:32, Derek Atkins ha scritto:
>>> The screenshot didn't make it through the email, most likely because you
>>> sent it as an embedded image in HTML instead of as a text with attachment.
>> Yes and I never had any issues before. Weird.
>> My apologies.
 gnc-fq-dump morningstarch LU0067412154
>>> When I run this, I get:
>>> 
>>> gnc-fq-dump morningstarch LU0067412154
>>> Finance::Quote fields Gnucash uses:
>>>  symbol: LU0067412154 <=== required
>>>date: 03/17/2021   <=== recommended
>>>currency: USD  <=== required
>>>last: 2150.31  <=\
>>> nav: 2150.31  <=== one of these
>>>   price: 2150.31  <=/
>>>timezone:  <=== optional
>>> 
>>> 
 gnc-fq-dump mstaruk LU0067412154
>>> This gives me different results:
>>> 
>>> gnc-fq-dump mstaruk LU0067412154
>>> Finance::Quote fields Gnucash uses:
>>>  symbol: LU0067412154 <=== required
>>>date: 03/17/2021   <=== recommended
>>>currency: USD  <=== required
>>>last: 5356.02  <=\
>>> nav: 5356.02  <=== one of these
>>>   price: 5356.02  <=/
>>>timezone:  <=== optional
>>> 
>>> So I would say the issue is upstream, possibly with the quote sources.
>> Hmm, the UK site of MorningStar gives a totally reasonable value.
>> That's why I asked.
>> Pity, the screenshot of the website is missing as well.
>> ___
>> 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] Scheduled transaction frequency?

[Peter West]

Can’t you set a complete calendar? 31st when it works, else 1st, else 2nd (to 
be on the safe side) in Feb, provided the 1 day early on 3 out of 4 Febs is not 
too big a problem.
—
p...@ehealth.id.au
“…an hour is coming when all who are in the tombs will hear his voice and come 
out…”

> On 17 Mar 2021, at 12:29 pm, gnu Gord  wrote:
> 
> Thanks to all that replied.
> I have set it up as 'last day of the month', that's one of the options,
> because it is an expense. I'll have to remember, or better yet, add a
> comment that says something like "change the date to the real date before
> posting". It's not a huge problem but an interesting situation...
> 
> Thanks again,
> Gord
> 
> 
> On Tue, Mar 16, 2021 at 11:13 AM Michael Hendry 
> wrote:
> 
>>> On 16 Mar 2021, at 17:13, Derek Atkins  wrote:
>>> 
>>> I don't think you can do that with the current implementation.
>>> 
>>> -derek
>>> 
>> 
>> As a workaround, could you simply set up a monthly transaction for the
>> last day of the month, or for the 3rd day of the month?
>> 
>> If it’s an expense you would use the former (to get early warning of money
>> going out), and for income the latter (so you definitely don’t spend it too
>> soon!).
>> 
>> You can always adjust the date later, if you really must have the dates
>> aligned with the actual payments.
>> 
>> Regards,
>> 
>> Michael
>> 
>> 
> ___
> 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] Moving to Linux

[Peter West]

You can (and should) always check which files will be affected by using ‘ls’ as 
in my example, before using rm on the same pattern.

rm * will remove files NOT starting with ‘.’


—
p...@ehealth.id.au
“Two men went up into the temple to pray, one a Pharisee and the other a tax 
collector.”

> On 14 Mar 2021, at 1:02 pm, w...@theprescotts.com wrote:
> 
> Be careful with 'rm' and the asterisk.
> rm ._* will remove files with names that start with anything followed by '_'
> rm ._ * will remove everything in the directory.
> 
> Will
> 
> On 2021 Mar 13, at 03-13 19:04:16, Peter West  wrote:
> 
> If these files are on linux try
> 
> $ ls ._*
> 
> That should show you those files. If there are none you want to keep then
> 
> $ rm ._*
> will remove them.
> 
> 
> 
> —
> p...@ehealth.id.au
> “Two men went up into the temple to pray, one a Pharisee and the other a tax 
> collector.”
> 
>> On 14 Mar 2021, at 8:38 am, Jim DeLaHunt  wrote:
>> 
>> 
>> On 2021-03-13 13:52, Jim DeLaHunt wrote:
>>> …It's probably more correct to think of your non-Mac system as creating 
>>> these files. Did you publish your Linux file system to the Mac using 
>>> NetATalk or Samba, and then use the Mac Finder to copy the files from the 
>>> Mac file system to that published file system? If so, then NetATalk or 
>>> Samba told the Mac it supported storing metadata, when the underlying Linux 
>>> file system did not have a way of storing metadata. Thus perhaps NetATalk 
>>> or Samba created these "._*" files as a workaround for storing the file 
>>> metadata.…
>> 
>> 
>> On 2021-03-13 13:59, Stephen C. Camidge wrote:
>>> No Jim. I copied my files on my Mac to an external FAT32 (I think it is 
>>> called) drive and opened it in Linux.
>> 
>> 
>> In that case, Mac system software is probably what handled reading and 
>> writing with the FAT32 disk. So, it is probably correct to say that the Mac 
>> software created these "._*" files. But the situation is the same: the FAT32 
>> file system doesn't support storing metadata, so the thing bridging the 
>> differences between the Mac world and the FAT32 world probably created these 
>> files, to store metadata that was attached to the files on the Mac.
>> 
>>   —Jim DeLaHun
>> 
>> ___
>> 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.

___
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] Moving to Linux

[Peter West]

If these files are on linux try

$ ls ._*

That should show you those files. If there are none you want to keep then

$ rm ._*
will remove them.



—
p...@ehealth.id.au
“Two men went up into the temple to pray, one a Pharisee and the other a tax 
collector.”

> On 14 Mar 2021, at 8:38 am, Jim DeLaHunt  wrote:
> 
> 
> On 2021-03-13 13:52, Jim DeLaHunt wrote:
>> …It's probably more correct to think of your non-Mac system as creating 
>> these files. Did you publish your Linux file system to the Mac using 
>> NetATalk or Samba, and then use the Mac Finder to copy the files from the 
>> Mac file system to that published file system? If so, then NetATalk or Samba 
>> told the Mac it supported storing metadata, when the underlying Linux file 
>> system did not have a way of storing metadata. Thus perhaps NetATalk or 
>> Samba created these "._*" files as a workaround for storing the file 
>> metadata.…
> 
> 
> On 2021-03-13 13:59, Stephen C. Camidge wrote:
>> No Jim. I copied my files on my Mac to an external FAT32 (I think it is 
>> called) drive and opened it in Linux.
> 
> 
> In that case, Mac system software is probably what handled reading and 
> writing with the FAT32 disk. So, it is probably correct to say that the Mac 
> software created these "._*" files. But the situation is the same: the FAT32 
> file system doesn't support storing metadata, so the thing bridging the 
> differences between the Mac world and the FAT32 world probably created these 
> files, to store metadata that was attached to the files on the Mac.
> 
> —Jim DeLaHun
> 
> ___
> 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] Blurred titles and Language issues

[Peter West]

I think it’s the column headings Gabriele’s referring to.


—
p...@ehealth.id.au
“Those who are well have no need of a physician, but those who are sick.”

> On 23 Feb 2021, at 12:46 pm, Adrien Monteleone 
>  wrote:
> 
> The screenshot you provided showed absolutely everything in the register 
> blurred out. (the rest of the UI is clear though) If that is the way it 
> normally looks, something is certainly wrong. (that is, if you didn't obscure 
> the register fields for privacy) Otherwise, I'm not sure what your issue is.
> 
> The date could be drawn from your MacOS locale settings, but I could be 
> mistaken. Play with it a bit to see what gets the English you expect. You 
> should still be able to set your time zone to be Belgium, but retain an 
> English 'locale' for the OS. (whichever variant you prefer)
> 
> Which version of GnuCash and which version of MacOS are you running?
> 
> Regards,
> Adrien
> 
> On 2/21/21 3:16 PM, Gabriele Venturato wrote:
>> Hello everyone,
>> I hope this is the right place where to discuss this, otherwise please point 
>> me to the right resource.
>> I’ve just installed GnuCash in MacOs, but I see a couple of problems. You 
>> can see them on the screenshot attached.
>> 1. The titles of all the account tables are blurred. Is there a reason for 
>> that? In linux (Fedora) I can see them neat. Moreover, all the other text in 
>> the interface looks fine.
>> 2. At the bottom you can see the date is not in English. I’m currently in 
>> Belgium (I suspect this is the problem), but I set everything in the system 
>> to be in English. The only thing related to Belgium is the region, but I 
>> don’t want to change it because it is where I actually am and therefore I 
>> think it’s correct that it remains like that.
>> I tried to search both on the preferences/settings and online, but I 
>> couldn’t find answers to these problems.
> 
> ___
> 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] Recent list in file menu

[Peter West]

I don’t have Big Sur, but I can just drag the icon from the Applications folder 
opened in FInder, onto the Dock. Then I can start Gnucash by double-clocking 
the icon in the dock. I suppoe it depends how busy you Dock is already.

peter

> On 17 Jan 2021, at 1:41 pm, Peter S. Shenkin  wrote:
> 
> On Big Sur, I have Gnucash installed directly under /Applications, which is
> the default Installer option.
> 
> I either double-click the icon, or, in a Terminal window, type "open
> /Applications/Gnucash.app".
> 
> If you have Gnucash.app installed somewhere else, just type open  to>/Gnucash.app. Once it opens, the icon will appear in the side bar. You
> can then right click on it and select Options > Keep in dock. From then on,
> you can just click the icon.
> 
> FWIW (for geeks), I have a function set up in my .bashrc. The declaration
> says:
> 
> appo() {
># "appo Foo" will recite "open /Applications/Foo.app"
>open /Applications/$1.app
> }
> 
> 
> The comment (beginning with the # sign) tells how I start an app that's in
> /Applications from a Terminal session. For Gnucash, I just say "appo
> Gnucash". (The mnemonic is "app open".)
> 
> I hope the above helps.
> 
> -P.
> 
> 
> On Sat, Jan 16, 2021 at 9:05 PM David H  wrote:
> 
>> Hi David,
>> 
>> Yes tried it without and get "Couldn't find an application named "Gnucash";
>> defaults unchanged" so it definitely seems to need the folder name in
>> addition to the app name.  Might uninstall on my Macbook Pro later and
>> re-install to apps folder only and see if it makes any difference.
>> 
>> Cheers David H.
>> 
>> 
>> On Sun, 17 Jan 2021 at 09:30, David Reiser  wrote:
>> 
>>> Have you tried without the extra directory info?
>>> man defaults says that the -app flag specifies the name of the app, not a
>>> directory. I haven’t tested it myself, and the manfile is a bit vague on
>>> details here. But since defaults write is writing to the pfile in
>> Library,
>>> it doesn’t have to know the location of Gnucash. Gnucash reads the pfile
>> on
>>> launch, so it shouldn’t matter where the app is stored.
>>> --
>>> Dave Reiser
>>> dbrei...@icloud.com
>>> 
>>> 
>>> 
>>> 
>>> 
 On Jan 16, 2021, at 5:54 PM, David H  wrote:
 
 Hi David,
 
 Been playing around with that exact same setting for a while now but it
 doesn't seem to work on my Big Sur / Gnucash 4.4 system.
 
 My setup is slightly different in that I installed Gnucash in
 /Applications/GnuCash as opposed to /Applications itself, so I've been
 tinkering with
 
 defaults write -app GnuCash/Gnucash "/org/gnucash/history/maxfiles" 5
>> but
 no luck so far
 
 Cheers David H.
 
 On Sun, 17 Jan 2021 at 07:52, David Carlson <
>> david.carlson@gmail.com
 
 wrote:
 
> Searching the archives of this list I found a thread a year ago.  This
> suggestion was part way through the thread: <
> 
>>> 
>> https://lists.gnucash.org/pipermail/gnucash-user/2020-January/089080.html>
> It seems to be only for Mac computers so there is no info that I could
>>> find
> for Linux or Windoze.  For either it might be an OS or workspace
>>> setting.
> 
> On Sat, Jan 16, 2021 at 12:51 PM Stephen M. Butler <
> stephen.m.butle...@gmail.com> wrote:
> 
>> On 1/16/21 9:15 AM, Michael Hendry wrote:
 On 15 Jan 2021, at 03:30, David Carlson <
>> david.carlson@gmail.com
 
>> wrote:
 
 Maybe I searched for the wrong term.  I would never have guessed to
>> search
 for plist or mru, for example.
>>> I’ve found the relevant file here:
>>> 
>>> ~/Library/Preferences/org.gnucash.Gnucash.plist
>>> 
>>> but I can’t locate the Key that defines the maximum number of
>> recently-used files for display (hereinafter called “MRU_MAX"), which
>> defaults to 4 on my iMac Catalina running 4.4.
>>> 
>>> I notice that the Keys org.gnucash.history.file0 to
>> org.gnucash.history.file9 contain fully qualified filenames for the
>> ten
>> books I have opened most recently, which suggests that MRU_MAX up to
>> 10
>> could be supported if the default of 4 were changed.
>>> 
>>> There seems not to ba a way of adjusting MRU_MAX using GnuCash’s
>> Preferences, so I’m stuck!
>>> 
>>> Regards,
>>> 
>>> Michael
>> Check the recent archives as I remember a discussion that if the key
>> entry doesn't exist, it defaults to 4.  You have to create the entry
>> name/value pair in order to change it.  They gave the key name in
>> that
>> discussion.
>> 
>> 
>> --
>> 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
>> 

Re: [GNC] Rounding & formulas

[Peter West]

Just by the way, there’s a fascinating illustration of the floating point 
problem in the history of TeX. When Knuth and co. wrote TeX, the intention was 
that a TeX document would reproduce identical printed documents irrespective of 
the hardware it ran on. After a while, it was reported that this was not true. 
Documents designed and produced on one system produced different results on 
another system.

The problem was that the layout calculations were being done in floating point, 
and the floating point hardware implementation was a little different on 
different systems. (Such hardware is much more standardised now.) The solution 
was to define the layout space as an integral number of thousandths of a point. 
Problem solved. Ah, the wonder of integers.

Peter
--
Peter West
p...@pbw.id.au
“My soul magnifies the Lord, and my spirit rejoices in God my Saviour…”

> On 22 Dec 2020, at 1:13 pm, Peter West  wrote:
> 
> Granted, but that only applies if total_amount is a floating point number. I 
> didn’t think that one through.
> 
> $1.01/2 = 0.505
> $1.01 - (1.01/2) = 1.01 - 0.505 = 0.505
> 
> Both results rounded = .50
> 
> I _never_ used floating point for monetary amounts, for reasons demonstrated 
> above, and I pretty soon discovered that that was the general advice. The 
> only currency that is not integral is Bitcoin. (That opens up a whole new can 
> of worms.) Foreign currency transactions are different, but you would have 
> currency conversion vestibules with integral amounts in and out.
> 
> I assume from all of this that floating point is built in with the 
> foundations, so it’s too late to do anything about it now.
> 
> However, there is talk of moving to a database, in which case the 
> representation of currency will, one hopes, be as a DECIMAL type, with the 
> appropriate number of decimal places, and the OP's formulae will start to 
> work, as if by magic.
> 
> [As an aside, individual cents are now virtual in Australian currency, thanks 
> to the ongoing debasement of same. Only in bank accounts and price books do 
> cents exist. One and two cent pieces were withdrawn from circulation years 
> ago. All cash payments are rounded to the nearest 5 cents.]
> 
> Peter
> --
> Peter West
> p...@pbw.id.au
> “My soul magnifies the Lord, and my spirit rejoices in God my Saviour…”
> 
>> On 21 Dec 2020, at 2:01 pm, John Ralls  wrote:
>> 
>> 
>> 
>>> On Dec 20, 2020, at 6:12 PM, Peter West  wrote:
>>> 
>>> I don’t understand why "total_amount-(total_amount/2)” doesn’t work.
>> 
>> Maybe because the rounding happens after the whole computation?
>> 
>> 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] Rounding & formulas

[Peter West]

Granted, but that only applies if total_amount is a floating point number. I 
didn’t think that one through.

$1.01/2 = 0.505
$1.01 - (1.01/2) = 1.01 - 0.505 = 0.505

Both results rounded = .50

I _never_ used floating point for monetary amounts, for reasons demonstrated 
above, and I pretty soon discovered that that was the general advice. The only 
currency that is not integral is Bitcoin. (That opens up a whole new can of 
worms.) Foreign currency transactions are different, but you would have 
currency conversion vestibules with integral amounts in and out.

I assume from all of this that floating point is built in with the foundations, 
so it’s too late to do anything about it now.

However, there is talk of moving to a database, in which case the 
representation of currency will, one hopes, be as a DECIMAL type, with the 
appropriate number of decimal places, and the OP's formulae will start to work, 
as if by magic.

[As an aside, individual cents are now virtual in Australian currency, thanks 
to the ongoing debasement of same. Only in bank accounts and price books do 
cents exist. One and two cent pieces were withdrawn from circulation years ago. 
All cash payments are rounded to the nearest 5 cents.]

Peter
--
Peter West
p...@pbw.id.au
“My soul magnifies the Lord, and my spirit rejoices in God my Saviour…”

> On 21 Dec 2020, at 2:01 pm, John Ralls  wrote:
> 
> 
> 
>> On Dec 20, 2020, at 6:12 PM, Peter West  wrote:
>> 
>> I don’t understand why "total_amount-(total_amount/2)” doesn’t work.
> 
> Maybe because the rounding happens after the whole computation?
> 
> 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] Rounding & formulas

[Peter West]

There’s no rounding as such involved in the formulae. The timing will only 
matter if total_amount changes between the two calculations, which I assume it 
will not do. If x/2, when x is an integer (be it number of cents or number of 
pennies or whatever), does not give identical results for the same x whenever 
it is executed, something is seriously wrong.

If x is a floating point number, odd things can happen. Even so, for the same 
x, the result must be constant. The developers should be able to clarify all of 
this.

Peter
--
Peter West
p...@pbw.id.au
“Blessed are you among women, and blessed is the fruit of your womb!”

> On 21 Dec 2020, at 9:24 pm, Fred Bone  wrote:
> 
> On 21 December 2020 at 12:12, Peter West said:
> 
>> I don’t understand why "total_amount-(total_amount/2)” doesn’t work.
>> I’m assuming that two formulae are used: total_amount/2 &
>> total_amount-(total_amount/2), as the OP specifies.
>> 
>> If the amount is odd, the first should be (given consistent truncation of
>> the dividend by integer division) equivalent to (total_amount -1) / 2,
>> which when subtracted from total_amount will leave an odd result. If it
>> doesn’t do this, then there is a serious problem with Gnucash
>> arithmetic.
> 
> That obviously depends on when the rounding occurs.
> 
> The OP's example suggests it happens as late as possible, as one would 
> reasonably expect. If so, adding 0.005 to whichever of the two is 
> required to be rounded up is guaranteed to produce the desired effect.
> 
> ___
> 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] Rounding & formulas

[Peter West]

Fred,

When I said no rounding as such I was referring to integer division. In integer 
division, 14/5 = 2, the same as 10/5, and all integers between. The rounding is 
simply throwing away the rubbish left over; the remainder.

Peter
--
Peter West
p...@pbw.id.au
“Blessed are you among women, and blessed is the fruit of your womb!”

> On 21 Dec 2020, at 10:38 pm, Fred Bone  wrote:
> 
> On 21 December 2020 at 22:14, Peter West said:
> 
>> There’s no rounding as such involved in the formulae. The timing will
>> only matter if total_amount changes between the two calculations, which I
>> assume it will not do. If x/2, when x is an integer (be it number of cents
>> or number of pennies or whatever), does not give identical results for the
>> same x whenever it is executed, something is seriously wrong.
>> 
>> If x is a floating point number, odd things can happen. Even so, for the
>> same x, the result must be constant. The developers should be able to
>> clarify all of this.
> 
> Of course there is rounding, but no-one suggested it was visible in the 
> formulae.
> 
> Half an odd number cannot be represented as a whole number and the end 
> result is necessarily rounded either up or down. This is true even if the 
> calculation is done in floating point rather than rational arithmetic.
> 
> As I said, much depends on whether the rounding occurs at the end (as I 
> would expect, and as the OP's report suggests) or at each stage of the 
> calculation (which is inconsistent with the OP's 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.

___
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] Rounding & formulas

[Peter West]

I don’t understand why "total_amount-(total_amount/2)” doesn’t work. I’m 
assuming that two formulae are used:
total_amount/2
&
total_amount-(total_amount/2),
as the OP specifies.

If the amount is odd, the first should be (given consistent truncation of the 
dividend by integer division) equivalent to
(total_amount -1) / 2,
which when subtracted from total_amount will leave an odd result. If it doesn’t 
do this, then there is a serious problem with Gnucash arithmetic.

Also, the OP isn’t trying to do accounting to the mille, but to the cent. The 
virtue of this is that everything balances, which is the whole point of double 
entry, I think. And if you’re vaguely obsessive, as I am, such virtue is its 
own reward.

God bless you all, and may you have a blessed and holy Christmas.

Peter
--
Peter West
p...@pbw.id.au
“Blessed are you among women, and blessed is the fruit of your womb!”

> On 21 Dec 2020, at 11:15 am, Adrien Monteleone 
>  wrote:
> 
> Note, I'm not aware of a 'proper' solution that you are looking for.
> 
> Sounds like a lot of effort to avoid changing a single digit on review when 
> occasionally the original amount is odd.
> 
> I would expect your try at "total_amount-(total_amount/2)" to only work half 
> the time, thus a coin flip. Note, that's 29 characters. (not to count the 
> clicks to get that far setting it up, or other characters involved) How many 
> did you type asking this question? How much time and typing will you save, 
> and if you find a solution, how long will it take to break even?
> 
> I'm not trying to be rude, but this is almost at the level of wanting to do 
> accounting to the mille. The payoff will never be worth the effort.
> 
> Regards,
> Adrien
> 
> On 12/19/20 12:09 PM, Thomas Lenherr wrote:
>> Hi,
>> I've been using gnucash for a few years now, including scheduled
>> transactions with variables/formulas, but one thing I never figured out is
>> how to avoid imbalances in them when variables cause "bad" rounding,
>> requiring me to fix those manually.
>> Simple example:
>> I use a scheduled transaction for an expense that varies month to month
>> (=variable), and I'd like to split it into two (share with another person,
>> i.e. book 50% against their account). Every now and then that amount is an
>> odd number of cents, and so just dividing by two for both the amount
>> against my expense account and their debitor-account results in an
>> imbalance that I need to fix manually (= I'm fine always being the person
>> that pays a cent more than the other one).
>> I tried to be "clever" by writing one of them as "total_amount/2" and the
>> other one as "total_amount-(total_amount/2)" but that didn't work either.
>> Is there a way to e.g. force rounding in the formula? E.g. something like
>> "round(total_amount/2, 0.01)" and "total_amount - round(total_amount/2,
>> 0.01)"? Or is there a different solution I'm not aware of?
>> If there's no existing option, would it be hard to add support for such a
>> function or other solution?
> 
> ___
> 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] Saving to MySQL

[Peter West]

The user id running the server is usually _mysql (note the underscore). I 
assume you specified root as the mysql users (given the URL you are using.)

Can you open a terminal (search terminal in spotlight)? Try typing
mysql -u root

It should start mysql and ask for a password for root, provided you specified 
one.

Peter

--
Peter West
p...@pbw.id.au
“Behold, I am the servant of the Lord; let it be to me according to your word.”

> On 10 Dec 2020, at 4:47 am, Ira Fuchs  wrote:
> 
> I have installed MySQL 8.0.22 on a Mac running Mojave (v10.14.6) with no 
> changes to any configuration file. I would like to save my GnuCash file to 
> this server but I am getting an error:
> 
> The server at URL mysql://root@localhost/gnucash 
>  experienced an error or encountered bad or 
> corrupt data.
> 
> What to 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.

___
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] bulk operations?

[Peter West]

There are a number of fields which are “descriptive” in one way or another, 
such that editing these fields outside Gnucash poses to risk to the integrity 
of the data. The developers know best which fields these are. A number of users 
have developed external means of editing databases (and I have done some ad hoc 
editing myself). It would be useful if the developers could list the database 
fields that are “safe”. I’m not suggesting this be put in the normal 
documentation, but that it be available somewhere for those who want to dig for 
it.
--
Peter West
p...@pbw.id.au
“After me comes he who is mightier than I, the strap of whose sandals I am not 
worthy to stoop down and untie.”

> On 8 Dec 2020, at 9:44 am, Adrien Monteleone  
> wrote:
> 
> Writing to the db is considered risky at this time. (and not supported) 
> Reading is fine though.
> 
> Regards,
> Adrien
> 
> On 12/7/20 5:21 PM, flywire wrote:
>>> * If it's not possible through the GUI, how about via issuing SQL
>> *>* statements to a database backend?*
>> *Seems reasonable.*
> 
> ___
> 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] entry point error after recent automatic windows 10 update

[Peter West]

Can someone who is running Windows 10 contact Laurel by Meet or Skype and get 
her to screen-share while she walks through the process? An experienced user 
may be able to spot a problem that an inexperienced user like Laurel is not 
noticing.

Peter

> On 27 Nov 2020, at 9:16 pm, Geert Janssens  wrote:
> 
> When uninstalling an reinstalling, be sure to remove directory
> C:\Progam Files(x86)\gnucash
> In between uninstalling and reinstalling.
> 
> We have encountered situations in the past where not all files from that 
> directory got properly removed which could lead to the error you are seeing.
> 
> Additionally, you may want to temporarily disable your anti-virus software 
> during the installation. That is also known to sometimes interfere with a 
> succesful install.
> 
> Regards, Geert
> 
> Derek Atkins  schreef op 26 november 2020 14:10:36 CET:
>> Hi Lauren,
>> Sorry you are having these issues.
>> I presume you are installing the official gnucash package that you 
>> downloaded from the links off www.gnucash.org?
>> Can you manually uninstall what you have installed, download the
>> package 
>> again, and reinstall it?
>> As others have said, there are many happy windows users, so it sounds
>> like 
>> something got corrupted on your system.
>> A full uninstall and reinstall should correct that.
>> Good luck!
>> 
>> -derek
>> Sent using my mobile device. Please excuse any typos.
>> On November 26, 2020 8:04:34 AM laurel hargis 
>> wrote:
>> 
>>> No I am not.
>>> 
>>> Thank you
>>> 
>>> On Wed, Nov 25, 2020 at 10:39 PM D. via gnucash-user <
>>> gnucash-user@gnucash.org> wrote:
>>> 
 Laurel,
 
 I'm sorry you're having these troubles. Many windows users (myself
 included) are successfully using gnucash on windows. A search online
>> showed
 several very old email threads with this error; however, they were
>> from
 users of a repackaged version of Gnucash from a group called
>> portableapps.
 
 Is it at all possible that yoga are trying to use a portable version
>> of
 Gnucash?
 
 David T.
 
 
  Original Message 
 From: nvsoar 
 Sent: Wed Nov 25 22:47:47 EST 2020
 To: gnucash-user@gnucash.org
 Subject: Re: [GNC] entry point error after recent automatic windows
>> 10
 update
 
 On 11/25/20 19:19, David Cousens wrote:
> Laurel,
> 
> Uninstalling and reinstalling the Windows 10 system should be a
>> last
 resort.
> 
> *Before you do that, at least make a copy of all the data files in
>> your
 user
> directory either on a USB stick or a copy to another computer*.
>> *Don't
 let a
> technician reinstall it without doing this first*. Your user files
>> will
 be
> stored in C:/Users// where you will need to
>> substitute
 your
> actual user name on the computer for the placeholder > name> in
 the
> above path.  Copy all files in that location onto a USB stick or
>> other
> medium before attempting a reinstall of Windows. You will then be
>> able to
> restore your user data files from the USB stick if you do have to
>> do a
> Windows reinstall and reinstall all programs.  That should prevent
>> any
 loss
> of data stored in the GNuCash files.
> 
> GnuCash 4.2 should not be looking for that file in that location
>> which
 may
> suggest that the initial install of GC 4.2 has perhaps not
>> completely
> removed all files from a previous version (which it should do
>> during the
> install procedure) and that an outdated dll file is being accessed
>> and in
> turn is looking for a routine in a dll which no longer exists. 
>> AFAIK
 there
> have been some rewrites of the GnuCash library files recently
>> which could
> lead to this.
> 
> You could also try making sure any subsequent Windows updates are
 installed
> and that Windows 10 itself is fully up to date.
> 
> Try manually removing GnuCash using the Control Panel  programs
>> tab
 before
> reinstalling GnuCash from a fresh download of 4.2. If old files
>> have not
> been removed properly this may unload them.
> 
> If that doesn't work I would then try reinstalling the version you
>> had
> previously and see if it works  Doing a manual uninstall of the
>> previous
> version  from the control panel after a reinstall of the old
>> version
 should
> then get rid of any previous program files which may have been
>> left in
> place.  Then follow that by reinstalling GC 4.2.
> 
> David
> 
> 
> 
> -
> David Cousens
> --
> Sent from:
 http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
 snip - I support the above approach suggested by David Cousens. FWIW
>> - I
 use the Revo Uninstaller because I found that the Windows
>> uninstaller
 still leaves stuff hanging around.  As for file finding I use an
 application 

Re: [GNC] List Replies

[Peter West]

Yes.
--
Peter West
p...@pbw.id.au
“Were not ten cleansed? Where are the nine?”

> On 16 Nov 2020, at 11:06 pm, Greg Feneis  wrote:
> 
> Hi friends,
> 
> A frequent encounter on this list is members replying to an email's
> originator and not to the list server.
> 
> In the grand scheme, not a big deal. However, other lists I belong to don't
> seem to have this issue.  I'm wondering if a list server setting could help.
> 
> For this other list I belong to, when I receive an email, it appears to
> come from the originator's name and email address.  But, no matter if I use
> reply, or reply-all, the initial email composition only ever begins with
> the list server as the only recipient.
> 
> I imagine this feature has to do with the construction of the email
> messages being sent from the server to the list members.
> 
> Could our mailman server be set to do the same thing?樂
> 
> Kind regards, Greg Feneis
> (Pixel 3)
> ___
> 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] Managing UK Gift-Aid

[Peter West]

Thank you Chris. Apostrophe pollution is uncontrolled. Where are the Apostrophe 
Police?

> On 29 Oct 2020, at 7:25 pm, Chris Green  wrote:
> 
>> 
>> I know there are other similar charity treasurer's hereabouts.
>> 
> Oops, the grocer's apostophe has appeared!
> 
> I know there are other similar charity treasurers hereabouts.
> 
> :-)
> 
> -- 
> Chris Green

___
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] ASX quotes not working

[Peter West]

--
Peter West
p...@pbw.id.au
“Woe to you lawyers also! For you load people with burdens hard to bear, and 
you yourselves do not touch the burdens with one of your fingers.”

It’s not strange, because %decoded_json is the name of a hash, a structure of 
key=>value pairs. A single “value” is a scalar, so to refer to that you must 
use a $, as in $decoded_json{key_value}. All scalars are referred to by $ It is curious that, although I have "$decoded_json", it is referring to 
> "%decoded_json".

I assume that this

Undefined subroutine ::Quote::ASX::asx called at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 604.

is happening because the module failed to compile.

This is happening

Global symbol "%decoded_json" requires explicit package name at 
C:/strawberry/perl/site/lib/Finance/Quote/ASX.pm line 138.

I think because the declaration at line 116 should be

my @decoded_json = eval{decode_json( $json )};

rather than
my $decoded_json = eval{decode_json( $json )};

peter

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

Re: [GNC] New User

[Peter West]

OSF?

Peter
--
Peter West
p...@pbw.id.au
“Woe to you lawyers also! For you load people with burdens hard to bear, and 
you yourselves do not touch the burdens with one of your fingers.”

> On 14 Oct 2020, at 5:42 am, Paul Konnersman  wrote:
> 
> I am a new user trying to run GnuCash 4.2 on a Mac PowerBook running MacOS
> 10.15.7. I did manage to get it running briefly, put my chart of accounts
> in manually and then tried to instal OSF using the OSF installation tool. I
> succeeded only in corrupting the file.
> 
> 
> I I wiped all GnuCash files from my PowerBook, ran disk utility twice and
> am now staring at the instructions in Read Me which is making my eyes
> cross. Any guidance would be greatly appreciated.
> 
> 
> 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
> 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] Issues with Balance Sheet report in 4.2

[Peter West]

> - "CoA" is an acronim for what ? 

Chart of Accounts

--
Peter West
p...@pbw.id.au
“‘Friend, how did you get in here without a wedding garment?’ And he was 
speechless.”

___
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] 8.1.1. Find Transaction

[Peter West]

Regular expressions are beautiful and powerful things. Perl (the language) was 
a laboratory for extending the reach of REs. In your travels you may come 
across PCRE regular expressions; that is Perl Compatible Regular Expressions. 
They are stunning.

Once you get the hang of even basic REs, you’ll wonder how you ever made do 
without them.

Make sure to get yourself a text editor with good RE support, because they are 
enormously useful for editing text.


--
Peter West
p...@pbw.id.au
“…whoever causes one of these little ones who believe in me to sin, it would be 
better for him to have a great millstone fastened around his neck and to be 
drowned in the depth of the sea.”

> On 4 Oct 2020, at 6:15 am, Michael or Penny Novack 
>  wrote:
> 
> On 10/3/2020 11:19 AM, David Carlson wrote:
>> We are't dead yet, and a couple of our approximate peers are actively 
>> seeking terms in the white house.  One of them having tested positive for 
>> Covid, hoping he will recover.
> 
> 
> I am going to add something. Matching strings using "regular expressions" is 
> VERY powerful. But as is common with powerful tools, there is a non-trivial 
> learning curve. It might not take you learn how to create the right regex for 
> simple matches. Then somewhat longer to ensure that they not only match what 
> you want them to (no misses) but also not match what anything else (false 
> positives). The latter is not so worrisome if you are just doing a "find", 
> then "find next" as you can skip over the "errors". But if that were a 
> find/replace operation ..
> 
> But it might take you a much longer time to learn to correctly match say "all 
> words starting with the letter "b", either upper lower case, second letter 
> lower case "e", and ending in "ing". Thus should match "being", "becoming", 
> "beekeeping", etc. but not "unbecoming" or "be thinking".
> 
> Expect to be testing/debugging your regular expressions, at least at the 
> start.
> 
> Michael D Novack
> 
> 
> 
> ___
> 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] clip board paste across catagories

[Peter West]

Or to put it another way, the list of components is:
Inches   On 1 Oct 2020, at 2:09 pm, Adrien Monteleone  
> wrote:
> 
> I've attached a screenshot to illustrate the different glyphs in another font.
> 
> The first part at the top, is a copy/paste directly from your list message 
> clearly showing different glyphs for various 'quotation' marks.
> 
> The font used is Times New Roman, and the app used is TextEdit.app on MacOS 
> 10.15, significantly enlarged for clarity.
> 
> (If mailman eats the attachment let me know and I'll use a 3rd party link.)
> 
> It is plain to see that the glyphs to the right of the '3' and '6' inch 
> measurements are 'right double quotes' and the glyphs to the right of the 
> '0.25' and '0.5' feet measurements are the 'left single quote' and 'right 
> single quote' respectively. (which should at the least be consistent, also 
> notice the errant spacing after the 0.25) The vertical positioning and 
> curvature of the glyph is determining if it is a 'right' or 'left' quote. One 
> can also see that the glyphs to the *left* of the '6' and the '0' feet/inch 
> measurements and the *right* of the 'p' in "strap" are 'double quotation 
> marks' and thus serve as delimiters of a *quoted text field*.
> 
> The other glyphs in between those *double quotation marks* are not 
> delimiters, thus they don't separate the data in a CSV to another 
> field/column. (even the comma contained therein will not, because it lies 
> between the quotes)



--
Peter West
p...@pbw.id.au
“The kingdom of heaven is like treasure hidden in a field, which a man found 
and covered up. Then in his joy he goes and sells all that he has and buys that 
field.”

___
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] Shortcuts and Sorts

[Peter West]

About auto-fill:

I have half a dozen categories for my grocery shopping, plus cleaning and 
household utensils that I can buy at the same supermarkets. I shop frequently, 
and I don’t buy big amounts, so there is a lot of variability. Putting the 
supermarket name into the initial Memo field brings up the last split, which is 
always wrong. So now, I just put a dummy value in there, and start with the 
total credit amount and account. If I’m disciplined about my descriptions, I 
get the split account filled out for me, which is handy, and I then just have 
to change the amount if necessary.

Some time after entering the credit, I can correct the memo entry. For example, 
my local supermarket is “Coles F.G.”. I just enter “Coles”, and I can go back, 
inset a space after “Coles”, and “F.G.” is auto-filled. Tab, Enter.

So, it’s a mixed blessing, but overall a time saver.

Peter

--
Peter West
p...@pbw.id.au
“For what will it profit a man if he gains the whole world and forfeits his 
soul?”

> On 24 Sep 2020, at 4:48 am, Walter Busch  wrote:
> 
> Have two questions.
> 
> In Quicken I could sort by the reconcile column, but don’t find that in this 
> program.
> 
> In Quicken I could stop autofill (shortcuts) I don’t write checks or entries 
> for the same amount all the time.  It is stupid to think that I go to the 
> grocery store and I buy something for exactly the same price each time.  Or 
> that my electric bill is the same every month.  It takes me more time to 
> correct the autofilled amounts.  How do I turn this off?  I can’t find that 
> in the help.
> 
> Otherwise, I really like the program over Quicken.  I was using an older 
> version of it and they now want to charge every year for personal use if I 
> update the program.  I don’t want to pay money each year for any program for 
> personal use.  One time, yes.
> 
> Thank you for the program and please help.  If these aren’t options, can they 
> be in a future release?
> Walt
> 
> Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10
> 
> ___
> 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] Help - entering opening balances

[Peter West]

I should add, that the transactions will be, e.g.,
Debit:Assets:Savings$
Credit:Equity:Opening Balances  $

Peter
--
Peter West
p...@pbw.id.au
“Stretch out your hand.” And he did so, and his hand was restored. But they 
were filled with fury…

> On 8 Sep 2020, at 11:01 pm, Peter West  wrote:
> 
> Hi Chris,
> 
> Don’t create accounts under Equity. Create your savings and current account 
> under Assets. Then enter your opening balances as Stan Brown describes.
> 
> Peter
> --
> Peter West
> p...@pbw.id.au
> “Stretch out your hand.” And he did so, and his hand was restored. But they 
> were filled with fury…
> 
>> On 8 Sep 2020, at 10:52 pm, Chris Green  wrote:
>> 
>> I am at the stage of lots of rude words at the moment! :-)
>> 
>> I am just starting to try and set up GnuCash for the PCC accounts and
>> I've fallen at the first hurdle.  I can't work out how to enter
>> opening balances for the two accounts we have - a current account and
>> a savings account (which is basically the building fund).
>> 
>> I have to say at present the help system is worse than useless, maybe
>> I'll get used to it later but it really doesn't help at all at this
>> beginner level.
>> 
>> A search for 'opening balance' in the Tutorial and Concepts Guide
>> always takes me back to the top level whereas I want to search within
>> a section.  HOw do I search for 'opening balance' in the Managing
>> Business Finances section?
>> 
>> So, ignoring the help system, how do I enter an Opening Balance?
>> There's a section in accounts under 'Equity' for opening balances and
>> I tried creating two accounts under that and entering balances but the
>> result made no sense at all to me.  Having entered an opening balance
>> I'd expect the balance sheet to show me that amount but GnuCash just
>> did a decrease and a balancing increase in the Equity account which
>> doesn't really make much sense.
>> 
>> 
>> -- 
>> Chris Green
>> ___
>> 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] Help - entering opening balances

[Peter West]

Hi Chris,

Don’t create accounts under Equity. Create your savings and current account 
under Assets. Then enter your opening balances as Stan Brown describes.

Peter
--
Peter West
p...@pbw.id.au
“Stretch out your hand.” And he did so, and his hand was restored. But they 
were filled with fury…

> On 8 Sep 2020, at 10:52 pm, Chris Green  wrote:
> 
> I am at the stage of lots of rude words at the moment! :-)
> 
> I am just starting to try and set up GnuCash for the PCC accounts and
> I've fallen at the first hurdle.  I can't work out how to enter
> opening balances for the two accounts we have - a current account and
> a savings account (which is basically the building fund).
> 
> I have to say at present the help system is worse than useless, maybe
> I'll get used to it later but it really doesn't help at all at this
> beginner level.
> 
> A search for 'opening balance' in the Tutorial and Concepts Guide
> always takes me back to the top level whereas I want to search within
> a section.  HOw do I search for 'opening balance' in the Managing
> Business Finances section?
> 
> So, ignoring the help system, how do I enter an Opening Balance?
> There's a section in accounts under 'Equity' for opening balances and
> I tried creating two accounts under that and entering balances but the
> result made no sense at all to me.  Having entered an opening balance
> I'd expect the balance sheet to show me that amount but GnuCash just
> did a decrease and a balancing increase in the Equity account which
> doesn't really make much sense.
> 
> 
> -- 
> Chris Green
> ___
> 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] Asset accounts: cost, or value?

[Peter West]

In my neck of the woods, sale prices of houses are recorded with the records of 
change of ownership. Sale values may not be available until some time after the 
sale, but they will appear. Online real estate sites can tell you the history 
of sales and sale prices in whatever area you are interested in. You can 
therefore get a reasonable idea of what is happening to values in your area.

If the purpose of your personal accounts is to inform you – not some external 
authority – of your equity standing, is it better to stick to the purchase 
price of an asset you may have had for a decade or more, or to include an 
estimate of the sale value of the property? In any case, external authorities 
are likely to want an estimate of current market value.

Any corporation that does NOT provide estimates of appreciation or depreciation 
of capital resources is not reporting accurately, as far as I can tell.

--
Peter West
p...@pbw.id.au
“Ha! What have you to do with us, Jesus of Nazareth? Have you come to destroy 
us? I know who you are—the Holy One of God.”

> On 2 Sep 2020, at 10:28 pm, Marcus Winston  
> wrote:
> 
> OK, Thanks. So the "balance" in the asset account would reflect the cost of 
> the asset, not its value. That's fine, and is what I concluded also.
> 
> Next question: When I sell the house, I'm adding the costs to sell the house 
> (title insurance, reconveyance fees, etc) to the cost of the house itself. In 
> other words, this will increase the bottom line on the fixed asset "House" 
> account. For two-column accounting, where does that money come from (what's 
> the other account)? I tried using an equity account, but then I end up with a 
> positive equity value on the house after I sell it, and that doesn't make 
> sense (I think I should have zero equity in the house once it's sold).
> 
> MW
> 
> On 9/1/20 10:38 PM, Stan Brown wrote:
>> On 2020-09-01 19:49, Marcus Winston wrote:
>>> I had thought that the Assets:Fixed assets:House would reflect the value of
>>> the house. But after putting the purchase price of the house, and then
>>> adding the costs to purchase (recording fees, appraisal, etc), I conclude
>>> that the House account actually reflects the total cost of the house, and
>>> not necessarily its value. First question: is that a correct view of the
>>> Assets:Fixed assets:House1 account?
>> Any tracking of value that you might do would be mere speculation. Even
>> an appraisal is no indication of how much your house is really worth:
>> both when I moved earlier this year both houses' appraisals were about
>> 20% different from the selling price.
>> 
>> Valuing assets on a balance sheet at somebody's guess of what they're
>> worth, known as "writing to market", is part of shady accounting
>> practices and, if I'm not mistaken, partly responsible for the real
>> estate crash of 2008-2011. Don't do it!
>> 
>> And of course for tax purposes, as you indicated, you _have_ to work
>> from actual costs, not from guesses about value. Keeping your books on a
>> cost basis will make that less difficult when you make out your tax returns.
>> 
> ___
> 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] help increasing size of font in GnuCash?

[Peter West]

Yes, I have discovered that. I’m very pleased that D. found the reference 
before I had to go hunting for it again.

The wiki is clearly wrong (and it is the Gnucash wiki). If that location 
applies to all GTK apps, I would assume that, in the absence of 
Gnucash-specific override, it will work for GC. Similarly, in the absence of 
gtk-3.0.css, gtk.css will work. It doesn’t.

I take it that either GTK configuration is buggy, or is being overridden in an 
unusual way within the code; unusual in that some configuration escapes and is 
available to users.

Should I set up a bugzilla account, or will someone else report this 
documentation inconsistency?

Peter
--
Peter West
p...@pbw.id.au
“O woman, great is your faith! Be it done for you as you desire.” And her 
daughter was healed instantly.

> On 18 Aug 2020, at 4:56 am, Adrien Monteleone 
>  wrote:
> 
> Peter,
> 
> If you read the Wiki carefully, you'll see that the `~/.local/share/gtk-3.0` 
> location is for all GTK apps, not just GnuCash. The GTK theme may conflict 
> and your customization may not override the theme in some cases. (note, the 
> Wiki also notes that `gtk-3.0.css` will override `gtk.css`)
> 
> The proper location to customize the GnuCash UI via CSS is:
>  ~/Library/Application Support/GnuCash
> 
> Regards,
> Adrien
> 
> On 8/16/20 1:47 AM, Peter West wrote:
>>> On 16 Aug 2020, at 1:29 pm, Adrien Monteleone 
>>>  wrote:
>> …
>>> The file should be named:
>>> 
>>>  gtk-3.0.css
>> That’s why I couldn’t get mine to work in either location. I was using 
>> gtk.css.
>> I can say that the location ~/.local/share/gtk-3.0/gtk-3.0.css does NOT 
>> work, in spite of the wiki.
>>> 
>>> The location should be:
>>> 
>>>  ~/Library/Application Support/GnuCash
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists 
> <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] help increasing size of font in GnuCash?

[Peter West]

> On 16 Aug 2020, at 1:29 pm, Adrien Monteleone 
>  wrote:
…
> The file should be named:
> 
>  gtk-3.0.css

That’s why I couldn’t get mine to work in either location. I was using gtk.css.

I can say that the location ~/.local/share/gtk-3.0/gtk-3.0.css does NOT work, 
in spite of the wiki.
> 
> The location should be:
> 
>  ~/Library/Application Support/GnuCash


--
Peter West
p...@pbw.id.au
“O woman, great is your faith! Be it done for you as you desire.” And her 
daughter was healed instantly.

___
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] help increasing size of font in GnuCash?

[Peter West]

As I read that note, .local only came into play with GTK3.0 and up. Maybe 
backward compatibility is supported, or maybe the files were just copied into 
that location.

On my Mac, running Gnucash for about a year now, !/.local/share exists, but 
only contains files from other applications.


> On 15 Aug 2020, at 7:55 pm, Adrien Monteleone 
>  wrote:
> 
> Strange. I was using 2.6 on this Mac originally and I never had .local being 
> used for it. I've always had to work with the other location.
> 
> Regards,
> Adrien
> 
> On 8/15/20 4:41 AM, Peter West wrote:
>> This is from the configuration locations page in the wiki: 
>> https://wiki.gnucash.org/wiki/Configuration_Locations 
>> <https://wiki.gnucash.org/wiki/Configuration_Locations>
>> macOS
>> HOME 
>> <https://wiki.gnucash.org/wiki/Configuration_Locations#HOME>/Library/Application
>>  Support/Gnucash
>> For GnuCash 3.0 and up, these files have been moved to different locations 
>> to integrate better with each supported platform's recommended locations. 
>> When moving from GnuCash 2.6 to 3.x or above, GnuCash will automatically try 
>> to migrate all data from DOT_GNUCASH_DIR to their respective new locations. 
>> After mitgration, GnuCash 3.0 or above should never use DOT_GNUCASH_DIR 
>> again.
>> Peter
> 
> ___
> 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] help increasing size of font in GnuCash?

[Peter West]

This is from the configuration locations page in the wiki: 
https://wiki.gnucash.org/wiki/Configuration_Locations 
<https://wiki.gnucash.org/wiki/Configuration_Locations>

macOS
HOME 
<https://wiki.gnucash.org/wiki/Configuration_Locations#HOME>/Library/Application
 Support/Gnucash
For GnuCash 3.0 and up, these files have been moved to different locations to 
integrate better with each supported platform's recommended locations. When 
moving from GnuCash 2.6 to 3.x or above, GnuCash will automatically try to 
migrate all data from DOT_GNUCASH_DIR to their respective new locations. After 
mitgration, GnuCash 3.0 or above should never use DOT_GNUCASH_DIR again.

Peter


> On 15 Aug 2020, at 7:18 pm, Adrien Monteleone 
>  wrote:
> 
> In which case, TextEdit.app should work just fine saving in plain text.
> 
> The file should be stored in ~/Library/Application Support/Gnucash
> 
> Regards,
> Adrien
> 
> On 8/14/20 10:01 PM, Peter West wrote:
>> I think Marilyn is on a Mac.
>> Peter
> 
> ___
> 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] help increasing size of font in GnuCash?

[Peter West]

Oops,

Looks as though it’s now gtk4.

If so, substitute gtk-4.0 for all occurrences of gtk-3.0, if this is 
consistent. Someone else will tell you the correct folder name for Gnucash 4.

Peter
--
Peter West
p...@pbw.id.au
“My soul magnifies the Lord, and my spirit rejoices in God my Savior…”

> On 15 Aug 2020, at 1:56 pm, Peter West  wrote:
> 
> Marilyn,
> 
> You’re on a recent Mac, so don’t worry about line endings. They should 
> default to unix endings (that is a LineFeed only).
> 
> Your .css configuration will go into a subdirectory of your home directory, 
> which is, say /Users/marilyn, but whatever your actual home directory is.
> 
> Here’s a diagram. You need the GTK_DTA_HOME folder.
> 
> https://lists.gnucash.org/wiki/Configuration_Diagrams_-_MacOS 
> <https://lists.gnucash.org/wiki/Configuration_Diagrams_-_MacOS>
> 
> 
> 1. Open a new Finder window. Your home diectory (say Marilyn) will probably 
> be at the top of your Favourites. In that window, press Shift-Command-.
> (period or full-stop) simultaneously. You should see a number of files with 
> names starting with . (dot). These are called dotfiles or hidden files. 
> Scroll through them. Do you have a .local folder? If so, open it up. Do you 
> have a folder called ‘share'? If so, go to 4. If not, go to 3.
> 
> 2. If not create a new folder (Shift-Cmd-N) and call it .local. You will be 
> warned about creating a dotfile. Go ahead.
> 3. Open that folder (double click on .local), and create a new folder called 
> share (all lower case.) 
>Open ’share’ by double clicking. Create a new folder and call it gtk-3.0
>   That’s where the .css file goes.
> 
> 4. Double click on ’share’ to open it. Do you have a folder called gtk-3.0? 
> If so, that’s where the .css file goes.
>   Otherwise create a folder called gtk-3.0
> 
> Press Shift-Command-. again to remove dotfiles from the Finder display.
> 
> 
> Peter
> 
> 
>> On 15 Aug 2020, at 9:58 am, Marilyn Graves Kimple via gnucash-user 
>>  wrote:
>> 
>> You guys lost me at GTK. I am definitely out of my league here.*I 
>> can certainly create a .css file but where do I put it? It sounds like there 
>> is supposed to be one somewhere.
>> **I am running GnuCash 4.1 on MacOSX 10.14.6. There is no GnuCash 
>> folder in my HOME/Library/Application Support. I looked at the package 
>> contents for the .app but I don't think that is what I am supposed to mess 
>> with.I have never done any Linux/Unix and know nothing about special 
>> line endings.
>> 
>> Thanks,mgk
>>   On Friday, August 14, 2020, 07:21:31 PM EDT, 
>> gnucash-user-requ...@gnucash.org  wrote:  
>> Message: 9
>> Date: Fri, 14 Aug 2020 22:52:53 + (UTC)
>> From: Marilyn Graves Kimple 
>> To: "GTI .H" 
>> Thanks. This looks pretty scary but I will study on it. I used to code 
>> HTML/CSS and I vaguely remember doing some DOS. I am a Mac person and don't 
>> remember the last time I used the Console.
>> Best regards,mgk
>> 
>>On Friday, August 14, 2020, 10:53:35 AM EDT, GTI .H  
>> wrote:  
>> 
>> Here's how to do it:
>> https://wiki.gnucash.org/wiki/GTK3#Visual_Styling
>> 
>> 
>> Is there a way to customize the font size in GnuCash? I do not have an easy 
>> time reading screens and I also have arthritis in my hands, which means I 
>> need a bigger target for my cursor. I looked at the documentation and all I 
>> could find was a style sheet for reports. My built-in Mac tricks for screen 
>> reading (control+, track pad motions) do not work with GnuCash.
>> Thanks--?Marilyn Graves Kimple
>> 
>> 
>> --
>> 
>> Message: 10
>> Date: Fri, 14 Aug 2020 17:57:54 -0500 (CDT)
>> From: Jimmy R 
>> 
>> This will get you there fast
>> 
>> gtk.css
>> 
>> /* Application wide font setting */
>> * {
>>  font: 16px arial;
>> }
>> 
>> --
>> 
>> Message: 11
>> Date: Fri, 14 Aug 2020 18:19:43 -0500
>> From: Adrien Monteleone 
>> 
>> Subject: Re: [GNC] help increasing size of font in GnuCash?
>> No console work necessary. Not sure what OS you are on, but just use 
>> your favorite text editor, but be sure to use Linux/Unix line endings. 
>> (some versions of Notepad I think use Windows endings) And of course 
>> save in plain text, not rich text or anything formatted.
>> 
>> Create a file called gtk-3.0.css containing at the least:
>> 
>> * {
>>  font-size: 16px;
>> }
>> 
>> This will of course aff

Re: [GNC] help increasing size of font in GnuCash?

[Peter West]

Marilyn,

You’re on a recent Mac, so don’t worry about line endings. They should default 
to unix endings (that is a LineFeed only).

Your .css configuration will go into a subdirectory of your home directory, 
which is, say /Users/marilyn, but whatever your actual home directory is.

Here’s a diagram. You need the GTK_DTA_HOME folder.

https://lists.gnucash.org/wiki/Configuration_Diagrams_-_MacOS 



1. Open a new Finder window. Your home diectory (say Marilyn) will probably be 
at the top of your Favourites. In that window, press Shift-Command-.
(period or full-stop) simultaneously. You should see a number of files with 
names starting with . (dot). These are called dotfiles or hidden files. Scroll 
through them. Do you have a .local folder? If so, open it up. Do you have a 
folder called ‘share'? If so, go to 4. If not, go to 3.

2. If not create a new folder (Shift-Cmd-N) and call it .local. You will be 
warned about creating a dotfile. Go ahead.
3. Open that folder (double click on .local), and create a new folder called 
share (all lower case.) 
Open ’share’ by double clicking. Create a new folder and call it gtk-3.0
That’s where the .css file goes.

4. Double click on ’share’ to open it. Do you have a folder called gtk-3.0? If 
so, that’s where the .css file goes.
Otherwise create a folder called gtk-3.0

Press Shift-Command-. again to remove dotfiles from the Finder display.


Peter


> On 15 Aug 2020, at 9:58 am, Marilyn Graves Kimple via gnucash-user 
>  wrote:
> 
> You guys lost me at GTK. I am definitely out of my league here.*I can 
> certainly create a .css file but where do I put it? It sounds like there is 
> supposed to be one somewhere.
> **I am running GnuCash 4.1 on MacOSX 10.14.6. There is no GnuCash 
> folder in my HOME/Library/Application Support. I looked at the package 
> contents for the .app but I don't think that is what I am supposed to mess 
> with.I have never done any Linux/Unix and know nothing about special 
> line endings.
> 
> Thanks,mgk
>On Friday, August 14, 2020, 07:21:31 PM EDT, 
> gnucash-user-requ...@gnucash.org  wrote:  
> Message: 9
> Date: Fri, 14 Aug 2020 22:52:53 + (UTC)
> From: Marilyn Graves Kimple 
> To: "GTI .H" 
> Thanks. This looks pretty scary but I will study on it. I used to code 
> HTML/CSS and I vaguely remember doing some DOS. I am a Mac person and don't 
> remember the last time I used the Console.
> Best regards,mgk
> 
> On Friday, August 14, 2020, 10:53:35 AM EDT, GTI .H  
> wrote:  
> 
> Here's how to do it:
> https://wiki.gnucash.org/wiki/GTK3#Visual_Styling
> 
> 
> Is there a way to customize the font size in GnuCash? I do not have an easy 
> time reading screens and I also have arthritis in my hands, which means I 
> need a bigger target for my cursor. I looked at the documentation and all I 
> could find was a style sheet for reports. My built-in Mac tricks for screen 
> reading (control+, track pad motions) do not work with GnuCash.
> Thanks--?Marilyn Graves Kimple
>   
> 
> --
> 
> Message: 10
> Date: Fri, 14 Aug 2020 17:57:54 -0500 (CDT)
> From: Jimmy R 
> 
> This will get you there fast
> 
> gtk.css
> 
> /* Application wide font setting */
> * {
>   font: 16px arial;
> }
> 
> --
> 
> Message: 11
> Date: Fri, 14 Aug 2020 18:19:43 -0500
> From: Adrien Monteleone 
> 
> Subject: Re: [GNC] help increasing size of font in GnuCash?
> No console work necessary. Not sure what OS you are on, but just use 
> your favorite text editor, but be sure to use Linux/Unix line endings. 
> (some versions of Notepad I think use Windows endings) And of course 
> save in plain text, not rich text or anything formatted.
> 
> Create a file called gtk-3.0.css containing at the least:
> 
> * {
>   font-size: 16px;
> }
> 
> This will of course affect every single text element of the UI, like a 
> magnifying glass.
> 
> Since you know CSS, you know you can play with the 16 and the px unit. 
> (not all Web CSS is recognizable in GTK, but much of it is)
> 
> That wiki page goes into more detail about where to save the file, and 
> what else you can put in it. (to target certain parts of the UI rather 
> than using the "*" sledgehammer.
> 
> 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.

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

Re: [GNC] Print to file Vs Make Pdf

[Peter West]

On Mac, the system print dialogue includes a write to PDF option, and you can 
install a CUPS-PDF printer driver. I think there are alternatives as well. 
Microsoft used to have a Microsoft Print to PDF option for its printer drivers.

Depending on you OS, install one of these, and specify it as you default 
printer before starting your print from Gnucash.

Peter
--
Peter West
p...@pbw.id.au
“My soul magnifies the Lord,
and my spirit rejoices in God my Savior…”

> On 14 Aug 2020, at 6:15 pm, Glen Hawksworth  wrote:
> 
> Thanks for the info.
> 
> On Fri, 14 Aug 2020, 6:14 pm Geert Janssens, 
> wrote:
> 
>> Hi Glen,
>> 
>> 
>> 
>> The change in behaviour comes with the upgrade to webkit2 (which was
>> forced on us due to deprecation of webkit1 on linux distros).
>> 
>> 
>> 
>> The newer webkit2 no longer provides the option to generate a pdf directly
>> from a report. So as a workaround we chose to fall back to opening the
>> print dialog. As this was essentially just replicating the print option
>> itself, the make pdf option has been removed in later versions. It may
>> still be in 3.4, but somewhere in the 3.x series it got completely removed.
>> 
>> 
>> 
>> It is a loss of functionality unfortunately, but it would take more effort
>> to work around this than any of the contributors has been willing to spend
>> on it so far. We did look, but didn't find an easy solution.
>> 
>> 
>> 
>> Regards,
>> 
>> 
>> 
>> Geert
>> 
>> 
>> 
>> Op vrijdag 14 augustus 2020 04:40:19 CEST schreef glenhawx:
>> 
>>> TL:DR - Linux Version of GnuCash v3.4: "Print" and "Make PDF" now do the
>> 
>>> same thing on my new install. Do I need an extra plugin or something so
>> 
>>> that "Make PDF" saves directly to pdf without "printing" and generates a
>> 
>>> filename from the Invoice number and date? (like it used to for me )
>> 
>>> 
>> 
>>> Hi to all my "Gnu" friends,
>> 
>>> I recently needed to reinstall GnuCash on a fresh install of linux on my
>> 
>>> chromebook (I have been using GnuCash on my chromebook for about a year
>> and
>> 
>>> a half) and I'm having some issues with the "Make PDF" feature.
>> Previously
>> 
>>> if I clicked "Make Pdf" it would immediately open up a save to PDF dialog
>> 
>>> with the filename generated like this...
>> 
>>> Invoice-000125-07_13_2020.pdf
>> 
>>> ...and then I could append the file name like this...
>> 
>>> Invoice-000125-07_13_2020-Geoff-ZoomaxPart.pdf
>> 
>>> ...to make it more friendly.
>> 
>>> However on my new install, "Make Pdf" does the same thing as "Print",
>> 
>>> allowing me to print to file but with the default name of "output.pdf".
>> 
>>> I have tried to find a solution online and by tinkering for a few days
>> now
>> 
>>> and I'm stuck. I thought maybe I was missing a dependency or something
>> but I
>> 
>>> couldn't figure out what it might be.
>> 
>>> I knew that LibreOffice had a similar PDF export feature so I tried
>> 
>>> installing that. The "export as PDF" worked as expected but still not in
>> 
>>> GnuCash.
>> 
>>> I tried uninstalling and reinstalling GnuCash with LibreOffice installed
>> but
>> 
>>> still no go.
>> 
>>> Has anyone experienced this issue and/or know what I need to do?
>> 
>>> Regards,
>> 
>>> Glen
>> 
>>> 
>> 
>>> 
>> 
>>> 
>> 
>>> --
>> 
>>> 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.

___
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] envelope method, equity sub-accounts, cash vs. hybrid vs. accrual accounting

[Peter West]

Thanks to Colin and Adrian for their advice on this.

Peter
___
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] help increasing size of font in GnuCash?

[Peter West]

I think Marilyn is on a Mac.

Peter
--
Peter West
p...@pbw.id.au
“For where two or three are gathered in my name, there am I among them.”

> On 15 Aug 2020, at 9:19 am, Adrien Monteleone 
>  wrote:
> 
> No console work necessary. Not sure what OS you are on, but just use your 
> favorite text editor, but be sure to use Linux/Unix line endings. (some 
> versions of Notepad I think use Windows endings) And of course save in plain 
> text, not rich text or anything formatted.
> 
> Create a file called gtk-3.0.css containing at the least:
> 
> * {
>  font-size: 16px;
> }
> 
> This will of course affect every single text element of the UI, like a 
> magnifying glass.
> 
> Since you know CSS, you know you can play with the 16 and the px unit. (not 
> all Web CSS is recognizable in GTK, but much of it is)
> 
> That wiki page goes into more detail about where to save the file, and what 
> else you can put in it. (to target certain parts of the UI rather than using 
> the "*" sledgehammer.
> 
> Regards,
> Adrien
> 
> On 8/14/20 5:52 PM, Marilyn Graves Kimple via gnucash-user wrote:
>>  Thanks. This looks pretty scary but I will study on it. I used to code 
>> HTML/CSS and I vaguely remember doing some DOS. I am a Mac person and don't 
>> remember the last time I used the Console.
>> Best regards,mgk
>> On Friday, August 14, 2020, 10:53:35 AM EDT, GTI .H  
>> wrote:
>>Here's how to do it:
>> https://wiki.gnucash.org/wiki/GTK3#Visual_Styling
>>  --
>> RegardsGTI
>> Em sex., 14 de ago. de 2020 às 09:35, Marilyn Graves Kimple via gnucash-user 
>>  escreveu:
>> Is there a way to customize the font size in GnuCash? I do not have an easy 
>> time reading screens and I also have arthritis in my hands, which means I 
>> need a bigger target for my cursor. I looked at the documentation and all I 
>> could find was a style sheet for reports. My built-in Mac tricks for screen 
>> reading (control+, track pad motions) do not work with GnuCash.
>> Thanks-- Marilyn Graves Kimple
> 
> ___
> 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] envelope method, equity sub-accounts, cash vs. hybrid vs. accrual accounting

[Peter West]

I use envelope budgeting, with one actual bank account, represented in Gnucash 
by multiple subaccounts. The account summary shows me the total amount in the 
actual account, which I can check against the balance of that account. I have 
scheduled transactions in Gc that deduct from my usual cash account (which is 
different again) into the subaccounts. At the bank, I have scheduled transfers 
that make those deductions from my cash account to my (single) budget account. 
When I know a bill is due, I schedule a payment at the bank from my single 
budget account, and likewise schedule a transaction in Gc.

The difficulties come in “reconciling” the budget accounts with the bank budget 
account. My accounts are set up so that the parent budget account shows the 
total of the subaccounts, but does not show the transactions. I may be able to 
make it do this, at least while “reconciling,” but I haven’t looked into it 
that far. So I hav to work from multiple Gc accounts against the single bank 
statement, which is a pain. However, as these are regular payments, that’s not 
so bad.

Incidentally, I use the scare quotes because I do not use Gc’s reconciliation 
mechanism. I started to look at it once, and it seemed incompatible with the 
way I was doing things. Now I reconcile manually against the statements by 
setting the cleared marker on the individual Gc transactions and then working 
out which ones I have forgotten to enter. I try to do entry regularly – ideally 
every evening – from the receipts I have collected during the day, including 
online receipts.

Obviously, only budgeted payments come out of the budget account. If I have to 
raid the budget, I’m living beyond my means. Confer with Mr Micawber. The whole 
point about having such a budget is that you don’t raid it. If you do, you’re 
stuffed, financially speaking. 

With those caveats, envelope budgeting works for me.




> On 14 Aug 2020, at 5:26 am, Don Ireland  wrote:
> 
> "I don't see how the envelope method of budgeting is somehow not compatible 
> with double-entry. One split will be the expenditure, the other will be the 
> appropriate envelope. Filling the envelopes involves splits between 
> cash-on-hand and the various envelopes. Double entry is certainly not 
> difficult or incompatible with the method."
> 
> When you "move money" to deposit into those envelopes, it will mess up the 
> transaction list on the checking/savings account that will continue to "hold" 
> those funds until you actually spend the money.  So it breaks in that sense.
> 
> On August 13, 2020 2:07:48 PM CDT, Adrien Monteleone 
>  wrote:
>> On 8/12/20 4:34 PM, doncram wrote:
>>> The documentation (GnuCash Tutorial and Concept Guide's
>>> chapter 14 on Budgets and its section on budget reports within
>> chapter 10
>>> Reports)  doesn't go very far yet.
>> 
>> This is certainly true, as can be found many times on this list, 
>> "Contributions welcome."
>> 
>>> It doesn't mention any report showing
>>> Budget vs. Actual amounts for a given period, but I assume something
>> like
>>> that must exist.
>> 
>> Did you run a report and investigate the options? Simply doing so would
>> 
>> have saved you typing a paragraph.
>> 
>> The Budget report has the Actual and Difference columns as an option.
>> 
>> Percentages would be nice, but you'll have to export to a spreadsheet 
>> for now.
>> 
>> 
>>> About implementing some "envelope method" approach, I think that
>> would be
>>> very radical, and that it would not be reasonable to devote
>> programming
>>> effort to it before it was proven to be useful in real life. I
>> haven't see
>>> it demonstrated in a spreadsheet-based example, even.  Are there
>> such?
>> 
>> Don't be lazy. A simple web search will reveal plenty of example sheets
>> 
>> you can download.
>> 
>> There are also apps which follow this. (you already know of YNAB) I've 
>> played with MoneyWell (Mac only) and while I like how it works, I kept 
>> coming back to GnuCash. Since both can integrate through import-export,
>> 
>> I may investigate using MoneyWell for day-to-day expenditures and 
>> budgeting, then exporting into GnuCash for my full accounting. That 
>> would solve my data-entry 'virtual account dance' that is required to 
>> use this method with GnuCash alone.
>> 
>> 
>>> but it sounds like it is meant as a thing for a firm which does not
>> have
>>> double-entry bookkeeping.  
>> 
>> I don't see how the envelope method of budgeting is somehow not 
>> compatible with double-entry. One split will be the expenditure, the 
>> other will be the appropriate envelope. Filling the envelopes involves 
>> splits between cash-on-hand and the various envelopes. Double entry is 
>> certainly not difficult or incompatible with the method.
>> 
>> 
>> If it is a thing, I suspect it is only a thing
>>> for entities like households that wouldn't be using GnuCash.
>> 
>> Again, I don't see this limitation at all. Why wouldn't a household use
>> 
>> GnuCash and 

Re: [GNC] GNU cash blocked-Why?

[Peter West]

That’s interesting. This is the symptom that my brother-in-law was seeing.



> On 4 Aug 2020, at 10:58 pm, Kothandaraman  wrote:
> 
> Dear Sir
> Thank you for your mail.
> See attachment. It goes on repeating.
> 
> Assuring you of our best services always
> Thanking you
> Yours truly
> KOTHANDARAMAN.V
> **
> We received mail:
> 
> 
> On Tue, Aug 4, 2020 at 6:20 PM Frank H. Ellenberger <
> frank.h.ellenber...@gmail.com > wrote:
> 
>> Kothandaraman,
>> 
>> please be more specific about what you are trying to do:
>> Access to the mailing list, website, …
>> running gnucash (which version and Operating system),
>> something else?
>> 
>> Describe your steps before the blocking and any messages about it.
>> 
>> Regards
>> Frank
>> 
>> 
>> Am 04.08.20 um 12:10 schrieb Kothandaraman:
>>> Dear Sir
>>> My user id is
>>> rojar...@gmail.com.
>>> I had subscribed and using for over a year.
>>> Now it is not working.
>>> What to do?
>>> Kothandaraman
>>> 
>>> Carlyle said: Make yourself an honest man, and then you may be sure there
>>> is one less rascal in the world.
>>> *'Work is Worship, Customer is God'; The Mumbai Dabbawallas' Sure Shot
>>> Formula for Success*
>>> **
>>> :
>> 
>> 
>  found.jpg>___
> 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] Installing on Windows 10 (with Defender)

[Peter West]

Thank you all.

I will recommend that Rob join the mailing list. I’m on Mac, but I got a 
1-month VMware Fusion copy and a Windows 10 freebie (yes, they do exist), and I 
tried it myself. Sure enough, I installed and ran the program without a problem.

My next step is to walk him through an install using the screen share facility 
of hangouts. We’ll see how that goes.

Many thanks.
--
Peter West
p...@pbw.id.au
When he went ashore he saw a great crowd, and he had compassion on them and 
healed their sick.

> On 4 Aug 2020, at 9:50 am, David H  wrote:
> 
> I also use Gnucash on a couple of installs of Windows 10 Pro and have Windows 
> Defender running.  My update/install process is to download the Gnucash 
> setup.exe, right click on it and display properties and then click the 
> Unblock checkbox and then simply double click on the .exe file and click OK 
> when necessary to allow the install or update to proceed.  My file size on 
> Windows is 141 MB (148,789,209 bytes) and I would expect your downloaded file 
> to be the same.
> 
> I'm with nvsoar on this one and think you need to download the Gnucash 
> setup.exe file again and make sure the download completes ok, then try the 
> re-install again.  Either manually uninstall the currently installed Gnucash 
> or let the new install uninstall the current version for you - it'll prompt 
> you to uninstall the currently installed version.
> 
> Regards David H.
> 
> On Tue, 4 Aug 2020 at 04:26, nvsoar  <mailto:nvs...@charter.net>> wrote:
> On 08/03/20 08:06, GTI .H wrote:
> > Em seg., 3 de ago. de 2020 às 00:41, Peter West  > <mailto:li...@pbw.id.au>> escreveu:
> >
> >> My brother-in-law in the US (I’m in Oz) tried on my recommendation to
> >> install Gnucash 4.1 from the gnucash.org <http://gnucash.org/> 
> >> <http://gnucash.org/ <http://gnucash.org/>> site.
> >>
> >> The install was initially blocked by Defender, but he managed to overcome
> >> that. When he tried to run the program, the complaint was about missing
> >> .dll files in C:\Program files (x86)\gnucash\bin\
> >>
> >> As I don’t know about Windows 10, can someone please tell me the way to
> >> perform the install correctly in this case?
> >>
> >> Thanks.
> >>
> > For many years I installed GnuCahs on Windows 10 with defender enabled
> > using the .exe installation file.
> >
> > I've never had any problems.
> >
> > I'm currently running v4.1 well, and it was the first master update that I
> > haven't noticed any problems with so far.
> >
> > *Congratulations DEVs!*
> >
> >
> > --
> > Regards
> > ___
> Sounds to me that there is a fault in the downloaded install file. I 
> suggest re-downloading the .exe file; checkg the hash code for accuracy 
> of the downloaded file; and then installing the new download file.
> 
> Do not believe the Defender is problem.  Windows will ask if you really 
> want to install the GnuCash install file.
> All the best, nvsoar
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists 
> <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.