Process Form Data Plug-in

The Process Form Data plug-in enables you to extract data from a form and write it to a file for further processing; you can also opt instead to move part or all of the data into a database. This plug-in supports OLEDB and ODBC connections.

Properties

Name	Description	Mandatory
xpath	Name of the form field from which data need to be extracted.	No
type	The type of data. Supported values are string, long, datetime and double.	No
file	Describes the location of a file which to which the data will will be extracted. It must be the full file path from the server file system. Example: Direct value: D:\Files\Public\Users\Daily-Records.xml	No
connectionname	The ODBC/OLEDB connection name to the database. It shows a list of all the OLEDB and ODBC connections defined at the global or current app level in a drop-down list.	Yes
query	Query is run on the database with the form data. Example: Direct value : insert into TimeOff (processid, requestor) values (@svprocessid, @svformvalue)	Yes

Example 1: Optional XPath and File Values

• file – c:\expense data\[$Process.Id].xml
• xpath – Field_1

This example extracts the value at Field_1 and stores it in a file where the name of the file is the ID of the process running.

Example 2: Optional XPath and File Values

• connectionstring – ODBCConnection1
• file – c:\time off data\timeoff-[$Process.Id].xml
• query – insert into TimeOff (processid, requestor) values (@svprocessid, @svformvalue)"
• xpath – Field_1

This example extracts the value at Field_1, stores it in the file noted, and updates the database’s TimeOff table with the value extracted.