Sorry for the repeat messages, but I decided to test American Express on my setup. I was able to set it up and retrieve transactions, all good. Even found my notes on how to set it up! The below were the settings I had to pay attention to.
User Name: Amex User ID: <loginname> UID: Leave blank QWIN 2500 103 Besides that, just follow the normal steps. Best, Colin On Tue, Oct 20, 2020 at 5:24 PM Colin <colinfar...@gmail.com> wrote: > 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-requ...@gnucash.org> wrote: > >> Send gnucash-user mailing list submissions to >> gnucash-user@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-requ...@gnucash.org >> >> You can reach the person managing the list at >> gnucash-user-ow...@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.pa...@usa.net> >> To: <gnucash-user@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." <sunfis...@yahoo.com> >> To: Kalpesh Patel <kalpesh.pa...@usa.net> >> Cc: Fran_3 via gnucash-user <gnucash-user@gnucash.org> >> Subject: Re: [GNC] Start up with security prices updated during launch >> Message-ID: <fdb5949a-4862-4096-a57f-5f3cadfbb...@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.pa...@usa.net> >> Sent: Mon Oct 19 14:10:56 EDT 2020 >> To: gnucash-user@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@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 <konners...@gmail.com> >> To: Gnucash Users <gnucash-user@gnucash.org> >> 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* >> *konners...@gmail.com <konners...@gmail.com>* >> *781-639-0616* >> >> >> ------------------------------ >> >> Message: 4 >> Date: Mon, 19 Oct 2020 16:52:48 -0400 >> From: "D." <sunfis...@yahoo.com> >> To: Kalpesh Patel <kalpesh.pa...@usa.net> >> Cc: Fran_3 via gnucash-user <gnucash-user@gnucash.org> >> Subject: Re: [GNC] Start up with security prices updated during launch >> Message-ID: <04601c30-06c9-40cd-afc1-5650bd855...@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@gnucash.org> >> Sent: Mon Oct 19 16:44:05 EDT 2020 >> To: Kalpesh Patel <kalpesh.pa...@usa.net> >> Cc: Fran_3 via gnucash-user <gnucash-user@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.pa...@usa.net> >> Sent: Mon Oct 19 14:10:56 EDT 2020 >> To: gnucash-user@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@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. >> >> >> >> ------------------------------ >> >> Message: 5 >> Date: Mon, 19 Oct 2020 16:14:07 -0500 (CDT) >> From: David Cousens <davidcous...@bigpond.com> >> To: gnucash-user@gnucash.org >> Subject: Re: [GNC] CSV import of Credit Card Transaction Data >> Message-ID: <1603142047515-0.p...@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" <dehrt...@daystar.io> >> To: <gnucash-user@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 <dfrank...@gmail.com> >> To: "gnucash-user@gnucash.org" <gnucash-user@gnucash.org> >> Subject: [GNC] AQ Banking OFX Direct Connect >> Message-ID: <5f8df695.1c69fb81.a1447.1...@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 <dbrei...@icloud.com> >> To: Edwin Franks <dfrank...@gmail.com> >> Cc: "gnucash-user@gnucash.org" <gnucash-user@gnucash.org> >> Subject: Re: [GNC] AQ Banking OFX Direct Connect >> Message-ID: <4e69e9a5-b859-4ba1-aa6d-8fbe96e17...@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 >> dbrei...@icloud.com >> >> >> >> >> >> > On Oct 19, 2020, at 4:27 PM, Edwin Franks <dfrank...@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@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 <dbrei...@icloud.com> >> To: Edwin Franks <dfrank...@gmail.com> >> Cc: "gnucash-user@gnucash.org" <gnucash-user@gnucash.org> >> Subject: Re: [GNC] AQ Banking OFX Direct Connect >> Message-ID: <8c25989b-2675-4357-8f53-789ea4de6...@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 >> dbrei...@icloud.com >> >> >> >> >> >> > On Oct 20, 2020, at 8:33 AM, David Reiser via gnucash-user < >> gnucash-user@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 >> > dbrei...@icloud.com >> > >> > >> > >> > >> > >> >> On Oct 19, 2020, at 4:27 PM, Edwin Franks <dfrank...@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@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. >> >> >> >> ------------------------------ >> >> Subject: Digest Footer >> >> _______________________________________________ >> >> 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. >> >> >> ------------------------------ >> >> End of gnucash-user Digest, Vol 211, Issue 38 >> ********************************************* >> > _______________________________________________ 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.
