Re: [GNC] Can't download stock prices

[David Reiser via gnucash-user]

> On May 20, 2024, at 21:07, Ernie Wakamatsu  wrote:
> 
> Very strange.  I get two results.
> 
> First, following your instructions, by coping and pasting
> Ernie@Ernie-Mac-mini contents % zsh -df
> Ernie-Mac-mini% /Applications/Gnucash.app/Contents/MacOS/gnucash-cli -Q info
> Application Path /Applications/Gnucash.app/Contents/MacOS/gnucash-cli

The following is also likely to be a significant problem
> Failed to initialize Finance::Quote: missing_modules JSON::Parse

Finance::Quote isn’t going to run until you have JSON::Parse installed.

--
Dave Reiser
dbrei...@icloud.com



> 
> But when I type in the command line:
> 
> Ernie-Mac-mini% /Applications/Gnucash.app/Contents/macOS/gnucash-cli -Q info
> Application Path /Applications/Gnucash.app/Contents/macOS/gnucash-cli
> * 11:01:28  WARN  failed to load gncmod-backend-dbi from relative 
> path 
> * 11:01:28 ERROR  required library gncmod-backend-dbi not found.
> * 11:01:28  WARN  failed to load gncmod-backend-xml from relative 
> path 
> * 11:01:28 ERROR  required library gncmod-backend-xml not found.
> * 11:01:28 ERROR  g_settings_schema_source_lookup: assertion 
> 'source != NULL' failed
> * 11:01:28 ERROR  g_settings_new_full: assertion 'schema != NULL' 
> failed
> * 11:01:28  WARN  [gnc_gsettings_get_settings_obj()] 
> Ignoring attempt to access unknown gsettings schema 
> org.gnucash.GnuCash.general
> zsh: segmentation fault  /Applications/Gnucash.app/Contents/macOS/gnucash-cli 
> -Q info
> 
> The two command lines are seemingly the same, but the difference is macOS and 
> MacOS.  I thought the shell was not case sensitive.  h  The behavior is 
> the same when I exit from the default shell.
> 
> I did check the directory and it is MacOS.
> 
> Ernie-Mac-mini% cd /Applications/Gnucash.app/Contents
> Ernie-Mac-mini% ls
> Info.plistMacOS   PkgInfo Resources   _CodeSignature
> Ernie-Mac-mini% 
> 
> Odd that it would behave differently.
> 
> Thoughts?
> 
> Ernie
> 
> 
> 
> 
>> On 21 May 2024, at 2:50 AM, John Ralls  wrote:
>> 
>> Ernie,
>> 
>> The double slash is present in my output too, and it’s harmless. 
>> 
>> That shows that the app bundle is complete and uncorrupted. Something is 
>> getting in the way of dlopen finding those two libraries.
>> 
>> Try getting a purely default shell environment by running 
>>   zsh -df
>> That opens a new sub shell with no environment variables set and ignoring 
>> all of your zsh config files. You can quit back to your regular shell with 
>> d, but first try running 
>>  /Applications/Gnucash.app/Contents/MacOS/gnucash-cli -Q info
>> 
>> Regards,
>> John Ralls
>> 
>>> On May 19, 2024, at 22:22, Ernie Wakamatsu  wrote:
>>> 
>>> Thanks John,
>>> 
>>> I ran the below commands and this is what I got.
>>> 
>>> Ernie@Ernie-Mac-mini contents % spctl --assess -vv /applications/gnucash.app
>>> /applications/gnucash.app: accepted
>>> source=Notarized Developer ID
>>> origin=Developer ID Application: John D Ralls (Y9EHT5WMK7)
>>> Ernie@Ernie-Mac-mini contents % otool -L 
>>> /Applications/Gnucash.app/Contents/Resources/lib/gnucash/libgncmod-backend-dbi.dylib
>>> /Applications/Gnucash.app/Contents/Resources/lib/gnucash/libgncmod-backend-dbi.dylib:
>>> @executable_path/../Resources//lib/gnucash/libgncmod-backend-dbi.dylib 
>>> (compatibility version 0.0.0, current version 0.0.0)
>>> @executable_path/../Resources/lib/libgnc-backend-sql.dylib 
>>> (compatibility version 0.0.0, current version 0.0.0)
>>> @executable_path/../Resources/lib/libgnc-engine.dylib (compatibility 
>>> version 0.0.0, current version 0.0.0)
>>> @executable_path/../Resources/lib/libdbi.3.dylib (compatibility version 
>>> 4.0.0, current version 4.0.0)
>>> @executable_path/../Resources/lib/libgnc-core-utils.dylib 
>>> (compatibility version 0.0.0, current version 0.0.0)
>>> @executable_path/../Resources/lib/libboost_regex.dylib (compatibility 
>>> version 0.0.0, current version 0.0.0)
>>> @executable_path/../Resources/lib/libboost_date_time.dylib 
>>> (compatibility version 0.0.0, current version 0.0.0)
>>> @executable_path/../Resources/lib/libicui18n.73.dylib (compatibility 
>>> version 73.0.0, current version 73.2.0)
>>> @executable_path/../Resources/lib/libicuuc.73.dylib (compatibility 
>>> version 73.0.0, current version 73.2.0)
>>> @executable_path/../Resources/lib/libicudata.73.dylib (compatibility 
>>> version 73.0.0, current version 73.2.0)
>>> @executable_path/../Resources/lib/libgmodule-2.0.0.dylib (compatibility 
>>> version 7601.0.0, current version 7601.3.0)
>>> @executable_path/../Resources/lib/libglib-2.0.0.dylib (compatibility 
>>> version 7601.0.0, current version 7601.3.0)
>>> @executable_path/../Resources/lib/libintl.8.dylib (compatibility 
>>> version 13.0.0, current version 13.0.0)
>>> @executable_path/../Resources/lib/libgobject-2.0.0.dylib (compatibility 
>>> version 7601.0.0, current version 7601.3.0)
>>> /usr/lib/libc++.1.dylib (compatibility 

Re: [GNC] Importing bank data, sending instructions.

[David Reiser via gnucash-user]

> On May 15, 2024, at 17:58, Chris Miller  wrote:
> 
> Hi Folks, 
> 
> GnuCash will import bank data in OFX format. OFX imports advise me of 
> activity that originates with the bank, so I can "sync" my books with the 
> bank. So far; so good. 
> 
> Wells Fargo produces an OFX import file with "WebConnect", but I have been 
> using Wells Fargo "Direct Connect" for thirty years. "Direct Connect" allows 
> me to write checks and transfer funds from QuickBooks, but "OFX Import" does 
> not, which makes sense, because it is an import, not a dialog. 
> 
> I see that there is a way to send instruction to the bank and it is 
> AQBanking, which is an open source library that comes with GnuCash. I suspect 
> that AQBanking will be tricky to configure, so I'm looking for advice, 
> specifically advice on configuring AQBanking to run with Wells Fargo. 
> Reference to a specific AQBanking monograph for Wells Fargo would be 
> outstanding. 
> 
> Thanks for the help, 
> -- 
> Chris. 
I’m sorry to say that sending instructions via AQbanking will never happen. 
Even before Quicken (and even Intuit before them) started actively trying to 
deep six DirectConnect, it was highly impractical for anyone on the outside to 
handle sending instructions. The costs of gaining access to a DirectConnect 
test server made it unthinkable for an open source programmer to attempt to 
include sending instructions via DirectConnect. Add to that the fact that 
sending instructions essentially means moving money out of someone’s account, 
the risks to an independent developer become enormous.

All but 2 of my financial institutions have ceased supporting DirectConnect 
even for downloading transaction data. And one of them has crippled the content 
of the description field so badly that I’ve bailed to CSV. That leaves 1 out of 
what used to be 8 institutions that I could use with AQbanking. The end is near 
(though a few banks may hold out for a few more years).

--
Dave Reiser
dbrei...@icloud.com





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

Re: [GNC] Question about OFX imports

[David Reiser via gnucash-user]

> On May 13, 2024, at 17:50, David Carlson  wrote:
> 
> Now it is my turn to ask a question.
> 
> My bank recently had an issue with the description text for a few
> transactions that resulted in the transactions being reposted with
> corrected descriptions.  Now I am trying to import the corrected
> transactions but they do not appear in the OFX importer even though they
> are in the file generated by the bank.
> 
> My question is: If I delete the previously imported transactions, can I
> import the corrected transactions?

yes.

> A corollary; is there any way to check, edit or remove the FITID value of a
> transaction that prevents the duplicate import without doing tricks in the
> OFX file before importing?

only if you are willing to risk damaging your datafile editing it outside of 
gnucash. The FITID values are stored as a key/value pair like:


  online_id
  20180906246910059666


and finding specific transactions in the raw XML is harder than you might 
imagine. The online_id is not available to the user anywhere in the gnucash 
interface.

I have never tried editing a gnucash SQL file outside of gnucash.

> 
> -- 
> David Carlson
> ___


--
Dave Reiser
dbrei...@icloud.com





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

Re: [GNC] Aqbanking

[David Reiser via gnucash-user]

I urge you not to try. But if you log into your bank and look for information 
on Quicken compatibility and it specifically says “QFX DirectConnect”, you have 
a chance. It may still be a challenge to find the connection information 
because Quicken and the bank don’t tell their tech support anything about it. 
For Quicken users, all that info is hidden inside Quicken. Banks will NEVER 
know anything about GnuCash, so it’s a bad idea to even mention it.

If your bank says it’s compatible with Express Web Connect (EWC) or Express Web 
Connect Plus (EWC+), then you are most likely out of luck.

Banks are abandoning DirectConnect almost as fast as they can. They’ve never 
liked it — first because in the early days Intuit had too much control of the 
standard and charged a _lot_ for their turnkey compatible software on the 
bank’s side, and now because its security features are not great.

The new 800-pound gorilla in finance data handling is FDX (presumably from 
Financial Data Exchange). FDX is an industry (i.e., banking industry) 
consortium focused on creating and maintaining standardized methods for 
financial data interchange among business partners. The OFX Group has become 
part of FDX. The intent of the combined group is to migrate everyone away from 
the OFX realm. The banking industry moves pretty slowly, so there will be a few 
stragglers offering DirectConnect for a few years.

The FDX API depends on software interacting with data aggregators (companies 
like Plaid) between consumer and bank. The complexity and cost of establishing 
credentials as an aggregator or even with an aggregation partner make it 
unlikely that open source software will ever be able to do direct retrieval of 
bank data again in the future.

Plan on downloading data from within your bank’s website, and then importing it 
into gnucash.

--
Dave Reiser
dbrei...@icloud.com





> On Apr 20, 2024, at 12:18, Dennis Powless  wrote:
> 
> How do I determine if my bank participates or offers ofx direct connect, 
> aqbanking?
> 
> Dennis

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

Re: [GNC] Finance Quotes Yahoo off the rails again?

[David Reiser via gnucash-user]

yahoo_json not YahooJSON

--
Dave Reiser
dbrei...@icloud.com





> On Apr 14, 2024, at 17:03, Fross, Michael via gnucash-user 
>  wrote:
> 
> Thanks Bruce for the update.  I've installed it but must be doing something
> wrong.
> 
> Syntax seems to work fine for YahooWeb, but I received an error if I do the
> same command with YahooJSON.  HTTP::CookieJar::LWP is installed and up to
> date. I'm not sure how to troubleshoot this effectively.
> 
> Any pointers would be appreciated.
> 
> Michael
> 
> *--Yahoo JSON--*
> C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --verbose -Q dump
> YahooJSON aapl
> Finance::Quote retrieval failed with error Failed to parse result returned
> by Finance::Quote.
> Error message:
> (1): expected value
> Result:
> 
> *--Yahoo Web--*
> C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --verbose -Q dump
> YahooWeb aapl
> aapl:
>  method => yahooweb
>high => 178.36
>  symbol => aapl
>last => 176.55
> success => 1
>name => Apple Inc.
>  volume => 101593300
>date => 04/12/2024
>currency => USD
>open => 174.26
> low => 174.21
>exchange => NasdaqGS - NasdaqGS Real Time Price
> isodate => 2024-04-12
> 
> On Sun, Apr 14, 2024 at 3:48 PM david amaral via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
>> Thank you.Installed on windows 11 Gnucash 5.6 flawlesly in an admin
>> comand window issued the command and all went without any errors.
>> 
>>On Sunday, April 14, 2024 at 08:45:09 AM GMT-7, Bruce Schuck <
>> bsch...@asgard-systems.com> wrote:
>> 
>> On 4/13/24 20:08:20 -0700, Bruce S wrote:
>> 
>>> There is some miscellaneous housekeeping and cleanup that needs to be
>>> done before pushing a final release to CPAN. Plus I had some other
>>> changes that I was planning for v1.60 but haven't done yet. Instead of
>>> v1.60, I may upload v1.59_01 tomorrow so people can at least fetch the
>>> fix for YahooJSON before v1.60 is uploaded and indexed by CPAN.
>> 
>> Pre-release F::Q v1.59_01 has been uploaded to CPAN.
>> 
>> To install using cpan or cpanm you must specify the path.
>> 
>> cpan> install BPSCHUCK/Finance-Quote-1.59_01.tar.gz
>> 
>> Bruce S.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> ___
> 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] ANNOUNCE: GnuCash 5.6 Released

[David Reiser via gnucash-user]

You could try

gnucash-cli -Q info

from a command line to see the perl errors.
--
Dave Reiser
dbrei...@icloud.com





> On Apr 1, 2024, at 13:07, David G. Pickett via gnucash-user 
>  wrote:
> 
> I eagerly installed it but in the Security editor Edit screen it says Finance 
> Quote is not installed properly, and the Get Quotes of the Price screen is 
> dimmed out.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Finance Quotes Yahoo off the rails again?

[David Reiser via gnucash-user]

I’ve seen that error, but it disappeared on its own in a few minutes. However, 
I don’t remember if I quit and relaunched Gnucash in between attempts. I do 
recommend updating F::Q to 1.59. The appearance of the error is rare, not 
common.
--
Dave Reiser
dbrei...@icloud.com





> On Mar 26, 2024, at 00:18, David G. Pickett via gnucash-user 
>  wrote:
> 
> PS: New error tonight:
> Found Finance::Quote version 1.58.* 23:59:55 ERROR  
> [parse_quotesource_error()] Unrecognized Finance::Quote Error Can't use 
> string ("18.590101") as a HASH ref while "strict refs" in use at 
> /app/lib/perl5/site_perl/5.32.0/Finance/Quote/YahooJSON.pm line 177.Price 
> retrieval failed: Unrecognized Finance::Quote Error: Can't use string 
> ("18.590101") as a HASH ref while "strict refs" in use at 
> /app/lib/perl5/site_perl/5.32.0/Finance/Quote/YahooJSON.pm line 177.
> 
> 2024-03-26 00:00:01 End bash* 00:07:56  WARN  
> [GncQuotesImpl::parse_one_quote()] Skipped NYSE:CSX - Finance::Quote returned 
> fetch failure.Reason Error retrieving quote for CSX. Attempt to fetch the URL 
> https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=CSX=price,summaryDetail,defaultKeyStatistics
>  resulted in HTTP response 500 (Internal Server Error)* 00:07:56  WARN 
>  [GncQuotesImpl::parse_one_quote()] Skipped NYSE:T - 
> Finance::Quote returned fetch failure.Reason Error retrieving quote for T. 
> Attempt to fetch the URL 
> https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=T=price,summaryDetail,defaultKeyStatistics
>  resulted in HTTP response 500 (Internal Server Error)* 00:07:56  WARN 
>  [GncQuotesImpl::parse_one_quote()] Skipped FUND:WFILX - 
> Finance::Quote returned fetch failure.
> 
> 
>On Monday, March 25, 2024 at 03:20:24 AM EDT, Frank H. Ellenberger 
>  wrote:  
> 
> Hi David,
> 
> Am 25.03.24 um 05:13 schrieb David G. Pickett via gnucash-user:
>>   Wow, the mail handler seems to hate ascii text!  Is it a side effect of 
>> html email?
>> 
>> I keep forgetting that to run stuff installed by flatpak you need flatpak 
>> magic like this:
>> flatpak run --command=gnucash-cli org.gnucash.GnuCash -Q dump xxx yyy
> 
> may I suggest, to read
> https://wiki.gnucash.org/wiki/Flatpak#Tips and
> https://www.gnucash.org/docs/v5/C/gnucash-manual/fq-command-line.html
> 
> After
>   flatpak run --command=sh org.gnucash.GnuCash
> you can enter all flavours of gnucash-cli
>   gnucash-cli --quotes info
>   gnucash-cli --verbose --quotes dump SOURCE SYMBOL
> 
> HTH
> Frank
> 
>> What are the valid source codes?
>>   On Sunday, March 24, 2024 at 07:30:41 PM EDT, David G. Pickett 
>>  wrote:
>>   
>> dgp@dgp-p6803w:~$ find / -name libgnc-report.so* -type f -s 
>> 2>/dev/nulldgp@dgp-p6803w:~$
>> 
>>   On Sunday, March 24, 2024 at 07:26:53 PM EDT, David G. Pickett 
>>  wrote:
>>   
>> How does one run it?
>> 
>> dgp@dgp-p6803w:~$ gnucash-cli -Q dump Command 'gnucash-cli' not found, but 
>> can be installed with:sudo apt install gnucashdgp@dgp-p6803w:~$ find / -name 
>> gnucash-cli -type f -ls 2>/dev/null  1070407168 -rwxr-xr-x   2 root 
>> root   170360 Dec 18 13:44 
>> /var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-clidgp@dgp-p6803w:~$
>>  
>> /var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-cli
>>  -Q 
>> dump/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-cli:
>>  error while loading shared libraries: libgnc-report.so: cannot open shared 
>> object file: No such file or directorydgp@dgp-p6803w:~$
>> 
>>   On Sunday, March 24, 2024 at 08:00:59 AM EDT, Geert Janssens 
>>  wrote:
>>   
>> 
>> gnc-fq-dump's functionality has been replaced with
>> 
>> 
>> gnucash-cli -Q dump   [ ...]
>> 
>> 
>> Regards,
>> 
>> 
>> Geert
>> 
>> 
>> Op zaterdag 23 maart 2024 20:40:43 CET schreef David G. Pickett via 
>> gnucash-user:
>> 
>>> Version: 5.5Build ID: Flathub 5.5Finance::Quote: 1.58
>> 
>>> Ubuntu 22.04.4 LTS (all the latest updates from flatpak, snap, Software
>> 
>>> Updater, Software).
>> 
>>> 
>> 
>>> Apparently the Usage is a bit off, or that script is not being distributed
>> 
>>> by flatpak: $ (cd
>> 
>>> /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F
>> 
>>> /Program\ Files/gnucash2.2.6/bin ; perl ./gnc-fq-dump; ) Usage:
>> 
>>> ./gnc-fq-dump  [-v]  [ ...]
>> 
>>> 
>> 
>>> $ (cd
>> 
>>> /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F
>> 
>>> /Program\ Files/gnucash2.2.6/binfor s in bseindia tmx fidelity hufund
>> 
>>> finanzpartner tsx za six fondsweb iexcloud xetra unionfunds
>> 
>>> troweprice_direct known_currencies bvb dwsfunds nzx oslobors tiaacref
>> 
>>> nasdaq romania hu morningstarch bse alphavantage hungary dutch
>> 
>>> 

Re: [GNC] 5.5-1 crashing on macOS 14.3

[David Reiser via gnucash-user]

We are now into my mental weeds as far as real knowledge goes, but I have had 
some success at thrashing around to fix self-induced perl challenges.

Since the error happens on both architectures, that suggests something is 
missing. I think YahooWeb is relatively recent in the F::Q realm. And F::Q 
hasn’t managed dependency declarations as well as I’d like. 

The error complains about a ‘row method’. YahooWeb uses HTML::TableExtract 
which might be the source of the row information. Try installing the 
appropriate arch version of HTML::TableExtract on each machine and see if that 
works.
--
Dave Reiser
dbrei...@icloud.com





> On Mar 8, 2024, at 1:03 PM, Tom Teixeira  wrote:
> 
> I spoke too soon: while getting an individual quote with gnucash-cli works:
> 
> /Applications/Gnucash-5.5.app/Contents/MacOS/gnucash-cli --quotes dump 
> yahooweb MSFT
> 
> Application Path /Applications/Gnucash-5.5.app/Contents/MacOS/gnucash-cli
> Finance::Quote fields GnuCash uses:
> symbol: MSFT<=== required
>   date: 03/08/2024  <=== recommended
>   currency: USD <=== required
>   last: 407.16  <=\
>nav: <=== one of these
>  price: <=/
> 
> trying to "Get Quotes" in my "Price Database" does not. I get a dialog box 
> with
> 
> Price retrieval failed: Unrecognized Finance::Quote Error: Can't call method 
> "rows" on an undefined value at /Library/Perl/5.34/Finance/Quote/YahooWeb.pm 
> line 101.
> 
> I have another, Intel-based Mac. After upgrading this to Sonoma 14.4 release 
> version, and re-installing Finance::Quote, it gets the same error.
> 
___
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] 5.5-1 crashing on macOS 14.3

[David Reiser via gnucash-user]

You could try: sudo arch -arch x86_64 cpan -f JSON::Parse

You definitely need the x86_64 version of Perl modules for use with gnucash on 
Macs with Apple silicon cpus (M1, M2, M3) because gnucash is running in 
rosetta. I think if you tried the gnc-fq-udate first, you may have satisfied 
the requirement for everything except JSON::Parse.

I my command, I’m not sure you need the “arch” without the - sign. But you do 
need the “-f” (force) instead of the plain “-i” (install) because you already 
have a version of JSON::Parse installed, and the installer then ignores the 
arch difference and says you’re OK.

--
Dave Reiser
dbrei...@icloud.com





> On Mar 8, 2024, at 11:39 AM, Tom Teixeira  wrote:
> 
> Just upgraded to MacOS 14.4 release version. I had not previously installed 
> the beta version.
> 
> I'm unable to get Finance::Quote working. I updated Finance::Quote -- tried 
> both gnc-fq-update found inside the Gnucash.app package, and also using sudo 
> cpan -i Finance::Quote.
> 
> /Applications/Gnucash-5.5.app/Contents/MacOS/gnucash-cli --quotes info
> Application Path /Applications/Gnucash-5.5.app/Contents/MacOS/gnucash-cli
> Failed to initialize Finance::Quote: missing_modules Finance::Quote 
> JSON::Parse
> 
> But
> 
> sudo cpan -i JSON::Parse
> Loading internal logger. Log::Log4perl recommended for better logging
> Reading '/Users/tom/.cpan/Metadata'
>   Database was generated on Fri, 08 Mar 2024 15:54:09 GMT
> JSON::Parse is up to date (0.62).
> 
> Any ideas?
> 
> On 3/8/24 10:56 AM, David Reiser via gnucash-user wrote:
>> Gnucash 5.5 and 5.4 work fine for me under MacOS 14.4 release version. I did 
>> have to completely reinstall the Finance::Quote and dependency batch (and 
>> JSON::Parse separately).
>> --
>> Dave Reiser
>> dbrei...@icloud.com
>> 
>> 
>> 
>> 
>> 
>>> On Mar 8, 2024, at 12:56 AM, john  wrote:
>>> 
>>> Have any other Mac users upgraded to 14.4 and had GnuCash crash on them at 
>>> startup? Or had it run without trouble?
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>> 
>>>> On Mar 7, 2024, at 17:28, john  wrote:
>>>> 
>>>> First of all, don't send the same email twice from different addresses.
>>>> 
>>>> GnuCash 5.5 is working perfectly well for me on macOS 14.4 Beta (23E5211a) 
>>>> from last week. The 14.4 release *should* be substantially the same, but 
>>>> I'm traveling this month with only the one computer so I'm not going to 
>>>> take any upgrades until I get back home, nor will I be able to build a new 
>>>> package until then.
>>>> 
>>>> If it's crashing there will be a crash report, see 
>>>> https://wiki.gnucash.org/wiki/Stack_Trace#macOS for how to find it. Open a 
>>>> bug report 
>>>> (https://wiki.gnucash.org/wiki/Bugzilla#Commenting_on_existing_bugs_or_entering_new_ones)
>>>>  and attach the crash report.
>>>> 
>>>> Regards,
>>>> John Ralls
>>>> 
>>>> 
>>>>> On Mar 6, 2024, at 11:25, rts.trey via gnucash-user 
>>>>>  wrote:
>>>>> 
>>>>> GnuCash 5.5-1 wouldn't open after OS update.
>>>>> Same version ran fine on previous OS versions.
>>>>> Multiple fresh download/install of new 5.5 GnuCash didn't fix.
>>>>> 
>>>>> Anything I can do to assist troubleshoot/repair the issue?
>>>>> 
>>>>> Anon20
>>>>> ___

___
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] 5.5-1 crashing on macOS 14.3

[David Reiser via gnucash-user]

Gnucash 5.5 and 5.4 work fine for me under MacOS 14.4 release version. I did 
have to completely reinstall the Finance::Quote and dependency batch (and 
JSON::Parse separately).
--
Dave Reiser
dbrei...@icloud.com





