User guide

Creating a Data Extract Export Job (Export Extracted Data/Data Extract Export Job)
www.iprotech.com Ipro eCapture User Guide 7-163
877-324-4776 Q1 2014
The export will always export the non-displayed system fields
[BATES_NUMBER] and [ITEM_ID] as the first two fields regardless of field
selections shown. All other fields to be exported are displayed in the Selected
Fields box and will be exported, in order, named as the field label. The next
section describes how to populate the Selected Fields box.
Sorting Fields
Alternate click a field and choose Make Sort Field from the shortcut menu. This
option appears for those fields that can be sorted.
A Y appears in the Sort column. To clear this entry, alternate click the field and
choose Clear Sort Field.
When a field is marked as a Sort field, it applies the value of the selected field
to all family members of a parent item. This allows sorting on the specified
field in an external application to be compound-complete. For example, when
the ‘Sent Date’ field is made into a Sort field, the value of the ‘Sent Date’ field
for an email will be used as the value of the same field in the exported load file
for all of the email’s attachments.
About the Select Export Fields Screen
The field type designator (discussed in the section, Defining Export Fields for
Databases on page 7-18) displays in the Type column of both the Available
and Selected Fields boxes.
Available Fields: Displays all fields available to be exported. Click the drop-
down list located above the field list, and select a specific field type. By
default, All Fields display. Ctrl-click to select non-contiguous fields. Shift-click
to select a contiguous range.
Filter Value - enter a value to filter the list. For example, to see only those
fields that contain the word “date”, enter date and click . To display all
fields, delete the value and click .
Selected Fields: Displays all fields selected from the Available Fields for
export. Right-click a field to edit it.
: Click to move a selected field from the Available Fields box to the
Selected Fields box.