User guide

Setting Data Extraction Options
www.iprotech.com Ipro eCapture User Guide 5-83
877-324-4776 Q1 2014
Select from the following Data Extraction options:
Replace tabs with spaces when extracting Excel text: When this option is
selected, the extracted Excel text will look similar to this:
Column A Column B
Value1 Value2
The column data is separated by a space rather than a tab (which can be, for
example, the equivalent of 5 spaces). Therefore, if the option is not selected,
then the extracted Excel data would look similar to this:
Column A Column B
Value1 Value2
In the above example, the column data is separated by a tab (5 spaces).
Expand Pivot Tables when extracting Excel text: Default is unchecked. If
pivot tables exist, they will be expanded when this option is checked. A flag is
also set in QC to indicate the Pivot table exists in the worksheet.
See the section Setting the Common Options on page 5-84 for a description of
the OCR options.
Lotus Notes - select from one of three methods:
• High Speed (Optimized for speed)
•Medium Speed (Balance of speed and quality)
• Low Speed (Optimized for highest quality output - UI Printing)
Note: Existing projects will have the Lotus option set to the Medium Speed
method which was the default method in version 2013.0.0. Newly created
Projects/Jobs will default to the High Speed method. The Low Speed option is
the same as the former Legacy option - extract text from Lotus Print UI. For
error handling, the next option will be used as fall back. For example, if errors
occur when High Speed is selected, then a retry occurs using the next method
of Medium Speed.
If the system defaults are in place, the system default options should be
adhered to using the following rules:
• If Legacy is checked; new Projects have Legacy selected
• If Legacy is not checked; new Projects have ESI selected