> On Mar 8, 2024, at 12:56 AM, john  wrote:
> 
> Have any other Mac users upgraded to 14.4 and had GnuCash crash on them at 
> startup? Or had it run without trouble?
> 
> Regards,
> John Ralls
> 
> 
>> On Mar 7, 2024, at 17:28, john  wrote:
>> 
>> First of all, don't send the same email twice from different addresses.
>> 
>> GnuCash 5.5 is working perfectly well for me on macOS 14.4 Beta (23E5211a) 
>> from last week. The 14.4 release *should* be substantially the same, but I'm 
>> traveling this month with only the one computer so I'm not going to take any 
>> upgrades until I get back home, nor will I be able to build a new package 
>> until then.
>> 
>> If it's crashing there will be a crash report, see 
>> https://wiki.gnucash.org/wiki/Stack_Trace#macOS for how to find it. Open a 
>> bug report 
>> (https://wiki.gnucash.org/wiki/Bugzilla#Commenting_on_existing_bugs_or_entering_new_ones)
>>  and attach the crash report.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Mar 6, 2024, at 11:25, rts.trey via gnucash-user 
>>>  wrote:
>>> 
>>> GnuCash 5.5-1 wouldn't open after OS update.
>>> Same version ran fine on previous OS versions.
>>> Multiple fresh download/install of new 5.5 GnuCash didn't fix.
>>> 
>>> Anything I can do to assist troubleshoot/repair the issue?
>>> 
>>> Anon20
>>> ___
>>> 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.

___
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-user Digest, Vol 252, Issue 3

[David Reiser via gnucash-user]

Before you get tempted to pay for a stop-payment order (just to be sure…), 
check the terms and conditions written in your bank agreement. Many banks don’t 
promise to actually not pay the check. There are often weasel words about “best 
effort” etc. It happened to my sister. She paid for a stop-payment order. When 
the check arrived at the bank, they paid it. Then they hit her with an 
overdraft fee because the supposedly stopped payment took her balance below 
zero. Eventually, she got them to refund the stop-payment fee and the overdraft 
fee, but they told her she’d have to get the money back herself from the payee.
--
Dave Reiser
dbrei...@icloud.com


> On Mar 4, 2024, at 11:25 PM, R Losey  wrote:
> 
> Best wishes -- I'm still waiting for a check from 2018 to clear. I checked
> with my bank (I thought a check would not be valid after a certain time),
> and they said they'd honor it if it showed up today.  I don't want to spend
> the money to issue a stop-check order.
> 
> On Sat, Mar 2, 2024 at 11:35 AM Eric H. Bowen via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
>> Thanks for pointing that out; it helped with the outstanding $200 check
>> I had trouble getting rid of. However, since it won't extend back any
>> farther than 50 days, I think it won't be likely to help when (if?) that
>> check I wrote to the nonprofit back in December finally clears.
>> 
>> Eric.
>> 
>> On 3/2/2024 12:26 AM, gnucash-user-requ...@gnucash.org wrote:
>>> Message: 3
>>> Date: Fri, 1 Mar 2024 13:29:47 -0800
>>> From: john
>>> To: "Eric H. Bowen"
>>> Cc:gnucash-user@gnucash.org
>>> Subject: Re: [GNC] Improving GnuCash's Processing of Outstanding
>>>  Checks
>>> Message-ID:<1459e1cf-dbc7-431a-8beb-7180011ff...@ceridwen.us>
>>> Content-Type: text/plain; charset=us-ascii
>>> 
>>> 
>>> 
 On Mar 1, 2024, at 08:53, Eric H. Bowen via gnucash-user<
>> gnucash-user@gnucash.org>  wrote:
 
 Is it possible to extend the time for outstanding checks to show up in
>> the "manual match" window?
>>> That's controlled by the two  match day thresholds in Preferences>Import.
>>> 
>>> Regards,
>>> John Ralls
>> ___
> 
> -- 
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8

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

Re: [GNC] Find Question

[David Reiser via gnucash-user]

If the 31.82 is in the debit or credit columns, you want to be searching 
‘value’ not ’number’. If it’s just text somewhere, search ‘Description, notes, 
and memo’.

--
Dave Reiser
dbrei...@icloud.com



> On Feb 16, 2024, at 12:50 PM, David Knoblich via gnucash-user 
>  wrote:
> 
> 
> I need to know how to find a number (31.82) that is in asplit entry. The find 
> function for this (^F) does not work. I press ^F, select ‘number’,‘contains’, 
> and ’31.82’. I do this from the main list of accounts or fromwithin the 
> actual account. I’ve even tried it from withing the account with thesplit 
> open. The results are always a search result tab with an emptytransaction. 
> Does anyone know how to do this? 
> 

___
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] auto _interest_ transfer

[David Reiser via gnucash-user]

There is a tool tip for that choice. While you can see the option, hold your 
mouse pointer over the text, and an explanation pops up.
--
Dave Reiser
dbrei...@icloud.com





> On Dec 28, 2023, at 5:31 PM, Andrew Gross  wrote:
> 
> *Subject: Re: [GNC] How is "auto asset transfer" used in an asset
> account?Andrew You may find some information in this section of the GnuCash
> guidehttps://www.gnucash.org/docs/v5/C/gnucash-guide/chapter_invest.html
> David
> Cousens*
> 
> Hi David, Looked around, didn't see anything.  I also tried a google search
> with the operand "site:gnucash.org" but that didn't reveal anything
> either.  Appreciate your input though.  Maybe this is just something new
> that hasn't been documented yet.
> 
> Andrew
> 
> 
> On Wed, Dec 27, 2023 at 10:41 PM  wrote:
> 
>> From: Andrew Gross 
>> To: GNU Cash User 
>> Cc:
>> Bcc:
>> Date: Wed, 27 Dec 2023 15:14:30 -0500
>> Subject: [GNC] How is "auto asset transfer" used in an asset account?
>> Greetings all,
>> 
>> I am creating a new account to hold bonds and started to create an asset
>> account; I see there is a checkbox for "auto interest transfer".  I have
>> not been able to find any definitive text on how to use this feature
>> although I have found mentions here
>> <
>> https://lists.gnucash.org/pipermail/gnucash-announce/2020-July/000326.html
>>> 
>> and
>> mentions possibly related to it such as in a couple of postings in August
>> 2022.
>> 
>> Can anyone point me to where I could find more information?

___
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] Printing Checks -- putting info on the memo line of checks

[David Reiser via gnucash-user]

At least most of the predefined check formats use the transactions Notes field 
as the source for a check memo. The Notes field can only be seen if you are in 
Double Line view mode in the register for the account associated with the 
checks. View menu > Double Line.
--
Dave Reiser
dbrei...@icloud.com





> On Dec 18, 2023, at 8:01 AM,   
> wrote:
> 
> Hi all!  Hope you can help.  For the life of me I can't find a way to print
> on the memo line of checks.  Can someone help me??
> 
> 
> 
> Thank you.
> 

___
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] Online Banking

[David Reiser via gnucash-user]

I never got aqbanking to successfully connect to Fidelity’s ofx server. I used 
ofxget to retrieve the files, and then imported into gnucash. However, Fidelity 
has crippled their ofx creation policy so much that I’ve abandoned their ofx 
feeds. Dividends show up with Descriptions and Memos of solely “Qualified 
Dividend” or “Non-qualified Dividend”. If you have dividends from stocks or 
funds that aren’t automatically reinvested, then you’ll have no idea which 
stock or fund paid those dividends.

I’ve been using "csv2ofx Convert" from MoneyThumb to convert csv downloads from 
Fidelity and Schwab into ofx files I can import into gnucash. It does cost 
money, and it does have some gotchas to be wary of, but it does keep me from 
making fumble fingered data input errors in my stock accounts.

I haven’t seen a good description of how to import a csv file of investment 
transactions directly into gnucash. If a tutorial of that operation is 
available, I’d be interested in pursuing it. The main challenge being (I think) 
that many investment transactions involve multiple commodities ($ and shares).

Dave
--
Dave Reiser
dbrei...@icloud.com





> On Dec 16, 2023, at 5:44 PM, david amaral via gnucash-user 
>  wrote:
> 
> I am attemting to set up online banking to Fidelity and not having much luck. 
> I keep getting error of "bad request"  Have no idea as to why,
> AqBanking v6.5.4.0stableSending jobs to the bank(s)Sorting commands by 
> accountSorting account queues by providerSend commands to providersSend 
> commands to provider "aqofxconnect"Locking customer "7"Sending 
> request...Connecting to server...Resolving hostname "ofx.fidelity.com" ...IP 
> address is "23.209.84.151"Connecting to "ofx.fidelity.com"Connected to 
> "ofx.fidelity.com"Connected.Sending message...Message sent.Waiting for 
> response...Receiving response...HTTP-Status: 400 (Bad Request)Unlocking 
> customer "7"
> Any help would be greatly appreciated
> 
> ___
> 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] Strange error in OFX import

[David Reiser via gnucash-user]

I think your problem arises from there being multiple  flags. The main 
data stream is coming from 8320, but each of the 
transactions within that account has 1425 within the 
transaction. So each of the transactions is a transfer from one credit card 
account to another. I’m guessing that the OFX importer is having trouble 
parsing multi-account transactions.

Multiple accounts within a single QFX/OFX file have always created problems. 
PNC Bank handled it in a way that gnucash could successfully import, at least 
for collections of checking and savings accounts. But I don’t have those 
accounts anymore, and I don’t have any of my downloaded files, so I can’t see 
how they handled it.
--
Dave Reiser
dbrei...@icloud.com





> On Dec 6, 2023, at 1:47 AM, David Carlson  wrote:
> 
> That bug may be a different symptom of the same problem or it may be a
> different bug altogether.  Interestingly, my file does have the 
> tag.
> 
> I attached my file to that bug report in case it helps with the diagnosis.
> 
> On Tue, Dec 5, 2023 at 9:56 PM john  wrote:
> 
>> 
>> 
>> On Dec 4, 2023, at 18:47, David Carlson 
>> wrote:
>> 
>> New to me, anyway.  Using release 4.8 in Linux importing to existing
>> account which worked with a previous import last March with today's import
>> I receive the error message "OFX File '/media...' 2 transactions processed,
>> no transactions to match
>> 
>> Why did it not proceed with the import?
>> 
>> 
>> 
>> https://bugs.gnucash.org/show_bug.cgi?id=799109 ?
>> 
>> Regards,
>> John Ralls
>> 
>> 
> 
> -- 
> 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] Importing data from QuickBooks Online

[David Reiser via gnucash-user]

Really grasping at straws now, but invisible characters/extra spaces in the 
2022 account names?
--
Dave Reiser
dbrei...@icloud.com





> On Jul 3, 2023, at 12:29 PM, Tom Olin  wrote:
> 
> David,
> 
> Both import files were generated from the same 2-year QBO export, so they 
> have identical structure. The process was:
> 
>   QBO export -> convert to CVS -> my script -> unified import file (CVS)
> 
> The problem occurred identically whether I imported the unified file or just 
> the 2022 data portion.
> 
> I tried changing a 2023 transaction to 2022 and it imported correctly.
> 
> --
> Tom
> 
> For the government, which came first? (a) first $ taxed; (b) first $ 
> borrowed; (c) first $ spent. (Hint: state or federal?)
> 
>> On Jul 3, 2023, at 12:11 PM, David Reiser  wrote:
>> 
>> So, the year isn’t the sticking point. If you look at the .xls files — one 
>> transaction from 2022 and one from 2023 — do you see a difference? If you 
>> move a 2023 transaction to 2022, does it import correctly, or fail? I’m 
>> guessing there’s a column missing in the 2022 xls file.
>> 
>> --
>> Dave Reiser
>> dbrei...@icloud.com
>> 
>> 
>> 
>> 
>>> On Jul 3, 2023, at 11:59 AM, Tom Olin via gnucash-user 
>>>  wrote:
>>> 
>>> [Resending to the list. Original reply went only to Jim.]
>>> 
>>> Jim,
>>> 
>>> Fair questions. Answers below, and I’ve attached the script itself which 
>>> includes documentation which addresses some of the questions. I’ve reviewed 
>>> all documentation that I can find.
>>> 
>>> From QBO, I export a journal report to XLS (only usable option in QBO).
>>> 
>>> GnuCash 5.3 on macOS 11.7.8
>>> 
>>> See the script for the specific steps.
>>> 
>>> The import matcher step of the import process is fully satisfied. That is 
>>> the step labeled “Match Import and GnuCash accounts”.
>>> 
>>> The  problem manifests at the “Match Transactions” screen where all 
>>> transactions need to be matched. I’ve attached a screenshot if it is 
>>> supported here.
>>> 
>>> One more data point: I tried changing one of the transactions in the 2022 
>>> import file to 2023. It still failed the same way.
>>> 
>>> —
>>> Tom
>>> 
>>>> On Jul 2, 2023, at 11:55 PM, Jim DeLaHunt  wrote:
>>>> 
>>>> Tom:
>>>> 
>>>> On 2023-07-02 15:10, Tom Olin via gnucash-user wrote:
>>>>> I’m attempting to import data from QuickBooks Online to GnuCash. I’ve 
>>>>> written an awk script which appears to work well except for one major 
>>>>> issue.
>>>> 
>>>> What format is the data which you export from Quickbooks Online? CSV 
>>>> (Comma Separated Values text files with tabular data)? QFX (Quicken 
>>>> Financial Exchange, similar to OFX)?
>>>> 
>>>> What GnuCash version are you using? On what computer OS?
>>>> 
>>>> What GnuCash sequence of actions do you use to import the data?
>>>> 
>>>> 
>>>>> The data I’m importing spans the years 2022 and 2023. All 2023 
>>>>> transactions import cleanly, but all 2022 transactions import unbalanced, 
>>>>> meaning I have to manually match up each of them - doable but tedious.
>>>> 
>>>> Let's assume you are exporting data in CSV format, and using the current 
>>>> version of GnuCash (5.3), and importing using the File… Import… Import 
>>>> Transactions from CSV menu item. You should be directed through an import 
>>>> matcher. This is the place where GnuCash should assign accounts to balance 
>>>> each transaction. Is each transaction assigned to an account in the import 
>>>> matcher?
>>>> 
>>>> Have you read the section of the documentation explaining how to import 
>>>> data?
>>>> 
>>>>> Can anyone think of anything that would cause this behavior? I’ve ruled 
>>>>> out Accounting Period. I’ve imported each year separately. I’ve exported 
>>>>> each year separately from QBO. The behavior persists.
>>>>> 
>>>>> I’m stumped. Any ideas?
>>>> 
>>>> I hope these questions help get enough information on the table to give 
>>>> someone ideas.
>>>> 
>>>> Best regards,
>>>>  —Jim DeLaHunt
>>>> 
>> 
> 

___
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] Importing data from QuickBooks Online

[David Reiser via gnucash-user]

So, the year isn’t the sticking point. If you look at the .xls files — one 
transaction from 2022 and one from 2023 — do you see a difference? If you move 
a 2023 transaction to 2022, does it import correctly, or fail? I’m guessing 
there’s a column missing in the 2022 xls file.

--
Dave Reiser
dbrei...@icloud.com




> On Jul 3, 2023, at 11:59 AM, Tom Olin via gnucash-user 
>  wrote:
> 
> [Resending to the list. Original reply went only to Jim.]
> 
> Jim,
> 
> Fair questions. Answers below, and I’ve attached the script itself which 
> includes documentation which addresses some of the questions. I’ve reviewed 
> all documentation that I can find.
> 
> From QBO, I export a journal report to XLS (only usable option in QBO).
> 
> GnuCash 5.3 on macOS 11.7.8
> 
> See the script for the specific steps.
> 
> The import matcher step of the import process is fully satisfied. That is the 
> step labeled “Match Import and GnuCash accounts”.
> 
> The  problem manifests at the “Match Transactions” screen where all 
> transactions need to be matched. I’ve attached a screenshot if it is 
> supported here.
> 
> One more data point: I tried changing one of the transactions in the 2022 
> import file to 2023. It still failed the same way.
> 
> —
> Tom
> 
>> On Jul 2, 2023, at 11:55 PM, Jim DeLaHunt  wrote:
>> 
>> Tom:
>> 
>> On 2023-07-02 15:10, Tom Olin via gnucash-user wrote:
>>> I’m attempting to import data from QuickBooks Online to GnuCash. I’ve 
>>> written an awk script which appears to work well except for one major issue.
>> 
>> What format is the data which you export from Quickbooks Online? CSV (Comma 
>> Separated Values text files with tabular data)? QFX (Quicken Financial 
>> Exchange, similar to OFX)?
>> 
>> What GnuCash version are you using? On what computer OS?
>> 
>> What GnuCash sequence of actions do you use to import the data?
>> 
>> 
>>> The data I’m importing spans the years 2022 and 2023. All 2023 transactions 
>>> import cleanly, but all 2022 transactions import unbalanced, meaning I have 
>>> to manually match up each of them - doable but tedious.
>> 
>> Let's assume you are exporting data in CSV format, and using the current 
>> version of GnuCash (5.3), and importing using the File… Import… Import 
>> Transactions from CSV menu item. You should be directed through an import 
>> matcher. This is the place where GnuCash should assign accounts to balance 
>> each transaction. Is each transaction assigned to an account in the import 
>> matcher?
>> 
>> Have you read the section of the documentation explaining how to import data?
>> 
>>> Can anyone think of anything that would cause this behavior? I’ve ruled out 
>>> Accounting Period. I’ve imported each year separately. I’ve exported each 
>>> year separately from QBO. The behavior persists.
>>> 
>>> I’m stumped. Any ideas?
>> 
>> I hope these questions help get enough information on the table to give 
>> someone ideas.
>> 
>> Best regards,
>>   —Jim DeLaHunt
>> 

___
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] Proposed enhancement to OFX/QFX import

[David Reiser via gnucash-user]

> On Jun 5, 2023, at 8:49 PM, Stephen Cohoon  wrote:
> 
> I have been using Gnucash for many years so I think it is time to
> contribute.  I have several credit card accounts from different banks that
> each take a different approach to how they populate the tags in the
> transaction download file.  When I import these files I often have to spend
> time cleaning up the description and notes fields, adding and deleting
> text.  In particular, one of my banks actually lets me set the memo field
> for a transaction through their web page and app.  I want this to appear in
> the transaction description.  I would like more control so I can specify
> more precisely how this data is imported for each account separately.
> 
> I propose adding 2 options to the account edit screen:
> 1. Append Memo - when set, if the memo tag is populated then append that
> text to the name tag and use that combined text to populate the transaction
> description field.  Default is off in which case the present logic is
> invoked.
> 
> 2. Suppress Notes - when set, skip the logic that populates the notes field
> of the transaction. Default is off in which case the present logic is
> invoked.
> 
> These options function independently.
> 
> What does the community think about this?
> 
> -Stephen
> -- 
> Stephen Cohoon
> smcoh...@gmail.com
> 
> If there's a problem that can't be solved with a clever program, is that
> problem really worth solving?
> ___

I wholeheartedly support at least item 2. 

A couple weeks ago, I spent a whole day manually deleting 5400+ useless Notes 
of the form "OFX ext. info: |Trans type:Other|Investment …”. With better regex 
skills I could have done it in a couple minutes, but it seemed a bit dangerous 
for my capabilities. 

I keep my checking and credit card notes up to date, and I never let ofx 
imports modify existing transactions (other than the clear flag). But TIAA 
makes dozens of tiny account adjustments per quarter among the retirement 
annuities held by  my wife and me. My approach to retirement accounts was to 
import all the transactions and make sure the units (shares) held according to 
gnucash matched my statements. Over 18 years, that left me with more than 5400 
notes that held absolutely no useful information. And now that I’m withdrawing 
money from those accounts, the bogus notes were distracting when I looked at 
account listings.

Dave
--
Dave Reiser
dbrei...@icloud.com





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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 again [sorry]

[David Reiser via gnucash-user]

except that there is no gnc-fq-check in gnucash 5
--
Dave Reiser
dbrei...@icloud.com





> On May 11, 2023, at 12:55 PM, Kalpesh Patel  wrote:
> 
> That sounds like GNC is not in your path ... try running following in a 
> console window:
> 
> c:\Strawberry\perl\bin\perl.exe "c:\Program Files 
> (x86)\gnucash\bin\gnc-fq-check"
> 
> It should spit out something like this:
> 
> Microsoft Windows [Version 10.0.22621.1702]
> (c) Microsoft Corporation. All rights reserved.
> 
> C:\Users\kalpesh>c:\Strawberry\perl\bin\perl.exe "c:\Program Files 
> (x86)\gnucash\bin\gnc-fq-check"
> ("1.54" "aex" "alphavantage" "amfiindia" "asegr" "asx" "aufunds" "australia" 
> "bamosz" "bet" "bloomberg" "bourso" "bse" "bseindia" "canada" "canadamutual" 
> "comdirect" "cse" "deka" "dutch" "dwsfunds" "europe" "fetch_live_currencies" 
> "fidelity" "fidelity_direct" "finanzpartner" "fondsweb" "fool" "france" 
> "ftfunds" "fundata" "fundlibrary" "goldmoney" "greece" "hu" "hufund" 
> "hungary" "hustock" "iexcloud" "india" "indiamutual" "known_currencies" 
> "morningstarau" "morningstarch" "morningstarjp" "mstaruk" "nasdaq" "nseindia" 
> "nyse" "nzx" "onvista" "oslobors" "romania" "seb_funds" "sinvestor" "six" 
> "tesouro_direto" "tiaacref" "tmx" "tradegate" "tradeville" "treasurydirect" 
> "troweprice" "troweprice_direct" "tsp" "tsx" "ukfunds" "unionfunds" "usa" 
> "xetra" "yahoo_json" "za")
> 
> C:\Users\kalpesh>
> 
> 
> 
> 
> -Original Message-
> From: Graham  
> Sent: Thursday, May 11, 2023 11:49 AM
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Finance:Quote again [sorry]
> 
> Dear team
> 
> Apologies if I am being particularly thick, but I can't get up to date stock 
> prices. The last ones on the system are from March. I've spent ages with the 
> documentation, so I uninstalled strawberry perl, re-run the windows install 
> online price retrieval tool. All went well. 
> But...when I attempt to run perl gnc-fq-check, I get 'Can't open perl script 
> "gnc-fq-check": No such file or directory'.
> 
> In the About section of Gnucash , i get the attached list, with no finance 
> quote shown. Trying to get updated quotes with the price database, it now 
> tells me Finance:Quote is not installed properly.
> 
> Win10, Gnucash 5.
> 
> Any help gratefully received
> 
> --
> --
> Cheerio,
> 
> Graham
> 
> ___
> 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] Issues Retrieving Quotes with v5.0

[David Reiser via gnucash-user]

Is your iMac an Apple Silicon (M1) machine? It’s possible to get mixed 
architecture perl modules installed. If your gnucash-cli -Q error included 
something like “want x86_64, have amd64”, then you definitely have an 
incompatible version of JSON::Parse. The way around that is to enter (in 
Terminal):

sudo arch -arch x86_64 cpan -f JSON::Parse

After that finishes, since gnucash-cli quits at the first error, you need  to 
run gnucash-cli -Q again — both to ensure that the right architecture 
JSON::Parse got installed, and to check if there are any other perl errors.

If necessary, run the above command repeatedly, substituting any new module 
names from arch-related error messages. When gnucash-cli -Q runs without 
complaint, you should be able to get quotes within gnucash 5.0

Dave
--
Dave Reiser
dbrei...@icloud.com





> On Mar 28, 2023, at 1:27 AM, R Losey  wrote:
> 
> David, thank you.
> 
> I did this on my iMac; it ran a LONG time with LOTS of output, and
> installed the development tools, but finally finished. Even though I'm a
> software engineer, it was kind of scary.
> 
> But the "Get Quotes" is still greyed out, even though I ran the
> gnc-fq-update...
> 
> When I attempt the gnucash-cli command, it fails, stating that
> Finance::Quote is missingcthe JSON::Parse module
> 
> 
> On Mon, Mar 27, 2023 at 3:49 PM David H  wrote:
> 
>> Michael,
>> 
>> Is your "Get Quotes" button in Gnucash also greyed out?  I had to run
>> gnc-fq-update in /Applications/Gnucash.app/Contents/Resources/bin in the
>> terminal on macOS and let it update and then start Gnucash before the
>> button became active. Same in windows 11 pro - open a command prompt as
>> Administrator and use the command perl "C:\Program Files
>> (x86)\gnucash\bin\gnc-fq-update" - you need the double quotes around the
>> path because of the space in the path. After I did this it all seemed ok.
>> 
>> Hope this helps,
>> 
>> Cheers David H.
>> 
>> 
>> 
>> On Tue, 28 Mar 2023 at 06:24, Fross, Michael  wrote:
>> 
>>> Hello everyone,
>>> 
>>> I'm looking for a few pointers on how to troubleshoot an issue I'm having
>>> with v5 downloading quotes.  I had no issues with v4.13.  When I select
>>> "Tools|Price Database|GetQuotes" a shell opens and closes quickly and
>>> nothing is updated.
>>> 
>>> I don't seem to have any issues with gnucash-cli.  Here are the results:
>>> ---
>>> C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --verbose -Q dump
>>> yahoo_json acn
>>> acn:
>>> isodate => 2023-03-27
>>> low => 270.64
>>>type => EQUITY
>>>name => acn (Accenture plc)
>>>  pe => 25.180145
>>>exchange => Sourced from Yahoo Finance (as JSON)
>>> eps => 10.88
>>>currency => USD
>>>  method => yahoo_json
>>> success => 1
>>>  volume => 2805531
>>>   close => 272
>>>date => 03/27/2023
>>>  year_range =>242.8 - 345.3
>>>last => 273.96
>>>open => 270.73
>>>   div_yield => 1.5919117
>>>  symbol => acn
>>>high => 274.36
>>> ---
>>> 
>>> Running gnucash with the "--log gnc.scm=debug"  shows the following
>> error:
>>> 
>>> * 15:11:29 ERROR  [gnc_prices_dialog_get_quotes_clicked()] Price
>>> retrieval failed: Failed to parse result returned by Finance::Quote.
>>> Error message:
>>> (1): expected value
>>> 
>>> 
>>> To me, it's odd that gnucash-cli.exe seems to work where the gnucash app
>>> itself does not.
>>> 
>>> I have Finance::Quote: 1.54 installed and it shows this in Help | About
>>> 
>>> Lastly, if I check the security editor, it seems like every quote
>> provider
>>> is greyed out.  This woudl suggest to me that gnucash doesn't think there
>>> is a valid Finance::Quote configured.
>>> 
>>> I'd appreciate any pointers on how to dig deeper and determine what broke
>>> for me between 4.13 and 5.0.  Is anyone else having issues?
>>> 
>>> I'm enjoying v5 quite a bit - congrats on the release.
>>> 
>>> 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
>>> -
>>> 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.
>> 
> 
> 
> -- 
> _
> 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 

Re: [GNC] OFX\QFX import

[David Reiser via gnucash-user]

> On Mar 27, 2023, at 1:00 PM, rick1 via gnucash-user 
>  wrote:
> 
> Just downloaded and installed Ver 5.0.
> 
> I do not see OFX/QFX import. Am I missing something? Surely this is temporary!
> 
> Rick
> 


File>Import>Import OFX/QFX…

Same place as last version.

And QFXDirectConnect seems to be in the same place: Actions>Online Actions>Get 
Transactions
But I can’t test that anymore since my banks have bailed on directconnect 
actions.
--
Dave Reiser
dbrei...@icloud.com


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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 with downloading transactions.

[David Reiser via gnucash-user]

> On Mar 17, 2023, at 7:33 PM, George Riner  wrote:
> 
> I wish there was a way to turn off the 'Bayesian" amount matching. Because I 
> don't want to be close, I want to be exact. So when reconciling I have to 
> carefully watch the matching transactions to make sure they're aren't off by 
> $0.02 or some tiny amount.

In Preferences>Import, try setting “Commercial ATM fees threshold” to 0.00. I 
think that forces the amount match to be exact.

Dave
--
Dave Reiser
dbrei...@icloud.com




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

Re: [GNC] Schedule transaction for 2 Wednesday?

[David Reiser via gnucash-user]

In the scheduled transaction editor, in the Frequency tab, in the box under the 
Daily/weekly/monthly/yearly drop down menu there is a box where you can set 
“Every {number} [time period]

on the next line, it says “On the” [drop down menu] “except on weekends” 
[another drop down menu]

At the bottom of the long list in the first of those drop down menus, you can 
choose 1st, 2nd, 3rd, or 4th [pick a day of the week]

--
Dave Reiser
dbrei...@icloud.com



> On Mar 9, 2023, at 11:38 PM, ToddAndMargo via gnucash-user 
>  wrote:
> 
> Hi All,
> 
> Fedora 37
> gnucash-4.13-1.fc37.x86_64
> 
> How do I set up a scheduled transaction to go off
> the second Wednesday of the month?
> 
> Many thanks,
> -T

