ExportDocumentVersions

Exports specific document versions to the Vault File Staging Server.

Stored Procedure-Specific Information

The DocumentVersionList input takes the name of a temporary (#TEMP) table that holds the version ids to export, one per row. Each version Id must be in Vault's id_major_minor form (for example, 534_0_1).

Versions are exported asynchronously in batches; larger tables are split into multiple jobs automatically. The operation waits for the export jobs to finish and returns the File Staging path of each exported file. The exported content (source files, renditions, and extracted document text, according to the input flags) is placed on the File Staging Server, where it can be retrieved.

Populating the DocumentVersionList Temporary Table

A temporary table is a connection-scoped table whose name ends in #TEMP. You do not create it explicitly: the first INSERT INTO that uses the #TEMP name brings the table into existence, and each subsequent INSERT adds more rows. Temporary tables last only as long as the current connection is open and are discarded when the connection is closed.

The recommended way to populate the table is an INSERT INTO SELECT query that reads the version ids directly from the DocumentVersions view, whose version_id column is already in the required id_major_minor form. An INSERT INTO SELECT selects a group of records from one table and inserts them into another as a single batch, which performs better than issuing many individual INSERT statements:

INSERT INTO DocumentVersionList#TEMP (version_id) SELECT version_id FROM DocumentVersions

The column list in parentheses maps the selected DocumentVersions.version_id values into the version_id column of DocumentVersionList#TEMP. Add a WHERE clause to the SELECT to control exactly which versions are included. You can also add rows one at a time with INSERT INTO ... VALUES:

INSERT INTO DocumentVersionList#TEMP (version_id) VALUES ('534_0_1')
INSERT INTO DocumentVersionList#TEMP (version_id) VALUES ('535_1_0')

Once the temporary table is populated, pass its name to the procedure through the DocumentVersionList input:

EXEC ExportDocumentVersions DocumentVersionList = 'DocumentVersionList#TEMP', Source = 'true', Renditions = 'false'

DocumentVersionList Temporary Table Schema


Column Name	Type	Required	Description
version_id	String	True	The Id of a document version to export, in id_major_minor form (for example, 534_0_1). Populate it from the version_id column of the DocumentVersions view.

Input


Name	Type	Required	Description
DocumentVersionList	String	True	The list of document versions to export. The value must be a temporary table (#TEMP) containing a 'version_id' column whose values are the version ids to export, each in the id_major_minor form (for example, 534_0_1). Versions are exported in batches of up to 10,000; larger lists are split into multiple jobs automatically.
Source	String	False	Specifies whether to include the source file of each version. Defaults to true.
Renditions	String	False	Specifies whether to include the renditions of each version. Defaults to false.
IncludeText	String	False	Specifies whether to include the extracted document text file for each exported version. Defaults to false.
ExportTimeout	String	False	The maximum number of seconds the entire operation may run, covering job submission, waiting for the export jobs, and retrieving results. Defaults to 3600. Set to 0 to run without a time limit.
PollInterval	String	False	The number of seconds to wait between export job status checks. Defaults to 15. Values below the Vault minimum of 10 seconds are raised to 10.

Result Set Columns