[kmymoney] [Bug 388935] New: Unable to import investment account transaction with .csv

wgking99 at yahoo.com wgking99 at yahoo.com
Sun Jan 14 00:36:21 UTC 2018


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

            Bug ID: 388935
           Summary: Unable to import investment account transaction with
                    .csv
           Product: kmymoney
           Version: 4.8.1
          Platform: Mint (Debian based)
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: importer
          Assignee: kmymoney-devel at kde.org
          Reporter: wgking99 at yahoo.com
  Target Milestone: ---

Created attachment 109848
  --> https://bugs.kde.org/attachment.cgi?id=109848&action=edit
1 line test file for investment transaction import

When trying to import investment transactions from brokerage as .csv file,
import fails after mapping fields with popup "The values in the columns you
have selected do not match any expected investment type", and all other types
from the drop down menu are grayed out. It even fails after modifying .csv file
to use sample type in the Merrill Lynch template in the csvimporterrc file.
Since option to reassign type are all grayed out (another issue?), the only
option is to abort the import. 

The proper action in the sample case would be to recognize "dividend" as a
valid brokerage transaction and deposit the amount in the "brokerage" account
of the corresponding investment account. The error occurs before  the
investment account is selected. The csvimporterrc template is the default M-L
one with the columns mapped as follows:
[BankProfiles]
BankNames=Merril Lynch,Schwab
PriorInvProfile=Merril Lynch

[MainWindow]
Height=174
Width=866

[Profiles-Merril Lynch]
AmountCol=7
BrokerageParam=Bill Payment,Check,dividend,interest,qualified div,foreign tax
paid,adr mgmt fee
BuyParam=buy
DateCol=1
DateFormat=2
DecimalSymbol=0
DetailCol=9
DivXParam=Dividend
Encoding=0
FeeCol=6
FieldDelimiter=0
FileType=Invest
Filter=
IntIncParam=Interest,Income
InvDirectory=~/
MemoCol=2
PayeeCol=3
PriceCol=5
PriceFraction=2
ProfileName=Merril Lynch
QuantityCol=4
ReinvdivParam=reinvest,Reinv,Re-inv,ReInv
RemoveParam=Remove
SecurityName=-1
SellParam=Sell,Repurchase
ShrsinParam=Add,Stock Dividend,Divd Reinv,Transfer In,Re-Registration
In,Journal Entry
StartLine=0
SymbolCol=8
TrailerLines=0

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


More information about the KMyMoney-devel mailing list