___
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] Migrating from PC to Mac

[David Reiser via gnucash-user]

The one issue that hasn’t been brought up today is that you can’t double click 
on the data file and have it launch gnucash on a mac.

So, Launch gnucash. Click on the file menu. Choose “Open…” and use the file 
dialog to navigate to and select your data file.
--
Dave Reiser
dbrei...@icloud.com





> On Feb 16, 2023, at 7:58 PM, David Carlson  
> wrote:
> 
> I don't use a Mac.  We need a Mac user to answer that question.
> 
> 
> 
> On Thu, Feb 16, 2023, 6:48 PM Martin Taylor  wrote:
> 
>> Thanks David
>> 
>> Found the file and have moved it to an iCloud folder. How then do I access
>> it from the Mac?
>> 
>> M
>> 
>> 
>> On 17/02/2023, at 1:33 PM, David Carlson 
>> wrote:
>> 
>> Martin
>> 
>> Open the file on your pc, then hover over the top entry in the drop down
>> menu under File.  Then the file name and folder will appear in the bottom
>> of the window.
>> 
>> 
>> 
>> On Thu, Feb 16, 2023, 5:49 PM Martin Taylor 
>> wrote:
>> 
>>>   Thanks
>>>   Where do I find the data file?
>>> 
>>>   On 17/02/2023 12:35, David Cousens  wrote:
>>> 
>>> Martin
>>> 
>>> Coy the data file from your PC to your Mac and open it with GnuCash
>>> on the Mac.
>>> You could also store the data file in an online storage location
>>> (Dropbox or
>>> similar) or networked storage on your LAN if applicable, so that you
>>> can open it
>>> from either system.
>>> If you have any saved reports you may also want to copy them See
>>>  https://wiki.gnucash.org/wiki/Configuration_Locations  for details.
>>> 
>>> David Cousens
>>> 
>>> On Fri, 2023-02-17 at 12:23 +1300, Martin Taylor wrote:
 
 I’ve got 4.13 installed and running on my PC, and I’ve also set up
>>> 4.13 on my
 Mac.
 
 I’ve tried exporting the account tree and transactions from the PC
>>> to an
 external drive and then importing them into the Mac but have
>>> struck a problem
 with the transaction file where the importer doesn’t recognise the
>>> date format
 or the data in the Deposit and Withdrawal columns, and nothing
>>> I’ve tried has
 got me past that point.
 The account tree seems to come across okay
 I’m sure there’s another way to do this, would welcome any
>>> suggestions
 
 Martin
 ___
 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.
>>> 
>> 
>> 
> ___
> 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] reconcile dates

[David Reiser via gnucash-user]

True, and sometimes I move the transaction to the actual month. But if it’s 
supposed to happen in the future, and happens now instead, if gnucash isn’t 
showing me pending transactions after the closing date, then reconciling is 
harder because I won’t get the reminder that the credit union was early in my 
favor.
--
Dave Reiser
dbrei...@icloud.com





> On Jan 7, 2023, at 5:50 PM, Gyle McCollam  wrote:
> 
> Technically, if your credit union credits the January payment in December and 
> you have access to  the money in December it should be credited in your books 
> in December, not January.  However, if you enter it as January in your books, 
> I can see why you would need to have Gnucash look past the end date.  This 
> happens to me as well, but I record the transaction in the month it happens, 
> not when it is supposed to happen. 
> 
> Thank You,   
> Gyle McCollam
> Gyle McCollam
> gmccol...@live.com <mailto:gmccol...@gyleshomes.com>   email
> From: David Reiser mailto:dbrei...@icloud.com>>
> Sent: Saturday, January 7, 2023 5:43 PM
> To: Gyle McCollam mailto:gmccol...@live.com>>
> Cc: Kevin T mailto:neviki...@yahoo.com>>; David T. 
> mailto:sunfis...@yahoo.com>>; Gnucash Users 
> mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] reconcile dates
>  
> My credit union activates deposits for my account when received. Deposits 
> from outside that are intended for the first of the month are usually 
> credited in the prior month. When that happens, I need gnucash to look beyond 
> the end of the month for the transaction that represents a January payment 
> credited in December, or my reconciliation will fail.
> --
> Dave Reiser
> dbrei...@icloud.com <mailto:dbrei...@icloud.com>
> 
> 
> 
> 
> 
>> On Jan 7, 2023, at 5:27 PM, Gyle McCollam > <mailto:gmccol...@live.com>> wrote:
>> 
>> I to don't see the need to include transactions whose date falls beyond the 
>> closing date of the reconciliation.  Gnucash could cutoff any transactions 
>> whose date is after the closing date.  However, I will say that I have 
>> gotten used to this little quirk and since I import most of my monthly 
>> transactions (and the financial institution knows how to cut off 
>> transactions beyond the closing date) using QFX, when I reconcile the needed 
>> transactions have already been checked and the ones after the closing have 
>> not.  Even though in a manual reconciliation you wouldn't even look at 
>> transactions after the closing date, it does no harm to include them.
>> 
>> 
>> Thank You,
>> 
>> Gyle McCollam
>> 
>> Gyle McCollam
>> 
>> gmccol...@live.com 
>> <mailto:gmccol...@live.com><mailto:gmccol...@gyleshomes.com>   email
>> 
>> 
>> From: gnucash-user > <mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org>> on behalf of 
>> David T. via gnucash-user > <mailto:gnucash-user@gnucash.org>>
>> Sent: Saturday, January 7, 2023 3:54 PM
>> To: Kevin T mailto:neviki...@yahoo.com>>
>> Cc: Gnucash Users > <mailto:gnucash-user@gnucash.org>>
>> Subject: Re: [GNC] reconcile dates
>> 
>> Your records and the bank's differ. The reconciliation date may include 
>> entries that you've entered with later dates, and how would GnuCash 
>> determine the proper cutoff?
>> 
>> Personally, I don't have trouble determining when the difference figure goes 
>> to 0.
>> 
>> ⁣David T. ​
>> 
>> On Jan 7, 2023, 11:45 PM, at 11:45 PM, Kevin T via gnucash-user 
>> mailto:gnucash-user@gnucash.org>> wrote:
>>> Is there some reason that the reconcile feature looks past the closing
>>> date specified?
>>> I have imported numerous months of transactions for an account.  Trying
>>> to reconcile only the first month with 0 balance and 0 transactions
>>> before the starting date.  I provide the 'statement date' to the
>>> reconcile feature and it brings up every transaction entered, even the
>>> ones after the 'statement date'.
>>> This is not how a person would reconcile this.  We could concern
>>> ourselves with on the transactions that occur before the closing date
>>> 'statement date'.
>>> Is there something I am missing ?
>>> Kevin
>>> ___
>>> 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

Re: [GNC] reconcile dates

[David Reiser via gnucash-user]

My credit union activates deposits for my account when received. Deposits from 
outside that are intended for the first of the month are usually credited in 
the prior month. When that happens, I need gnucash to look beyond the end of 
the month for the transaction that represents a January payment credited in 
December, or my reconciliation will fail.
--
Dave Reiser
dbrei...@icloud.com





> On Jan 7, 2023, at 5:27 PM, Gyle McCollam  wrote:
> 
> I to don't see the need to include transactions whose date falls beyond the 
> closing date of the reconciliation.  Gnucash could cutoff any transactions 
> whose date is after the closing date.  However, I will say that I have gotten 
> used to this little quirk and since I import most of my monthly transactions 
> (and the financial institution knows how to cut off transactions beyond the 
> closing date) using QFX, when I reconcile the needed transactions have 
> already been checked and the ones after the closing have not.  Even though in 
> a manual reconciliation you wouldn't even look at transactions after the 
> closing date, it does no harm to include them.
> 
> 
> Thank You,
> 
> Gyle McCollam
> 
> Gyle McCollam
> 
> gmccol...@live.com   email
> 
> 
> From: gnucash-user  on 
> behalf of David T. via gnucash-user 
> Sent: Saturday, January 7, 2023 3:54 PM
> To: Kevin T 
> Cc: Gnucash Users 
> Subject: Re: [GNC] reconcile dates
> 
> Your records and the bank's differ. The reconciliation date may include 
> entries that you've entered with later dates, and how would GnuCash determine 
> the proper cutoff?
> 
> Personally, I don't have trouble determining when the difference figure goes 
> to 0.
> 
> ⁣David T. ​
> 
> On Jan 7, 2023, 11:45 PM, at 11:45 PM, Kevin T via gnucash-user 
>  wrote:
>> Is there some reason that the reconcile feature looks past the closing
>> date specified?
>> I have imported numerous months of transactions for an account.  Trying
>> to reconcile only the first month with 0 balance and 0 transactions
>> before the starting date.  I provide the 'statement date' to the
>> reconcile feature and it brings up every transaction entered, even the
>> ones after the 'statement date'.
>> This is not how a person would reconcile this.  We could concern
>> ourselves with on the transactions that occur before the closing date
>> 'statement date'.
>> Is there something I am missing ?
>> Kevin
>> ___
>> 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.

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

[David Reiser via gnucash-user]

bug, maybe?

import-export/qif-imp/qif-to-gnc.scm says:

((stksplit)
 (let* ((splitratio (n/ num-shares (gnc-numeric-create 10 1)))
(in-shares
 (xaccAccountGetBalance near-acct))
(out-shares (n* in-shares splitratio)))
   (xaccSplitSetAmount gnc-near-split out-shares)
   (xaccSplitSetAmount gnc-far-split (n- in-shares))
   (xaccSplitSetValue gnc-near-split (n- split-amt))
   (xaccSplitSetValue gnc-far-split split-amt


num-shares is the value of the qif Q line, so it looks like the entered split 
ratio is being divided by 10. But I can’t find a definition of 
gnc-numeric-create. And my scheme (well, LISP, in my case) is so rusty it 
almost might be worse than not knowing it in the first place...
--
Dave Reiser
dbrei...@icloud.com





> On Jan 5, 2023, at 6:13 PM, m...@tgr66.me wrote:
> 
> So, the ratio * 10 does seem to be working. :man_shrugging:
> 
> For example, if it is a 4 for 1 split, 40
> If it is a 1 for 10 split, 1
> 
>> On Jan 5, 2023, at 14:17, m...@tgr66.me wrote:
>> 
>> Yes. I missed adding that to the list I’ve tried.
>> 
>> In the full work minimal example below, the share balance ends up at 1.2
>> 
>> !Account
>> NAssets:Investments:Brokerage Account:Joint Brokerage
>> TInvst
>> ^
>> !Type:Bank
>> D01/11/2020
>> NPayment/Deposit
>> PTrf My Bank
>> CX
>> T1,000.00
>> MDeposit
>> LAssets:Current Assets:My Bank
>> ^
>> !Type:Invst
>> D12/2/2021
>> NBuy
>> PXYZ, INC
>> YXYZ
>> I150
>> T450
>> Q3
>> CR
>> M3 shares @ 150; Nothing to see here
>> ^
>> !Type:Invst
>> D1/1/2022
>> NStkSplit
>> PXYZ, INC
>> YXYZ
>> CR
>> Q4
>> M4 for 1 split
>> ^
>> 
>> Then I changed Q to 40 and while I end up with the correct balance (GnuCash 
>> creates two transactions, one removing the original three shares, and the 
>> second adding 12 shares), I have no idea if that is just luck or if I’ve 
>> stumbled on new math :-)
>> 
>> I’ll experiment some more.
>> 
>> 
>>> On Jan 5, 2023, at 14:02, David Reiser  wrote:
>>> 
>>> I’ve never used QIF for stock splits, but the obvious question is “Have you 
>>> tried Q4?” After all, 4/1 is numerically equal to 4 (a ratio reduced to a 
>>> single number).
>>> --
>>> Dave Reiser
>>> dbrei...@icloud.com
>>> 
>>> 
>>> 
>>> 
>>> 
>>>> On Jan 5, 2023, at 2:51 PM, m...@tgr66.me wrote:
>>>> 
>>>> I’ve searched considerably, but if I missed it, I apologize.
>>>> 
>>>> Docs for QIF say the Q field should contain the split ratio. I’ve tried 
>>>> various options, but I’m not getting the expected results after import.
>>>> 
>>>> !Type:Invst
>>>> D8/31/2020
>>>> NStkSplit
>>>> PAPPLE INC
>>>> YAAPL
>>>> CR
>>>> M4 for 1 split; 
>>>> Q36 // Have also tried 4:1, 4/1 and simply 48
>>>> ^
>>>> 
>>>> GnuCash 4.13 on macOS. I’ve not tried yet on my Linux box.
>>>> 
>>>> 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
>>>> -
>>>> 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] QIF format for StkSplit

[David Reiser via gnucash-user]

I’ve never used QIF for stock splits, but the obvious question is “Have you 
tried Q4?” After all, 4/1 is numerically equal to 4 (a ratio reduced to a 
single number).
--
Dave Reiser
dbrei...@icloud.com





> On Jan 5, 2023, at 2:51 PM, m...@tgr66.me wrote:
> 
> I’ve searched considerably, but if I missed it, I apologize.
> 
> Docs for QIF say the Q field should contain the split ratio. I’ve tried 
> various options, but I’m not getting the expected results after import.
> 
> !Type:Invst
> D8/31/2020
> NStkSplit
> PAPPLE INC
> YAAPL
> CR
> M4 for 1 split; 
> Q36 // Have also tried 4:1, 4/1 and simply 48
> ^
> 
> GnuCash 4.13 on macOS. I’ve not tried yet on my Linux box.
> 
> 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
> -
> 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] Changes: Macbook Pro

[David Reiser via gnucash-user]

> On Dec 19, 2022, at 6:31 PM, Paul Roberts  wrote:
> 
> I am running gnucash on the following hardware:
> MacBook Pro
> Chip: Apple M1 Pro
> Memory: 16 GB
> macOS: Ventura 13.0.1
> 
> Was working great until a couple of weeks ago. Now it is working remarkably
> differently. When I attempt to select a date from a drop calendar it just
> closes, In most any dialog box I need to select OK twice, and just some
> other little things that are different than were before. I am a little
> worried that I might lose some data if things are going wrong.
> 
> I am wondering if anyone else is experiencing the same things.
> 
> -- 
> 
> Paul L Roberts, Ph.D.
> 
> Head of School
> 
> Bay Islands International School
> 
> 42 E Sandy Bay Beach Road, Sandy Bay
> 
> Roatan, Islas de la Bahia, Honduras
> 
> +504 9817-0344
> 
> +504 9335-5272
> 
> www.roatanschools.org
> 
> Education That Will Take You Anywhere
> ___

That came from an incompatibility between Ventura and the gtk version available 
when gnucash 4.12 was built. Fixed in gnucash 4.13 (released yesterday),
--
Dave Reiser
dbrei...@icloud.com





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

Re: [GNC] Open banking platform support

[David Reiser via gnucash-user]

> On Dec 14, 2022, at 6:08 PM, Kalpesh Patel  wrote:
> 
> 
> 
> Bank of America is one of the banks that has stopped supporting OFX method,
> in addition to Chase Bank, for transaction download via direct connect as of
> early Nov and moved to the open banking platform. Is there any roadmap to
> get that supported as part of the GNC native method for download of
> transactions?  
> 
I would be extremely surprised if it ever becomes possible for gnucash to 
participate in the new bank connection realm.

The Open Banking initiative is only open in the sense of business-to-business. 
The banks will only talk to authorized 
API implementations. And becoming authorized means keeping the banks and API 
consortium happy. That takes money as well as other hoops to jump through.

Dave
--
Dave Reiser
dbrei...@icloud.com




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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 on MacOS 12.5 ?

[David Reiser via gnucash-user]

> On Oct 23, 2022, at 10:40 PM, john  wrote:
> 
> 
> 
>> On Oct 23, 2022, at 10:41 AM, Jesse Ayers  wrote:
>> 
>> I have been using GnuCash on Mac for several years.  I have purchased a new 
>> MacBook that runs MacOS 12.5 “Monterey.”  Can someone tell me if Gnucash 
>> will run on this new OS?  I haven’t been able to find an answer on the 
>> Gnucash site or in the text files that come with version 4.12.
> 
> 
> The only issue specific to Apple Silicon is that Finance::Quote doesn't work, 
> see https://bugs.gnucash.org/show_bug.cgi?id=798456.
> 
> Regards,
> John Ralls
> ___


It works for me on a Mac Studio (M1). Getting F::Q installed was a major pain, 
though. Eventually what worked for me was using xcode-select to install a 
second set of CommandLineTools in the non-xcode default location, make sure 
that was the path cpan was using, and then installing F::Q. 

I have no idea if there was a more sane way to point cpan to CommandLineTools 
in the usual XCode-related location. This is not the first time I’ve had two 
installations of CommandLineTools, but it doesn’t seem to interfere with what I 
use them for.

Dave
--
Dave Reiser
dbrei...@icloud.com





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

[GNC] Chase OFXdirect connect - another one bites the dust

[David Reiser via gnucash-user]

As of today, aqbanking reports that “ofx.chase.com ” is 
an unknown host. Banktivity reports that today is the start of Chase enforcing 
data access only through Open Banking APIs. 

OFX data format transaction downloads are still available from the Chase online 
web accounts — manual download followed by File>Import>Import OFX/QFX… in 
Gnucash. 
--
Dave Reiser
dbrei...@icloud.com





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

Re: [GNC] Setting up online banking finishes without success or error...

[David Reiser via gnucash-user]

> On Jul 19, 2022, at 10:57 PM, Jeffrey Bush  wrote:
> 
> I am setting up OFX-DirectConnect backend in GnuCash and I enter all of the
> information for the user and when I get to the end it asks you to request
> the account list. I do that and the resulting output says:
> 
> 22:34:28 Sending request...
> 22:34:28 Using GnuTLS default ciphers.
> 22:34:28 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-128-GCM:AEAD
> 22:34:28 Waiting for response...
> 22:34:28 Operation finished, you can now close this window.
> 
> All examples I can see online have something between "Waiting for
> response..." and "Operation finished". An error, a success message,
> something. But I get nothing at all.
> 
> I have double-checked all of the settings and they are correct. I have used
> the Python library ofxtools to connect with the settings and they work and
> I am able to get a list of accounts and transactions with that tool. The
> settings are:
> 
> FID = '94089'
> ORG = 'starone.org'
> URL = 'https://fs-services.1fsapi.com/eftxweb/tyfone.ofx'
> Client ID = 'F878CCBF-0AB5-4C61-A8DD-DD77275B4558'
> The username and password don't have anything besides letters and numbers
> in them (the wiki mentioned that that could sometimes be a problem). If I
> do give a username/password combo that is bad I do get an error during the
> account list retrieval, so it is at least getting that far.
> 
> Is there any way to get more logs of why this might be going wrong? I was
> thinking of submitting this to the aq mailing list, but I don't know
> German...
> 
> Another solution that I would actually prefer is to be able to run OFX
> import from the command line or API. I know that it would have to make
> assumptions about which accounts to make expenses go into since that is
> normally done interactively, but I am actually completely fine with that.
> What I want is to get the bayesian matching predictions that I can correct
> later.
> 
> Thanks!
> ___

Well, you don’t have an error message, so that suggests you completed the 
request. 

That window that you can close is the comm status window, not the aqbanking 
setup window.

If you look in the aqbanking setup dialog, there is a Users tab and an Accounts 
tab. Have you looked to see if anything has shown up in the Accounts tab?

Martin (author of aqbanking) does just fine with English queries on the 
aqbanking mailing list. And he’s the best authority on aqbanking operation. 
Occasionally the gnucash interface with aqbanking throws in a couple curve 
balls, but he’d probably still know how to proceed.


--
Dave Reiser
dbrei...@icloud.com





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

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

[David Reiser via gnucash-user]

> On May 30, 2022, at 5:09 PM, Dieter Kip via gnucash-user 
>  wrote:
> 
> Hi there!
> 
> I installed Finance::Quite on my MacBook Air and GnuCash recognizes that it 
> is installed on the computer. However, GnuCash is not obtaining any quotes….
> 
> When I test the “generic” commands to test the program like ECHO I got a 
> response… All other commands like gnc-fa-update are not executed….
> 
> Could that be because the GnuCash path is not recognized/properly set up to 
> get the quotes into GnuCash?
> 
> Thank you very much for your help!!
> 
> With kind regards,
> 
> Dieter Kip
> 
> 

It could be a lot of things, but when I had a similar instance doing “install 
Mozilla::CA” via cpan solved my issue. In general, I’ve always had the CA file 
installed, but when Apple messed with the location of perl, the lack of the CA 
file wasn’t caught during the installation of Finance::Quote or any of its 
dependencies.

--
Dave Reiser
dbrei...@icloud.com





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

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

[David Reiser via gnucash-user]

The three tags in question are not valid OFX tags, which means they are custom 
to either QFX  or BofA. I’d seriously doubt libofx would be willing to get into 
trying to maintain custom tags.
--
Dave Reiser
dbrei...@icloud.com





> On May 4, 2022, at 9:49 PM, davidcousen...@gmail.com wrote:
> 
> 
> 
> The other possibility if libofx supports the credit card tags  would be to 
> give
> users the option of having the different card numbers recognized as 
> subaccounts
> of the main credit card account .  If libofx doesn't support it it is unlikely
> much can be done other than raising it as an issue with the libofx 
> developer(s).
> Once it is in libofx then GnuCash can be modified to recognize the situation.
> 
> David Cousens
> 
> On Wed, 2022-05-04 at 20:01 -0500, David Carlson wrote:
>> Perhaps there should be a GnuCash error message if libofx fails.
>> 
>> On Wed, May 4, 2022, 4:41 PM Jean Laroche  wrote:
>> 
>>> Don't know if my last messages went through. Here they are again:
>>> 
>>> Running gnucash with --debug shows what the issue is.
>>> 
>>> Removing the lines that contain the CARDNUM, CARDNAME and MCC elements
>>> makes the file import correctly.
>>> I'm not sure why ofxlib does not just ignore the unrecognized elements,
>>> but that's the way it is.
>>> Perhaps file a bug with libofx?
>>> 
>>> In the meantime, if you're on a linux box or a mac and you're familiar
>>> with linux commands, you can use the command line to strip the ofx file
>>> from the offending lines using sed, for example on the mac:
>>> 
>>> cat stmt.qfx | sed -E "/ stmt_fixed.qfx
>>> 
>>> 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
>>> 
>>> 
>>> 
>>> 
>>> On 5/4/22 2:24 PM, Kalpesh Patel wrote:
 I did experimented with the file he has attached and I can concur that
>>> OFX
 matcher is bailing out, or more likely silently exiting as if it was NOP.
 This is most likely an OFX import bug.
 
 
 
 If you start a fresh new file with just the 'Common Accounts' and then
 import the ofx file that was originally attached to the e-mail, GNC 4.10
>>> on
 Windows 10 prompts to create a new account which it does with 'Unknown
>>> OFX
 credit card account "Credit card 4003901016729673"' account name and then
 there is no subsequent dialogue box to import the single transaction
>>> that is
 in that file. It exit with the effect that you cancelled the import after
 creating the account. If I reimport the file again then there is nothing
 displayed, -- nothing;  nada --,  such as error messages or the
>>> notification
 windows that one transaction was found and that it was a duplicate. It
>>> once
 again simply silently exits and goes back if like no "import" was
>>> performed
 at all or cancelled. I don't see the transaction getting added to the
 register either.
 
 
 
 
 
 
 
 --
 
 
 
 Message: 12
 
 Date: Wed, 4 May 2022 03:25:25 +
 
 From: Peter Wu mailto:peter_cd...@hotmail.com>
 
 
 To: "gnucash-user@gnucash.org  "
 mailto:gnucash-user@gnucash.org> >
 
 Subject: [GNC] QFX file for Bank of American business account not
 
 invoking Import Matcher
 
 Message-ID:
 
 
 
>>> >>> OM
 >> dm8p221mb05727f95859d29b4d429f0a4c2...@dm8p221mb0572.namp221.prod.ou
 TLOOK.COM> >
 
 
 
 Content-Type: text/plain; charset="windows-1252"
 
 
 
 Hello,
 
 Gnucash community.  Hope everyone is doing well and having a good time.
>>> Two
 questions:
 
 
 
 
 
   1.  Beside the mailing-list.  Does anyone know a forum where we can
>>> ask
 and discuss issues?  I feel it may be easier to search/discuss/answer
 questions 

Re: [GNC] No Stock Quotes - OS Monterey, Gnucash 4.8(Build ID: 4.8a+(2021-09-28))

[David Reiser via gnucash-user]

The entities mentioned in this thread are all Perl modules, so they are 
installed via CPAN.

I usually launch CPAN with ’sudo cpan’ so I can get help when I botch a command.

Once in cpan, ‘install Mozilla::CA’ should work.
--
Dave Reiser
dbrei...@icloud.com





