Process Form Data

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

Value Pair	Description
connectionstring	OLE DB connection string to a database.
query	Query to run on the database with the form data.
type	The type of data. Supported values are string, long, datetime, and double.
Optional Value Pair	Description
file	Name of the file.
xpath	xpath to query.

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.