Tag: SelectFromFile
Achieve row selection with values found in a CSV file.
XML
</SelectFromFile>
Tag Attributes
|
Attributes |
Attribute Values |
Value Description |
|---|---|---|
|
FilePath |
N/A |
Uniquely identifies the grid (grid code name) |
|
HasHeaders |
N/A |
Name of the list to use as a source of value to match row to |
|
And |
True / False (Defaults to False) |
Restrict or enlarge selection key |
Detailed Description
For each selection value, one SetParam is required with:
-
Field = grid columnID
-
Value = column rank in CSV / Excel file
Example (Users module in sapio365):
|
name (index: 0) |
weight in kg (index: 1) |
age (index: 2) |
type (index: 3) |
job title (index: 4) |
city (index: 5) |
continent (index: 6) |
|---|---|---|---|---|---|---|
|
George |
199 |
68 |
Member |
engineer |
Cairo |
Africa |
|
Rodolf |
77 |
31 |
Member |
engineer |
Redmond |
Atlantis |
|
Michele |
29 |
51 |
Guest |
Consultant |
Tulsa |
North America |
Example Script
SelectFromFile
XML
<ytriaAutomation>
<SelectFromFile FilePath="C:\dev\Temp_XML\selectFromFile.csv" HasHeaders="True" And="true">
<SetParam field="userType" value="3"/>
<SetParam field="city" value="5"/>
</SelectFromFile>
</ytriaAutomation>
