Applies to:
- Winshuttle Foundation
Process Form Data plugin properties
The Process Form Data plugin 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.