Export Form Data to OLEDB plugin properties

The Export Form Data to OLEDB plugin exports form data to a database that supports OLEDB.

Value Pair	Description
column	List to specify how to map the form’s data.
connectionstring	OLE DB connection string to the database.
table	The name of the destination table.

Optional Value Pair	Description
lineitem	XPath to the repeating element to be exported.
lineitemcolumn	Value pair list to specify how to map the repeating group’s data.
lineitemimportkey	Value pair to specify a form field to be stored in a line item column.
lineitemtable	Name of the table to which a form’s repeating group data is exported.

The following example stores the form data specified into the PurchaseRequest table in the specified Access database.

Example

column – PRNumber=[//my:PRNumber],Dept=[//my:Dept],Requestor=[//my:Requestor],RequestDate=[//my:RequestDate],Vendor=[//my:Vendor],VendorAddress=[//my:VendorAddress],Amount=[//my:PRTotal],Description=[//my:Description],VendorTel=[//my:VendorTelephone],VendorContact=[//my:VendorContact],DeliverySchedule=[//my:DeliverySchedule]
connectionstring –Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\FormDataSource\db.mdb;User Id=admin;Password=;
lineitem – //my:LineItem
lineitemcolumn – ItemNumber=[my:ItemNumber],ItemDesc=[my:ItemDesc],Qty=[my:ItemQty],UnitPrice=[my:ItemUnitPrice],Total=[my:ItemTotal]
lineitemimportkey – PRNumber=[//my:PRNumber]
lineitemtable – PRLineItem
table – PurchaseRequest