Thanks R:azzak, Yes, it helps. I was using the option to create a new table from the import file and the "Specifications" button is not available; It is only available when importing data into an existing table. I have used this approach before and I knew there was a way of generating a specification file. I can create the receiving table ahead of time as a workaround. I am trying to create a utility that automates the entire process, from importing the data, adding an index adding calculated columns and then running a procedure to populate another table with the averaged values. I should have enough now to get me going. 😊
Javier, Javier Valencia, PE 913-915-3137 -----Original Message----- From: [email protected] <[email protected]> On Behalf Of A. Razzak Memon Sent: Tuesday, June 29, 2021 5:03 PM To: [email protected] Subject: Re: [RBASE-L] - Importing Data Javier, It is the [Specifications ...] button during the whole process of setting up the Import process. See attached. Hope it helps! Very Best R:egards, Razzak At 05:47 PM 6/29/2021, [email protected] wrote: >I need to import 170,000 rows of data from either a CSV or an Excel >file and I would like to create a specification file  (*.RGW) with all >the parameters so I can run t from command line. I remember having the > option to create the import using the Gateway Utility and then >storing the parameters in a RGW type file but I do not seem to find >where the option is or how to do it. > >When importing using the Excel import it gives me the option of using >row 1 to read the column names; I do not seem to get this option when >using CSV; is this not available? > >Also, when changing the columns names on the import file to match >current columns, it tells me the columns already exist even when the >type and length are identical so I have to change the name to something else. > >Obviously I have not used this feature in a while and my skills are >rusty and the newer version are probably different than the last one >when I use Gateway. Any light you can shed would be appreciated. > >Javier, > >Javier Valencia, PE -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/0LptxZ-1lKsfD37El-00fi3C%40mrelay.perfora.net. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAG1gU%2BA71stIig71BAFnx9iihQAAEAAAAA66%2Bbnmq3pGoOuGF2JPWzkBAAAAAA%3D%3D%40vtgonline.com.
