Feature Requests Incident #20112
It may also be useful to take the Firefox "Export to CSV" plugin and adapt it to feed data to xTuple (possibly through one of the middleware options just mentioned)
The Export to CSV plugin simply lets a user click any HTML table in a bank or vendor web site and save the cell contents as CSV data.
A generalized version of the plugin could route the CSV data into xTuple somehow
This has been discussed on the SF Conservancy npo-accounting mailing list thread here:
Here are my thoughts/observations on the strategy for this issue:
a) it is not a problem that is unique to xTuple
b) it could be a pain to keep in sync with the API options offered by all the different banks around the world
c) therefore, it may be better to solve this through the creation of some middleware component that can be shared between free software accounting suites
Here are some options that could fulfil this strategy:
GnuCash is already using a middleware called Aqbanking. AqBanking appears to have a focus on the German market (where German banks provide a comprehensive API using common standards) although it appears generic enough that it could support US use too.
Another option that has been pointed out is LedgerHub - http://furius.ca/ledgerhub/
This was raised four times under the kickstart project by:
Online connection to banks (for online bank rec) Ability to download transactions daily or whatever period for reconciliation (see what Xero does). There is a free service which has a connections to thousands of banks which they are leveraging. I can't remember the name of the service, but I can find out if necessary.
|Project||XTUPLEAPPS||Ported From Mantis||x|
SubscribersYou do not have permission to view subscribers.
|04/23/13 09:51||dcsint||Characteristic Kickstart Added: "True"|
|04/21/13 10:06||dcsint||New||Incident Added|
|04/21/13 10:33||dcsint||Description Updated: "Online connection to..." -> "Online connection to..."|
|04/21/13 14:39||dcsint||Status||Status Changed: New -> Confirmed|
|07/01/13 15:24||jrogelstad||Characteristic Time Estimate Added: "80"|
|03/10/15 09:29||gmoskowitz||Severity||Severity Changed: -> Normal|
|03/10/15 09:29||gmoskowitz||Priority||Priority Changed: -> Normal|