Thank you Randy and Tony, I pretty much know the order of the columns so I can create an empty table with all the computed columns and indices in place using pretty straight forward code and just import the data into the empty table using a stored *.RGW file with all the parameters.
Javier, Javier Valencia, PE 913-915-3137 -----Original Message----- From: [email protected] <[email protected]> On Behalf Of Randyp Sent: Tuesday, June 29, 2021 8:28 PM To: [email protected] Subject: Re: [RBASE-L] - Importing Data I import a CVS file then rename columns which makes data compatible with existing tables. This could be done with an update table command. Your additional procedures could follow in order. You might append to an empty existing table to have the benefit of pre-defined indexes and computed columns. The newly populated table could be the source for a view or views automating the averaging of values. Randy Peterson Sent from my iPhone > On Jun 29, 2021, at 7:03 PM, [email protected] wrote: > > 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. -- 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/EFDF36BD-5282-4BCD-BA43-0C131974FCE1%40ctags.com. -- 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%2BA71stIig71BAFnx9iihQAAEAAAACfJZ3DlxiVOqMLKcqHWHe0BAAAAAA%3D%3D%40vtgonline.com.