> On Feb 10, 2022, at 1:51 PM, smad...@hotmail.com wrote:
> 
> Hi David,
> 
>  Per your suggestion, I tried  to install the certificate collection by 
> typing “sudo install Mozilla::CA” and got the following:
> 
> dwa1@dwa1 ~ % sudo install Mozilla::CA
> Password:
> usage: install [-bCcpSsv] [-B suffix] [-f flags] [-g group] [-m mode]
>[-o owner] file1 file2
>install [-bCcpSsv] [-B suffix] [-f flags] [-g group] [-m mode]
>[-o owner] file1 ... fileN directory
>install -d [-v] [-g group] [-m mode] [-o owner] directory ...
> dwa1@dwa1 ~ % 
> 
> Obviously I need more or different information to get and install 
> Mozilla::CA.  I’m really out of my element here so if you can provide the 
> actual command I need to use I would appreciate it.  
> 
> 
> 
>> On Feb 9, 2022, at 22:39, David Reiser > <mailto:dbrei...@icloud.com>> wrote:
>> 
>> Matthias Fasching noted last summer that he needed to install Mozilla::CA to 
>> get quotes working for him in Big Sur.
>> 
>> That missing certificate collection was what had been keeping my office mac 
>> from being able retrieve quotes for at least a couple Gnucash versions. 
>> That change was after dealing with the B::Keywords test failures and needing 
>> to upgrade the Test2 module.
>> 
>> 
>> --
>> Dave Reiser
>> dbrei...@icloud.com <mailto:dbrei...@icloud.com>
>> 
>> 
>> 
>> 
>> 
>>> On Feb 9, 2022, at 11:51 PM, john >> <mailto:jra...@ceridwen.us>> wrote: 
>>> 
>>> Your dump looks pretty much llke a rerun of the same problem except that 
>>> now you also have an SSL certificate problem.
>>> 
>>> /usr/bin is right where you'd expect it, but you can't see it with Finder, 
>>> only from the terminal. For example you can type
>>>   ls -l /usr/bin/make
>>> and if it's there get back something like
>>>   -rwxr-xr-x  1 root  wheel  167088 Dec  7 15:39 /usr/bin/make*
>>> 
>>> Did you install Xcode in /Applications without messing with the name? If 
>>> not you might try
>>>  sudo xcode-select -s /Path/to Xcode.app
>>> making the obvious substitution. 
>>> Or, since something seems confused, maybe run that even if you *did* 
>>> install it in /Applications.
>>> 
>>> Since make is in the Xcode bundle you might be able to work around the 
>>> problem for Finance::Quote with 
>>>  export PATH="$PATH:/Path/to/Xcode.app/Contents/Developer/usr/bin"
>>> and then running gnc-fq-update again.
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>> 
>>>> On Feb 9, 2022, at 8:05 PM, dennis adams >>> <mailto:smad...@hotmail.com>> wrote:
>>>> 
>>>> John, thanks for the response.  I believe I have the full XCode (32GB 
>>>> worth) but don’t know for sure since I don’t use it.  I only have it 
>>>> because of GC.  I hadn’t opened it but did after your response and told it 
>>>> to install the “additional components”.  After that, I ran the 
>>>> “gnc-fq-update” command again and got the “You need to install the 
>>>> following Perl modules: Finance::Quote” result when I ran a check, like 
>>>> before.  Terminal info is attached.  (Note: I changed the GC app name from 
>>>> Gnucash 4.8.app to just Gnucash.app so you will see that change in the 
>>>> sudo command line). 
>>>> 
>>>> You stated that on your mac, “xcrun” and “make”are in the /usr/bin.  Not 
>>>> sure where that is but I right clicked the xCode app and then clicked show 
>>>> contents.  With this following path: xCode.app/Contents/Developer/usr/bin  
>>>>  I did find “make” but did not find “xcrun”.  Is that the correct location 
>>>> where they should be?  There are a lot of other xc—— commands but no 
>>>> “xcrun”
>>>> 
>>>> You stated I could install command-line tools by running  “xcode-select 
>>>> —install”.  Even though I think I have the full xCode with 32.12 GB, I 
>>>> went ahead and ran the command.  Since I am on slow DSL (2.87Mbps) it 
>>>> showed 215 hours remaining to download so I stopped it.  
>>>> 
>>>> Any other thoughts or ways to get “xcrun”?
&

Re: [GNC] No Stock Quotes - OS Monterey, Gnucash 4.8(Build ID: 4.8a+(2021-09-28))

[David Reiser via gnucash-user]

Matthias Fasching noted last summer that he needed to install Mozilla::CA to 
get quotes working for him in Big Sur.

That missing certificate collection was what had been keeping my office mac 
from being able retrieve quotes for at least a couple Gnucash versions. 
That change was after dealing with the B::Keywords test failures and needing to 
upgrade the Test2 module.


--
Dave Reiser
dbrei...@icloud.com





> On Feb 9, 2022, at 11:51 PM, john  wrote: 
> 
> Your dump looks pretty much llke a rerun of the same problem except that now 
> you also have an SSL certificate problem.
> 
> /usr/bin is right where you'd expect it, but you can't see it with Finder, 
> only from the terminal. For example you can type
>   ls -l /usr/bin/make
> and if it's there get back something like
>   -rwxr-xr-x  1 root  wheel  167088 Dec  7 15:39 /usr/bin/make*
> 
> Did you install Xcode in /Applications without messing with the name? If not 
> you might try
>  sudo xcode-select -s /Path/to Xcode.app
> making the obvious substitution. 
> Or, since something seems confused, maybe run that even if you *did* install 
> it in /Applications.
> 
> Since make is in the Xcode bundle you might be able to work around the 
> problem for Finance::Quote with 
>  export PATH="$PATH:/Path/to/Xcode.app/Contents/Developer/usr/bin"
> and then running gnc-fq-update again.
> 
> Regards,
> John Ralls
> 
> 
>> On Feb 9, 2022, at 8:05 PM, dennis adams  wrote:
>> 
>> John, thanks for the response.  I believe I have the full XCode (32GB worth) 
>> but don’t know for sure since I don’t use it.  I only have it because of GC. 
>>  I hadn’t opened it but did after your response and told it to install the 
>> “additional components”.  After that, I ran the “gnc-fq-update” command 
>> again and got the “You need to install the following Perl modules: 
>> Finance::Quote” result when I ran a check, like before.  Terminal info is 
>> attached.  (Note: I changed the GC app name from Gnucash 4.8.app to just 
>> Gnucash.app so you will see that change in the sudo command line). 
>> 
>> You stated that on your mac, “xcrun” and “make”are in the /usr/bin.  Not 
>> sure where that is but I right clicked the xCode app and then clicked show 
>> contents.  With this following path: xCode.app/Contents/Developer/usr/bin   
>> I did find “make” but did not find “xcrun”.  Is that the correct location 
>> where they should be?  There are a lot of other xc—— commands but no “xcrun”
>> 
>> You stated I could install command-line tools by running  “xcode-select 
>> —install”.  Even though I think I have the full xCode with 32.12 GB, I went 
>> ahead and ran the command.  Since I am on slow DSL (2.87Mbps) it showed 215 
>> hours remaining to download so I stopped it.  
>> 
>> Any other thoughts or ways to get “xcrun”?
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>>> On Feb 9, 2022, at 18:54, john >> > wrote:
>>> 
>>> 
>>> 
 On Feb 9, 2022, at 1:36 PM, dennis adams >>> > wrote:
 
 Upgraded to Monterey (V12.2) and got black screen for GC.  Read mailing 
 list and saw  where I needed to get GC 4.8 which I did.  Installed 4.8 and 
 GC came up and displayed correctly but am now unable to get stock quotes.  
 The Price Database Get Quotes button is greyed out.
 
 Went to Applications, GC 4.8, Contents, Resources, bin and clicked on 
 gnc-fq-check which said:
 
 “Last login: Wed Feb 9 13:18:07 on ttys000
 /Applications/Gnucash\ 4.8.app/Contents/Resources/bin/gnc-fq-check ; exit; 
 dwa1@dwa1 ~ % /Applications/Gnucash\ 
 4.8.app/Contents/Resources/bin/gnc-fq-check
 ; exit;
 You need to install the following Perl modules: Finance::Quote
 Use your system's package manager to install them, or run 'gnc-fq-update' 
 as root.
 missing-lib
 Saving session...
 ...copying shared history...
 ...saving history...truncating history files... ...completed.
 [Process completed] “
 
 I had old version of XCode which didn’t work with Monterey so updated to 
 version 13.2.1 and then ran “sudo /Applications/Gnucash\ 
 4.8.app/Contents/Resources/bin/gnc-fq- update”.  Terminal info from that 
 run is attached, but basically it didn’t work since when I ran the 
 gnc-fq-check again, I got the same message as above.
 
 I’m well out of my depth with all this and not sure where to go from here. 
  The Terminal information does not really make sense to me but there were 
 several statements like “missing xcrun at: 
 /Library/Developer/CommandLineTools/usr/bin/xcrun “  and “the following 
 files are missing in your kit: .travis.yml “ as well as others
 
 It would seem that if I had all the FQ commands in 
 /Applications/Gnucash\4.8.app/Contents/Resources/bin/ xxx then I have FQ 
 installed but the check says no.  Don’t know where to go from here.  Any 
 help would be appreciated.
>>> 
>>> Most of the modules failed to 

Re: [GNC] Crash getting online transactions

[David Reiser via gnucash-user]

> On Jan 30, 2022, at 12:52 PM, Jon Schewe  wrote:
> 
> I've recently found that getting online transactions for my savings
> account crashes GnuCash. Getting the checking account and credit card
> accounts from the same bank work fine. I turned on the debug log and
> found this:
> 
> * 11:50:01  INFO 
> [xaccAccountGetBalanceInCurrency]  baln=453392/100
> * 11:50:05 ERROR <> provider_sendcmd.c:  355: Handling user
> "myusername"
> * 11:50:05 ERROR <> provider_sendcmd.c:  272: Handling account "14"
> * 11:50:10 ERROR  gui_dialogs.c:  365: Progress by id
> 0002 not found
> * 11:50:10 ERROR  transaction.c: 4916: List missing
> * 11:50:10  INFO  [qof_event_generate_internal] id=16
> hi=0x55abf7a45610 han=0x7f3ee5b5a790 data=(nil)
> 
> Any suggestions?
> 
> Using GnuCash 4.9-2 Flatpak on Ubuntu Linux.
> 
> Jon
> 
4.9 crashes on aqbanking ofxdirectconnects if there are no new transactions to 
display in the matcher window. The choices are to go back to 4.8 or wait for 
4.10
--
Dave Reiser
dbrei...@icloud.com





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

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

[David Reiser via gnucash-user]

What do the  tag contents say about timezone?

I have some ofx files from TDBanknorth (as it was known in the US back in 2007) 
where the  field said the server was keeping time in GMT. None of the 
transactions declared a timezone, but all of the transaction times were 17. 
There was significant evidence that TD had written their own ofx software 
rather than pay Intuit. And it sure looks like the transaction times were local 
instead of server time.

Dave
--
Dave Reiser
dbrei...@icloud.com





> On Jan 11, 2022, at 6:20 PM, xraive .  wrote:
> 
> Yes I live in the same time zone as the time zone in the file.
> 
> 
> From: David Carlson 
> Sent: Tuesday, January 11, 2022 10:57 PM
> To: xraive . 
> Cc: Jean Laroche ; gnucash-user@gnucash.org 
> 
> Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)
> 
> And do you live in the Eastern Standard Time zone?
> 
> 
> On Tue, Jan 11, 2022, 4:49 PM xraive . 
> mailto:xra...@hotmail.com>> wrote:
> If I haven't mentioned it, I'm running GNUCASH Version: 4.9 Build ID: 
> 4.9+(2021-12-18) on a Windows 10 PC.  The time settings on this PC are 
> correct as far as I can tell.
> 
> Thanks in advance.
> 
> 
> From: xraive . mailto:xra...@hotmail.com>>
> Sent: Tuesday, January 11, 2022 10:33 PM
> To: David Carlson 
> mailto:david.carlson@gmail.com>>; Jean 
> Laroche mailto:rip...@gmail.com>>
> Cc: gnucash-user@gnucash.org 
> mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)
> 
> Sorry for the late response.  I tried removing [-5:EST] and the issue still 
> persists. All the dates are still reported as one day earlier.  I imported 
> the same file in MSMoney and the dates matched the banks if that helps.
> 
> Thanks for your assistance so far.
> 
> From: gnucash-user 
> mailto:hotmail@gnucash.org>>
>  on behalf of David Carlson 
> mailto:david.carlson@gmail.com>>
> Sent: Tuesday, January 11, 2022 9:33 PM
> To: Jean Laroche mailto:rip...@gmail.com>>
> Cc: gnucash-user@gnucash.org 
> mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)
> 
> That -5 EST relates local time to universal time and may come into play if
> the local computer clock is not set to the local time zone.  Usually it
> clarifies the source time reference of the data.
> 
> On Tue, Jan 11, 2022, 2:07 PM Jean Laroche 
> mailto:rip...@gmail.com>> wrote:
> 
>>> I wonder what happens if the "[-5:EST]" gets removed.  The dates seem to
>> have 0200 as their time; subtracting 5 hours from that would return -3
>> o'clock (and presumably shift the date back one).
>> 
>> You could do a test where you modify your OFX file to remove [-5:EST]
>> from all transactions (you can do that easily in an editor), then try to
>> import it and see whether this fixes the dates.
>> 
>> After that the question is whether that [-5:EST] is valid or not.
>> Jean
>> 
>> 
>> On 1/11/22 11:59 AM, D. via gnucash-user wrote:
>>> But EFT transactions (which are the bulk of my txns these days)
>> shouldn't get shifted around much at all. I'd be miffed if every EFT entry
>> were a day off.
>>> 
>>> 
>>>  Original Message 
>>> From: Gyle McCollam mailto:gmccol...@live.com>>
>>> Sent: Tue Jan 11 13:33:51 EST 2022
>>> To: "D." mailto:sunfis...@yahoo.com>>
>>> Cc: "gnucash-user@gnucash.org" 
>>> mailto:gnucash-user@gnucash.org>>
>>> Subject: Re: Re: [GNC] Transaction Date issues during import OFX file
>> (TD Bank)
>>> 
>>> I find my dates usualy do not agree with the bank dates.  I record
>> credit card bills when I pay them (electronically) and they are recorded by
>> the payee on the same date.  However, they usually hit my bank the next
>> banking day.  This isn't and shouldn't be a problem or concern.  Actual
>> physical checks take even longer to show up at the bank.  This is all
>> normal.
>>> 
>>> 
>>> Thank You,
>>> Gyle McCollam
>>> 
>>> Gyle McCollam
>>> 
>>> 609.680.2326 Mobile
>>> 
>>> gmccol...@live.com
>>>email
>>> 
>>> 
>>> From: gnucash-user 
>>> mailto:gmail@gnucash.org>>
>> on behalf of D. via gnucash-user 
>> mailto:gnucash-user@gnucash.org>>
>>> Sent: Tuesday, January 11, 2022 1:20 PM
>>> To: David Carlson 
>>> mailto:david.carlson@gmail.com>>
>>> Cc: GnuCash mailto:gnucash-user@gnucash.org>>
>>> Subject: Re: [GNC] Transaction Date issues during import OFX file (TD
>> Bank)
>>> 
>>> I'd be annoyed at the shift.
>>> 
>>> I wonder what happens if the "[-5:EST]" gets removed.  The dates seem to
>> have 0200 as their time; subtracting 5 hours from that would return -3
>> o'clock (and presumably shift the date back one).
>>> 
>>> 
>>>  Original Message 

Re: [GNC] OFX-DirectConnect to Chase fails on invalid password

[David Reiser via gnucash-user]

Have you read 
https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#Chase_.28Bank_Accounts_and_Credit_Cards.29
 

 , and did you follow the directions for the out-of-band authentication (needed 
only once)?
--
Dave Reiser
dbrei...@icloud.com





> On Jan 6, 2022, at 10:17 PM, tim.cerka.al...@gmail.com wrote:
> 
> When setting up online banking it always fails on invalid password. Has
> anybody out there had the same experience with Chase? 
> 
> P.S. Version 4.9 was just installed and it fails to launch.
> 
> Tim
> -- 
> 
> 
> 5200 E Main St, Lot G2
> Mesa, AZ 85205
> 
> 
> software
>   GNUCash v4.8
> os
>   Linux Host 5.13.19-2-MANJARO #1 SMP PREEMPT
>   Sun Sep 19 21:31:53 UTC 2021 x86_64 GNU/Linux
> host   
>   description: Desktop Computer
>   product: 90MV0001US
>   (LENOVO_MT_90MV_BU_Lenovo_FM_IdeaCentre 3 07ADA05)
>   vendor: LENOVO
>   version: IdeaCentre 3 07ADA05
>   serial: MJ0E2TS2
>   width: 64 bits
> memory
>   description: System Memory
>   slot: System board or motherboard
>   size: 16GiB
> cpu
>   description: CPU
>   product: AMD Athlon Silver 3050U with Radeon Graphics
>   vendor: Advanced Micro Devices [AMD]
>   bus info: cpu@0
>   version: AMD Athlon Silver 3050U with Radeon Graphics
>   slot: FP5
>   size: 2516MHz
>   capacity: 3200MHz
>   width: 64 bits
>   clock: 100MHz
> 
> ___
> 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] OFX Connect

[David Reiser via gnucash-user]

Chase has a different out-of-band verification scheme that Citi does. It’s 
somewhere in the wiki.

I don’t remember anyone reporting success with Discover.
--
Dave Reiser
dbrei...@icloud.com





> On Sep 30, 2021, at 10:49 PM, Gyle McCollam  wrote:
> 
> I have been trying for hours to get this to work.  I have it working for my 
> checking account and a Citi Bank credit card, but I can't get it to work for 
> my Chase or Discover cards!  Sometimes when setting up it asks for my 
> password and sometimes it does not and I don't know why that is.  When I try 
> to retrieve the account list I get this message:
> 
> 22:36:53 Sending request...
> 22:36:53 Using GnuTLS default ciphers.
> 22:36:53 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
> 22:36:53 Waiting for response...
> 22:36:53 Operation finished, you can now close this window.
> 
> There is no "success" message and the account doesn't show up "Online Bank 
> Account" screen.
> 
> I have tried the wiki information page and that is how I got the Citi Bank to 
> work, but no luck with Chase or Discover.  Has anyone set them up 
> successfully?  And why isn't asking for my password during the initial setup?
> 
> 
> Thank You,
> Gyle McCollam
> 
> Gyle McCollam
> 
> 609.680.2326 Mobile
> 
> gmccol...@live.com   email
> ___
> 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] OFX Direct Connect Bank Settings Citi Credit Card

[David Reiser via gnucash-user]

On Sep 6, 2021, at 7:30 AM, Nicholas Rood  wrote:
> 
> If anyone is having a problem with Citi Credit Card direct connect
> lately I have a solution that appears to be working.
> The wiki entry at 
> https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#Citi_Credit_Card
> worked until about a month or so ago.  I figured they changed the OFX
> server url again but what I discovered is that when I set the field
> "HTTP User Agent" to "InetClntApp/3.0", it now downloads my
> transactions into my register as before.   The citi.com -> Profile ->
> Manage Desktop Apps website again lists Quicken Windows as an app
> allowed to use my Citi credentials.  I'm using Gnucash 4.6 on Linux.
> -- Nicholas Rood
> 
> 
Thank you for finding that mod. I would have had a seriously hard time finding 
that. I wonder if Citi even knows they made that change?

Dave
--
Dave Reiser
dbrei...@icloud.com



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

Re: [GNC] Transactions for multiple accounts in 1 ofx file?

[David Reiser via gnucash-user]

There was a change in libofx 10.something that changed the way it interpreted 
cash transactions. I think they overdid it by taking the philosophy that any 
non-interest, non-dividend cash transaction should not be an investment 
transaction. In my case, that means that investment management fees are now 
skipped by the gnucash importer (I think) because libofx presents them 
differently to gnucash than it did before. 
--
Dave Reiser
dbrei...@icloud.com





> On Aug 2, 2021, at 11:56 AM, Kalpesh Patel  wrote:
> 
> There seems to be different potential bug in the ofx import it looks like.
> 
> 
> 
> I have a ofx file from a large brokerage house here in the US which has both 
> the mutual fund transaction and a bank transaction in a single account. It 
> looks like the cash transactions are not being picked up by the importer. For 
> example,  transactions for mutual fund purchase that is picked up is:
> 
> 
> 
> 
> 
>   
> 
>  
> 
> X827884101620210520
> 
>   2021052012
> 
>  YOU BOUGHT   PROSPECTUS 
> 
>  
> 
>  
> 
> 31635T708
> 
>   CUSIP
> 
>  
> 
> +8.09800
> 
>   00014.95000
> 
>  +00.
> 
> +00.
> 
>-000121.0600
> 
>   
> 
>  1.00
> 
> 
> USD
> 
>   
> 
>   CASH
> 
>  CASH
> 
>   
> 
>  BUY
> 
> 
> 
> 
> 
> But it didn’t pick up following transactions from the same account:
> 
> 
> 
> 
> 
>   
> 
>  DEP
> 
> 2021050412
> 
>   +64.1500
> 
>  X827882501120210504
> 
> DIRECT   DEPOSIT ELA
> 
>DIRECT   
> DEPOSIT ELAN CARDSVCRedemption
> 
>   
> 
>  1.00
> 
> 
> USD
> 
>   
> 
>   
> 
>  CASH
> 
> 
> 
> 
> 
> I did a test where I created a brand new file with just (all) basic account 
> types and then imported the file. Sure enough it only registered buy/sell 
> transactions but skipped all the banking transactions in the import windows.  
> It asked to create new (MF) securities and assign accounts appropriately but 
> no cash transactions in any of them. I tried this exercise with version 4.5 
> of gnucash on Windows 10 (my base OS). I can provided anonymized ofx file if 
> there is interest to debug it further.
> 
> 
> 
> I installed 4.6 version but I ran into two issues with it which might be 
> separate from ofx importers:  1) I am seeing silent crash between file à quit 
> and the actual process being removed from the process list. The symptoms I 
> see is that when I relaunch next time it tells me that the lock file is still 
> there on random occasions which shouldn’t be as I went through the proper 
> exit process. And 2) actions à Check & Repairs à Check & Repair All where it 
> simply hangs indefinitely after checking few accounts and need to kill the 
> process from the task manager. The update status bar in the lower right 
> corner goes dim and does not update for minutes on and the cursor on the 
> window shows a busy process. I am not 100% sure what is going on with the 
> execution, hence I have avoided calling them “found” bugs at this time. I 
> reverted to 4.5 of gnucash and see neither of these issues so I have stayed 
> back.
> 
> 
> 
> Kalpesh…
> 
> 
> 
> From: David Carlson  
> Sent: Sunday, August 01, 2021 7:19 AM
> To: Chris Good 
> Cc: Kalpesh Patel ; Gnucash Users 
> 
> Subject: Re: [GNC] Transactions for multiple accounts in 1 ofx file?
> 
> 
> 
> You will also note that bug report is dated in 2003, the concern was raised 
> then with the hint that it was inherent in the OFX specification and 
> therefore probably difficult or impossible to fix.
> 
> 
> 
> The most recent changes to the generic import assistant allows re-ordering 
> the entries into chronological order which will put the duplicate d 
> transactions close to each other on the screen,  making them very easy to 
> spot and manually pick one or the other to keep.
> 
> 
> 
> I 

Re: [GNC] Finance Quote after a MacOS update

[David Reiser via gnucash-user]

Apple is not including the Perl headers location in CPATH these days. I’ve 
never figured out authoritatively how to avoid installing two versions of the 
Command Line Tools, so if you follow the following recipe, you’ll likely have 
one set inside XCode and one in /Library/Developer

xcode-select —install
export 
CPATH=/Library/Developer/CommandLineTools/SDKs/MacOSX11.3.sdk/System/Library/Perl/5.30/darwin-thread-multi-2level/CORE:$CPATH

then run the cpan commands
--
Dave Reiser
dbrei...@icloud.com





> On Apr 30, 2021, at 11:27 AM, Outlook  wrote:
> 
> sudo /applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
> 
> Reported
> 
> Can't locate JSON/Parse.pm in @INC (you may need to install the JSON::Parse 
> module) (@INC contains: /Library/Perl/5.30/darwin-thread-multi-2level 
> /Library/Perl/5.30 /Network/Library/Perl/5.30/darwin-thread-multi-2level 
> /Network/Library/Perl/5.30 
> /Library/Perl/Updates/5.30.2/darwin-thread-multi-2level 
> /Library/Perl/Updates/5.30.2 
> /System/Library/Perl/5.30/darwin-thread-multi-2level 
> /System/Library/Perl/5.30 
> /System/Library/Perl/Extras/5.30/darwin-thread-multi-2level 
> /System/Library/Perl/Extras/5.30) at 
> /Library/Perl/5.30/Finance/Quote/MorningstarAU.pm line 27.
> BEGIN failed--compilation aborted at 
> /Library/Perl/5.30/Finance/Quote/MorningstarAU.pm line 27.
> Compilation failed in require at (eval 293) line 1.
> BEGIN failed--compilation aborted at (eval 293) line 1.
>  at /applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check line 91.
> Can't locate object method "methods" via package 
> "Finance::Quote::MorningstarAU" at /Library/Perl/5.30/Finance/Quote.pm line 
> 120.
> 
> 
> sudo cpan -f -i JSON::Parse
> 
> Reported errors as below
> 
> Parse.xs:1:10: fatal error: 'EXTERN.h' file not found
> #include "EXTERN.h"
>  ^~
> 1 error generated.
> make: *** [Parse.o] Error 1
>   BKB/JSON-Parse-0.61.tar.gz
>   /usr/bin/make -- NOT OK
> 
> Stuck here……
> 
> 
>> David Reiser mailto:dbrei...@icloud.com>> 於 2021年4月28日 
>> 上午5:44 寫道：
>> 
>> Done.
>> --
>> Dave Reiser
>> dbrei...@icloud.com <mailto:dbrei...@icloud.com>
>> 
>> 
>> 
>> 
>> 
>>> On Apr 27, 2021, at 12:50 AM, John Ralls  wrote:
>>> 
>>> Having seen David's earlier post I did
>>> sudo cpan install Test2
>>> sudo /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update
>>> 
>>> which ran successfully, after which 
>>> /applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check reported the 
>>> usual list of sources.
>>> 
>>> Anyone care to open an issue at 
>>> https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Ffinance-quote%2Ffinance-quotedata=04%7C01%7C%7C16fbc1101b0746a59d3808d909c5a3e0%7C84df9e7fe9f640afb435%7C1%7C0%7C637551566725738401%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000sdata=9sDi6cFWDrmCFh%2Faky00FAXUg4R65Y9dnLalElAFzCk%3Dreserved=0
>>>  about them needing to add the dependency on Test2 to the CPAN metadata?
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>> 
>>> 
>>>> On Apr 26, 2021, at 7:34 PM, David Reiser via gnucash-user 
>>>>  wrote:
>>>> 
>>>> You will have to reinstall Date::Manip again too, but I think all the 
>>>> error problems in reinstalling Finance::Quote are taken care of by
>>>> 
>>>> upgrade Test 2
>>>> 
>>>> before
>>>> 
>>>> install Finance::Quote
>>>> 
>>>> inside CPAN (launched with “sudo CPAN”)
>>>> --
>>>> Dave Reiser
>>>> dbrei...@icloud.com
>>>> 
>>>> 
>>>> 
>>>> 
>>>> 
>>>>> On Apr 26, 2021, at 10:30 PM, Outlook  wrote:
>>>>> 
>>>>> Just had the same issue after upgrading to MacOS 11.3. (with GNC V4.4)
>>>>> 
>>>>> Message as below:
>>>>> 
>>>>> Test Summary Report
>>>>> ---
>>>>> t/00-use.t   (Wstat: 512 Tests: 1 Failed: 0)
>>>>> Non-zero exit status: 2
>>>>> Parse errors: Bad plan.  You planned 19 tests but ran 1.
>>>>> t/currency_lookup.t  (Wstat: 512 Tests: 0 Failed: 0)
>>>>> Non-zero exit status: 2
>>>>> Parse errors: Bad plan.  You planned 12 tests but ran 0.
>>>>> t/quote.t(Wstat: 512 Tests: 0 Failed: 0)
>>>&g

Re: [GNC] Finance Quote after a MacOS update

[David Reiser via gnucash-user]

Done.
--
Dave Reiser
dbrei...@icloud.com





