Export Form Data to Database Plug-in

Use the Export Form Data plug-in with a database that supports ODBC and OLEDB connections.

Properties


Name	Description	Mandatory	Group Name	Modes
connectionstring	The ODBC/OLEDB connection name to the database. Includes a drop-down list of all the OLEDB and ODBC connections defined at the global level or current app level.	Yes	Connection Details	NA
table	The name of the destination table to which form field data is exported. Example: Direct value: TableName	Yes	Form Data	NA
column	The value pair list specifying how to map the form’s data. Example: Direct value: dbCol1=[//my:field1],dbCol2=[//my:field2]	Yes	Form Data	NA
lineitemtable	The name of the destination table to which a form’s repeating group data is exported. Example: Direct value: lineItemTableName	No	Form Table Data	NA
lineitem	The name of the repeating element to be exported. Includes a drop-down list of the repeating element names on the form.	No	Form Table Data	NA
lineitemcolumn	The list specifying 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	Form Table Data	NA
lineitemimportkey	Specifies a form field which is stored in a line item column. Example: Direct value: dbCol1=[//my:myFields/my:Ordernumber]	No	Form Table Data	NA

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