Re: [GNC] OFX connections
On Fri, Feb 19, 2021 at 11:05 John Ralls wrote: > Tom, ... > GnuCash already has a CSV import facility: Use File>Import>Import > Transactions from CSV. There you can associate columns in the CSV with > GnuCash fields and adjust CSV parameters. Once you have it set up you can > save the configuration for reuse. The configs are saved in the book state > file and aren't amenable to sharing. Thanks, John, I didn't realize that (or forgot about it), and it's good to know! I will pass that on to my children for sure. (AFAIK they haven't started using it yet, but they can't say they haven't heard about it!) Best regards, -Tom ___ 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] OFX connections
Tom, The security implications of enabling the webkit instance in GnuCash to connect to the network are dire, especially on Microsoft Windows where WebKit is stuck on a 10 year old release with hundreds of CVEs. I suppose someone might write a browser plugin to initiate the CSV downloads from bank websites once the user has authenticated but I suspect it would be difficult and wouldn't contribute much. It's generally only a couple of clicks on any particular website. GnuCash already has a CSV import facility: Use File>Import>Import Transactions from CSV. There you can associate columns in the CSV with GnuCash fields and adjust CSV parameters. Once you have it set up you can save the configuration for reuse. The configs are saved in the book state file and aren't amenable to sharing. Regards, John Ralls > On Feb 19, 2021, at 8:36 AM, Tom Browder wrote: > > On Thu, Feb 18, 2021 at 23:27 John Ralls wrote: > I'm pretty sure David was being facetious. There's approximately zero chance > that any bank is going to undertake developing a new transfer protocol. > > How many banks and financial houses still allow CVS download? All of ours do: > TD Ameritrade (recently bought by Schwab), Fidelity, Fidelity Credit Card, > Synovus Bank, Synovus Card Services, USAA (recently integrated software-wise > with Schwab), and American Express Credit Card. > > How much effort to add a hook to GNU Cash to initiate the download? > > How much effort to add a CVS to GNU Cash converter? > > All of those CSV converters would probably require help from users having > accounts, and maybe a first step would be a Perl (or Raku) CSV => OFX (or > some other useful format) converter which I could help with. > > I already have some converters from CSV to other formats for Fidelity and TD > Ameritrade products (in Raku), but I haven't looked at OFX in a long time (I > do not enjoy working with XML in the least, but converting to XML is not so > bad). > > I would also be willing to donate to the effort if it were deemed feasible > and of interest. > > -Tom ___ 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] OFX connections
On Thu, Feb 18, 2021 at 23:27 John Ralls wrote: > I'm pretty sure David was being facetious. There's approximately zero > chance that any bank is going to undertake developing a new transfer > protocol. How many banks and financial houses still allow CVS download? All of ours do: TD Ameritrade (recently bought by Schwab), Fidelity, Fidelity Credit Card, Synovus Bank, Synovus Card Services, USAA (recently integrated software-wise with Schwab), and American Express Credit Card. How much effort to add a hook to GNU Cash to initiate the download? How much effort to add a CVS to GNU Cash converter? All of those CSV converters would probably require help from users having accounts, and maybe a first step would be a Perl (or Raku) CSV => OFX (or some other useful format) converter which I could help with. I already have some converters from CSV to other formats for Fidelity and TD Ameritrade products (in Raku), but I haven't looked at OFX in a long time (I do not enjoy working with XML in the least, but converting to XML is not so bad). I would also be willing to donate to the effort if it were deemed feasible and of interest. -Tom ___ 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] OFX connections
Richard, None of the developers of GnuCash are paid to work on the program. They volunteer their time freely . There are very few of them attempting to support a very complex program, and they do this on the side after their day job or retired life. GnuCash is free to the user, and we cannot demand any particular feature or even that they fix bugs. We should be grateful to the developers for their contributions. They have made GnuCash the fine program that it is. They are always looking for additional volunteers. If you have a skill that you can contribute, they would love your help. On Thu, Feb 18, 2021 at 11:14 PM John Ralls wrote: > I'm pretty sure David was being facetious. There's approximately zero > chance that any bank is going to undertake developing a new transfer > protocol. The trend is that Quicken's propietary Web Connect authentication > is what's supported. We've kept USAA going only because USAA decided to > stick with DirectConnect and Quicken made it easy to reverse-engineer the > new authentication arrangement. > > Now if somebody can reverse engineer Web Connect I'm sure Martin would be > willing to implement it if it's feasible. He has the advantage of being > largely beyond the reach of the DMCA. > > Ideally Congress would mandate something like Germany's FinTS for the US. > That campaign would need some very wealthy donors to bankroll it, the > lobbying against such a mandate from the banking industry and from Intuit > will be intense and they have a lot of money and lobbyists. > > Regards, > John Ralls > > > On Feb 18, 2021, at 3:09 PM, David Carlson > wrote: > > > > -- Forwarded message --------- > > From: Richard > > Date: Thu, Feb 18, 2021 at 3:22 PM > > Subject: Re: [GNC] OFX connections > > To: David Carlson > > > > > > How do I go about that? > > > > I use several banks for credit cards, etc. > > > > I am not afraid to ask them. > > On 2/18/2021 4:03 PM, David Carlson wrote: > > > > Maybe your bank would sponsor you to develop one. > > > > On Thu, Feb 18, 2021, 2:54 PM Richard via gnucash-user < > > gnucash-user@gnucash.org> wrote: > > > >> I saw a long list of banks that do not support OFX connections. > >> > >> That being said, is there a newer bank access protocol under development > >> for gnucash. > >> > >> Richard > >> > >> ___ > >> 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. > >> > > > > > > -- > > David Carlson > > ___ > > 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. > > -- David Carlson ___ 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] OFX connections
I'm pretty sure David was being facetious. There's approximately zero chance that any bank is going to undertake developing a new transfer protocol. The trend is that Quicken's propietary Web Connect authentication is what's supported. We've kept USAA going only because USAA decided to stick with DirectConnect and Quicken made it easy to reverse-engineer the new authentication arrangement. Now if somebody can reverse engineer Web Connect I'm sure Martin would be willing to implement it if it's feasible. He has the advantage of being largely beyond the reach of the DMCA. Ideally Congress would mandate something like Germany's FinTS for the US. That campaign would need some very wealthy donors to bankroll it, the lobbying against such a mandate from the banking industry and from Intuit will be intense and they have a lot of money and lobbyists. Regards, John Ralls > On Feb 18, 2021, at 3:09 PM, David Carlson > wrote: > > -- Forwarded message - > From: Richard > Date: Thu, Feb 18, 2021 at 3:22 PM > Subject: Re: [GNC] OFX connections > To: David Carlson > > > How do I go about that? > > I use several banks for credit cards, etc. > > I am not afraid to ask them. > On 2/18/2021 4:03 PM, David Carlson wrote: > > Maybe your bank would sponsor you to develop one. > > On Thu, Feb 18, 2021, 2:54 PM Richard via gnucash-user < > gnucash-user@gnucash.org> wrote: > >> I saw a long list of banks that do not support OFX connections. >> >> That being said, is there a newer bank access protocol under development >> for gnucash. >> >> Richard >> >> ___ >> 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. >> > > > -- > David Carlson > ___ > 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] OFX connections
Maybe your bank would sponsor you to develop one. On Thu, Feb 18, 2021, 2:54 PM Richard via gnucash-user < gnucash-user@gnucash.org> wrote: > I saw a long list of banks that do not support OFX connections. > > That being said, is there a newer bank access protocol under development > for gnucash. > > Richard > > ___ > 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.