[Kmymoney-devel] [Bug 302181] New: Problems importing CSV files

[allan]

https://bugs.kde.org/show_bug.cgi?id=302181

            Bug ID: 302181
          Severity: normal
           Version: 4.6.1
          Priority: NOR
          Assignee: kmymoney-devel at kde.org
           Summary: Problems importing CSV files
    Classification: Unclassified
                OS: Linux
          Reporter: agander93 at gmail.com
          Hardware: Ubuntu Packages
            Status: NEW
         Component: general
           Product: kmymoney4

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?


Reproducible: Always

Steps to Reproduce:
1.Read the above lines into the csv importer plugin
2.Select tab as separator and comma as decimal.
3.Import

Actual Results:  
The decimal sign is not recognised.  -512 is imported as -51200,00 and -2478,25
as -247825,00.

Expected Results:  
Should import as -512,00 and -2478,25.

-- 
You are receiving this mail because:
You are the assignee for the bug.