Help Center>Foundation Help

Applies to:

  • Winshuttle Foundation

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