> On Apr 27, 2021, at 12:50 AM, John Ralls  wrote:
> 
> Having seen David's earlier post I did
>  sudo cpan install Test2
>  sudo /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update
> 
> which ran successfully, after which 
> /applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check reported the 
> usual list of sources.
> 
> Anyone care to open an issue at 
> https://github.com/finance-quote/finance-quote about them needing to add the 
> dependency on Test2 to the CPAN metadata?
> 
> Regards,
> John Ralls
> 
> 
> 
>> On Apr 26, 2021, at 7:34 PM, David Reiser via gnucash-user 
>>  wrote:
>> 
>> You will have to reinstall Date::Manip again too, but I think all the error 
>> problems in reinstalling Finance::Quote are taken care of by
>> 
>> upgrade Test 2
>> 
>> before
>> 
>> install Finance::Quote
>> 
>> inside CPAN (launched with “sudo CPAN”)
>> --
>> Dave Reiser
>> dbrei...@icloud.com
>> 
>> 
>> 
>> 
>> 
>>> On Apr 26, 2021, at 10:30 PM, Outlook  wrote:
>>> 
>>> Just had the same issue after upgrading to MacOS 11.3. (with GNC V4.4)
>>> 
>>> Message as below:
>>> 
>>> Test Summary Report
>>> ---
>>> t/00-use.t   (Wstat: 512 Tests: 1 Failed: 0)
>>> Non-zero exit status: 2
>>> Parse errors: Bad plan.  You planned 19 tests but ran 1.
>>> t/currency_lookup.t  (Wstat: 512 Tests: 0 Failed: 0)
>>> Non-zero exit status: 2
>>> Parse errors: Bad plan.  You planned 12 tests but ran 0.
>>> t/quote.t(Wstat: 512 Tests: 0 Failed: 0)
>>> Non-zero exit status: 2
>>> Parse errors: Bad plan.  You planned 28 tests but ran 0.
>>> Files=66, Tests=1,  6 wallclock secs ( 0.11 usr  0.08 sys +  5.09 cusr  
>>> 0.98 csys =  6.26 CPU)
>>> Result: FAIL
>>> Failed 3/66 test programs. 0/1 subtests failed.
>>> make: *** [test_dynamic] Error 255
>>> ECOCODE/Finance-Quote-1.49.tar.gz
>>> 2 dependencies missing (DateTime::Format::Strptime,JSON::Parse); 
>>> additionally test harness failed
>>> /usr/bin/make test -- NOT OK
>>> //hint// to see the cpan-testers results for installing this module, try:
>>> reports ECOCODE/Finance-Quote-1.49.tar.gz
>>> 
>>>> David Reiser via gnucash-user >>> <mailto:gnucash-user@gnucash.org>> 於 2021年4月27日 上午9:04 寫道：
>>>> 
>>>> Found it. Had to 
>>>> upgrade Test2
>>>> 
>>>> Perl is so much fun
>>>> 
>>>> Dave
>>>> --
>>>> Dave Reiser
>>>> dbrei...@icloud.com <mailto:dbrei...@icloud.com>
>>>> 
>>>> 
>>>> 
>>>> 
>>>> 
>>>>> On Apr 26, 2021, at 8:45 PM, David Reiser via gnucash-user 
>>>>> mailto:gnucash-user@gnucash.org>> wrote:
>>>>> 
>>>>> Installing MacOS 11.3 seems to have blown away Finance-Quote.
>>>>> My efforts to get it installed via CPAN end with a bunch of errors
>>>>> /usr/bin/make test -- NOT OK
>>>>> 
>>>>> It seems to keep thrashing along until it quits with
>>>>> 
>>>>> ECOCODE/Finance-Quote-1.49.tar.gz: make_test NO one 
>>>>> dependency not OK (DateTime::Format::Strptime); additionally test harness 
>>>>> failed
>>>>> 
>>>>> The DateTime::Format::Strptime installed already is too old (v 1.25), but 
>>>>> it doesn’t upgrade either.
>>>>> 
>>>>> Suggestions?
>>>>> 
>>>>> Dave
>>>>> --
>>>>> Dave Reiser
>>>>> dbrei...@icloud.com <mailto:dbrei...@icloud.com>
>>>>> 
>>>>> 
>>>>> 
>>>>> 
>>>>> 
>>>>> ___
>>>>> gnucash-user mailing list
>>>>> gnucash-user@gnucash.org
>>>>> To update your subscription preferences or to unsubscribe:
>>>>> https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=04%7C01%7C%7C59240e6d7a7b41d1391008d90918971b%7C84df9e7fe9f640afb435%7C1%7C0%7C637550823488996353%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000sdata=37UErf7S

Re: [GNC] Finance Quote after a MacOS update

[David Reiser via gnucash-user]

You will have to reinstall Date::Manip again too, but I think all the error 
problems in reinstalling Finance::Quote are taken care of by

upgrade Test 2

before

install Finance::Quote

inside CPAN (launched with “sudo CPAN”)
--
Dave Reiser
dbrei...@icloud.com





> On Apr 26, 2021, at 10:30 PM, Outlook  wrote:
> 
> Just had the same issue after upgrading to MacOS 11.3. (with GNC V4.4)
> 
> Message as below:
> 
> Test Summary Report
> ---
> t/00-use.t   (Wstat: 512 Tests: 1 Failed: 0)
>   Non-zero exit status: 2
>   Parse errors: Bad plan.  You planned 19 tests but ran 1.
> t/currency_lookup.t  (Wstat: 512 Tests: 0 Failed: 0)
>   Non-zero exit status: 2
>   Parse errors: Bad plan.  You planned 12 tests but ran 0.
> t/quote.t(Wstat: 512 Tests: 0 Failed: 0)
>   Non-zero exit status: 2
>   Parse errors: Bad plan.  You planned 28 tests but ran 0.
> Files=66, Tests=1,  6 wallclock secs ( 0.11 usr  0.08 sys +  5.09 cusr  0.98 
> csys =  6.26 CPU)
> Result: FAIL
> Failed 3/66 test programs. 0/1 subtests failed.
> make: *** [test_dynamic] Error 255
>   ECOCODE/Finance-Quote-1.49.tar.gz
> 2 dependencies missing (DateTime::Format::Strptime,JSON::Parse); additionally 
> test harness failed
>   /usr/bin/make test -- NOT OK
> //hint// to see the cpan-testers results for installing this module, try:
>   reports ECOCODE/Finance-Quote-1.49.tar.gz
> 
>> David Reiser via gnucash-user > <mailto:gnucash-user@gnucash.org>> 於 2021年4月27日 上午9:04 寫道：
>> 
>> Found it. Had to 
>> upgrade Test2
>> 
>> Perl is so much fun
>> 
>> Dave
>> --
>> Dave Reiser
>> dbrei...@icloud.com <mailto:dbrei...@icloud.com>
>> 
>> 
>> 
>> 
>> 
>>> On Apr 26, 2021, at 8:45 PM, David Reiser via gnucash-user 
>>> mailto:gnucash-user@gnucash.org>> wrote:
>>> 
>>> Installing MacOS 11.3 seems to have blown away Finance-Quote.
>>> My efforts to get it installed via CPAN end with a bunch of errors
>>>   /usr/bin/make test -- NOT OK
>>> 
>>> It seems to keep thrashing along until it quits with
>>> 
>>> ECOCODE/Finance-Quote-1.49.tar.gz: make_test NO one dependency 
>>> not OK (DateTime::Format::Strptime); additionally test harness failed
>>> 
>>> The DateTime::Format::Strptime installed already is too old (v 1.25), but 
>>> it doesn’t upgrade either.
>>> 
>>> Suggestions?
>>> 
>>> Dave
>>> --
>>> Dave Reiser
>>> dbrei...@icloud.com <mailto:dbrei...@icloud.com>
>>> 
>>> 
>>> 
>>> 
>>> 
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=04%7C01%7C%7C59240e6d7a7b41d1391008d90918971b%7C84df9e7fe9f640afb435%7C1%7C0%7C637550823488996353%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000sdata=37UErf7ScpWLpL1pVONLr%2FV4YHnSPKkAuq6qDp6MUg4%3Dreserved=0
>>>  
>>> <https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=04%7C01%7C%7C59240e6d7a7b41d1391008d90918971b%7C84df9e7fe9f640afb435%7C1%7C0%7C637550823488996353%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000sdata=37UErf7ScpWLpL1pVONLr%2FV4YHnSPKkAuq6qDp6MUg4%3Dreserved=0>
>>> If you are using Nabble or Gmane, please see 
>>> https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Listsdata=04%7C01%7C%7C59240e6d7a7b41d1391008d90918971b%7C84df9e7fe9f640afb435%7C1%7C0%7C637550823489006308%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000sdata=FPPs%2FC5yq6Q4O4mK9Saf%2FWSOFlcOuOivz60umKepH60%3Dreserved=0
>>>  
>>> <https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Listsdata=04%7C01%7C%7C59240e6d7a7b41d1391008d90918971b%7C84df9e7fe9f640afb435%7C1%7C0%7C637550823489006308%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000sdata=FPPs%2FC5yq6Q4O4mK9Saf%2FWSOFlcOuOivz60umKepH60%3Dreserved=0>
>>>  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 after a MacOS update

[David Reiser via gnucash-user]

Found it. Had to 
upgrade Test2

Perl is so much fun

Dave
--
Dave Reiser
dbrei...@icloud.com





> On Apr 26, 2021, at 8:45 PM, David Reiser via gnucash-user 
>  wrote:
> 
> Installing MacOS 11.3 seems to have blown away Finance-Quote.
> My efforts to get it installed via CPAN end with a bunch of errors
>/usr/bin/make test -- NOT OK
> 
> It seems to keep thrashing along until it quits with
> 
> ECOCODE/Finance-Quote-1.49.tar.gz: make_test NO one dependency 
> not OK (DateTime::Format::Strptime); additionally test harness failed
> 
> The DateTime::Format::Strptime installed already is too old (v 1.25), but it 
> doesn’t upgrade either.
> 
> Suggestions?
> 
> Dave
> --
> Dave Reiser
> dbrei...@icloud.com
> 
> 
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

[GNC] Finance Quote after a MacOS update

[David Reiser via gnucash-user]

Installing MacOS 11.3 seems to have blown away Finance-Quote.
My efforts to get it installed via CPAN end with a bunch of errors
/usr/bin/make test -- NOT OK

It seems to keep thrashing along until it quits with

ECOCODE/Finance-Quote-1.49.tar.gz: make_test NO one dependency not 
OK (DateTime::Format::Strptime); additionally test harness failed

The DateTime::Format::Strptime installed already is too old (v 1.25), but it 
doesn’t upgrade either.

Suggestions?

Dave
--
Dave Reiser
dbrei...@icloud.com





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

Re: [GNC] TD Ameritrade OFX Direct

[David Reiser via gnucash-user]

As of late last year, Martin was going to see if he could make the 
stocks/mutual funds ofx transaction work well in aqbanking. I don’t know how 
far he got, since he doesn’t have any of his own accounts to test that 
functionality with. 

You might not be doing anything wrong. And fixing it might not do you any good.

I use ofx.py to download TDAmeritrade transactions. Then File>Import in Gnucash 
works, since the import function goes through libofx to parse the transactions. 
Libofx has handled stock/mutual fund transactions pretty well for me.
--
Dave Reiser
dbrei...@icloud.com





> On Feb 15, 2021, at 11:20 AM, Keith Bellairs  wrote:
> 
> Quicken is able to download brokerage account transactions from Ameritrade.
> 
> I can configure Online Banking in GNC with my user info, retrieve accounts,
> and link the accounts to my GNC accounts. But when I try to Get
> Transactions the ameritrade server accepts my connection and returns a HTTP
> status 400. No transactions. But Quicken sees and downloads them.
> 
> Does anyone use online banking with Ameritrade? If so, what am I doing
> wrong?
> 
> Keith
> 
> Here's the GNC Online Banking connection Window:
> 
> AqBanking v6.2.5.0stable
> Sending jobs to the bank(s)
> Sorting commands by account
> Sorting commands by account
> Sorting commands by provider
> Send commands to providers
> Send commands to provider "aqofxconnect"
> Locking customer "13"
> Sending request...
> Connecting to server...
> Resolving hostname "ofxs.ameritrade.com" ...
> IP address is "198.200.171.142"
> Connecting to "ofxs.ameritrade.com"
> Connected to "ofxs.ameritrade.com"
> Using GnuTLS default ciphers.
> TLS: SSL-Ciphers negotiated: TLS1.2:RSA-AES-256-GCM:AEAD
> Connected.
> Sending message...
> Message sent.
> Waiting for response...
> Receiving response...
> HTTP-Status: 400 (400)
> Unlocking customer "13"
> ___
> 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] 4.4 slow

[David Reiser via gnucash-user]

My memory is a bit fuzzy, but version 4 made some significant changes to (I 
think) a number of key-value structures in the database. The first time you 
open version 4, it has to convert all the old values (if you have done lots of 
transaction importing, that’s a big contributor). If you quit gnucash before 
it’s done with the conversion, it  has to start over the next time. I think it 
took something like 45 minutes before my Mac was done updating everything 
internally in the database. 

After that it has been fine.
--
Dave Reiser
dbrei...@icloud.com





> On Feb 5, 2021, at 11:01 AM, R. Victor Klassen  wrote:
> 
> So I finally decided to upgrade from 2.6.21, and downloaded 4.4 for Mac. I 
> had read something about faster startup times.  
> 
> Well I am unconvinced about that part.  But worse still, it regularly has 
> long delays when entering lines in an invoice or posting it. 
> 
> I think I would have heard lots of complaints by now if this were common.  
> Wondering what might be up with this. 
> 
> Mac OS 10.13.6. 
> Gnucash version 4.4+ (2020-12-28)
> 
> Sent from my iPhone
> ___
> 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] USAA FSB requires newer QWIN support

[David Reiser via gnucash-user]

There’s a note on Quicken’s pages that some USAA customers need to get a new ID 
and PIN for transaction downloads (different from the rest of the USAA web page 
credentials). I didn’t see any definitive info on who or why.

The next step would be to look at the ofx log file — something you have to turn 
on in Gnucash via environment variables. Directions are somewhere on the wiki.

The ofx log will tell you if your login was declined. Sometimes, you even get 
an ofx error as partial indication of why.
--
Dave Reiser
dbrei...@icloud.com





> On Jan 29, 2021, at 9:16 PM, Jon Schewe  wrote:
> 
> Some additional data points. I was using appVer 2200 and got no
> transactions. I edited the aqbanking config file and changed the appVer
> to 2700, still no transactions. I changed the headerVer to 103, still
> no transactions. I tried adding a clientUid and that didn't help
> either.
> 
> However I do not see any errors in the log window.
> 
> According to the log I'm using AqBanking v6.2.1.0stable.
> 
> 
> On Thu, 2021-01-28 at 10:40 -0500, David Reiser via gnucash-user wrote:
>> The first thing to try is setting the appVer to 2700 (nine years
>> newer than 1800). 
>> 
>> If that doesn’t work on its own, try setting headerVer  to 103 and
>> creating a clientUid
>> --
>> Dave Reiser
>> dbrei...@icloud.com
>> 
>> 
>> 
>> 
>> 
>> 
>>> On Jan 28, 2021, at 10:30 AM, Bob White via gnucash-user <
>>> gnucash-user@gnucash.org
>>>> wrote:
>>> 
>>> As of 27 Jan 2021 USAA has deprecated aqbanking QWIN v1800
>>> support.  Can connect, but transactions are no longer downloaded.
>>> 
>>> I confirmed with USAA.  I am trying to get details on newer
>>> requirements from USAA but it is difficult--they will only
>>> troubleshoot with the actual Quicken app, which I do not have.
>>> 
>>> Waiting on a callback from USAA.
>>> 
>>> Has anyone else experienced these issues or know of a resolution?
>>> 
>>> Thanks,
>>> 
>>> Bob
>>> 
>>> 
>>> ___
>>> 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] USAA FSB requires newer QWIN support

[David Reiser via gnucash-user]

You can if you want to edit the aqbanking settings files (text). But it’s 
easier to edit user information in the wizard. Just enter the new/changed info 
using “edit user” 
--
Dave Reiser
dbrei...@icloud.com





> On Jan 28, 2021, at 11:43 AM, Jon Schewe  wrote:
> 
> I see that I have this issue as well.
> 
> Is it possible to change the setup without running the online banking
> wizard?
> 
> The last time I set this up I updated the wiki at 
> https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA and
> noted the the client ID should be empty.
> 
> 
> On Thu, 2021-01-28 at 10:40 -0500, David Reiser via gnucash-user wrote:
>> The first thing to try is setting the appVer to 2700 (nine years
>> newer than 1800). 
>> 
>> If that doesn’t work on its own, try setting headerVer  to 103 and
>> creating a clientUid
>> --
>> Dave Reiser
>> dbrei...@icloud.com
>> 
>> 
>> 
>> 
>> 
>> 
>>> On Jan 28, 2021, at 10:30 AM, Bob White via gnucash-user <
>>> gnucash-user@gnucash.org
>>>> wrote:
>>> 
>>> As of 27 Jan 2021 USAA has deprecated aqbanking QWIN v1800
>>> support.  Can connect, but transactions are no longer downloaded.
>>> 
>>> I confirmed with USAA.  I am trying to get details on newer
>>> requirements from USAA but it is difficult--they will only
>>> troubleshoot with the actual Quicken app, which I do not have.
>>> 
>>> Waiting on a callback from USAA.
>>> 
>>> Has anyone else experienced these issues or know of a resolution?
>>> 
>>> Thanks,
>>> 
>>> Bob
>>> 
>>> 
>>> ___
>>> 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] USAA FSB requires newer QWIN support

[David Reiser via gnucash-user]

unix systems will generate a clientUid with the terminal command: uuidgen
I make it all lower case and remove the hyphens by using the command in the 
form "uuidgen | awk '{print tolower($0)}' | tr -d -"
I don’t know how important case or hyphens/lack of hyphens is.

There’s a box in the aqbanking setup to enter a clientUid.
--
Dave Reiser
dbrei...@icloud.com





> On Jan 28, 2021, at 11:15 AM, Bob White  wrote:
> 
> Thanks, Dave. 
> 
> Updating to 2700 alone did not work.  
> 
> Do I need to go through actual Quicken software to generate the clientUid?
> 
> Regards,
> 
> Bob
> 
> Sent from my iPhone
> 
>> On Jan 28, 2021, at 10:41 AM, David Reiser  wrote:
>> 
>> The first thing to try is setting the appVer to 2700 (nine years newer than 
>> 1800). 
>> 
>> If that doesn’t work on its own, try setting headerVer  to 103 and creating 
>> a clientUid
>> --
>> Dave Reiser
>> dbrei...@icloud.com
>> 
>> 
>> 
>> 
>> 
>>> On Jan 28, 2021, at 10:30 AM, Bob White via gnucash-user 
>>>  wrote:
>>> 
>>> As of 27 Jan 2021 USAA has deprecated aqbanking QWIN v1800 support.  Can 
>>> connect, but transactions are no longer downloaded.
>>> 
>>> I confirmed with USAA.  I am trying to get details on newer requirements 
>>> from USAA but it is difficult--they will only troubleshoot with the actual 
>>> Quicken app, which I do not have.
>>> 
>>> Waiting on a callback from USAA.
>>> 
>>> Has anyone else experienced these issues or know of a resolution?
>>> 
>>> Thanks,
>>> 
>>> Bob
>>> 
>>> 
>>> ___
>>> 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] USAA FSB requires newer QWIN support

[David Reiser via gnucash-user]

The first thing to try is setting the appVer to 2700 (nine years newer than 
1800). 

If that doesn’t work on its own, try setting headerVer  to 103 and creating a 
clientUid
--
Dave Reiser
dbrei...@icloud.com





> On Jan 28, 2021, at 10:30 AM, Bob White via gnucash-user 
>  wrote:
> 
> As of 27 Jan 2021 USAA has deprecated aqbanking QWIN v1800 support.  Can 
> connect, but transactions are no longer downloaded.
> 
> I confirmed with USAA.  I am trying to get details on newer requirements from 
> USAA but it is difficult--they will only troubleshoot with the actual Quicken 
> app, which I do not have.
> 
> Waiting on a callback from USAA.
> 
> Has anyone else experienced these issues or know of a resolution?
> 
> Thanks,
> 
> Bob
> 
> 
> ___
> 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

[David Reiser via gnucash-user]

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

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

Re: [GNC] gnucash-user Digest, Vol 214, Issue 23

[David Reiser via gnucash-user]

I believe that the Online ID section deals only with assigning a Gnucash 
account to the account designation presented by the file being imported. It’s 
more of a one-time assignment vs. ‘matching’ .

The Bayesian and Non-Bayesian sections deal with matching incoming transactions 
to the secondary account in gnucash (the primary gnucash account is already 
determined by the online ID). So if you’re being directed to the filter 
operation, that’s just external transaction to gnucash second split account 
information. So you should be able to search as directed to find the accounts 
associated with the Not Found messages.
--
Dave Reiser
dbrei...@icloud.com





> On Jan 11, 2021, at 5:50 PM, Kalpesh Patel  wrote:
> 
> This is what I was looking for. It worked, thanks to both David's responses
> on providing the procedure. It is actually good that I get an opportunity to
> map to the proper account when I am importing it in next time as opposed to
> figuring it out manually. 
> 
> Another side question on this ... when I was in that dialogue box it
> mentioned that there were few invalid mapping and to see them I had to use a
> filter of 'Map Account NOT found'. I didn't see any button to filter when I
> clicked 'Online' radio button. Is that correct function? I do see an input
> field at the bottom when Bayesian is selected.
> 
> --
> 
> Message: 1
> Date: Sat, 9 Jan 2021 17:13:32 -0500
> From: David Reiser 
> To: Kalpesh Patel 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] OFX matched account and unmatching it manually
> Message-ID: <6f2e5d35-4b8c-49be-b490-87a372839...@icloud.com>
> Content-Type: text/plain; charset=utf-8
> 
> Tools>Import Map Editor
> select the Online radio button
> then select and delete the incorrect connection
> 
> You don?t get to edit it. Next time you import an ofx file for that account,
> the dialog you showed will reappear. Pick the correct account.
> --
> Dave Reiser
> dbrei...@icloud.com
> 
> 
> 
> 
> 
>> On Jan 9, 2021, at 5:08 PM, Kalpesh Patel  wrote:
>> 
>> Hi all,
>> 
>> 
>> 
>> I normally download OFX files and then import those downloaded 
>> transactions into GnuCash. When a new account is encountered in the 
>> import process, a dialog box shows up (see attached pic) that allows 
>> you to set the 'Account Name' in GnuCash that is mapped to and 
>> 'Account ID' that is downloaded in the ofx file. I somehow cannot 
>> figure out how-to bring that dialog box up after the fact, and then 
>> make corrections to it, specifically to unmap existing one and then remap
> it to another 'Account ID', if necessary?
>> 
>> 
>> 
>> Any help is appreciated. 
>> 
>> 
>> 
>> Have a happy, healthy, safe and prosperous new year.
>> 
>> 
>> 
>> Kalpesh.
>> 
>> 
>> 
>> 
>> 
>> ___
>> 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.
> 
> 
> 
> --
> 
> Message: 2
> Date: Sat, 9 Jan 2021 16:21:08 -0600 (CST)
> From: David Cousens 
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] OFX matched account and unmatching it manually
> Message-ID: <1610230868218-0.p...@n4.nabble.com>
> Content-Type: text/plain; charset=us-ascii
> 
> Kalpesh
> Tools->Import Map Editor   will bring up a dialog. If you select the
> Non-Bayesian you can delete but not add or edit entries for CSV import. The
> online radio button allows you to similarly edit the onlineId entries which
> AFAIK are what are used to match external accounts to the GnuCash internal
> accounts for OFX importing . I do not import online at all and these have
> been set for the imports I do from OFX files downloaded from my bank. Again
> you can delete but not add or edit the entries and reset them in the next
> import.
> 
> David
> 
> 
> 
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> 
> 
> --
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https:/

Re: [GNC] OFX matched account and unmatching it manually

[David Reiser via gnucash-user]

Tools>Import Map Editor
select the Online radio button
then select and delete the incorrect connection

You don’t get to edit it. Next time you import an ofx file for that account, 
the dialog you showed will reappear. Pick the correct account.
--
Dave Reiser
dbrei...@icloud.com





> On Jan 9, 2021, at 5:08 PM, Kalpesh Patel  wrote:
> 
> Hi all,
> 
> 
> 
> I normally download OFX files and then import those downloaded transactions
> into GnuCash. When a new account is encountered in the import process, a
> dialog box shows up (see attached pic) that allows you to set the 'Account
> Name' in GnuCash that is mapped to and 'Account ID' that is downloaded in
> the ofx file. I somehow cannot figure out how-to bring that dialog box up
> after the fact, and then make corrections to it, specifically to unmap
> existing one and then remap it to another 'Account ID', if necessary?
> 
> 
> 
> Any help is appreciated. 
> 
> 
> 
> Have a happy, healthy, safe and prosperous new year.
> 
> 
> 
> Kalpesh.
> 
> 
> 
> 
> 
> ___
> 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] How is Total(period) in Account Tree intended to work for brokerage accounts?

[David Reiser via gnucash-user]

I finally understand that a transaction must occur during the period to be 
included.

However, the unrealized gain is included for stock transactions based in the 
current period. The Account Tree is not a report, so it’s unclear how one might 
change the evaluation. But my Total(period) for the account with stock 
transactions this year absolutely is showing today’s value of any stock 
transaction occurring during the period. (Where “today’s value” means the value 
of the stock account as determined by the latest entry in the price database 
for that stock.)

My Total(period) for the brokerage account containing (only) stock transactions 
from this year is showing me the current, appreciated value of those 
transactions based on entries in the price database that have been added since 
the purchase transactions.
--
Dave Reiser
dbrei...@icloud.com





> On Jan 8, 2021, at 5:10 PM, D.  wrote:
> 
> The Total(Period) column includes the value of actual transactions during the 
> period. Changes in valuation aren't counted in this value because they are 
> unrealized. You are seeing a number in the one account precisely because you 
> rolled the money over from one account to another. That was an actual 
> transaction.
> 
> 
>  Original Message 
> From: David Carlson 
> Sent: Fri Jan 08 14:52:22 EST 2021
> To: David Reiser 
> Cc: Gnucash Users 
> Subject: Re: [GNC] How is Total(period) in Account Tree intended to work for 
> brokerage accounts?
> 
> Parenthetically, this year, having business holidays around calendar
> year-end, you need to make sure that you understand how Gnucash picks
> values out of the price database when designing your reports.
> 
> On Fri, Jan 8, 2021 at 12:55 PM David Reiser via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
>> I have a number of brokerage-like accounts (cursed with multiple TIAA
>> contracts…). In most cases, the Total(period) column in the account tree
>> page lists $0.00 as that total.
>> 
>> I did a roth conversion at the end of 2020 that resulted in the money for
>> the conversion being moved to the new account in 2020, but the reinvestment
>> transactions took place in 2021. For that account, the total(period) lists
>> the dollar-value change of that account, including the increase in mutual
>> fund value since the investment transactions took place. It would really be
>> nice if all the brokerage account accounts showed the total value change in
>> the current accounting period. What’s different about the new account
>> (seems to be set up identically to all the other brokerage parent
>> accounts)? Should I be able to get the other brokerage accounts to exhibit
>> the same totalling behavior?
>> 
>> --
>> Dave Reiser
>> dbrei...@icloud.com
>> 
>> 
>> 
>> 
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> 
> 
> --
> David Carlson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 

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

