Re: Importing problem

[ Message Board ] [ Archives ] [ Search ]

Posted by Mark on February 08, 2007 at 10:41:24:

In Reply to: Importing problem posted by Stan on February 08, 2007 at 07:02:48:

: Hi all,

: Somehow I can't get the generic import to function properly.

: Example of CSV-file to be imported:
: 04/26/06,0.215,0.22,0.19,0.205,1328100
: 04/27/06,0.22,0.22,0.185,0.19,736900
: 04/28/06,0.21,0.22,0.185,0.20,987300
: 05/01/06,0.21,0.21,0.18,0.185,294900
: 05/02/06,0.18,0.19,0.15,0.17,442900

: I am using the following import-definition:
: "MM/DD/YY",OO,HH,LL,NAV,VV

: (Of course, I specify the ticker symbol in the dialog box. Ticker has already been created, by the way).

: Yet, I get an error msg. stating that "the specified import definition did not match any line in the imported file."

: I can't see what I'm doing wrong.
: Do you? If so, please tell me! :-)

Hi Stan,

Your format string has double quotes around the date, but your data doesn't. Try using this instead:

MM/DD/YY,OO,HH,LL,NAV,VV

Thanks,
Mark
--
Fund Manager - Portfolio Management Software

Replies: