search

BananaAccounting / General

Excel and Banana Apps that works with Banana Accounting
Other
8 stars 9 forks source link

Import filter #4

Closed fuerst closed 8 years ago

fuerst commented 8 years ago

I'm looking for an examples of an import filter script for importing transactions (CSV) into accounting. In General/TutorialApps/tutorial2.ac2 there is an section IMPORT within the Documents tab. It is empty though. I tried to adopt the existing ch.banana.filter.import.raiffeisen.js to the format used by my Bank (GLS Bank, Germany) but ended up with the Unknow format error.

Question is: how do I debug an import filter script?

dzucchetti commented 8 years ago

Thank for your feedback. We have added a new page especially for importing CSV https://github.com/BananaAccounting/General/tree/master/ImportApps with a better template and more information Le us know.

fuerst commented 8 years ago

That works great, thanks! I now have a working import filter for the CSV transaction export file of GLS Bank (Germany).

Two notes though:

  1. I have to Banana.Converter.toInternalAmountFormat(convertedData["Income"]); inside postProcessIntermediaryData() to actually get the amount imported.
  2. After selecting a CSV file from the Import into accounting dialog and clicking OK I get a File not found error (systemmsg::err_filenontrovato). Importing CSV data from the clipboard works well though.
dzucchetti commented 8 years ago

Perfect! Do you want to contribute back? In case do it on the same directory.

  1. I think the Banana.Converter.toInternalAmountFormat(convertedData["Income"]); could be used also in the defineConversionParam.
  2. It is a know bug in Banana with relative path, that will be fixed in a next release.
  3. We have also developped other tools for Germany that are not yet published. In case you have some more needs contact me at domenico@banana.ch
fuerst commented 8 years ago

Would be glad to share. What about naming of the file. Should it something like import.glsbank.template.js, ch.banana.filter.import.glsbank.js or de.fuerstnet.import.filter.glsbank.js (my company).

dzucchetti commented 8 years ago

Thank. We have not yet set standards. But I think. "import.de.glsbank.csv.js" would be ok. It would be interesting also to have one csv file (just one row of data) "import.de.glsbank.csv.csv".