Convert rabobank csv file to qif

[Tommy Trussell]

On Wed, Jul 23, 2014 at 10:06 AM, Marcel <marcel.roolvink at gmail.com> wrote:

> Hi Erik,
>
> I would like to use gnucash to manage my cashflow. My bank is the Rabobank
> and I would like to import the transactions automatically. I came across
> your program to do this (rabocsv_to_qif) but it doesn't seem to work for
> me. When I run the program I get a lot of output :
> Failed to parse (this is normal for the last line in the file):
> ['NL23RABO....
> but no transactions are written to the output file. I'm not familiar with
> python, so I can't analyse what the program does exactly.  It's possible
> that the progrma is causing an error because the IBAN codes have been
> introduced in the new bank accounts.
>
> Can you please help?
>
> Kind regards,
>
> Marcel Roolvink
>
>
Greetings! I am not the OP but saw your message and wanted to point out the
original message you discovered was from March 9, 2010, and there was a
follow-up message on July 29, 2013 with some suggested changes to fix the
script.

It would have been helpful to have quoted the original message so people
know the context and to which Erik you were addressing, and then to ask
your question below the quoted message so people can follow the discussion.

For yours and others' convenience, I'm quoting both the original and
follow-up messages here:

On Tue, Mar 9, 2010 at 2:55 PM, erik <e.m.schepers at gmail.com> wrote:

>
> Hi all,
>
> Since there seems to be no good script available anymore to convert (Ducth)
> rabobank csv files to QIF format to import them in gnucash, I rolled my
> own.
>
> The advantage of this script over the old rabocsv2qif script (besides that
> it is available), is that it can convert a csv file containing data from
> multiple accounts into a single QIF, which will import correct into
> gnucash.
>
> I made the python script available at:
> http://members.home.nl/emschepers/rabocsv_to_qif.py
> (under the GPL license)
>
> Erik
>

On Mon, Jul 29, 2013 at 5:46 AM, FJM <f.mosch at hccnet.nl> wrote:

> Hi All,
>
> In order to use rabocsv_to_qif.py with the new download format it is
> necessary to add 3 variables to the line:
>
> def __init__(self, account, valuta, date, debcred, amount, payee, descr0,
> interest_date, code0, code1, descr1, descr2, descr3, descr4, descr5,
> descr6):
>
> I changed it into:
>
> def __init__(self, account, valuta, date, debcred, amount, payee, descr0,
> interest_date, code0, code1, descr1, descr2, descr3, descr4, descr5,
> descr6,
> descr7, descr8, descr9):
>
> It worked for me.
>
> FJM.
>





> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>