Export Form Data to ODBC plugin properties

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

Value Pair	Description
column	Value pair list to specify how to map the form’s data.
connectionstring	ODBC 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	List to specify how to map the repeating group’s data.
lineitemimportkey	Specifies 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.

Example

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

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
lineitems – //my:Details
table – PurchaseRequest