Menu
▾
▴
StepType_Data
Data
Calling Data in a Step Sequence allows you to create parameters from a row of data in a datasheet
How each column is used:
| Column Name | Value |
|---|---|
| iID | The ID used to uniquely identify the current Step Sequence |
| iSeq | Optional/Purely cosmetic, only used to help you structure you step sequences |
| cStepType | Data |
| cField | The ID used to uniquely identify the row of data in the datasheet |
| cValue | The name of the data sheet containing the data to save as parameters |
| cTiming | The path to the folder containing the data sheet that contains the data |
| cExpect | Not Used |
| cOnError | Not Used |
Example usage:
In this example Business Process 13 is adding a person in the application, this could be adding a student in a School Database or a new customer in a retail sales system.
Given the following datasheet that is stored at \TestingServer\TestingShare\DataSheets\BP13Data.tsv
| iID | GivenName | Surname | DateOfBirth |
|---|---|---|---|
| BP13Case001 | Tom | Jackson | 2010-08-08 |
| BP13Case002 | Megawatikesuma | 2001-06-18 | |
| BP13Case003 | Franklin | ||
| BP13Case004 | 震嶽 | 張 | 1969-03-29 |
| BP13Case005 | Афанасий | Аминев | 1945-10-01 |
| iID | iSeq | cStepType | cField | cValue | cTiming | cExpect | cOnError |
|---|---|---|---|---|---|---|---|
| Seq001 | 1 | Data | BP13Case001 | BP13Data | \TestingServer\TestingShare\DataSheets |
When the data step is called in this example 4 parameters are created as follows:
| Parameter Name | Value |
|---|---|
| iID | BP13Case001 |
| GivenName | Tom |
| Surname | Jackson |
| DateOfBirth | 2010-08-08 |
These Parameters can then be used in future steps by placing {} around the parameter name e.g {GivenName}. For more details see the section on [Parameterisation]
