Process Form Data Plug-in Properties

The Process Form Data plug-in allows you to extract form data and write it to a file for further processing, or insert part or all of the data into a database.

Value Pair	Description	Mandatory
connectionname	Connection name to the database. This should be a from Connection defined globally or for that app only. Shows the list of connection names in the drop-down field.	Yes
query	Query to run on the database with the form data.	Yes
type	The type of data. Supported values are string, long, datetime, and double.	No
file	Name of the file.	No
xpath	xpath to Query.	No

Example 1: Optional XPath and File Values

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

This example extracts the value at //my:Amount 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 – "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=form_data;Integrated Security=SSPI,"
• file – c:\time off data\timeoff-[$Process.Id].xml
• query – insert into TimeOff (processid, requestor) values (@svprocessid, @svformvalue)"
• xpath – //my:Requestor

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