Version: 22-SP0-25 and onwards
Please note this version now supports the following control types:
Earlier versions of the Specification PowerPack did not export the above control types.
If any of the above controls are in use and this version (or newer) of the PowerPack is installed the exported file will include this information.
This Specification Flow Task recurses all the Forms in a Project and all of the Controls within each form.
The following information is exported:
The name of the form the control exists on.
The name of the control.
The type of the control (for example CheckBox, TextBox, etc.).
Each control type is prefixed with DriveWorks.Forms.
The value at the time of export for each control that supports value export, see below.
Controls that do not support value export will have all other information exported.
The value of the left position on the form.
The value of the top position on the form.
The height value of the control.
The width value of the control.
Microsoft Office
Microsoft Office and DriveWorks Live running as a service through IIS
Services (IIS) do not have access to many applications, especially COM programs such as Microsoft Word and Excel.
When using DriveWorks Live and IIS please read the following articles for information on where to place this Task.
This task will export the current value of the following control types:
All other control types will be exported without the Control Value field being populated.
Control values that span multiple lines will place the value in a single cell in the exported file.
This applies to the following control types:
| Property Name | Description |
|---|---|
| Source File Name | File Name of the source (template) spreadsheet. |
| Target File Name | File Name of the target (new) spreadsheet. |
| Target Sheet Name | The Sheet name in the spreadsheet that will have the data exported to. |
| ShowExcel | Workbook will be visible if set to TRUE. |
| Extension for Saving File | Pipe-bar (|) delimited list of extensions to save the file as (e.g. .pdf, .xps, .txt).
The following extensions are supported for saving the file: .pdf, .xps, .txt, .xml, .htm, .html, .csv, .dif, .slk, .ods, .xlsm, .xlsb, .xls, .xltx, .xltm, .xlt, .xla and .xlam |
When this Task is added the properties are static. To be able to build rules on a static property see How To: Change A Static Property To A Dynamic Property.
| Property Name | Example Rule | Example Result | Meaning |
|---|---|---|---|
| Source File Name | "C:\MyDocuments\Templates\Template.xlsx" | C:\MyDocuments\Templates\Template.xlsx | This is the location where the source (your template) spreadsheet is stored. |
| Target File Name | "C:\MyDocuments\Exports\SpecInfo.xlsx" | C:\MyDocuments\Exports\SpecInfo.xlsx | This is the location where the file will be created. |
| Target Sheet Name | "Sheet1" | Sheet1 | This is the name of the sheet on your exported spreadsheet that the data will be written to. |
| ShowExcel | TRUE | TRUE | TRUE will show the Excel workbook opening when you run the Task. |
| Extension For Saving File | ".CSV" | .CSV | This will produce a CSV file of the exported data that has been exported to Excel. |
| Type | Name | Value |
|---|---|---|
| Text Box Control | TextBox1 | ABC |
| Macro Button | MacroButton1 | |
| Slider Control | Slider1 | 43 |
| Text Box Control | TextBox2 | XYZ |
| Form Name | Control Name | Control Type | Control Value | Left | Top | Height | Width |
|---|---|---|---|---|---|---|---|
| Details | TextBox1 | DriveWorks.Forms.TextBox | ABC | 25 | 50 | 20 | 200 |
| Details | NumericTextBox1 | DriveWorks.Forms.MacroButton | 25 | 100 | 20 | 200 | |
| Details | Slider1 | DriveWorks.Forms.Slider | 43 | 25 | 150 | 20 | 200 |
| Details | TextBox2 | DriveWorks.Forms.TextBox | XYZ | 25 | 200 | 20 | 200 |
This task supports Status Outputs. These can be used to perform different actions depending on what the status outcome of the task is. For more information see Status Outputs in the Task Node Outputs section of Specification Macros Task Node.
The status output navigation is as follows:
Success
Success with Warnings
Failed (one of the following occurred).