Tag: SelectFromFile  FilterFromFile


</SelectFromFile>
XML
</FilterFromFile>
XML

Tag Attributes

AttributesAttribute ValuesValue DescriptionComment
FilePathN/AUniquely identifies the grid (grid code name)N/A
HasHeadersN/AName of the list to use as a source of value to match row toN/A
AndTrue/False (Defaults to False)This is only relevant to SelectFromFileN/A

Detailed Description

For each filter / selection value, both actions require one SetParam action with:

  • Field = grid columnID
  • Value = column rank in CSV / Excel file

Example (Users module in sapio365): 

  • name,weight in kg,age,type,job title,city,continent
  • George,199,68,Member,engineer,Cairo,Africa
  • Michele,29,51,Guest,Consultant,Tulsa,'Murica
  • Rodolf,77,31,Member,engineer,Redmond,Atlantis

Example Script

SelectFromFile

<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>
XML


FilterFromFile

<ytriaAutomation>
	<FilterFromFile FilePath="C:\dev\Temp_XML\selectFromFile.csv" HasHeaders="True">
		<SetParam field="userType" value="3"/>
		<SetParam field="city" value="5"/>
	</FilterFromFile>
</ytriaAutomation>
XML


Column rank in file starts at 0.