Re: [GNC] How is Total(period) in Account Tree intended to work for brokerage accounts?

[David Reiser via gnucash-user]

The brokerage parent is in dollars. The individual fund accounts under it are 
in shares. But it’s the same setup for both the account that shows a ‘real’ 
total and those that show 0.00.
--
Dave Reiser
dbrei...@icloud.com





> On Jan 8, 2021, at 2:55 PM, David Carlson  wrote:
> 
> For each account, is ti's value in US Dollars or is it in shares that have 
> some US Dollar value per share??
> 
> On Fri, Jan 8, 2021 at 1:51 PM David Reiser  <mailto:dbrei...@icloud.com>> wrote:
> All security values are updated on a roughly daily basis. And since all of my 
> investments and other accounts are linked to USD, I still don’t see any 
> difference between the account that reports a ‘real’ total vs. the accounts 
> that report 0.00.
> --
> Dave Reiser
> dbrei...@icloud.com <mailto:dbrei...@icloud.com>
> 
> 
> 
> 
> 
>> On Jan 8, 2021, at 2:47 PM, David Carlson > <mailto:david.carlson@gmail.com>> wrote:
>> 
>> David,
>> 
>> The total value of brokerage accounts is usually zero because that number 
>> only represents the cash in the account.  The securities are valued 
>> separately, usually in their share amounts.  You would need to separately 
>> make sure that GnuCash has been updated with the value of each of those 
>> shares in your preferred currency in order to create a report with the net 
>> value of all the securities in each brokerage account
>> 
>> On Fri, Jan 8, 2021 at 12:55 PM David Reiser via gnucash-user 
>> mailto:gnucash-user@gnucash.org>> wrote:
>> I have a number of brokerage-like accounts (cursed with multiple TIAA 
>> contracts…). In most cases, the Total(period) column in the account tree 
>> page lists $0.00 as that total.
>> 
>> I did a roth conversion at the end of 2020 that resulted in the money for 
>> the conversion being moved to the new account in 2020, but the reinvestment 
>> transactions took place in 2021. For that account, the total(period) lists 
>> the dollar-value change of that account, including the increase in mutual 
>> fund value since the investment transactions took place. It would really be 
>> nice if all the brokerage account accounts showed the total value change in 
>> the current accounting period. What’s different about the new account (seems 
>> to be set up identically to all the other brokerage parent accounts)? Should 
>> I be able to get the other brokerage accounts to exhibit the same totalling 
>> behavior?
>> 
>> --
>> Dave Reiser
>> dbrei...@icloud.com <mailto:dbrei...@icloud.com>
>> 
>> 
>> 
>> 
>> 
>> ___
>> 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.
>> 
>> 
>> -- 
>> David Carlson
> 
> 
> 
> -- 
> David Carlson

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

Re: [GNC] How is Total(period) in Account Tree intended to work for brokerage accounts?

[David Reiser via gnucash-user]

All security values are updated on a roughly daily basis. And since all of my 
investments and other accounts are linked to USD, I still don’t see any 
difference between the account that reports a ‘real’ total vs. the accounts 
that report 0.00.
--
Dave Reiser
dbrei...@icloud.com





> On Jan 8, 2021, at 2:47 PM, David Carlson  wrote:
> 
> David,
> 
> The total value of brokerage accounts is usually zero because that number 
> only represents the cash in the account.  The securities are valued 
> separately, usually in their share amounts.  You would need to separately 
> make sure that GnuCash has been updated with the value of each of those 
> shares in your preferred currency in order to create a report with the net 
> value of all the securities in each brokerage account
> 
> On Fri, Jan 8, 2021 at 12:55 PM David Reiser via gnucash-user 
> mailto:gnucash-user@gnucash.org>> wrote:
> I have a number of brokerage-like accounts (cursed with multiple TIAA 
> contracts…). In most cases, the Total(period) column in the account tree page 
> lists $0.00 as that total.
> 
> I did a roth conversion at the end of 2020 that resulted in the money for the 
> conversion being moved to the new account in 2020, but the reinvestment 
> transactions took place in 2021. For that account, the total(period) lists 
> the dollar-value change of that account, including the increase in mutual 
> fund value since the investment transactions took place. It would really be 
> nice if all the brokerage account accounts showed the total value change in 
> the current accounting period. What’s different about the new account (seems 
> to be set up identically to all the other brokerage parent accounts)? Should 
> I be able to get the other brokerage accounts to exhibit the same totalling 
> behavior?
> 
> --
> Dave Reiser
> dbrei...@icloud.com <mailto:dbrei...@icloud.com>
> 
> 
> 
> 
> 
> ___
> 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.
> 
> 
> -- 
> David Carlson

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

[GNC] How is Total(period) in Account Tree intended to work for brokerage accounts?

[David Reiser via gnucash-user]

I have a number of brokerage-like accounts (cursed with multiple TIAA 
contracts…). In most cases, the Total(period) column in the account tree page 
lists $0.00 as that total.

I did a roth conversion at the end of 2020 that resulted in the money for the 
conversion being moved to the new account in 2020, but the reinvestment 
transactions took place in 2021. For that account, the total(period) lists the 
dollar-value change of that account, including the increase in mutual fund 
value since the investment transactions took place. It would really be nice if 
all the brokerage account accounts showed the total value change in the current 
accounting period. What’s different about the new account (seems to be set up 
identically to all the other brokerage parent accounts)? Should I be able to 
get the other brokerage accounts to exhibit the same totalling behavior?

--
Dave Reiser
dbrei...@icloud.com





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

Re: [GNC] ofx.chase.com?

[David Reiser via gnucash-user]

Chase ofx server is back to working for me.

--
Dave Reiser
dbrei...@icloud.com





> On Dec 14, 2020, at 1:30 PM, David Reiser  wrote:
> 
> Message has changed:
> HTTP-Status: 502 (Bad Gateway)
> 
> I’m wondering if they’ve pulled another year-end stunt of security changes 
> without adequate documentation. If they’ve gone all-in on Quicken’s Express 
> Web Connect, then we’re probably screwed. EWC is totally proprietary to 
> Quicken, so we’ll never connect that way. If a qfx/ofx server is viewed as a 
> security risk, then we’re even deeper in the “no service for you” category.
> 
> Dave
> --
> Dave Reiser
> dbrei...@icloud.com
> 
> 
> 
> 
> 
>> On Dec 14, 2020, at 9:27 AM, David Reiser via gnucash-user 
>>  wrote:
>> 
>>>> HTTP-Status: 504 (Gateway Time-out)
>> 
>> means that chase isn’t sending any data. No data, no transactions for 
>> Gnucash to detect.
>> 
>> It has only been since yesterday. The system worked on Saturday, did not 
>> work Sunday or today yet. But they’re a bank, and ofx/qfx is probably pretty 
>> low on their emergency priority list. So today is likely the first day any 
>> employee will see the block and start working on it.
>> --
>> Dave Reiser
>> dbrei...@icloud.com
>> 
>> 
>> 
>> 
>> 
>>> On Dec 14, 2020, at 8:03 AM, Charles Gagnon  wrote:
>>> 
>>> Anyone else struggling with OFX at Chase. I've been using it for years
>>> without issues. Used it successfully last month. Since yesterday, on all
>>> accounts, I'm told there were no transactions to download. I tried using
>>> fixed date instead of "since last transfer" and no difference:
>>> 
>>> [image: image.png]
>>> 
>>> I do not think this is a Gnucash issue per say. Unless it's a OFX version
>>> thing. I googled around but can't find any indications of others having
>>> problems so I'm confused. Any ideas or pointers? What's a good next step?
>>> Is there an OFX mailing list or do I just reach out to Chase? Could this be
>>> just my setup broken?
>>> 
>>> It connects and seems to establish a session with Chase but gets nothing.
>>> Log below...
>>> 
>>> AqBanking v6.2.2.0stable
>>> Sending jobs to the bank(s)
>>> Sorting commands by account
>>> Sorting commands by account
>>> Sorting commands by provider
>>> Send commands to providers
>>> Send commands to provider "aqofxconnect"
>>> Locking customer "24"
>>> Sending request...
>>> Connecting to server...
>>> Resolving hostname "ofx.chase.com" ...
>>> IP address is "159.53.44.44"
>>> Connecting to "ofx.chase.com"
>>> Connected to "ofx.chase.com"
>>> Using GnuTLS default ciphers.
>>> TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-128-GCM:AEAD
>>> Connected.
>>> Sending message...
>>> Message sent.
>>> Waiting for response...
>>> Receiving response...
>>> HTTP-Status: 504 (Gateway Time-out)
>>> Unlocking customer "24"
>>> 
>>> --
>>> Charles Gagnon
>>> charlesg at unixrealm.com
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see 
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 

___
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] ofx.chase.com?

[David Reiser via gnucash-user]

Message has changed:
HTTP-Status: 502 (Bad Gateway)

I’m wondering if they’ve pulled another year-end stunt of security changes 
without adequate documentation. If they’ve gone all-in on Quicken’s Express Web 
Connect, then we’re probably screwed. EWC is totally proprietary to Quicken, so 
we’ll never connect that way. If a qfx/ofx server is viewed as a security risk, 
then we’re even deeper in the “no service for you” category.

Dave
--
Dave Reiser
dbrei...@icloud.com





> On Dec 14, 2020, at 9:27 AM, David Reiser via gnucash-user 
>  wrote:
> 
>>> HTTP-Status: 504 (Gateway Time-out)
> 
> means that chase isn’t sending any data. No data, no transactions for Gnucash 
> to detect.
> 
> It has only been since yesterday. The system worked on Saturday, did not work 
> Sunday or today yet. But they’re a bank, and ofx/qfx is probably pretty low 
> on their emergency priority list. So today is likely the first day any 
> employee will see the block and start working on it.
> --
> Dave Reiser
> dbrei...@icloud.com
> 
> 
> 
> 
> 
>> On Dec 14, 2020, at 8:03 AM, Charles Gagnon  wrote:
>> 
>> Anyone else struggling with OFX at Chase. I've been using it for years
>> without issues. Used it successfully last month. Since yesterday, on all
>> accounts, I'm told there were no transactions to download. I tried using
>> fixed date instead of "since last transfer" and no difference:
>> 
>> [image: image.png]
>> 
>> I do not think this is a Gnucash issue per say. Unless it's a OFX version
>> thing. I googled around but can't find any indications of others having
>> problems so I'm confused. Any ideas or pointers? What's a good next step?
>> Is there an OFX mailing list or do I just reach out to Chase? Could this be
>> just my setup broken?
>> 
>> It connects and seems to establish a session with Chase but gets nothing.
>> Log below...
>> 
>> AqBanking v6.2.2.0stable
>> Sending jobs to the bank(s)
>> Sorting commands by account
>> Sorting commands by account
>> Sorting commands by provider
>> Send commands to providers
>> Send commands to provider "aqofxconnect"
>> Locking customer "24"
>> Sending request...
>> Connecting to server...
>> Resolving hostname "ofx.chase.com" ...
>> IP address is "159.53.44.44"
>> Connecting to "ofx.chase.com"
>> Connected to "ofx.chase.com"
>> Using GnuTLS default ciphers.
>> TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-128-GCM:AEAD
>> Connected.
>> Sending message...
>> Message sent.
>> Waiting for response...
>> Receiving response...
>> HTTP-Status: 504 (Gateway Time-out)
>> Unlocking customer "24"
>> 
>> --
>> Charles Gagnon
>> charlesg at unixrealm.com
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
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] ofx.chase.com?

[David Reiser via gnucash-user]

>> HTTP-Status: 504 (Gateway Time-out)

means that chase isn’t sending any data. No data, no transactions for Gnucash 
to detect.

It has only been since yesterday. The system worked on Saturday, did not work 
Sunday or today yet. But they’re a bank, and ofx/qfx is probably pretty low on 
their emergency priority list. So today is likely the first day any employee 
will see the block and start working on it.
--
Dave Reiser
dbrei...@icloud.com





> On Dec 14, 2020, at 8:03 AM, Charles Gagnon  wrote:
> 
> Anyone else struggling with OFX at Chase. I've been using it for years
> without issues. Used it successfully last month. Since yesterday, on all
> accounts, I'm told there were no transactions to download. I tried using
> fixed date instead of "since last transfer" and no difference:
> 
> [image: image.png]
> 
> I do not think this is a Gnucash issue per say. Unless it's a OFX version
> thing. I googled around but can't find any indications of others having
> problems so I'm confused. Any ideas or pointers? What's a good next step?
> Is there an OFX mailing list or do I just reach out to Chase? Could this be
> just my setup broken?
> 
> It connects and seems to establish a session with Chase but gets nothing.
> Log below...
> 
> AqBanking v6.2.2.0stable
> Sending jobs to the bank(s)
> Sorting commands by account
> Sorting commands by account
> Sorting commands by provider
> Send commands to providers
> Send commands to provider "aqofxconnect"
> Locking customer "24"
> Sending request...
> Connecting to server...
> Resolving hostname "ofx.chase.com" ...
> IP address is "159.53.44.44"
> Connecting to "ofx.chase.com"
> Connected to "ofx.chase.com"
> Using GnuTLS default ciphers.
> TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-128-GCM:AEAD
> Connected.
> Sending message...
> Message sent.
> Waiting for response...
> Receiving response...
> HTTP-Status: 504 (Gateway Time-out)
> Unlocking customer "24"
> 
> --
> Charles Gagnon
> charlesg at unixrealm.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Mac OS update

[David Reiser via gnucash-user]

Apple did change the perl version from 5.18.4 to 5.28.2, so just the normal 
version path info changed. And I think Apple has been moving things around to 
further lock down system locations, so that may have impacted standard perl 
attempts to find previously installed perl modules.
--
Dave Reiser
dbrei...@icloud.com





> On Nov 28, 2020, at 10:42 AM, Keith Bellairs  wrote:
> 
> I noticed that when I updated to Mac OS 11.0.1 I lost Finance Quote and had
> to find the wiki page to do a fresh install of FQ.
> 
> https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Perl_on_Unix
> 
> Is that normal or did I mess up the upgrade?
> 
> Keith
> ___
> 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] AQbanking ofx.log

[David Reiser via gnucash-user]

If the transfer occurs, you will see the receive data stream in the log file. 
The 400 error suggests the site on the other end is not responding (or locking 
you out). Make sure the bank hasn’t changed it’s ofx access address, or shut it 
off.
--
Dave Reiser
dbrei...@icloud.com





> On Nov 14, 2020, at 3:22 PM, Shyam Acharya  wrote:
> 
> Frank/John - 
> 
> Thanks for the assist. I was able to generate a logfile by setting 
> environmental variable AQOFX_LOG_COMM and AQOFXCONNECT_LOGLEVEL. However, 
> when I look at the log, I see what was sent. But don’t see the bank's 
> response. Perhaps my expectation that the response is captured is incorrect. 
> Should I be able to see the response?
> 
> I am trying to resolve a HTTP-Status 400 (Bad Request) error.
> 
> Thanks
> Shyam
> 
> 
> 
> 
> On 11/14/20, 6:45 AM, "Frank H. Ellenberger"  
> wrote:
> 
>Hi,
> 
>Am 14.11.20 um 04:43 schrieb John Ralls:
>> 
>> 
>>> On Nov 13, 2020, at 4:28 PM, Shyam Acharya  wrote:
>>> 
>>> Hi –
>>> 
>>> I am a new user and trying to debug an online banking setup. How (and 
>>> where) can I can turn on enhanced logging  “AQOFX_LOG_COMM=1” so I can 
>>> decipher the problem?
>>> 
>>> I use a PC WIN10 GNUCASH ver 4.2. I do have access to a Mac as well.
>> 
>> It's an environment variable: 
>> https://docs.microsoft.com/en-us/windows/win32/procthread/environment-variables
>> 
>> Regards,
>> John Ralls
> 
>I believe, https://wiki.gnucash.org/wiki/AqBanking#Debugging and related
>pages like
>
> https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect#Enabling_the_OFX_Log
>do not really reflect the current state of AqBanking 6.
> 
>https://lists.gnucash.org/pipermail/gnucash-user/2020-March/090164.html
>should describe the current state starting with Martins comment from Mar
>30 with "AQOFX_LOG_COMM=PATH_TO_LOGFILE"
> 
>As I can not verify the OFX stuff, it would be nice, if somebody who
>can, would update the wiki sections.
> 
>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] creating gnucash custom check printing files on Mac

[David Reiser via gnucash-user]

> On Nov 6, 2020, at 4:57 PM, Bart Schroeder  wrote:
> 
> Using Gnucash 4.2 on Mac OS 10.15.  None of pre-defined check printing 
> formats work for my purpose.  So, how to duplicate, then modify one of these 
> print formats.  I am unable to locate any check files (using Mac interface) 
> to use as sample files.   In terminal, none show in Application directory as 
> suggested in documentation.  Can someone please ID steps to create new check 
> format files and where they should be located.
> 
> Thank you in advance,
> 
> Bart

The check files are in the application bundle. So in the Finder, you’d have to 
right click on the GnuCash app, select Show Package Contents, and then go to:

/Applications/Gnucash.app/Contents/Resources/share/gnucash/checks/

to get to the check files. The first 3 elements of the above path are just for 
reference because Show Package Contents opens a Finder window with the Contents 
folder showing.

Take your pick of the check file(s) and store copies (after renaming!) in:

/Users/[your user name]/Library/Application Support/Gnucash/checks/

You can edit the files and save them back to the app bundle, but then any 
version upgrade will blow away your changed versions (even if you’ve renamed 
them in the app bundle).

Versions saved in Application Support survive across anything that maintains 
the user Library.


--
Dave Reiser
dbrei...@icloud.com






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

Re: [GNC] Fidelity and TD Ameritrade setup

[David Reiser via gnucash-user]

I don’t download a file. I turn on logging in aqbanking, make the connection, 
then copy the transactions out of the aqbanking log file into a separate text 
file for manual import.
--
Dave Reiser
dbrei...@icloud.com





