Config_Export

Michal Čihař edited this page May 16, 2016 · 2 revisions

format

sql/latex/excel/csv/xml/xls/htmlexcel/htmlword/ods/odt

$cfg['Export']['format'] = 'sql';

compression

none/zip/gzip/bzip2

$cfg['Export']['compression'] = 'none';

asfile

$cfg['Export']['asfile'] = FALSE;

charset

$cfg['Export']['charset'] = '';

( 1 legal values for preselection, takes only effect if $cfg['AllowAnywhereRecoding'] = true; )

onserver

$cfg['Export']['onserver'] = FALSE;

onserver_overwrite

$cfg['Export']['onserver_overwrite'] = FALSE;

remember_file_template

$cfg['Export']['remember_file_template'] = TRUE;

file_template_table

$cfg['Export']['file_template_table'] = '@TABLE@';

For versions prior to 3.4:

$cfg['Export']['file_template_table'] = '__TABLE__';

file_template_database

$cfg['Export']['file_template_database'] = '@DATABASE@';

For versions prior to 3.4:

$cfg['Export']['file_template_database'] = '__DB__';

file_template_server

$cfg['Export']['file_template_server'] = '@SERVER@';

For versions prior to 3.4:

$cfg['Export']['file_template_server'] = '__SERVER__';

ODS

ods_columns

$cfg['Export']['ods_columns'] = FALSE;

ods_null

$cfg['Export']['ods_null'] = 'NULL';

ODT

odt_structure

$cfg['Export']['odt_structure'] = TRUE;

odt_data

$cfg['Export']['odt_data'] = TRUE;

odt_columns

$cfg['Export']['odt_columns'] = TRUE;

odt_relation

$cfg['Export']['odt_relation'] = TRUE;

odt_comments

$cfg['Export']['odt_comments'] = TRUE;

odt_mime

$cfg['Export']['odt_mime'] = TRUE;

odt_null

$cfg['Export']['odt_null'] = 'NULL';

HTML-Excel

htmlexcel_columns

$cfg['Export']['htmlexcel_columns'] = FALSE;

htmlexcel_null

$cfg['Export']['htmlexcel_null'] = 'NULL';

HTML-Word

htmlword_structure

$cfg['Export']['htmlword_structure'] = TRUE;

htmlword_data

$cfg['Export']['htmlword_data'] = TRUE;

htmlword_columns

$cfg['Export']['htmlword_columns'] = FALSE;

htmlword_null

$cfg['Export']['htmlword_null'] = 'NULL';

Texy

texytext_structure

$cfg['Export']['texytext_structure'] = TRUE;

texytext_data

$cfg['Export']['texytext_data'] = TRUE;

texytext_columns

$cfg['Export']['texytext_columns'] = FALSE;

texytext_null

$cfg['Export']['texytext_null'] = 'NULL';

XLS

xls_columns

$cfg['Export']['xls_columns'] = FALSE;

xls_null

$cfg['Export']['xls_null'] = 'NULL';

CSV

csv_columns

$cfg['Export']['csv_columns'] = FALSE;

csv_null

$cfg['Export']['csv_null'] = 'NULL';

csv_separator

$cfg['Export']['csv_separator'] = ',';

csv_enclosed

$cfg['Export']['csv_enclosed'] = '"';

csv_escaped

$cfg['Export']['csv_escaped'] = '\\';

csv_terminated

$cfg['Export']['csv_terminated'] = 'AUTO';

Excel

excel_columns

$cfg['Export']['excel_columns'] = FALSE;

excel_null

$cfg['Export']['excel_null'] = 'NULL';

excel_edition

win/mac

$cfg['Export']['excel_edition'] = 'win';

Latex

latex_structure

$cfg['Export']['latex_structure'] = TRUE;

latex_data

$cfg['Export']['latex_data'] = TRUE;

latex_columns

$cfg['Export']['latex_columns'] = TRUE;

latex_relation

$cfg['Export']['latex_relation'] = TRUE;

latex_comments

$cfg['Export']['latex_comments'] = TRUE;

latex_mime

$cfg['Export']['latex_mime'] = TRUE;

latex_null

$cfg['Export']['latex_null'] = '\textit{NULL}';

latex_caption

$cfg['Export']['latex_caption'] = TRUE;

latex_structure_caption

$cfg['Export']['latex_structure_caption'] = 'strLatexStructure';

latex_structure_continued_caption

$cfg['Export']['latex_structure_continued_caption'] = 'strLatexStructure strLatexContinued';

latex_data_caption

$cfg['Export']['latex_data_caption'] = 'strLatexContent';

latex_data_continued_caption

$cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued';

latex_data_label

$cfg['Export']['latex_data_label'] = 'tab:@TABLE@-data';

For versions prior to 3.4:

$cfg['Export']['latex_data_label'] = 'tab:__TABLE__-data';

latex_structure_label

$cfg['Export']['latex_structure_label'] = 'tab:@TABLE@-structure';

For versions prior to 3.4:

$cfg['Export']['latex_structure_label'] = 'tab:__TABLE__-structure';

SQL

sql_structure

$cfg['Export']['sql_structure'] = TRUE;

sql_data

$cfg['Export']['sql_data'] = TRUE;

sql_compat

NONE | ANSI | DB2 | MAXDB | MYSQL323 | MYSQL40 | MSSQL | ORACLE | POSTGRESQL

$cfg['Export']['sql_compat'] = 'NONE';

sql_disable_fk

$cfg['Export']['sql_disable_fk'] = FALSE;

sql_use_transaction

$cfg['Export']['sql_use_transaction'] = FALSE;

sql_drop_database

$cfg['Export']['sql_drop_database'] = FALSE;

sql_drop_table

$cfg['Export']['sql_drop_table'] = FALSE;

sql_if_not_exists

$cfg['Export']['sql_if_not_exists'] = FALSE;

sql_auto_increment

$cfg['Export']['sql_auto_increment'] = TRUE;

sql_backquotes

$cfg['Export']['sql_backquotes'] = TRUE;

sql_dates

$cfg['Export']['sql_dates'] = FALSE;

sql_relation

$cfg['Export']['sql_relation'] = FALSE;

sql_columns

this is for defining the default state of the "Complete inserts" checkbox

$cfg['Export']['sql_columns'] = TRUE;

sql_delayed

$cfg['Export']['sql_delayed'] = FALSE;

sql_ignore

$cfg['Export']['sql_ignore'] = FALSE;

sql_hex_for_binary

$cfg['Export']['sql_hex_for_binary'] = TRUE;

sql_type

insert/update/replace

$cfg['Export']['sql_type'] = 'insert';

sql_extended

$cfg['Export']['sql_extended'] = TRUE;

sql_max_query_size

$cfg['Export']['sql_max_query_size'] = 50000;

sql_comments

$cfg['Export']['sql_comments'] = FALSE;

sql_mime

$cfg['Export']['sql_mime'] = FALSE;

sql_header_comment

\n is replaced by new line

$cfg['Export']['sql_header_comment'] = '';

PDF

pdf_structure

$cfg['Export']['pdf_structure'] = FALSE;

pdf_data

$cfg['Export']['pdf_data'] = TRUE;

pdf_report_title

$cfg['Export']['pdf_report_title'] = '';

Clone this wiki locally
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.