[GNC] aqbanking date offset in GnuCash

[John Vermeer]

When I import from my Credit Union to GnuCash using AqBanking there seems to be 
a date offset. I suspect this may be due to UTC vs Local Time. When I import, I 
do not see the the current transactions unless I set the "To" date in the "Get 
Transaction Online" dialog to 'tomorrow'.

So, I currently have to manually change that date before importing ever time.

Is there a setting that would make this happen automatically when I do the 
aqbanking import?

Thanks for any insights.

John


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Aqbanking

[David Reiser via gnucash-user]

I urge you not to try. But if you log into your bank and look for information 
on Quicken compatibility and it specifically says “QFX DirectConnect”, you have 
a chance. It may still be a challenge to find the connection information 
because Quicken and the bank don’t tell their tech support anything about it. 
For Quicken users, all that info is hidden inside Quicken. Banks will NEVER 
know anything about GnuCash, so it’s a bad idea to even mention it.

If your bank says it’s compatible with Express Web Connect (EWC) or Express Web 
Connect Plus (EWC+), then you are most likely out of luck.

Banks are abandoning DirectConnect almost as fast as they can. They’ve never 
liked it — first because in the early days Intuit had too much control of the 
standard and charged a _lot_ for their turnkey compatible software on the 
bank’s side, and now because its security features are not great.

The new 800-pound gorilla in finance data handling is FDX (presumably from 
Financial Data Exchange). FDX is an industry (i.e., banking industry) 
consortium focused on creating and maintaining standardized methods for 
financial data interchange among business partners. The OFX Group has become 
part of FDX. The intent of the combined group is to migrate everyone away from 
the OFX realm. The banking industry moves pretty slowly, so there will be a few 
stragglers offering DirectConnect for a few years.

The FDX API depends on software interacting with data aggregators (companies 
like Plaid) between consumer and bank. The complexity and cost of establishing 
credentials as an aggregator or even with an aggregation partner make it 
unlikely that open source software will ever be able to do direct retrieval of 
bank data again in the future.

Plan on downloading data from within your bank’s website, and then importing it 
into gnucash.

--
Dave Reiser
dbrei...@icloud.com





> On Apr 20, 2024, at 12:18, Dennis Powless  wrote:
> 
> How do I determine if my bank participates or offers ofx direct connect, 
> aqbanking?
> 
> Dennis

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Aqbanking

[john]

> On Apr 20, 2024, at 09:18, Dennis Powless  wrote:
> 
> How do I determine if my bank participates or offers ofx direct connect, 
> aqbanking?

You can see if they have an entry at https://ofxhome.com 
, but that's crowdsourced so it isn't authoritative. For 
that you have to check with the bank. Ask about or look for on the bank's webs 
Quciken support and look for the terms "Direct Connect" and "Web Connect". 
GnuCash/AQBanking support only the former, and only if you can set up 
authentication in a way that AQBanking can work with. If your bank isn't 
reported in OFXHome.com  then you'll have to figure out 
the other OFX parameters like emulated Quicken version and OFX standard version 
on your own.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Aqbanking

[Dennis Powless]

How do I determine if my bank participates or offers ofx direct connect, 
aqbanking?

Dennis
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Aqbanking

[Gyle McCollam]

I am using the new 5.6 Gnucash on Win11, and aqbanking does not show under the 
"Tools" menu.  I see no way to set it up using Windows.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Aqbanking not included with gnucash for windows??

[barry milliken]

Just downloaded gnucash for windows.
Help says click Tools>Online Banking Setup... while in a register.
That took doesn't appear.

What do I do next?


Barry Milliken

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] AqBanking and Direct Connections

[Mike Stillingfleet]

Hi Everyone,

I want to explore an OFX Direct Connection to my bank(s).

Currently I down load to OFX and then import. But I would prefer to have a real 
time update.

Please can I get some feed back:

1. Have you successfully connected to a UK bank were there any issues?
2. Has anyone had any security issues with AqBanking do banks approve of 
AqBanking.

Regards

Mike

-- 
  Mike Stillingfleet
  mikestillingfl...@fastmail.co.uk
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] AqBanking Online Set Up

[Jesse MacDougall]

YAS! General Journal Register ftw! woot!  Even imported five bank
accounts.  Okay so now I manually click the amounts to correct account.
Sweet! Wish I was using GNU Cash Years ago.

On Tue, Jan 4, 2022 at 1:28 PM John Ralls  wrote:

