[GNC] gnucash-user Digest, Vol 211, Issue 38

Colin colinfarndt at gmail.com
Tue Oct 20 11:24:37 EDT 2020


Hi David,

The GnuCash wiki has a section for getting OFX online banking to work, with
sections for different cards.

I have a Citi credit card and had to modify the settings substantially to
get it to work. The server changed from what is listed in the AQBanking
database, unfortunately the maintainer doesn't seem to make it possible to
update this information any longer.

Regardless, I updated the entry in the GnuCash wiki to give exact
instructions on what needs to be changed:
https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#Citi_Credit_Card

I also have an American Express card, though don't currently use online
banking with it. If memory serves, I was able to get it working when I
initially set up GnuCash a few months ago. I'm sorry I can't recall any
specific changes I had to make, only that I had it working at one point!

Best,
Colin

On Tue, Oct 20, 2020 at 2:41 PM <gnucash-user-request at gnucash.org> wrote:

> Send gnucash-user mailing list submissions to
>         gnucash-user at gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
>         gnucash-user-request at gnucash.org
>
> You can reach the person managing the list at
>         gnucash-user-owner at gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
>    1.  Start up with security prices updated during launch
>       (Kalpesh Patel)
>    2. Re:  Start up with security prices updated during launch (D.)
>    3.  CSV import of Credit Card Transaction Data (Paul Konnersman)
>    4. Re:  Start up with security prices updated during launch (D.)
>    5. Re:  CSV import of Credit Card Transaction Data (David Cousens)
>    6.  Make PDF from reports (Derek Zehr)
>    7.  AQ Banking OFX Direct Connect (Edwin Franks)
>    8. Re:  AQ Banking OFX Direct Connect (David Reiser)
>    9. Re:  AQ Banking OFX Direct Connect (David Reiser)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 19 Oct 2020 14:10:56 -0400
> From: "Kalpesh Patel" <kalpesh.patel at usa.net>
> To: <gnucash-user at gnucash.org>
> Subject: [GNC] Start up with security prices updated during launch
> Message-ID: <002e01d6a643$314cba60$93e62f20$@usa.net>
> Content-Type: text/plain;       charset="us-ascii"
>
> Hi GNUCash User group -
>
>
>
> Is there a way to launch GNUCash in Windows 10 such that it also updated
> security prices from online sources for securities that are configured
> before displaying the scheduled transactions? I am using version 4.2 on
> Windows at the moment.
>
>
>
> I don't believe it's:
>
>
>
> gnucash-cli.exe --quotes get file://C:/path/to/file.gnucash
>
>
>
>
>
> Thanks.
>
>
>
>
>
>
>
>
>
> ------------------------------
>
> Message: 2
> Date: Mon, 19 Oct 2020 16:44:05 -0400
> From: "D." <sunfish62 at yahoo.com>
> To: Kalpesh Patel <kalpesh.patel at usa.net>
> Cc: Fran_3 via gnucash-user <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Start up with security prices updated during launch
> Message-ID: <fdb5949a-4862-4096-a57f-5f3cadfbb582 at yahoo.com>
> Content-Type: text/plain; charset=UTF-8
>
> Not really. See
> https://lists.gnucash.org/pipermail/gnucash-user/2017-March/069738.html
> for a recent discussion, and
> https://bugs.gnucash.org/show_bug.cgi?id=628734 for an older one.
>
> You can get behavior like this by writing a simple batch file that updates
> process before opening your data file in the GUI.
>
> David T
>
>
> -------- Original Message --------
> From: Kalpesh Patel <kalpesh.patel at usa.net>
> Sent: Mon Oct 19 14:10:56 EDT 2020
> To: gnucash-user at gnucash.org
> Subject: [GNC] Start up with security prices updated during launch
>
> Hi GNUCash User group -
>
>
>
> Is there a way to launch GNUCash in Windows 10 such that it also updated
> security prices from online sources for securities that are configured
> before displaying the scheduled transactions? I am using version 4.2 on
> Windows at the moment.
>
>
>
> I don't believe it's:
>
>
>
> gnucash-cli.exe --quotes get file://C:/path/to/file.gnucash
>
>
>
>
>
> Thanks.
>
>
>
>
>
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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: 3
> Date: Mon, 19 Oct 2020 16:52:07 -0400
> From: Paul Konnersman <konnersman at gmail.com>
> To: Gnucash Users <gnucash-user at gnucash.org>
> Subject: [GNC] CSV import of Credit Card Transaction Data
> Message-ID:
>         <
> CAEkznucrH1+diauTwrcrQaczhMdb9C2zNUnHa3JxgUBmXYRU8Q at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> MacOS Version Catalina 10.15.7 (19H2) and   GnuCash Version: 4.2 Build ID:
> 4.2+(2020-09-26)
>
>
> I?m attempting to import a CSV Credit Card transaction file. In the import
> Preview window I have the following fields mapped to the import data:
> ?Date,? Num,? ?Description,? ?Memo,? but there seems to be *no appropriate
> mapping for the fields that I might call ?Debit/Credit,? and ?Amount.?*
>
>
> I don?t see a need for Debit/Credit since that can be handled with the
> minus sign on amount. But certainly, I need ?Amount.? But I can?t find any
> reference to it in the docs. What have I missed?
>
>
> Paul
>
> --
> *Paul M. Konnersman*
> *konnersman at gmail.com <konnersman at gmail.com>*
> *781-639-0616*
>
>
> ------------------------------
>
> Message: 4
> Date: Mon, 19 Oct 2020 16:52:48 -0400
> From: "D." <sunfish62 at yahoo.com>
> To: Kalpesh Patel <kalpesh.patel at usa.net>
> Cc: Fran_3 via gnucash-user <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Start up with security prices updated during launch
> Message-ID: <04601c30-06c9-40cd-afc1-5650bd85542b at yahoo.com>
> Content-Type: text/plain; charset=UTF-8
>
> Further to your last statement, the syntax should I believe be:
>
> gnucash-cli.exe --add-price-quotes=<myfile>
>
> But I haven't used this feature in a long time, myself.
>
>
> -------- Original Message --------
> From: "D. via gnucash-user" <gnucash-user at gnucash.org>
> Sent: Mon Oct 19 16:44:05 EDT 2020
> To: Kalpesh Patel <kalpesh.patel at usa.net>
> Cc: Fran_3 via gnucash-user <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Start up with security prices updated during launch
>
> Not really. See
> https://lists.gnucash.org/pipermail/gnucash-user/2017-March/069738.html
> for a recent discussion, and
> https://bugs.gnucash.org/show_bug.cgi?id=628734 for an older one.
>
> You can get behavior like this by writing a simple batch file that updates
> process before opening your data file in the GUI.
>
> David T
>
>
> -------- Original Message --------
> From: Kalpesh Patel <kalpesh.patel at usa.net>
> Sent: Mon Oct 19 14:10:56 EDT 2020
> To: gnucash-user at gnucash.org
> Subject: [GNC] Start up with security prices updated during launch
>
> Hi GNUCash User group -
>
>
>
> Is there a way to launch GNUCash in Windows 10 such that it also updated
> security prices from online sources for securities that are configured
> before displaying the scheduled transactions? I am using version 4.2 on
> Windows at the moment.
>
>
>
> I don't believe it's:
>
>
>
> gnucash-cli.exe --quotes get file://C:/path/to/file.gnucash
>
>
>
>
>
> Thanks.
>
>
>
>
>
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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 at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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: 5
> Date: Mon, 19 Oct 2020 16:14:07 -0500 (CDT)
> From: David Cousens <davidcousens at bigpond.com>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] CSV import of Credit Card Transaction Data
> Message-ID: <1603142047515-0.post at n4.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> Paul,
>
> The headings should include a columns for  Deposit  and Withdrawal. If you
> have a single column of signed data one of these should work. You may have
> to experiment to get the right header for your bank's data. From memory I
> used the Deposit header on a bank account CSV import.
>
> The importer has different headers to cope with banks proclivity not to
> stick with any particular standard way of presenting CSV data. Some have
> separate columns for deposits and Withdrawals, some use a single unsigned
> column with another column which has Debit/Credit entries. GnuCash has to
> be
> able to cope with all of these variations.
>
> David Cousens
>
>
>
> -----
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>
>
> ------------------------------
>
> Message: 6
> Date: Mon, 19 Oct 2020 20:05:56 -0400
> From: "Derek Zehr" <dehrtobe at daystar.io>
> To: <gnucash-user at gnucash.org>
> Subject: [GNC] Make PDF from reports
> Message-ID: <012201d6a674$c8d4e160$5a7ea420$@daystar.io>
> Content-Type: text/plain; charset="us-ascii"
>
> Hello,
>
>
>
> I just created my first-ever report in GnuCash, to report some finances
> with
> a forum I'm involved with. This is the window I get when I hit Make PDF,
> and
> specify a valid file name in my documents folder. GnuCash Version: 4.1
> Build
> ID: 4.1+(2020-07-25) on Windows 7.
>
>
>
> Hope it something simple. Not sure what to do to resolve something like
> this.
>
>
>
> Thanks,
>
>
>
> Derek Zehr
>
>
>
>
>
>
>
>
>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image001.png
> Type: image/png
> Size: 6676 bytes
> Desc: not available
> URL: <
> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20201019/84059c35/attachment-0001.png
> >
>
> ------------------------------
>
> Message: 7
> Date: Mon, 19 Oct 2020 15:27:01 -0500
> From: Edwin Franks <dfrankssr at gmail.com>
> To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: [GNC] AQ Banking OFX Direct Connect
> Message-ID: <5f8df695.1c69fb81.a1447.17bd at mx.google.com>
> Content-Type: text/plain; charset="utf-8"
>
> 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
>
> <OFX>
> <SIGNONMSGSRQV1>
> <SONRQ>
> <DTCLIENT>20201019194201.000
> <USERID>XXXXXXXX
> <USERPASS>XXXXXXXXXXXX
> <LANGUAGE>ENG
> <FI>
> <ORG>AMEX
> <FID>3101
> </FI>
> <APPID>QWIN
> <APPVER>2200
> </SONRQ>
> </SIGNONMSGSRQV1>
> <CREDITCARDMSGSRQV1>
> <CCSTMTTRNRQ>
> <TRNUID>20201019194220.000
> <CLTCOOKIE>1
> <CCSTMTRQ>
> <CCACCTFROM>
> <ACCTID>XXXXXXXXXXXXXXXX
> </CCACCTFROM>
> <INCTRAN>
> <DTSTART>20201014000000.000
> <DTEND>20201019000000.000
> <INCLUDE>Y
> </INCTRAN>
> </CCSTMTRQ>
> </CCSTMTTRNRQ>
> </CREDITCARDMSGSRQV1>
> </OFX>
>
>
> Received:
> -------------------------------------
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:102
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:20201019194220.000
>
> <OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>Login
> successful</STATUS><DTSERVER>20201019124220.670[-7:MST]<LANGUAGE>ENG<FI><ORG>AMEX<FID>3101</FI><
> ORIGIN.ID
> >FMPWeb<CUSTOMER.TYPE>BCM<START.TIME>20201019124220</SONRS></SIGNONMSGSRSV1><CREDITCARDMSGSRSV1><CCSTMTTRNRS><TRNUID>20201019194220.000<STATUS><CODE>2003<SEVERITY>ERROR</STATUS><CLTCOOKIE>1</CCSTMTTRNRS></CREDITCARDMSGSRSV1></OFX>
>
> 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
>
> <OFX>
> <SIGNONMSGSRQV1>
> <SONRQ>
> <DTCLIENT>20201019150941.000
> <USERID>XXXXXXXX
> <USERPASS>XXXXXXXXXXXX
> <LANGUAGE>ENG
> <FI>
> <ORG>Citigroup
> <FID>24909
> </FI>
> <APPID>QWIN
> <APPVER>2200
> <CLIENTUID>
> </SONRQ>
> </SIGNONMSGSRQV1>
> <CREDITCARDMSGSRQV1>
> <CCSTMTTRNRQ>
> <TRNUID>20201019151026.000
> <CLTCOOKIE>1
> <CCSTMTRQ>
> <CCACCTFROM>
> <ACCTID>XXXXXXXXXXXXXXXX
> </CCACCTFROM>
> <INCTRAN>
> <DTSTART>20201010000000.000
> <DTEND>20201019000000.000
> <INCLUDE>Y
> </INCTRAN>
> </CCSTMTRQ>
> </CCSTMTTRNRQ>
> </CREDITCARDMSGSRQV1>
> </OFX>
>
> Thank you for any help you might give me.
>
> Dale Franks
>
> Sent from Mail for Windows 10
>
>
>
> ------------------------------
>
> Message: 8
> Date: Tue, 20 Oct 2020 08:33:02 -0400
> From: David Reiser <dbreiser at icloud.com>
> To: Edwin Franks <dfrankssr at gmail.com>
> Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: Re: [GNC] AQ Banking OFX Direct Connect
> Message-ID: <4E69E9A5-B859-4BA1-AA6D-8FBE96E17CD0 at icloud.com>
> Content-Type: text/plain;       charset=utf-8
>
> <APPVER>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
> dbreiser at icloud.com
>
>
>
>
>
> > On Oct 19, 2020, at 4:27 PM, Edwin Franks <dfrankssr at gmail.com> 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
> >
> > <OFX>
> > <SIGNONMSGSRQV1>
> > <SONRQ>
> > <DTCLIENT>20201019194201.000
> > <USERID>XXXXXXXX
> > <USERPASS>XXXXXXXXXXXX
> > <LANGUAGE>ENG
> > <FI>
> > <ORG>AMEX
> > <FID>3101
> > </FI>
> > <APPID>QWIN
> > <APPVER>2200
> > </SONRQ>
> > </SIGNONMSGSRQV1>
> > <CREDITCARDMSGSRQV1>
> > <CCSTMTTRNRQ>
> > <TRNUID>20201019194220.000
> > <CLTCOOKIE>1
> > <CCSTMTRQ>
> > <CCACCTFROM>
> > <ACCTID>XXXXXXXXXXXXXXXX
> > </CCACCTFROM>
> > <INCTRAN>
> > <DTSTART>20201014000000.000
> > <DTEND>20201019000000.000
> > <INCLUDE>Y
> > </INCTRAN>
> > </CCSTMTRQ>
> > </CCSTMTTRNRQ>
> > </CREDITCARDMSGSRQV1>
> > </OFX>
> >
> >
> > Received:
> > -------------------------------------
> > OFXHEADER:100
> > DATA:OFXSGML
> > VERSION:102
> > SECURITY:NONE
> > ENCODING:USASCII
> > CHARSET:1252
> > COMPRESSION:NONE
> > OLDFILEUID:NONE
> > NEWFILEUID:20201019194220.000
> >
> > <OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>Login
> successful</STATUS><DTSERVER>20201019124220.670[-7:MST]<LANGUAGE>ENG<FI><ORG>AMEX<FID>3101</FI><
> ORIGIN.ID
> >FMPWeb<CUSTOMER.TYPE>BCM<START.TIME>20201019124220</SONRS></SIGNONMSGSRSV1><CREDITCARDMSGSRSV1><CCSTMTTRNRS><TRNUID>20201019194220.000<STATUS><CODE>2003<SEVERITY>ERROR</STATUS><CLTCOOKIE>1</CCSTMTTRNRS></CREDITCARDMSGSRSV1></OFX>
> >
> > 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
> >
> > <OFX>
> > <SIGNONMSGSRQV1>
> > <SONRQ>
> > <DTCLIENT>20201019150941.000
> > <USERID>XXXXXXXX
> > <USERPASS>XXXXXXXXXXXX
> > <LANGUAGE>ENG
> > <FI>
> > <ORG>Citigroup
> > <FID>24909
> > </FI>
> > <APPID>QWIN
> > <APPVER>2200
> > <CLIENTUID>
> > </SONRQ>
> > </SIGNONMSGSRQV1>
> > <CREDITCARDMSGSRQV1>
> > <CCSTMTTRNRQ>
> > <TRNUID>20201019151026.000
> > <CLTCOOKIE>1
> > <CCSTMTRQ>
> > <CCACCTFROM>
> > <ACCTID>XXXXXXXXXXXXXXXX
> > </CCACCTFROM>
> > <INCTRAN>
> > <DTSTART>20201010000000.000
> > <DTEND>20201019000000.000
> > <INCLUDE>Y
> > </INCTRAN>
> > </CCSTMTRQ>
> > </CCSTMTTRNRQ>
> > </CREDITCARDMSGSRQV1>
> > </OFX>
> >
> > Thank you for any help you might give me.
> >
> > Dale Franks
> >
> > Sent from Mail for Windows 10
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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: 9
> Date: Tue, 20 Oct 2020 08:35:10 -0400
> From: David Reiser <dbreiser at icloud.com>
> To: Edwin Franks <dfrankssr at gmail.com>
> Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: Re: [GNC] AQ Banking OFX Direct Connect
> Message-ID: <8C25989B-2675-4357-8F53-789EA4DE6927 at icloud.com>
> Content-Type: text/plain;       charset=utf-8
>
> 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
> dbreiser at icloud.com
>
>
>
>
>
> > On Oct 20, 2020, at 8:33 AM, David Reiser via gnucash-user <
> gnucash-user at gnucash.org> wrote:
> >
> > <APPVER>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
> > dbreiser at icloud.com
> >
> >
> >
> >
> >
> >> On Oct 19, 2020, at 4:27 PM, Edwin Franks <dfrankssr at gmail.com> 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
> >>
> >> <OFX>
> >> <SIGNONMSGSRQV1>
> >> <SONRQ>
> >> <DTCLIENT>20201019194201.000
> >> <USERID>XXXXXXXX
> >> <USERPASS>XXXXXXXXXXXX
> >> <LANGUAGE>ENG
> >> <FI>
> >> <ORG>AMEX
> >> <FID>3101
> >> </FI>
> >> <APPID>QWIN
> >> <APPVER>2200
> >> </SONRQ>
> >> </SIGNONMSGSRQV1>
> >> <CREDITCARDMSGSRQV1>
> >> <CCSTMTTRNRQ>
> >> <TRNUID>20201019194220.000
> >> <CLTCOOKIE>1
> >> <CCSTMTRQ>
> >> <CCACCTFROM>
> >> <ACCTID>XXXXXXXXXXXXXXXX
> >> </CCACCTFROM>
> >> <INCTRAN>
> >> <DTSTART>20201014000000.000
> >> <DTEND>20201019000000.000
> >> <INCLUDE>Y
> >> </INCTRAN>
> >> </CCSTMTRQ>
> >> </CCSTMTTRNRQ>
> >> </CREDITCARDMSGSRQV1>
> >> </OFX>
> >>
> >>
> >> Received:
> >> -------------------------------------
> >> OFXHEADER:100
> >> DATA:OFXSGML
> >> VERSION:102
> >> SECURITY:NONE
> >> ENCODING:USASCII
> >> CHARSET:1252
> >> COMPRESSION:NONE
> >> OLDFILEUID:NONE
> >> NEWFILEUID:20201019194220.000
> >>
> >> <OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>Login
> successful</STATUS><DTSERVER>20201019124220.670[-7:MST]<LANGUAGE>ENG<FI><ORG>AMEX<FID>3101</FI><
> ORIGIN.ID
> >FMPWeb<CUSTOMER.TYPE>BCM<START.TIME>20201019124220</SONRS></SIGNONMSGSRSV1><CREDITCARDMSGSRSV1><CCSTMTTRNRS><TRNUID>20201019194220.000<STATUS><CODE>2003<SEVERITY>ERROR</STATUS><CLTCOOKIE>1</CCSTMTTRNRS></CREDITCARDMSGSRSV1></OFX>
> >>
> >> 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
> >>
> >> <OFX>
> >> <SIGNONMSGSRQV1>
> >> <SONRQ>
> >> <DTCLIENT>20201019150941.000
> >> <USERID>XXXXXXXX
> >> <USERPASS>XXXXXXXXXXXX
> >> <LANGUAGE>ENG
> >> <FI>
> >> <ORG>Citigroup
> >> <FID>24909
> >> </FI>
> >> <APPID>QWIN
> >> <APPVER>2200
> >> <CLIENTUID>
> >> </SONRQ>
> >> </SIGNONMSGSRQV1>
> >> <CREDITCARDMSGSRQV1>
> >> <CCSTMTTRNRQ>
> >> <TRNUID>20201019151026.000
> >> <CLTCOOKIE>1
> >> <CCSTMTRQ>
> >> <CCACCTFROM>
> >> <ACCTID>XXXXXXXXXXXXXXXX
> >> </CCACCTFROM>
> >> <INCTRAN>
> >> <DTSTART>20201010000000.000
> >> <DTEND>20201019000000.000
> >> <INCLUDE>Y
> >> </INCTRAN>
> >> </CCSTMTRQ>
> >> </CCSTMTTRNRQ>
> >> </CREDITCARDMSGSRQV1>
> >> </OFX>
> >>
> >> Thank you for any help you might give me.
> >>
> >> Dale Franks
> >>
> >> Sent from Mail for Windows 10
> >>
> >> _______________________________________________
> >> gnucash-user mailing list
> >> gnucash-user at gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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 at gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
>
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
> ------------------------------
>
> End of gnucash-user Digest, Vol 211, Issue 38
> *********************************************
>


More information about the gnucash-user mailing list