> On Nov 2, 2020, at 11:00 AM, Fross, Michael  wrote:
> 
> David, where did you download the OFX file from Fidelity?  I've not seen 
> that.  Were you using AQ Banking (I've never been able to get it to work)?
> 
> Michael
> 
> On Mon, Nov 2, 2020 at 9:12 AM David Reiser via gnucash-user 
> mailto:gnucash-user@gnucash.org>> wrote:
> Good to know.
> 
> My Fidelity ofx data is up to date (I got a 10/30 dividend transaction in 
> yesterday’s download).
> 
> --
> Dave Reiser
> dbrei...@icloud.com <mailto:dbrei...@icloud.com>
> 
> 
> 
> 
> 
> > On Nov 2, 2020, at 10:06 AM, Kalpesh Patel  > <mailto:kalpesh.pa...@usa.net>> wrote:
> > 
> > You may want to explore freeware product called PocketSense (at
> > https://sites.google.com/site/pocketsense/ 
> > <https://sites.google.com/site/pocketsense/> and
> > https://pocketsense.blogspot.com/ <https://pocketsense.blogspot.com/>) by 
> > fine gentleman named Robert which is
> > to more or less degree has been kept up with modern times. Robert will
> > accept donation to Coffee Fund in case you want to contribute something
> > after finding it useful.
> > 
> > 
> > 
> > It was made to be able to continue use of M$ Money online when they
> > discontinued that product. However, what I discovered was that it has
> > ability to combine and generate a single OFX file after scrapping number of
> > statements from various brokers, handles multiple accounts from a single
> > broker and ability to import manually downloaded OFX files for those that
> > are not readily support by the download interface into that single file.
> > Then it is matter of just importing that single file into GnuCash. Don't get
> > discouraged from the documentation if you do decide to plunge; it is way
> > easier then what is made out to be there - just need Python 2.7, configure a
> > file with OFX parameters (gotten from OFXHome at
> > https://www.ofxhome.com/index.php/home/directory/all 
> > <https://www.ofxhome.com/index.php/home/directory/all>)  and some
> > experimentation. I have been using this method since I moved over from
> > Quicken once they went the subscription model after somewhat painful
> > migration to GnuCash. It claims to be able to also download security pricing
> > as part of the process which I do not use at this time - GnuCash does a good
> > job on its own so I just use that provided facility. I basically run it when
> > I fire up my computer which collects various statements and then import it
> > in at that time and call it a day.
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > Heads up for those that use aqbanking to connect brokers for download:
> > 
> > 
> > 
> > Charles Schwab: recently they have closed off download of OFX based
> > statement and will only let you download CSV file after logging on to their
> > site. In order to continue OFX download, you have to be a Quicken subscriber
> > and few other that I cannot recall but very limited offering from the
> > conversation I had with their support folks.
> > 
> > Fidelity:  the data on OFX server lags by a month or more.
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > ___
> > 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 <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://w

Re: [GNC] Fidelity and TD Ameritrade setup

[David Reiser via gnucash-user]

Good to know.

My Fidelity ofx data is up to date (I got a 10/30 dividend transaction in 
yesterday’s download).

--
Dave Reiser
dbrei...@icloud.com





> On Nov 2, 2020, at 10:06 AM, Kalpesh Patel  wrote:
> 
> You may want to explore freeware product called PocketSense (at
> https://sites.google.com/site/pocketsense/ and
> https://pocketsense.blogspot.com/) by fine gentleman named Robert which is
> to more or less degree has been kept up with modern times. Robert will
> accept donation to Coffee Fund in case you want to contribute something
> after finding it useful.
> 
> 
> 
> It was made to be able to continue use of M$ Money online when they
> discontinued that product. However, what I discovered was that it has
> ability to combine and generate a single OFX file after scrapping number of
> statements from various brokers, handles multiple accounts from a single
> broker and ability to import manually downloaded OFX files for those that
> are not readily support by the download interface into that single file.
> Then it is matter of just importing that single file into GnuCash. Don't get
> discouraged from the documentation if you do decide to plunge; it is way
> easier then what is made out to be there - just need Python 2.7, configure a
> file with OFX parameters (gotten from OFXHome at
> https://www.ofxhome.com/index.php/home/directory/all)  and some
> experimentation. I have been using this method since I moved over from
> Quicken once they went the subscription model after somewhat painful
> migration to GnuCash. It claims to be able to also download security pricing
> as part of the process which I do not use at this time - GnuCash does a good
> job on its own so I just use that provided facility. I basically run it when
> I fire up my computer which collects various statements and then import it
> in at that time and call it a day.
> 
> 
> 
> 
> 
> 
> 
> Heads up for those that use aqbanking to connect brokers for download:
> 
> 
> 
> Charles Schwab: recently they have closed off download of OFX based
> statement and will only let you download CSV file after logging on to their
> site. In order to continue OFX download, you have to be a Quicken subscriber
> and few other that I cannot recall but very limited offering from the
> conversation I had with their support folks.
> 
> Fidelity:  the data on OFX server lags by a month or more.
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> ___
> 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] Fidelity and TD Ameritrade setup

[David Reiser via gnucash-user]

My fidelity account automatically got specified as an investment account, so in 
my section of the log file says:


fidelity.com
account_id_here


That part is generated by aqbanking to send to fidelity. In the online banking 
setup tool, if you launch the wizard and go to accounts, pick the fidelity 
account and choose Edit, there’s a popup with account type. Mine says 
Investment Account.

That might not be the source of your Bad Request error. It might be, but 
anything else that went wrong along the way might also end up with the same 
error.

Dave
--
Dave Reiser
dbrei...@icloud.com





> On Nov 1, 2020, at 8:33 PM, April  wrote:
> 
> Thank you for your information, Dave.
> 
> With your help, I managed to turn on the loging. I see this from fidelity.
> Receiving response...
> HTTP-Status: 400 (Bad Request)
> Unlocking customer "36"
> 
> Inside the log file:
> 
> fidelity.com <http://fidelity.com/>
> account_number_here
> MONEYMRKT
> 
> 
> Wondering if it got to do with ACCTTYPE. 
> 
> Anyone has any ideas?
> 
> Thanks
> Ada
> 
> 
> On Sun, Nov 1, 2020 at 3:35 PM David Reiser  <mailto:dbrei...@icloud.com>> wrote:
> 
> > On Nov 1, 2020, at 2:43 PM, April  > <mailto:faith201...@gmail.com>> wrote:
> > 
> > Hi there,
> > 
> > I am new to Gnucash. I would like to set up online access for Fidelity and
> > TD Ameritrade.
> > 
> > But somehow I can not get them to work. For example, I can get account list
> > but can not get transactions from Fidelity .
> > 
> > Anyone set up successfully?
> > 
> > Thanks
> > Ada
> > 
> 
> The transactions are probably being sent, but aqbanking doesn’t handle 
> brokerage account transactions well at all. The aqbanking author doesn’t have 
> access to any US brokerage accounts to do testing. The net result is that a 
> direct online banking download from Fidelity and TDAmeritrade results in 
> almost no transactions showing up in Gnucash.
> 
> If you set up aqbanking to keep a log of the ofx download data stream, you 
> can open the log, save the text associated with a particular download to a 
> separate text file (transactions.ofx, for example), then use 
> File>Import>Import QFX/OFX… in gnucash to import the transactions. With the 
> manual import, gnucash uses the libofx library instead of aqbanking.
> 
> Neither Fidelity nor TDAmeritrade makes it easy to get an ofx file. They 
> assume that if you’re on the website you want a CSV download. And obviously 
> (they think) if you want ofx, then you’re using Quicken. So you end up having 
> to either get an external ofx connection app or deal with the aqbanking log 
> file.
> 
> Dave
> --
> Dave Reiser
> dbrei...@icloud.com <mailto:dbrei...@icloud.com>
> 
> 
> 
> 
> 

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

Re: [GNC] Fidelity and TD Ameritrade setup

[David Reiser via gnucash-user]

> On Nov 1, 2020, at 2:43 PM, April  wrote:
> 
> Hi there,
> 
> I am new to Gnucash. I would like to set up online access for Fidelity and
> TD Ameritrade.
> 
> But somehow I can not get them to work. For example, I can get account list
> but can not get transactions from Fidelity .
> 
> Anyone set up successfully?
> 
> Thanks
> Ada
> 

The transactions are probably being sent, but aqbanking doesn’t handle 
brokerage account transactions well at all. The aqbanking author doesn’t have 
access to any US brokerage accounts to do testing. The net result is that a 
direct online banking download from Fidelity and TDAmeritrade results in almost 
no transactions showing up in Gnucash.

If you set up aqbanking to keep a log of the ofx download data stream, you can 
open the log, save the text associated with a particular download to a separate 
text file (transactions.ofx, for example), then use File>Import>Import QFX/OFX… 
in gnucash to import the transactions. With the manual import, gnucash uses the 
libofx library instead of aqbanking.

Neither Fidelity nor TDAmeritrade makes it easy to get an ofx file. They assume 
that if you’re on the website you want a CSV download. And obviously (they 
think) if you want ofx, then you’re using Quicken. So you end up having to 
either get an external ofx connection app or deal with the aqbanking log file.

Dave
--
Dave Reiser
dbrei...@icloud.com





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

Re: [GNC] AQ Banking OFX Direct Connect

[David Reiser via gnucash-user]

Once you get Citi working, you won’t have to use the extra connection with 
their web site — it’s a one-off authorization for each piece of software.
--
Dave Reiser
dbrei...@icloud.com





> On Oct 20, 2020, at 8:33 AM, David Reiser via gnucash-user 
>  wrote:
> 
> 2200
> 
> Is almost certainly part of your problem. That number is the way Quicken 
> (formerly Intuit) locked out versions older than 3 years from downloading 
> data. There may be new ways to do that now that Quicken is totally 
> subscription based, but 2700 has been working for me lately.
> 
> Next, Citibank has (or had a year ago) a secondary authentication protocol 
> that required you to log into their web site, find the necessary support page 
> to tell them you were going to be logging in with some automated software, 
> and then go out and use that software to log in to Citi’s server within 10 
> minutes. Citibank has been weird over the years, but it has been working for 
> me with regard to credit card transaction data.
> 
> Amex has several entry points for data, and figuring out which one might 
> respond favorably to your login requests is your first task. I avoid Amex 
> whenever possible, so I will have no useful information for you.
> --
> Dave Reiser
> dbrei...@icloud.com
> 
> 
> 
> 
> 
>> On Oct 19, 2020, at 4:27 PM, Edwin Franks  wrote:
>> 
>> I am trying to get connected to my banking institutions using the AQ Banking 
>> OFX Direct Connect module.  The application apparently authenticates my user 
>> name and password properly, but instead of returning data, it returns an 
>> error.  For my American Express credit card, it gives an “Account not found” 
>> error.  For my Citibank credit card, it gives me an Http-Status: 403 
>> (Forbidden) error.  Below are the contents of the messages from the AQ 
>> Banking GUI and OFX.LOG files for both the American Express and Citibank 
>> attempts:
>> 
>> American Express Messages:
>> 
>> Messages shown in the AQBanking GUI:
>> 
>> AqBanking v6.2.2.0stable
>> Sending jobs to the bank(s)
>> Sorting commands by account
>> Sorting commands by account
>> Sorting commands by provider
>> Send commands to providers
>> Send commands to provider "aqofxconnect"
>> Locking customer "2"
>> Saving communication log to /tmp/ofx.log
>> Sending request...
>> Connecting to server...
>> Resolving hostname "online.americanexpress.com" ...
>> IP address is "23.67.235.83"
>> Connecting to "online.americanexpress.com"
>> Connected to "online.americanexpress.com"
>> Using GnuTLS default ciphers.
>> TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD
>> Connected.
>> Sending message...
>> Message sent.
>> Waiting for response...
>> Receiving response...
>> HTTP-Status: 200 (OK)
>> Response received.
>> Disconnecting from server...
>> Disconnected.
>> Saving communication log to /tmp/ofx.log
>> Parsing response...
>> Status for signon request: Success (Code 0, severity "INFO")
>> The server successfully processed the request.
>> Status for transaction statement request: Account not found (Code 2003, 
>> severity "ERROR")
>> The specified account number does not correspond to one of the user's 
>> accounts.
>> Unlocking customer "2"
>> 
>> Sanitized Contents of the OFX.LOG File:
>> 
>> Sending:
>> -
>> OFXHEADER:100
>> DATA:OFXSGML
>> VERSION:102
>> SECURITY:NONE
>> ENCODING:USASCII
>> CHARSET:1252
>> COMPRESSION:NONE
>> OLDFILEUID:NONE
>> NEWFILEUID:20201019194220.000
>> 
>> 
>> 
>> 
>> 20201019194201.000
>> 
>> 
>> ENG
>> 
>> AMEX
>> 3101
>> 
>> QWIN
>> 2200
>> 
>> 
>> 
>> 
>> 20201019194220.000
>> 1
>> 
>> 
>> 
>> 
>> 
>> 2020101400.000
>> 2020101900.000
>> Y
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> Received:
>> -
>> OFXHEADER:100
>> DATA:OFXSGML
>> VERSION:102
>> SECURITY:NONE
>> ENCODING:USASCII
>> CHARSET:1252
>> COMPRESSION:NONE
>> OLDFILEUID:NONE
>> NEWFILEUID:20201019194220.000
>> 
>> 0INFOLogin 
>> successful20201019124220.670[-7:MST]ENGAMEX3101FMPWebBCM2020101912422020201019194220.0002003ERROR1
>> 
>> Citibank Messages:
>&

Re: [GNC] AQ Banking OFX Direct Connect

[David Reiser via gnucash-user]

2200

Is almost certainly part of your problem. That number is the way Quicken 
(formerly Intuit) locked out versions older than 3 years from downloading data. 
There may be new ways to do that now that Quicken is totally subscription 
based, but 2700 has been working for me lately.

Next, Citibank has (or had a year ago) a secondary authentication protocol that 
required you to log into their web site, find the necessary support page to 
tell them you were going to be logging in with some automated software, and 
then go out and use that software to log in to Citi’s server within 10 minutes. 
Citibank has been weird over the years, but it has been working for me with 
regard to credit card transaction data.

Amex has several entry points for data, and figuring out which one might 
respond favorably to your login requests is your first task. I avoid Amex 
whenever possible, so I will have no useful information for you.
--
Dave Reiser
dbrei...@icloud.com





> On Oct 19, 2020, at 4:27 PM, Edwin Franks  wrote:
> 
> I am trying to get connected to my banking institutions using the AQ Banking 
> OFX Direct Connect module.  The application apparently authenticates my user 
> name and password properly, but instead of returning data, it returns an 
> error.  For my American Express credit card, it gives an “Account not found” 
> error.  For my Citibank credit card, it gives me an Http-Status: 403 
> (Forbidden) error.  Below are the contents of the messages from the AQ 
> Banking GUI and OFX.LOG files for both the American Express and Citibank 
> attempts:
> 
> American Express Messages:
> 
> Messages shown in the AQBanking GUI:
> 
> AqBanking v6.2.2.0stable
> Sending jobs to the bank(s)
> Sorting commands by account
> Sorting commands by account
> Sorting commands by provider
> Send commands to providers
> Send commands to provider "aqofxconnect"
> Locking customer "2"
> Saving communication log to /tmp/ofx.log
> Sending request...
> Connecting to server...
> Resolving hostname "online.americanexpress.com" ...
> IP address is "23.67.235.83"
> Connecting to "online.americanexpress.com"
> Connected to "online.americanexpress.com"
> Using GnuTLS default ciphers.
> TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD
> Connected.
> Sending message...
> Message sent.
> Waiting for response...
> Receiving response...
> HTTP-Status: 200 (OK)
> Response received.
> Disconnecting from server...
> Disconnected.
> Saving communication log to /tmp/ofx.log
> Parsing response...
> Status for signon request: Success (Code 0, severity "INFO")
> The server successfully processed the request.
> Status for transaction statement request: Account not found (Code 2003, 
> severity "ERROR")
> The specified account number does not correspond to one of the user's 
> accounts.
> Unlocking customer "2"
> 
> Sanitized Contents of the OFX.LOG File:
> 
> Sending:
> -
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:102
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:20201019194220.000
> 
> 
> 
> 
> 20201019194201.000
> 
> 
> ENG
> 
> AMEX
> 3101
> 
> QWIN
> 2200
> 
> 
> 
> 
> 20201019194220.000
> 1
> 
> 
> 
> 
> 
> 2020101400.000
> 2020101900.000
> Y
> 
> 
> 
> 
> 
> 
> 
> Received:
> -
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:102
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:20201019194220.000
> 
> 0INFOLogin 
> successful20201019124220.670[-7:MST]ENGAMEX3101FMPWebBCM2020101912422020201019194220.0002003ERROR1
> 
> Citibank Messages:
> 
> Messages Shown in the AQBanking GUI:
> 
> AqBanking v6.2.2.0stable
> Sending jobs to the bank(s)
> Sorting commands by account
> Sorting commands by account
> Sorting commands by provider
> Send commands to providers
> Send commands to provider "aqofxconnect"
> Locking customer "3"
> Saving communication log to /tmp/ofx.log
> Sending request...
> Connecting to server...
> Resolving hostname "www.accountonline.com" ...
> IP address is "104.72.140.84"
> Connecting to "www.accountonline.com"
> Connected to "www.accountonline.com"
> Using GnuTLS default ciphers.
> TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
> Connected.
> Sending message...
> Message sent.
> Waiting for response...
> Receiving response...
> HTTP-Status: 403 (Forbidden)
> Unlocking customer "3"
> 
> Messages in the OFX.LOG File:
> 
> Sending:
> -
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:102
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:20201019151026.000
> 
> 
> 
> 
> 20201019150941.000
> 
> 
> ENG
> 
> Citigroup
> 24909
> 
> QWIN
> 2200
> 
> 
> 
> 
> 
> 20201019151026.000
> 1
> 
> 
> 
> 
> 
> 2020101000.000
> 2020101900.000
> Y
> 
> 
> 
> 
> 
> 
> Thank you for any help 

Re: [GNC] Error with Advanced portfolio report

[David Reiser via gnucash-user]

They haven’t missed a release date in over 2 years. It’s still barely 
mid-morning in the time zone where the primary release manage lives.
--
Dave Reiser
dbrei...@icloud.com





> On Sep 27, 2020, at 11:42 AM, mike823  wrote:
> 
> Got it. Any chance you can estimate the new date for us?
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] OFX log location

[David Reiser via gnucash-user]

On a mac, there is a file

/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment

that declares all the locations for gnucash to find things like configuration 
files and support library files. 
I don’t know where the same information lives in linux or windows.
--
Dave Reiser
dbrei...@icloud.com





> On Sep 16, 2020, at 11:26 PM, Tom B via gnucash-user 
>  wrote:
> 
> Dave,
> Please excuse my ignorance but I'm not familiar with the "gnucash
> environment file", please provide a bit more explanation.
> 
> regards,
> 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
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] OFX log location

[David Reiser via gnucash-user]

AQOFX_LOG_COMM=1

means you have named your ofx.log file “1” It’s probably either in the root 
level of your disk, or in /tmp

I put my definition in the gnucash environment file, and I use:

AQOFX_LOG_COMM={HOME}/logs/ofx.log

--
Dave Reiser
dbrei...@icloud.com





> On Sep 16, 2020, at 7:39 PM, Tom B via gnucash-user 
>  wrote:
> 
> Following the directions for setting env variables for OFX logging I am not
> finding the actual ofx.log. Where should i find the 
> OFX log
> 
> Linux Mint 20
> GnuCash 4.1
> Build ID: Flathub 4.1-2
> AqBanking-CLI: 6.2.1
> Gwenhywfar   : 5.3.0.0
> AqBanking: 6.2.1.0
> 
> AQBANKING_LOGLEVEL=info
> AQOFX_LOG_COMM=1
> AQOFXCONNECT_LOGLEVEL=info
> 
> Regards,
> Tom
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

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

[David Reiser via gnucash-user]

That’s the wrong library folder. There’s another one in /Users/[your user 
name]/Library.

Dave
--
Dave Reiser
dbrei...@icloud.com





> On Aug 16, 2020, at 5:56 PM, Marilyn Graves Kimple via gnucash-user 
>  wrote:
> 
> No problem-- there were actually two of us with the same problem, and I do 
> have a Mac but the other was Windows. But I know about Application Support 
> and I do not have a GnuCash folder. No idea why not.
> Best regards, mgk
>  PM.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
> 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] MacOS High Sierra 10.13.6 - recently updated to GNUCASH 4.0 and then 4.1 = app not opening

[David Reiser via gnucash-user]

I haven’t tried moving something from the HD to Applications recently. It 
didn’t used to be a problem. If gnucash was running, I’d suspect the OS was 
complaining about moving something into a protected place at a bad time. 
Otherwise, I haven’t a clue. But next I’d try restarting the Mac and moving the 
app before its first launch after the restart. If that doesn’t work, then I’d 
go for dragging a new copy from the disk image to the Applications folder.
--
Dave Reiser
dbrei...@icloud.com





> On Aug 10, 2020, at 3:31 PM, Anne  wrote:
> 
> Hi Dave, 
> 
> BTW, I moved the app to my HD no problem, but when I tried to move it into my 
> Applications.  The error box showed up=>"The operation can’t be completed 
> because an unexpected error occurred (error code -8062)."
> 
> Is this because I can't copy the app from HD into the Applications folder?  
> Do I need to move it directly from the disk image?
> 
> Thanks, 
> Anne
> 
> On Monday, August 10, 2020, 11:26:01 PM GMT+4, Anne  wrote:
> 
> 
> Hi Dave, 
> 
> Thanks, that did the trick!  Appreciate your help. 
> 
> Anne
> 
> On Monday, August 10, 2020, 9:57:00 PM GMT+4, David Reiser 
>  wrote:
> 
> 
> You can’t run it from the disk image. Drag it somewhere on your hard disk 
> (usually the Applications folder) and run it from there. Once on your hard 
> disk, try launching the app. If you don’t get the option to click an Open 
> button, then you’ll have to right click on the app and choose Open from the 
> pop-up.
> 
> Dave
> --
> Dave Reiser
> dbrei...@icloud.com <mailto:dbrei...@icloud.com>
> 
> 
> 
> 
> 
>> On Aug 10, 2020, at 1:25 PM, Anne > <mailto:acix...@yahoo.com>> wrote:
>> 
>> Hi Dave, 
>> 
>> Thanks for your reply. I've started multiple times but the results are the 
>> same
>> 
>> However,  when the below warning comes up --- 
>> 
>> ["Gnucash" is an application downloaded from the Internet.  Are you sure you 
>> want to open it? (Gnucash is on the disk image "Gnucash-Intel-4.0-2.dmg". 
>> Firefox downloaded this disk image on July 13, 2020)].  
>> 
>> 
>> I didn't check the box that says "Don't warn me when opening application 
>> on this disk image" but clicked on openthat's when nothing opens or 
>> happensevery dialog disappears.  Should I check the box that stops the 
>> computer from warning me? 
>> 
>> Thanks for your help, 
>> 
>> Anne
>> 
>> On Monday, August 10, 2020, 5:58:55 PM GMT+4, David Reiser 
>> mailto:dbrei...@icloud.com>> wrote:
>> 
>> 
>> Did you try opening it a second time? I’ve always had the gatekeeper dialog 
>> go away, and gnucash fails to open. Once gatekeeper has permission, it 
>> doesn’t interfere any more, and all subsequent launches work as expected.  
>> My first attempt in a certain unreleased version finally seems to have fixed 
>> that problem, but we’ll see.
>> 
>> Dave
>> --
>> Dave Reiser
>> dbrei...@icloud.com <mailto:dbrei...@icloud.com>
>> 
>> 
>> 
>> 
>> 
>> > On Aug 9, 2020, at 9:35 PM, Anne via gnucash-user 
>> > mailto:gnucash-user@gnucash.org>> wrote:
>> > 
>> > Been using the software for years without issues in opening up after 
>> > downloading the update. 
>> > 
>> > After installing Gnucash-Intel-4.1-2.dmg and clicking on the GNUCASH icon, 
>> > I get the warning from Mac about opening the file download using Firefox.  
>> > Then I select OPEN => nothing happens.  GNU CASH doesn't open. 
>> > 
>> > I see the files are still there, but nothing opens.
>> > Please help.
>> > Thanks, 
>> > Anne
> 

___
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] MacOS High Sierra 10.13.6 - recently updated to GNUCASH 4.0 and then 4.1 = app not opening

[David Reiser via gnucash-user]

You can’t run it from the disk image. Drag it somewhere on your hard disk 
(usually the Applications folder) and run it from there. Once on your hard 
disk, try launching the app. If you don’t get the option to click an Open 
button, then you’ll have to right click on the app and choose Open from the 
pop-up.

Dave
--
Dave Reiser
dbrei...@icloud.com





> On Aug 10, 2020, at 1:25 PM, Anne  wrote:
> 
> Hi Dave, 
> 
> Thanks for your reply. I've started multiple times but the results are the 
> same
> 
> However,  when the below warning comes up --- 
> 
> ["Gnucash" is an application downloaded from the Internet.  Are you sure you 
> want to open it? (Gnucash is on the disk image "Gnucash-Intel-4.0-2.dmg". 
> Firefox downloaded this disk image on July 13, 2020)].  
> 
> 
> I didn't check the box that says "Don't warn me when opening application 
> on this disk image" but clicked on openthat's when nothing opens or 
> happensevery dialog disappears.  Should I check the box that stops the 
> computer from warning me? 
> 
> Thanks for your help, 
> 
> Anne
> 
> On Monday, August 10, 2020, 5:58:55 PM GMT+4, David Reiser 
>  wrote:
> 
> 
> Did you try opening it a second time? I’ve always had the gatekeeper dialog 
> go away, and gnucash fails to open. Once gatekeeper has permission, it 
> doesn’t interfere any more, and all subsequent launches work as expected.  My 
> first attempt in a certain unreleased version finally seems to have fixed 
> that problem, but we’ll see.
> 
> Dave
> --
> Dave Reiser
> dbrei...@icloud.com <mailto:dbrei...@icloud.com>
> 
> 
> 
> 
> 
> > On Aug 9, 2020, at 9:35 PM, Anne via gnucash-user  > <mailto:gnucash-user@gnucash.org>> wrote:
> > 
> > Been using the software for years without issues in opening up after 
> > downloading the update. 
> > 
> > After installing Gnucash-Intel-4.1-2.dmg and clicking on the GNUCASH icon, 
> > I get the warning from Mac about opening the file download using Firefox.  
> > Then I select OPEN => nothing happens.  GNU CASH doesn't open. 
> > 
> > I see the files are still there, but nothing opens.
> > Please help.
> > Thanks, 
> > Anne

___
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] MacOS High Sierra 10.13.6 - recently updated to GNUCASH 4.0 and then 4.1 = app not opening

[David Reiser via gnucash-user]

Did you try opening it a second time? I’ve always had the gatekeeper dialog go 
away, and gnucash fails to open. Once gatekeeper has permission, it doesn’t 
interfere any more, and all subsequent launches work as expected.  My first 
attempt in a certain unreleased version finally seems to have fixed that 
problem, but we’ll see.

Dave
--
Dave Reiser
dbrei...@icloud.com





> On Aug 9, 2020, at 9:35 PM, Anne via gnucash-user  
> wrote:
> 
> Been using the software for years without issues in opening up after 
> downloading the update. 
> 
> After installing Gnucash-Intel-4.1-2.dmg and clicking on the GNUCASH icon, I 
> get the warning from Mac about opening the file download using Firefox.  Then 
> I select OPEN => nothing happens.  GNU CASH doesn't open. 
> 
> I see the files are still there, but nothing opens.
> Please help.
> Thanks, 
> Anne

___
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] Latest Update

[David Reiser via gnucash-user]

Both were as planned in the release schedule. The 4.0 update was 3 months after 
3.9 (3.10 was an emergency release 2 weeks after 3.9, and 3.11 was the normally 
planned simultaneous release with 4.0). As with most x.0 releases, there were 
enough bugfixes in the first month after release to warrant the 4.1 release on 
a faster schedule. Again, the 4.1 release plan was published far in advance as 
being a 1-month after 4.0. To put things back to the usual schedule (every 
three months at the end of the usual calendar quarters), the 4.2 release is 
scheduled for the end of September. Other than the 3.10 issues, there are no 
surprises here.
--
Dave Reiser
dbrei...@icloud.com





> On Aug 4, 2020, at 9:23 AM, John Donnee  wrote:
> 
> Any idea as to why there have been two updates in the past month?
> 
> I have an iMac and decided not to do the last update.
> 
> Thanks
> 
> John
> -- 
> John J Donnee
> 
> 317 Mount Eden Place
> Cary, NC 27518
> ___
> 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] Matcher for qfx files

[David Reiser via gnucash-user]

It at least uses the , which is matched via the 
outside-account-to-gnucash-account list. And imports of multiple TIAA contracts 
containing multiple instances of the same fund do work correctly if the links 
are set up correctly. I’m currently using gnucash 4.1, but I don’t recall 
problems with 3.8 specifically. There was one version where changes in the 
matcher resulted in requests to re-establish links to the various TIAA accounts 
and funds.

I frequently have to undo my choices when I get one of those dialogs because 
I’m not careful enough at reading the exact language at the top of the dialog. 
I haven’t made many changes lately, but I think you’ll get a request to 
identify a security, but that usually also includes a statement about which 
TIAA contract is involved. Then (? hmm, not sure of the order…) it’ll ask you 
for a gnucash account to associate with a specific TIAA contract. Somewhere 
along the way, there’s a question about which account to associate income from 
the various contracts and/or funds. Most of that used to get rolled up inside 
the TIAA/CREF funds, but now at least one of our contracts splits out a special 
fee/credit that is something like the net difference between dividends and fees 
for several of the funds.

If your employer hasn’t done an administrative change that would kick some 
extra transactions into your ofx stream (and there appears to be a lot of 
pressure from somewhere to do that), then having gnucash ask for additional 
matching info is a bit strange. One other possibility is that your employer’s 
plan has qualified for a better version of the same fund you’ve had for a while 
(R3 vs R2 fee levels, higher digit is lower fees). One example is CREF stock R3 
(QCSTIX in public symbol world) vs CREF stock R2 (QCSTPX).

Since there have been a few import transaction matcher changes lately, I’d 
recommend giving gnucash version 4.1 a try if you can. I’m unfamiliar with the 
version availability in the linux prepackaged realm.
--
Dave Reiser
dbrei...@icloud.com




> On Aug 2, 2020, at 1:53 PM, Dale Alspach  wrote:
> 
> When importing a .qfx file does the matcher use the tags   and
> ?
> 
> The issue is that I download transactions from TIAA which are from multiple
> accounts but are in the same download. There are some mutual funds which
> are held in more than one account.
> I recently upgraded to gnucash 3.8. I started to do an import in gnucash
> 3.8 (linux mint 20) and was asked to match a fund to an account but was
> only given the cusip number. which refers to a security which could be in
> any one of 3 gnucash accounts.
> If I recall correctly older versions of gnucash gave the name of the fund
> and the TIAA contract number.
> 
> Dale

___
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 stopped working after upgrade to macOS Catalina

[David Reiser via gnucash-user]

> On Jul 30, 2020, at 9:44 AM, Richard Belshoff  
> wrote:
> 
> I upgraded my macbook pro from High Sierra 10.13.6 to Catalina 10.15.6. Now
> when I go to applications and click on "Gnucash", nothing happens. How can
> I get gnucash to work again?  Any ideas?
> Thanks,
> Richard
What version of Gnucash? I’ve been using Gnucash on Catalina since at least 
version 3.8 (5 versions ago…).
The simplest thing to try is download the current version of Gnucash (4.1) and 
install that. It should work, though I always have to launch new versions twice 
(for the first run) to get past the gatekeeper dialog even though I say, yes, 
open it.

Dave
--
Dave Reiser
dbrei...@icloud.com




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

Re: [GNC] Gnucash - user: Google result

[David Reiser via gnucash-user]

And to make matters more confusing, those two options aren’t exclusive. Both 
are checked in my Edit>Attachments pop-out. I think  I viewed the 
“windows-friendly” as preventing resource forks  in the old days and possibly 
managing file name character sets at some point since then.

The annoying part of the “always at the end” doesn’t necessarily preclude such 
an attachment from still being officially an inline inclusion, just that it’s 
placed at the end.
--
Dave Reiser
dbrei...@icloud.com





> On Jul 7, 2020, at 11:11 AM, Adrien Monteleone 
>  wrote:
> 
> Sure enough, it seems the last update set me to ‘Always Send Windows-Friendly 
> Attachments’ instead of ‘Always Insert Attachments at End of Message’. (I 
> don’t recall where the preference was originally when I set it years ago. It 
> is now in Edit > Attachments instead of in Mail > Preferences where Apple’s 
> own guidelines say it should go, but I guess they get to violate their own 
> rules.)
> 
> This is an example of good case for not setting a new default preference on a 
> software update!
> 
> Hope anyone using Mail.app with the same problem finds this...
> 
> Regards,
> Adrien
> 
>> On Jul 7, 2020 w28d189, at 10:01 AM, Adrien Monteleone 
>>  wrote:
>> 
>> Nope, it was an attachment. (or supposed to be) I made sure to put it at the 
>> end, and my mail.app is set to ‘attach’ rather than ‘inline’. I confess, 
>> mail.app could have done what it wanted though. It wouldn’t be the first 
>> time.
>> 
>> But here is the URL: 
>> https://lists.gnucash.org/pipermail/gnucash-user/2015-January/057812.html
>> 
>> Note my followup message that I realized this is a hit from a list topic 
>> with that term, so there isn’t likely anything to be done about it.
> 
> 

___
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] Best match probability calc is too pessimistic

[David Reiser via gnucash-user]

Done. Bug 797847 <https://bugs.gnucash.org/show_bug.cgi?id=797847>

I left out the moribund straggling check issue, since it’s a much lower 
priority to me. I write about 5 checks a year these days. The credit card 
import issue pretty much happens every time I import.

Dave
--
Dave Reiser
dbrei...@icloud.com





> On Jul 5, 2020, at 3:11 PM, Jim DeLaHunt  wrote:
> 
> On 2020-07-05 11:49, David Reiser via gnucash-user wrote:
>> …From my perspective, transactions posting within 3 days of the transaction 
>> date should still get a match score of 6. One day after transaction ought to 
>> be 8. One of the grocery stores I go to frequently has never posted the 
>> charge to the credit card company the next day. Sometimes there’s only a 
>> 2-day gap, but it is frequently 3 days. I suspect the difference between 2 
>> and 3 days is related to how late in the evening I go shopping.
>> 
>> And on the extreme end, for a checking account transaction, if the imported 
>> check number (complicated by bank-prepended zeroes) and amount match 
>> exactly, and the date in gnucash is within 180 days of the bank’s date, then 
>> the transaction should still have some usable match score. In the U.S., the 
>> bank will still pay that check. I have had friends sit on checks for 
>> excessive lengths of time.
> 
> David, I completely agree with you. I have been doing a lot of transaction 
> importing from OFX recently, and it's a continuing problem that I can't trust 
> the matcher to handle dates the way you describe.
> 
> Would you care to add a bug report for this into the bug tracker, 
> <https://bugs.gnucash.org/> ? If so, I'll second it.
> 
> Best regards,
> —Jim DeLaHunt, software engineer, Vancouver, Canada
> 

___
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] Best match probability calc is too pessimistic

[David Reiser via gnucash-user]

