You are right. I agree with you. I noticed this last night. On Tue, Jan 4, 2022 at 10:02 AM john <jra...@ceridwen.us> 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 <macdougall.je...@gmail.com> > 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 <jra...@ceridwen.us> 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 <jra...@ceridwen.us> 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/ <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 <c...@ellisonet.ca> 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. > > > > > > > > <downloadtransactions.png><ofxhome.png> > > > -- * 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.
