Razzak:
Thanks so much for the (quick) change following a brief discussion
with support regarding the specification files. The change should be
a big help for those who need to manage multiple .rgw files through the wizard.
Steve Johnson
At 01:38 PM 9/4/2013, you wrote:
Wednesday, September 4, 2013
Tip of the Day: Using File Gateway Specification Files
Product.: R:BASE eXtreme 9.5 (32/64)
Build...: 9.5.3.20829 or higher www.rupdates.com
Keywords: GATEWAY, Import, Export, Specification File
Section.: File Gateway
When using the File Gateway utility to import data into an existing table or
when using the Export Wizard, specification files (.rgw) can be used to save
your import/export options and settings to load from a previous data transfer.
As part of the latest update, it is now easier to manage multiple
specification
files in the same working folder with an enhanced "Save As" button.
During the import/export process, the "Specifications..." button is available.
The specification file will store your import options for type, source file,
fields, settings and mode.
http://www.razzak.com/Tips/Specification.jpg
The specification files can be loaded for the current data transfer and saved
for future transfers. The specification files are stored in the current folder
with the .RGW file extension.
http://www.razzak.com/Tips/ImportSpecification.jpg
Specification files can be utilized using both the File Gateway user interface
and the GATEWAY.
GATEWAY Import Example:
GATEWAY IMPORT XLS Customer_New.xls APPEND Customer +
OPTION SHEET_INDEX 1 +
|SPECIFICATION_FILE_NAME Customer_Import.rgw +
|FIRST_ROW 2 +
|SHOW_PROGRESS ON +
|MESSAGES OFF
GATEWAY Export Example:
GATEWAY EXPORT CSV Customer_Release.csv +
SELECT Company,CustAddress,CustCity,CustState,CustZip FROM Customer +
OPTION COL_NAMES OFF +
|SHOW_PROGRESS ON +
|MESSAGES OFF +
|SPECIFICATION_FILE_NAME Customer_Release.rgw
Stay productive, my friends!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
www.RazzakMemon.com
--
30+ years of continuous innovation!
15 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
