[Kmymoney] CSV import decimal problem

[Allan]

On 12/12/13 14:08, Joao Roscoe wrote:
> Dear Srs,
>
> I'm starting to use kmymoney to bring a bit of order to my finances. I
> need to use CSV import to get my bank an credit card statements into
> the database, and I'm having troble with something that appears to be
> a known bug: missing decimals in imported data:
>
> http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=646206
> http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=668458
>
> I'm running vanilla i386 debian wheezy, which has kmymoney 4.6.2, so a took a
> look in newer kmymoney release notes, and saw that a decimal symbol
> related bug was solved, according to this:
> http://kmymoney2.sourceforge.net/release-4.6.3.html
> ...and this:
> https://bugs.kde.org/show_bug.cgi?id=312181
>
> Thus, I made a backport of kmymoney 4.6.4, from debian testing version,
> and installed it in my system. The backport itself worked, but the import issue
> remains: no decimal symbol at all (tested CSVs with both "comma" and
> "colon" as decimal symbol, and using both "TAB" and "semicolon" as
> field separator. The CSVs were generated using LibreOffice, and
> modified with awk, to get proper formatting.
>
> Any ideas? Am I overlooking anything obvious and essential?
> Thank you very much
> João
> _______________________________________________

I've done some more checking and the original problem was fixed in 
4.6.3, and that fix has been in the subsequent releases.

So, and assuming your decimal symbol is the comma, when you load your 
csv file into the plugin, I assume that all the fields have been 
correctly displayed, ie, the field separator is correct.  Then, once 
you've selected the columns you need, and also the rows, when you look 
at the data in the amount/debit/credit/quantity/amount columns, does the 
comma separator appear there correctly?  Are you then selecting the 
decimal separator which matches your file?  That needs to be done before 
import.  If so, the amounts in those columns should be highlighted in 
green.  If your file still imports incorrectly, then I'm afraid I will 
need to see your file to find the issue.

Allan