> Yup, 10 months:
>  2021030112[-8]
>  2021123112[-8]
>
> Are you sure that GnuCash imported only December's transactions? Did you
> change the filter on the General Journal register or look in the account's
> register?
>
> Regards,
> John Ralls
>
> > On Jan 4, 2022, at 12:54 PM, Jesse MacDougall <
> macdougall.je...@gmail.com> wrote:
> >
> > Okay found out Royal Bank only saves transactions upto 120 days for
> OFX.  Nnesense. 365 days is what an Auditor wants.  The file I downloaded
> only had one month once I imported the OFX.  This conflicts with what Royal
> Bank has said so far.  So I called Royal Bank back and everything is fine
> on their end.
> >
> > I then looked at the OFX file in text editor and saw it has
> March-December so the problem is with the format of the OFX file relative
> to GnuCash.  Headers...
> >
> > I've attached the transactions for the Use Case in the email.
> >
> > Any ideas on next steps?
> >
> >
> >
> > On Tue, Jan 4, 2022 at 10:51 AM Jesse MacDougall <
> macdougall.je...@gmail.com> wrote:
> > The import went smooth.  Alot eaier then a .csv and other softwares I've
> used in my career.  QFX is what I got but Royal Bank only included December
> transactions in the file when I chose the entire year.
> >
> > So this is great.  Can download one file a month and post each
> transaction to proper account usually expense.
> >
> > So now I have to get other information so that gnucash will automate the
> downloading and importing process?  Is this possible? I dunno, I think
> so...Sometimes I think technology is supposed to do something but it
> doesn't 
> >
> > On Tue, Jan 4, 2022 at 10:13 AM john  wrote:
> >
> https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-ofx
> >
> > At the end of the QFX import you were presented with a window listing
> all of the imported new transactions. Since this is a first import they
> should all have had a yellow background. You can either double-click each
> one or select one or more and right click then select "assign account" from
> the context menu. That will bring up a window with your account tree from
> which you can select the "other" account for the selected transactions.
> When you do this GnuCash records information from the transaction's
> description and will use it to suggest an account for future transactions
> with similar descriptions; those will have a green background as will
> transactions after you've assigned an account to them.
> >
> > If you skipped that step you'll find al of your transactions assigned to
> Imbalance-CAD and you'll need to re-assign them in the register. That
> doesn't train the import matcher.
> >
> > The General Ledger by default filters to the last 30 days. You can
> change that with View>Filter By.
> >
> > Regards,
> > John Ralls
> >
> >
> >> On Jan 3, 2022, at 11:38 PM, Jesse MacDougall <
> macdougall.je...@gmail.com> wrote:
> >>
> >> I was able to download in QFX format.  I did the import.  How do I
> assign the transactions to the accounts now? I see some of the transactions
> are posted in GL but I do not see the entire year of transactions.  Just
> December.
> >>
> >> On Mon, Jan 3, 2022 at 9:28 PM john  wrote:
> >> Not necessarily. You just need to see if Quicken knows how to connect
> to RBC and if so whether they authenticate with DirectConnect (which
> AQBanking can handle), Express WebConect, or WebConnect (both of which it
> can't).
> >>
> >> It just as possible that what that page is really talking about is
> downloading files; you can figure that out by logging in to your RBC web
> account and looking for a download link. GnuCash can handle OFX, QFX, and
> QIF but not QBO. It's also able to handle CSV though that may take a bit of
> tweaking and in some cases some preprocessing of the CSV.
> >>
> >> Regards,
> >> John Ralls
> >>
> >>
> >>
> >>
> >>> On Jan 3, 2022, at 9:17 PM, Jesse MacDougall <
> macdougall.je...@gmail.com> wrote:
> >>>
> >>> Merci, that eliminates two of the options.  I see a forum to a missing
> institution and connections
> http://www.ofxhome.com/ofxforum//viewforum.php?id=3.  I see someone two
> years ask about Canadian Banks.  No response
> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49825
> >>>
> >>> Here someone says TD Bank Canada is not listed but USA is =(
> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49482
> >>>
> >>> A Quicken friend who uses Royal Bank as well?
> >>>
> >>>
> >>>
> >>> On Mon, Jan 3, 2022 at 8:26 PM john  wrote:
> >>> Nope. HBCI (now called FinTS) works *only* with *German* Banks. The
> Royal Bank of *Canada* is absolutely not a German bank and isn't likely to
> support HBCI.
> >>> EBICS is also German only.
> >>>
> >>>
> 

Re: [GNC] AqBanking Online Set Up

[John Ralls]

Yup, 10 months:
 2021030112[-8]
 2021123112[-8]

Are you sure that GnuCash imported only December's transactions? Did you change 
the filter on the General Journal register or look in the account's register?

Regards,
John Ralls

> On Jan 4, 2022, at 12:54 PM, Jesse MacDougall  
> wrote:
> 
> Okay found out Royal Bank only saves transactions upto 120 days for OFX.  
> Nnesense. 365 days is what an Auditor wants.  The file I downloaded only had 
> one month once I imported the OFX.  This conflicts with what Royal Bank has 
> said so far.  So I called Royal Bank back and everything is fine on their 
> end.  
> 
> I then looked at the OFX file in text editor and saw it has March-December so 
> the problem is with the format of the OFX file relative to GnuCash.  
> Headers...
> 
> I've attached the transactions for the Use Case in the email.  
> 
> Any ideas on next steps?
> 
> 
> 
> On Tue, Jan 4, 2022 at 10:51 AM Jesse MacDougall  
> wrote:
> The import went smooth.  Alot eaier then a .csv and other softwares I've used 
> in my career.  QFX is what I got but Royal Bank only included December 
> transactions in the file when I chose the entire year.
> 
> So this is great.  Can download one file a month and post each transaction to 
> proper account usually expense.  
> 
> So now I have to get other information so that gnucash will automate the 
> downloading and importing process?  Is this possible? I dunno, I think 
> so...Sometimes I think technology is supposed to do something but it doesn't 
> 
> 
> On Tue, Jan 4, 2022 at 10:13 AM john  wrote:
> https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-ofx
> 
> At the end of the QFX import you were presented with a window listing all of 
> the imported new transactions. Since this is a first import they should all 
> have had a yellow background. You can either double-click each one or select 
> one or more and right click then select "assign account" from the context 
> menu. That will bring up a window with your account tree from which you can 
> select the "other" account for the selected transactions. When you do this 
> GnuCash records information from the transaction's description and will use 
> it to suggest an account for future transactions with similar descriptions; 
> those will have a green background as will transactions after you've assigned 
> an account to them.
> 
> If you skipped that step you'll find al of your transactions assigned to 
> Imbalance-CAD and you'll need to re-assign them in the register. That doesn't 
> train the import matcher.
> 
> The General Ledger by default filters to the last 30 days. You can change 
> that with View>Filter By.
> 
> Regards,
> John Ralls
> 
> 
>> On Jan 3, 2022, at 11:38 PM, Jesse MacDougall  
>> wrote:
>> 
>> I was able to download in QFX format.  I did the import.  How do I assign 
>> the transactions to the accounts now? I see some of the transactions are 
>> posted in GL but I do not see the entire year of transactions.  Just 
>> December.
>> 
>> On Mon, Jan 3, 2022 at 9:28 PM john  wrote:
>> Not necessarily. You just need to see if Quicken knows how to connect to RBC 
>> and if so whether they authenticate with DirectConnect (which AQBanking can 
>> handle), Express WebConect, or WebConnect (both of which it can't).
>> 
>> It just as possible that what that page is really talking about is 
>> downloading files; you can figure that out by logging in to your RBC web 
>> account and looking for a download link. GnuCash can handle OFX, QFX, and 
>> QIF but not QBO. It's also able to handle CSV though that may take a bit of 
>> tweaking and in some cases some preprocessing of the CSV.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> 
>> 
>>> On Jan 3, 2022, at 9:17 PM, Jesse MacDougall  
>>> wrote:
>>> 
>>> Merci, that eliminates two of the options.  I see a forum to a missing 
>>> institution and connections 
>>> http://www.ofxhome.com/ofxforum//viewforum.php?id=3.  I see someone two 
>>> years ask about Canadian Banks.  No response 
>>> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49825 
>>> 
>>> Here someone says TD Bank Canada is not listed but USA is =( 
>>> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49482
>>> 
>>> A Quicken friend who uses Royal Bank as well? 
>>> 
>>> 
>>> 
>>> On Mon, Jan 3, 2022 at 8:26 PM john  wrote:
>>> Nope. HBCI (now called FinTS) works *only* with *German* Banks. The Royal 
>>> Bank of *Canada* is absolutely not a German bank and isn't likely to 
>>> support HBCI.
>>> EBICS is also German only.
>>> 
>>> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html
>>>  
>>> 
>>>  suggests that RBC might support OFX Direct Connect based on the list of 
>>> software they claim to support, but they're not listed in 
>>> https://www.ofxhome.com/  so you'd have to find 
>>> the 

Re: [GNC] AqBanking Online Set Up

[Jesse MacDougall]

The import went smooth.  Alot eaier then a .csv and other softwares I've
used in my career.  QFX is what I got but Royal Bank only included December
transactions in the file when I chose the entire year.

So this is great.  Can download one file a month and post each transaction
to proper account usually expense.

So now I have to get other information so that gnucash will automate the
downloading and importing process?  Is this possible? I dunno, I think
so...Sometimes I think technology is supposed to do something but it
doesn't 

On Tue, Jan 4, 2022 at 10:13 AM john  wrote:

>
> https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-ofx
>
> At the end of the QFX import you were presented with a window listing all
> of the imported new transactions. Since this is a first import they should
> all have had a yellow background. You can either double-click each one or
> select one or more and right click then select "assign account" from the
> context menu. That will bring up a window with your account tree from which
> you can select the "other" account for the selected transactions. When you
> do this GnuCash records information from the transaction's description and
> will use it to suggest an account for future transactions with similar
> descriptions; those will have a green background as will transactions after
> you've assigned an account to them.
>
> If you skipped that step you'll find al of your transactions assigned to
> Imbalance-CAD and you'll need to re-assign them in the register. That
> doesn't train the import matcher.
>
> The General Ledger by default filters to the last 30 days. You can change
> that with View>Filter By.
>
> Regards,
> John Ralls
>
>
> On Jan 3, 2022, at 11:38 PM, Jesse MacDougall 
> wrote:
>
> I was able to download in QFX format.  I did the import.  How do I assign
> the transactions to the accounts now? I see some of the transactions are
> posted in GL but I do not see the entire year of transactions.  Just
> December.
>
> On Mon, Jan 3, 2022 at 9:28 PM john  wrote:
>
>> Not necessarily. You just need to see if Quicken knows how to connect to
>> RBC and if so whether they authenticate with DirectConnect (which AQBanking
>> can handle), Express WebConect, or WebConnect (both of which it can't).
>>
>> It just as possible that what that page is really talking about is
>> downloading files; you can figure that out by logging in to your RBC web
>> account and looking for a download link. GnuCash can handle OFX, QFX, and
>> QIF but not QBO. It's also able to handle CSV though that may take a bit of
>> tweaking and in some cases some preprocessing of the CSV.
>>
>> Regards,
>> John Ralls
>>
>>
>>
>>
>> On Jan 3, 2022, at 9:17 PM, Jesse MacDougall 
>> wrote:
>>
>> Merci, that eliminates two of the options.  I see a forum to a missing
>> institution and connections
>> http://www.ofxhome.com/ofxforum//viewforum.php?id=3.  I see someone two
>> years ask about Canadian Banks.  No response
>> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49825
>>
>> Here someone says TD Bank Canada is not listed but USA is =(
>> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49482
>>
>> A Quicken friend who uses Royal Bank as well?
>>
>>
>>
>> On Mon, Jan 3, 2022 at 8:26 PM john  wrote:
>>
>>> Nope. HBCI (now called FinTS) works *only* with *German* Banks. The
>>> Royal Bank of *Canada* is absolutely not a German bank and isn't likely to
>>> support HBCI.
>>> EBICS is also German only.
>>>
>>>
>>> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html
>>> <
>>> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html>
>>> suggests that RBC might support OFX Direct Connect based on the list of
>>> software they claim to support, but they're not listed in
>>> https://www.ofxhome.com/  so you'd have to
>>> find the connection parameters some other way. The simplest would be to
>>> find a friend who has Quicken and see if it knows how to connect.
>>>
>>> Regards,
>>> John Ralls
>>>
>>>
>>> > On Jan 3, 2022, at 7:00 PM, Cam Ellison  wrote:
>>> >
>>> > On 2022-01-03 5:39 p.m., Jesse MacDougall wrote:
>>> >> Guy's, I'm stumped here.  My Bank is Royal Bank in Canada.  I have no
>>> idea
>>> >> where to get this information from.  When I call the bank they talk
>>> to me
>>> >> like I am a terrorist due to Iddiocracy.
>>> >>
>>> >> Never seen this side of technology before.  I read the AqBanking wiki
>>> but
>>> >> didn't advance.
>>> >>
>>> > Try selecting a range of transactions by date, and then downloading
>>> it. See what formats are available for download. The format of each line
>>> should tell you - or someone on this list with more knowledge than I -
>>> which of those options to use.  Most likely it's HBCI, but that's a wild
>>> guess on my part.
>>> >
>>> > There is likely at least one member of this list with an RBC account,
>>> besides yourself. I have only a 

Re: [GNC] AqBanking Online Set Up

[Jesse MacDougall]

You are right. I agree with you.  I noticed this last night.

On Tue, Jan 4, 2022 at 10:02 AM john  wrote:

> No, those are file download types, not connection options. Money means
> OFX, Quicken probably means QFX but might mean QIF, QuickBooks probably
> means QBO but might also mean QFX or QIF. I don't know what Makisoft is nor
> what file type Sage likes. GnuCash can handle the Money or Quicken
> selections. Since Money is certainly OFX pick that and use
> File>Import>import OFX/QFX to import the data. It's both more reliable and
> less effort than importing CSV.
>
> Regards,
> John Ralls
>
>
> On Jan 3, 2022, at 11:12 PM, Jesse MacDougall 
> wrote:
>
> I can see Royal Bank connects with quicken because when I go to download
> my transactions from Royal Bank there is a Quicken option.So now I have
> determined Quicken integrates with Royal Bank I need to obtain the
> connection parameters.  Are these the parameters?
>
> I downloaded the annual transactions in .csv.  Now to import
> *challenge*
> 
>
>
>
>
>
> On Mon, Jan 3, 2022 at 9:28 PM john  wrote:
>
>> Not necessarily. You just need to see if Quicken knows how to connect to
>> RBC and if so whether they authenticate with DirectConnect (which AQBanking
>> can handle), Express WebConect, or WebConnect (both of which it can't).
>>
>> It just as possible that what that page is really talking about is
>> downloading files; you can figure that out by logging in to your RBC web
>> account and looking for a download link. GnuCash can handle OFX, QFX, and
>> QIF but not QBO. It's also able to handle CSV though that may take a bit of
>> tweaking and in some cases some preprocessing of the CSV.
>>
>> Regards,
>> John Ralls
>>
>>
>>
>>
>> On Jan 3, 2022, at 9:17 PM, Jesse MacDougall 
>> wrote:
>>
>> Merci, that eliminates two of the options.  I see a forum to a missing
>> institution and connections
>> http://www.ofxhome.com/ofxforum//viewforum.php?id=3.  I see someone two
>> years ask about Canadian Banks.  No response
>> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49825
>>
>> Here someone says TD Bank Canada is not listed but USA is =(
>> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49482
>>
>> A Quicken friend who uses Royal Bank as well?
>>
>>
>>
>> On Mon, Jan 3, 2022 at 8:26 PM john  wrote:
>>
>>> Nope. HBCI (now called FinTS) works *only* with *German* Banks. The
>>> Royal Bank of *Canada* is absolutely not a German bank and isn't likely to
>>> support HBCI.
>>> EBICS is also German only.
>>>
>>>
>>> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html
>>> <
>>> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html>
>>> suggests that RBC might support OFX Direct Connect based on the list of
>>> software they claim to support, but they're not listed in
>>> https://www.ofxhome.com/  so you'd have to
>>> find the connection parameters some other way. The simplest would be to
>>> find a friend who has Quicken and see if it knows how to connect.
>>>
>>> Regards,
>>> John Ralls
>>>
>>>
>>> > On Jan 3, 2022, at 7:00 PM, Cam Ellison  wrote:
>>> >
>>> > On 2022-01-03 5:39 p.m., Jesse MacDougall wrote:
>>> >> Guy's, I'm stumped here.  My Bank is Royal Bank in Canada.  I have no
>>> idea
>>> >> where to get this information from.  When I call the bank they talk
>>> to me
>>> >> like I am a terrorist due to Iddiocracy.
>>> >>
>>> >> Never seen this side of technology before.  I read the AqBanking wiki
>>> but
>>> >> didn't advance.
>>> >>
>>> > Try selecting a range of transactions by date, and then downloading
>>> it. See what formats are available for download. The format of each line
>>> should tell you - or someone on this list with more knowledge than I -
>>> which of those options to use.  Most likely it's HBCI, but that's a wild
>>> guess on my part.
>>> >
>>> > There is likely at least one member of this list with an RBC account,
>>> besides yourself. I have only a credit card with them, and that format is
>>> different.
>>> >
>>> > Good luck with this
>>> >
>>> > Cam
>>> >
>>> >
>>> >
>>> > ___
>>> > 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.
>>> -
>>> 

Re: [GNC] AqBanking Online Set Up

[john]

https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-ofx
 


At the end of the QFX import you were presented with a window listing all of 
the imported new transactions. Since this is a first import they should all 
have had a yellow background. You can either double-click each one or select 
one or more and right click then select "assign account" from the context menu. 
That will bring up a window with your account tree from which you can select 
the "other" account for the selected transactions. When you do this GnuCash 
records information from the transaction's description and will use it to 
suggest an account for future transactions with similar descriptions; those 
will have a green background as will transactions after you've assigned an 
account to them.

If you skipped that step you'll find al of your transactions assigned to 
Imbalance-CAD and you'll need to re-assign them in the register. That doesn't 
train the import matcher.

The General Ledger by default filters to the last 30 days. You can change that 
with View>Filter By.

Regards,
John Ralls


> On Jan 3, 2022, at 11:38 PM, Jesse MacDougall  
> wrote:
> 
> I was able to download in QFX format.  I did the import.  How do I assign the 
> transactions to the accounts now? I see some of the transactions are posted 
> in GL but I do not see the entire year of transactions.  Just December.
> 
> On Mon, Jan 3, 2022 at 9:28 PM john  > wrote:
> Not necessarily. You just need to see if Quicken knows how to connect to RBC 
> and if so whether they authenticate with DirectConnect (which AQBanking can 
> handle), Express WebConect, or WebConnect (both of which it can't).
> 
> It just as possible that what that page is really talking about is 
> downloading files; you can figure that out by logging in to your RBC web 
> account and looking for a download link. GnuCash can handle OFX, QFX, and QIF 
> but not QBO. It's also able to handle CSV though that may take a bit of 
> tweaking and in some cases some preprocessing of the CSV.
> 
> Regards,
> John Ralls
> 
> 
> 
> 
>> On Jan 3, 2022, at 9:17 PM, Jesse MacDougall > > wrote:
>> 
>> Merci, that eliminates two of the options.  I see a forum to a missing 
>> institution and connections 
>> http://www.ofxhome.com/ofxforum//viewforum.php?id=3 
>> .  I see someone two 
>> years ask about Canadian Banks.  No response 
>> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49825 
>>  
>> 
>> Here someone says TD Bank Canada is not listed but USA is =( 
>> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49482 
>> 
>> 
>> A Quicken friend who uses Royal Bank as well? 
>> 
>> 
>> 
>> On Mon, Jan 3, 2022 at 8:26 PM john > > wrote:
>> Nope. HBCI (now called FinTS) works *only* with *German* Banks. The Royal 
>> Bank of *Canada* is absolutely not a German bank and isn't likely to support 
>> HBCI.
>> EBICS is also German only.
>> 
>> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html
>>  
>> 
>>  
>> >  
>> >
>>  suggests that RBC might support OFX Direct Connect based on the list of 
>> software they claim to support, but they're not listed in 
>> https://www.ofxhome.com/  
>> > so you'd have to find 
>> the connection parameters some other way. The simplest would be to find a 
>> friend who has Quicken and see if it knows how to connect.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> > On Jan 3, 2022, at 7:00 PM, Cam Ellison > > > wrote:
>> > 
>> > On 2022-01-03 5:39 p.m., Jesse MacDougall wrote:
>> >> Guy's, I'm stumped here.  My Bank is Royal Bank in Canada.  I have no idea
>> >> where to get this information from.  When I call the bank they talk to me
>> >> like I am a terrorist due to Iddiocracy.
>> >> 
>> >> Never seen this side of technology before.  I read the AqBanking wiki but
>> >> didn't advance.
>> >> 
>> > Try selecting a range of transactions by date, and then downloading it. 
>> > See what formats are available for download. The format of each line 
>> > should tell you - or someone on this list with more knowledge than I - 
>> > which of those options to use.  Most likely it's HBCI, but that's a wild 
>> > guess on my part.
>> > 
>> > There is likely at least one member of this list with an RBC account, 
>> > besides yourself. 

Re: [GNC] AqBanking Online Set Up

[john]

No, those are file download types, not connection options. Money means OFX, 
Quicken probably means QFX but might mean QIF, QuickBooks probably means QBO 
but might also mean QFX or QIF. I don't know what Makisoft is nor what file 
type Sage likes. GnuCash can handle the Money or Quicken selections. Since 
Money is certainly OFX pick that and use File>Import>import OFX/QFX to import 
the data. It's both more reliable and less effort than importing CSV.

Regards,
John Ralls


> On Jan 3, 2022, at 11:12 PM, Jesse MacDougall  
> wrote:
> 
> I can see Royal Bank connects with quicken because when I go to download my 
> transactions from Royal Bank there is a Quicken option.So now I have 
> determined Quicken integrates with Royal Bank I need to obtain the connection 
> parameters.  Are these the parameters?
> 
> I downloaded the annual transactions in .csv.  Now to import *challenge*
> 
> 
> 
> 
> 
> 
> On Mon, Jan 3, 2022 at 9:28 PM john  > wrote:
> Not necessarily. You just need to see if Quicken knows how to connect to RBC 
> and if so whether they authenticate with DirectConnect (which AQBanking can 
> handle), Express WebConect, or WebConnect (both of which it can't).
> 
> It just as possible that what that page is really talking about is 
> downloading files; you can figure that out by logging in to your RBC web 
> account and looking for a download link. GnuCash can handle OFX, QFX, and QIF 
> but not QBO. It's also able to handle CSV though that may take a bit of 
> tweaking and in some cases some preprocessing of the CSV.
> 
> Regards,
> John Ralls
> 
> 
> 
> 
>> On Jan 3, 2022, at 9:17 PM, Jesse MacDougall > > wrote:
>> 
>> Merci, that eliminates two of the options.  I see a forum to a missing 
>> institution and connections 
>> http://www.ofxhome.com/ofxforum//viewforum.php?id=3 
>> .  I see someone two 
>> years ask about Canadian Banks.  No response 
>> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49825 
>>  
>> 
>> Here someone says TD Bank Canada is not listed but USA is =( 
>> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49482 
>> 
>> 
>> A Quicken friend who uses Royal Bank as well? 
>> 
>> 
>> 
>> On Mon, Jan 3, 2022 at 8:26 PM john > > wrote:
>> Nope. HBCI (now called FinTS) works *only* with *German* Banks. The Royal 
>> Bank of *Canada* is absolutely not a German bank and isn't likely to support 
>> HBCI.
>> EBICS is also German only.
>> 
>> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html
>>  
>> 
>>  
>> >  
>> >
>>  suggests that RBC might support OFX Direct Connect based on the list of 
>> software they claim to support, but they're not listed in 
>> https://www.ofxhome.com/  
>> > so you'd have to find 
>> the connection parameters some other way. The simplest would be to find a 
>> friend who has Quicken and see if it knows how to connect.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> > On Jan 3, 2022, at 7:00 PM, Cam Ellison > > > wrote:
>> > 
>> > On 2022-01-03 5:39 p.m., Jesse MacDougall wrote:
>> >> Guy's, I'm stumped here.  My Bank is Royal Bank in Canada.  I have no idea
>> >> where to get this information from.  When I call the bank they talk to me
>> >> like I am a terrorist due to Iddiocracy.
>> >> 
>> >> Never seen this side of technology before.  I read the AqBanking wiki but
>> >> didn't advance.
>> >> 
>> > Try selecting a range of transactions by date, and then downloading it. 
>> > See what formats are available for download. The format of each line 
>> > should tell you - or someone on this list with more knowledge than I - 
>> > which of those options to use.  Most likely it's HBCI, but that's a wild 
>> > guess on my part.
>> > 
>> > There is likely at least one member of this list with an RBC account, 
>> > besides yourself. I have only a credit card with them, and that format is 
>> > different.
>> > 
>> > Good luck with this
>> > 
>> > Cam
>> > 
>> > 
>> > 
>> > ___
>> > 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 
>> 

Re: [GNC] AqBanking Online Set Up

[Jesse MacDougall]

I was able to download in QFX format.  I did the import.  How do I assign
the transactions to the accounts now? I see some of the transactions are
posted in GL but I do not see the entire year of transactions.  Just
December.

On Mon, Jan 3, 2022 at 9:28 PM john  wrote:

> Not necessarily. You just need to see if Quicken knows how to connect to
> RBC and if so whether they authenticate with DirectConnect (which AQBanking
> can handle), Express WebConect, or WebConnect (both of which it can't).
>
> It just as possible that what that page is really talking about is
> downloading files; you can figure that out by logging in to your RBC web
> account and looking for a download link. GnuCash can handle OFX, QFX, and
> QIF but not QBO. It's also able to handle CSV though that may take a bit of
> tweaking and in some cases some preprocessing of the CSV.
>
> Regards,
> John Ralls
>
>
>
>
> On Jan 3, 2022, at 9:17 PM, Jesse MacDougall 
> wrote:
>
> Merci, that eliminates two of the options.  I see a forum to a missing
> institution and connections
> http://www.ofxhome.com/ofxforum//viewforum.php?id=3.  I see someone two
> years ask about Canadian Banks.  No response
> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49825
>
> Here someone says TD Bank Canada is not listed but USA is =(
> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49482
>
> A Quicken friend who uses Royal Bank as well?
>
>
>
> On Mon, Jan 3, 2022 at 8:26 PM john  wrote:
>
>> Nope. HBCI (now called FinTS) works *only* with *German* Banks. The Royal
>> Bank of *Canada* is absolutely not a German bank and isn't likely to
>> support HBCI.
>> EBICS is also German only.
>>
>>
>> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html
>> <
>> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html>
>> suggests that RBC might support OFX Direct Connect based on the list of
>> software they claim to support, but they're not listed in
>> https://www.ofxhome.com/  so you'd have to
>> find the connection parameters some other way. The simplest would be to
>> find a friend who has Quicken and see if it knows how to connect.
>>
>> Regards,
>> John Ralls
>>
>>
>> > On Jan 3, 2022, at 7:00 PM, Cam Ellison  wrote:
>> >
>> > On 2022-01-03 5:39 p.m., Jesse MacDougall wrote:
>> >> Guy's, I'm stumped here.  My Bank is Royal Bank in Canada.  I have no
>> idea
>> >> where to get this information from.  When I call the bank they talk to
>> me
>> >> like I am a terrorist due to Iddiocracy.
>> >>
>> >> Never seen this side of technology before.  I read the AqBanking wiki
>> but
>> >> didn't advance.
>> >>
>> > Try selecting a range of transactions by date, and then downloading it.
>> See what formats are available for download. The format of each line should
>> tell you - or someone on this list with more knowledge than I - which of
>> those options to use.  Most likely it's HBCI, but that's a wild guess on my
>> part.
>> >
>> > There is likely at least one member of this list with an RBC account,
>> besides yourself. I have only a credit card with them, and that format is
>> different.
>> >
>> > Good luck with this
>> >
>> > Cam
>> >
>> >
>> >
>> > ___
>> > 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.
>>
>
>
> --
> * Please consider adding jesse@macdougall.ninja to your address book.
> This will be my new address.  This gmail address is being retired.
>
>
>
>
>
>
>
>
>
>

-- 
* Please consider adding jesse@macdougall.ninja to your address book.  This
will be my new address.  This gmail address is being retired.
___
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.

Re: [GNC] AqBanking Online Set Up

[john]

Not necessarily. You just need to see if Quicken knows how to connect to RBC 
and if so whether they authenticate with DirectConnect (which AQBanking can 
handle), Express WebConect, or WebConnect (both of which it can't).

It just as possible that what that page is really talking about is downloading 
files; you can figure that out by logging in to your RBC web account and 
looking for a download link. GnuCash can handle OFX, QFX, and QIF but not QBO. 
It's also able to handle CSV though that may take a bit of tweaking and in some 
cases some preprocessing of the CSV.

Regards,
John Ralls




> On Jan 3, 2022, at 9:17 PM, Jesse MacDougall  
> wrote:
> 
> Merci, that eliminates two of the options.  I see a forum to a missing 
> institution and connections 
> http://www.ofxhome.com/ofxforum//viewforum.php?id=3 
> .  I see someone two 
> years ask about Canadian Banks.  No response 
> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49825 
>  
> 
> Here someone says TD Bank Canada is not listed but USA is =( 
> http://www.ofxhome.com/ofxforum//viewtopic.php?id=49482 
> 
> 
> A Quicken friend who uses Royal Bank as well? 
> 
> 
> 
> On Mon, Jan 3, 2022 at 8:26 PM john  > wrote:
> Nope. HBCI (now called FinTS) works *only* with *German* Banks. The Royal 
> Bank of *Canada* is absolutely not a German bank and isn't likely to support 
> HBCI.
> EBICS is also German only.
> 
> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html
>  
> 
>  
>   
> >
>  suggests that RBC might support OFX Direct Connect based on the list of 
> software they claim to support, but they're not listed in 
> https://www.ofxhome.com/   > so you'd have to find the connection parameters 
> some other way. The simplest would be to find a friend who has Quicken and 
> see if it knows how to connect.
> 
> Regards,
> John Ralls
> 
> 
> > On Jan 3, 2022, at 7:00 PM, Cam Ellison  > > wrote:
> > 
> > On 2022-01-03 5:39 p.m., Jesse MacDougall wrote:
> >> Guy's, I'm stumped here.  My Bank is Royal Bank in Canada.  I have no idea
> >> where to get this information from.  When I call the bank they talk to me
> >> like I am a terrorist due to Iddiocracy.
> >> 
> >> Never seen this side of technology before.  I read the AqBanking wiki but
> >> didn't advance.
> >> 
> > Try selecting a range of transactions by date, and then downloading it. See 
> > what formats are available for download. The format of each line should 
> > tell you - or someone on this list with more knowledge than I - which of 
> > those options to use.  Most likely it's HBCI, but that's a wild guess on my 
> > part.
> > 
> > There is likely at least one member of this list with an RBC account, 
> > besides yourself. I have only a credit card with them, and that format is 
> > different.
> > 
> > Good luck with this
> > 
> > Cam
> > 
> > 
> > 
> > ___
> > 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.
> 
> 
> -- 
> * Please consider adding jesse@macdougall.ninja to your address book.  This 
> will be my new address.  This gmail address is being retired.
> 
> 
>  
> 
>  
> 
>  

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:

Re: [GNC] AqBanking Online Set Up

[Jesse MacDougall]

Merci, that eliminates two of the options.  I see a forum to a missing
institution and connections
http://www.ofxhome.com/ofxforum//viewforum.php?id=3.  I see someone two
years ask about Canadian Banks.  No response
http://www.ofxhome.com/ofxforum//viewtopic.php?id=49825

Here someone says TD Bank Canada is not listed but USA is =(
http://www.ofxhome.com/ofxforum//viewtopic.php?id=49482

A Quicken friend who uses Royal Bank as well?



On Mon, Jan 3, 2022 at 8:26 PM john  wrote:

> Nope. HBCI (now called FinTS) works *only* with *German* Banks. The Royal
> Bank of *Canada* is absolutely not a German bank and isn't likely to
> support HBCI.
> EBICS is also German only.
>
>
> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html
> <
> https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html>
> suggests that RBC might support OFX Direct Connect based on the list of
> software they claim to support, but they're not listed in
> https://www.ofxhome.com/  so you'd have to find
> the connection parameters some other way. The simplest would be to find a
> friend who has Quicken and see if it knows how to connect.
>
> Regards,
> John Ralls
>
>
> > On Jan 3, 2022, at 7:00 PM, Cam Ellison  wrote:
> >
> > On 2022-01-03 5:39 p.m., Jesse MacDougall wrote:
> >> Guy's, I'm stumped here.  My Bank is Royal Bank in Canada.  I have no
> idea
> >> where to get this information from.  When I call the bank they talk to
> me
> >> like I am a terrorist due to Iddiocracy.
> >>
> >> Never seen this side of technology before.  I read the AqBanking wiki
> but
> >> didn't advance.
> >>
> > Try selecting a range of transactions by date, and then downloading it.
> See what formats are available for download. The format of each line should
> tell you - or someone on this list with more knowledge than I - which of
> those options to use.  Most likely it's HBCI, but that's a wild guess on my
> part.
> >
> > There is likely at least one member of this list with an RBC account,
> besides yourself. I have only a credit card with them, and that format is
> different.
> >
> > Good luck with this
> >
> > Cam
> >
> >
> >
> > ___
> > 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.
>


-- 
* Please consider adding jesse@macdougall.ninja to your address book.  This
will be my new address.  This gmail address is being retired.
___
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.

Re: [GNC] AqBanking Online Set Up

[Frank H. Ellenberger]

Am 04.01.22 um 05:22 schrieb john:
> EBICS is also German only.

No, European: AT, CH, DE, FR.
But at least in DE only offered for the (more expensive) business accounts.

Regards
Frank
___
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.

Re: [GNC] AqBanking Online Set Up

[Cam Ellison]

On 2022-01-03 8:22 p.m., john wrote:

Nope. HBCI (now called FinTS) works *only* with *German* Banks. The Royal Bank 
of *Canada* is absolutely not a German bank and isn't likely to support HBCI.
EBICS is also German only.

https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html 

 suggests that RBC might support OFX Direct Connect based on the list of software they 
claim to support, but they're not listed in https://www.ofxhome.com/ 
 so you'd have to find the connection parameters some other 
way. The simplest would be to find a friend who has Quicken and see if it knows how to 
connect.


Thanks, John - I stand corrected.

I've not had to do this for probably a decade, but seem to recall being 
able to make it work with a CSV file (from a credit union) - but that 
was a few versions of GnuCash ago. The CSV option is still in GnuCash - 
that might work well enough. I recall having to hand-bomb some of the 
entries to make it come out correctly.


Cheers

Cam



___
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.

Re: [GNC] AqBanking Online Set Up

[john]

Nope. HBCI (now called FinTS) works *only* with *German* Banks. The Royal Bank 
of *Canada* is absolutely not a German bank and isn't likely to support HBCI.
EBICS is also German only.

https://www.rbcroyalbank.com/onlinebanking/bankingusertips/accountingsoftware/index.html
 

 suggests that RBC might support OFX Direct Connect based on the list of 
software they claim to support, but they're not listed in 
https://www.ofxhome.com/  so you'd have to find the 
connection parameters some other way. The simplest would be to find a friend 
who has Quicken and see if it knows how to connect.

Regards,
John Ralls


> On Jan 3, 2022, at 7:00 PM, Cam Ellison  wrote:
> 
> On 2022-01-03 5:39 p.m., Jesse MacDougall wrote:
>> Guy's, I'm stumped here.  My Bank is Royal Bank in Canada.  I have no idea
>> where to get this information from.  When I call the bank they talk to me
>> like I am a terrorist due to Iddiocracy.
>> 
>> Never seen this side of technology before.  I read the AqBanking wiki but
>> didn't advance.
>> 
> Try selecting a range of transactions by date, and then downloading it. See 
> what formats are available for download. The format of each line should tell 
> you - or someone on this list with more knowledge than I - which of those 
> options to use.  Most likely it's HBCI, but that's a wild guess on my part.
> 
> There is likely at least one member of this list with an RBC account, besides 
> yourself. I have only a credit card with them, and that format is different.
> 
> Good luck with this
> 
> Cam
> 
> 
> 
> ___
> 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.

Re: [GNC] AqBanking Online Set Up

[Cam Ellison]

On 2022-01-03 5:39 p.m., Jesse MacDougall wrote:

Guy's, I'm stumped here.  My Bank is Royal Bank in Canada.  I have no idea
where to get this information from.  When I call the bank they talk to me
like I am a terrorist due to Iddiocracy.

Never seen this side of technology before.  I read the AqBanking wiki but
didn't advance.

Try selecting a range of transactions by date, and then downloading it. 
See what formats are available for download. The format of each line 
should tell you - or someone on this list with more knowledge than I - 
which of those options to use.  Most likely it's HBCI, but that's a wild 
guess on my part.


There is likely at least one member of this list with an RBC account, 
besides yourself. I have only a credit card with them, and that format 
is different.


Good luck with this

Cam



___
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.

[GNC] AqBanking Online Set Up

[Jesse MacDougall]

Guy's, I'm stumped here.  My Bank is Royal Bank in Canada.  I have no idea
where to get this information from.  When I call the bank they talk to me
like I am a terrorist due to Iddiocracy.

Never seen this side of technology before.  I read the AqBanking wiki but
didn't advance.

-- 
* Please consider adding jesse@macdougall.ninja to your address book.  This
will be my new address.  This gmail address is being retired.
___
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.

Re: [GNC] AqBanking Wizard won't start

[Frank H. Ellenberger]

Am 25.11.20 um 19:56 schrieb Peter Dutton:
> Not sure how to use flatpak.

The command to start the flatpak version of GnuCash is:

flatpak run org.gnucash.GnuCash

from https://wiki.gnucash.org/wiki/Flatpak#Regular_releases_from_flathub.org
___
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.

[GNC] AqBanking Wizard won't start

[Peter Dutton]

   I'm trying to get the Aqbanking wizard to run.  While in GC v 3.11 I
   clicking on Start AqBanking Wizard (button) does nothing.  I installed
   Flatpak which had no effect so far.  Not sure how to use flatpak.

   I'm running- Ubuntu 18.04 Mate

   Thanks,

   Peter
___
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.

Re: [GNC] AQbanking ofx.log

[Shyam Acharya]

John/Frank - 

Thanks for your comments. The URL is correct and I see them in OFX-Direct 
Connect database. But I don’t see any successful attempts. BTW the institution 
is Merrill Lynch. 

I managed to get the list of accounts based on my username and PWD. But when I 
try to download transactions I get the error. So I think they are locking me 
out or as you suggested OR do not support OFX. Will try calling them. I did log 
into my account to see if there was a request to authenticate. There was 
nothing.

But again, thanks for taking the time!! 

Shyam

On 11/14/20, 6:31 PM, "John Ralls"  wrote:

Shyam,

The http 400 status *is* the bank's response and it means that either that 
you're not connecting to an OFX-Direct Connect server or that the server thinks 
that the HTTP request is malformed.

Have you confirmed at http://ofxhome.com that your bank supports OFX-Direct 
Connect and has recently tested satisfactory? Are you sure there are no typos 
in the URI?

Regards,
John Ralls


> On Nov 14, 2020, at 12:22 PM, Shyam Acharya  wrote:
> 
> Frank/John - 
> 
> Thanks for the assist. I was able to generate a logfile by setting 
environmental variable AQOFX_LOG_COMM and AQOFXCONNECT_LOGLEVEL. However, when 
I look at the log, I see what was sent. But don’t see the bank's response. 
Perhaps my expectation that the response is captured is incorrect. Should I be 
able to see the response?
> 
> I am trying to resolve a HTTP-Status 400 (Bad Request) error.
> 
> Thanks
> Shyam
> 
> 
> 
> 
> On 11/14/20, 6:45 AM, "Frank H. Ellenberger" 
 wrote:
> 
>Hi,
> 
>Am 14.11.20 um 04:43 schrieb John Ralls:
>> 
>> 
>>> On Nov 13, 2020, at 4:28 PM, Shyam Acharya  
wrote:
>>> 
>>> Hi –
>>> 
>>> I am a new user and trying to debug an online banking setup. How (and 
where) can I can turn on enhanced logging  “AQOFX_LOG_COMM=1” so I can decipher 
the problem?
>>> 
>>> I use a PC WIN10 GNUCASH ver 4.2. I do have access to a Mac as well.
>> 
>> It's an environment variable: 
https://docs.microsoft.com/en-us/windows/win32/procthread/environment-variables
>> 
>> Regards,
>> John Ralls
> 
>I believe, https://wiki.gnucash.org/wiki/AqBanking#Debugging and 
related
>pages like
>
https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect#Enabling_the_OFX_Log
>do not really reflect the current state of AqBanking 6.
> 
>https://lists.gnucash.org/pipermail/gnucash-user/2020-March/090164.html
>should describe the current state starting with Martins comment from 
Mar
>30 with "AQOFX_LOG_COMM=PATH_TO_LOGFILE"
> 
>As I can not verify the OFX stuff, it would be nice, if somebody who
>can, would update the wiki sections.
> 
>Regards
>Frank
> 


___
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.

Re: [GNC] AQbanking ofx.log

[John Ralls]

Shyam,

The http 400 status *is* the bank's response and it means that either that 
you're not connecting to an OFX-Direct Connect server or that the server thinks 
that the HTTP request is malformed.

Have you confirmed at http://ofxhome.com that your bank supports OFX-Direct 
Connect and has recently tested satisfactory? Are you sure there are no typos 
in the URI?

Regards,
John Ralls


> On Nov 14, 2020, at 12:22 PM, Shyam Acharya  wrote:
> 
> Frank/John - 
> 
> Thanks for the assist. I was able to generate a logfile by setting 
> environmental variable AQOFX_LOG_COMM and AQOFXCONNECT_LOGLEVEL. However, 
> when I look at the log, I see what was sent. But don’t see the bank's 
> response. Perhaps my expectation that the response is captured is incorrect. 
> Should I be able to see the response?
> 
> I am trying to resolve a HTTP-Status 400 (Bad Request) error.
> 
> Thanks
> Shyam
> 
> 
> 
> 
> On 11/14/20, 6:45 AM, "Frank H. Ellenberger"  
> wrote:
> 
>Hi,
> 
>Am 14.11.20 um 04:43 schrieb John Ralls:
>> 
>> 
>>> On Nov 13, 2020, at 4:28 PM, Shyam Acharya  wrote:
>>> 
>>> Hi –
>>> 
>>> I am a new user and trying to debug an online banking setup. How (and 
>>> where) can I can turn on enhanced logging  “AQOFX_LOG_COMM=1” so I can 
>>> decipher the problem?
>>> 
>>> I use a PC WIN10 GNUCASH ver 4.2. I do have access to a Mac as well.
>> 
>> It's an environment variable: 
>> https://docs.microsoft.com/en-us/windows/win32/procthread/environment-variables
>> 
>> Regards,
>> John Ralls
> 
>I believe, https://wiki.gnucash.org/wiki/AqBanking#Debugging and related
>pages like
>
> https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect#Enabling_the_OFX_Log
>do not really reflect the current state of AqBanking 6.
> 
>https://lists.gnucash.org/pipermail/gnucash-user/2020-March/090164.html
>should describe the current state starting with Martins comment from Mar
>30 with "AQOFX_LOG_COMM=PATH_TO_LOGFILE"
> 
>As I can not verify the OFX stuff, it would be nice, if somebody who
>can, would update the wiki sections.
> 
>Regards
>Frank
> 

___
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.

Re: [GNC] AQbanking ofx.log

[David Reiser via gnucash-user]

If the transfer occurs, you will see the receive data stream in the log file. 
The 400 error suggests the site on the other end is not responding (or locking 
you out). Make sure the bank hasn’t changed it’s ofx access address, or shut it 
off.
--
Dave Reiser
dbrei...@icloud.com





> On Nov 14, 2020, at 3:22 PM, Shyam Acharya  wrote:
> 
> Frank/John - 
> 
> Thanks for the assist. I was able to generate a logfile by setting 
> environmental variable AQOFX_LOG_COMM and AQOFXCONNECT_LOGLEVEL. However, 
> when I look at the log, I see what was sent. But don’t see the bank's 
> response. Perhaps my expectation that the response is captured is incorrect. 
> Should I be able to see the response?
> 
> I am trying to resolve a HTTP-Status 400 (Bad Request) error.
> 
> Thanks
> Shyam
> 
> 
> 
> 
> On 11/14/20, 6:45 AM, "Frank H. Ellenberger"  
> wrote:
> 
>Hi,
> 
>Am 14.11.20 um 04:43 schrieb John Ralls:
>> 
>> 
>>> On Nov 13, 2020, at 4:28 PM, Shyam Acharya  wrote:
>>> 
>>> Hi –
>>> 
>>> I am a new user and trying to debug an online banking setup. How (and 
>>> where) can I can turn on enhanced logging  “AQOFX_LOG_COMM=1” so I can 
>>> decipher the problem?
>>> 
>>> I use a PC WIN10 GNUCASH ver 4.2. I do have access to a Mac as well.
>> 
>> It's an environment variable: 
>> https://docs.microsoft.com/en-us/windows/win32/procthread/environment-variables
>> 
>> Regards,
>> John Ralls
> 
>I believe, https://wiki.gnucash.org/wiki/AqBanking#Debugging and related
>pages like
>
> https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect#Enabling_the_OFX_Log
>do not really reflect the current state of AqBanking 6.
> 
>https://lists.gnucash.org/pipermail/gnucash-user/2020-March/090164.html
>should describe the current state starting with Martins comment from Mar
>30 with "AQOFX_LOG_COMM=PATH_TO_LOGFILE"
> 
>As I can not verify the OFX stuff, it would be nice, if somebody who
>can, would update the wiki sections.
> 
>Regards
>Frank
> 
> ___
> 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.

Re: [GNC] AQbanking ofx.log

[Shyam Acharya]

Frank/John - 

Thanks for the assist. I was able to generate a logfile by setting 
environmental variable AQOFX_LOG_COMM and AQOFXCONNECT_LOGLEVEL. However, when 
I look at the log, I see what was sent. But don’t see the bank's response. 
Perhaps my expectation that the response is captured is incorrect. Should I be 
able to see the response?

I am trying to resolve a HTTP-Status 400 (Bad Request) error.

Thanks
Shyam




On 11/14/20, 6:45 AM, "Frank H. Ellenberger"  
wrote:

Hi,

Am 14.11.20 um 04:43 schrieb John Ralls:
> 
> 
>> On Nov 13, 2020, at 4:28 PM, Shyam Acharya  wrote:
>>
>> Hi –
>>
>> I am a new user and trying to debug an online banking setup. How (and 
where) can I can turn on enhanced logging  “AQOFX_LOG_COMM=1” so I can decipher 
the problem?
>>
>> I use a PC WIN10 GNUCASH ver 4.2. I do have access to a Mac as well.
> 
> It's an environment variable: 
https://docs.microsoft.com/en-us/windows/win32/procthread/environment-variables
> 
> Regards,
> John Ralls

I believe, https://wiki.gnucash.org/wiki/AqBanking#Debugging and related
pages like

https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect#Enabling_the_OFX_Log
do not really reflect the current state of AqBanking 6.

https://lists.gnucash.org/pipermail/gnucash-user/2020-March/090164.html
should describe the current state starting with Martins comment from Mar
30 with "AQOFX_LOG_COMM=PATH_TO_LOGFILE"

As I can not verify the OFX stuff, it would be nice, if somebody who
can, would update the wiki sections.

Regards
Frank

___
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.

Re: [GNC] AQbanking ofx.log

[Frank H. Ellenberger]

Hi,

Am 14.11.20 um 04:43 schrieb John Ralls:
> 
> 
>> On Nov 13, 2020, at 4:28 PM, Shyam Acharya  wrote:
>>
>> Hi –
>>
>> I am a new user and trying to debug an online banking setup. How (and where) 
>> can I can turn on enhanced logging  “AQOFX_LOG_COMM=1” so I can decipher the 
>> problem?
>>
>> I use a PC WIN10 GNUCASH ver 4.2. I do have access to a Mac as well.
> 
> It's an environment variable: 
> https://docs.microsoft.com/en-us/windows/win32/procthread/environment-variables
> 
> Regards,
> John Ralls

I believe, https://wiki.gnucash.org/wiki/AqBanking#Debugging and related
pages like
https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect#Enabling_the_OFX_Log
do not really reflect the current state of AqBanking 6.

https://lists.gnucash.org/pipermail/gnucash-user/2020-March/090164.html
should describe the current state starting with Martins comment from Mar
30 with "AQOFX_LOG_COMM=PATH_TO_LOGFILE"

As I can not verify the OFX stuff, it would be nice, if somebody who
can, would update the wiki sections.

Regards
Frank
___
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.

Re: [GNC] AQbanking ofx.log

[John Ralls]

> On Nov 13, 2020, at 4:28 PM, Shyam Acharya  wrote:
> 
> Hi –
> 
> I am a new user and trying to debug an online banking setup. How (and where) 
> can I can turn on enhanced logging  “AQOFX_LOG_COMM=1” so I can decipher the 
> problem?
> 
> I use a PC WIN10 GNUCASH ver 4.2. I do have access to a Mac as well.

It's an environment variable: 
https://docs.microsoft.com/en-us/windows/win32/procthread/environment-variables

Regards,
John Ralls

___
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.

[GNC] AQbanking ofx.log

[Shyam Acharya]

Hi –

I am a new user and trying to debug an online banking setup. How (and where) 
can I can turn on enhanced logging  “AQOFX_LOG_COMM=1” so I can decipher the 
problem?

I use a PC WIN10 GNUCASH ver 4.2. I do have access to a Mac as well.

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.

Re: [GNC] AqBanking OFX DirectConnect issues

[jean laroche]

Thanks for mentioning that. I have completely given up on aqbanking 
within GC, I struggled mightily to make it work and failed, and decided 
to go the ofx way.

I personally use ofxclient, there's also ofxget.
But sadly recently my bank (Patelco) stopped their ofx server, there was 
a long discussion on this mail group about that.
I started using plaid, which is an api/service that collects 
transactions/balances etc from all your banks and makes them available 
to you. Not everybody is comfortable with that though.
Then I resorted to writing my own screen scraping python code to log 
into my bank, and download the ofx files automatically. I used python 
and selenium and selenium ide (an extension for Chrome and Firefox).

Definitely not ideal, but it works...
Jean.


On 7/15/2020 4:38 AM, fleur wrote:

Thanks for the info.  FYI If you know python, and are so inclined, there are 
OFX libraries you can use to generate those requests.  ofxtools is one.


fleur
--
Fleur Dragan / fl...@obscure.org





On Jul 12, 2020, at 11:11 AM, Dan Howell  wrote:

On Fri, Jul 10, 2020 at 09:21 AM EDT fleur  wrote:


I can't help unfortunately, but I'm having my own OFX setup issues and I'm
curious: What platform do you run GnuCash on?  Also, were you successful in
re-setting up your Chase account(s)?


As I said in my original message, I'm using GnuCash on Windows 10. Yes, I
was successful re-setting up the Chase account, by reusing the same Client
UID I generated when I first successfully set up the Chase connection
before the AqBanking upgrade.

So far, Schwab and Chase are the only banks I've had success in connecting
to. I may try again soon with some other banks, hoping the upgrade might
fix some issues I've had before, but given most U.S. banks reluctance to
work with any financial software not owned by Intuit, I'm not expecting
much. But now that I know how to generate OFX requests with cURL, I may
experiment more.

Thanks to Martin for fixing the  issue.

Dan
___
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.


___
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.

Re: [GNC] AqBanking OFX DirectConnect issues

[fleur]

Thanks for the info.  FYI If you know python, and are so inclined, there are 
OFX libraries you can use to generate those requests.  ofxtools is one.


fleur
--
Fleur Dragan / fl...@obscure.org




> On Jul 12, 2020, at 11:11 AM, Dan Howell  wrote:
> 
> On Fri, Jul 10, 2020 at 09:21 AM EDT fleur  wrote:
> 
>> I can't help unfortunately, but I'm having my own OFX setup issues and I'm
>> curious: What platform do you run GnuCash on?  Also, were you successful in
>> re-setting up your Chase account(s)?
>> 
> 
> As I said in my original message, I'm using GnuCash on Windows 10. Yes, I
> was successful re-setting up the Chase account, by reusing the same Client
> UID I generated when I first successfully set up the Chase connection
> before the AqBanking upgrade.
> 
> So far, Schwab and Chase are the only banks I've had success in connecting
> to. I may try again soon with some other banks, hoping the upgrade might
> fix some issues I've had before, but given most U.S. banks reluctance to
> work with any financial software not owned by Intuit, I'm not expecting
> much. But now that I know how to generate OFX requests with cURL, I may
> experiment more.
> 
> Thanks to Martin for fixing the  issue.
> 
> Dan
> ___
> 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.

Re: [GNC] AqBanking OFX DirectConnect issues

[Dan Howell]

On Fri, Jul 10, 2020 at 09:21 AM EDT fleur  wrote:

> I can't help unfortunately, but I'm having my own OFX setup issues and I'm
> curious: What platform do you run GnuCash on?  Also, were you successful in
> re-setting up your Chase account(s)?
>

As I said in my original message, I'm using GnuCash on Windows 10. Yes, I
was successful re-setting up the Chase account, by reusing the same Client
UID I generated when I first successfully set up the Chase connection
before the AqBanking upgrade.

So far, Schwab and Chase are the only banks I've had success in connecting
to. I may try again soon with some other banks, hoping the upgrade might
fix some issues I've had before, but given most U.S. banks reluctance to
work with any financial software not owned by Intuit, I'm not expecting
much. But now that I know how to generate OFX requests with cURL, I may
experiment more.

Thanks to Martin for fixing the  issue.

Dan
___
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.

Re: [GNC] AqBanking OFX DirectConnect issues

[Martin Preuss]

Hi,

Am 10.07.20 um 05:54 schrieb Dan Howell:
[...]
> By sending the same request through cURL, but moving the  parameter
> to right after  (where it was with AqBanking 5), the query succeeds:
[...]
> So if this could be routed to the proper person who could fix this, I would
> be grateful for this to be fixed in the next version.
[...]

thanks, should be fixed now in GIT.


Regards
Martin


-- 
"Things are only impossible until they're not"
___
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.

Re: [GNC] AqBanking OFX DirectConnect issues

[Jim DeLaHunt]

On 2020-07-09 20:54, Dan Howell wrote:


…when importing OFX files manually (i.e.
through File > Import), where the  string is put in the Description
field, and the  is put in the Notes field, although with added cruft
like, "OFX ext. info: |Trans type:Generic debit|Memo:" which is a bit
annoying to me as well….


The cruft annoys me also.

Bug 797678 - OFX importer should supplement, not replace, existing Notes 
(and Description and Memo) fields 
 asks to improve that 
situation. Consider giving it a read, and adding your opinion to that 
discussion.


Best regards,
 —Jim DeLaHunt, Vancouver, Canada

___
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.

Re: [GNC] AqBanking OFX DirectConnect issues

[fleur]

Hi Dan,

I can't help unfortunately, but I'm having my own OFX setup issues and I'm 
curious: What platform do you run GnuCash on?  Also, were you successful in 
re-setting up your Chase account(s)?

(Also, I'll +1 on the cruft in the notes field on manual import.)


thanks,
fleur
--
Fleur Dragan / fl...@obscure.org




> On Jul 10, 2020, at 4:54 AM, Dan Howell  wrote:
> 
> Hi,
> 
> After upgrading from GnuCash 3.7 to 4.0 on Windows 10, I realize that comes
> with an AqBanking upgrade as well, requiring me to re-setup all of my
> account connections.
> 
> One issue I'm having is with a Charles Schwab investment account. With
> AqBanking 5 I was able to import successfully, but with AqBanking 6, I see
> in the OFX logs that if fails with error code 2000, "Account information
> may contain bad or invalid characters such as spaces." I tried all the
> suggestions on the GnuCash OFXDirectConnect page to no avail.
> 
> After using the logs to generate OFX requests by hand with curl, I was able
> to determine the problem. The Schwab OFX server is picky about the
> placement of the  parameter. So while the following request sent by
> AqBanking 6 fails:
> 
> [...most of OFX request redacted...]
> 
> Y
> 
> Y
> 
> Y
> 
> 20200709015145.000
> 
> 
> 
> 
> By sending the same request through cURL, but moving the  parameter
> to right after  (where it was with AqBanking 5), the query succeeds:
> 
> [...most of OFX request redacted...]
> 
> Y
> 
> 20200709015145.000
> Y
> 
> Y
> 
> 
> 
> 
> 
> So if this could be routed to the proper person who could fix this, I would
> be grateful for this to be fixed in the next version.
> 
> --
> 
> Another, unrelated issue, and mostly just an annoyance, is that when
> importing, e.g, from my Chase bank account, the  and  fields
> are imported into the GnuCash Description field as "Memo string; Name
> string". This results in e.g.:
> 
>   Online Payment 9901156465 To SOUTHERN CALIFORNIA GAS
> 
> Being imported as:
> 
>   THERN CALIFORNIA GAS; Online Payment 9901156465 To SOU
> 
> This is backwards from what would be expected--the name field should
> clearly come before the memo field. As I perused through several other
> banks' OFX files, I couldn't find any examples where it would make sense to
> put the Memo field before the Name field, so this isn't unique to Chase.
> 
> By the way, this is different than when importing OFX files manually (i.e.
> through File > Import), where the  string is put in the Description
> field, and the  is put in the Notes field, although with added cruft
> like, "OFX ext. info: |Trans type:Generic debit|Memo:" which is a bit
> annoying to me as well. It would be nice if how OFX fields are imported
> could be made customizable on a per account basis. My OCD brain insists on
> fixing these quirks to make it more presentable, consuming precious amounts
> of my time copying, pasting, and deleting, so I wish this could be
> automated somehow.
> 
> Dan Howell
> dhowel...@gmail.com
> ___
> 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.

[GNC] AqBanking OFX DirectConnect issues

[Dan Howell]

Hi,

After upgrading from GnuCash 3.7 to 4.0 on Windows 10, I realize that comes
with an AqBanking upgrade as well, requiring me to re-setup all of my
account connections.

One issue I'm having is with a Charles Schwab investment account. With
AqBanking 5 I was able to import successfully, but with AqBanking 6, I see
in the OFX logs that if fails with error code 2000, "Account information
may contain bad or invalid characters such as spaces." I tried all the
suggestions on the GnuCash OFXDirectConnect page to no avail.

After using the logs to generate OFX requests by hand with curl, I was able
to determine the problem. The Schwab OFX server is picky about the
placement of the  parameter. So while the following request sent by
AqBanking 6 fails:

[...most of OFX request redacted...]

Y

Y

Y

20200709015145.000




By sending the same request through cURL, but moving the  parameter
to right after  (where it was with AqBanking 5), the query succeeds:

[...most of OFX request redacted...]

Y

20200709015145.000
Y

Y





So if this could be routed to the proper person who could fix this, I would
be grateful for this to be fixed in the next version.

--

Another, unrelated issue, and mostly just an annoyance, is that when
importing, e.g, from my Chase bank account, the  and  fields
are imported into the GnuCash Description field as "Memo string; Name
string". This results in e.g.:

   Online Payment 9901156465 To SOUTHERN CALIFORNIA GAS

Being imported as:

   THERN CALIFORNIA GAS; Online Payment 9901156465 To SOU

This is backwards from what would be expected--the name field should
clearly come before the memo field. As I perused through several other
banks' OFX files, I couldn't find any examples where it would make sense to
put the Memo field before the Name field, so this isn't unique to Chase.

By the way, this is different than when importing OFX files manually (i.e.
through File > Import), where the  string is put in the Description
field, and the  is put in the Notes field, although with added cruft
like, "OFX ext. info: |Trans type:Generic debit|Memo:" which is a bit
annoying to me as well. It would be nice if how OFX fields are imported
could be made customizable on a per account basis. My OCD brain insists on
fixing these quirks to make it more presentable, consuming precious amounts
of my time copying, pasting, and deleting, so I wish this could be
automated somehow.

Dan Howell
dhowel...@gmail.com
___
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.

Re: [GNC] AQbanking Amex OFX Download Badly Broken

[Chris Good]

Message: 5
Date: Sun, 24 May 2020 00:19:33 -0400
From: "Alan" 
To: "'Gnucash Users'" 
Subject: [GNC] AQbanking Amex OFX Download Badly Broken
Message-ID: <0fbc01d63182$87ba6ea0$972f4be0$@bigtowers.net>
Content-Type: text/plain;   charset="us-ascii"

Tried the Aqbanking section on GnuCash 3.10 with my Amex account. It was
encouraging to see the latest version of Aqbanking now recognizes the
content in the OFX download (last broken version could only read the
headers). Was about to congratulate the development team, but then I noticed
something very wrong with the few hundred transactions I had just loaded
into GnuCash.

None of the payees matched anything that could be matched up with any
previously entered, downloaded and audited transactions. Closer inspection
revealed something very wrong, and repeated on every transaction record
downloaded.

I compared individual transactions in my Aqbanking debug log to the ones
that GnuCash had downloaded. GnuCash apparently concatenated each memo field
followed by a space, followed by the transaction payee name. None of the
downloaded data ended up in a valid transaction memo field. This is badly
broken, and totally unusable.

I examined the debug log to see how well Aqbanking has been communicating
with the bank. Headers show the session established and completed properly.
Transaction records and fields were being presented correctly, amounts were
correctly associated with the real payees, and Amex was proving a fully
formed payee name  followed by a fully formed memo field . The
transaction ID number was also transferred consistently in the 
field, though GnuCash appears to be ignoring it.

Someone had to go to a lot of trouble to do this, rather than just place
each usable transaction field data into the closest matching ledger fields
(even the transaction ID can be useful for simple dupe checking). That's all
that we're looking for. Download the data, populate the record fields, and
get back to business.

So I'm at a total loss how anyone could have deliberately taken clearly
defined fields and data (that should easily match the "Description" and
"Notes" fields within GnuCash account ledgers), and pretty much destroy
them, along with the user data sets that also have to be deleted and
recreated.

Hi Alan,

I import downloaded .ofx files, as my bank doesn't offer direct connection,
but I think GnuCash does the same thing with direct connect as importing a
downloaded .ofx file.

I believe (but this is just my idea) the  fields are imported into the
transaction Note field (View, Double Line) in order to not override the
split Memo fields on existing transactions.

The transaction ID number, if this is supposed to be the unique code for a
transaction in an account, should be in an 'FITID' tag.

The OFX libraries (libofx) were probably not designed for GnuCash, so we
have to map as best we can.

It may be worthwhile creating an enhancement type bug specifying how you'd
like 'REFNUM' handled.

Regards, Chris Good

___
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.

[GNC] AQbanking Amex OFX Download Badly Broken

[Alan]

Tried the Aqbanking section on GnuCash 3.10 with my Amex account. It was
encouraging to see the latest version of Aqbanking now recognizes the content in
the OFX download (last broken version could only read the headers). Was about to
congratulate the development team, but then I noticed something very wrong with
the few hundred transactions I had just loaded into GnuCash.

 

None of the payees matched anything that could be matched up with any previously
entered, downloaded and audited transactions. Closer inspection revealed
something very wrong, and repeated on every transaction record downloaded.

 

I compared individual transactions in my Aqbanking debug log to the ones that
GnuCash had downloaded. GnuCash apparently concatenated each memo field followed
by a space, followed by the transaction payee name. None of the downloaded data
ended up in a valid transaction memo field. This is badly broken, and totally
unusable.

 

I examined the debug log to see how well Aqbanking has been communicating with
the bank. Headers show the session established and completed properly.
Transaction records and fields were being presented correctly, amounts were
correctly associated with the real payees, and Amex was proving a fully formed
payee name  followed by a fully formed memo field . The transaction
ID number was also transferred consistently in the  field, though
GnuCash appears to be ignoring it.

 

Someone had to go to a lot of trouble to do this, rather than just place each
usable transaction field data into the closest matching ledger fields (even the
transaction ID can be useful for simple dupe checking). That's all that we're
looking for. Download the data, populate the record fields, and get back to
business.

 

So I'm at a total loss how anyone could have deliberately taken clearly defined
fields and data (that should easily match the "Description" and "Notes" fields
within GnuCash account ledgers), and pretty much destroy them, along with the
user data sets that also have to be deleted and recreated.

___
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.

Re: [GNC] AqBanking for Canadian banks

[Evenmoreconfused]

Nelson wrote
> Just wondering if anyone was successful in setting up any Canadian banks
> for
> online banking in GnuCash. Thanks for sharing.

I download transactions from several Canadian banks (BMO, TD, CIBC)  in
three different GnuCash files on a regular basis. Works just fine.

I simply select OFX format (sometimes called MS-Money) and let Firefox
download into the downloads folder. Then I go into GnuCash and use File >
Import > Import OFX/QFX...

I imagine there are more automated ways of achieving this, but I'm a bit of
a control freak and hate cleaning up the messes that happen when something
goes awry. This way is roughly the way I like it, actually. 



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] AqBanking for Canadian banks

[Derek Atkins]

Nelson  writes:

> Hello everyone.  
>
> Just wondering if anyone was successful in setting up any Canadian banks for
> online banking in GnuCash. Thanks for sharing.

Do they support OFX-DC?

You can check OFXHome for your bank info?

Good Luck,

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
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.

[GNC] AqBanking for Canadian banks

[Nelson]

Hello everyone.  

Just wondering if anyone was successful in setting up any Canadian banks for
online banking in GnuCash. Thanks for sharing.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] aqbanking not working for me in 3.9 on mac

[Martin Preuss]

Ups... that was a stupid bug I introduced some time ago... Fixed in GIT.

So, regarding the case at hand:  "AQOFX_LOG_COMM=1" will with the
current release (up to 6.1.4) create the log file "1" in the current folder.
Any other value will use the known path "/tmp/ofx.log" regardless of the
value given...


Martin




Am 30.03.20 um 22:03 schrieb Chris Graves:
> My experience is that setting AQOFX_LOG_COMM=1
> 
> Creates the ofx log file in the current directory, however the name of
> the file is “1”.
> 
>> On Mar 30, 2020, at 11:51 AM, Martin Preuss > > wrote:
>>
>> Dave,
>>
>> you could try "AQOFX_LOG_COMM=PATH_TO_LOGFILE" ("=1" should still create
>> the default log file, but in newer versions of AqBanking you can also
>> set the path and name of the log file to use).
>>
>>
>> Martin
>>
>>
>> Am 30.03.20 um 06:10 schrieb David Reiser via gnucash-user:
>>> Giving Gnucash 3.9 full disk access in System Prefs allows the
>>> retrieval to work correctly, but does not reenable ofx.log creation.
>>>
>>> Dave
>>> --
>>> Dave Reiser
>>> dbrei...@icloud.com 
>>>
>>>
>>>
>>>
>>>
 On Mar 29, 2020, at 11:42 PM, David Reiser via gnucash-user
  wrote:

 Gnucash 3.9 on MacOS 10.15.4 is not successfully retrieving
  transactions for me.

 I ran a Get Transactions in 3.9 from one of my Chase credit card
 accounts and got a blank matcher window.

 Quit 3.9
 Launch 3.7, and run the Get Transaction process. One new and one
 to-be-added transactions are displayed in the matcher window.
 Cancel the import
 Quit 3.7
 Go back to 3.9, verify the transactions aren’t cleared or imported,
 rerun Get Transactions. Nothing appears in the matcher window.

 And I can’t tell if it’s aqbanking or gnucash.
 I used to be able to add AQOFX_LOG_COMM=1 to
 /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment
 and have the ofx data stream show up in /tmp/ofx.log.
 That log file isn’t updated from 3.9, even with the environment
 variable added.

 Dave
 --
 Dave Reiser
 dbrei...@icloud.com





 ___
 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.
>>>
>>
>>
>> -- 
>> "Things are only impossible until they're not"
>> ___
>> 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.
> 


-- 
"Things are only impossible until they're not"
___
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.

Re: [GNC] aqbanking not working for me in 3.9 on mac

[Chris Graves]

My experience is that setting AQOFX_LOG_COMM=1

Creates the ofx log file in the current directory, however the name of the file 
is “1”.

> On Mar 30, 2020, at 11:51 AM, Martin Preuss  wrote:
> 
> Dave,
> 
> you could try "AQOFX_LOG_COMM=PATH_TO_LOGFILE" ("=1" should still create
> the default log file, but in newer versions of AqBanking you can also
> set the path and name of the log file to use).
> 
> 
> Martin
> 
> 
> Am 30.03.20 um 06:10 schrieb David Reiser via gnucash-user:
>> Giving Gnucash 3.9 full disk access in System Prefs allows the retrieval to 
>> work correctly, but does not reenable ofx.log creation.
>> 
>> Dave
>> --
>> Dave Reiser
>> dbrei...@icloud.com
>> 
>> 
>> 
>> 
>> 
>>> On Mar 29, 2020, at 11:42 PM, David Reiser via gnucash-user 
>>>  wrote:
>>> 
>>> Gnucash 3.9 on MacOS 10.15.4 is not successfully retrieving  transactions 
>>> for me.
>>> 
>>> I ran a Get Transactions in 3.9 from one of my Chase credit card accounts 
>>> and got a blank matcher window.
>>> 
>>> Quit 3.9
>>> Launch 3.7, and run the Get Transaction process. One new and one 
>>> to-be-added transactions are displayed in the matcher window.
>>> Cancel the import
>>> Quit 3.7
>>> Go back to 3.9, verify the transactions aren’t cleared or imported, rerun 
>>> Get Transactions. Nothing appears in the matcher window.
>>> 
>>> And I can’t tell if it’s aqbanking or gnucash.
>>> I used to be able to add AQOFX_LOG_COMM=1 to 
>>> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment and 
>>> have the ofx data stream show up in /tmp/ofx.log.
>>> That log file isn’t updated from 3.9, even with the environment variable 
>>> added.
>>> 
>>> Dave
>>> --
>>> Dave Reiser
>>> dbrei...@icloud.com
>>> 
>>> 
>>> 
>>> 
>>> 
>>> ___
>>> 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.
>> 
> 
> 
> -- 
> "Things are only impossible until they're not"
> ___
> 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.

Re: [GNC] aqbanking not working for me in 3.9 on mac

[John Ralls]

I found that not to work when I was working on AQBanking a couple of weeks ago. 
It wrote the log file to /tmp/ofx.log no matter what I set AQOFX_LOG_COMM to. I 
also found it necessary to set AQOFXCONNECT_LOGLEVEL=info (or debug) to get AQB 
to write ofx.log.

Regards,
John Ralls


> On Mar 30, 2020, at 11:51 AM, Martin Preuss  wrote:
> 
> Dave,
> 
> you could try "AQOFX_LOG_COMM=PATH_TO_LOGFILE" ("=1" should still create
> the default log file, but in newer versions of AqBanking you can also
> set the path and name of the log file to use).
> 
> 
> Martin
> 
> 
> Am 30.03.20 um 06:10 schrieb David Reiser via gnucash-user:
>> Giving Gnucash 3.9 full disk access in System Prefs allows the retrieval to 
>> work correctly, but does not reenable ofx.log creation.
>> 
>> Dave
>> --
>> Dave Reiser
>> dbrei...@icloud.com
>> 
>> 
>> 
>> 
>> 
>>> On Mar 29, 2020, at 11:42 PM, David Reiser via gnucash-user 
>>>  wrote:
>>> 
>>> Gnucash 3.9 on MacOS 10.15.4 is not successfully retrieving  transactions 
>>> for me.
>>> 
>>> I ran a Get Transactions in 3.9 from one of my Chase credit card accounts 
>>> and got a blank matcher window.
>>> 
>>> Quit 3.9
>>> Launch 3.7, and run the Get Transaction process. One new and one 
>>> to-be-added transactions are displayed in the matcher window.
>>> Cancel the import
>>> Quit 3.7
>>> Go back to 3.9, verify the transactions aren’t cleared or imported, rerun 
>>> Get Transactions. Nothing appears in the matcher window.
>>> 
>>> And I can’t tell if it’s aqbanking or gnucash.
>>> I used to be able to add AQOFX_LOG_COMM=1 to 
>>> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment and 
>>> have the ofx data stream show up in /tmp/ofx.log.
>>> That log file isn’t updated from 3.9, even with the environment variable 
>>> added.
>>> 
>>> Dave
>>> --
>>> Dave Reiser
>>> dbrei...@icloud.com
>>> 
>>> 
>>> 
>>> 
>>> 
>>> ___
>>> 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.
>> 
> 
> 
> -- 
> "Things are only impossible until they're not"
> ___
> 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.

Re: [GNC] aqbanking not working for me in 3.9 on mac

[Martin Preuss]

Dave,

you could try "AQOFX_LOG_COMM=PATH_TO_LOGFILE" ("=1" should still create
the default log file, but in newer versions of AqBanking you can also
set the path and name of the log file to use).


Martin


Am 30.03.20 um 06:10 schrieb David Reiser via gnucash-user:
> Giving Gnucash 3.9 full disk access in System Prefs allows the retrieval to 
> work correctly, but does not reenable ofx.log creation.
> 
> Dave
> --
> Dave Reiser
> dbrei...@icloud.com
> 
> 
> 
> 
> 
>> On Mar 29, 2020, at 11:42 PM, David Reiser via gnucash-user 
>>  wrote:
>>
>> Gnucash 3.9 on MacOS 10.15.4 is not successfully retrieving  transactions 
>> for me.
>>
>> I ran a Get Transactions in 3.9 from one of my Chase credit card accounts 
>> and got a blank matcher window.
>>
>> Quit 3.9
>> Launch 3.7, and run the Get Transaction process. One new and one to-be-added 
>> transactions are displayed in the matcher window.
>> Cancel the import
>> Quit 3.7
>> Go back to 3.9, verify the transactions aren’t cleared or imported, rerun 
>> Get Transactions. Nothing appears in the matcher window.
>>
>> And I can’t tell if it’s aqbanking or gnucash.
>> I used to be able to add AQOFX_LOG_COMM=1 to 
>> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment and 
>> have the ofx data stream show up in /tmp/ofx.log.
>> That log file isn’t updated from 3.9, even with the environment variable 
>> added.
>>
>> Dave
>> --
>> Dave Reiser
>> dbrei...@icloud.com
>>
>>
>>
>>
>>
>> ___
>> 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.
> 


-- 
"Things are only impossible until they're not"
___
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.

Re: [GNC] aqbanking not working for me in 3.9 on mac

[David Reiser via gnucash-user]

Giving Gnucash 3.9 full disk access in System Prefs allows the retrieval to 
work correctly, but does not reenable ofx.log creation.

Dave
--
Dave Reiser
dbrei...@icloud.com





> On Mar 29, 2020, at 11:42 PM, David Reiser via gnucash-user 
>  wrote:
> 
> Gnucash 3.9 on MacOS 10.15.4 is not successfully retrieving  transactions for 
> me.
> 
> I ran a Get Transactions in 3.9 from one of my Chase credit card accounts and 
> got a blank matcher window.
> 
> Quit 3.9
> Launch 3.7, and run the Get Transaction process. One new and one to-be-added 
> transactions are displayed in the matcher window.
> Cancel the import
> Quit 3.7
> Go back to 3.9, verify the transactions aren’t cleared or imported, rerun Get 
> Transactions. Nothing appears in the matcher window.
> 
> And I can’t tell if it’s aqbanking or gnucash.
> I used to be able to add AQOFX_LOG_COMM=1 to 
> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment and have 
> the ofx data stream show up in /tmp/ofx.log.
> That log file isn’t updated from 3.9, even with the environment variable 
> added.
> 
> Dave
> --
> Dave Reiser
> dbrei...@icloud.com
> 
> 
> 
> 
> 
> ___
> 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.

[GNC] aqbanking not working for me in 3.9 on mac

[David Reiser via gnucash-user]

Gnucash 3.9 on MacOS 10.15.4 is not successfully retrieving  transactions for 
me.

I ran a Get Transactions in 3.9 from one of my Chase credit card accounts and 
got a blank matcher window.

Quit 3.9
Launch 3.7, and run the Get Transaction process. One new and one to-be-added 
transactions are displayed in the matcher window.
Cancel the import
Quit 3.7
Go back to 3.9, verify the transactions aren’t cleared or imported, rerun Get 
Transactions. Nothing appears in the matcher window.

And I can’t tell if it’s aqbanking or gnucash.
I used to be able to add AQOFX_LOG_COMM=1 to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment and have 
the ofx data stream show up in /tmp/ofx.log.
That log file isn’t updated from 3.9, even with the environment variable added.

Dave
--
Dave Reiser
dbrei...@icloud.com





___
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.

Re: [GNC] AQBanking OFX DirectConnect

[chris graves]

Yeah, and perhaps I wasn't following your advice of:

It actually requires make uninstall && make clean && make && make install to 
ensure that the changed code is used.

> On Mar 18, 2020, at 5:32 PM, John Ralls  wrote:
> 
> Chris,
> 
> I guess in your case it was having OFXHEADER:100 and VERSION:102. I think 
> that's all that changed between your last failed run and the successful one.
> 
> Regards,
> John Ralls
> 
>> On Mar 18, 2020, at 5:21 PM, Chris Graves  wrote:
>> 
>> John,
>> 
>> You are probably right, but here is an excerpt from the working ofx.log 
>> file, so I guess I'm not sure what enabled this progress:
>> Sending:
>> -
>> OFXHEADER:100
>> DATA:OFXSGML
>> VERSION:102
>> SECURITY:NONE
>> ENCODING:USASCII
>> CHARSET:1252
>> COMPRESSION:NONE
>> OLDFILEUID:NONE
>> NEWFILEUID:20200318152018.000
>> 
>> 
>> 
>> 
>> 20200318152011.000
>> xxx
>> xx
>> ENG
>> 
>> KINECTA
>> 322278073
>> 
>> 
>> On Wed, Mar 18, 2020 at 5:10 PM John Ralls  wrote:
>> Chris,
>> 
>> You have it backwards: Martin changed LANG -> LANGUAGE because that's what 
>> AQB5 used.
>> 
>> However, I just tested on a bank account at USAA and that worked, except 
>> that it crashed GnuCash when trying to process the new transactions. That's 
>> probably not AQBanking's doing and I'll look into that separately.
>> 
>> Next I'll try Martin's command-line test.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Mar 18, 2020, at 4:57 PM, Chris Graves  wrote:
>>> 
>>> John,
>>> 
>>> In your ofx.log file it still says LANGUAGE instead of LANG.  Mine says 
>>> LANG, which is what Martin just fixed.
>>> 
>>> On Wed, Mar 18, 2020 at 4:54 PM John Ralls  wrote:
>>> Progress indeed, though still not enough for USAA. :-(
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>> 
 On Mar 18, 2020, at 4:48 PM, Chris Graves  wrote:
 
 Wow! making serious progress now.  I was requesting transactions from my 
 checking account.  Looking at the ofx.log file, they were returned!!!
 
 However the import process indicated that there were no transactions to be 
 imported.
 
 On Wed, Mar 18, 2020 at 4:32 PM Martin Preuss  wrote:
 Hi,
 
 I just checked in another change... While comparing your logs I found
 that aqb6 uses "LANG" while aqb5 used the correct name "LANGUAGE".
 
 Also, added "CLTCOOKIE" (was set by aqb5 but missing in aqb6).
 
 Also, I noticed that aqb5 included "BANKID" which you log from aqb6
 didn't contain that line...
 
 However, I think the unexpected element "LANG" (instead of "LANGUAGE")
 was what made the server reject the request due to syntax error...
 
 Fixed in git.
 
 
 Regards
 Martin
 
 
 Am 19.03.20 um 00:26 schrieb John Ralls:
> That's what mine says:
>char flags="forceSsl3", "sendShortDate"
>char bankName="USAA Federal Savings Bank"
>char org="USAA"
>char fid="24591"
>char serverAddr="https%3A%2F%2Fservice2.usaa.com%2Fofx%2FOFXServlet"
>char appId="QWIN"
>char appVer="2300"
>char headerVer="102"
>int  httpVMajor="0"
>int  httpVMinor="0"
>  }
> 
> Regards,
> John Ralls
> 
> 
>> On Mar 18, 2020, at 4:15 PM, Martin Preuss  wrote:
>> 
>> Hmm, maybe the server is picky about the HTTP version? Some servers
>> are... That can currently only be changed directly in the configuration
>> file:
>> 
>> $HOME/.aqbanking/settings6/users/*.conf
>> 
>> Some servers only accept httpVMinor="0"...
>> 
>> 
>> Regards
>> Martin
>> 
>> 
>> 
>> Am 18.03.20 um 23:20 schrieb John Ralls:
>>> Sigh, that's not it either:
>>> Sending:
>>> -
>>> OFXHEADER:100
>>> DATA:OFXSGML
>>> VERSION:102
>>> SECURITY:NONE
>>> ENCODING:USASCII
>>> CHARSET:1252
>>> COMPRESSION:NONE
>>> OLDFILEUID:NONE
>>> NEWFILEUID:20200318151247.000
>> [...]
>> 
>> -- 
>> "Things are only impossible until they're not"
> 
 
 
 -- 
 "Things are only impossible until they're not"
>>> 
>> 
> 

___
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.

Re: [GNC] AQBanking OFX DirectConnect

[John Ralls]

Chris,

I guess in your case it was having OFXHEADER:100 and VERSION:102. I think 
that's all that changed between your last failed run and the successful one.

Regards,
John Ralls

> On Mar 18, 2020, at 5:21 PM, Chris Graves  wrote:
> 
> John,
> 
> You are probably right, but here is an excerpt from the working ofx.log file, 
> so I guess I'm not sure what enabled this progress:
> Sending:
> -
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:102
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:20200318152018.000
> 
> 
> 
> 
> 20200318152011.000
> xxx
> xx
> ENG
> 
> KINECTA
> 322278073
> 
> 
> On Wed, Mar 18, 2020 at 5:10 PM John Ralls  wrote:
> Chris,
> 
> You have it backwards: Martin changed LANG -> LANGUAGE because that's what 
> AQB5 used.
> 
> However, I just tested on a bank account at USAA and that worked, except that 
> it crashed GnuCash when trying to process the new transactions. That's 
> probably not AQBanking's doing and I'll look into that separately.
> 
> Next I'll try Martin's command-line test.
> 
> Regards,
> John Ralls
> 
> 
> > On Mar 18, 2020, at 4:57 PM, Chris Graves  wrote:
> > 
> > John,
> > 
> > In your ofx.log file it still says LANGUAGE instead of LANG.  Mine says 
> > LANG, which is what Martin just fixed.
> > 
> > On Wed, Mar 18, 2020 at 4:54 PM John Ralls  wrote:
> > Progress indeed, though still not enough for USAA. :-(
> > 
> > Regards,
> > John Ralls
> > 
> > 
> > > On Mar 18, 2020, at 4:48 PM, Chris Graves  wrote:
> > > 
> > > Wow! making serious progress now.  I was requesting transactions from my 
> > > checking account.  Looking at the ofx.log file, they were returned!!!
> > > 
> > > However the import process indicated that there were no transactions to 
> > > be imported.
> > > 
> > > On Wed, Mar 18, 2020 at 4:32 PM Martin Preuss  wrote:
> > > Hi,
> > > 
> > > I just checked in another change... While comparing your logs I found
> > > that aqb6 uses "LANG" while aqb5 used the correct name "LANGUAGE".
> > > 
> > > Also, added "CLTCOOKIE" (was set by aqb5 but missing in aqb6).
> > > 
> > > Also, I noticed that aqb5 included "BANKID" which you log from aqb6
> > > didn't contain that line...
> > > 
> > > However, I think the unexpected element "LANG" (instead of "LANGUAGE")
> > > was what made the server reject the request due to syntax error...
> > > 
> > > Fixed in git.
> > > 
> > > 
> > > Regards
> > > Martin
> > > 
> > > 
> > > Am 19.03.20 um 00:26 schrieb John Ralls:
> > > > That's what mine says:
> > > > char flags="forceSsl3", "sendShortDate"
> > > > char bankName="USAA Federal Savings Bank"
> > > > char org="USAA"
> > > > char fid="24591"
> > > > char serverAddr="https%3A%2F%2Fservice2.usaa.com%2Fofx%2FOFXServlet"
> > > > char appId="QWIN"
> > > > char appVer="2300"
> > > > char headerVer="102"
> > > > int  httpVMajor="0"
> > > > int  httpVMinor="0"
> > > >   }
> > > > 
> > > > Regards,
> > > > John Ralls
> > > > 
> > > > 
> > > >> On Mar 18, 2020, at 4:15 PM, Martin Preuss  wrote:
> > > >>
> > > >> Hmm, maybe the server is picky about the HTTP version? Some servers
> > > >> are... That can currently only be changed directly in the configuration
> > > >> file:
> > > >>
> > > >> $HOME/.aqbanking/settings6/users/*.conf
> > > >>
> > > >> Some servers only accept httpVMinor="0"...
> > > >>
> > > >>
> > > >> Regards
> > > >> Martin
> > > >>
> > > >>
> > > >>
> > > >> Am 18.03.20 um 23:20 schrieb John Ralls:
> > > >>> Sigh, that's not it either:
> > > >>> Sending:
> > > >>> -
> > > >>> OFXHEADER:100
> > > >>> DATA:OFXSGML
> > > >>> VERSION:102
> > > >>> SECURITY:NONE
> > > >>> ENCODING:USASCII
> > > >>> CHARSET:1252
> > > >>> COMPRESSION:NONE
> > > >>> OLDFILEUID:NONE
> > > >>> NEWFILEUID:20200318151247.000
> > > >> [...]
> > > >>
> > > >> -- 
> > > >> "Things are only impossible until they're not"
> > > > 
> > > 
> > > 
> > > -- 
> > > "Things are only impossible until they're not"
> > 
> 

___
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.

Re: [GNC] AQBanking OFX DirectConnect

[Chris Graves]

John,

You are probably right, but here is an excerpt from the working ofx.log
file, so I guess I'm not sure what enabled this progress:
Sending:
-
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:20200318152018.000




20200318152011.000
xxx
xx
ENG

KINECTA
322278073


On Wed, Mar 18, 2020 at 5:10 PM John Ralls  wrote:

> Chris,
>
> You have it backwards: Martin changed LANG -> LANGUAGE because that's what
> AQB5 used.
>
> However, I just tested on a bank account at USAA and that worked, except
> that it crashed GnuCash when trying to process the new transactions. That's
> probably not AQBanking's doing and I'll look into that separately.
>
> Next I'll try Martin's command-line test.
>
> Regards,
> John Ralls
>
>
> > On Mar 18, 2020, at 4:57 PM, Chris Graves  wrote:
> >
> > John,
> >
> > In your ofx.log file it still says LANGUAGE instead of LANG.  Mine says
> LANG, which is what Martin just fixed.
> >
> > On Wed, Mar 18, 2020 at 4:54 PM John Ralls  wrote:
> > Progress indeed, though still not enough for USAA. :-(
> >
> > Regards,
> > John Ralls
> >
> >
> > > On Mar 18, 2020, at 4:48 PM, Chris Graves 
> wrote:
> > >
> > > Wow! making serious progress now.  I was requesting transactions from
> my checking account.  Looking at the ofx.log file, they were returned!!!
> > >
> > > However the import process indicated that there were no transactions
> to be imported.
> > >
> > > On Wed, Mar 18, 2020 at 4:32 PM Martin Preuss 
> wrote:
> > > Hi,
> > >
> > > I just checked in another change... While comparing your logs I found
> > > that aqb6 uses "LANG" while aqb5 used the correct name "LANGUAGE".
> > >
> > > Also, added "CLTCOOKIE" (was set by aqb5 but missing in aqb6).
> > >
> > > Also, I noticed that aqb5 included "BANKID" which you log from aqb6
> > > didn't contain that line...
> > >
> > > However, I think the unexpected element "LANG" (instead of "LANGUAGE")
> > > was what made the server reject the request due to syntax error...
> > >
> > > Fixed in git.
> > >
> > >
> > > Regards
> > > Martin
> > >
> > >
> > > Am 19.03.20 um 00:26 schrieb John Ralls:
> > > > That's what mine says:
> > > > char flags="forceSsl3", "sendShortDate"
> > > > char bankName="USAA Federal Savings Bank"
> > > > char org="USAA"
> > > > char fid="24591"
> > > > char serverAddr="https%3A%2F%2Fservice2.usaa.com
> %2Fofx%2FOFXServlet"
> > > > char appId="QWIN"
> > > > char appVer="2300"
> > > > char headerVer="102"
> > > > int  httpVMajor="0"
> > > > int  httpVMinor="0"
> > > >   }
> > > >
> > > > Regards,
> > > > John Ralls
> > > >
> > > >
> > > >> On Mar 18, 2020, at 4:15 PM, Martin Preuss 
> wrote:
> > > >>
> > > >> Hmm, maybe the server is picky about the HTTP version? Some servers
> > > >> are... That can currently only be changed directly in the
> configuration
> > > >> file:
> > > >>
> > > >> $HOME/.aqbanking/settings6/users/*.conf
> > > >>
> > > >> Some servers only accept httpVMinor="0"...
> > > >>
> > > >>
> > > >> Regards
> > > >> Martin
> > > >>
> > > >>
> > > >>
> > > >> Am 18.03.20 um 23:20 schrieb John Ralls:
> > > >>> Sigh, that's not it either:
> > > >>> Sending:
> > > >>> -
> > > >>> OFXHEADER:100
> > > >>> DATA:OFXSGML
> > > >>> VERSION:102
> > > >>> SECURITY:NONE
> > > >>> ENCODING:USASCII
> > > >>> CHARSET:1252
> > > >>> COMPRESSION:NONE
> > > >>> OLDFILEUID:NONE
> > > >>> NEWFILEUID:20200318151247.000
> > > >> [...]
> > > >>
> > > >> --
> > > >> "Things are only impossible until they're not"
> > > >
> > >
> > >
> > > --
> > > "Things are only impossible until they're not"
> >
>
>
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[John Ralls]

That did it!

Now to that crash.

Regards,
John Ralls

> On Mar 18, 2020, at 5:06 PM, Martin Preuss  wrote:
> 
> So the only remaining difference is the line "bankid" which wasn't in
> the aqb5 log.
> 
> Just applied a change to the git repository to change that...
> 
> 
> Regards
> Martin
> 
> 
> Am 19.03.20 um 00:53 schrieb John Ralls:
>> Nope:
>> Connected.
>> Sending message...
>> Message sent.
>> Waiting for response...
>> Receiving response...
>> HTTP-Status: 400 (Bad Request)
>> Unlocking customer "8"
>> 
>> Sending:
>> -
>> OFXHEADER:100
>> DATA:OFXSGML
>> VERSION:102
>> SECURITY:NONE
>> ENCODING:USASCII
>> CHARSET:1252
>> COMPRESSION:NONE
>> OLDFILEUID:NONE
>> NEWFILEUID:20200318164314.000
>> 
>> 
>> 
>> 
>> 20200318164310
>> 
>> 
>> ENG
>> 
>> USAA
>> 24591
>> 
>> QWIN
>> 2300
>> 
>> 
>> 
>> 
>> 20200318164314
>> 1
>> 
>> 
>> 24591
>> XX
>> 
>> 
>> 2020030900
>> 2020031800
>> Y
>> 
>> 
>> 
>> 
>> 
>> 
>> Taking out the \r\n's doesn't help either.
>> 
>> Regards,
>> John Ralls
>> 
>>> On Mar 18, 2020, at 4:32 PM, Martin Preuss  wrote:
>>> 
>>> Hi,
>>> 
>>> I just checked in another change... While comparing your logs I found
>>> that aqb6 uses "LANG" while aqb5 used the correct name "LANGUAGE".
>>> 
>>> Also, added "CLTCOOKIE" (was set by aqb5 but missing in aqb6).
>>> 
>>> Also, I noticed that aqb5 included "BANKID" which you log from aqb6
>>> didn't contain that line...
>>> 
>>> However, I think the unexpected element "LANG" (instead of "LANGUAGE")
>>> was what made the server reject the request due to syntax error...
>>> 
>>> Fixed in git.
>>> 
>> 
> 
> 
> -- 
> "Things are only impossible until they're not"

___
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.

Re: [GNC] AQBanking OFX DirectConnect

[John Ralls]

Chris,

You have it backwards: Martin changed LANG -> LANGUAGE because that's what AQB5 
used.

However, I just tested on a bank account at USAA and that worked, except that 
it crashed GnuCash when trying to process the new transactions. That's probably 
not AQBanking's doing and I'll look into that separately.

Next I'll try Martin's command-line test.

Regards,
John Ralls


> On Mar 18, 2020, at 4:57 PM, Chris Graves  wrote:
> 
> John,
> 
> In your ofx.log file it still says LANGUAGE instead of LANG.  Mine says LANG, 
> which is what Martin just fixed.
> 
> On Wed, Mar 18, 2020 at 4:54 PM John Ralls  wrote:
> Progress indeed, though still not enough for USAA. :-(
> 
> Regards,
> John Ralls
> 
> 
> > On Mar 18, 2020, at 4:48 PM, Chris Graves  wrote:
> > 
> > Wow! making serious progress now.  I was requesting transactions from my 
> > checking account.  Looking at the ofx.log file, they were returned!!!
> > 
> > However the import process indicated that there were no transactions to be 
> > imported.
> > 
> > On Wed, Mar 18, 2020 at 4:32 PM Martin Preuss  wrote:
> > Hi,
> > 
> > I just checked in another change... While comparing your logs I found
> > that aqb6 uses "LANG" while aqb5 used the correct name "LANGUAGE".
> > 
> > Also, added "CLTCOOKIE" (was set by aqb5 but missing in aqb6).
> > 
> > Also, I noticed that aqb5 included "BANKID" which you log from aqb6
> > didn't contain that line...
> > 
> > However, I think the unexpected element "LANG" (instead of "LANGUAGE")
> > was what made the server reject the request due to syntax error...
> > 
> > Fixed in git.
> > 
> > 
> > Regards
> > Martin
> > 
> > 
> > Am 19.03.20 um 00:26 schrieb John Ralls:
> > > That's what mine says:
> > > char flags="forceSsl3", "sendShortDate"
> > > char bankName="USAA Federal Savings Bank"
> > > char org="USAA"
> > > char fid="24591"
> > > char serverAddr="https%3A%2F%2Fservice2.usaa.com%2Fofx%2FOFXServlet"
> > > char appId="QWIN"
> > > char appVer="2300"
> > > char headerVer="102"
> > > int  httpVMajor="0"
> > > int  httpVMinor="0"
> > >   }
> > > 
> > > Regards,
> > > John Ralls
> > > 
> > > 
> > >> On Mar 18, 2020, at 4:15 PM, Martin Preuss  wrote:
> > >>
> > >> Hmm, maybe the server is picky about the HTTP version? Some servers
> > >> are... That can currently only be changed directly in the configuration
> > >> file:
> > >>
> > >> $HOME/.aqbanking/settings6/users/*.conf
> > >>
> > >> Some servers only accept httpVMinor="0"...
> > >>
> > >>
> > >> Regards
> > >> Martin
> > >>
> > >>
> > >>
> > >> Am 18.03.20 um 23:20 schrieb John Ralls:
> > >>> Sigh, that's not it either:
> > >>> Sending:
> > >>> -
> > >>> OFXHEADER:100
> > >>> DATA:OFXSGML
> > >>> VERSION:102
> > >>> SECURITY:NONE
> > >>> ENCODING:USASCII
> > >>> CHARSET:1252
> > >>> COMPRESSION:NONE
> > >>> OLDFILEUID:NONE
> > >>> NEWFILEUID:20200318151247.000
> > >> [...]
> > >>
> > >> -- 
> > >> "Things are only impossible until they're not"
> > > 
> > 
> > 
> > -- 
> > "Things are only impossible until they're not"
> 

___
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.

Re: [GNC] AQBanking OFX DirectConnect

[Martin Preuss]

So the only remaining difference is the line "bankid" which wasn't in
the aqb5 log.

Just applied a change to the git repository to change that...


Regards
Martin


Am 19.03.20 um 00:53 schrieb John Ralls:
> Nope:
> Connected.
> Sending message...
> Message sent.
> Waiting for response...
> Receiving response...
> HTTP-Status: 400 (Bad Request)
> Unlocking customer "8"
> 
> Sending:
> -
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:102
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:20200318164314.000
> 
> 
> 
> 
> 20200318164310
> 
> 
> ENG
> 
> USAA
> 24591
> 
> QWIN
> 2300
> 
> 
> 
> 
> 20200318164314
> 1
> 
> 
> 24591
> XX
> 
> 
> 2020030900
> 2020031800
> Y
> 
> 
> 
> 
> 
> 
> Taking out the \r\n's doesn't help either.
> 
> Regards,
> John Ralls
> 
>> On Mar 18, 2020, at 4:32 PM, Martin Preuss  wrote:
>>
>> Hi,
>>
>> I just checked in another change... While comparing your logs I found
>> that aqb6 uses "LANG" while aqb5 used the correct name "LANGUAGE".
>>
>> Also, added "CLTCOOKIE" (was set by aqb5 but missing in aqb6).
>>
>> Also, I noticed that aqb5 included "BANKID" which you log from aqb6
>> didn't contain that line...
>>
>> However, I think the unexpected element "LANG" (instead of "LANGUAGE")
>> was what made the server reject the request due to syntax error...
>>
>> Fixed in git.
>>
> 


-- 
"Things are only impossible until they're not"
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[Martin Preuss]

I changed aqb6 to use "LANGUAGE" like aqb5 did, because that is the
correct name (don't know where I read "LANG", I guess that was in
another protocol...)

According to the specs (1.6) "LANGUAGE" should be used.


Regards
Martin



Am 19.03.20 um 00:57 schrieb Chris Graves:
> John,
> 
> In your ofx.log file it still says LANGUAGE instead of LANG.  Mine says
> LANG, which is what Martin just fixed.
> 
> On Wed, Mar 18, 2020 at 4:54 PM John Ralls  > wrote:
> 
> Progress indeed, though still not enough for USAA. :-(
> 
> Regards,
> John Ralls
> 
> 
> > On Mar 18, 2020, at 4:48 PM, Chris Graves  > wrote:
> >
> > Wow! making serious progress now.  I was requesting transactions
> from my checking account.  Looking at the ofx.log file, they were
> returned!!!
> >
> > However the import process indicated that there were no
> transactions to be imported.
> >
> > On Wed, Mar 18, 2020 at 4:32 PM Martin Preuss  > wrote:
> > Hi,
> >
> > I just checked in another change... While comparing your logs I found
> > that aqb6 uses "LANG" while aqb5 used the correct name "LANGUAGE".
> >
> > Also, added "CLTCOOKIE" (was set by aqb5 but missing in aqb6).
> >
> > Also, I noticed that aqb5 included "BANKID" which you log from aqb6
> > didn't contain that line...
> >
> > However, I think the unexpected element "LANG" (instead of "LANGUAGE")
> > was what made the server reject the request due to syntax error...
> >
> > Fixed in git.
> >
> >
> > Regards
> > Martin
> >
> >
> > Am 19.03.20 um 00:26 schrieb John Ralls:
> > > That's what mine says:
> > >     char flags="forceSsl3", "sendShortDate"
> > >     char bankName="USAA Federal Savings Bank"
> > >     char org="USAA"
> > >     char fid="24591"
> > >     char serverAddr="https%3A%2F%2Fservice2.usaa.com
> %2Fofx%2FOFXServlet"
> > >     char appId="QWIN"
> > >     char appVer="2300"
> > >     char headerVer="102"
> > >     int  httpVMajor="0"
> > >     int  httpVMinor="0"
> > >   }
> > >
> > > Regards,
> > > John Ralls
> > >
> > >
> > >> On Mar 18, 2020, at 4:15 PM, Martin Preuss  > wrote:
> > >>
> > >> Hmm, maybe the server is picky about the HTTP version? Some servers
> > >> are... That can currently only be changed directly in the
> configuration
> > >> file:
> > >>
> > >> $HOME/.aqbanking/settings6/users/*.conf
> > >>
> > >> Some servers only accept httpVMinor="0"...
> > >>
> > >>
> > >> Regards
> > >> Martin
> > >>
> > >>
> > >>
> > >> Am 18.03.20 um 23:20 schrieb John Ralls:
> > >>> Sigh, that's not it either:
> > >>> Sending:
> > >>> -
> > >>> OFXHEADER:100
> > >>> DATA:OFXSGML
> > >>> VERSION:102
> > >>> SECURITY:NONE
> > >>> ENCODING:USASCII
> > >>> CHARSET:1252
> > >>> COMPRESSION:NONE
> > >>> OLDFILEUID:NONE
> > >>> NEWFILEUID:20200318151247.000
> > >> [...]
> > >>
> > >> --
> > >> "Things are only impossible until they're not"
> > >
> >
> >
> > --
> > "Things are only impossible until they're not"
> 


-- 
"Things are only impossible until they're not"
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[Chris Graves]

John,

In your ofx.log file it still says LANGUAGE instead of LANG.  Mine says
LANG, which is what Martin just fixed.

On Wed, Mar 18, 2020 at 4:54 PM John Ralls  wrote:

> Progress indeed, though still not enough for USAA. :-(
>
> Regards,
> John Ralls
>
>
> > On Mar 18, 2020, at 4:48 PM, Chris Graves  wrote:
> >
> > Wow! making serious progress now.  I was requesting transactions from my
> checking account.  Looking at the ofx.log file, they were returned!!!
> >
> > However the import process indicated that there were no transactions to
> be imported.
> >
> > On Wed, Mar 18, 2020 at 4:32 PM Martin Preuss 
> wrote:
> > Hi,
> >
> > I just checked in another change... While comparing your logs I found
> > that aqb6 uses "LANG" while aqb5 used the correct name "LANGUAGE".
> >
> > Also, added "CLTCOOKIE" (was set by aqb5 but missing in aqb6).
> >
> > Also, I noticed that aqb5 included "BANKID" which you log from aqb6
> > didn't contain that line...
> >
> > However, I think the unexpected element "LANG" (instead of "LANGUAGE")
> > was what made the server reject the request due to syntax error...
> >
> > Fixed in git.
> >
> >
> > Regards
> > Martin
> >
> >
> > Am 19.03.20 um 00:26 schrieb John Ralls:
> > > That's what mine says:
> > > char flags="forceSsl3", "sendShortDate"
> > > char bankName="USAA Federal Savings Bank"
> > > char org="USAA"
> > > char fid="24591"
> > > char serverAddr="https%3A%2F%2Fservice2.usaa.com
> %2Fofx%2FOFXServlet"
> > > char appId="QWIN"
> > > char appVer="2300"
> > > char headerVer="102"
> > > int  httpVMajor="0"
> > > int  httpVMinor="0"
> > >   }
> > >
> > > Regards,
> > > John Ralls
> > >
> > >
> > >> On Mar 18, 2020, at 4:15 PM, Martin Preuss 
> wrote:
> > >>
> > >> Hmm, maybe the server is picky about the HTTP version? Some servers
> > >> are... That can currently only be changed directly in the
> configuration
> > >> file:
> > >>
> > >> $HOME/.aqbanking/settings6/users/*.conf
> > >>
> > >> Some servers only accept httpVMinor="0"...
> > >>
> > >>
> > >> Regards
> > >> Martin
> > >>
> > >>
> > >>
> > >> Am 18.03.20 um 23:20 schrieb John Ralls:
> > >>> Sigh, that's not it either:
> > >>> Sending:
> > >>> -
> > >>> OFXHEADER:100
> > >>> DATA:OFXSGML
> > >>> VERSION:102
> > >>> SECURITY:NONE
> > >>> ENCODING:USASCII
> > >>> CHARSET:1252
> > >>> COMPRESSION:NONE
> > >>> OLDFILEUID:NONE
> > >>> NEWFILEUID:20200318151247.000
> > >> [...]
> > >>
> > >> --
> > >> "Things are only impossible until they're not"
> > >
> >
> >
> > --
> > "Things are only impossible until they're not"
>
>
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[Martin Preuss]

Okay, we should now look for console logs.
I'm not sure how Gnucash handles log files, but you could try the
process of requesting statements using console-only:


1. get list of accounts:
# aqbanking-cli listaccounts
Column 6 contains the unique account id to be used in the next step.

2. get statements for an account with debug output
# AQOFXCONNECT_LOGLEVEL=info aqbanking-cli request --aid=UNIQUEID
--transactions --fromdate=20200301
-c OUTPUTFILE.ctx

3. Look into the file OUTPUTFILE.ctx: Does it contain transactions? If
not: Is there any helpfull output on the console?


Regards
Martin


Am 19.03.20 um 00:48 schrieb Chris Graves:
> Wow! making serious progress now.  I was requesting transactions from my
> checking account.  Looking at the ofx.log file, they were returned!!!
> 
> However the import process indicated that there were no transactions to
> be imported.
[...]

-- 
"Things are only impossible until they're not"
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[Chris Graves]

Interesting, there were 8 Sending requests and 3 Received responses.  Looks
like transactions were returned duplicated 3 times.

On Wed, Mar 18, 2020 at 4:46 PM Martin Preuss  wrote:

>
> the OFX specs show this example:
>
> -X8
> POST http://www.fi.com/ofx.cgi HTTP/1.0
> User-Agent:MyApp 5.0
> Content-Type: application/x-ofx
> Content-Length: 1032
>
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:160
> SECURITY:TYPE1
> ENCODING:USASCII
> CHARSET:NONE
> COMPRESSION:NONE
> NEWFILEUID:NONE
> OLDFILEUID:NONE
>
> 
> ... Open Financial Exchange requests ...
> 
> -X8
>
> or, in a table:
>
> -X8
> HTTP headers
> CRLF(s)
> MIME type information
> CRLF(s)
> OFX header element 1
> CRLF
> OFX header element 2
> CRLF
> OFX header element n
> CRLF(s)
> OFX SGML Block
> -X8
>
> Well, the table isn't that helpfull...
> But the specs also state that all elements - http headers, OFX headers
> and OFX request - should be separated by a blank line from each other...
>
>
> Regards
> Martin
>
>
>
> --
> "Things are only impossible until they're not"
> ___
> 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.

Re: [GNC] AQBanking OFX DirectConnect

[John Ralls]

Progress indeed, though still not enough for USAA. :-(

Regards,
John Ralls


> On Mar 18, 2020, at 4:48 PM, Chris Graves  wrote:
> 
> Wow! making serious progress now.  I was requesting transactions from my 
> checking account.  Looking at the ofx.log file, they were returned!!!
> 
> However the import process indicated that there were no transactions to be 
> imported.
> 
> On Wed, Mar 18, 2020 at 4:32 PM Martin Preuss  wrote:
> Hi,
> 
> I just checked in another change... While comparing your logs I found
> that aqb6 uses "LANG" while aqb5 used the correct name "LANGUAGE".
> 
> Also, added "CLTCOOKIE" (was set by aqb5 but missing in aqb6).
> 
> Also, I noticed that aqb5 included "BANKID" which you log from aqb6
> didn't contain that line...
> 
> However, I think the unexpected element "LANG" (instead of "LANGUAGE")
> was what made the server reject the request due to syntax error...
> 
> Fixed in git.
> 
> 
> Regards
> Martin
> 
> 
> Am 19.03.20 um 00:26 schrieb John Ralls:
> > That's what mine says:
> > char flags="forceSsl3", "sendShortDate"
> > char bankName="USAA Federal Savings Bank"
> > char org="USAA"
> > char fid="24591"
> > char serverAddr="https%3A%2F%2Fservice2.usaa.com%2Fofx%2FOFXServlet"
> > char appId="QWIN"
> > char appVer="2300"
> > char headerVer="102"
> > int  httpVMajor="0"
> > int  httpVMinor="0"
> >   }
> > 
> > Regards,
> > John Ralls
> > 
> > 
> >> On Mar 18, 2020, at 4:15 PM, Martin Preuss  wrote:
> >>
> >> Hmm, maybe the server is picky about the HTTP version? Some servers
> >> are... That can currently only be changed directly in the configuration
> >> file:
> >>
> >> $HOME/.aqbanking/settings6/users/*.conf
> >>
> >> Some servers only accept httpVMinor="0"...
> >>
> >>
> >> Regards
> >> Martin
> >>
> >>
> >>
> >> Am 18.03.20 um 23:20 schrieb John Ralls:
> >>> Sigh, that's not it either:
> >>> Sending:
> >>> -
> >>> OFXHEADER:100
> >>> DATA:OFXSGML
> >>> VERSION:102
> >>> SECURITY:NONE
> >>> ENCODING:USASCII
> >>> CHARSET:1252
> >>> COMPRESSION:NONE
> >>> OLDFILEUID:NONE
> >>> NEWFILEUID:20200318151247.000
> >> [...]
> >>
> >> -- 
> >> "Things are only impossible until they're not"
> > 
> 
> 
> -- 
> "Things are only impossible until they're not"

___
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.

Re: [GNC] AQBanking OFX DirectConnect

[John Ralls]

Nope:
Connected.
Sending message...
Message sent.
Waiting for response...
Receiving response...
HTTP-Status: 400 (Bad Request)
Unlocking customer "8"

Sending:
-
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:20200318164314.000




20200318164310


ENG

USAA
24591

QWIN
2300




20200318164314
1


24591
XX


2020030900
2020031800
Y






Taking out the \r\n's doesn't help either.

Regards,
John Ralls

> On Mar 18, 2020, at 4:32 PM, Martin Preuss  wrote:
> 
> Hi,
> 
> I just checked in another change... While comparing your logs I found
> that aqb6 uses "LANG" while aqb5 used the correct name "LANGUAGE".
> 
> Also, added "CLTCOOKIE" (was set by aqb5 but missing in aqb6).
> 
> Also, I noticed that aqb5 included "BANKID" which you log from aqb6
> didn't contain that line...
> 
> However, I think the unexpected element "LANG" (instead of "LANGUAGE")
> was what made the server reject the request due to syntax error...
> 
> Fixed in git.
> 

___
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.

Re: [GNC] AQBanking OFX DirectConnect

[Chris Graves]

Wow! making serious progress now.  I was requesting transactions from my
checking account.  Looking at the ofx.log file, they were returned!!!

However the import process indicated that there were no transactions to be
imported.

On Wed, Mar 18, 2020 at 4:32 PM Martin Preuss  wrote:

> Hi,
>
> I just checked in another change... While comparing your logs I found
> that aqb6 uses "LANG" while aqb5 used the correct name "LANGUAGE".
>
> Also, added "CLTCOOKIE" (was set by aqb5 but missing in aqb6).
>
> Also, I noticed that aqb5 included "BANKID" which you log from aqb6
> didn't contain that line...
>
> However, I think the unexpected element "LANG" (instead of "LANGUAGE")
> was what made the server reject the request due to syntax error...
>
> Fixed in git.
>
>
> Regards
> Martin
>
>
> Am 19.03.20 um 00:26 schrieb John Ralls:
> > That's what mine says:
> > char flags="forceSsl3", "sendShortDate"
> > char bankName="USAA Federal Savings Bank"
> > char org="USAA"
> > char fid="24591"
> > char serverAddr="https%3A%2F%2Fservice2.usaa.com%2Fofx%2FOFXServlet"
> > char appId="QWIN"
> > char appVer="2300"
> > char headerVer="102"
> > int  httpVMajor="0"
> > int  httpVMinor="0"
> >   }
> >
> > Regards,
> > John Ralls
> >
> >
> >> On Mar 18, 2020, at 4:15 PM, Martin Preuss  wrote:
> >>
> >> Hmm, maybe the server is picky about the HTTP version? Some servers
> >> are... That can currently only be changed directly in the configuration
> >> file:
> >>
> >> $HOME/.aqbanking/settings6/users/*.conf
> >>
> >> Some servers only accept httpVMinor="0"...
> >>
> >>
> >> Regards
> >> Martin
> >>
> >>
> >>
> >> Am 18.03.20 um 23:20 schrieb John Ralls:
> >>> Sigh, that's not it either:
> >>> Sending:
> >>> -
> >>> OFXHEADER:100
> >>> DATA:OFXSGML
> >>> VERSION:102
> >>> SECURITY:NONE
> >>> ENCODING:USASCII
> >>> CHARSET:1252
> >>> COMPRESSION:NONE
> >>> OLDFILEUID:NONE
> >>> NEWFILEUID:20200318151247.000
> >> [...]
> >>
> >> --
> >> "Things are only impossible until they're not"
> >
>
>
> --
> "Things are only impossible until they're not"
>
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[Martin Preuss]

the OFX specs show this example:

-X8
POST http://www.fi.com/ofx.cgi HTTP/1.0
User-Agent:MyApp 5.0
Content-Type: application/x-ofx
Content-Length: 1032

OFXHEADER:100
DATA:OFXSGML
VERSION:160
SECURITY:TYPE1
ENCODING:USASCII
CHARSET:NONE
COMPRESSION:NONE
NEWFILEUID:NONE
OLDFILEUID:NONE


... Open Financial Exchange requests ...

-X8

or, in a table:

-X8
HTTP headers
CRLF(s)
MIME type information
CRLF(s)
OFX header element 1
CRLF
OFX header element 2
CRLF
OFX header element n
CRLF(s)
OFX SGML Block
-X8

Well, the table isn't that helpfull...
But the specs also state that all elements - http headers, OFX headers
and OFX request - should be separated by a blank line from each other...


Regards
Martin



-- 
"Things are only impossible until they're not"
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[John Ralls]

I did
--- a/src/libs/plugins/backends/aqofxconnect/v1/r_statements.c
+++ b/src/libs/plugins/backends/aqofxconnect/v1/r_statements.c
@@ -77,7 +77,7 @@ int AO_V1_RequestStatements(AB_PROVIDER *pro, AB_USER *u, 
AB_ACCOUNT *a, AB_TRAN
   }
   GWEN_XMLNode_free(xmlRoot);

-#if 0
+#if 1
   DBG_ERROR(AQOFXCONNECT_LOGDOMAIN, "OFX request:");
   fprintf(stderr, "%s\n", GWEN_Buffer_GetStart(bufRequest));
   GWEN_Text_LogString(GWEN_Buffer_GetStart(bufRequest),
@@ -99,7 +99,7 @@ int AO_V1_RequestStatements(AB_PROVIDER *pro, AB_USER *u, 
AB_ACCOUNT *a, AB_TRAN
   GWEN_Buffer_free(bufRequest);


-#if 0
+#if 1
   DBG_ERROR(AQOFXCONNECT_LOGDOMAIN, "OFX response:");
   GWEN_Text_LogString(GWEN_Buffer_GetStart(bufResponse),
   GWEN_Buffer_GetUsedBytes(bufResponse),

to get some more out of the logs. That inserted the exact same string as in 
ofx.log, which is good, but with GWEN_LOGLEVEL=debug the next bit of the log is
* 15:22:21 ERROR  io_network.c:  165: Saving OFX log to 
"/tmp/ofx.log" ...
7:2020/03/18 
15-22-21:gwen(83151):/Users/john/Development/Gnucash-Build/Gnucash-3/src/gwenhywfar-5.2.0/src/parser/urlfns.c:
  123: Server: [service2.usaa.com]
7:2020/03/18 
15-22-21:gwen(83151):/Users/john/Development/Gnucash-Build/Gnucash-3/src/gwenhywfar-5.2.0/src/parser/urlfns.c:
  176: Path: [/ofx/OFXServlet]
7:2020/03/18 
15-22-21:gwen(83151):/Users/john/Development/Gnucash-Build/Gnucash-3/src/gwenhywfar-5.2.0/src/parser/urlfns.c:
  123: Server: [service2.usaa.com]
7:2020/03/18 
15-22-21:gwen(83151):/Users/john/Development/Gnucash-Build/Gnucash-3/src/gwenhywfar-5.2.0/src/parser/urlfns.c:
  176: Path: [/ofx/OFXServlet]
7:2020/03/18 15-22-21:gwen(83151):String size is 31
7:2020/03/18 15-22-21:gwen(83151):: 50 4f 53 54 20 2f 6f 66 78 2f 4f 46 58 
53 65 72 POST /ofx/OFXSer
7:2020/03/18 15-22-21:gwen(83151):0010: 76 6c 65 74 20 48 54 54 50 2f 31 2e 30 
0d 0avlet HTTP/1.0..
7:2020/03/18 15-22-21:gwen(83151):String size is 159
7:2020/03/18 15-22-21:gwen(83151):: 48 6f 73 74 3a 73 65 72 76 69 63 65 32 
2e 75 73 Host:service2.us
7:2020/03/18 15-22-21:gwen(83151):0010: 61 61 2e 63 6f 6d 0d 0a 43 6f 6e 6e 65 
63 74 69 aa.com..Connecti
7:2020/03/18 15-22-21:gwen(83151):0020: 6f 6e 3a 63 6c 6f 73 65 0d 0a 50 72 61 
67 6d 61 on:close..Pragma
7:2020/03/18 15-22-21:gwen(83151):0030: 3a 6e 6f 2d 63 61 63 68 65 0d 0a 43 61 
63 68 65 :no-cache..Cache
7:2020/03/18 15-22-21:gwen(83151):0040: 2d 63 6f 6e 74 72 6f 6c 3a 6e 6f 20 63 
61 63 68 -control:no cach
7:2020/03/18 15-22-21:gwen(83151):0050: 65 0d 0a 43 6f 6e 74 65 6e 74 2d 74 79 
70 65 3a e..Content-type:
7:2020/03/18 15-22-21:gwen(83151):0060: 61 70 70 6c 69 63 61 74 69 6f 6e 2f 78 
2d 6f 66 application/x-of
7:2020/03/18 15-22-21:gwen(83151):0070: 78 0d 0a 55 73 65 72 2d 41 67 65 6e 74 
3a 41 71 x..User-Agent:Aq
7:2020/03/18 15-22-21:gwen(83151):0080: 42 61 6e 6b 69 6e 67 0d 0a 43 6f 6e 74 
65 6e 74 Banking..Content
7:2020/03/18 15-22-21:gwen(83151):0090: 2d 6c 65 6e 67 74 68 3a 35 37 35 0d 0a 
0d 0a-length:575
7:2020/03/18 15-22-21:gwen(83151):String size is 25
7:2020/03/18 15-22-21:gwen(83151):: 48 54 54 50 2f 31 2e 30 20 34 30 30 20 
42 61 64 HTTP/1.0 400 Bad
7:2020/03/18 15-22-21:gwen(83151):0010: 20 52 65 71 75 65 73 74 00  
 Request.
:

Should there be two \n\r after the length header and is it supposed to log the 
request content? Unfortunately Gwen4 doesn't emit anything useful for 
comparison.

Regards,
John Ralls

> On Mar 18, 2020, at 3:20 PM, John Ralls  wrote:
> 
> Sigh, that's not it either:
> Sending:
> -
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:102
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:20200318151247.000
> 
> 20200318151243XXENGUSAA24591QWIN23002020031815124724591XXX20200309002020031800Y
> 
> and a 400.
> 
> Regards,
> John Ralls
> 
> 
>> On Mar 18, 2020, at 3:08 PM, Martin Preuss  wrote:
>> 
>> Hi,
>> 
>> hmm, so no linebreaks...
>> 
>> Could either of you please try with the following lines commented out in
>> v1/n_toofx.c:
>> - 105:   if (hasSubTags)
>> - 106: GWEN_Buffer_AppendString(buf, "\r\n");
>> - 128:   GWEN_Buffer_AppendString(buf, "\r\n");
>> 
>> Will be back in a few mins, have to watch an episode of "Bull" on my
>> wifes request... ;-)
>> 
>> 
>> Regards
>> Martin
>> 
>> 
>> Am 18.03.20 um 23:02 schrieb John Ralls:
>>> Remember, the working ofx from AQB5 is
>>> Sending:
>>> -
>>> OFXHEADER:100
>>> DATA:OFXSGML
>>> VERSION:102
>>> SECURITY:NONE
>>> ENCODING:USASCII
>>> CHARSET:1252
>>> COMPRESSION:NONE
>>> OLDFILEUID:NONE
>>> NEWFILEUID:20200315112517.000
>>> 
>>> 20200315112517
>>> 
>>> ENGUSAA24591QWIN2300202003151125171202003140020200315112517Y
>>> 
>>> 
>>> Regards,
>>> John Ralls
>>> 
 On Mar 18, 2020, at 2:54 PM, Martin Preuss  wrote:
 
 Hi,
 
 please see my other mail (latest 

Re: [GNC] AQBanking OFX DirectConnect

[Martin Preuss]

Hi,

I just checked in another change... While comparing your logs I found
that aqb6 uses "LANG" while aqb5 used the correct name "LANGUAGE".

Also, added "CLTCOOKIE" (was set by aqb5 but missing in aqb6).

Also, I noticed that aqb5 included "BANKID" which you log from aqb6
didn't contain that line...

However, I think the unexpected element "LANG" (instead of "LANGUAGE")
was what made the server reject the request due to syntax error...

Fixed in git.


Regards
Martin


Am 19.03.20 um 00:26 schrieb John Ralls:
> That's what mine says:
> char flags="forceSsl3", "sendShortDate"
> char bankName="USAA Federal Savings Bank"
> char org="USAA"
> char fid="24591"
> char serverAddr="https%3A%2F%2Fservice2.usaa.com%2Fofx%2FOFXServlet"
> char appId="QWIN"
> char appVer="2300"
> char headerVer="102"
> int  httpVMajor="0"
> int  httpVMinor="0"
>   }
> 
> Regards,
> John Ralls
> 
> 
>> On Mar 18, 2020, at 4:15 PM, Martin Preuss  wrote:
>>
>> Hmm, maybe the server is picky about the HTTP version? Some servers
>> are... That can currently only be changed directly in the configuration
>> file:
>>
>> $HOME/.aqbanking/settings6/users/*.conf
>>
>> Some servers only accept httpVMinor="0"...
>>
>>
>> Regards
>> Martin
>>
>>
>>
>> Am 18.03.20 um 23:20 schrieb John Ralls:
>>> Sigh, that's not it either:
>>> Sending:
>>> -
>>> OFXHEADER:100
>>> DATA:OFXSGML
>>> VERSION:102
>>> SECURITY:NONE
>>> ENCODING:USASCII
>>> CHARSET:1252
>>> COMPRESSION:NONE
>>> OLDFILEUID:NONE
>>> NEWFILEUID:20200318151247.000
>> [...]
>>
>> -- 
>> "Things are only impossible until they're not"
> 


-- 
"Things are only impossible until they're not"
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[John Ralls]

That's what mine says:
char flags="forceSsl3", "sendShortDate"
char bankName="USAA Federal Savings Bank"
char org="USAA"
char fid="24591"
char serverAddr="https%3A%2F%2Fservice2.usaa.com%2Fofx%2FOFXServlet"
char appId="QWIN"
char appVer="2300"
char headerVer="102"
int  httpVMajor="0"
int  httpVMinor="0"
  }

Regards,
John Ralls


> On Mar 18, 2020, at 4:15 PM, Martin Preuss  wrote:
> 
> Hmm, maybe the server is picky about the HTTP version? Some servers
> are... That can currently only be changed directly in the configuration
> file:
> 
> $HOME/.aqbanking/settings6/users/*.conf
> 
> Some servers only accept httpVMinor="0"...
> 
> 
> Regards
> Martin
> 
> 
> 
> Am 18.03.20 um 23:20 schrieb John Ralls:
>> Sigh, that's not it either:
>> Sending:
>> -
>> OFXHEADER:100
>> DATA:OFXSGML
>> VERSION:102
>> SECURITY:NONE
>> ENCODING:USASCII
>> CHARSET:1252
>> COMPRESSION:NONE
>> OLDFILEUID:NONE
>> NEWFILEUID:20200318151247.000
> [...]
> 
> -- 
> "Things are only impossible until they're not"

___
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.

Re: [GNC] AQBanking OFX DirectConnect

[John Ralls]

Sigh, that's not it either:
Sending:
-
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:20200318151247.000

2020031815124318015524376ENGUSAA24591QWIN23002020031815124724591427082906539504520200309002020031800Y

and a 400.

Regards,
John Ralls


> On Mar 18, 2020, at 3:08 PM, Martin Preuss  wrote:
> 
> Hi,
> 
> hmm, so no linebreaks...
> 
> Could either of you please try with the following lines commented out in
> v1/n_toofx.c:
> - 105:   if (hasSubTags)
> - 106: GWEN_Buffer_AppendString(buf, "\r\n");
> - 128:   GWEN_Buffer_AppendString(buf, "\r\n");
> 
> Will be back in a few mins, have to watch an episode of "Bull" on my
> wifes request... ;-)
> 
> 
> Regards
> Martin
> 
> 
> Am 18.03.20 um 23:02 schrieb John Ralls:
>> Remember, the working ofx from AQB5 is
>> Sending:
>> -
>> OFXHEADER:100
>> DATA:OFXSGML
>> VERSION:102
>> SECURITY:NONE
>> ENCODING:USASCII
>> CHARSET:1252
>> COMPRESSION:NONE
>> OLDFILEUID:NONE
>> NEWFILEUID:20200315112517.000
>> 
>> 20200315112517
>> 
>> ENGUSAA24591QWIN2300202003151125171202003140020200315112517Y
>> 
>> 
>> Regards,
>> John Ralls
>> 
>>> On Mar 18, 2020, at 2:54 PM, Martin Preuss  wrote:
>>> 
>>> Hi,
>>> 
>>> please see my other mail (latest GIT).
>>> 
>>> Maybe "103" then (I heard of some cases where "103" was necessary)? Or
>>> perhaps "160"?
>>> 
>>> Will fix the gui btw...
>>> 
>>> 
>>> Regards
>>> Martin
>>> 
>>> Am 18.03.20 um 22:50 schrieb Chris Graves:
 Hi Martin,
 
 The GUI wouldn't let me leave that field blank, so I manually deleted
 the entry from the .conf file. Running again, it did use the defaults
 that you specified.  However, still the http 400 error and no response.
 
 Sending:
 -
 OFXHEADER:100
 DATA:OFXSGML
 VERSION:102
 SECURITY:NONE
 ENCODING:USASCII
 CHARSET:1252
 COMPRESSION:NONE
 OLDFILEUID:NONE
 NEWFILEUID:20200318144035.000
 
 On Wed, Mar 18, 2020 at 2:34 PM Martin Preuss >>> > wrote:
 
   Hi,
 
   not ATM, but that can be arranged. However, how about leaving that field
   empty in the settings dialog? That should default to 100 for OFXHEADER
   and 102 for VERSION (for - ahem - historic reasons, I'm sure I had
   good^H^H^H reasons for those mixed defaults... :-})
 
   Regards
   Martin
 
 
   Am 18.03.20 um 22:26 schrieb Chris Graves:
> Nice!  I see that the change has been made, but still receive the HTTP
> 400 error.
> 
> In the AQB5 ofx.log file for a successful case, I see
> OFXHEADER:100
> VERSION:102
> 
> In the AQB6 file, I see
> OFXHEADER:102
> VERSION:102
> 
> Not sure if this could be the problem.  Is there a way to set
   OFXHEADER
> and VERSION independently?
> 
> 
> On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss >>>   
> >> wrote:
> 
> Hi,
> 
> you can change the header manually to 102/103 in the
   homebanking setup
> dialog (select user, edit user, switch to app settings and type-in
> header version 102).
> 
> Regards
> Martin
> 
> 
> Am 18.03.20 um 21:57 schrieb Chris Graves:
>> Hi Martin,
>> 
>> Looking better!  However, to my knowledge, my bank only
   supports OFX
>> version 102 or 103.  I had been using 102.
>> 
>> ofx.log:
>> Sending:
>> -
>> OFXHEADER:220
>> DATA:OFXSGML
>> VERSION:220
>> SECURITY:NONE
>> ENCODING:USASCII
>> CHARSET:1252
>> COMPRESSION:NONE
>> OLDFILEUID:NONE
>> NEWFILEUID:20200318135033.000
>> 
>> 
>> 
>> 
>> 20200318135025.000
>> 
>> On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss
   mailto:mar...@aqbanking.de>
> >
>> 
   > 
>>Hi Chris,
>> 
>>could you please test the latest GIT version? It should
   create
> valid
>>OFXv1 requests now, however, I can't test it completely
   since
> I only
>>have access to an OFXv2 server...
>> 
>> 
>>Regards
>>Martin
>> 
>> 
>>Am 18.03.20 um 16:31 schrieb chris graves:
>>> An additional bit of information from /tmp/ofx.log:
>>> AQB5:
>>> Sending:
>>> -
>>> OFXHEADER:100
>>> DATA:OFXSGML
>>> VERSION:102
>>> SECURITY:NONE
>>> ENCODING:USASCII
>>> 

Re: [GNC] AQBanking OFX DirectConnect

[Martin Preuss]

Hi,

hmm, so no linebreaks...

Could either of you please try with the following lines commented out in
v1/n_toofx.c:
- 105:   if (hasSubTags)
- 106: GWEN_Buffer_AppendString(buf, "\r\n");
- 128:   GWEN_Buffer_AppendString(buf, "\r\n");

Will be back in a few mins, have to watch an episode of "Bull" on my
wifes request... ;-)


Regards
Martin


Am 18.03.20 um 23:02 schrieb John Ralls:
> Remember, the working ofx from AQB5 is
> Sending:
> -
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:102
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:20200315112517.000
> 
> 20200315112517
> 
> ENGUSAA24591QWIN2300202003151125171202003140020200315112517Y
> 
> 
> Regards,
> John Ralls
> 
>> On Mar 18, 2020, at 2:54 PM, Martin Preuss  wrote:
>>
>> Hi,
>>
>> please see my other mail (latest GIT).
>>
>> Maybe "103" then (I heard of some cases where "103" was necessary)? Or
>> perhaps "160"?
>>
>> Will fix the gui btw...
>>
>>
>> Regards
>> Martin
>>
>> Am 18.03.20 um 22:50 schrieb Chris Graves:
>>> Hi Martin,
>>>
>>> The GUI wouldn't let me leave that field blank, so I manually deleted
>>> the entry from the .conf file. Running again, it did use the defaults
>>> that you specified.  However, still the http 400 error and no response.
>>>
>>> Sending:
>>> -
>>> OFXHEADER:100
>>> DATA:OFXSGML
>>> VERSION:102
>>> SECURITY:NONE
>>> ENCODING:USASCII
>>> CHARSET:1252
>>> COMPRESSION:NONE
>>> OLDFILEUID:NONE
>>> NEWFILEUID:20200318144035.000
>>>
>>> On Wed, Mar 18, 2020 at 2:34 PM Martin Preuss >> > wrote:
>>>
>>>Hi,
>>>
>>>not ATM, but that can be arranged. However, how about leaving that field
>>>empty in the settings dialog? That should default to 100 for OFXHEADER
>>>and 102 for VERSION (for - ahem - historic reasons, I'm sure I had
>>>good^H^H^H reasons for those mixed defaults... :-})
>>>
>>>Regards
>>>Martin
>>>
>>>
>>>Am 18.03.20 um 22:26 schrieb Chris Graves:
 Nice!  I see that the change has been made, but still receive the HTTP
 400 error.

 In the AQB5 ofx.log file for a successful case, I see
 OFXHEADER:100
 VERSION:102

 In the AQB6 file, I see
 OFXHEADER:102
 VERSION:102

 Not sure if this could be the problem.  Is there a way to set
>>>OFXHEADER
 and VERSION independently?


 On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss >>
 >> wrote:

  Hi,

  you can change the header manually to 102/103 in the
>>>homebanking setup
  dialog (select user, edit user, switch to app settings and type-in
  header version 102).

  Regards
  Martin


  Am 18.03.20 um 21:57 schrieb Chris Graves:
  > Hi Martin,
  >
  > Looking better!  However, to my knowledge, my bank only
>>>supports OFX
  > version 102 or 103.  I had been using 102.
  >
  > ofx.log:
  > Sending:
  > -
  > OFXHEADER:220
  > DATA:OFXSGML
  > VERSION:220
  > SECURITY:NONE
  > ENCODING:USASCII
  > CHARSET:1252
  > COMPRESSION:NONE
  > OLDFILEUID:NONE
  > NEWFILEUID:20200318135033.000
  >
  > 
  > 
  > 
  > 20200318135025.000
  >
  > On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss
>>>mailto:mar...@aqbanking.de>
  >
  > 
>>>
  > Hi Chris,
  >
  > could you please test the latest GIT version? It should
>>>create
  valid
  > OFXv1 requests now, however, I can't test it completely
>>>since
  I only
  > have access to an OFXv2 server...
  >
  >
  > Regards
  > Martin
  >
  >
  > Am 18.03.20 um 16:31 schrieb chris graves:
  > > An additional bit of information from /tmp/ofx.log:
  > > AQB5:
  > > Sending:
  > > -
  > > OFXHEADER:100
  > > DATA:OFXSGML
  > > VERSION:102
  > > SECURITY:NONE
  > > ENCODING:USASCII
  > > CHARSET:1252
  > > COMPRESSION:NONE
  > > OLDFILEUID:NONE
  > > NEWFILEUID:20200318081757.000
  > >
  > > ...
  > [...]
  >
  >
  > --
  > "Things are only impossible until they're 

Re: [GNC] AQBanking OFX DirectConnect

[chris graves]

Is there any easy way to capture the dialog between the client and server?

> On Mar 18, 2020, at 3:04 PM, John Ralls  wrote:
> 
> The only difference I see now in the ofx.logs is the newlines, and I still 
> haven't figured out if they're correctly escaped in the http request.
> 
> Regards,
> John Ralls
> 
> 
>> On Mar 18, 2020, at 2:59 PM, Martin Preuss  wrote:
>> 
>> Hi again,
>> 
>> with the latest changes: Are there any probably important differences in
>> the generated OFX request compared to Aqb5's output (except dates etc.)?
>> 
>> Regards
>> Martin
>> 
>> 
>> Am 18.03.20 um 22:50 schrieb Chris Graves:
>>> Hi Martin,
>>> 
>>> The GUI wouldn't let me leave that field blank, so I manually deleted
>>> the entry from the .conf file. Running again, it did use the defaults
>>> that you specified.  However, still the http 400 error and no response.
>>> 
>>> Sending:
>>> -
>>> OFXHEADER:100
>>> DATA:OFXSGML
>>> VERSION:102
>>> SECURITY:NONE
>>> ENCODING:USASCII
>>> CHARSET:1252
>>> COMPRESSION:NONE
>>> OLDFILEUID:NONE
>>> NEWFILEUID:20200318144035.000
>>> 
>>> On Wed, Mar 18, 2020 at 2:34 PM Martin Preuss >> > wrote:
>>> 
>>>   Hi,
>>> 
>>>   not ATM, but that can be arranged. However, how about leaving that field
>>>   empty in the settings dialog? That should default to 100 for OFXHEADER
>>>   and 102 for VERSION (for - ahem - historic reasons, I'm sure I had
>>>   good^H^H^H reasons for those mixed defaults... :-})
>>> 
>>>   Regards
>>>   Martin
>>> 
>>> 
>>>   Am 18.03.20 um 22:26 schrieb Chris Graves:
 Nice!  I see that the change has been made, but still receive the HTTP
 400 error.
 
 In the AQB5 ofx.log file for a successful case, I see
 OFXHEADER:100
 VERSION:102
 
 In the AQB6 file, I see
 OFXHEADER:102
 VERSION:102
 
 Not sure if this could be the problem.  Is there a way to set
>>>   OFXHEADER
 and VERSION independently?
 
 
 On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss >>   
 >> wrote:
 
 Hi,
 
 you can change the header manually to 102/103 in the
>>>   homebanking setup
 dialog (select user, edit user, switch to app settings and type-in
 header version 102).
 
 Regards
 Martin
 
 
 Am 18.03.20 um 21:57 schrieb Chris Graves:
> Hi Martin,
> 
> Looking better!  However, to my knowledge, my bank only
>>>   supports OFX
> version 102 or 103.  I had been using 102.
> 
> ofx.log:
> Sending:
> -
> OFXHEADER:220
> DATA:OFXSGML
> VERSION:220
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:20200318135033.000
> 
> 
> 
> 
> 20200318135025.000
> 
> On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss
>>>   mailto:mar...@aqbanking.de>
 >
> 
>>>    
>Hi Chris,
> 
>could you please test the latest GIT version? It should
>>>   create
 valid
>OFXv1 requests now, however, I can't test it completely
>>>   since
 I only
>have access to an OFXv2 server...
> 
> 
>Regards
>Martin
> 
> 
>Am 18.03.20 um 16:31 schrieb chris graves:
>> An additional bit of information from /tmp/ofx.log:
>> AQB5:
>> Sending:
>> -
>> OFXHEADER:100
>> DATA:OFXSGML
>> VERSION:102
>> SECURITY:NONE
>> ENCODING:USASCII
>> CHARSET:1252
>> COMPRESSION:NONE
>> OLDFILEUID:NONE
>> NEWFILEUID:20200318081757.000
>> 
>> ...
>[...]
> 
> 
>--
>"Things are only impossible until they're not"
> 
 
 
 --
 "Things are only impossible until they're not"
 
>>> 
>>> 
>>>   -- 
>>>   "Things are only impossible until they're not"
>>> 
>> 
>> 
>> -- 
>> "Things are only impossible until they're not"
> 

___
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.

Re: [GNC] AQBanking OFX DirectConnect

[John Ralls]

The only difference I see now in the ofx.logs is the newlines, and I still 
haven't figured out if they're correctly escaped in the http request.

Regards,
John Ralls


> On Mar 18, 2020, at 2:59 PM, Martin Preuss  wrote:
> 
> Hi again,
> 
> with the latest changes: Are there any probably important differences in
> the generated OFX request compared to Aqb5's output (except dates etc.)?
> 
> Regards
> Martin
> 
> 
> Am 18.03.20 um 22:50 schrieb Chris Graves:
>> Hi Martin,
>> 
>> The GUI wouldn't let me leave that field blank, so I manually deleted
>> the entry from the .conf file. Running again, it did use the defaults
>> that you specified.  However, still the http 400 error and no response.
>> 
>> Sending:
>> -
>> OFXHEADER:100
>> DATA:OFXSGML
>> VERSION:102
>> SECURITY:NONE
>> ENCODING:USASCII
>> CHARSET:1252
>> COMPRESSION:NONE
>> OLDFILEUID:NONE
>> NEWFILEUID:20200318144035.000
>> 
>> On Wed, Mar 18, 2020 at 2:34 PM Martin Preuss > > wrote:
>> 
>>Hi,
>> 
>>not ATM, but that can be arranged. However, how about leaving that field
>>empty in the settings dialog? That should default to 100 for OFXHEADER
>>and 102 for VERSION (for - ahem - historic reasons, I'm sure I had
>>good^H^H^H reasons for those mixed defaults... :-})
>> 
>>Regards
>>Martin
>> 
>> 
>>Am 18.03.20 um 22:26 schrieb Chris Graves:
>>> Nice!  I see that the change has been made, but still receive the HTTP
>>> 400 error.
>>> 
>>> In the AQB5 ofx.log file for a successful case, I see
>>> OFXHEADER:100
>>> VERSION:102
>>> 
>>> In the AQB6 file, I see
>>> OFXHEADER:102
>>> VERSION:102
>>> 
>>> Not sure if this could be the problem.  Is there a way to set
>>OFXHEADER
>>> and VERSION independently?
>>> 
>>> 
>>> On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss >
>>> >> wrote:
>>> 
>>>  Hi,
>>> 
>>>  you can change the header manually to 102/103 in the
>>homebanking setup
>>>  dialog (select user, edit user, switch to app settings and type-in
>>>  header version 102).
>>> 
>>>  Regards
>>>  Martin
>>> 
>>> 
>>>  Am 18.03.20 um 21:57 schrieb Chris Graves:
>>>  > Hi Martin,
>>>  >
>>>  > Looking better!  However, to my knowledge, my bank only
>>supports OFX
>>>  > version 102 or 103.  I had been using 102.
>>>  >
>>>  > ofx.log:
>>>  > Sending:
>>>  > -
>>>  > OFXHEADER:220
>>>  > DATA:OFXSGML
>>>  > VERSION:220
>>>  > SECURITY:NONE
>>>  > ENCODING:USASCII
>>>  > CHARSET:1252
>>>  > COMPRESSION:NONE
>>>  > OLDFILEUID:NONE
>>>  > NEWFILEUID:20200318135033.000
>>>  >
>>>  > 
>>>  > 
>>>  > 
>>>  > 20200318135025.000
>>>  >
>>>  > On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss
>>mailto:mar...@aqbanking.de>
>>>  >
>>>  > 
>>>>  >
>>>  > Hi Chris,
>>>  >
>>>  > could you please test the latest GIT version? It should
>>create
>>>  valid
>>>  > OFXv1 requests now, however, I can't test it completely
>>since
>>>  I only
>>>  > have access to an OFXv2 server...
>>>  >
>>>  >
>>>  > Regards
>>>  > Martin
>>>  >
>>>  >
>>>  > Am 18.03.20 um 16:31 schrieb chris graves:
>>>  > > An additional bit of information from /tmp/ofx.log:
>>>  > > AQB5:
>>>  > > Sending:
>>>  > > -
>>>  > > OFXHEADER:100
>>>  > > DATA:OFXSGML
>>>  > > VERSION:102
>>>  > > SECURITY:NONE
>>>  > > ENCODING:USASCII
>>>  > > CHARSET:1252
>>>  > > COMPRESSION:NONE
>>>  > > OLDFILEUID:NONE
>>>  > > NEWFILEUID:20200318081757.000
>>>  > >
>>>  > > ...
>>>  > [...]
>>>  >
>>>  >
>>>  > --
>>>  > "Things are only impossible until they're not"
>>>  >
>>> 
>>> 
>>>  --
>>>  "Things are only impossible until they're not"
>>> 
>> 
>> 
>>-- 
>>"Things are only impossible until they're not"
>> 
> 
> 
> -- 
> "Things are only impossible until they're not"

___
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.

Re: [GNC] AQBanking OFX DirectConnect

[John Ralls]

Remember, the working ofx from AQB5 is
Sending:
-
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:20200315112517.000

20200315112517

ENGUSAA24591QWIN2300202003151125171202003140020200315112517Y


Regards,
John Ralls

> On Mar 18, 2020, at 2:54 PM, Martin Preuss  wrote:
> 
> Hi,
> 
> please see my other mail (latest GIT).
> 
> Maybe "103" then (I heard of some cases where "103" was necessary)? Or
> perhaps "160"?
> 
> Will fix the gui btw...
> 
> 
> Regards
> Martin
> 
> Am 18.03.20 um 22:50 schrieb Chris Graves:
>> Hi Martin,
>> 
>> The GUI wouldn't let me leave that field blank, so I manually deleted
>> the entry from the .conf file. Running again, it did use the defaults
>> that you specified.  However, still the http 400 error and no response.
>> 
>> Sending:
>> -
>> OFXHEADER:100
>> DATA:OFXSGML
>> VERSION:102
>> SECURITY:NONE
>> ENCODING:USASCII
>> CHARSET:1252
>> COMPRESSION:NONE
>> OLDFILEUID:NONE
>> NEWFILEUID:20200318144035.000
>> 
>> On Wed, Mar 18, 2020 at 2:34 PM Martin Preuss > > wrote:
>> 
>>Hi,
>> 
>>not ATM, but that can be arranged. However, how about leaving that field
>>empty in the settings dialog? That should default to 100 for OFXHEADER
>>and 102 for VERSION (for - ahem - historic reasons, I'm sure I had
>>good^H^H^H reasons for those mixed defaults... :-})
>> 
>>Regards
>>Martin
>> 
>> 
>>Am 18.03.20 um 22:26 schrieb Chris Graves:
>>> Nice!  I see that the change has been made, but still receive the HTTP
>>> 400 error.
>>> 
>>> In the AQB5 ofx.log file for a successful case, I see
>>> OFXHEADER:100
>>> VERSION:102
>>> 
>>> In the AQB6 file, I see
>>> OFXHEADER:102
>>> VERSION:102
>>> 
>>> Not sure if this could be the problem.  Is there a way to set
>>OFXHEADER
>>> and VERSION independently?
>>> 
>>> 
>>> On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss >
>>> >> wrote:
>>> 
>>>  Hi,
>>> 
>>>  you can change the header manually to 102/103 in the
>>homebanking setup
>>>  dialog (select user, edit user, switch to app settings and type-in
>>>  header version 102).
>>> 
>>>  Regards
>>>  Martin
>>> 
>>> 
>>>  Am 18.03.20 um 21:57 schrieb Chris Graves:
>>>  > Hi Martin,
>>>  >
>>>  > Looking better!  However, to my knowledge, my bank only
>>supports OFX
>>>  > version 102 or 103.  I had been using 102.
>>>  >
>>>  > ofx.log:
>>>  > Sending:
>>>  > -
>>>  > OFXHEADER:220
>>>  > DATA:OFXSGML
>>>  > VERSION:220
>>>  > SECURITY:NONE
>>>  > ENCODING:USASCII
>>>  > CHARSET:1252
>>>  > COMPRESSION:NONE
>>>  > OLDFILEUID:NONE
>>>  > NEWFILEUID:20200318135033.000
>>>  >
>>>  > 
>>>  > 
>>>  > 
>>>  > 20200318135025.000
>>>  >
>>>  > On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss
>>mailto:mar...@aqbanking.de>
>>>  >
>>>  > 
>>>>  >
>>>  > Hi Chris,
>>>  >
>>>  > could you please test the latest GIT version? It should
>>create
>>>  valid
>>>  > OFXv1 requests now, however, I can't test it completely
>>since
>>>  I only
>>>  > have access to an OFXv2 server...
>>>  >
>>>  >
>>>  > Regards
>>>  > Martin
>>>  >
>>>  >
>>>  > Am 18.03.20 um 16:31 schrieb chris graves:
>>>  > > An additional bit of information from /tmp/ofx.log:
>>>  > > AQB5:
>>>  > > Sending:
>>>  > > -
>>>  > > OFXHEADER:100
>>>  > > DATA:OFXSGML
>>>  > > VERSION:102
>>>  > > SECURITY:NONE
>>>  > > ENCODING:USASCII
>>>  > > CHARSET:1252
>>>  > > COMPRESSION:NONE
>>>  > > OLDFILEUID:NONE
>>>  > > NEWFILEUID:20200318081757.000
>>>  > >
>>>  > > ...
>>>  > [...]
>>>  >
>>>  >
>>>  > --
>>>  > "Things are only impossible until they're not"
>>>  >
>>> 
>>> 
>>>  --
>>>  "Things are only impossible until they're not"
>>> 
>> 
>> 
>>-- 
>>"Things are only impossible until they're not"
>> 
> 
> 
> -- 
> "Things are only impossible until they're not"

___
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 

Re: [GNC] AQBanking OFX DirectConnect

[John Ralls]

It actually requires make uninstall && make clean && make && make install to 
ensure that the changed code is used.

Regards,
John Ralls

> On Mar 18, 2020, at 2:52 PM, Martin Preuss  wrote:
> 
> Hi,
> 
> okay now, the latest GIT version always sets "OFXHEADER:100" and uses
> the given header version only for the "VERSION:" header. In that case
> you can specify "102" and it should create the correct headers...
> 
> Please note: For reasons not yet understood it might be necessary when
> updating from git to first issue "make clean" before "make", otherwise
> sometimes the resulting binaries might not be based on all the latest
> code (I have no idea whether this happens for others as well, it's just
> something I stumbled upon while working on AqBanking).
> 
> 
> Regards
> Martin
> 
> 
> Am 18.03.20 um 22:47 schrieb John Ralls:
>> It won't let you leave that blank, and even if it did it would put '100' in 
>> both fields:
>> if (!(s && *s))
>>s="100";
>> 
>>  GWEN_Buffer_AppendString(buf, "OFXHEADER:");
>>  GWEN_Buffer_AppendString(buf, s);
>>  GWEN_Buffer_AppendString(buf, "\r\nDATA:OFXSGML\r\n");
>> 
>>  GWEN_Buffer_AppendString(buf, "VERSION:");
>>  s=AO_User_GetHeaderVer(u);
>>  if (!s || !*s)
>>s="102";
>>  GWEN_Buffer_AppendString(buf, s);
>>  GWEN_Buffer_AppendString(buf, "\r\n");
>> 
>> Because at the second test s has a value.
>> 
>> The new code doesn't emit the trailing tags, so that may not have been the 
>> problem. The main difference other than the OFXHEADER: value now appears to 
>> be that there are newlines between the fields. Are those getting escaped in 
>> GWEN_SyncIo_Http_Write?
>> 
>> Regards,
>> John Ralls
>>> On Mar 18, 2020, at 2:34 PM, Martin Preuss  wrote:
>>> 
>>> Hi,
>>> 
>>> not ATM, but that can be arranged. However, how about leaving that field
>>> empty in the settings dialog? That should default to 100 for OFXHEADER
>>> and 102 for VERSION (for - ahem - historic reasons, I'm sure I had
>>> good^H^H^H reasons for those mixed defaults... :-})
>>> 
>>> Regards
>>> Martin
>>> 
>>> 
>>> Am 18.03.20 um 22:26 schrieb Chris Graves:
 Nice!  I see that the change has been made, but still receive the HTTP
 400 error.
 
 In the AQB5 ofx.log file for a successful case, I see
 OFXHEADER:100
 VERSION:102
 
 In the AQB6 file, I see
 OFXHEADER:102
 VERSION:102
 
 Not sure if this could be the problem.  Is there a way to set OFXHEADER
 and VERSION independently?
 
 
 On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss >>> > wrote:
 
   Hi,
 
   you can change the header manually to 102/103 in the homebanking setup
   dialog (select user, edit user, switch to app settings and type-in
   header version 102).
 
   Regards
   Martin
 
 
   Am 18.03.20 um 21:57 schrieb Chris Graves:
> Hi Martin,
> 
> Looking better!  However, to my knowledge, my bank only supports OFX
> version 102 or 103.  I had been using 102.
> 
> ofx.log:
> Sending:
> -
> OFXHEADER:220
> DATA:OFXSGML
> VERSION:220
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:20200318135033.000
> 
> 
> 
> 
> 20200318135025.000
> 
> On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss >>>   
> >> wrote:
> 
> Hi Chris,
> 
> could you please test the latest GIT version? It should create
   valid
> OFXv1 requests now, however, I can't test it completely since
   I only
> have access to an OFXv2 server...
> 
> 
> Regards
> Martin
> 
> 
> Am 18.03.20 um 16:31 schrieb chris graves:
>> An additional bit of information from /tmp/ofx.log:
>> AQB5:
>> Sending:
>> -
>> OFXHEADER:100
>> DATA:OFXSGML
>> VERSION:102
>> SECURITY:NONE
>> ENCODING:USASCII
>> CHARSET:1252
>> COMPRESSION:NONE
>> OLDFILEUID:NONE
>> NEWFILEUID:20200318081757.000
>> 
>> ...
> [...]
> 
> 
> --
> "Things are only impossible until they're not"
> 
 
 
   -- 
   "Things are only impossible until they're not"
 
>>> 
>>> 
>>> -- 
>>> "Things are only impossible until they're not"
>> 
> 
> 
> -- 
> "Things are only impossible until they're not"

___
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 

Re: [GNC] AQBanking OFX DirectConnect

[chris graves]

Not sure if it matters, but the OFX clause/aggregate? in AQB5 is on three lines 
with a line break after the USERID and again after USERPASS.

In git, there is a linebreak after each element/aggregate.

> On Mar 18, 2020, at 2:51 PM, John Ralls  wrote:
> 
> I changed the line just below OFXHEADER to 
>GWEN_Buffer_AppendString(buf, "100");
> 
> producing the following. No luck, it still returns a 400 error.
> 
> Regards,
> John Ralls
> 
> Sending:
> -
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:102
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:20200318144822.000
> 
> 
> 
> 
> 20200318144819
> 
> 
> ENG
> 
> USAA
> 24591
> 
> QWIN
> 2300
> 
> 
> 
> 
> 20200318144822
> 
> 
> 24591
> 
> 
> 
> 2020030900
> 2020031800
> Y
> 
> 
> 
> 
> 
> 
>> On Mar 18, 2020, at 2:47 PM, John Ralls  wrote:
>> 
>> It won't let you leave that blank, and even if it did it would put '100' in 
>> both fields:
>> if (!(s && *s))
>>   s="100";
>> 
>> GWEN_Buffer_AppendString(buf, "OFXHEADER:");
>> GWEN_Buffer_AppendString(buf, s);
>> GWEN_Buffer_AppendString(buf, "\r\nDATA:OFXSGML\r\n");
>> 
>> GWEN_Buffer_AppendString(buf, "VERSION:");
>> s=AO_User_GetHeaderVer(u);
>> if (!s || !*s)
>>   s="102";
>> GWEN_Buffer_AppendString(buf, s);
>> GWEN_Buffer_AppendString(buf, "\r\n");
>> 
>> Because at the second test s has a value.
>> 
>> The new code doesn't emit the trailing tags, so that may not have been the 
>> problem. The main difference other than the OFXHEADER: value now appears to 
>> be that there are newlines between the fields. Are those getting escaped in 
>> GWEN_SyncIo_Http_Write?
>> 
>> Regards,
>> John Ralls
>>> On Mar 18, 2020, at 2:34 PM, Martin Preuss  wrote:
>>> 
>>> Hi,
>>> 
>>> not ATM, but that can be arranged. However, how about leaving that field
>>> empty in the settings dialog? That should default to 100 for OFXHEADER
>>> and 102 for VERSION (for - ahem - historic reasons, I'm sure I had
>>> good^H^H^H reasons for those mixed defaults... :-})
>>> 
>>> Regards
>>> Martin
>>> 
>>> 
>>> Am 18.03.20 um 22:26 schrieb Chris Graves:
 Nice!  I see that the change has been made, but still receive the HTTP
 400 error.
 
 In the AQB5 ofx.log file for a successful case, I see
 OFXHEADER:100
 VERSION:102
 
 In the AQB6 file, I see
 OFXHEADER:102
 VERSION:102
 
 Not sure if this could be the problem.  Is there a way to set OFXHEADER
 and VERSION independently?
 
 
 On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss >>> > wrote:
 
  Hi,
 
  you can change the header manually to 102/103 in the homebanking setup
  dialog (select user, edit user, switch to app settings and type-in
  header version 102).
 
  Regards
  Martin
 
 
  Am 18.03.20 um 21:57 schrieb Chris Graves:
> Hi Martin,
> 
> Looking better!  However, to my knowledge, my bank only supports OFX
> version 102 or 103.  I had been using 102.
> 
> ofx.log:
> Sending:
> -
> OFXHEADER:220
> DATA:OFXSGML
> VERSION:220
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:20200318135033.000
> 
> 
> 
> 
> 20200318135025.000
> 
> On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss >>>  
> >> wrote:
> 
>Hi Chris,
> 
>could you please test the latest GIT version? It should create
  valid
>OFXv1 requests now, however, I can't test it completely since
  I only
>have access to an OFXv2 server...
> 
> 
>Regards
>Martin
> 
> 
>Am 18.03.20 um 16:31 schrieb chris graves:
>> An additional bit of information from /tmp/ofx.log:
>> AQB5:
>> Sending:
>> -
>> OFXHEADER:100
>> DATA:OFXSGML
>> VERSION:102
>> SECURITY:NONE
>> ENCODING:USASCII
>> CHARSET:1252
>> COMPRESSION:NONE
>> OLDFILEUID:NONE
>> NEWFILEUID:20200318081757.000
>> 
>> ...
>[...]
> 
> 
>--
>"Things are only impossible until they're not"
> 
 
 
  -- 
  "Things are only impossible until they're not"
 
>>> 
>>> 
>>> -- 
>>> "Things are only impossible until they're not"
>> 
> 

___
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 

Re: [GNC] AQBanking OFX DirectConnect

[Martin Preuss]

Hi again,

with the latest changes: Are there any probably important differences in
the generated OFX request compared to Aqb5's output (except dates etc.)?

Regards
Martin


Am 18.03.20 um 22:50 schrieb Chris Graves:
> Hi Martin,
> 
> The GUI wouldn't let me leave that field blank, so I manually deleted
> the entry from the .conf file. Running again, it did use the defaults
> that you specified.  However, still the http 400 error and no response.
> 
> Sending:
> -
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:102
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:20200318144035.000
> 
> On Wed, Mar 18, 2020 at 2:34 PM Martin Preuss  > wrote:
> 
> Hi,
> 
> not ATM, but that can be arranged. However, how about leaving that field
> empty in the settings dialog? That should default to 100 for OFXHEADER
> and 102 for VERSION (for - ahem - historic reasons, I'm sure I had
> good^H^H^H reasons for those mixed defaults... :-})
> 
> Regards
> Martin
> 
> 
> Am 18.03.20 um 22:26 schrieb Chris Graves:
> > Nice!  I see that the change has been made, but still receive the HTTP
> > 400 error.
> >
> > In the AQB5 ofx.log file for a successful case, I see
> > OFXHEADER:100
> > VERSION:102
> >
> > In the AQB6 file, I see
> > OFXHEADER:102
> > VERSION:102
> >
> > Not sure if this could be the problem.  Is there a way to set
> OFXHEADER
> > and VERSION independently?
> >
> >
> > On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss  
> > >> wrote:
> >
> >     Hi,
> >
> >     you can change the header manually to 102/103 in the
> homebanking setup
> >     dialog (select user, edit user, switch to app settings and type-in
> >     header version 102).
> >
> >     Regards
> >     Martin
> >
> >
> >     Am 18.03.20 um 21:57 schrieb Chris Graves:
> >     > Hi Martin,
> >     >
> >     > Looking better!  However, to my knowledge, my bank only
> supports OFX
> >     > version 102 or 103.  I had been using 102.
> >     >
> >     > ofx.log:
> >     > Sending:
> >     > -
> >     > OFXHEADER:220
> >     > DATA:OFXSGML
> >     > VERSION:220
> >     > SECURITY:NONE
> >     > ENCODING:USASCII
> >     > CHARSET:1252
> >     > COMPRESSION:NONE
> >     > OLDFILEUID:NONE
> >     > NEWFILEUID:20200318135033.000
> >     >
> >     > 
> >     > 
> >     > 
> >     > 20200318135025.000
> >     >
> >     > On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss
> mailto:mar...@aqbanking.de>
> >     >
> >     > 
>  >     >
> >     >     Hi Chris,
> >     >
> >     >     could you please test the latest GIT version? It should
> create
> >     valid
> >     >     OFXv1 requests now, however, I can't test it completely
> since
> >     I only
> >     >     have access to an OFXv2 server...
> >     >
> >     >
> >     >     Regards
> >     >     Martin
> >     >
> >     >
> >     >     Am 18.03.20 um 16:31 schrieb chris graves:
> >     >     > An additional bit of information from /tmp/ofx.log:
> >     >     > AQB5:
> >     >     > Sending:
> >     >     > -
> >     >     > OFXHEADER:100
> >     >     > DATA:OFXSGML
> >     >     > VERSION:102
> >     >     > SECURITY:NONE
> >     >     > ENCODING:USASCII
> >     >     > CHARSET:1252
> >     >     > COMPRESSION:NONE
> >     >     > OLDFILEUID:NONE
> >     >     > NEWFILEUID:20200318081757.000
> >     >     >
> >     >     > ...
> >     >     [...]
> >     >
> >     >
> >     >     --
> >     >     "Things are only impossible until they're not"
> >     >
> >
> >
> >     --
> >     "Things are only impossible until they're not"
> >
> 
> 
> -- 
> "Things are only impossible until they're not"
> 


-- 
"Things are only impossible until they're not"
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[Martin Preuss]

Hi,

please see my other mail (latest GIT).

Maybe "103" then (I heard of some cases where "103" was necessary)? Or
perhaps "160"?

Will fix the gui btw...


Regards
Martin

Am 18.03.20 um 22:50 schrieb Chris Graves:
> Hi Martin,
> 
> The GUI wouldn't let me leave that field blank, so I manually deleted
> the entry from the .conf file. Running again, it did use the defaults
> that you specified.  However, still the http 400 error and no response.
> 
> Sending:
> -
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:102
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:20200318144035.000
> 
> On Wed, Mar 18, 2020 at 2:34 PM Martin Preuss  > wrote:
> 
> Hi,
> 
> not ATM, but that can be arranged. However, how about leaving that field
> empty in the settings dialog? That should default to 100 for OFXHEADER
> and 102 for VERSION (for - ahem - historic reasons, I'm sure I had
> good^H^H^H reasons for those mixed defaults... :-})
> 
> Regards
> Martin
> 
> 
> Am 18.03.20 um 22:26 schrieb Chris Graves:
> > Nice!  I see that the change has been made, but still receive the HTTP
> > 400 error.
> >
> > In the AQB5 ofx.log file for a successful case, I see
> > OFXHEADER:100
> > VERSION:102
> >
> > In the AQB6 file, I see
> > OFXHEADER:102
> > VERSION:102
> >
> > Not sure if this could be the problem.  Is there a way to set
> OFXHEADER
> > and VERSION independently?
> >
> >
> > On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss  
> > >> wrote:
> >
> >     Hi,
> >
> >     you can change the header manually to 102/103 in the
> homebanking setup
> >     dialog (select user, edit user, switch to app settings and type-in
> >     header version 102).
> >
> >     Regards
> >     Martin
> >
> >
> >     Am 18.03.20 um 21:57 schrieb Chris Graves:
> >     > Hi Martin,
> >     >
> >     > Looking better!  However, to my knowledge, my bank only
> supports OFX
> >     > version 102 or 103.  I had been using 102.
> >     >
> >     > ofx.log:
> >     > Sending:
> >     > -
> >     > OFXHEADER:220
> >     > DATA:OFXSGML
> >     > VERSION:220
> >     > SECURITY:NONE
> >     > ENCODING:USASCII
> >     > CHARSET:1252
> >     > COMPRESSION:NONE
> >     > OLDFILEUID:NONE
> >     > NEWFILEUID:20200318135033.000
> >     >
> >     > 
> >     > 
> >     > 
> >     > 20200318135025.000
> >     >
> >     > On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss
> mailto:mar...@aqbanking.de>
> >     >
> >     > 
>  >     >
> >     >     Hi Chris,
> >     >
> >     >     could you please test the latest GIT version? It should
> create
> >     valid
> >     >     OFXv1 requests now, however, I can't test it completely
> since
> >     I only
> >     >     have access to an OFXv2 server...
> >     >
> >     >
> >     >     Regards
> >     >     Martin
> >     >
> >     >
> >     >     Am 18.03.20 um 16:31 schrieb chris graves:
> >     >     > An additional bit of information from /tmp/ofx.log:
> >     >     > AQB5:
> >     >     > Sending:
> >     >     > -
> >     >     > OFXHEADER:100
> >     >     > DATA:OFXSGML
> >     >     > VERSION:102
> >     >     > SECURITY:NONE
> >     >     > ENCODING:USASCII
> >     >     > CHARSET:1252
> >     >     > COMPRESSION:NONE
> >     >     > OLDFILEUID:NONE
> >     >     > NEWFILEUID:20200318081757.000
> >     >     >
> >     >     > ...
> >     >     [...]
> >     >
> >     >
> >     >     --
> >     >     "Things are only impossible until they're not"
> >     >
> >
> >
> >     --
> >     "Things are only impossible until they're not"
> >
> 
> 
> -- 
> "Things are only impossible until they're not"
> 


-- 
"Things are only impossible until they're not"
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[Martin Preuss]

Hi,

okay now, the latest GIT version always sets "OFXHEADER:100" and uses
the given header version only for the "VERSION:" header. In that case
you can specify "102" and it should create the correct headers...

Please note: For reasons not yet understood it might be necessary when
updating from git to first issue "make clean" before "make", otherwise
sometimes the resulting binaries might not be based on all the latest
code (I have no idea whether this happens for others as well, it's just
something I stumbled upon while working on AqBanking).


Regards
Martin


Am 18.03.20 um 22:47 schrieb John Ralls:
> It won't let you leave that blank, and even if it did it would put '100' in 
> both fields:
>  if (!(s && *s))
> s="100";
> 
>   GWEN_Buffer_AppendString(buf, "OFXHEADER:");
>   GWEN_Buffer_AppendString(buf, s);
>   GWEN_Buffer_AppendString(buf, "\r\nDATA:OFXSGML\r\n");
> 
>   GWEN_Buffer_AppendString(buf, "VERSION:");
>   s=AO_User_GetHeaderVer(u);
>   if (!s || !*s)
> s="102";
>   GWEN_Buffer_AppendString(buf, s);
>   GWEN_Buffer_AppendString(buf, "\r\n");
> 
> Because at the second test s has a value.
> 
> The new code doesn't emit the trailing tags, so that may not have been the 
> problem. The main difference other than the OFXHEADER: value now appears to 
> be that there are newlines between the fields. Are those getting escaped in 
> GWEN_SyncIo_Http_Write?
> 
> Regards,
> John Ralls
>> On Mar 18, 2020, at 2:34 PM, Martin Preuss  wrote:
>>
>> Hi,
>>
>> not ATM, but that can be arranged. However, how about leaving that field
>> empty in the settings dialog? That should default to 100 for OFXHEADER
>> and 102 for VERSION (for - ahem - historic reasons, I'm sure I had
>> good^H^H^H reasons for those mixed defaults... :-})
>>
>> Regards
>> Martin
>>
>>
>> Am 18.03.20 um 22:26 schrieb Chris Graves:
>>> Nice!  I see that the change has been made, but still receive the HTTP
>>> 400 error.
>>>
>>> In the AQB5 ofx.log file for a successful case, I see
>>> OFXHEADER:100
>>> VERSION:102
>>>
>>> In the AQB6 file, I see
>>> OFXHEADER:102
>>> VERSION:102
>>>
>>> Not sure if this could be the problem.  Is there a way to set OFXHEADER
>>> and VERSION independently?
>>>
>>>
>>> On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss >> > wrote:
>>>
>>>Hi,
>>>
>>>you can change the header manually to 102/103 in the homebanking setup
>>>dialog (select user, edit user, switch to app settings and type-in
>>>header version 102).
>>>
>>>Regards
>>>Martin
>>>
>>>
>>>Am 18.03.20 um 21:57 schrieb Chris Graves:
 Hi Martin,

 Looking better!  However, to my knowledge, my bank only supports OFX
 version 102 or 103.  I had been using 102.

 ofx.log:
 Sending:
 -
 OFXHEADER:220
 DATA:OFXSGML
 VERSION:220
 SECURITY:NONE
 ENCODING:USASCII
 CHARSET:1252
 COMPRESSION:NONE
 OLDFILEUID:NONE
 NEWFILEUID:20200318135033.000

 
 
 
 20200318135025.000

 On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss >>
 >> wrote:

  Hi Chris,

  could you please test the latest GIT version? It should create
>>>valid
  OFXv1 requests now, however, I can't test it completely since
>>>I only
  have access to an OFXv2 server...


  Regards
  Martin


  Am 18.03.20 um 16:31 schrieb chris graves:
  > An additional bit of information from /tmp/ofx.log:
  > AQB5:
  > Sending:
  > -
  > OFXHEADER:100
  > DATA:OFXSGML
  > VERSION:102
  > SECURITY:NONE
  > ENCODING:USASCII
  > CHARSET:1252
  > COMPRESSION:NONE
  > OLDFILEUID:NONE
  > NEWFILEUID:20200318081757.000
  >
  > ...
  [...]


  --
  "Things are only impossible until they're not"

>>>
>>>
>>>-- 
>>>"Things are only impossible until they're not"
>>>
>>
>>
>> -- 
>> "Things are only impossible until they're not"
> 


-- 
"Things are only impossible until they're not"
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[John Ralls]

I changed the line just below OFXHEADER to 
GWEN_Buffer_AppendString(buf, "100");

producing the following. No luck, it still returns a 400 error.

Regards,
John Ralls

Sending:
-
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:20200318144822.000




20200318144819


ENG

USAA
24591

QWIN
2300




20200318144822


24591



2020030900
2020031800
Y






> On Mar 18, 2020, at 2:47 PM, John Ralls  wrote:
> 
> It won't let you leave that blank, and even if it did it would put '100' in 
> both fields:
> if (!(s && *s))
>s="100";
> 
>  GWEN_Buffer_AppendString(buf, "OFXHEADER:");
>  GWEN_Buffer_AppendString(buf, s);
>  GWEN_Buffer_AppendString(buf, "\r\nDATA:OFXSGML\r\n");
> 
>  GWEN_Buffer_AppendString(buf, "VERSION:");
>  s=AO_User_GetHeaderVer(u);
>  if (!s || !*s)
>s="102";
>  GWEN_Buffer_AppendString(buf, s);
>  GWEN_Buffer_AppendString(buf, "\r\n");
> 
> Because at the second test s has a value.
> 
> The new code doesn't emit the trailing tags, so that may not have been the 
> problem. The main difference other than the OFXHEADER: value now appears to 
> be that there are newlines between the fields. Are those getting escaped in 
> GWEN_SyncIo_Http_Write?
> 
> Regards,
> John Ralls
>> On Mar 18, 2020, at 2:34 PM, Martin Preuss  wrote:
>> 
>> Hi,
>> 
>> not ATM, but that can be arranged. However, how about leaving that field
>> empty in the settings dialog? That should default to 100 for OFXHEADER
>> and 102 for VERSION (for - ahem - historic reasons, I'm sure I had
>> good^H^H^H reasons for those mixed defaults... :-})
>> 
>> Regards
>> Martin
>> 
>> 
>> Am 18.03.20 um 22:26 schrieb Chris Graves:
>>> Nice!  I see that the change has been made, but still receive the HTTP
>>> 400 error.
>>> 
>>> In the AQB5 ofx.log file for a successful case, I see
>>> OFXHEADER:100
>>> VERSION:102
>>> 
>>> In the AQB6 file, I see
>>> OFXHEADER:102
>>> VERSION:102
>>> 
>>> Not sure if this could be the problem.  Is there a way to set OFXHEADER
>>> and VERSION independently?
>>> 
>>> 
>>> On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss >> > wrote:
>>> 
>>>   Hi,
>>> 
>>>   you can change the header manually to 102/103 in the homebanking setup
>>>   dialog (select user, edit user, switch to app settings and type-in
>>>   header version 102).
>>> 
>>>   Regards
>>>   Martin
>>> 
>>> 
>>>   Am 18.03.20 um 21:57 schrieb Chris Graves:
 Hi Martin,
 
 Looking better!  However, to my knowledge, my bank only supports OFX
 version 102 or 103.  I had been using 102.
 
 ofx.log:
 Sending:
 -
 OFXHEADER:220
 DATA:OFXSGML
 VERSION:220
 SECURITY:NONE
 ENCODING:USASCII
 CHARSET:1252
 COMPRESSION:NONE
 OLDFILEUID:NONE
 NEWFILEUID:20200318135033.000
 
 
 
 
 20200318135025.000
 
 On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss >>   
 >> wrote:
 
 Hi Chris,
 
 could you please test the latest GIT version? It should create
>>>   valid
 OFXv1 requests now, however, I can't test it completely since
>>>   I only
 have access to an OFXv2 server...
 
 
 Regards
 Martin
 
 
 Am 18.03.20 um 16:31 schrieb chris graves:
> An additional bit of information from /tmp/ofx.log:
> AQB5:
> Sending:
> -
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:102
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:20200318081757.000
> 
> ...
 [...]
 
 
 --
 "Things are only impossible until they're not"
 
>>> 
>>> 
>>>   -- 
>>>   "Things are only impossible until they're not"
>>> 
>> 
>> 
>> -- 
>> "Things are only impossible until they're not"
> 

___
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.

Re: [GNC] AQBanking OFX DirectConnect

[Chris Graves]

Hi Martin,

The GUI wouldn't let me leave that field blank, so I manually deleted the
entry from the .conf file. Running again, it did use the defaults that you
specified.  However, still the http 400 error and no response.

Sending:
-
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:20200318144035.000

On Wed, Mar 18, 2020 at 2:34 PM Martin Preuss  wrote:

> Hi,
>
> not ATM, but that can be arranged. However, how about leaving that field
> empty in the settings dialog? That should default to 100 for OFXHEADER
> and 102 for VERSION (for - ahem - historic reasons, I'm sure I had
> good^H^H^H reasons for those mixed defaults... :-})
>
> Regards
> Martin
>
>
> Am 18.03.20 um 22:26 schrieb Chris Graves:
> > Nice!  I see that the change has been made, but still receive the HTTP
> > 400 error.
> >
> > In the AQB5 ofx.log file for a successful case, I see
> > OFXHEADER:100
> > VERSION:102
> >
> > In the AQB6 file, I see
> > OFXHEADER:102
> > VERSION:102
> >
> > Not sure if this could be the problem.  Is there a way to set OFXHEADER
> > and VERSION independently?
> >
> >
> > On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss  > > wrote:
> >
> > Hi,
> >
> > you can change the header manually to 102/103 in the homebanking
> setup
> > dialog (select user, edit user, switch to app settings and type-in
> > header version 102).
> >
> > Regards
> > Martin
> >
> >
> > Am 18.03.20 um 21:57 schrieb Chris Graves:
> > > Hi Martin,
> > >
> > > Looking better!  However, to my knowledge, my bank only supports
> OFX
> > > version 102 or 103.  I had been using 102.
> > >
> > > ofx.log:
> > > Sending:
> > > -
> > > OFXHEADER:220
> > > DATA:OFXSGML
> > > VERSION:220
> > > SECURITY:NONE
> > > ENCODING:USASCII
> > > CHARSET:1252
> > > COMPRESSION:NONE
> > > OLDFILEUID:NONE
> > > NEWFILEUID:20200318135033.000
> > >
> > > 
> > > 
> > > 
> > > 20200318135025.000
> > >
> > > On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss  > 
> > > >> wrote:
> > >
> > > Hi Chris,
> > >
> > > could you please test the latest GIT version? It should create
> > valid
> > > OFXv1 requests now, however, I can't test it completely since
> > I only
> > > have access to an OFXv2 server...
> > >
> > >
> > > Regards
> > > Martin
> > >
> > >
> > > Am 18.03.20 um 16:31 schrieb chris graves:
> > > > An additional bit of information from /tmp/ofx.log:
> > > > AQB5:
> > > > Sending:
> > > > -
> > > > OFXHEADER:100
> > > > DATA:OFXSGML
> > > > VERSION:102
> > > > SECURITY:NONE
> > > > ENCODING:USASCII
> > > > CHARSET:1252
> > > > COMPRESSION:NONE
> > > > OLDFILEUID:NONE
> > > > NEWFILEUID:20200318081757.000
> > > >
> > > > ...
> > > [...]
> > >
> > >
> > > --
> > > "Things are only impossible until they're not"
> > >
> >
> >
> > --
> > "Things are only impossible until they're not"
> >
>
>
> --
> "Things are only impossible until they're not"
>
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[John Ralls]

It won't let you leave that blank, and even if it did it would put '100' in 
both fields:
 if (!(s && *s))
s="100";

  GWEN_Buffer_AppendString(buf, "OFXHEADER:");
  GWEN_Buffer_AppendString(buf, s);
  GWEN_Buffer_AppendString(buf, "\r\nDATA:OFXSGML\r\n");

  GWEN_Buffer_AppendString(buf, "VERSION:");
  s=AO_User_GetHeaderVer(u);
  if (!s || !*s)
s="102";
  GWEN_Buffer_AppendString(buf, s);
  GWEN_Buffer_AppendString(buf, "\r\n");

Because at the second test s has a value.

The new code doesn't emit the trailing tags, so that may not have been the 
problem. The main difference other than the OFXHEADER: value now appears to be 
that there are newlines between the fields. Are those getting escaped in 
GWEN_SyncIo_Http_Write?

Regards,
John Ralls
> On Mar 18, 2020, at 2:34 PM, Martin Preuss  wrote:
> 
> Hi,
> 
> not ATM, but that can be arranged. However, how about leaving that field
> empty in the settings dialog? That should default to 100 for OFXHEADER
> and 102 for VERSION (for - ahem - historic reasons, I'm sure I had
> good^H^H^H reasons for those mixed defaults... :-})
> 
> Regards
> Martin
> 
> 
> Am 18.03.20 um 22:26 schrieb Chris Graves:
>> Nice!  I see that the change has been made, but still receive the HTTP
>> 400 error.
>> 
>> In the AQB5 ofx.log file for a successful case, I see
>> OFXHEADER:100
>> VERSION:102
>> 
>> In the AQB6 file, I see
>> OFXHEADER:102
>> VERSION:102
>> 
>> Not sure if this could be the problem.  Is there a way to set OFXHEADER
>> and VERSION independently?
>> 
>> 
>> On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss > > wrote:
>> 
>>Hi,
>> 
>>you can change the header manually to 102/103 in the homebanking setup
>>dialog (select user, edit user, switch to app settings and type-in
>>header version 102).
>> 
>>Regards
>>Martin
>> 
>> 
>>Am 18.03.20 um 21:57 schrieb Chris Graves:
>>> Hi Martin,
>>> 
>>> Looking better!  However, to my knowledge, my bank only supports OFX
>>> version 102 or 103.  I had been using 102.
>>> 
>>> ofx.log:
>>> Sending:
>>> -
>>> OFXHEADER:220
>>> DATA:OFXSGML
>>> VERSION:220
>>> SECURITY:NONE
>>> ENCODING:USASCII
>>> CHARSET:1252
>>> COMPRESSION:NONE
>>> OLDFILEUID:NONE
>>> NEWFILEUID:20200318135033.000
>>> 
>>> 
>>> 
>>> 
>>> 20200318135025.000
>>> 
>>> On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss >
>>> >> wrote:
>>> 
>>>  Hi Chris,
>>> 
>>>  could you please test the latest GIT version? It should create
>>valid
>>>  OFXv1 requests now, however, I can't test it completely since
>>I only
>>>  have access to an OFXv2 server...
>>> 
>>> 
>>>  Regards
>>>  Martin
>>> 
>>> 
>>>  Am 18.03.20 um 16:31 schrieb chris graves:
>>>  > An additional bit of information from /tmp/ofx.log:
>>>  > AQB5:
>>>  > Sending:
>>>  > -
>>>  > OFXHEADER:100
>>>  > DATA:OFXSGML
>>>  > VERSION:102
>>>  > SECURITY:NONE
>>>  > ENCODING:USASCII
>>>  > CHARSET:1252
>>>  > COMPRESSION:NONE
>>>  > OLDFILEUID:NONE
>>>  > NEWFILEUID:20200318081757.000
>>>  >
>>>  > ...
>>>  [...]
>>> 
>>> 
>>>  --
>>>  "Things are only impossible until they're not"
>>> 
>> 
>> 
>>-- 
>>"Things are only impossible until they're not"
>> 
> 
> 
> -- 
> "Things are only impossible until they're not"

___
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.

Re: [GNC] AQBanking OFX DirectConnect

[Martin Preuss]

Hi,

not ATM, but that can be arranged. However, how about leaving that field
empty in the settings dialog? That should default to 100 for OFXHEADER
and 102 for VERSION (for - ahem - historic reasons, I'm sure I had
good^H^H^H reasons for those mixed defaults... :-})

Regards
Martin


Am 18.03.20 um 22:26 schrieb Chris Graves:
> Nice!  I see that the change has been made, but still receive the HTTP
> 400 error.
> 
> In the AQB5 ofx.log file for a successful case, I see
> OFXHEADER:100
> VERSION:102
> 
> In the AQB6 file, I see
> OFXHEADER:102
> VERSION:102
> 
> Not sure if this could be the problem.  Is there a way to set OFXHEADER
> and VERSION independently?
> 
> 
> On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss  > wrote:
> 
> Hi,
> 
> you can change the header manually to 102/103 in the homebanking setup
> dialog (select user, edit user, switch to app settings and type-in
> header version 102).
> 
> Regards
> Martin
> 
> 
> Am 18.03.20 um 21:57 schrieb Chris Graves:
> > Hi Martin,
> >
> > Looking better!  However, to my knowledge, my bank only supports OFX
> > version 102 or 103.  I had been using 102.
> >
> > ofx.log:
> > Sending:
> > -
> > OFXHEADER:220
> > DATA:OFXSGML
> > VERSION:220
> > SECURITY:NONE
> > ENCODING:USASCII
> > CHARSET:1252
> > COMPRESSION:NONE
> > OLDFILEUID:NONE
> > NEWFILEUID:20200318135033.000
> >
> > 
> > 
> > 
> > 20200318135025.000
> >
> > On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss  
> > >> wrote:
> >
> >     Hi Chris,
> >
> >     could you please test the latest GIT version? It should create
> valid
> >     OFXv1 requests now, however, I can't test it completely since
> I only
> >     have access to an OFXv2 server...
> >
> >
> >     Regards
> >     Martin
> >
> >
> >     Am 18.03.20 um 16:31 schrieb chris graves:
> >     > An additional bit of information from /tmp/ofx.log:
> >     > AQB5:
> >     > Sending:
> >     > -
> >     > OFXHEADER:100
> >     > DATA:OFXSGML
> >     > VERSION:102
> >     > SECURITY:NONE
> >     > ENCODING:USASCII
> >     > CHARSET:1252
> >     > COMPRESSION:NONE
> >     > OLDFILEUID:NONE
> >     > NEWFILEUID:20200318081757.000
> >     >
> >     > ...
> >     [...]
> >
> >
> >     --
> >     "Things are only impossible until they're not"
> >
> 
> 
> -- 
> "Things are only impossible until they're not"
> 


-- 
"Things are only impossible until they're not"
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[Chris Graves]

Nice!  I see that the change has been made, but still receive the HTTP 400
error.

In the AQB5 ofx.log file for a successful case, I see
OFXHEADER:100
VERSION:102

In the AQB6 file, I see
OFXHEADER:102
VERSION:102

Not sure if this could be the problem.  Is there a way to set OFXHEADER and
VERSION independently?


On Wed, Mar 18, 2020 at 2:02 PM Martin Preuss  wrote:

> Hi,
>
> you can change the header manually to 102/103 in the homebanking setup
> dialog (select user, edit user, switch to app settings and type-in
> header version 102).
>
> Regards
> Martin
>
>
> Am 18.03.20 um 21:57 schrieb Chris Graves:
> > Hi Martin,
> >
> > Looking better!  However, to my knowledge, my bank only supports OFX
> > version 102 or 103.  I had been using 102.
> >
> > ofx.log:
> > Sending:
> > -
> > OFXHEADER:220
> > DATA:OFXSGML
> > VERSION:220
> > SECURITY:NONE
> > ENCODING:USASCII
> > CHARSET:1252
> > COMPRESSION:NONE
> > OLDFILEUID:NONE
> > NEWFILEUID:20200318135033.000
> >
> > 
> > 
> > 
> > 20200318135025.000
> >
> > On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss  > > wrote:
> >
> > Hi Chris,
> >
> > could you please test the latest GIT version? It should create valid
> > OFXv1 requests now, however, I can't test it completely since I only
> > have access to an OFXv2 server...
> >
> >
> > Regards
> > Martin
> >
> >
> > Am 18.03.20 um 16:31 schrieb chris graves:
> > > An additional bit of information from /tmp/ofx.log:
> > > AQB5:
> > > Sending:
> > > -
> > > OFXHEADER:100
> > > DATA:OFXSGML
> > > VERSION:102
> > > SECURITY:NONE
> > > ENCODING:USASCII
> > > CHARSET:1252
> > > COMPRESSION:NONE
> > > OLDFILEUID:NONE
> > > NEWFILEUID:20200318081757.000
> > >
> > > ...
> > [...]
> >
> >
> > --
> > "Things are only impossible until they're not"
> >
>
>
> --
> "Things are only impossible until they're not"
>
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[Martin Preuss]

Hi,

you can change the header manually to 102/103 in the homebanking setup
dialog (select user, edit user, switch to app settings and type-in
header version 102).

Regards
Martin


Am 18.03.20 um 21:57 schrieb Chris Graves:
> Hi Martin,
> 
> Looking better!  However, to my knowledge, my bank only supports OFX
> version 102 or 103.  I had been using 102.
> 
> ofx.log:
> Sending:
> -
> OFXHEADER:220
> DATA:OFXSGML
> VERSION:220
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:20200318135033.000
> 
> 
> 
> 
> 20200318135025.000
> 
> On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss  > wrote:
> 
> Hi Chris,
> 
> could you please test the latest GIT version? It should create valid
> OFXv1 requests now, however, I can't test it completely since I only
> have access to an OFXv2 server...
> 
> 
> Regards
> Martin
> 
> 
> Am 18.03.20 um 16:31 schrieb chris graves:
> > An additional bit of information from /tmp/ofx.log:
> > AQB5:
> > Sending:
> > -
> > OFXHEADER:100
> > DATA:OFXSGML
> > VERSION:102
> > SECURITY:NONE
> > ENCODING:USASCII
> > CHARSET:1252
> > COMPRESSION:NONE
> > OLDFILEUID:NONE
> > NEWFILEUID:20200318081757.000
> >
> > ...
> [...]
> 
> 
> -- 
> "Things are only impossible until they're not"
> 


-- 
"Things are only impossible until they're not"
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[chris graves]

I think that would have been a mistake, git defaults to OFXv1.

> On Mar 18, 2020, at 1:38 PM, Christopher Singley  wrote:
> 
> See the top post on this thread - John Ralls reporting that git only speaks 
> OFXv2.  However many banks only speak OFXv1.
> 
> I can confirm that I can download from USAA by speaking OFXv1.0.2.
> 
> I can no longer speak OFXv2 to USAA; something has changed on their side.
> 
> Sorry John, no workaround yet.
> 
> On 3/18/20 3:30 PM, Chris Graves wrote:
>> Here is what I was thinking were significant differences found in ofx.log.
>> AQB5 vs git, which should be defaulting to OFX 1.
>> 
>> AQB5:
>> Sending:
>> -
>> OFXHEADER:100
>> DATA:OFXSGML
>> VERSION:102
>> SECURITY:NONE
>> ENCODING:USASCII
>> CHARSET:1252
>> COMPRESSION:NONE
>> OLDFILEUID:NONE
>> NEWFILEUID:20200318081757.000
>> 
>> ...
>> 
>> git:
>> Sending:
>> -
>> 
>> 
>> ...
>> 
>> On Wed, Mar 18, 2020 at 1:23 PM John Ralls > > wrote:
>> That would be because they are XML syntax. OFX V2 is XML.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> > On Mar 18, 2020, at 1:15 PM, chris graves > > > wrote:
>> > 
>> > Because I don't see them in the AQB5 ofx.log file and to me they look like 
>> > XML syntax.  Not being knowledgeable on the subject I can't say for sure.  
>> > I thought at v1.6, the syntax was pure SMGL.  But again, I don't know what 
>> > I don't know.
>> > 
>> >> On Mar 18, 2020, at 1:12 PM, John Ralls > >> > wrote:
>> >> 
>> >> And why were you thinking that?
>> >> 
>> >> Regards,
>> >> John Ralls
>> >> 
>> >> 
>> >>> On Mar 18, 2020, at 1:05 PM, chris graves > >>> > wrote:
>> >>> 
>> >>> I was thinking that it could be the first two lines of your file below.
>> >>> 
>>  On Mar 18, 2020, at 12:40 PM, John Ralls >  > wrote:
>>  
>>  
>>  
>> > On Mar 18, 2020, at 9:33 AM, Christopher Singley > > > wrote:
>> > 
>> > You're sending VERSION="220", which USAA doesn't accept.  You need to 
>> > send VERSION="200" or VERSION="202".  Try that.
>>  
>>  No joy, I still get a 400 response, but it does occur to me that it 
>>  isn't necessarily an OFX issue, it could be that the HTTP request 
>>  itself is malformed.
>>  
>>  
>>  
>>  
>>  
>>  
>>  20200318122832
>>  
>>  
>>  ENG
>>  
>>  USAA
>>  24591
>>  
>>  QWIN
>>  2300
>>  
>>  
>>  
>>  
>>  20200318122835
>>  
>>  
>>  24591
>>  XX
>>  
>>  
>>  2020031000
>>  2020031800
>>  Y
>>  
>>  
>>  
>>  
>>  
>>  
>>  Regards,
>>  John Ralls
>>  ___
>>  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.

Re: [GNC] AQBanking OFX DirectConnect

[Chris Graves]

Hi Martin,

Looking better!  However, to my knowledge, my bank only supports OFX
version 102 or 103.  I had been using 102.

ofx.log:
Sending:
-
OFXHEADER:220
DATA:OFXSGML
VERSION:220
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:20200318135033.000




20200318135025.000

On Wed, Mar 18, 2020 at 1:32 PM Martin Preuss  wrote:

> Hi Chris,
>
> could you please test the latest GIT version? It should create valid
> OFXv1 requests now, however, I can't test it completely since I only
> have access to an OFXv2 server...
>
>
> Regards
> Martin
>
>
> Am 18.03.20 um 16:31 schrieb chris graves:
> > An additional bit of information from /tmp/ofx.log:
> > AQB5:
> > Sending:
> > -
> > OFXHEADER:100
> > DATA:OFXSGML
> > VERSION:102
> > SECURITY:NONE
> > ENCODING:USASCII
> > CHARSET:1252
> > COMPRESSION:NONE
> > OLDFILEUID:NONE
> > NEWFILEUID:20200318081757.000
> >
> > ...
> [...]
>
>
> --
> "Things are only impossible until they're not"
>
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[Christopher Singley]

See the top post on this thread - John Ralls reporting that git only 
speaks OFXv2.  However many banks only speak OFXv1.


I can confirm that I can download from USAA by speaking OFXv1.0.2.

I can no longer speak OFXv2 to USAA; something has changed on their side.

Sorry John, no workaround yet.

On 3/18/20 3:30 PM, Chris Graves wrote:

Here is what I was thinking were significant differences found in ofx.log.
AQB5 vs git, which should be defaulting to OFX 1.

AQB5:
Sending:
-
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:20200318081757.000

...

git:
Sending:
-


...

On Wed, Mar 18, 2020 at 1:23 PM John Ralls > wrote:


That would be because they are XML syntax. OFX V2 is XML.

Regards,
John Ralls


> On Mar 18, 2020, at 1:15 PM, chris graves mailto:mohaveba...@gmail.com>> wrote:
>
> Because I don't see them in the AQB5 ofx.log file and to me they
look like XML syntax.  Not being knowledgeable on the subject I
can't say for sure.  I thought at v1.6, the syntax was pure SMGL. 
But again, I don't know what I don't know.
>
>> On Mar 18, 2020, at 1:12 PM, John Ralls mailto:jra...@ceridwen.us>> wrote:
>>
>> And why were you thinking that?
>>
>> Regards,
>> John Ralls
>>
>>
>>> On Mar 18, 2020, at 1:05 PM, chris graves
mailto:mohaveba...@gmail.com>> wrote:
>>>
>>> I was thinking that it could be the first two lines of your
file below.
>>>
 On Mar 18, 2020, at 12:40 PM, John Ralls mailto:jra...@ceridwen.us>> wrote:



> On Mar 18, 2020, at 9:33 AM, Christopher Singley
mailto:csing...@gmail.com>> wrote:
>
> You're sending VERSION="220", which USAA doesn't accept. 
You need to send VERSION="200" or VERSION="202".  Try that.

 No joy, I still get a 400 response, but it does occur to me
that it isn't necessarily an OFX issue, it could be that the HTTP
request itself is malformed.

 
 
 
 
 
 20200318122832
 
 
 ENG
 
 USAA
 24591
 
 QWIN
 2300
 
 
 
 
 20200318122835
 
 
 24591
 XX
 
 
 2020031000
 2020031800
 Y
 
 
 
 
 

 Regards,
 John Ralls
 ___
 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.

Re: [GNC] AQBanking OFX DirectConnect

[Martin Preuss]

Hi Chris,

could you please test the latest GIT version? It should create valid
OFXv1 requests now, however, I can't test it completely since I only
have access to an OFXv2 server...


Regards
Martin


Am 18.03.20 um 16:31 schrieb chris graves:
> An additional bit of information from /tmp/ofx.log: 
> AQB5:
> Sending:
> -
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:102
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:20200318081757.000
> 
> ...
[...]


-- 
"Things are only impossible until they're not"
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[Chris Graves]

Here is what I was thinking were significant differences found in ofx.log.
AQB5 vs git, which should be defaulting to OFX 1.

AQB5:
Sending:
-
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:20200318081757.000

...

git:
Sending:
-


...

On Wed, Mar 18, 2020 at 1:23 PM John Ralls  wrote:

> That would be because they are XML syntax. OFX V2 is XML.
>
> Regards,
> John Ralls
>
>
> > On Mar 18, 2020, at 1:15 PM, chris graves  wrote:
> >
> > Because I don't see them in the AQB5 ofx.log file and to me they look
> like XML syntax.  Not being knowledgeable on the subject I can't say for
> sure.  I thought at v1.6, the syntax was pure SMGL.  But again, I don't
> know what I don't know.
> >
> >> On Mar 18, 2020, at 1:12 PM, John Ralls  wrote:
> >>
> >> And why were you thinking that?
> >>
> >> Regards,
> >> John Ralls
> >>
> >>
> >>> On Mar 18, 2020, at 1:05 PM, chris graves 
> wrote:
> >>>
> >>> I was thinking that it could be the first two lines of your file below.
> >>>
>  On Mar 18, 2020, at 12:40 PM, John Ralls  wrote:
> 
> 
> 
> > On Mar 18, 2020, at 9:33 AM, Christopher Singley 
> wrote:
> >
> > You're sending VERSION="220", which USAA doesn't accept.  You need
> to send VERSION="200" or VERSION="202".  Try that.
> 
>  No joy, I still get a 400 response, but it does occur to me that it
> isn't necessarily an OFX issue, it could be that the HTTP request itself is
> malformed.
> 
>  
>   OLDFILEUID="NONE"?>
>  
>  
>  
>  20200318122832
>  
>  
>  ENG
>  
>  USAA
>  24591
>  
>  QWIN
>  2300
>  
>  
>  
>  
>  20200318122835
>  
>  
>  24591
>  XX
>  
>  
>  2020031000
>  2020031800
>  Y
>  
>  
>  
>  
>  
> 
>  Regards,
>  John Ralls
>  ___
>  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.

Re: [GNC] AQBanking OFX DirectConnect

[chris graves]

But I'm using (or trying to use) OFX V1.

> On Mar 18, 2020, at 1:23 PM, John Ralls  wrote:
> 
> That would be because they are XML syntax. OFX V2 is XML.
> 
> Regards,
> John Ralls
> 
> 
>> On Mar 18, 2020, at 1:15 PM, chris graves  wrote:
>> 
>> Because I don't see them in the AQB5 ofx.log file and to me they look like 
>> XML syntax.  Not being knowledgeable on the subject I can't say for sure.  I 
>> thought at v1.6, the syntax was pure SMGL.  But again, I don't know what I 
>> don't know.
>> 
>>> On Mar 18, 2020, at 1:12 PM, John Ralls  wrote:
>>> 
>>> And why were you thinking that?
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>> 
 On Mar 18, 2020, at 1:05 PM, chris graves  wrote:
 
 I was thinking that it could be the first two lines of your file below.
 
> On Mar 18, 2020, at 12:40 PM, John Ralls  wrote:
> 
> 
> 
>> On Mar 18, 2020, at 9:33 AM, Christopher Singley  
>> wrote:
>> 
>> You're sending VERSION="220", which USAA doesn't accept.  You need to 
>> send VERSION="200" or VERSION="202".  Try that.
> 
> No joy, I still get a 400 response, but it does occur to me that it isn't 
> necessarily an OFX issue, it could be that the HTTP request itself is 
> malformed.
> 
> 
> 
> 
> 
> 
> 20200318122832
> 
> 
> ENG
> 
> USAA
> 24591
> 
> QWIN
> 2300
> 
> 
> 
> 
> 20200318122835
> 
> 
> 24591
> XX
> 
> 
> 2020031000
> 2020031800
> Y
> 
> 
> 
> 
> 
> 
> Regards,
> John Ralls
> ___
> 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.

Re: [GNC] AQBanking OFX DirectConnect

[John Ralls]

That would be because they are XML syntax. OFX V2 is XML.

Regards,
John Ralls


> On Mar 18, 2020, at 1:15 PM, chris graves  wrote:
> 
> Because I don't see them in the AQB5 ofx.log file and to me they look like 
> XML syntax.  Not being knowledgeable on the subject I can't say for sure.  I 
> thought at v1.6, the syntax was pure SMGL.  But again, I don't know what I 
> don't know.
> 
>> On Mar 18, 2020, at 1:12 PM, John Ralls  wrote:
>> 
>> And why were you thinking that?
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Mar 18, 2020, at 1:05 PM, chris graves  wrote:
>>> 
>>> I was thinking that it could be the first two lines of your file below.
>>> 
 On Mar 18, 2020, at 12:40 PM, John Ralls  wrote:
 
 
 
> On Mar 18, 2020, at 9:33 AM, Christopher Singley  
> wrote:
> 
> You're sending VERSION="220", which USAA doesn't accept.  You need to 
> send VERSION="200" or VERSION="202".  Try that.
 
 No joy, I still get a 400 response, but it does occur to me that it isn't 
 necessarily an OFX issue, it could be that the HTTP request itself is 
 malformed.
 
 
 
 
 
 
 20200318122832
 
 
 ENG
 
 USAA
 24591
 
 QWIN
 2300
 
 
 
 
 20200318122835
 
 
 24591
 XX
 
 
 2020031000
 2020031800
 Y
 
 
 
 
 
 
 Regards,
 John Ralls
 ___
 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.

Re: [GNC] AQBanking OFX DirectConnect

[chris graves]

Because I don't see them in the AQB5 ofx.log file and to me they look like XML 
syntax.  Not being knowledgeable on the subject I can't say for sure.  I 
thought at v1.6, the syntax was pure SMGL.  But again, I don't know what I 
don't know.

> On Mar 18, 2020, at 1:12 PM, John Ralls  wrote:
> 
> And why were you thinking that?
> 
> Regards,
> John Ralls
> 
> 
>> On Mar 18, 2020, at 1:05 PM, chris graves  wrote:
>> 
>> I was thinking that it could be the first two lines of your file below.
>> 
>>> On Mar 18, 2020, at 12:40 PM, John Ralls  wrote:
>>> 
>>> 
>>> 
 On Mar 18, 2020, at 9:33 AM, Christopher Singley  
 wrote:
 
 You're sending VERSION="220", which USAA doesn't accept.  You need to send 
 VERSION="200" or VERSION="202".  Try that.
>>> 
>>> No joy, I still get a 400 response, but it does occur to me that it isn't 
>>> necessarily an OFX issue, it could be that the HTTP request itself is 
>>> malformed.
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 20200318122832
>>> 
>>> 
>>> ENG
>>> 
>>> USAA
>>> 24591
>>> 
>>> QWIN
>>> 2300
>>> 
>>> 
>>> 
>>> 
>>> 20200318122835
>>> 
>>> 
>>> 24591
>>> XX
>>> 
>>> 
>>> 2020031000
>>> 2020031800
>>> Y
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> Regards,
>>> John Ralls
>>> ___
>>> 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.

Re: [GNC] AQBanking OFX DirectConnect

[Christopher Singley]

Don't worry about that.  That's a standard OFXv2 header (i.e. compliant 
XML).  The other headers you were noting earlier are OFXv1 headers (i.e. 
the weird INI-formatted key: value pairs prepended to the SGML soup).


The problem I have is that USAA bank tells me it will speak OFXv2, and 
then returns an error when I try to do so.  And then furthermore returns 
an error for validly-formed OFXv1!


None of this using AqBanking, mind. Something has changed over at USAA.

On 3/18/20 3:05 PM, chris graves wrote:

I was thinking that it could be the first two lines of your file below.


On Mar 18, 2020, at 12:40 PM, John Ralls  wrote:




On Mar 18, 2020, at 9:33 AM, Christopher Singley  wrote:

You're sending VERSION="220", which USAA doesn't accept.  You need to send VERSION="200" 
or VERSION="202".  Try that.

No joy, I still get a 400 response, but it does occur to me that it isn't 
necessarily an OFX issue, it could be that the HTTP request itself is malformed.






20200318122832


ENG

USAA
24591

QWIN
2300




20200318122835


24591
XX


2020031000
2020031800
Y






Regards,
John Ralls
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[John Ralls]

And why were you thinking that?

Regards,
John Ralls


> On Mar 18, 2020, at 1:05 PM, chris graves  wrote:
> 
> I was thinking that it could be the first two lines of your file below.
> 
>> On Mar 18, 2020, at 12:40 PM, John Ralls  wrote:
>> 
>> 
>> 
>>> On Mar 18, 2020, at 9:33 AM, Christopher Singley  wrote:
>>> 
>>> You're sending VERSION="220", which USAA doesn't accept.  You need to send 
>>> VERSION="200" or VERSION="202".  Try that.
>> 
>> No joy, I still get a 400 response, but it does occur to me that it isn't 
>> necessarily an OFX issue, it could be that the HTTP request itself is 
>> malformed.
>> 
>> 
>> 
>> 
>> 
>> 
>> 20200318122832
>> 
>> 
>> ENG
>> 
>> USAA
>> 24591
>> 
>> QWIN
>> 2300
>> 
>> 
>> 
>> 
>> 20200318122835
>> 
>> 
>> 24591
>> XX
>> 
>> 
>> 2020031000
>> 2020031800
>> Y
>> 
>> 
>> 
>> 
>> 
>> 
>> Regards,
>> John Ralls
>> ___
>> 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.

Re: [GNC] AQBanking OFX DirectConnect

[Christopher Singley]

Are you able to make OFX connection with USAA's server in any manner 
whatsoever?


I have a dormant USAA bank account that I used to be able to download, 
that now is returning HTTP 400 for the same OFX configs that used to 
work.  They haven't moved the server, have they?


(ofxtools) 11:39:27 csingley@nous ofxtools sequences ? ofxget list usaa

USAA Federal Savings Bank
ofxhome = 483
url = https://service2.usaa.com/ofx/OFXServlet
version = 103
org = USAA
fid = 24591
user = 
bankid = 314074269
savings = 
checking = 
unclosedelements = true
clientuid = 

These used to work, but now raise HTTP 400.

The problem may be larger than AqBanking...

On 3/18/20 2:40 PM, John Ralls wrote:



On Mar 18, 2020, at 9:33 AM, Christopher Singley  wrote:

You're sending VERSION="220", which USAA doesn't accept.  You need to send VERSION="200" 
or VERSION="202".  Try that.

No joy, I still get a 400 response, but it does occur to me that it isn't 
necessarily an OFX issue, it could be that the HTTP request itself is malformed.






20200318122832


ENG

USAA
24591

QWIN
2300




20200318122835


24591
XX


2020031000
2020031800
Y






Regards,
John Ralls

___
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.

Re: [GNC] AQBanking OFX DirectConnect

[chris graves]

I was thinking that it could be the first two lines of your file below.

> On Mar 18, 2020, at 12:40 PM, John Ralls  wrote:
> 
> 
> 
>> On Mar 18, 2020, at 9:33 AM, Christopher Singley  wrote:
>> 
>> You're sending VERSION="220", which USAA doesn't accept.  You need to send 
>> VERSION="200" or VERSION="202".  Try that.
> 
> No joy, I still get a 400 response, but it does occur to me that it isn't 
> necessarily an OFX issue, it could be that the HTTP request itself is 
> malformed.
> 
> 
> 
> 
> 
> 
> 20200318122832
> 
> 
> ENG
> 
> USAA
> 24591
> 
> QWIN
> 2300
> 
> 
> 
> 
> 20200318122835
> 
> 
> 24591
> XX
> 
> 
> 2020031000
> 2020031800
> Y
> 
> 
> 
> 
> 
> 
> Regards,
> John Ralls
> ___
> 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.

Re: [GNC] AQBanking OFX DirectConnect

[John Ralls]

> On Mar 18, 2020, at 9:33 AM, Christopher Singley  wrote:
> 
> You're sending VERSION="220", which USAA doesn't accept.  You need to send 
> VERSION="200" or VERSION="202".  Try that.

No joy, I still get a 400 response, but it does occur to me that it isn't 
necessarily an OFX issue, it could be that the HTTP request itself is malformed.






20200318122832


ENG

USAA
24591

QWIN
2300




20200318122835


24591
XX


2020031000
2020031800
Y






Regards,
John Ralls
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[Christopher Singley]

You're sending VERSION="220", which USAA doesn't accept.  You need to 
send VERSION="200" or VERSION="202".  Try that.


On 3/18/20 11:31 AM, John Ralls wrote:

Interesting. USAA can't parse the OFXv2 that AQBanking 6.1.2 emits. 
Unfortunately it just returns an HTTP 400 response, no details. Perhaps like v1 
there are Intuit-induced quirks in the v2 parser as well and we'd need to 
capture a v2 interaction with Quicken to figure them out.

Regards,
John Ralls


On Mar 18, 2020, at 4:35 AM, csingley  wrote:


Aside from the extra whitespace, which shouldn't matter, the git code has

closing tags on every element while the AQB5 code has closing tags only on
grouping elements.

USERID is specified in the OFX 1.6 DTD as

and according to
https://en.wikipedia.org/wiki/Standard_Generalized_Markup_Language#OMITTAG
the "- o" in the middle means that it should have an opening tag and no
closing tag.

Sorry to butt in..  MAY have, not SHOULD have.  Closing tags are optional
for OFXv1 "elements" (i.e. data-bearing leaf nodes).

But the spec doesn't really matter in the real world.  The FIs code to
Quicken, not to the spec... and Quicken sends OFXv1 with unclosed elements.
Therefore, AqBanking really should do so as well in order to be useful.

Contrary to the spec, USAA doesn't accept closing tags on elements.
However, USAA does accept OFXv2, specifically versions 202 and 205.  Just
send them XML.

Here's the result of scanning USAA's server:

(ofxtools) 6:30:50 csingley@nous ofxtools sequences ? ofxget scan usaa
[{"versions": [102, 151], "formats": [{"pretty": false, "unclosedelements":
true}, {"pretty": true, "unclosedelements": true}]}, {"versions": [200,
202], "formats": [{"pretty": false}, {"pretty": true}]}, {"chgpinfirst":
false, "clientuidreq": false, "authtokenfirst": false, "mfachallengefirst":
false}]




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[John Ralls]

Interesting. USAA can't parse the OFXv2 that AQBanking 6.1.2 emits. 
Unfortunately it just returns an HTTP 400 response, no details. Perhaps like v1 
there are Intuit-induced quirks in the v2 parser as well and we'd need to 
capture a v2 interaction with Quicken to figure them out.

Regards,
John Ralls

> On Mar 18, 2020, at 4:35 AM, csingley  wrote:
> 
>> Aside from the extra whitespace, which shouldn't matter, the git code has
> closing tags on every element while the AQB5 code has closing tags only on
> grouping elements.
>> 
>> USERID is specified in the OFX 1.6 DTD as
>> 
>> and according to
>> https://en.wikipedia.org/wiki/Standard_Generalized_Markup_Language#OMITTAG
>> the "- o" in the middle means that it should have an opening tag and no
>> closing tag.
> 
> Sorry to butt in..  MAY have, not SHOULD have.  Closing tags are optional
> for OFXv1 "elements" (i.e. data-bearing leaf nodes).
> 
> But the spec doesn't really matter in the real world.  The FIs code to
> Quicken, not to the spec... and Quicken sends OFXv1 with unclosed elements. 
> Therefore, AqBanking really should do so as well in order to be useful.
> 
> Contrary to the spec, USAA doesn't accept closing tags on elements. 
> However, USAA does accept OFXv2, specifically versions 202 and 205.  Just
> send them XML.
> 
> Here's the result of scanning USAA's server:
> 
> (ofxtools) 6:30:50 csingley@nous ofxtools sequences ? ofxget scan usaa
> [{"versions": [102, 151], "formats": [{"pretty": false, "unclosedelements":
> true}, {"pretty": true, "unclosedelements": true}]}, {"versions": [200,
> 202], "formats": [{"pretty": false}, {"pretty": true}]}, {"chgpinfirst":
> false, "clientuidreq": false, "authtokenfirst": false, "mfachallengefirst":
> false}]
> 
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.

Re: [GNC] AQBanking OFX DirectConnect

[Christopher Singley]

Thanks.  Just, y'know, keep it cool on the profile scanning... each one 
spams a lot of requests.


Your bank's server has an OK parser... standards-compliant OFXv1.0.3 
(what Quicken sends).  Sadly no OFXv2 support.


On 3/18/20 10:50 AM, Chris Graves wrote:

ofxtools -- nice toolset!

Here are the results from my bank:
ofxget scan kinecta
[{"versions": [102, 103], "formats": [{"pretty": false, 
"unclosedelements": false}, {"pretty": false, "unclosedelements": 
true}, {"pretty": true, "unclosedelements": false}, {"pretty": true, 
"unclosedelements": true}]}, {"versions": [], "formats": []}, 
{"chgpinfirst": false, "clientuidreq": true, "authtokenfirst": false, 
"mfachallengefirst": false}]


On Wed, Mar 18, 2020 at 4:38 AM csingley > wrote:


> Aside from the extra whitespace, which shouldn't matter, the git
code has
closing tags on every element while the AQB5 code has closing tags
only on
grouping elements.
>
> USERID is specified in the OFX 1.6 DTD as
> 
> and according to
>
https://en.wikipedia.org/wiki/Standard_Generalized_Markup_Language#OMITTAG
> the "- o" in the middle means that it should have an opening tag
and no
> closing tag.

Sorry to butt in..  MAY have, not SHOULD have.  Closing tags are
optional
for OFXv1 "elements" (i.e. data-bearing leaf nodes).

But the spec doesn't really matter in the real world.  The FIs code to
Quicken, not to the spec... and Quicken sends OFXv1 with unclosed
elements.
Therefore, AqBanking really should do so as well in order to be
useful.

Contrary to the spec, USAA doesn't accept closing tags on elements.
However, USAA does accept OFXv2, specifically versions 202 and
205.  Just
send them XML.

Here's the result of scanning USAA's server:

(ofxtools) 6:30:50 csingley@nous ofxtools sequences ? ofxget scan usaa
[{"versions": [102, 151], "formats": [{"pretty": false,
"unclosedelements":
true}, {"pretty": true, "unclosedelements": true}]}, {"versions":
[200,
202], "formats": [{"pretty": false}, {"pretty": true}]},
{"chgpinfirst":
false, "clientuidreq": false, "authtokenfirst": false,
"mfachallengefirst":
false}]




--
Sent from:
http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] AQBanking OFX DirectConnect

[Chris Graves]

ofxtools -- nice toolset!

Here are the results from my bank:
ofxget scan kinecta
[{"versions": [102, 103], "formats": [{"pretty": false, "unclosedelements":
false}, {"pretty": false, "unclosedelements": true}, {"pretty": true,
"unclosedelements": false}, {"pretty": true, "unclosedelements": true}]},
{"versions": [], "formats": []}, {"chgpinfirst": false, "clientuidreq":
true, "authtokenfirst": false, "mfachallengefirst": false}]

On Wed, Mar 18, 2020 at 4:38 AM csingley  wrote:

> > Aside from the extra whitespace, which shouldn't matter, the git code has
> closing tags on every element while the AQB5 code has closing tags only on
> grouping elements.
> >
> > USERID is specified in the OFX 1.6 DTD as
> > 
> > and according to
> >
> https://en.wikipedia.org/wiki/Standard_Generalized_Markup_Language#OMITTAG
> > the "- o" in the middle means that it should have an opening tag and no
> > closing tag.
>
> Sorry to butt in..  MAY have, not SHOULD have.  Closing tags are optional
> for OFXv1 "elements" (i.e. data-bearing leaf nodes).
>
> But the spec doesn't really matter in the real world.  The FIs code to
> Quicken, not to the spec... and Quicken sends OFXv1 with unclosed
> elements.
> Therefore, AqBanking really should do so as well in order to be useful.
>
> Contrary to the spec, USAA doesn't accept closing tags on elements.
> However, USAA does accept OFXv2, specifically versions 202 and 205.  Just
> send them XML.
>
> Here's the result of scanning USAA's server:
>
> (ofxtools) 6:30:50 csingley@nous ofxtools sequences ? ofxget scan usaa
> [{"versions": [102, 151], "formats": [{"pretty": false, "unclosedelements":
> true}, {"pretty": true, "unclosedelements": true}]}, {"versions": [200,
> 202], "formats": [{"pretty": false}, {"pretty": true}]}, {"chgpinfirst":
> false, "clientuidreq": false, "authtokenfirst": false, "mfachallengefirst":
> false}]
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.

Re: [GNC] AQBanking OFX DirectConnect

[chris graves]

An additional bit of information from /tmp/ofx.log: 
AQB5:
Sending:
-
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:20200318081757.000

...

git:
Sending:
-


...

> On Mar 17, 2020, at 10:40 AM, John Ralls  wrote:
> 
> 
> 
>> On Mar 17, 2020, at 9:45 AM, John Ralls  wrote:
>> 
>> 
>> 
>>> On Mar 15, 2020, at 1:21 PM, John Ralls  wrote:
>>> 
 
 On Mar 15, 2020, at 12:47 PM, Martin Preuss  wrote:
 
 Hi,
 
 Am 15.03.20 um 20:17 schrieb John Ralls:
> I just made a MacOS build with the latest AQBanking so I could test it 
> with my bank (USAA). No go, and a bit of troubleshooting reveals that 
> it's because AQBanking now uses the XML-based OFX V2. AFAIK that's not 
> supported by any US bank.
 [...]
 
 OFX2 is the only version I could get access to a test server for, so
 thats what I implemented so far.
 
 However, since the OFX spec state that banks should also accept XML like
 OFX requests (i.e. OFX files with closing XML elements) the code might
 be adjustable for this...
 
 I will try to add a mode in which the plugin sends the headers
 previously used for OFX1 and still send requests with closing XML
 elements, at least according to the specs I read that should work...
 
 Anyway, as I wrote before I can't test it myself. There is only person -
 so far - I heard of from the US who tested the latest code with a real
 server and I really appreciate his help, but he seems to be using the
 prebuilt Windows version which makes the debug process... well... 
 difficult.
 
 It would be extremely helpfull to have someone who could compile and
 test a version from GIT, but given the different timezones the possible
 OFX users and I live in that might be time consuming for both sides...
>>> 
>>> Martin,
>>> 
>>> As I said here and in my bug report, AQB 5's OFX backend works well and has 
>>> done for many years. If you just update it for the new AQB6 and Gwen5 API 
>>> it has a good chance of working.
>>> 
>>> I can build from git and test. So far there's no need for debugging, simply 
>>> comparing the OFX from 5.8 and 6.1 showed me the problem: OFX DirectConnect 
>>> servers using V1 can't parse the XML you send in the request and 400, see 
>>> the transcripts in the bug report.
>>> 
>>> The current OFX spec doesn't matter if the bank is using software written 
>>> for OFX V1 as nearly all in the US do.
>> 
>> Martin,
>> 
>> Frank noticed yesterday that you'd pushed a large OFX V1 change to AQBanking 
>> master, so I pulled it and tested it. Unfortunately its a total fail because 
>> the V1 code formats the OFX in XML.
>> 
>> V1 servers cannot parse XML and return a 400 error.
> 
> Martin,
> 
> Sorry, that's not quite right. It's not XML, but it does still 400. The 
> headers match those sent by AQB5, but the AQB5 request block is
> 
> 20200315112517XX
> X
> ENGUSAA24591QWIN2300202003151125171202003140020200315112517Y
> 
> unrolled and indented:
> 
>  
>
>  20200315112517
>  XX
>  X
>  ENG
>  
>USAA
>24591
>  
>  QWIN
>  2300
>
>  
>  
>
>  20200315112517
>  1
>  
>
>  
>
>
>  2020031400
>  20200315112517
>  Y
>
>  
>
>  
> 
> 
> 
> and git V1 sends
> 
> 
> 
> 20200317095100
> 
> 
> ENG
> 
> USAA
> 24591
> 
> QWIN
> 2300
> 
> 
> 
> 
> 20200317095103
> 
> 
> 24591
> 
> 
> 
> 2020031400
> 2020031700
> Y
> 
> 
> 
> 
> 
> 
> Aside from the extra whitespace, which shouldn't matter, the git code has 
> closing tags on every element while the AQB5 code has closing tags only on 
> grouping elements.
> 
> USERID is specified in the OFX 1.6 DTD as
> 
> and according to 
> https://en.wikipedia.org/wiki/Standard_Generalized_Markup_Language#OMITTAG 
> the "- o" in the middle means that it should have an opening tag and no 
> closing tag.
> 
> Regards,
> John Ralls
> 
> 
> 
> 
> 
> ___
> 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 

Re: [GNC] AQBanking OFX DirectConnect

[csingley]

> Aside from the extra whitespace, which shouldn't matter, the git code has
closing tags on every element while the AQB5 code has closing tags only on
grouping elements.
> 
> USERID is specified in the OFX 1.6 DTD as
> 
> and according to
> https://en.wikipedia.org/wiki/Standard_Generalized_Markup_Language#OMITTAG
> the "- o" in the middle means that it should have an opening tag and no
> closing tag.

Sorry to butt in..  MAY have, not SHOULD have.  Closing tags are optional
for OFXv1 "elements" (i.e. data-bearing leaf nodes).

But the spec doesn't really matter in the real world.  The FIs code to
Quicken, not to the spec... and Quicken sends OFXv1 with unclosed elements. 
Therefore, AqBanking really should do so as well in order to be useful.

Contrary to the spec, USAA doesn't accept closing tags on elements. 
However, USAA does accept OFXv2, specifically versions 202 and 205.  Just
send them XML.

Here's the result of scanning USAA's server:

(ofxtools) 6:30:50 csingley@nous ofxtools sequences ? ofxget scan usaa
[{"versions": [102, 151], "formats": [{"pretty": false, "unclosedelements":
true}, {"pretty": true, "unclosedelements": true}]}, {"versions": [200,
202], "formats": [{"pretty": false}, {"pretty": true}]}, {"chgpinfirst":
false, "clientuidreq": false, "authtokenfirst": false, "mfachallengefirst":
false}]




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.