Javier:
As to the question of generating and using an .RGW specification file at
the command line, the process is to create the RGW file using the File
Gateway feature from the interface (update: as Razzak just indicated);
then, within the GATEWAY IMPORT command at the command line, refer to
said .RGW file with the OPTION SPECIFICATION_FILE_NAME
Example:
GATEWAY IMPORT ...
OPTION SPECIFICATION_FILE_NAME humpty.rgw
As for the rest ...
Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
[email protected] | +011 (909) 238-9012 c | +011 (909) 912-8678 f
------ Original Message ------
From: [email protected]
To: [email protected]
Sent: 6/29/2021 2:47:53 PM
Subject: [RBASE-L] - Importing Data
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
913-915-3137
--
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%2BA71stIig71BAFnx9iihQAAEAAAAFI/ToNEPw9PrCt8uNCZG1YBAAAAAA%3D%3D%40vtgonline.com
<https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAG1gU%2BA71stIig71BAFnx9iihQAAEAAAAFI/ToNEPw9PrCt8uNCZG1YBAAAAAA%3D%3D%40vtgonline.com?utm_medium=email&utm_source=footer>.
--
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/em94e3c0d0-195c-4090-a72a-aa03aaf1f4cc%40pathfinder.
