Re: generic import - one or more fields not specified

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

In Reply to: generic import - one or more fields not specified posted by Andrew on November 01, 2005 at 15:36:26:

: Mark,

: "one or more fields not specified" error. I've tried a lot of variations and your wisdom is appreciated.

: input format: UD,TRAN,ANUM,BNUM,CNUM

: First three rows of data in the .csv file -
: UD,TRAN,ANUM,BNUM,CNUM
: 20051017,BUY,$32.43 ,1.156,0
: 20051003,BUY,$33.31 ,1.126,0

: Thanks,

: Andrew

Hi Andrew,

For the data shown above you would use:

ED,TRAN,$ANUM,BNUM,CNUM

Note, that "ED" is the 8 digit date, and "UD" is a 6 digit date. Your data has 8. Also, the data above has a $ before the ANUM field, so you would need that in the format string. I noticed the CSV file you linked to does not have the $ sign in it, so in that case you wouldn't need it, ie:

ED,TRAN,ANUM,BNUM,CNUM

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

Replies:

• Re: generic import - one or more fields not specified Andrew 11:19:47 11/02/05 (0)