[Kmymoney-devel] KMyMoney: Import CSV file from bank (csvbankingqif.py)

[aga]

On Friday 02 Apr 2010 13:10:36 you wrote:
> Hi,
> 
> thanks for your answer. I use the packman repository here on my open suse
> linux machine and use their kmymoney package(s) so compiling from source
> is not a good idea for me here :-(
> 
> Is there another way I can test your new import plugin? With your mentioned
> patches?
> 
> I also tried your python script (which has version date "Sat 31 Oct. 2009"
>  in it) and it works ok. I use following csv file format:
> 
> #Date;Details;Credits;Debits;Verwendungszweck
> #02 10 2009;HERMANN HERZ;400;;MIETE 05.2009 U. HAUSHALTSGELD
> 
> Is there a chance I can have these additional informations "MIETE 05.2009
>  U. HAUSHALTSGELD" in kmymoney notice field? (see screenshot attached)
> 
> And also, do I have to edit my bank csv file to split the amount of the
> transaction in two different columns (credits, debits) or can I have it
> it only one column with 400 for credit and -400 for debits?
> 
> Thanks
> Hermann H.

Hi Hermann (hope that's right this time)

No, I'm afraid that if you want to stick with packman, then you have to forgo 
the plugin method, until it is accepted.  The packman repo will be the 
openSuse official release, easy to upgrade, but not 'cutting edge'.  To use 
the patches involves compiling the source.  That however is pretty straight 
forward, once the prerequisites are in place, and involves only two or three 
commands.  If you're not familiar with compiling then patching invilves an 
extra stage, so you may be best staying with the script.

You don't need to have two columns for debit/credits.  If your bank supplies 
just one field, then you should label that column as 'Amount', and all should 
be well.  So far as capturing the additional data is concerned, then as it 
stands the script does not accept that.  The need for that sort of requirement 
is why I abandoned the script approach and went for a plugin with GUI.  
However, I did provide someone else with a different script with additional 
fields being dumped into the 'Memo' (notice?) field, but it would need to be 
altered again to suit you.  If you wish, and while we wait for the plugin to 
be accepted, I'll have another look at that.  I've just had another thought, 
too, so that's something else I'll need to look at.  Just had a look, and it's 
not quite what I hoped, but I did produce a free-standing program with a GUI 
that can produce a QIF file, or rather it could if I amend it.  I'll see what 
I can do.

It would be good though if one of the developers could spare some time to look 
at the plugin, to save this faffing about.

Allan

> Am Donnerstag 01 April 2010 (17:03:25) schrieb Hermann H., kmymoney-
> 
> devel at kde.org:
> > On Thursday 01 Apr 2010 14:54:22 you wrote:
> > > Hi,
> > >
> > > I have managed my online banking account through an app called
> > >  "jameica/hibiscus". From there I have exported a csv format file for
> > > my transactions and now I want to import this csv file into kmymoney2
> > > (version 3.97.0-42.pm.42.2).
> > >
> > > I found your attached csvbankingqif.py file and wondered if I can do
> > > that with that file? Is ist the newest version?
> > > Is this possible?
> > >
> > > Thanks a lot!!!!!
> > >
> > > Regards,
> > > Heart
> >
> > Hi Heart?
> >
> > That probably is the latest version (but your attachment was 0 bytes),
> > and it may be possible for you to use it.  It is suited to input of csv
> > files as from a bank.  Much depends on the format of your csv file, and
> > if you could supply an non-incriminating version I could check, or you
> > could just try it yourself, as per the instructions at the top of the
> > file.
> >
> > I have since taken a different approach, in an attempt to cope with csv
> >  file layout differences and individual preferences, and have produced a
> >  plugin for use with KMM version 3/9X, which I see you have.  The csv is
> >  awaiting the approval of the KMM developers prior to being accepted, but
> >  of course they have been otherwise occupied lately!  (NB. to the
> >  developers.  Please let me know when you may be able to go ahead as I
> > have made some minor changes.)
> >
> > However, if you are able to compile from the source (or are willing to
> >  try), I can either provide patches to implement it on a trial basis, or
> > as a file plus some minor edits to KMM files (with instructions) to allow
> > you to test it out.
> >
> > I've been using it for a few months without problem with different
> > institutions and formats and locales, and for me it works well, to the
> >  extent that I prefer it to qif import, where the bank gives a choice.
> >
> > Let me know if you want to try the plugin, or if you try the py script
> > and have problems, then I'll be glad to try and help.
> >
> > Allan
> 
> !DSPAM:4bb5dea4212535019919123!
>