Export Form Data to ODBC

Back to

Related topics

Looking for Winshuttle Composer Plugins?

The Export Form Data to ODBC plug-in 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