Version: 6.x

EXPORT operator

The EXPORT operator: creates an action that exports specified properties to a file, or, in common case, that opens a form in a structured view.

Syntax

EXPORT [exportFormat] FROM [columnId1 =] propertyExpr1, ..., [columnIdN = ] propertyExprN 
  [WHERE whereExpr] [ORDER orderExpr1 [DESC], ..., orderExprL [DESC]]
  [TOP topExpr] [OFFSET offsetExpr] [TO propertyId]
EXPORT formName [OBJECTS objName1 = expr1, ..., objNameK = exprK] [exportFormat] 
  [TOP (topExpr | (topGroupId1 = topPropertyExpr1, ..., topGroupIdT = topPropertyExprT))]
  [OFFSET (offsetExpr | (offsetGroupId1 = offsetPropertyExpr1, ..., offsetGroupIdF = offsetPropertyExprF))]
  [TO (propertyId | (groupId1 = propertyId1, ..., groupIdM = propertyIdM))]

exportFormat can be specified by one of the following options:

JSON [CHARSET charsetStr]
XML [HEADER | NOHEADER] [ATTR] [CHARSET charsetStr]
CSV [separator] [HEADER | NOHEADER] [ESCAPE | NOESCAPE] [CHARSET charsetStr]
XLS [SHEET sheetProperty] [HEADER | NOHEADER]
XLSX [SHEET sheetProperty] [HEADER | NOHEADER]
DBF [CHARSET charsetStr]
TABLE

Description

The EXPORT operator creates an action that exports data from the specified properties or form to a file. The following file formats are supported: XML, JSON, CSV, XLS, XLSX, DBF, TABLE.

If no export file format is specified, it is considered to be JSON.

If the property to which the data is exported is of class FILE, then the extension of the resulting file is determined depending on the format as follows:

Format	Extension
JSON	json
XML	xml
CSV	csv
XLS	xls
XLSX	xlsx
DBF	dbf
TABLE	table

When exporting a form in an OBJECTS block, it is possible to add extra filters to check for the equality of the objects on the form with the values passed. These objects will not participate in building the object group hierarchy.

Parameters

Source of export

formName

The name of the form from which you want to export data. Composite ID.
objName1 ... objNameK

Names of form objects for which filtered (fixed) values are specified. Simple IDs.
expr1 ... exprK

Expressions whose values determine the filtered (fixed) values for form objects.
propertyExpr1, ..., propertyExprN

List of expressions from whose values the data is exported. Each property is mapped to a table column of the result file.
columnId1, ..., columnIdN

A list of column IDs in the resulting file into which data from the corresponding property will be exported. Each list element is either a simple ID or a string literal. If no ID is specified, it is considered equal to expr<Column number> by default.
whereExpr

An expression whose value is a condition for the export. If not specified, it is considered equal to the disjunction of all exported properties (that is, at least one of the properties must be non-NULL).
orderExpr1, ..., orderExprL

List of expressions by which the exported data is sorted. Only properties present in the list propertyExpr1, ..., propertyExprN can be used
DESC

Keyword. Specifies reverse sort order. By default, ascending sort is used.
TOP topExpr
TOP (topExpr | (topGroupId1 = topPropertyExpr1, ..., topGroupIdT = topPropertyExprT))

Export only first n records, where n is value of expression topExpr or topPropertyExprT for group object topGroupIdT.
OFFSET offsetExpr
OFFSET (offsetExpr | (offsetGroupId1 = offsetPropertyExpr1, ..., offsetGroupIdF = offsetPropertyExprF))

Export only records with offset m, where m is value of expression offsetExpr or offsetPropertyExprF for group object offsetGroupIdF.

Export format

ATTR

A keyword that specifies that values should be exported to the attributes of the parent tag. If not specified, the values are exported to child tags. Only applicable for export to XML.
separator

Delimiter in a CSV file. String literal. If not specified, then the default delimiter is ;.
HEADER | NOHEADER

Keywords specifying the presence (HEADER) or absence (NOHEADER) of a header string in a CSV, XLS, or XLSX file. The default is NOHEADER.

When using the NOHEADER option if the column name is one of the predefined names (A, B, ..., Z, AA, ..., AE), it is exported to the column with the corresponding number, and the following columns are exported to the columns next in order after this column.

Has other meaning for XML: with HEADER result file contains first string like <?xml version="1.0" encoding="UTF-8"?>. Export with NOHEADER exports without this string. The default is HEADER.
ESCAPE | NOESCAPE

Keywords specifying the presence (ESCAPE) or absence (NOESCAPE) of escaping for special characters (\r, \n, " (double quotes) and the specified delimiter (separator) in a CSV file. It makes sense to use NOESCAPE only in cases where the specified delimiter is guaranteed not to occur in the data. The default is ESCAPE.
CHARSET charsetStr

An option specifying the encoding used for export.
- charsetStr
  
  String literal that defines the encoding.
sheetProperty

The ID of the property whose value is used as the name of the sheet in the exported file. The property must not have parameters. It is used for XLS and XLSX export formats.

Export destination

propertyId

Property ID to which the generated file will be written. This property must not have parameters and its value must be of a file class (FILE, RAWFILE, JSONFILE, etc.). If this property is not specified, the System.exportFile property is used by default.
groupId1, ..., groupIdM

Names of object groups from the exported form for which you want to export data. Simple IDs. Used only for exporting forms to flat formats.
propertyId1 , ..., propertyIdM

Property IDs to which the generated files for specified object groups will be written. These properties must not have parameters and their value must be of file classes (FILE, RAWFILE, JSONFILE, etc.). Used only for exporting forms to flat formats. For the empty group of objects, the name root is used.

Examples

CLASS Store;

name = DATA STRING[20] (Sku);
weight = DATA NUMERIC[10,2] (Sku);

in = DATA BOOLEAN (Store, Sku);

exportSkus (Store store)  {
    // uploading to DBF all Sku for which in (Store, Sku) is specified for the desired warehouse
    EXPORT DBF CHARSET 'CP866' FROM id(Sku s), name(s), weight(s) WHERE in(store, s); 
    // uploads to CSV without header line and escaping special characters
    EXPORT CSV NOHEADER NOESCAPE FROM id(Sku s), name(s), weight(s) WHERE in(store, s); 
    // uploads JSON, sorting by property name[Sku] in descending order
    EXPORT FROM id(Sku s), name(s), weight(s) WHERE in(store, s) ORDER name(s) DESC; 
    // uploads JSON {"ff":"HI"}, as by default it gets the name value, and the platform
    // gets the object {"value":"HI"} to "HI"
    EXPORT FROM ff='HI'; 
    // uploads JSON "HI", as by default it gets the name value, and the platform
    // automatically converts the object {"value": "HI"} to "HI"
    EXPORT FROM 'HI'; 
}

FORM exportSku
    OBJECTS st = Store

    OBJECTS s = Sku
    PROPERTIES(s) id, name, weight
    FILTERS in(st, s)
;

exportSku (Store store)  {
    // uploading to DBF all Sku for which in (Store, Sku) is specified for the desired warehouse
    EXPORT exportSku OBJECTS st = store DBF CHARSET 'CP866';
    EXPORT exportSku XML;
    EXPORT exportSku OBJECTS st = store CSV ',';
}

Syntax​

Description​

Parameters​

Source of export​

Export format​

Export destination​

Examples​