Looks impressive; however, I am working on importing data and easiest way is to create a receiving table with all the computed columns and indexes already in place and when data is loaded it is ready to go in one step. Best thing about R:Base, there is always more than one way to do just about anything.
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 7:22 PM To: [email protected] Subject: RE: [RBASE-L] - Importing Data Javier, If you know all headers, table name, and column mappings, you could actually create you own, your way! See attached sample that generates cool XLS data (GATEWAY EXPORT) in this case, based on "Customer" table in RRBYW20 sample database. Have fun! Very Best R:egards, Razzak At 08:03 PM 6/29/2021, [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/0MFvO4-1m3I4S2y9e-00Eyvb%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%2BA71stIig71BAFnx9iihQAAEAAAAEzVZqPDGLJHk3k05p3xrDQBAAAAAA%3D%3D%40vtgonline.com.
