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

[aga]

Hi,

On 11/10/15 13:23, Marcel wrote:
> https://bugs.kde.org/show_bug.cgi?id=352789
>
> --- Comment #10 from Marcel <kde at picodesign.de> ---
> Hi,
> I've tested again with a setup with an investment and asset account and
> starting kMyMoney with KDE_LANG=en_US, since my remaining problems are probably
> not related to my German setup (the CSV is also as generated by a US broker).
>
> One thing about the import process that always confuses me is that I get "Enter
> the name of the Brokerage or Checking Account used for the transfer of funds"
> after clicking Import CSV. Shouldn't I get a dropdown with my existing accounts
> here?

OK.  The reason for this is that you will be importing into a file which 
you select during the import process.  However, if say, you are dealing 
with a file including monetary values, for instance, a Buy or a Sell, 
you need to specify the checking-type account to use, and not everyone 
uses a brokerage account linked to the investment account.  So, that is 
the purpose of that little window.  In fact, you can enter anything you 
like there, and it will just show up as an unbalanced transaction and 
you can then enter what you require.


That part was actually written in the very early days of the plugin, and 
I did not then wish to access KMM features inside the plugin.

> Afterwards, I'm asked to choose which account my import is for. If I choose the
> investment account here, I get "This imported statement contains investment
> transactions with no security.", which is clearly not the case. If I choose the
> brokerage account, I do get an import, but not in the investment account.

I suspect that that is because the kmy file includes a stock without a 
name.  If I give the stock a name, like say Apple, then you don't get 
that problem.  The investment file does need to be imported into an 
investment account.  KMM requires separation between the shares aspect 
and the money side.  Possibly that will change in time, but don't hold 
your breath.

> The imported file was the same as before (the corresponding settings can be
> seen in the screenshot), the kMyMoney setup is simply creating a new Investment
> account together with a brokerage account in a new .kmy file.
>

Using USD for the relevant accounts does allow successful importing, 
whereas Euro does not.

Allan