Please enable JavaScript to view this site.

Navigation: Invantive Script > Statements

Export Documents

Results from queries containing documents in binary or text format can be exported to output files using the syntax:

local export documents in <COLUMN-NAME> to "<DIRECTORY>"

filename (automatic|column <COLUMN-NAME>) [actions <ACTION1>[,<ACTION2]*]

The document contents are retrieved from a column and save in the specified directory. One output file is created per row. The name of the output files can be automatically generated or retrieved from another column.

The automatic generation process of file names tries to detect the MIME type of each document with its's associated extension. When it can not be determined, it uses 'txt' as extension. The documents are number sequentially.

Post-process actions can be specified. The supported actions are:

onerrorcontinue: operation normally fails when an error occurs during data retrieval or storage. Operation continues in onerrorcontinue mode.

onerrorfail: fail when an error occurs during data retrieval or storage.

extractzip: consider the document to be a ZIP archive and extract it to a subfolder of the output folder named after the ZIP file name.