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


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


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


There are several workarounds for this problem.

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

// Database connection string
	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);

/* 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 = 

// Update the list of entries

// Close the connection

You can select the workaround that best suits your needs.

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