wish: preprocessing script and/or CSV map files
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
HomeBank |
Confirmed
|
Wishlist
|
Unassigned |
Bug Description
It would be useful to have HomeBank automatically run transaction data through a customizable transformation upon import. For example, it would be helpful to be able to run HB_Convert (or something similar) automatically on importing a csv. This would also be helpful for other formats such as QIF. In the QIF files exported from Bendigo Bank Australia, the memo and payee fields are identical and includes information such as the amount in the original currency. It also includes useless categories that I'd rather not import.
Perhaps this feature could be as simple as running an external program of the user's choosing. The external program would receive a single row of the transaction via STDIN and return more useful information for the transaction via STDOUT.
I know it's possible to do all this manually, but doing it manually takes time that could be spent doing more important stuff in HomeBank. Also, it would make the transformation programs much simpler and more standardized. This would allow for a repository of such transformations. Such repository would be a open source alternative to the data parsing component of Yodlee.
tags: | removed: wish |
summary: |
- wish: Transaction data transformation on import + wish: csv mapping for import |
summary: |
- wish: csv mapping for import + wish: csv mapping external file for import |
Changed in homebank: | |
status: | New → Confirmed |
summary: |
- wish: csv mapping external file for import + wish: preprocessing script and/or CSV map files |
As we are here focused on CSV, I more think about some external mapping file to could be share and enable to map any csv format to HB fields.