https://bugs.kde.org/show_bug.cgi?id=302181
Bug ID: 302181
Severity: normal
Version: 4.6.1
Priority: NOR
Assignee: kmymoney-devel@kde.org
Summary: Problems importing CSV files
Classification: Unclassified
OS: Linux
Reporter: agande...@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.
_______________________________________________
KMyMoney-devel mailing list
KMyMoney-devel@kde.org
https://mail.kde.org/mailman/listinfo/kmymoney-devel
