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 to move part or all of the data into a database. It supports OLEDB and ODBC connections.
Properties
|
Name |
Description |
Mandatory |
Group Name | Modes |
|---|---|---|---|---|
|
xpath |
The name of the form field from which data will be extracted. |
No |
Form Data | All |
|
type |
The type of data. Supported values are string, long, datetime and double. |
No |
Extract to | File and Database |
|
file |
Describes the location of a file which to which the data 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 |
Extract to | File, File and Database |
|
connectionname |
The ODBC/OLEDB connection name to the database. It includes a drop-down list of the OLEDB and ODBC connections defined at the global or current app level. |
Yes |
Extract to | File and Database |
|
query |
A query is run on the database with the form data. Example: Direct value : insert into TimeOff (processid, requestor) values (@svprocessid, @svformvalue) |
Yes |
Extract to | File and Database |
Examples: Optional XPath and File Values
Example 1
- 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
- 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.