Welcome > Data type compatibility

Data type compatibility

This topic describes the data type compatibility between Kofax Capture and Microsoft SharePoint and between Kofax TotalAgility and SharePoint. With Kofax Express, data types are not applicable because index field values are treated as strings.

General compatibility rules

Data type checking is performed at export time. For the most part, if Microsoft SharePoint does not accept a data type from Kofax Capture, the data is ignored. However, if date or time data is invalid, the document is rejected and sent to Quality Control.

Note The connector supports Date Only as well as Date & Time data types for Microsoft SharePoint columns. This includes proper adjustments for different locales and time zones.

Valid Yes/No Formats

In Microsoft SharePoint:

  • TRUE or the number 1 is accepted as Yes.

  • FALSE or any number other than 1 is accepted as No.

Numbers

In Microsoft SharePoint:

  • If a column definition includes a limit on the number of decimal places, any numbers sent to that column are rounded to the defined limit.

  • If a column definition includes a range limit, accepts numbers outside of that range.

Choice Lists

A choice value, when formatted as text, must match an element in the choice list.

Hyperlink and Picture Columns

Hyperlink and Picture columns only accept properly formatted URLs.

Data type compatibility - Kofax Capture and SharePoint

The following table shows how Microsoft SharePoint data types are compatible with the Kofax Capture data types.

Kofax Capture Data Types

SharePoint Data Types
Single line of text Multiple lines of text Number or currency Date

or time

Yes/No Person and Group Hyperlink or Picture Choice Lookup Enterprise Keyword Managed Metadata

Char

x

x

x1

x2

x

x

x4

x5

x5

x

x5

Date

x

x

x

x3

x5

x5

x

x5

Decimal

x

x

x

x

x5

x5

x

x5

Double

x

x

x

x

x5

x5

x

x5

Float

x

x

x

x

x5

x5

x

x5

Integer

x

x

x

x

x5

x5

x

x5

Numeric

x

x

x

x

x5

x5

x

x5

Real

x

x

x

x

x5

x5

x

x5

Smallint

x

x

x

x

x5

x5

x

x5

Time

x

x

x

x3

x5

x5

x

x5

Varchar

x

x

x1

x2

x

x

x4

x5

x5

x

x5

Legend

1 The text must be a valid number.

2 The text must be a valid date.

3 The value is No.

4 The text must be a properly formatted absolute URL.

5 The entered value must belong to an existing choice list, lookup list, or a set of terms.

Kofax Values and text constants

The following table shows how Microsoft SharePoint data types are compatible with Kofax Values and Text Constants.

Kofax Values

SharePoint Data Types

Single line or multi-line text

Choice

Number or currency

Date or time

Yes/No

Hyperlink or Picture

{Batch Creation Date}

x

x

{Batch Creation Time}

x

x

{Current Date}

x

x

{Document Count}

x

x

x

x

{Current Time}

x

x

{First Page Roll Number}

x

x

x

x

{Batch ID}

x

x

x

x

{Document GUID}

x

All other Kofax Values

x

x

x1

x2

x

Text Constants

x

x

x1

x2

x

x3

Legend

Unsupported data types - Calculated, Business Data, Publishing HTML, Publishing Image, Publishing Hyperlink, Summary Links, Audience Targeting, and Media fields.

1 The text must be a valid number.

2 The text must be interpreted as a DateTime by the Microsoft .NET library.

3 The text must be a properly formatted absolute URL or relative URL.

Data type compatibility - Kofax TotalAgility and SharePoint

The following table shows how Microsoft SharePoint data types are compatible with the Kofax TotalAgility data types.

Kofax TotalAgility Data Types

SharePoint Data Types

Single line of text Multiple lines of text Number or currency Date

or time

Yes/No Person and Group Hyperlink or Picture Choice Lookup Enterprise Keyword Managed Metadata

Text

x

x

x1

x2

x3

x

x4

x5

x5

x

x5

Boolean

x

x

x

x5

x5

x

x5

Choice

x

x

x1

x2

x3

x

x4

x5

x5

x

x5

Date

x

x

x

x3

x5

x5

x

x5

Number

x

x

x

x3

x5

x5

x

x5

Legend

1 The text must be a valid number.

2 The text must be a valid date.

3 If the input value is 1, Yes, or True, the SharePoint output value is Yes (check box selected). For all other input values, the SharePoint output value is No (check box not selected).

4 The text must be a properly formatted absolute URL.

5 The entered value must belong to an existing choice list, lookup list, or a set of terms.