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

Colin colinfarndt at gmail.com
Tue Oct 20 11:36:27 EDT 2020 

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 <colinfarndt at 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-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