Works OK for me. - created new blank database to save me time (no categories assigned) - saved a list in your format (as blakerandy.txt file)
line1 test,0,abc learning,abc,0 test,1,bcd group,bcd,1 test,2,cde company, cde,2 - saved your format in format folder (as blakerandy.format) $FORMAT Skip,Industry,Fullname,Ticker,Market $SEPARATOR , $SKIPLINES 1 $AUTOADD 1 $DEBUG 1 $Noquotes 1 - added to import.types in format folder Default ASCII (*.*)|*.*|default.format Yahoo's CSV (*.csv)|*.csv|yahoo.format AmiQuote Historical (*.aqh)|*.aqh|aqh.format AmiQuote Historical (Funds) (*.aqh)|*.aqh|aqhfunds.format AmiQuote Daily (*.aqd)|*.aqd|aqd.format AmiQuote Historical (Google) (*.aqg)|*.aqg|aqg.format AmiQuote Intraday (*.aqi)|*.aqi|aqi.format AmiQuote Historical (MSN) (*.aqm)|*.aqm|aqm.format AmiQuote Historical (eSignal) (*.aqe)|*.aqe|aqe.format Metastock ASCII (*.txt)|*.txt|metastock.format Omega SC ASCII (*.txt)|*.txt|omega.format S-Files (s*.*)|s*.*|sfile.format C-Files (c*.*)|c*.*|cfile.format Sharenet DN (*.dn)|*.dn|sharenet.format PRN Format with Ticker (*.prn)|*.prn|prnn.format PRN Format without Ticker (*.prn)|*.prn|prnn2.format Space separated Ticker,Date,OHLC (*.txt)|*.txt|ssv.format Space separated Date,HLCV (*.txt)|*.txt|ssv2.format Short Daily CSV (*.csv)|*.csv|daily.format MST Format w/Ticker (*.mst)|*.mst|mst.format StockWatch.com format (*.csv)|*.csv|stockwatch.format TenBagger format (*.stk)|*.stk|stk.format SP100 (*.*)|*.*|SP100.format blakereandy format (*.*)|*.txt|blakerandy.format - ASCII import >> (select blakerandy.txt with filetype == blakerandy.format >> open stock abc goes into market 0, bcd goes into market 1 etc brian_z --- In [email protected], "blakerandy" <[EMAIL PROTECTED]> wrote: > > I have created a database structure to follow the Yahoo Sector and > Industry structure. > > When I create a new database the structure is set up properly. > > I also have a text file of stocks that includes the sector, industry, > company name, symbol and market for each stock I want to include in my > database. This file is in a comma delimited format. > > I created a new format file to import the data. When the import is > done, all of the symbols are there but they are all under the first > industry. > > Does anyone have an idea of what I might be doing wrong? > > Sector File: > Basic Materials > Conglomerates > Consumer Goods > Financial > Healthcare > Industrial Goods > Services > Technology > Utilities > > Partial Industry File: > 0 Agricultural Chemicals > 0 Aluminum > 0 Chemicals-Major Diversified > 0 Copper > 0 Gold > 0 Independent Oil & Gas > > > Format File: > $FORMAT Skip,Industry,Fullname,Ticker,Market > $SEPARATOR , > $SKIPLINES 1 > $AUTOADD 1 > $DEBUG 1 > $Noquotes 1 >
