gnucash crashes during csv import - what's the approved csv formats?
John Ralls
jralls at ceridwen.us
Sun Mar 26 16:20:26 EDT 2017
> On Mar 26, 2017, at 1:08 PM, Karin Lagesen <karin.lagesen at gmail.com> wrote:
>
> Hi!
>
> I am having trouble importing the DNB (Den Norske Bank)'s csv format. It _looks_ good, but no matter how much fiddling I do with it, I always end up with crashing gnucash.
>
> The format I get looks like this (edited descriptions and amounts to remove personal information).
>
> "Dato";"Forklaring";"Rentedato";"Ut av konto";"Inn på konto"
> "01.10.2016";"Description";"03.10.2016";"10.000,00";""
> "11.10.2016";"Description with norw. characters ";"11.10.2016";"";"10.000,20"
> "13.10.2016";"Description";"13.10.2016";"";"10.000,00"
>
> Anybody got any ideas/tips/hints re what to do to get this to import? Are there characters that aren't allowed? Anything else I should be aware of?
>
> Thanks in advance,
Worked fine for me just now. Note that you can have only one date column, so the other one will be ignored. Make sure that you set the date order and currency format to match what's in the file and to set the "starting at" row to 2 at the top of the dialog box so that the importer doesn't try to parse the headings.
Regards,
John Ralls
More information about the gnucash-user
mailing list