[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