[Kmymoney-devel] request for interest in CSV2QIF filter (written in Perl)
teus at theunis.org
Sat Mar 26 13:06:52 CET 2011
After using KMyMoney for two years now with firstly a quite simple Perl program during the time of KMM2 use extended CSV to QIF filter on a few dutch banks (ING, ABN-AMRO, Rabo, NIBC, Bank of Scotland) for a handful persons and about 20 bank account I rewrote lately the program so it is more adaptive and more useful for others as well.
De Perl filter is heavily modular and is easy to extend for other types of CSV fin. records as well.
The filter is quite self supporting. For vCards management it depends on Text::vCard. vCard handling is optional so it will be turned off if the Perl module is not available in the system. The INI file at the payee info section will suffice then. The filter does not use the Text::CSV module as I discovered some people have trouble installing Perl modules.
What does it do:
- tunable account naming via INI file
- automatic category detection on input patterns
- check of account numbers in use
- payee name automatic correction
- payee location detection
- building payee data base
- payee info management as eg bank accounts, customer reference
- interaction with vCard database so KAdddressBook can deal with it and correct payee info
update payee info as well vCard DB automatically
- intelligence to create a consistant payee DB within KMM2 on names in use (eg via account as ref model)
- ready for output in stead of QIF as well OFX
- add unique transaction numbers when needed to avoid double records.
- OFX is on the to do list (a CSV2OFX converter) and should be easy.
- the script is in Perl. This is a religious choice :-)
The filter is for now in development state as it needs more testing by others as myself.
Rabo bank is not tested as I wrote the routine from the description I found on their web site.
More banks are needed as I did not find documents and test sets of those banks.
What do I need from KMM2:
KMM2 does not handle bank account numbers in payee info (and it should imho).
KMM2 should handle QIF payee records fully (address info, etc) so it can take up this way eg info provided from CSV records (yes address info is sometimes available via that way) or in this case via vCards with KAddressBook.
Is there interest in that part?
What am I asking:
- more descriptions and test sets for other banks
- a location at KMyMoney development tree to make this filter more general available and get help.
Respond to me directly if you want a preview of the CSV2QIF filter so I send you the Perl script.
NB yes I know there exists a PHP script which logs into ING accounts and should be able to download CSV records in an automatic and periodic way. If KMM2 is able to run in batch style it could import the records fully automatic. Warning: this opens the door for others to break into your bank account. Eg build this as app into your mobile and even if the bank is checking operations via SMS it will succeed fully. Food for security people...
More information about the KMyMoney-devel