Knowledge Base

Article ID: 1399 | Category: Export | Type: Hot Fix | Last Modified: 10/1/2013

Exporting fields with multiple lines of text to an Oracle database

Description

An Oracle database requires fields with multiple lines of text, but these fields only contain one line after being exported from ABBYY FlexiCapture 10.

Reason

ABBYY FlexiCapture 10 does not currently support exporting fields with multiple text lines to databases. All newline characters are deleted.

Solution

There are several workarounds for this problem.

//------JScript------
// Declare ADO object variables
var adoConn = new ActiveXObject("ADODB.Connection");
var adoRS = new ActiveXObject("ADODB.Recordset");

// Database connection string
adoConn.Open('Provider=OraOLEDB.Oracle.1;Password=scott;
	Persist Security Info=True;User;Data Source=test;');

// Open the list of tables available at this connection 
adoRS.Open("Select * From ScriptExport", adoConn, 1, 3);
adoRS.AddNew;

/* Write the value of the DeliveryAddress field 
from the first section of the DocumentSection1 document.
The number of the section must be specified because there
may be several DocumentSection1 sections in this project */
adoRS.Fields("Address").Value = 
             this.Field("DocumentSection1[0]\\DeliveryAddress").Text;

// Update the list of entries
adoRS.Update;

// Close the connection
adoRS.Close();
adoConn.Close();

You can select the workaround that best suits your needs.

375 people think this is helpful.
Was this information helpful to you?