Re: generic import - one or more fields not specified

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

In Reply to: Re: generic import - one or more fields not specified posted by Mark on November 01, 2005 at 20:38:42:

: : 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
:

Mark,

Thanks a lot, it worked.

Andrew

Replies: