[Kmymoney-devel] [kmymoney4] [Bug 334995] CSV import Debit/Credit mode only looks at one column, credits become 0.00

[Barry Scott]

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

--- Comment #3 from Barry Scott <barry at barrys-emacs.org> ---
Summary:

You have an assumption that that in Credit/Debit mode only one of the two cells
will have a value, the other will be blank.

Change that assumption to be only on of the cells can have a non-zero value,
treat 0 the same as blank.

If both Credit and Debit are non blank/0.00 report a format error.
Refactor if anyone can come up with this ambiguous format.

--- decimal defaults ---

Choosing Import/CSV gives me a dialog that has the Decimal and Thousands
drop down both blank. I cannot see a setting in the profile I found:

$ cat ./Library/Preferences/KDE/share/config/csvimporterrc
[Columns]
AmountCol=3
CreditCol=-1
DateCol=0
DebitCol=-1
NumberCol=-1
PayeeCol=1

[MainWindow]
Height=595

[Profile]
CsvDirectory=~/KMyMoney/new-transactions/
CurrentUI=Banking
DateFormat=2
Encoding=0
FieldDelimiter=0
StartLine=1
TextDelimiter=0

-- automatic defaulting --

I can see how this would work.

1234.56 - "." is decimal no thousands
1234,56 - "," is decimal no thousands
1,234.56 - "." is decimal "," is thousands
1.234,56 - "," is decimal "." is thousands
123456 - assume pennies/cents? Ask user?

Barry

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