Kofax Business Interaction Server - Manual (Page 22)

Chapter 4
16 Business Interaction Server Configuration Guide
<?xml version="1.0" encoding="UTF-8"?>
<m:mapping xmlns:m="http://www.dicomgroup.com/avalin/bis/
fieldmapping"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<map>
<bisfield name="BIS_Firstname" type="String"/>
<dbfield name="ContactFirstName"/>
<description>The first name</description>
</map>
<map>
<bisfield name="BIS_Lastname" type="String"/>
<dbfield name="ContactLastName"/>
</map>
<map>
<bisfield name="BIS_Email1" type="String"/>
<dbfield name="emailaddress"/>
<description>Email address</description>
</map>
</m:mapping>
Tip
For data lookup in your database, you can limit the number of fields where you
want Business Interaction Server to browse for information. Change the SQL Select
statement in the corresponding section of the configuration file bis_config.xml,
usually located in C:\Program Files\Kofax\Business Interaction
Server\Avalin\Jboss\server\avalin\conf, to specify the fields for data lookup.
For the example above, change the <SqlQuery> tag in the <DataLookup> section to
<SqlQuery>SELECT ContactFirstName, ContactLastName, emailaddress FROM
</SqlQuery>.
Supported Data Types
The following lists the SQL data types that are supported by Business Interaction
Server for field mapping configuration:
Table 4-1. Supported Data Types
Data Type Description
Date Represents the date