I keep my records based on transaction date. I want to know when I bought 
something, not when a credit card company gets around to posting it. Online 
transactions will sometimes post on the transaction date, but in-store 
transaction almost never do. I almost always enter transactions in gnucash 
before I download transactions from the bank. With most transactions entered 
prior to downloading, finding mistakes and missed transactions is much easier.

Under the transaction matcher behavior in gnucash 4.0, a transaction which 
posts one day after the transaction date gets a best match probability score 
too low to ever meet the auto-match threshold during an ofx import processing 
run. For example, I bought some stamps at the post office on July 2. The credit 
card company posted the transaction on July 3. When I imported transaction on 
July 5, the transaction showed up in the matcher window with no probable match 
acknowledged.

From my perspective, transactions posting within 3 days of the transaction date 
should still get a match score of 6. One day after transaction ought to be 8. 
One of the grocery stores I go to frequently has never posted the charge to the 
credit card company the next day. Sometimes there’s only a 2-day gap, but it is 
frequently 3 days. I suspect the difference between 2 and 3 days is related to 
how late in the evening I go shopping.

And on the extreme end, for a checking account transaction, if the imported 
check number (complicated by bank-prepended zeroes) and amount match exactly, 
and the date in gnucash is within 180 days of the bank’s date, then the 
transaction should still have some usable match score. In the U.S., the bank 
will still pay that check. I have had friends sit on checks for excessive 
lengths of time.

Dave
--
Dave Reiser
dbrei...@icloud.com





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

Re: [GNC] Finance::Quote enters previous day's price as today's

[David Reiser via gnucash-user]

> On Jun 24, 2020, at 3:00 AM, Colin Arndt  wrote:
> 
> Interesting. It still sounds like a bug report is in order if it’s storing an 
> incorrect price after normal user interaction with the feature. The bug is 
> that it’s storing a new price for the day before there is a new price for the 
> day, and only correcting it after it gets the day’s price. I can adjust my 
> behavior to avoid this, but it will affect other people in the future. Does 
> that sound reasonable?
> 

It’s more like a policy dispute between you and the likes of yahoo finance. 
Yahoo has decided that they will account for any overnight corrections to 
funds' prior day closing by coughing up a pre-market quote with today’s date 
and yesterday’s adjusted closing price. Most pre-market quotes will be exactly 
the same as yesterday’s early evening reported closing price, but not always. 

If the data broker hands finance-quote a valid date and a valid price, there’s 
no way gnucash can determine that it should ignore the data record.

It looks like the part of alphavantage that finance-quote uses comes closer to 
what you want than yahoo does, but then it wasn’t possible to get a quote of 
Monday’s close of VTSAX from alphavantage+finance quote (at least not on 
Tuesday—I don’t know about Monday night). Perhaps alphavantage’s policy is that 
any overnight corrections block any outgoing price quote for the corrected day 
for that fund, at least as far as “yesterday’s closing price” is concerned.

> Thanks for your help everyone.
> 
> Matt, I’m on Linux not Windows, but I’d love to have your script as a 
> starting point in case I go the import route. Thanks for the offer.
> 
> On Wed, Jun 24, 2020 at 12:40 AM David Reiser  <mailto:dbrei...@icloud.com>> wrote:
> 
> > On Jun 23, 2020, at 4:10 PM, David Carlson  > <mailto:david.carlson@gmail.com>> wrote:
> > 
> > I am not sure that this is your problem or not, but I have found that I
> > need to wait several hours after the markets have closed before downloading
> > mutual fund prices.  It seems to take hours for some of them to get posted
> > at Yahoo.com. One way to check would be to see what Yahoo.com is reporting
> > early after hours vs later.
> > 
> > GnuCash only keeps one downloaded price per day, and repeated prices are
> > discarded.  If you see that is what is happening, you might file a RFE to
> > keep the last price reported instead of the first.
> > 
> > 
> On my test today, gnucash did save the most recent downloaded price for 
> today, not the first.
> 
> Fund prices can get weird, depending on data feed and intermediaries. Yahoo 
> as JSON was reporting an 8am price for today that was slightly different from 
> yesterday’s close for all three of these Vanguard funds. Alphavantage, as of 
> 6:30pm today (Tuesday) was still reporting Friday’s price for these funds.
> 
> Yahoo got today’s closing NAV for VTIAX and VWELX at 5:39 pm (EDT). The VTSAX 
> price didn’t update until 6:00pm.
> 
> 
> 
> > 
> > .
> > 
> > On Tue, Jun 23, 2020 at 2:19 PM Colin  > <mailto:lumica...@gmail.com>> wrote:
> > 
> >> First off, I just installed GnuCash a couple weeks ago, after trying a few
> >> other options and finding they simply weren't mature enough or
> >> feature-complete enough for what I need. I can't say thank you enough to
> >> everyone who's developed this program, everyone who continues to develop it
> >> and everyone who provides support here. It's an incredible accomplishment!
> >> 
> >> I have an issue with Finance::Quote. It brings in prices for my three
> >> Vanguard funds when I run the following command, and I've been planning on
> >> setting up a cron job for it:
> >> gnucash --add-price-quotes path/to/my/gnucash/file
> >> However, for one fund (VTSAX) it enters the prior day's price again as
> >> today's. This requires me to look it up and fix it manually. Its settings
> >> under Security editor are the same as the other two (VTIAX and VWELX).
> >> They're set to get online quotes from a single source, Alphavantage.
> >> Can anyone provide guidance on what may be going on here?
> >> Second question:
> >> I have a Raspberry Pi and it would make sense to run the cron job there
> >> since it's always up. I also use Syncthing for syncing files between
> >> devices. However, the latest version in their repo's is GnuCash 3.4 and
> >> Finance::Quote 1.47. Would this introduce problems to have the Pi update my
> >> GnuCash file with price quotes?
> >> 
> >> Thank you,
> >> Colin
> 
> 
> --
> Dave Reiser
> dbrei...@icloud.c

Re: [GNC] Finance::Quote enters previous day's price as today's

[David Reiser via gnucash-user]

> On Jun 23, 2020, at 4:10 PM, David Carlson  
> wrote:
> 
> I am not sure that this is your problem or not, but I have found that I
> need to wait several hours after the markets have closed before downloading
> mutual fund prices.  It seems to take hours for some of them to get posted
> at Yahoo.com. One way to check would be to see what Yahoo.com is reporting
> early after hours vs later.
> 
> GnuCash only keeps one downloaded price per day, and repeated prices are
> discarded.  If you see that is what is happening, you might file a RFE to
> keep the last price reported instead of the first.
> 
> 
On my test today, gnucash did save the most recent downloaded price for today, 
not the first.

Fund prices can get weird, depending on data feed and intermediaries. Yahoo as 
JSON was reporting an 8am price for today that was slightly different from 
yesterday’s close for all three of these Vanguard funds. Alphavantage, as of 
6:30pm today (Tuesday) was still reporting Friday’s price for these funds.

Yahoo got today’s closing NAV for VTIAX and VWELX at 5:39 pm (EDT). The VTSAX 
price didn’t update until 6:00pm.



> 
> .
> 
> On Tue, Jun 23, 2020 at 2:19 PM Colin  wrote:
> 
>> First off, I just installed GnuCash a couple weeks ago, after trying a few
>> other options and finding they simply weren't mature enough or
>> feature-complete enough for what I need. I can't say thank you enough to
>> everyone who's developed this program, everyone who continues to develop it
>> and everyone who provides support here. It's an incredible accomplishment!
>> 
>> I have an issue with Finance::Quote. It brings in prices for my three
>> Vanguard funds when I run the following command, and I've been planning on
>> setting up a cron job for it:
>> gnucash --add-price-quotes path/to/my/gnucash/file
>> However, for one fund (VTSAX) it enters the prior day's price again as
>> today's. This requires me to look it up and fix it manually. Its settings
>> under Security editor are the same as the other two (VTIAX and VWELX).
>> They're set to get online quotes from a single source, Alphavantage.
>> Can anyone provide guidance on what may be going on here?
>> Second question:
>> I have a Raspberry Pi and it would make sense to run the cron job there
>> since it's always up. I also use Syncthing for syncing files between
>> devices. However, the latest version in their repo's is GnuCash 3.4 and
>> Finance::Quote 1.47. Would this introduce problems to have the Pi update my
>> GnuCash file with price quotes?
>> 
>> Thank you,
>> Colin


--
Dave Reiser
dbrei...@icloud.com



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

Re: [GNC] Import matcher shortcomings, OFX realm (at least)

[David Reiser via gnucash-user]

Overall, yes. But this case presents a many-to-many sorting out vs. the 
one-to-many resolution in QIF. And none of those unique IDs exist in the 
gnucash file until the transactions have finished being imported.
--
Dave Reiser
dbrei...@icloud.com



> On May 6, 2020, at 2:50 PM, Jean Laroche  wrote:
> 
> QIF is a lot worse the OFX. OFX transactions have a unique ID, which QIF ones 
> don't have...
> 
> On 5/6/20 11:48 AM, David Reiser wrote:
>> Thanks, Jean.
>> I think the QIF importer has some code that detects multiple possible 
>> matches and pops up a “select the right match” dialog/window. Perhaps that 
>> can be reworked/incorporated. I don’t use QIF too much, but I think that 
>> particular behavior gets triggered in a step a little closer to the final 
>> import sequence than the General Matcher window gets to when it has decided 
>> it has already identified matches.
>> --
>> Dave Reiser
>> dbrei...@icloud.com
>>> On May 6, 2020, at 2:16 PM, Jean Laroche  wrote:
>>> 
>>> I have run into this issue as well! Thanks for looking into it.
>>> I'll try to fix it. What should really be done here, I'm guessing is that 
>>> the matcher should not match several transactions to the same one. This may 
>>> not be super easy to fix, but I'll take a look.
>>> Jean
>>> 
>>> On 5/6/20 11:00 AM, David Reiser via gnucash-user wrote:
>>>> Michael Fross said:
>>>>> I have to keep importing the same QFX file over and over until I get
>>>>> “nothing to import” message. If I don’t, it seems to miss transactions in
>>>>> the file. Not sure about QIF, but Maybe it’s similar.
>>>>> 
>>>>> Michael
>>>> Ok, I’ll split this out into another discussion.
>>>> The need for multiple attempts at importing the same ofx file to get all 
>>>> the transactions imported is probably a result of a shortcoming in the 
>>>> matcher code when multiple same-dollar-value transactions (or nearly the 
>>>> same if Commercial ATM fee threshold is set to anything greater than 0.00) 
>>>> appear in the ofx file. One very common cause of such cases is vending 
>>>> machine transactions.
>>>> If you never enter any of the same-value transactions manually, and only 
>>>> import them, then you’ll probably be OK, because the matcher will suggest 
>>>> that all the transactions should be Added rather than matched.
>>>> If, however, you have even one of the same-value transactions entered 
>>>> manually, and a set of 5 same-value transactions incoming in the import 
>>>> file, the matcher’s default behavior is to display all 5 incoming 
>>>> transactions as having a good candidate match. The problem is that all 
>>>> five of those incoming transactions are pointed at a single transaction in 
>>>> the gnucash file. If you blithely click OK in the Matcher window, the 
>>>> import process matches the first incoming transaction to the existing 
>>>> transaction. Then when the second same-value transaction gets examined, 
>>>> the matcher says “Oh, I already matched that existing transaction, I’ll 
>>>> ignore this one”. And all subsequent same-value transaction that had 
>>>> reported they had a match in the file are ignored because the candidate 
>>>> match is already taken.
>>>> Matching can be even messier if you have, say, 4 transactions of $2.00 
>>>> entered in your data file, but 7 $2.00 transactions coming in with the 
>>>> import.
>>>> The reason sequential imports work is that once a candidate is matched and 
>>>> the import process ends, the next time the import process is launched, 
>>>> that first transaction is no longer a candidate match because it now has 
>>>> an imported transaction ID associated with it (and the transaction ID 
>>>> prevents the incoming transaction from appearing at all anymore), and the 
>>>> matcher moves on (sometimes only one candidate transaction at a time).
>>>> I did file a bug on this several years ago, but the matcher’s default 
>>>> match identification has not changed. What was added is the ability to 
>>>> double click a transaction in the matcher dialog window to see alternative 
>>>> transactions to match against. If you see multiple transactions in your 
>>>> matcher window with the same dollar value, you must inspect the potential 
>>>> matches for each one and select a different one from the top candidate 
>>&g

Re: [GNC] Import matcher shortcomings, OFX realm (at least)

[David Reiser via gnucash-user]

Thanks, Jean. 
I think the QIF importer has some code that detects multiple possible matches 
and pops up a “select the right match” dialog/window. Perhaps that can be 
reworked/incorporated. I don’t use QIF too much, but I think that particular 
behavior gets triggered in a step a little closer to the final import sequence 
than the General Matcher window gets to when it has decided it has already 
identified matches.
--
Dave Reiser
dbrei...@icloud.com





> On May 6, 2020, at 2:16 PM, Jean Laroche  wrote:
> 
> I have run into this issue as well! Thanks for looking into it.
> I'll try to fix it. What should really be done here, I'm guessing is that the 
> matcher should not match several transactions to the same one. This may not 
> be super easy to fix, but I'll take a look.
> Jean
> 
> On 5/6/20 11:00 AM, David Reiser via gnucash-user wrote:
>> Michael Fross said:
>>> I have to keep importing the same QFX file over and over until I get
>>> “nothing to import” message. If I don’t, it seems to miss transactions in
>>> the file. Not sure about QIF, but Maybe it’s similar.
>>> 
>>> Michael
>> Ok, I’ll split this out into another discussion.
>> The need for multiple attempts at importing the same ofx file to get all the 
>> transactions imported is probably a result of a shortcoming in the matcher 
>> code when multiple same-dollar-value transactions (or nearly the same if 
>> Commercial ATM fee threshold is set to anything greater than 0.00) appear in 
>> the ofx file. One very common cause of such cases is vending machine 
>> transactions.
>> If you never enter any of the same-value transactions manually, and only 
>> import them, then you’ll probably be OK, because the matcher will suggest 
>> that all the transactions should be Added rather than matched.
>> If, however, you have even one of the same-value transactions entered 
>> manually, and a set of 5 same-value transactions incoming in the import 
>> file, the matcher’s default behavior is to display all 5 incoming 
>> transactions as having a good candidate match. The problem is that all five 
>> of those incoming transactions are pointed at a single transaction in the 
>> gnucash file. If you blithely click OK in the Matcher window, the import 
>> process matches the first incoming transaction to the existing transaction. 
>> Then when the second same-value transaction gets examined, the matcher says 
>> “Oh, I already matched that existing transaction, I’ll ignore this one”. And 
>> all subsequent same-value transaction that had reported they had a match in 
>> the file are ignored because the candidate match is already taken.
>> Matching can be even messier if you have, say, 4 transactions of $2.00 
>> entered in your data file, but 7 $2.00 transactions coming in with the 
>> import.
>> The reason sequential imports work is that once a candidate is matched and 
>> the import process ends, the next time the import process is launched, that 
>> first transaction is no longer a candidate match because it now has an 
>> imported transaction ID associated with it (and the transaction ID prevents 
>> the incoming transaction from appearing at all anymore), and the matcher 
>> moves on (sometimes only one candidate transaction at a time).
>> I did file a bug on this several years ago, but the matcher’s default match 
>> identification has not changed. What was added is the ability to double 
>> click a transaction in the matcher dialog window to see alternative 
>> transactions to match against. If you see multiple transactions in your 
>> matcher window with the same dollar value, you must inspect the potential 
>> matches for each one and select a different one from the top candidate 
>> picked by default for all the same-value transactions.
>> I hope this explanation helps reduce the number of repeat imports you have 
>> to use.
>> Dave
>> --
>> Dave Reiser
>> dbrei...@icloud.com
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.

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

[GNC] Import matcher shortcomings, OFX realm (at least)

[David Reiser via gnucash-user]

Michael Fross said:
> I have to keep importing the same QFX file over and over until I get
> “nothing to import” message. If I don’t, it seems to miss transactions in
> the file. Not sure about QIF, but Maybe it’s similar.
> 
> Michael

Ok, I’ll split this out into another discussion.

The need for multiple attempts at importing the same ofx file to get all the 
transactions imported is probably a result of a shortcoming in the matcher code 
when multiple same-dollar-value transactions (or nearly the same if Commercial 
ATM fee threshold is set to anything greater than 0.00) appear in the ofx file. 
One very common cause of such cases is vending machine transactions.

If you never enter any of the same-value transactions manually, and only import 
them, then you’ll probably be OK, because the matcher will suggest that all the 
transactions should be Added rather than matched.

If, however, you have even one of the same-value transactions entered manually, 
and a set of 5 same-value transactions incoming in the import file, the 
matcher’s default behavior is to display all 5 incoming transactions as having 
a good candidate match. The problem is that all five of those incoming 
transactions are pointed at a single transaction in the gnucash file. If you 
blithely click OK in the Matcher window, the import process matches the first 
incoming transaction to the existing transaction. Then when the second 
same-value transaction gets examined, the matcher says “Oh, I already matched 
that existing transaction, I’ll ignore this one”. And all subsequent same-value 
transaction that had reported they had a match in the file are ignored because 
the candidate match is already taken.

Matching can be even messier if you have, say, 4 transactions of $2.00 entered 
in your data file, but 7 $2.00 transactions coming in with the import. 

The reason sequential imports work is that once a candidate is matched and the 
import process ends, the next time the import process is launched, that first 
transaction is no longer a candidate match because it now has an imported 
transaction ID associated with it (and the transaction ID prevents the incoming 
transaction from appearing at all anymore), and the matcher moves on (sometimes 
only one candidate transaction at a time).

I did file a bug on this several years ago, but the matcher’s default match 
identification has not changed. What was added is the ability to double click a 
transaction in the matcher dialog window to see alternative transactions to 
match against. If you see multiple transactions in your matcher window with the 
same dollar value, you must inspect the potential matches for each one and 
select a different one from the top candidate picked by default for all the 
same-value transactions.

I hope this explanation helps reduce the number of repeat imports you have to 
use.

Dave
--
Dave Reiser
dbrei...@icloud.com





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

Re: [GNC] Trying to set up online banking

[David Reiser via gnucash-user]

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





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

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

Re: [GNC] Trying to set up online banking

[David Reiser via gnucash-user]

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





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

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

Re: [GNC] some of my reconciliations in 3.9 are completely bonkers

[David Reiser via gnucash-user]

I have no problem with (A), except maybe if you’re using the gnucash posting 
date. A reconciliation resolves transactions based on the bank’s posting date, 
not gnucash’s. If I don’t enter March 31, 2020 interest until April 1, I’m 
still going to enter it in my account as having occurred on 3/31. But even that 
distinction can’t be causing what I’m seeing.

In my simplest case, my savings account was last reconciled based on the 
interest paid 1/31/2020. On 2/29 I received $0.96 in interest and on 3/31 I 
received $1.03 in interest. There were no other transactions during that time. 
I have no idea when I entered the February interest, but I did enter the March 
interest on 3/31/2020 (at least it was still 3/31 on the U.S. east coast).

When I click Reconcile, in the Reconcile Information dialog, I get:
Statement date 02/29/2020
Starting Balance $3024.39 (this amount was reconciled in gnucash 3.7)
ending Balance $3025.36  (reasonable, since 3024.39 + 0.96 = 3025.35)

Now if I click OK to get to the transaction check-off dialog, I get:

Starting balance: 375.15  (What???)
Ending Balance: 3025.36 (well, it remembered what I entered)
Reconciled balance: 376.11 (well, it is 375.15 + 0.96 …)

Difference: 2649.24 (the math is locally consistent, but the starting balance 
doesn’t represent anything in my register or what gnucash showed me on the 
prior screen)

Dave
--
Dave Reiser
dbrei...@icloud.com





> On Apr 1, 2020, at 1:19 AM, Christopher Lam  wrote:
> 
> This is due to https://bugs.gnucash.org/show_bug.cgi?id=797640 
> <https://bugs.gnucash.org/show_bug.cgi?id=797640>
> 
> This change modifies the reconciliation starting balance calculator from 
> Account->reconciled_balance to account->reconciled_balance on statement date.
> 
> The reasoning for this change is with the observation:
> 
> (A) if reconciliation is performed from a statement dated 31/01/2019, the 
> starting balance calculator should ignore transactions posted later than 
> 31/01/2019.
> 
> (B) subsequent work https://github.com/Gnucash/gnucash/pull/667 
> <https://github.com/Gnucash/gnucash/pull/667> aims to store past 
> reconciliation ending balances and statement date. As a result we can 
> re-reconcile any past statement.
> 
> (C) subsequent work will allow a sanity-check type report (illustrated in 
> above PR)  which will compare account reconciled balances at previous 
> statement dates, and highlight any discrepancy.
> 
> There have been previous feature requests to store and retrieve reconciled 
> balances and reconciliation dates, and I believe it's possible and reasonable.
> 
> Having explained the rationale, the reasoning (A) may be incorrect -- please 
> file in bug 797640 how/why starting_balance should include transactions 
> posted after statement date. If reasoning (A) is invalid then we will need to 
> revert the change, which means (B) and (C) above cannot happen.
> 
> On Wed, 1 Apr 2020, 11:48 am David Reiser via gnucash-user, 
> mailto:gnucash-user@gnucash.org>> wrote:
> My checking account reconciled fine.
> Then I went to two savings accounts and got completely off-the-wall results. 
> When I first clicked the reconcile button, the dialog that comes up has the 
> correct starting balance and the correct proposed to-be-reconciled balance. 
> When I click OK to get to the transaction check-off dialog, gnucash has 
> completely changed the starting balance to a much smaller number (and one 
> that has never appeared in the account ledger) and thus presents an out of 
> balance total that cannot be reconciled with the transactions that are in the 
> account.
> 
> Dave
> --
> Dave Reiser
> dbrei...@icloud.com <mailto:dbrei...@icloud.com>
> 
> 
> 
> 
> 
> ___
> 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.

[GNC] some of my reconciliations in 3.9 are completely bonkers

[David Reiser via gnucash-user]

My checking account reconciled fine.
Then I went to two savings accounts and got completely off-the-wall results. 
When I first clicked the reconcile button, the dialog that comes up has the 
correct starting balance and the correct proposed to-be-reconciled balance. 
When I click OK to get to the transaction check-off dialog, gnucash has 
completely changed the starting balance to a much smaller number (and one that 
has never appeared in the account ledger) and thus presents an out of balance 
total that cannot be reconciled with the transactions that are in the account.

Dave
--
Dave Reiser
dbrei...@icloud.com





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

Re: [GNC] aqbanking not working for me in 3.9 on mac

[David Reiser via gnucash-user]

Giving Gnucash 3.9 full disk access in System Prefs allows the retrieval to 
work correctly, but does not reenable ofx.log creation.

Dave
--
Dave Reiser
dbrei...@icloud.com





> On Mar 29, 2020, at 11:42 PM, David Reiser via gnucash-user 
>  wrote:
> 
> Gnucash 3.9 on MacOS 10.15.4 is not successfully retrieving  transactions for 
> me.
> 
> I ran a Get Transactions in 3.9 from one of my Chase credit card accounts and 
> got a blank matcher window.
> 
> Quit 3.9
> Launch 3.7, and run the Get Transaction process. One new and one to-be-added 
> transactions are displayed in the matcher window.
> Cancel the import
> Quit 3.7
> Go back to 3.9, verify the transactions aren’t cleared or imported, rerun Get 
> Transactions. Nothing appears in the matcher window.
> 
> And I can’t tell if it’s aqbanking or gnucash.
> I used to be able to add AQOFX_LOG_COMM=1 to 
> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment and have 
> the ofx data stream show up in /tmp/ofx.log.
> That log file isn’t updated from 3.9, even with the environment variable 
> added.
> 
> Dave
> --
> Dave Reiser
> dbrei...@icloud.com
> 
> 
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

[GNC] aqbanking not working for me in 3.9 on mac

[David Reiser via gnucash-user]

Gnucash 3.9 on MacOS 10.15.4 is not successfully retrieving  transactions for 
me.

I ran a Get Transactions in 3.9 from one of my Chase credit card accounts and 
got a blank matcher window.

Quit 3.9
Launch 3.7, and run the Get Transaction process. One new and one to-be-added 
transactions are displayed in the matcher window.
Cancel the import
Quit 3.7
Go back to 3.9, verify the transactions aren’t cleared or imported, rerun Get 
Transactions. Nothing appears in the matcher window.

And I can’t tell if it’s aqbanking or gnucash.
I used to be able to add AQOFX_LOG_COMM=1 to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment and have 
the ofx data stream show up in /tmp/ofx.log.
That log file isn’t updated from 3.9, even with the environment variable added.

Dave
--
Dave Reiser
dbrei...@icloud.com





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

Re: [GNC] Problems importing American Express QFX files into GNUCash

[David Reiser via gnucash-user]

> On Mar 3, 2020, at 4:14 PM, Jonathan Bentz  wrote:
> 
> I'm running GNUCash 3.8 and was manually importing my credit card
> statements yesterday via QFX and when I tried to import a QFX file from
> AMEX, it was blank.  I have successfully imported QFX files from AMEX for a
> few years now and as recently as December of 2019 I have never encountered
> this.
> 
> I download the QFX file to my local Win10 machine, then "import" it into
> GNUCash, and there are no transactions listed.
> 
> Any idea what's going on, or what I could try?  Thanks.

European banking changes forced some changes in aqbanking that adversely 
affected gnucash US ofx/qfx imports.

Try Gnucash version 3.7, or wait for 3.9.

Dave
--
Dave Reiser
dbrei...@icloud.com





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

Re: [GNC] AppleCard OFX file

[David Reiser via gnucash-user]

On Mar 1, 2020, at 12:46 PM, Keith Bellairs  wrote:
> 
> Apple has added ability to export Apple credit card transactions in ofx
> format. When I tried to import their ofx file, ended up with an empty
> transaction matching window in gnucash. I think Apple's sgml ofx data is
> buggy. There is no closing tag   in the header info. I edited
> the ofx and added the tag. After that the gnucash import worked correctly
> in GNC 3.7 on my Mac.
> 
> The corrected set of tags looks like this:
> 
> Apple Card
> 
> 
> So that worked this month.
> 
> Keith


That’s good to know. But notice that the ACCTID isn’t particularly unique. 
Since Apple/GS don’t allow joint accounts, my wife and I both have accounts. 
But both sets of ofx groups have the same ACCTID, meaning I’d have to 
edit/script modify one or both accounts each month before importing the data.

Ofx’s biggest advantage — FITID tags to easily identify duplicates — is 
rendered unimportant by another of Apple’s inflexibilities. Since you can only 
export a whole month at a time and always get the same transactions for a whole 
month, there’s never a chance of getting anything other than 0% or 100% 
duplicates.

Under the current system, I’ve found it easier to import the csv transaction 
data. I have one settings file for my data, and one for my wife’s. And I easily 
end up in the same transaction matcher in nearly the same time as for a 
well-formed ofx file.

Dave
--
Dave Reiser
dbrei...@icloud.com



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