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 <[email protected]> wrote: > Send gnucash-user mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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" <[email protected]> > To: <[email protected]> > Subject: [GNC] Start up with security prices updated during launch > Message-ID: <[email protected]> > 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." <[email protected]> > To: Kalpesh Patel <[email protected]> > Cc: Fran_3 via gnucash-user <[email protected]> > Subject: Re: [GNC] Start up with security prices updated during launch > Message-ID: <[email protected]> > 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 <[email protected]> > Sent: Mon Oct 19 14:10:56 EDT 2020 > To: [email protected] > 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 > [email protected] > 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 <[email protected]> > To: Gnucash Users <[email protected]> > Subject: [GNC] CSV import of Credit Card Transaction Data > Message-ID: > < > caekznucrh1+diautwrcrqaczhmdb9c2znunha3jxgubmxyr...@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* > *[email protected] <[email protected]>* > *781-639-0616* > > > ------------------------------ > > Message: 4 > Date: Mon, 19 Oct 2020 16:52:48 -0400 > From: "D." <[email protected]> > To: Kalpesh Patel <[email protected]> > Cc: Fran_3 via gnucash-user <[email protected]> > Subject: Re: [GNC] Start up with security prices updated during launch > Message-ID: <[email protected]> > 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" <[email protected]> > Sent: Mon Oct 19 16:44:05 EDT 2020 > To: Kalpesh Patel <[email protected]> > Cc: Fran_3 via gnucash-user <[email protected]> > 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 <[email protected]> > Sent: Mon Oct 19 14:10:56 EDT 2020 > To: [email protected] > 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 > [email protected] > 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 > [email protected] > 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 <[email protected]> > To: [email protected] > Subject: Re: [GNC] CSV import of Credit Card Transaction Data > Message-ID: <[email protected]> > 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" <[email protected]> > To: <[email protected]> > Subject: [GNC] Make PDF from reports > Message-ID: <[email protected]> > 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 <[email protected]> > To: "[email protected]" <[email protected]> > Subject: [GNC] AQ Banking OFX Direct Connect > Message-ID: <[email protected]> > 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 <[email protected]> > To: Edwin Franks <[email protected]> > Cc: "[email protected]" <[email protected]> > Subject: Re: [GNC] AQ Banking OFX Direct Connect > Message-ID: <[email protected]> > 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 > [email protected] > > > > > > > On Oct 19, 2020, at 4:27 PM, Edwin Franks <[email protected]> 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 > > [email protected] > > 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 <[email protected]> > To: Edwin Franks <[email protected]> > Cc: "[email protected]" <[email protected]> > Subject: Re: [GNC] AQ Banking OFX Direct Connect > Message-ID: <[email protected]> > 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 > [email protected] > > > > > > > On Oct 20, 2020, at 8:33 AM, David Reiser via gnucash-user < > [email protected]> 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 > > [email protected] > > > > > > > > > > > >> On Oct 19, 2020, at 4:27 PM, Edwin Franks <[email protected]> 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 > >> [email protected] > >> 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 > > [email protected] > > 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 > [email protected] > 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 > ********************************************* > _______________________________________________ gnucash-user mailing list [email protected] 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.
