Re: Generic Import problem

[ Message Board ] [ Archives ] [ Search ]

Posted by Mark on April 20, 2006 at 14:20:50:

In Reply to: Generic Import problem posted by John H on April 20, 2006 at 14:07:12:

: I am trying to import some historical transactions.

: In a file called Amzn.txt, it has the following data line

: 10.44,1000,0,buy,03/02/2001,amzn

: I have written in the input format as:
: ANUM,BNUM,CNUM,TRAN,mm/dd/yyyy,SYMB

:
: I am getting an error message "Specific Input Format is illegal".

: What am I doing wrong?

Hi John,

You are quite close. The format string uses upper case keys, so it should be:

ANUM,BNUM,CNUM,TRAN,MM/DD/YY,SYMB

Also, the year key is only YY, not yyyy, even to match a 4 digit year.

Thanks,
Mark
--
Fund Manager - Portfolio Management Software

Replies: