Control Architect Help Documentation
×
Menu
Index

Specify Excel DataSource File options

Specify Excel DataSource File options
1

Excel DataSource File: field

1. Excel DataSource File: field
Displays the Excel DataSource file path.  Click the Browse button to select the Excel file to use as the source of the data to use for building or editing Control strategies.
2

Browse: button

2. Browse: button
Click this button to select the Excel file to use as the source of the data to use for building or editing Control strategies.
3

Excel DataSource Worksheet: drop-down

3. Excel DataSource Worksheet: drop-down
Select the Excel Worksheet name to use as the source of the data.
4

Excel Worksheet Data Columns: list

4. Excel Worksheet Data Columns: list
This list contains the Excel data columns that are discovered in the selected Excel Worksheet.  When an Excel Worksheet is selected from the Excel Worksheet drop-down, this list will be populated with data column names discovered in the Worksheet.
 
When your Control Conversion project files are created, this set of source properties is used to create the Control Property Template file.
5

Primary Key: button

5. Primary Key: button
Click this button to specify the selected Excel data column as the source of the data that uniquely identifies the data contained in this Excel Worksheet.  This will typically be the data column that specifies the name of the new Control Strategy or Control Module.
 
There must be a Primary Key defined for a single Excel data column.  Failure to specify a Primary Key will result in your Data Collection execution failing.
6

Primary Key Status: image

6. Primary Key Status: image
This image identifies the Excel data column that uniquely identifies all data contained in the selected Excel Worksheet.  Click the Primary Key button to toggle this status for the selected Excel data column in this list.