Re: The specified input format is illegal

[ Q2 03 - Q4 05 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: The specified input format is illegal posted by Keith on September 27, 2005 at 22:41:07:

: Hi --
: I keep getting the message "The specified input format is illegal" when I use:
: File>Import>Transactions>Generic and
: File to Import: C:\......\myfile.csv
: Import Format: ED,ANUM
: Portfolio: MyPortfolio
: Import All ....: Cash (This is my default cash account in MyPortfolio)
: and myfile.csv looks like:
: 20050901,0.01
: 20050901,84.38
: 20050831,23.79
: 20050831,305.00

: TIA for any and all help.
: -- Keith

Hi Keith,

You're missing some of the required keys, like BNUM and CNUM. For more details, see:

http://www.fundmanagersoftware.com/help/tran_import_generic.html

What is that data you're trying to import? Is it really transactions, or maybe prices? Assuming that is transactions, and those are purchase values listed where you have ANUM specified, you could do something like this:

ED,ANUM,BNUM,CNUM

and in your .csv file your lines would look like:

20050831,1.00,305.00,0

and since you don't have SYMB in the import format string, you must "specify" the investment that you're importing into. The above example will record a purchase of 305 shares at $1/share, with $0 commission fee. Since you aren't using TRAN all lines will assume they are purchases.

Thanks,
Mark
--
Mark Beiley
Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP/2003

Replies: