ExportFromDatabase

ExportFromDatabase(Type As Integer, Name As String, MaxNoOfItems As Integer, Statuses As Integer, Queues As Long, Keep As Boolean, FileName As String, ID As String, ID2 As String, ExportDefs As Boolean, IncludeImages As Boolean, JobName As String, NoOfExported ByRef As Integer) As Integer

Application object

This method is used with ImportToDatabase and StatusOnExportFile. We recommend that these three methods be implemented by advanced users only.

ExportFromDatabase exports forms or sets from the database to a file. The forms or sets that match the parameters are written to the file, together with the following:

The form definition (or form definition(s) and set definition, if you export sets), if ExportDefs is set to TRUE

Any image images exported by FORMS (that is, images created by FORMS during the scanning process), if IncludeImages is set to TRUE

The job file (if specified)

NoOfExported contains the actual number of exported items when the function is finished.

The method returns 0 if it succeeded, otherwise an error code.

Parameters

Parameter

Description

Type

1 = Forms, 2 = Sets

Name

Name of the form definition or set definition from which you want to export data.

MaxNoOfItems

Maximum number of items to export.

Statuses

Statuses to export. Set bit flag to:

2 for Identified
4 for Complete
8 for Incomplete
16 for Interpretation error
32 for Validation error
64 for Retype
128 for Transferred
256 for Unidentified
512 for Mass Verify

Add up if more than one status is to be imported.

Queues

Queues you want to export from. Bit flag. Set to -1 for all queues.

Keep

If set to TRUE, the exported items are kept in the database—that is, the file will be a copy of the items. If set to FALSE, the items are deleted from the database.

FileName

Export file name, including full path.

An optional user-specified string to be written to the file. Max. 128 characters. Can be retrieved with ImportToDatabase or StatusOnExportFile.

ID2

A second optional user-specified string to be written to the file. Max. 128 characters. Can be retrieved with ImportToDatabase or StatusOnExportFile.

ExportDefs

If set to TRUE, the form definition name (or form definition(s) and set definition, if you export sets) is written to the file.

IncludeImages

If set to TRUE, any images exported by FORMS (that is, images created by FORMS during the scanning process) are also written to the file.

JobName

A job description file name, without any path. Only job descriptions in the job directory are found. Both the job description file and the associated .evm file are written to the file.

(The job directory is specified by the JobFiles setting in Ehlocal.ini.)

NoOfExported

Returns the actual number of exported items.