User guide

Creating a Data Extract Export Job (Export Extracted Data/Data Extract Export Job)
www.iprotech.com Ipro eCapture User Guide 7-159
877-324-4776 Q1 2014
Defining Export Fields for Databases
If you are creating any database load file formats during the Ipro eCapture
export process, you need to define the export fields that Ipro eCapture will
export. This step ensures that the data exported from Ipro eCapture matches
the fields in the database where the data will be used.
There are several field types that can be exported. These field types are desig-
nated as follows:
S (System Fields): These fields only have meaning in the context of an Ipro
eCapture export. If a document was viewed outside of the export, none of
these field types would apply. Any brackets [] will be removed from the label
when exporting. The System field definitions are as follows:
ITEM_ID: The Ipro eCapture unique identifier for the document. Can be
added/removed from Selected Fields.
BEGDOC: Starting Bates of the document.
ENDDOC: Ending Bates of the document. Note: Not automatically included in
the Selected Fields box; however, may be selected if it is to be included in the
export.
BEGATT: Starting Bates of the attachment range.
ENDATT: Ending Bates of the attachment range.
PARENT_ATTACHMENT: "P" for anything not an attachment, "A" for attachment
(child).
ATTACHMENT_BATES: Semicolon-delimited list of Bates numbers of the chil-
dren of a parent document.
ATTACHMENT_ITEMIDS: Semicolon-delimited list of the ItemIDs of the chil-
dren of a parent document.
PARENT_BATES: If a document is a child, the Bates of the parent.
PARENT_ITEMID: If a document is a child, the ItemID of the parent.
EXPORT_NATIVE_FILES: Used when exporting native files. Shows export path
to the native files. Defaults to Selected fields box when Export Native Files is
selected from the Formats and File Handling screen. May be moved from
Selected Fields box to Available Fields if required.