eCopy Connector for Quick Connect
Quick Connect enables users to scan documents and deliver them to predetermined network locations, Web locations, databases, or to an SMTP server, with minimal data entry requirements. It is ideally suited to environments where large numbers of documents must be scanned quickly into automated or manual workflows.
To be able to use this connector with the Email and folder watching service, you need to create a profile in such a way that it does not require user interaction (express).
For the generic connector configuration options, see Configure connector profile.
Destination settings
Field/Button |
Description |
---|---|
New |
Adds a new destination. |
Edit |
Edits an existing destination |
Copy |
Copies the selected destination. |
Remove |
Removes the selected destination. |
Move up |
Moves the selected destination up in the list. |
Move down |
Moves the selected destination down in the list. |
Expression |
Displays the Expression dialog. |
Field/Button |
Description |
---|---|
Name |
The name of the destination. |
Type |
The type of the destination. The following destination types are available:
|
Field/Button |
Description |
---|---|
Folder location |
Destination information for the scanned documents.
Note that Quick Connect does not support long UNC paths, thus full path names are limited to 260 characters, |
Secure connection (FTPS explicit) |
Check this box to enable a secure connection. Only available for FTP folders. |
Enable subfolder navigation |
Enables users to select a subfolder at the device. |
Root path |
Only valid for Windows folders. Clicking the key icon before this textbox allows ShareScan to retrieve the root path data from Data Publishing. When the icon is highlighted, the name of the data published key defining root path must to be specified in the textbox (for example, a barcode name). The root path (a UNC path) is retrieved from this data published key during runtime. If the key icon is not highlighted, the root path has to be specified in the textbox manually. If the Data Publishing is used, subfolder routing and subfolder navigation works normally. |
Maximum folder level |
The number of subfolder levels users may navigate. The default is 3. |
Subfolder routing... |
This button displays a dialog which configures subfolder names where documents are stored. The text box under Folder Location specifies the root folder of the destination. A user can navigate subfolders underneath this root folder. If subfolder navigation is enabled at the device, Quick Connect creates subfolder underneath the user-specified folder and stores documents in the created folder. If subfolder navigation is disabled, Quick Connect creates a subfolder underneath the root folder and stores documents in the created folder. The location where documents are stored is: <Root folder>\<user navigated subfolders>\<subfolder to be created>\<document.pdf>
|
Only available for Secure FTP destination type.
Field/Button |
Description |
---|---|
FTP type |
|
Ssl mode |
|
Passive |
Select this check box for a passive FTP connection (the client initiates both connections to the server; this solves the problem of firewalls filtering the incoming data port connection to the client from the server). |
Field/Button |
Description |
---|---|
Authentication type |
Available for FTP folder, Secure FTP, WebDAV folder; the following options exist for each type:
|
Authenticate user |
The options are:
|
User ID |
All Authentication types require a user name and password if Logon As is selected as the user authentication method. |
Password |
Specifies the password for the Logon as user. |
Domain |
Select either Logon as or RunTime authentication mode to enable this combo box.
|
Tree |
Only available for Novell Netware folders; has the same function as the Domain combo box. |
Field/Button |
Description |
---|---|
Server |
Specifies the SMTP server via name or IP address. |
Port |
Specifies the port number used. The default is 25. |
Account |
Sets the account to be used for authentication. The following options are available:
|
Reply To |
Specifies the sender's email address. Available only for Generic account None Authentication. |
Domain |
Specifies the domain name used as initial value on the Logon form. Available only for Personal account - Windows Authentication. |
Tree |
Specifies the tree name used as initial value on the Logon form. Available only for Personal account - Netware Authentication. |
LDAP settings |
Displays the LDAP server settings dialog. Available only for Personal account - LDAP Authentication. |
Cc sender |
Checking this box sends a copy of each message to the sender. |
To listbox |
Use the Add button to add the SMTP addresses of the recipients. |
Subject |
Set the subject of the message. |
For more information on database types and settings, see Database types and settings.
Field/Button |
Description |
---|---|
DB type |
The configured database types are displayed here. The available types are as follows:
|
Data source |
Displays the data source. |
Catalog |
Displays the catalog name, if supported. |
Table |
Displays the table name with schema, if applicable. |
Document data (BLOB) |
Displays the column name for the document's data (BLOB). |
Document name |
Displays the column name for the document name. |
Document extension |
Displays the column name for the document extension. |
Configure |
Displays a situation-based dialog. If the administrator is defining a new Database destination, clicking this button displays the Configure Data Source dialog to define database connection. If a defined database connection exists, the Select recent data source dialog with previously used connections is displayed, thus the administrator can reuse existing connection setting or go to Configure data source dialog via the New… button. If an existing connection setting is selected or new connection setting has defined, the connector displays the Map document destination dialog to define data mapping. |
Field/Button |
Description |
---|---|
Name Location, and Logon |
Enables you to create a list of destinations to which the connector profile can send scanned documents. Clicking the Add button displays the Add destination to ... window, where you can set the attributes of the chosen destination. When you add a destination to the list, you specify the destination name, type, and location, as well as the authentication information. The New destination window then lists all the destinations. |
To make sure that users have to log on, at most once, at the device, you cannot mix certain combinations of destination type and authentication in a destination list.
If you add a Windows Folder or Novell Netware Folder destination that uses Runtime authentication, and then you add an FTP Folder destination, the Authenticate User combo box is shown without Runtime authentication mode.
Invalid options will not be available in the Authenticate User list.
This destination type represents another ShareScan workflow that receives its input from the output of this connector profile / destination.
By using the Connector destination type, it is possible to chain ShareScan workflows with the limitation that the second (and third, and so on) workflows in such a chain must be an Express workflow (that is, not having any user interface / forms to display), similarly to the Watcher workflows.
For more details on Express workflows, see the Watcher.
To transfer document metadata between the original and the chained (connector destination) workflow, you can use the XML Index File fields: whichever metadata (data from Data Publishing, like barcode values, data provided by Database Lookup Extender and so on) item you want to use in the chained workflow, you simply need to specify it as a field the Index File of the connector profile using a Connector destination, and create a mapping in the Data Publishing Mapper.
The Connector destination type can also be used as an item in a Destination list. In this way, the same document(s) can be stored via multiple connectors.
The following scenarios details how to properly configure the QuickConnect Connector destination:
Make sure that the Connector destination type is available and the created profile results in a hidden watcher configuration:
- Prerequisites
- Install ShareScan
- Load normal (non-watcher: dev, prodd, eval, nfr) ShareScan license
- Create / Set HKLM\SOFTWARE\Wow6432Node\Kofax\ShareScan\ShareScanAdmin\ShowHiddenCascadingWatchers to true
- Create a no-UI (aka Express) workflow with QuickConnect (profile is
named as finaltarget in the example below)
- Create a folder on a local drive (for example, ShareScanQC)
- Create a Windows folder destination (named as Output1 in the screenshot below) using the folder created in the previous step
- Make sure the is no user modifiable settings (for example, document type) in the connector profile
- The icon of the connector profile will be grey, indicating the profile does not require any user input
- To be able to check the hidden watcher profiles, import a valid Watcher license as well. All the functionalities (of creating connector destinations) must also be available without a connector license.
- Tests:
- Create a new QuickConnect profile (for example, by Save As... the default profile – named as ConnectorDest1 in the example below)
- On the Destinations tab click the New button
- The New destination dialog appears
- There will be a Connector item in the list of the Type control.
- If you select the Connector item, the dialog UI changes as follows: (If there is no Express profile to select, a warning is shown.If there is/are profiles(s) to select, they are included in the list.
- Click OK – a warning appears:
- If you click the Click to edit index field mappings of this destination link, the same warning appears.
- Click the finaltarget radio button under the Quick Connect node (only the Express (no-UI) profiles should be listed in this dialog – all of the Express profiles should appear in this list, for any of the connectors having such type of profile)
- If you click the Click to edit index field mappings of this destination link, the Data Publishing Mapper dialog appears (does not contain any items to edit yet, as there are some pre-requisites).
- Click OK: a new destination shall appear on the Destinations tab, with the specified name, with the blue puzzle icon (representing the Connector destination)
- Click the Save button for the profile saving.
- Go to the Devices tab / Watching, right-click / Reload watchers: a watcher appears
- A new entry is displayed, with the following name structure: <QC profile name>@<destination name> }- QuickConnect-<target express profile name>(This watcher is not be visible if the registry setting described in 1/c is not set, or set to false) Observe that the Rule has the name Rule - <GUID>, where the GUID is an automatically generated unique identifier of the connector destination
- Click the newly created watcher entry, and check the Summary in the main panel of Administration Console
- The Watch Folder entry will point to a folder under ...ShareScan\Cascading\<GUID>, where the GUID is a unique identifier of the connector destination. This GUID matches the GUID displayed for the Watcher Rule in m.)
- Open Windows Explorer and check the folder shown in the Watcher Summary – it should be created by the creation of the Connector destination.
- When the Rule is selected, click the Edit button in the Main panel - the Rule editor Wizard appears:
- Observe that the Do not recreate PDF files check box and the Route to destination without processing radio buttons correspond to the check box on dialog 2.e
- If the QC connector profile with the Connector destination is created with any/both of the check boxes of 2.e having checked values, then the Do not recreate PDF files check box in the rule will be the same as the state of the corresponding check box of dialog 2.e; the Route to destination without processing radio button will be selected in the rule if the Route only check box was checked on dialog 2.e
- The settings of the rule described in (s.) will correspond to the check box states of 2.e also if the connector profile / Connector destination is edited. FAIL
- If the target Express profile is changed (while editing the connector destination), the change will be reflected in the watcher Rule. PASS
- Testing if the DP mapper dialog is showing up only the relevant
fields:
- Create an index field (on the Index File tab click Add. Do not save the connector profile at this point.
- Create a connector destination or edit an existing one
- Click the Click to edit index field mappings of this destination link. A message box pops up.
- If you click on No, the message box disappears and the DP mapper will not open. If you click Yes, the connector profile is saved, and then the DP mapper will open.
- The list of the Published Key column should contain only the field that is defined as an index field in the QC profile, having this connector destination. The name of the key will be Connector Destination.<name of the QC profile> . FAIL – the key is shown only when the QC profile was saved manually
- Connector keys in the DP mapper dialog are filtered to the available connector keys of the target connector – this is identical to the feature of the DP mapper when it is opened from the connector profile right-hand panel link.
Make sure that in Quick Connect connector, Connector destination type is available and the created profile results in a hidden watcher configuration in the Destination list:
- Prerequisites: same as in the previous scenario
- Tests:
- Similar to step 2.a of the previous scenario.
- Similar to step 2.a of the previous scenario.
- On the New destination dialog, select Destination list from the Type list.
- Click the Add button.
- From this point, creating the Connector destination is the same as in the previous scenario.
- When the destination dialog is confirmed with OK, the newly created destination list item appears in the list.
- The Summary panel below reflects the different settings of the Connector destination (Name, connector type, target profile name, Route only flag, PDF recreate flag). Clearing or selecting is necessary to have these changes visible.
- All the other test items from the previous scenario apply.
Field/Button |
Description |
---|---|
Choose connector profile for processing |
This list displays the configured Express connectors / profiles (that is, the profiles with no UI runtime). If no connector / profile is available with Express setup, a warning message informs the user that the profile and corresponding services require Express mode. These profiles will not replicate in an AutoSync environment. |
Route only |
Select this check box if you want to pass your files to their destinations without processing and/or transformation. |
Do not recreate PDF files |
Select this check box to process incoming files as if they are all actual scans. When the Route only check box is selected, this check box is greyed out. |
Click to edit index field mappings of this destination |
Click this link to open the Data Publishing mapper tool with the published keys filtered for the keys derived from the index field of Quick Connect and the connector keys filtered to the destination Connector selected. |
LDAP server settings
Field/Button |
Description |
---|---|
Server |
The IP address, DNS name, or URL of the LDAP server associated with the directory you want to use. |
Port |
The LDAP server port number. The default is 389. |
Server requires SSL |
Select this check box if connecting to the LDAP server requires SSL. |
User ID |
The ID of the administrator who logs on to the LDAP server. This administrator account is used to query e-mail address for runtime-log-on user from the LDAP server. |
Password |
The password associated with the server account. |
Connect anonymously |
Allows anonymous connection to the LDAP server, if the server supports anonymous authentication. |
Base DN |
The DN of the base or root of the directory in which to search. This varies depending on the server you are using and the portion of the directory you wish to search. |
Test |
Pressing this button checks the connection to the specified LDAP server. If the test succeeds, the OK button is enabled. |
Setting a database as a destination
Setting a database as a destination enables you to configure a connector profile so that users at the device can scan and index documents and store them in the specified database. You can configure the profile to store the index information in a file, in the same database as the scanned document, or in a different database.
To set a database as a destination:
-
On the Configure tab, click New.
The New destination window opens.
- In the Name field, enter a name for the destination.
- In the Type list, select Database.
-
Under Destination, click Configure.
The Configure data source window opens.
- Configure a new data source.
- Select the database type and specify the settings.
- Click Test connection.
- When the system displays the “Test succeeded” message, click OK twice.
Or
Configure an existing data source
- If the Select recent data source window opens, select the data source that you want to use.
- Click OK.
The data source is the database where the scanned documents will be stored.
- Depending from the purpose, the following windows are displayed:
- Map document destination for database destinations.
- Choose fields dialog for database fields.
- Map index fields dialog for index files.
- Click OK. The New destination window displays the database settings.
- Click OK to save the settings. The Destinations list displays the name and summary information for the database destination you created.
Database types and settings
Database type |
Settings |
---|---|
Microsoft Access |
Specifies the path to the Access database (*.MDB), which can be on a local drive or on a Universal Naming Convention (UNC) path. If the database is on a local drive and does not require a user name and password, select the Blank Username and Password check box. If the database is on a UNC path, enter the appropriate credentials. The user must have permission to access the specified path. |
Microsoft SQL |
Specifies the SQL server, user name, and password used to access the SQL Server, and the Catalog/Database.
|
Oracle |
Specifies the listener, user name, and password used to access the Oracle database.
|
Map a document destination
When you set a database as a destination, you can use the Map document destination feature to map the name and file extension of the scanned document to STRING fields in a table in the database. This enables you, or a database administrator, to create associations between the scanned document and any index information that the user enters on the Index screen for the document, wherever that index information is stored.
Database type |
Settings |
---|---|
Connection information |
Displays current database connection information:
Use the Modify button to edit the displayed information, and the Refresh button to clear table selection and field mapping. |
Select Table Name |
Displays available tables in the current data source. If a table is selected from the list, it gets bold and the Map Fields data grid view gets enabled. |
Map Fields |
Displays which fields are mapped to which database columns. The administrator selects a column name from list. The column for Document Data (BLOB) must be specified but Document Name and Document Extension is optional. If an already assigned column is reselected, the dialog shows an error message and clears column selection. |
Using a database as the source of field values
You can create a file name field or an index field that uses a database as the source of field values. Users at the device can then select from a list of available values for that field.
If the database administrator modifies, in a database, values that are associated with a Quick Connect field, users will have access to the changed values. You do not need to make any changes to the field in the Administration Console.
To use a database as the source of field values:
-
On the File name or the Index file tab, click New.
The appropriate Field editor window opens (File name field editor or Index file field editor).
- In the Name field, enter a name for the new field.
- In the Type field, select Database as the type.
- Check User modify if you want the user at the device to be able to alter this part of the file name.
- Select the Required option if you want to require users at the device to specify a file name or index value.
-
Click Configure.
If you have previously configured a data source, the Select recent data source window opens.
-
On the File name or the Index file tab, click New.
The appropriate Field editor window opens (File name field editor or Index file field editor).
- In the Name field, enter a name for the new field.
- In the Type field, select Database as the type.
- Check User modify if you want the user at the device to be able to alter this part of the file name.
- Select the Required option if you want to require users at the device to specify a file name or index value.
- Click Configure.
If you have previously configured a data source, the Select recent data source window opens.
- To use an existing data source, select it and then click OK.
-
If you do not want to use an existing data source, click New.
The Configure data source window opens. Follow the instructions to configure a new data source.
- If you have not previously configured a data source, the Configure data source window opens. Follow the instructions for configuring a new data source.
- After selecting or configuring a data source, the Choose field window opens.
- Select a table, select a column in the table, and then select the default file name or index value from the list of available values. The user at the device can accept the default value for the field or select a value from the list.
-
Click OK to return to the Field editor window.
The window displays the settings you have configured.
-
Click OK to save the settings and return to the File name or Index file tab.
The tab displays the name and summary information for the Database field you created.
Defining Expressions for destinations
You can define parameters, operators, and constant values via the Expression dialog. The parameters are published to the Data Mapping tool and mapped to published data from a document service. Document service publishes data as string and the connector converts the string to specific data type according to parameter type.
Field/Button |
Description |
---|---|
New |
Allows adding a new parameter via a dialog, where you can set the name and type of the new parameter. The available data types are the following:
|
Edit |
Edits the selected parameter. |
Remove |
Removes the selected parameter from the list view. |
Operator |
Select a parameter to display the available operators defining how to compare parameter and constant values. The set of operators varies according to parameter type. |
Constant |
Select a parameter to display the constant value which is compared to parameter value during runtime. The input text must be formatted properly to successfully process the equation. |
Defining file naming fields
The file name generated at the eCopy-enabled device is composed of one or more fields. Note that if file name is not published by document service, Quick Connect uses its file naming rule even if you check Use Document Service file name.
To define file naming fields:
- Select the File Name tab.
- Click New.
- Use the File name field editor to specify a name for the field and set the default values.
- Click OK.
-
Repeat this procedure for each new file naming field.
Or
Select Use Document Service file name to use the file name configured for the Document Service.
-
Click the Save current profile button.
The system saves your settings as part of the connector profile.
File name tab
Field/Button |
Description |
---|---|
New |
Adds a new entry via the File name field editor. |
Edit |
Edits an existing entry via the File name field editor. |
Remove |
Removes the selected entry from the list view. |
Move up |
Moves the selected entry up in the list view. |
Move down |
Moves the selected entry down in the list view. |
Use Document service's file name |
Checks published entry name by a document service. If the file name is published, the connector uses the published name as an output file name instead of the File naming form and constructing the file name according to file naming rule. |
If file name already exists: |
Set the method for resolving file name conflicts:
|
Field Type |
Description |
---|---|
Name |
Specifies a unique file name field name. Not case sensitive. If you increase the minimal length, this field becomes required. |
Type |
Specifies a type of field. Type-dependent settings change according to the field. For more information, see the Field types table below.
|
Export to Index File |
Specifies whether the entry name field value is exported to the index file. If checked, a field which has a name of FileNameField.<field name> is added to the Index File list view control in the Index File tab. |
Field Type |
Description |
---|---|
Alphanumeric |
Inserts text into the file name. The text can contain any printable characters except those restricted from Windows file naming conventions or any characters you define as separators.
|
Batch number |
Inserts the current batch number into the file name.
|
Batch-based index value |
You can only use batch-based index values if you have the eCopyBarcode Recognition Service. Batch-based indexing enables you to create index files with separate barcode values for each batch. |
Database |
Inserts a value from the database into the file name. Click the Configure button and configure a data source. |
Date |
Inserts the date on which the document was scanned into the file name. Format: The format in which you want the date to appear in the file name. |
Device name |
The name of the device from which the document is scanned. No additional settings. |
Numeric |
Inserts numeric characters into the file name.
|
Separator |
Character: The character that you want to use to separate the fields in the file name. The character that you select cannot be used in any other file name field. |
List |
Enables you to create a list of values from which the user can select a single value at the device. If you select the Required option, the user at the device must select a value from the list. If you do not select this option, the user at the device can leave the field blank. If you select the Required option and do not select the User modify option, you must set one of the list items as the default value. |
Time |
Inserts the time at which the document was scanned into the file name. Format: The format in which you want the time to appear in the file name. |
Defining index files
Setting up an index file enables the user at the device to enter indexing information for the scanned document in one or more fields. Quick Connect writes the field names that you create on the Index file tab to an index file, and creates data mapping information between field names and database columns. The default values that you associate with each index field, or the values entered for the field by the user at the device are also stored in the index file or database table.
The information describes the content of the document, such as a case ID, a client name, or a document type. Quick Connect saves the index information with the scanned document. This option is useful with back-end applications that can process the scanned documents (image files) and index files in the destination folder.
To configure an index file:
- Select the Index File tab.
- Click New.
- Use the Index Field Editor to define an index field and its default values.
- Click OK.
- Repeat this procedure for each new index field.
- In the File format area, select the format of the index file.
- If the Document splitting option is enabled on the Settings pane and you want to create a single index file, select Create single index file when Splitting is enabled.
- If you want to duplicate unchanging index values, select Repeat unchanging index values.
- Click the Save current profile button. The system saves your settings as part of the connector profile.
Index file tab
Field/Button |
Description |
---|---|
New |
Adds a new field via the Index file field editor. |
Edit |
Edits an existing file via the Index file field editor. |
Remove |
Removes the selected file from the list view. |
Move up |
Moves the selected file up in the list view. |
Move down |
Moves the selected file down in the list view. |
Mapping |
The Select Recent Data Source or Map Index Fields dialog is displayed directly, if no connection settings are stored to the registry. In the dialog you can assign Index fields to database columns. If at least one index field is configured and the Database button is clicked, this button gets enabled. |
File format |
The following file types are available:
Note: When selecting the Database option, the Mapping button is enabled on the toolbar. |
Convert XML file |
Select XML index file format to enable this control. If this control is checked, the controls in XSLT group are enabled. |
XSLT group |
The following options are available via the XSLT group:
|
Create single index file when Batching is enabled |
If checked, the connector creates a single index file per job. If unchecked, an index file per batch is created. |
Repeat unchanging index values |
Available only if Create single index file when Batching is enabled is checked. If checked, the connector records the system- or job-based index values for every batch. If unchecked, the connector records the system- or job-based index values only once and records batching-based index values for every batch. |
Field Type |
Description |
---|---|
Name |
Specifies a unique file name. Not case sensitive. |
Type |
Specifies a type of field. Type-dependent settings change according to the field. For more information, see the Field Types table below.
|
Field Type |
Description |
---|---|
Alphanumeric |
Records the text which contains any printable character into the index file. |
Batch-based index value |
Pulls published value from DataPublishing based on current batch number and records into the index file. |
Database |
Records the selected value from the database into the index file. |
Date |
Records the formatted text of the date into the index file when the job was started |
Destination path |
Records the location where the document is sent into the index file. The location information differs according to destination type:
|
Device name |
Records the name of the device on which the client is running into the index file. The device name is retrieved when the connector starts. |
File name |
Records the file name of the document into the index file. |
Logged on user |
Records the logged on user’s name into the index file. If the destination uses Runtime authentication, the connector records runtime-logon-user name (either Bypass session logon user, CAC user or connector’s log on user). If authentication mode is Logon as, it uses pre-configured user name. Otherwise it records an empty string. |
Number of pages |
Records the number of pages in the document into the index file |
Numeric |
Records the text which contains only numeric characters into the index file. |
File size (kB) |
Records the file size of the document in kB into the index file. |
List |
Records the selected value from the list into the index file. |
Time |
Records the formatted text of the time into the index file when the job was started. |
Index file formats
The index file has the same name as the scanned document, but has a different file extension. The available formats of the index file are:
- XML
- CSV (comma-separated value)
- TSV (tab-separated value)
- Database
Document splitting settings
When the Document splitting option is enabled on the Settings pane, you can configure Quick Connect to create a single index file that records the index values entered at the device for all scan jobs of a batch.
-
The connector uses the file name that you create on the File name tab to create a name for the index file. If you do not configure a file name, the connector uses the default file naming rule.
If the file name includes the Batch number field, the connector sets the current batch number in that field; otherwise, the connector adds an underscore (_) to the batching number, as in “document-20070131_1.pdf”.
If a file name already exists and the Create unique file name option is configured on the File name tab, the connector adds a period to the rolling number, as in document-20070131_1.1.pdf.
- Index fields are divided into three types. The type of index value determines the frequency of changes to index values:
-
System: The index field retains the same index value when the user at the device starts a new scan job.
Used with the following field type: Device Name.
-
Scan Job: The index values in index fields of this type are the same for the entire scan job.
Used with the following field types: Alphanumeric, Numeric, Date, Time, List, Authenticated user, Destination path, Database.
-
Splitting job: A scan job can comprise multiple document splitting jobs. The index values in index fields of this type change for each document splitting job.
Used with the following field types: File name, Number of pages, File size, and Batch-based index value.
- The Repeat unchanging index values option enables you to record the index values for a batch job each time the user enters the index values, even if the user at the device enters the same index values many times.
- If you do not select this option, the connector records the system- and scan job-dependent index values only once.
- Since batch job-dependent index values have different values based on the job, they will be recorded multiple times by default. However, if there is only a single batching job, the index values will be treated like system- and scan job-dependent values.
- If you select this option, batch job-dependent index values will be recorded in a different node (for an XML file) or a different row (for CSV and TSV files, and database tables). This does not apply when the connector is processing only one batch scanning job
Mapping index fields to fields in a database
This feature enables you to specify a database that will store index values entered at an eCopy-enabled device. You can map any type of Quick Connect index field to fields in an SQL, Access, or Oracle database. When a user enters values in mapped index fields, the connector profile stores the values in the associated database fields.
If you store scanned documents in a database and you want to create a relationship between the database fields where the documents are stored and the database fields where the index values are stored, make sure that one of the mapped index fields is of the type “File name”. Index fields of type “File name” automatically use the file name of the scanned document that is stored in the database destination.
Map index fields to fields in a database
- Select the Index file tab, click New, and then define each index field that you want to map.
-
Under File format, select Database and then click Map Fields.
The Configure data source window opens.
-
If you have not yet configured a data source, configure it now.
To use the current data source, proceed to step 4.
If you do not want to use the current data source, click Modify to select a different data source. When the Select recent data source window opens, click New and follow the instructions for configuring a new data source.
-
If you previously configured a data source, the Map index fields window opens, displaying the connection information.
- Via Select table name, select a table.
-
Under Map fields, which displays the index fields you created, select the Quick Connect index field you want to map to a database field. You do not have to map all the Quick Connect fields.
In the Database field column, which only displays fields of STRING data type, select the target field. The index values that the user at the device enters in the index fields will be stored in the database fields after the document is scanned.
- Click OK to save the settings and return to the Index file tab.
Configuring batch-based indexing
If you have the eCopy Barcode Recognition Service, you can use batch-based index values. Batch-based indexing enables you to create index files with separate barcode values for each batch by assigning a base name (Publishing Name) to the position of the barcode.
All Publishing Names also have batch information available for Quick Connect to use. Note that only the first value found per Publishing Name is published for the session.
For example, a document is divided into two batches. It begins with a page that contains three barcodes and is split by another page that also contains three barcodes. On both pages the barcodes follow the same sequence but have different values:
Batch-based indexing example
Barcode Number |
Batch-based index value - Publishing Name |
Index value, page 1 |
Index value, page 2 |
---|---|---|---|
1 |
Document Number |
1 |
2 |
2 |
Locator |
4455 |
6677 |
3 |
Extension |
1234 |
5678 |
The following diagram shows the four page document and how, after processing, the scanned document is stored with the correct index information.
To configure batch based indexing in Quick Connect:
- Select the Index file or File name tab.
-
Click New.
The relevant Field editor opens.
- Enter the Data Publishing name to receive the Published Key from the service. You can specify any name to the Name field. The Name field provides descriptive information for you.
- Select Batch-based index value as the Type, and click OK.
- Follow steps 2 through 4 above for each value that you want to use.
- Save the connector profile with the values.
When you configure a device and select this connector profile, you must then select the corresponding Service profile that you set up in the Barcode Recognition Service.
Quick Connect and Data Publishing
Quick Connect can read data published to a Data Publishing service by a connector. For example, a company can install a barcode recognition service and then use Quick Connect to access the barcode data that the service publishes.
The ShareScan administrator is responsible for the following tasks:
- Install and configure the Service on the same computer as the eCopy Manager. For more information see the Help topic for the Service in question.
-
Work with the developer of the service, which may be available from eCopy or from a third party, to identify the data that the Service publishes and the names of the fields that will contain the published data. For example, assume that the document to be scanned contains barcodes. The service extracts data from the following barcode fields and publishes the data to a COM object:
Barcode1, which contains a user name.
Barcode2, which contains a date.
Barcode3, which contains a company name.
Barcode4, which contains a city.
- Define Quick Connect index fields that reflect the names of the fields containing the published data. Using the example, the administrator must define index fields named Barcode1, Barcode2, Barcode3, and Barcode4.
- Configure the Quick Connect index file.
When a user scans a document at an eCopy-enabled device, the Manager starts the installed Service. The Service creates the COM object and publishes data from the scanned document to the COM object. The Manager passes the COM object to Quick Connect, which searches the COM object for the configured field names. If Quick Connect finds a match, for example, if it finds a field named “Barcode1”, it reads the value in that field and writes the value over the default value in the “Barcode1” index field in the index file. Quick Connect then sends both the scanned image document and the index file to the target destination.