Re: [GNC-dev] New OFX Requirements For USAA FSB
I attempted to use AqBanking's TRNUID, and something on the far side returned a Java.IO error instead of any useful info. Some experimentation shows it must be a UUID. I ran my experiments with APPVER of 2300 and this worked. The curl command Scott provided works, I think the typo was in his description. -Randy On Mon, Feb 8, 2021, 2:47 AM Martin Preuss wrote: > Hi, > > nicely done!! > > Some notes reagarding AqBanking's OFX Direct Connect plugin: > > Am 07.02.21 um 05:45 schrieb Scott McRae: > [...] > > Some things I've found through trial and error: > > - The OFX elements must be separated with "\r\n". This is dumb, but > true. > > No spaces. No simple "\n". Exactly "\r\n". > [...] > This should already be the case in AqBanking. > > [...] > > - The APPID "QMOFX" and APPVER "QMOFX" work. Others I tried did not. > > - The CLIENTUID "1955A543-B071-455E-A31E-73CC7C493D68" works for me. It > > must be uppercase. This might be particular to your account. If so, you > can > > find it looking at the OFX logs from Quicken. > [...] > > You mean APPVER must also be set to QMOFX? Not a version number? > > [...] > > - TRNUID must be present, but an UUID will do. > [...] > > AqBanking creates an ID derived from the current date (like in > "20210207223800"). Does that also work? > > [...] > > - DTACCTUP: The value "19900101" works. The value "19700101" does not. > The > > value "1990010100" does not. > [...] > > Okay, changed that in AqBanking. > > [...] > > - You need the "Content-Type: application/x-ofx" header > [...] > That's already used in AqBanking. > > [...] > > - You need the User-Agent "InetClntApp/3.0". This is what Quicken for > Mac > > sends. > [...] > > Okay, I added an edit widget to AqBanking's "Edit User" dialog which > allows for the HTTP user agent to be set. > > > Regards > Martin > > > -- > "Things are only impossible until they're not" > ___ > gnucash-devel mailing list > gnucash-devel@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-devel > ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
[GNC-dev] USAA Additional Info
Scott, Thanks for the shout out. I just saw the new thread this morning and I want to confirm that the CLIENTUID is user specific--the one I was given by Quicken differs from the one you mention. I also noticed that APPVER has two values [2300, 2400] in the Quicken logs. I can't decipher when and why it changes. But if "QMOFX" works then it's easier to got with that. I hope to use your recap to try and get valid requests working through the aqbanking-cli app, but not sure how soon I can get to it--got to get to work right now. Regards, Bob ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] USAA
Scott, To expand a bit more on your research, it turns I got myself locked out working via command line (had a typo in my password,) but I got a new response: = HTTP/2 200 date: Mon, 08 Feb 2021 19:21:46 GMT content-type: application/x-ofx content-length: 661 vary: Origin vary: Access-Control-Request-Method vary: Access-Control-Request-Headers x-content-type-options: nosniff x-xss-protection: 1; mode=block cache-control: no-cache, no-store, max-age=0, must-revalidate pragma: no-cache expires: 0 strict-transport-security: max-age=31536000 ; includeSubDomains x-frame-options: DENY set-cookie: visid_incap_2454689=VL3kNBr2SlSW0WJCqhj8bUqPIWAAQUIPAAAItMvflIE03TK597RZBrSG; expires=Tue, 08 Feb 2022 16:54:56 GMT; HttpOnly; path=/; Domain=.1fsapi.com; Secure; SameSite=None set-cookie: nlbi_2454689=GUGEXaoMYhyU6CN+hXBnAwCJYu0m0lufamEaMlpy8lh6; path=/; Domain=.1fsapi.com; Secure; SameSite=None set-cookie: incap_ses_1286_2454689=sP1YdCv3cxxFphfCS8rYEUqPIWAADjWNiSpDNqhTw/8uqYqZkA==; path=/; Domain=.1fsapi.com; Secure; SameSite=None x-cdn: Incapsula x-iinfo: 3-12758011-12758012 CT(8 5 0) RT(1612812105972 0) q(0 0 0 -1) r(1 1) U6 OFXHEADER:100 DATA:OFXSGML VERSION:103 SECURITY:NONE ENCODING:USASCII CHARSET:NONE COMPRESSION:NONE OLDFILEUID:NONE NEWFILEUID:NONE 2000ERRORYou're locked out due to multiple tries, you'll need to verify your information. Get Access ID and PIN here https://df3cx-services.1fsapi.com/casm/usaa/enroll20210208142146.714[-5:EST]ENGUSAA Federal Savings Bank67811096F9A5D-A1A6-4FF7-A75E-222F55F834CFc15500ERROR = I am even getting this response in the Quicken OFX logs at the moment. Followed the link in the MESSAGE above and it just showed me the creds page with the user/passwd I'd preciously setup. I was able to automate some of the changing fields (DTCLIENT and TRNUID) in the request: = echo -en "OFXHEADER:100\r\nDATA:OFXSGML\r\nVERSION:103\r\nSECURITY:NONE\r\nENCODING:USASCII\r\nCHARSET:NONE\r\nCOMPRESSION:NONE\r\nOLDFILEUID:NONE\r\nNEWFILEUID:NONE\r\n\r\n\r\n\r\n\r\n`date +%Y%m%d%H%M%S`\r\n362\r\n66\r\nENG\r\n\r\nUSAA Federal Savings Bank\r\n67811\r\n\r\nQMOFX\r\n2300\r\n-DB64-4AC0-A835-\r\n\r\n\r\n\r\n\r\n`uuidgen | id=_ && echo ${id^^}`c\r\n\r\n19900101\r\n\r\n\r\n\r\n\r\n" | curl -isS -X POST -H "Content-Type: application/x-ofx" -A InetClntApp/3.0 --data-binary @- https://df3cx-services.1fsapi.com/casm/usaa/access.ofx = Not sure how long I will be locked out, but will get back to it when I can. Regards, Bob ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] USAA
You can try unlinking Quicken from your USAA account settings page (under Apps) and then re-activate it? On Mon, Feb 8, 2021 at 11:47 AM Bob White wrote: > Scott, > > To expand a bit more on your research, it turns I got myself locked out > working via command line (had a typo in my password,) but I got a new > response: > > = > HTTP/2 200 > date: Mon, 08 Feb 2021 19:21:46 GMT > content-type: application/x-ofx > content-length: 661 > vary: Origin > vary: Access-Control-Request-Method > vary: Access-Control-Request-Headers > x-content-type-options: nosniff > x-xss-protection: 1; mode=block > cache-control: no-cache, no-store, max-age=0, must-revalidate > pragma: no-cache > expires: 0 > strict-transport-security: max-age=31536000 ; includeSubDomains > x-frame-options: DENY > set-cookie: > visid_incap_2454689=VL3kNBr2SlSW0WJCqhj8bUqPIWAAQUIPAAAItMvflIE03TK597RZBrSG; > expires=Tue, 08 Feb 2022 16:54:56 GMT; HttpOnly; path=/; Domain=. > 1fsapi.com; Secure; SameSite=None > set-cookie: nlbi_2454689=GUGEXaoMYhyU6CN+hXBnAwCJYu0m0lufamEaMlpy8lh6; > path=/; Domain=.1fsapi.com; Secure; SameSite=None > set-cookie: > incap_ses_1286_2454689=sP1YdCv3cxxFphfCS8rYEUqPIWAADjWNiSpDNqhTw/8uqYqZkA==; > path=/; Domain=.1fsapi.com; Secure; SameSite=None > x-cdn: Incapsula > x-iinfo: 3-12758011-12758012 CT(8 5 0) RT(1612812105972 0) q(0 0 0 > -1) r(1 1) U6 > > OFXHEADER:100 > DATA:OFXSGML > VERSION:103 > SECURITY:NONE > ENCODING:USASCII > CHARSET:NONE > COMPRESSION:NONE > OLDFILEUID:NONE > NEWFILEUID:NONE > > 2000ERRORYou're > locked out due to multiple tries, you'll need to verify your information. > Get Access ID and PIN here > https://df3cx-services.1fsapi.com/casm/usaa/enroll20210208142146.714[-5:EST]ENGUSAA > Federal Savings > Bank67811096F9A5D-A1A6-4FF7-A75E-222F55F834CFc15500ERROR > = > > I am even getting this response in the Quicken OFX logs at the moment. > Followed the link in the MESSAGE above and it just showed me the creds page > with the user/passwd I'd preciously setup. > > I was able to automate some of the changing fields (DTCLIENT and TRNUID) > in the request: > > = > echo -en > "OFXHEADER:100\r\nDATA:OFXSGML\r\nVERSION:103\r\nSECURITY:NONE\r\nENCODING:USASCII\r\nCHARSET:NONE\r\nCOMPRESSION:NONE\r\nOLDFILEUID:NONE\r\nNEWFILEUID:NONE\r\n\r\n\r\n\r\n\r\n`date > +%Y%m%d%H%M%S`\r\n362\r\n66\r\nENG\r\n\r\nUSAA > Federal Savings > Bank\r\n67811\r\n\r\nQMOFX\r\n2300\r\n-DB64-4AC0-A835-\r\n\r\n\r\n\r\n\r\n`uuidgen > | id=_ && echo > ${id^^}`c\r\n\r\n19900101\r\n\r\n\r\n\r\n\r\n" > | curl -isS -X POST -H "Content-Type: application/x-ofx" -A InetClntApp/3.0 > --data-binary @- https://df3cx-services.1fsapi.com/casm/usaa/access.ofx > = > > Not sure how long I will be locked out, but will get back to it when I can. > > > Regards, > > Bob > ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
[GNC-dev] GnuCash: Mark tr as external
Hello Benno, as we got no answer from the turkish team in a week, can you mark tr as external? Regards Frank Ellenberger Weitergeleitete Nachricht Betreff: Fwd: [Hosted Weblate] Neuer Sprachvorschlag in GnuCash/Glossary Datum: Sat, 30 Jan 2021 19:46:06 +0100 Von: Frank H. Ellenberger An: Emin Tufan Çetin Kopie (CC): Turkish , gnucash-devel Hello Emin, we got the attached request by Ömer Faruk Çakmak from weblate.org, who wants to contribute. Your last contribution has been 3 years ago. Are you or somebody else from the team still interested to translate gnucash or should we move it to weblate? Regards Frank Ellenberger Weitergeleitete Nachricht Betreff: [Hosted Weblate] Neuer Sprachvorschlag in GnuCash/Glossary Datum: Sat, 30 Jan 2021 17:57:28 - Von: Ömer Faruk Çakmak An: frank.h.ellenber...@gmail.com # Neue gewünschte Sprache [ omerfarukcakmak](https://hosted.weblate.org/user/omerfarukcakmak/ "Ömer Faruk Çakmak"): [Hosted Weblate](https://hosted.weblate.org) / [GnuCash](https://hosted.weblate.org/projects/gnucash/) / [Glossary](https://hosted.weblate.org/projects/gnucash/glossary/) Es gab eine Anfrage von Ömer Faruk Çakmak für eine neue Sprache bei GnuCash/Glossary auf Hosted Weblate. Bitte fügen Sie die Sprachdatei zur Versionsverwaltung hinzu, Weblate wird sie bei der nächsten Aktualisierung automatisch entdecken. [ Weitere Informationen zum Hinzufügen neuer Sprachdateien finden Sie in der Dokumentation. ](https://docs.weblate.org/en/latest/devel/translations.html#adding- translation) ## Gewünschte Sprache Türkisch (tr) [Übersetzungskomponente anzeigen](https://hosted.weblate.org/projects/gnucash/glossary/) ## Komponenteninformation Sprachen| [29](https://hosted.weblate.org/projects/gnucash/glossary/) | |-|-- Alle Zeichenketten | 6.032 | Übersetzte Zeichenketten | 4.918 | 81% Nicht übersetzte Zeichenketten | 582 | 9% Zeichenketten mit Handlungsbedarf | 1.114 | 18% Zur Bearbeitung markierte Zeichenketten | 532 | 8% [Anzeigen](https://hosted.weblate.org/projects/gnucash/glossary/) [Weblate, das freie kontinuierliche Übersetzungssystem.](https://weblate.org/) ▸ [Benachrichtigungseinstellungen](https://hosted.weblate.org/accounts/profile/#notifications) ▸ [Deaktivieren Sie diese Benachrichtigung](https://hosted.weblate.org/accounts/unsubscribe/?i=210598:1l5uUx:g8t2K_wW1m5c-KfDRWkHRK4pFxCoXPTcehVfONrguxc) Generiert um 30. Januar 2021 18:57. ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel