[Kmymoney-devel] XML Import Request

[Allan]

On 27/06/14 14:18, Jennifer Wensel wrote:
> Hello,
>
> I'm just now installing KMyMoney, and see that I won't be able to import
> from my bank, which only exports statements using XML and PDF. I'm a
> busy mom, not a programmer, so I certainly can't write this plugin
> myself. Any chance someone else could do it? My bank is KiwiBank, the
> national bank of New Zealand, so this would be useful to other Kiwi's
> over here on this side of the world.
>
> In the meantime, do you know of any way to easily convert either of
> those files to something that would import? I use Foxit Phantom PDF
> which should do image recognition, do you know how well it would put the
> PDF into something that could become CSV? My credit card statements (the
> most important ones for me, are only offered in PDFs, not XMLs).
>
> Thanks,
> Jennifer
>

Hi Jennifer

There is actually a script in the KMyMoney/contrib folder which will 
convert from PDF to QIF for importing.  However, it requires some 
knowledge of regex to setup to match your fields.  I did get it working 
for me, but it was not simple, and instead I resorted to copying the 
data from the bank site and pasting it into a text editor, to format it 
as CSV.  Fortunately, I only needed to use it infrequently.

If you don't have access to the KMM source, I could send you the two 
scripts, if you want to investigate.

So far as the XML option is concerned, perhaps you could post a specimen 
file, obviously with personal stuff changed, as long as the format is 
preserved.

With banks, sometimes the best option is to vote with your feet and move 
to a bank that's in the real world.

Allan