Use the GATEWAY command to start the import/export of data. Using the GATEWAY command at the R> Prompt or within command files you can automate the entire task of providing desired data formats to your end-users and/or clients. There are NO limits on importing or exporting numerous records into and out of R:BASE for Windows databases with the GATEWAY command.
IMPORTANT NOTE ABOUT GATEWAY: You MUST be aware of both your source file structure and table structure for the command to function properly. The table and file structure MUST coincide with each other.
Specifies to export an R:BASE table or view to an external file.
Specifies to launch the File Gateway, displaying only the "Export" options, with or with default values specified.
Specifies to import an external file to an R:BASE table.
Specifies to launch the File Gateway, displaying only the "Import" options, with or with default values specified.
OPTION <default_parameter> <value>
Specifies to launch the File Gateway with the preferred parameters and valued predefined.
About the GATEWAY Command
Use the Import/Export utility to import a file from another program into a new or existing table in an R:BASE database or export data from an R:BASE database into a file that can be imported into another program or R:BASE database.
Users can access File Gateway user interface module either by clicking on "File Gateway" icon on the R:BASE Main Toolbar or typing GATEWAY at the R> Prompt or in a command file. The File Gateway interface may be launched with default options specified, using parameters for exporting and importing data.
The following types of files are supported to import or export data:
•Import Formats include:
dBase (*.dbf)
Paradox (*.db)
Text (*.txt)
Comma Delimited (*.csv)
Text Data (*.dat)
Text Printout (*.prn)
Tab Delimited (*.tab)
Tilde Delimited (*.til)
ASCII (*.asc)
HTML (*.htm, *.html)
MS Excel Spreadsheet (*.xls)
MS Excel Workbook (*.xls)
Lotus 1-2-3 (*.wk1)
Lotus 1-2-3 (*.wk2)
Lotus Symphony (*.wr1)
QuattroPro (*.wq1)
XML (*.xml)
MS Access Database (*.mdb)
JSON JavaScript Object Notation (*.json)
OpenOffice Spreadsheet (*.ods)
•Export Formats include:
Paradox (*.db)
dBase (*.dbf)
Comma Separated Values (*.csv)
HTML (*.HTM, *.HTML)
MS Excel Spreadsheet (*.xls)
MS Excel Workbook (*.xls)
MS Word (*.doc)
Tab Delimited (*.tab)
SYLK Symbolic Link (*.slk)
DIF Data Interchange Format (*.dif)
Lotus 1-2-3 (*.wk1)
QuattroPro (*.wq1)
SQL Script (*.sql)
oMSSQL
oMySQL
oInerBase/FireBird
oOracle
oPostgreSQL
oDB2
oInformix
oMS Access
oSQLite
XML (*.xml)
MS Windows Clipboard
Rich Text Format (*.rtf)
SPSS Format (*.sav)
Adobe Acrobat Document (*.pdf)
LDAP Data Interchange Format (*.ldif)
JSON JavaScript Object Notation (*.json)
OpenOffice Text Document (*.odt)
