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.
[Common]
App=R:BASE X.5 Enterprise (Version 10.5)
Description=Gateway Export: specification
Specification=Export specification
TableType=Excel
AddTitle=1
BlankIfZero=1
SelectedRecord=0
TableName=Customer
CharacterSet=0
[ExportStyle]
Style=0
OddColor=0
EvenColor=0
Layout=0
[Mappings]
Count=7
Map0=CustID = Cust ID
ColumnTitleBackground0=255
ColumnTitleFontName0=MS Sans Serif
ColumnTitleFontHeight0=-11
ColumnTitleFontColor0=16777215
ColumnTitleFontBold0=1
ColumnTitleFontItalic0=0
ColumnTitleFontUnderline0=0
ColumnTitleFontStrikeout0=0
ColumnDataBackground0=16777215
ColumnDataWidth0=8
ColumnDataFontName0=MS Sans Serif
ColumnDataFontHeight0=-11
ColumnDataFontColor0=255
ColumnDataFontBold0=0
ColumnDataFontItalic0=0
ColumnDataFontUnderline0=0
ColumnDataFontStrikeout0=0
Map1=Company = Company Name
ColumnTitleBackground1=32768
ColumnTitleFontName1=MS Sans Serif
ColumnTitleFontHeight1=-11
ColumnTitleFontColor1=16777215
ColumnTitleFontBold1=1
ColumnTitleFontItalic1=0
ColumnTitleFontUnderline1=0
ColumnTitleFontStrikeout1=0
ColumnDataBackground1=16777215
ColumnDataWidth1=26
ColumnDataFontName1=MS Sans Serif
ColumnDataFontHeight1=-11
ColumnDataFontColor1=32768
ColumnDataFontBold1=0
ColumnDataFontItalic1=0
ColumnDataFontUnderline1=0
ColumnDataFontStrikeout1=0
Map2=CustAddress = Address
ColumnTitleBackground2=8388608
ColumnTitleFontName2=MS Sans Serif
ColumnTitleFontHeight2=-11
ColumnTitleFontColor2=16777215
ColumnTitleFontBold2=1
ColumnTitleFontItalic2=0
ColumnTitleFontUnderline2=0
ColumnTitleFontStrikeout2=0
ColumnDataBackground2=16777215
ColumnDataWidth2=24
ColumnDataFontName2=MS Sans Serif
ColumnDataFontHeight2=-11
ColumnDataFontColor2=8388608
ColumnDataFontBold2=0
ColumnDataFontItalic2=0
ColumnDataFontUnderline2=0
ColumnDataFontStrikeout2=0
Map3=CustCity = City
ColumnTitleBackground3=8421376
ColumnTitleFontName3=MS Sans Serif
ColumnTitleFontHeight3=-11
ColumnTitleFontColor3=16777215
ColumnTitleFontBold3=1
ColumnTitleFontItalic3=0
ColumnTitleFontUnderline3=0
ColumnTitleFontStrikeout3=0
ColumnDataBackground3=16777215
ColumnDataWidth3=12
ColumnDataFontName3=MS Sans Serif
ColumnDataFontHeight3=-11
ColumnDataFontColor3=8421376
ColumnDataFontBold3=0
ColumnDataFontItalic3=0
ColumnDataFontUnderline3=0
ColumnDataFontStrikeout3=0
Map4=CustState = State
ColumnTitleBackground4=65535
ColumnTitleFontName4=MS Sans Serif
ColumnTitleFontHeight4=-11
ColumnTitleFontColor4=0
ColumnTitleFontBold4=1
ColumnTitleFontItalic4=0
ColumnTitleFontUnderline4=0
ColumnTitleFontStrikeout4=0
ColumnDataBackground4=16777215
ColumnDataWidth4=6
ColumnDataFontName4=MS Sans Serif
ColumnDataFontHeight4=-11
ColumnDataFontColor4=0
ColumnDataFontBold4=0
ColumnDataFontItalic4=0
ColumnDataFontUnderline4=0
ColumnDataFontStrikeout4=0
Map5=CustZip = Zip Code
ColumnTitleBackground5=128
ColumnTitleFontName5=MS Sans Serif
ColumnTitleFontHeight5=-11
ColumnTitleFontColor5=16777215
ColumnTitleFontBold5=1
ColumnTitleFontItalic5=0
ColumnTitleFontUnderline5=0
ColumnTitleFontStrikeout5=0
ColumnDataBackground5=16777215
ColumnDataWidth5=10
ColumnDataFontName5=MS Sans Serif
ColumnDataFontHeight5=-11
ColumnDataFontColor5=128
ColumnDataFontBold5=0
ColumnDataFontItalic5=0
ColumnDataFontUnderline5=0
ColumnDataFontStrikeout5=0
Map6=CustPhone = Phone Number
ColumnTitleBackground6=8388736
ColumnTitleFontName6=MS Sans Serif
ColumnTitleFontHeight6=-11
ColumnTitleFontColor6=16777215
ColumnTitleFontBold6=1
ColumnTitleFontItalic6=0
ColumnTitleFontUnderline6=0
ColumnTitleFontStrikeout6=0
ColumnDataBackground6=16777215
ColumnDataWidth6=12
ColumnDataFontName6=MS Sans Serif
ColumnDataFontHeight6=-11
ColumnDataFontColor6=8388736
ColumnDataFontBold6=0
ColumnDataFontItalic6=0
ColumnDataFontUnderline6=0
ColumnDataFontStrikeout6=0
ColumnTitleAlign0=2
ColumnDataAlign0=2
ColumnTitleAlign1=0
ColumnDataAlign1=0
ColumnTitleAlign2=0
ColumnDataAlign2=0
ColumnTitleAlign3=0
ColumnDataAlign3=0
ColumnTitleAlign4=2
ColumnDataAlign4=2
ColumnTitleAlign5=2
ColumnDataAlign5=2
ColumnTitleAlign6=0
ColumnDataAlign6=0
[Header]
Count=0
[Footer]
Count=0
[Text]
FieldDelimiter=20
TextQualifier=00
RecordSeparator=0D0A
Fixed=0
RowFirst=2
RowLast=2147483647
[DataFormat]
DateOrder=0
DateSeparator=2F
TimeSeparator=3A
DecimalSeparator=2E
FourDigitYear=0
LeadingZerosInDate=1
BooleanTrue=True
BooleanFalse=False
