Help Center>Foundation Help

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.