Export Form Data to Database Plug-in

Export Form Data to a database that supports ODBC and OLEDB connections.

Properties

Name	Description	Mandatory
connectionstring	ODBC/OLEDB connection name to the database. It includes a list of all the OLEDB and ODBC connections defined at the global level or current app level in a drop-down.	Yes
table	The name of the destination table to which form field data is exported. Example: Direct value: TableName	Yes
column	Value pair list to specify how to map the form’s data. Example: Direct value: dbCol1=[//my:field1],dbCol2=[//my:field2]	Yes
lineitemtable	Name of the destination table to which a form’s repeating group data is exported. Example: Direct value: lineItemTableName	No
lineitem	Name of the repeating element to be exported. This shows all the repeating element names on the form in a drop-down list.	No
lineitemcolumn	List to specify how to map the repeating group’s data. Example: Direct Value: ItemNumber=[my:ItemNumber],ItemDesc=[my:ItemDesc],Qty=[my:ItemQty],UnitPrice=[my:ItemUnitPrice],Total=[my:ItemTotal]	No
lineitemimportkey	Specifies a form field to be stored in a line item column. Example: Direct value: dbCol1=[//my:myFields/my:Ordernumber]	No

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 – connection1
• lineitem – my:Repeating_Table_1
• lineitemcolumn – ItemNumber=[my:ItemNumber],ItemDesc=[my:ItemDesc],Qty=[my:ItemQty],UnitPrice=[my:ItemUnitPrice],Total=[my:ItemTotal]
• lineitemimportkey – PRNumber=[//my:PRNumber]
• lineitemtable – PRLineItem
• table – PurchaseRequest