What I found is this. If the company name field was greater than about 65 characters , it corrupted the database.
Used the Ascii Import wizard for this, but I suspect the lack of integrity checking for field length is the problem. --- In [email protected], "Lester Vanhoff" <[EMAIL PROTECTED]> wrote: > > Did you include "$NOQUOTES 1" in your format definition file? I assume that you are importing only [ticker + company name] and that all tickers with quotes are already in your database: > > # Format definition for a file with ticker > # and company name only. > # $NOQUOTES 1 is necessary even if there > # are no fields with numbers. > # $AUTOADD 0: prevents creating new data > # files with no quotes > > $FORMAT Ticker,FullName > $SEPARATOR , > $SKIPLINES 1 > $NOQUOTES 1 > $AUTOADD 0 > $OVERWRITE 0 > $DEBUG 1 > > This will import ASCii file that looks like this (as long as the ticker with quotes is already in your database): > > Ticker, FullName > ECA=o XR , ECA Dec 46 Put > ECA=o XQ , ECA Dec 48 Put > ECA=o XJ , ECA Dec 50 Put > ECA=o XT , ECA Dec 52 Put > ECA=o XX , ECA Dec 54 Put > > Lester > > -- In [email protected], "Homar Simpson" <x77777x@> wrote: > > > > I tried updating the Nasdaq symbols with a ticker list containing > > just symbols and descriptions. > > > > They imported but they also corrupt the ALL category, so that only 1 > > symbol shows there. > > > > Tried it with a fresh database and also see strangeness there. > > Version 4.80. > > > > What would cause the ALL category to stop working? > > >
