Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Command Index > G > GATEWAY

Export Dialog

Scroll Prev Top Next More

The File Gateway utility can be launched with the available export options preselected, allowing for easier file transfers for end users. The OPTION keyword must immediately follow the EXPORT keyword in order for the default options to be assigned.

 

GATEWAY_Export_Dialog

 

 

Default Parameter

Value

DEFAULT_TABLE

value

ONLY_TABLE

value

DEFAULT_FORMAT

WIZARD, DB, DBF, CSV, HTM, HTML, XLS, XLSX, XLSW, DOC, SLK, DIF, WK1, WQ1, SQL, XML, CLIP, CLIPBOARD, RTF, SAV, PDF, LDIF, JSON, ODT

DEFAULT_SQL_FORMAT

GENERIC, DB2, INTERBASE, IB, FIREBIRD, FB, MSACCESS, ACCESS, MSSQL, SQL, SQLSERVER, MYSQL, ORACLE, POSTGRESQL, POSTGRES, PG, SQLITE

DEFAULT_INCLUDE_STRUCTURE

ON/OFF

DEFAULT_FILENAME

value

DEFAULT_WHERE

value

DEFAULT_SHOW_PROGRESS

ON/OFF

DEFAULT_ZERO_AS_BLANK

ON/OFF

DEFAULT_NULL_VALUE_AS_BLANK

ON/OFF

DEFAULT_APPEND

ON/OFF

DEFAULT_PASSWORD

value

DEFAULT_PASSWORD_TO_OPEN

value

DEFAULT_LAUNCH_AFTER_EXPORT

ON/OFF

DEFAULT_NO_UNICODE_TO_ANSI

ON/OFF

DEFAULT_ADD_UTF8_BOM

ON/OFF

 

Example 01:

-- launches the Gateway Utility with only the Export tab displayed

GATEWAY EXPORT

 

Example 02:

-- launches the Gateway Utility Export tab with Customer preselected as the default table, and prevents the selection of other tables

GATEWAY EXPORT OPTION DEFAULT_TABLE Customer +

|ONLY_TABLE Customer

 

Example 03:

-- launches the Gateway Utility Export tab with History preselected as the default table, DBF as the file format, a check in the append check box, and with the file name specified

GATEWAY EXPORT OPTION DEFAULT_TABLE History +

|DEFAULT_FORMAT DBF +

|DEFAULT_APPEND ON +

|DEFAULT_FILENAME History.dbf

 

Example 04:

-- launches the Gateway Utility Export tab with Transactions as the preselected table, SQL as the file format, and SQL Server as the SQL format

GATEWAY EXPORT OPTION DEFAULT_TABLE Transactions +

|DEFAULT_FORMAT SQL +

|DEFAULT_SQL_FORMAT MSSQL

 

Example 05:

-- launches the Gateway Utility Export tab with Transactions as the preselected table, SQL as the file format, SQL Server as the SQL format including the table structure, and with the file name specified

GATEWAY EXPORT OPTION DEFAULT_TABLE Transactions +

|DEFAULT_FORMAT SQL +

|DEFAULT_SQL_FORMAT MSSQL +

|DEFAULT_INCLUDE_STRUCTURE ON +

|DEFAULT_FILENAME Transactions.sql

 

Example 06:

-- launches the Gateway Utility Export tab with Customer as the preselected table, XLS as the file format, a WHERE Clause specified, the progress display enabled, and the option enabled to launch file after the export completes

GATEWAY EXPORT OPTION DEFAULT_TABLE Customer +

|DEFAULT_FORMAT XLS +

|DEFAULT_WHERE WHERE CustState IN (CA,PA) ORDER BY Company +

|DEFAULT_FILENAME Customer.xls +

|DEFAULT_SHOW_PROGRESS ON +

|DEFAULT_LAUNCH_AFTER_EXPORT ON

 

Example 07:

-- launches the Gateway Utility Export tab with TransMaster as the preselected table, XLSX as the file format, the file name specified, NULLs set to display as blank, exports Unicode data as a UTF-8 string, and specifies to add a UTF-8 BOM to exported UTF-8 strings

GATEWAY EXPORT OPTION DEFAULT_TABLE TransMaster +

|DEFAULT_FORMAT XLSX +

|DEFAULT_FILENAME TransMaster.xlsx +

|DEFAULT_NULL_VALUE_AS_BLANK ON +

|DEFAULT_NO_UNICODE_TO_ANSI ON +

|DEFAULT_ADD_UTF8_BOM ON

 

 

GATEWAY_Export_Dialog_XLSX