Export Dimension

Exports a dimension 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
Dimension	string	Name of the dimension ([Dimension]).	yes
Attribute	boolean	If 'True' attributes are exported. The default value is 'True'.	no	true
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: Ansi, Ascii, BigEndianUnicode, Unicode (Utf16/Utf-16), Utf7 (Utf-7) or Utf8 (Utf-8). The default value is Utf8.	no	Utf8	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
StartRecord	integer	Record number where the export should start. The default value is '0', which means no start record. This is useful when a large number of records should be exported in multiple parts.	no	0

Result

No fields

Code

EXPORT DIMENSION
FILE=[string, Needed]
DIMENSION=[string, Needed]
ATTRIBUTE=[boolean, default=true]
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=Utf8, values=[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]
STARTRECORD=[integer, default=0]