[Kmymoney-devel] [kmymoney4] [Bug 352789] Investment CSV import case sensitivity

[allan]

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

--- Comment #9 from allan <agander93 at gmail.com> ---
(In reply to Marcel from comment #6)
> Ok, I have created some test files and also screenshots during the import
> process.

Good, thanks for that.  I see that your asset account is in USD, but there
appears to be no investment account into which to import the CSV file.   I
assume you do have one, and am I right in assuming that that also is in USD?  I
want to be sure to match your setup, as I haven't as yet been able to get a
good import?  I take it that your locale is German, and therefore uses the
comma decimal symbol?

Before completing the import, on the  Edit Securities and Symbols window the
symbol AAPL appears, without a security name, but that doesn't show in your
.kmy file.

> My column mapping is Date=4, Price=6, Type/Action=9, Amount=5,
> Commissions/Fees=7, Note=12*, Amount=8, Symbol=2, Details=3 and I import
> line 2-2.
> 
> Basically, the right thing happens when I ignore the warning/red background
> for the Quantity column (Step 4a/4b in the attachment.)
> When I switch the decimal separator to Comma, everything becomes green and
> the right amounts are still displayed  (Step 4c/4d in the attachment), but
> after the import, amounts are multiplied by 100 (though there is a warning
> message about a missing decimal separator in column 8). 
> 
> When I switch to Comma and back to Point as decimal separator, several
> columns become red (step 4e in the attachment), but as a user I would expect
> to get the same result as before switching to Comma. The import succeeds
> again in that case. 
> 
> To summarize, the main problem is that columns become red/green when they
> shouldn't, which confused me.
> 
> 
> 
> This test file also exhibits #352792, as the commision of 1 gets ignored (or
> maybe I didn't quite get the import process. I always get asked to enter the
> name (instead of choosing one) of the checking account used for transfers,
> even when I create the kind of investment account that also adds a
> settlement account.

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