Bob, >From help file. "ยท Import Formats include: Paradox (*.db) dBase (*.dbf) Text (*.txt) Comma Delimited (*.csv) Text Data (*.dat) Text Printout (*.prn) Tab Delimited (*.tab) ASCII (*.asc) HTML (*.htm, *.html) MS Excel Spreadsheet (*.xls) MS Excel Workbook (*.xls) Lotus 1-2-3 (*.wk1) Lotus 1-2-3 (*.wk2) Lotus Symphony (*.wr1) QuattroPro (*.wq1) XML (*.xml) MS Access Database (*.mdb)
I would create a temporary one column table with the column being a TEXT field of the maximum length of a row in your imput file. I would then start the GATEWAY wizard for importing data. Select to import "TXT" and follow the pompts to define the input as one column. CSV is definately not the type you want to use. I am curious why you want to us gateway to import the data instead of using the following syntax: "LOAD tblview FROM filespec AS FORMATTED USING colname start end" where tblview is your existing 5 column table where filespec is your ipod file where colname is your raw data column where start is 1 where end is max size of data row in import file. Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 --- On Tue, 7/8/08, Bob Thompson <[EMAIL PROTECTED]> wrote: > From: Bob Thompson <[EMAIL PROTECTED]> > Subject: [RBASE-L] - Re: Load versus Gateway issue > To: "RBASE-L Mailing List" <[email protected]> > Date: Tuesday, July 8, 2008, 7:35 PM > James, > Thanks for the reply. > > It is not that Gateway does not allow a table, it does not > allow to specify > what column in the table > you want to load. My table has 5 columns, of which I want > to load only one > column. > > The file that I am loading is not really a CSV file, but > that is the closest > option I see in Gateway. > The file is an EDI text file with typical lines such as: > > BSN*001*023456*20080708*20080813**175 > N1*OB*0923 > LIN*001*VP*705*SK*500123*UP*04355980512 > REF*SAN JOSE*CA*99999*ABC > > Each line can and does have a different number of fields. > I load the entire line into a single column text field then > cursor through > the table. > EDI has a specified format such that BSN line contains > certain data, N1 line > contains > different data, etc. etc. However, not all transactions > have the same > number of lines, > or even the same segments. I will leave it to say that > this is the way it > is done. > > So one must load the "line" of data into a single > column and parse out what > is needed. > This is all rather easy. However, if I use the Load > command to load the > file, I do get all > the records loaded. However, the LOAD command sees the > space in "SAN JOSE" > as > a delimiter and drops the rest of the data. I.E. the line > REF*SAN > JOSE*CA*99999*ABC > gets loaded into the table only as REF*SAN Everything > after the space gets > dropped > for some reason. > > If I use GATEWAY, the above line gets loaded perfectly, > however only less > than > half of the file gets loaded. I get no errors and all > seems to work OK, > just the file > does not all load. > > I tried GateWay on a regular view versus temp, a temp table > and a permanent > table. > They all acted the same, only 1649 rows added. Using the > LOAD command on > either permanent or temp tables adds all records, but > anything with a space > malfunctions. > > -Bob > > > ----- Original Message ----- > From: "James Bentley" > <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" > <[email protected]> > Sent: Tuesday, July 08, 2008 7:15 PM > Subject: [RBASE-L] - Re: Load versus Gateway issue > > > > Bob, > > to the best of my knowledge a table name is allowed in > gateway syntax. > > > > GATEWAY IMPORT CSV D:\TEMP\FNAME.TXT CREATE > AAA > > GATEWAY IMPORT CSV D:\TEMP\FNAME.TXT APPEND > AAA > > GATEWAY IMPORT CSV D:\TEMP\FNAME.TXT REPLACE > AAA > > > > If you check the syntax diagram it says > "tblview" which means table name > > or view name. > > > > The only problem I see is your are loading a one > column table using a CSV > > syntax. I find it strange that you would have a > "ONE COLUMN" CSV input > > file. CSV usually implies multiple columns. Also > make sure your values > > in the imput file are enclosed in " characters. > > > > You might want to post about a dozen lines from your > input file to see if > > we can spot what you problem is. > > > > > > Jim Bentley > > American Celiac Society > > [EMAIL PROTECTED] > > tel: 1-504-737-3293 > > > > > > --- On Tue, 7/8/08, [EMAIL PROTECTED] > <[EMAIL PROTECTED]> wrote: > > > >> From: [EMAIL PROTECTED] > <[EMAIL PROTECTED]> > >> Subject: [RBASE-L] - Load versus Gateway issue > >> To: "RBASE-L Mailing List" > <[email protected]> > >> Date: Tuesday, July 8, 2008, 6:16 PM > >> I am having an issue with Gateway and perhaps > someone can > >> see the problem: > >> > >> R>LOAD edisplit FROM podata.001 using edidata > >> R>sel count(edidata) from edisplit > >> count (edi > >> ---------- > >> 3515 (Correct value) > >> R>del rows from edisplit > >> R>gateway import csv podata.001 append > tempsplit > >> R>sel count(edidata) from edisplit > >> count (edi > >> ---------- > >> 1649 (Should be 3515) > >> > >> tempsplit is a temp view of edisplit having the > one column > >> edidata. > >> I do not see where the Gateway import option > allows you to > >> specify > >> a column to load so I had to use the temp view. > EdiSplit > >> has 5 columns > >> but I only want to load one. > >> > >> ????? > >> > >> Thanks, > >> -Bob > >> > >> > >> -- > >> Thompson Technology Consultants > >> LaPorte, IN 46350 > >> 219-363-7441 > > > > > > > > > > > > > > > > -- > > No virus found in this incoming message. > > Checked by AVG. > > Version: 7.5.526 / Virus Database: 270.4.6/1538 - > Release Date: 7/7/2008 > > 7:40 AM > > > >
