[Kmymoney] Problems importing CSV files

[Allan]

On 18/06/12 19:46, Magnus Larsson wrote:
> Hi!
>
> I am running kmymoney on Kubuntu 12.04, and I am trying to migrate from
> GnuCash to KmyMoney. Now I've run into a problem:
>
> I need to import lists of transactions, that I download as xls-files
> from my bank, then edit them in gnumeric/libreoffice calc, and save as
> csv. Only 3 coumns: date, description, and amount (+ and - in one
> column, NOT separate debet and credit). Like this:
>
> 2012/06/04 	VA-SYD 	-512
> 2012/06/04 	FRIHAMNSVIADUK 	-2478,25
>
>
>
> When importing into KmyMoney, the decimals are not identified. So 130,50
> is recognized as 13050. I've tried using a decimal comma (saved the file
> with commas AND set it to comma in the configuration tab of the imprt
> window) and dots, same error produced.
>
> ANy ideas on what I might do wrong? Any more information that I should
> supply?
>
> Best,
>
>
> Magnus Larsson

Hi Magnus

Would you say what revision you have of KMM, please?

I'm not sure if the two lines of data above are actually what you are 
trying to import, or whether you've formatted them for readability in 
the email, as they seem to contain both tabs and spaces between fields.

That said, there definitely appears to be a problem importing them.  I'm 
investigating, using semi-colon (;) as separator and comma (,) as 
decimal.  There is a problem importing '-512' as it contains no decimal, 
but the importer is supposed to handle that, but doesn't.  Adding ',00' 
to it allows it to import correctly here, using 4.6.1.

There is another problem, too, in that the second line shows in the UI, 
but not in the line count.

However, you may have more success for the time being using a comma 
separator and point '.' as decimal.  Using those settings, both of the 
above lines import here.

Let me know how you get on.  It might help if you can supply a typical 
file formatted as you would wish it to appear, for me to test with, in 
case of other gremlins.

Allan