Export Variables

Exports the variables to a text file. The text file is saved on the server.

Permissions

Command Kind	Needed User Kind
Read	Admin, Sys

Parameters

Name	Type	Description	Required	Default	Values
File	string	Name/path of the export file. The file is exported on the server.	yes
Brackets	boolean	If 'True' the dimension items are exported with brackets ([Item]). The default value is 'True'.	no	true
Caption1	boolean	If 'True' caption 1 is exported. The default value is 'True'.	no	true
Caption2	boolean	If 'True' caption 2 is exported. The default value is 'True'.	no	true
Caption3	boolean	If 'True' caption 3 is exported. The default value is 'True'.	no	true
Caption4	boolean	If 'True' caption 4 is exported. The default value is 'True'.	no	true
Caption5	boolean	If 'True' caption 5 is exported. The default value is 'True'.	no	true
Caption6	boolean	If 'True' caption 6 is exported. The default value is 'True'.	no	true
Caption7	boolean	If 'True' caption 7 is exported. The default value is 'True'.	no	true
Caption8	boolean	If 'True' caption 8 is exported. The default value is 'True'.	no	true
Caption9	boolean	If 'True' caption 9 is exported. The default value is 'True'.	no	true
Caption10	boolean	If 'True' caption 10 is exported. The default value is 'True'.	no	true
Coding	string	Coding of the file: Automatic (checks the file), Ansi, Ascii, BigEndianUnicode, Unicode (Utf16/Utf-16), Utf7 (Utf-7) or Utf8 (Utf-8). The default value is Automatic	no	Automatic	Automatic, Ansi, Ascii, BigEndianUnicode, Unicode, Utf7, Utf8
FieldSeparator	string	Field separator (long and short): Circumflex (^), Comma (,), Semicolon (😉, Tabulator (Tab) or Pipe (|).	no	Tabulator	Circumflex, Comma, Semicolon, Tabulator, Pipe
Header	boolean	If 'True' the header is exported. The default value is 'True'.	no	true
MaxRecords	integer	Maximum number of records to be exported. The default value is 500000.	no	500000
Quoted	boolean	If 'True' the text fields are quoted ("Text"). The default value is 'False'.	no	false
Value	boolean	If 'True' the variable value is exported. The default value is 'True'.	no	true

Result

No fields

Code

EXPORT VARIABLES
FILE=[string, Needed]
BRACKETS=[boolean, default=true]
CAPTION1=[boolean, default=true]
CAPTION2=[boolean, default=true]
CAPTION3=[boolean, default=true]
CAPTION4=[boolean, default=true]
CAPTION5=[boolean, default=true]
CAPTION6=[boolean, default=true]
CAPTION7=[boolean, default=true]
CAPTION8=[boolean, default=true]
CAPTION9=[boolean, default=true]
CAPTION10=[boolean, default=true]
CODING=[string, default=Automatic, values=[Automatic,Ansi,Ascii,BigEndianUnicode,Unicode,Utf7,Utf8]]
FIELDSEPARATOR=[string, default=Tabulator, values=[Circumflex,Comma,Semicolon,Tabulator,Pipe]]
HEADER=[boolean, default=true]
MAXRECORDS=[integer, default=500000]
QUOTED=[boolean, default=false]
VALUE=[boolean, default=true]