Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

multiexcerpt-include-macro

...

nameHeader
templateData[]
pageHow to article - Include Page stuff
addpanelfalse

Info

Use this page to find example workflows for Aura Digital Workforce.

...

Multiexcerpt fast include block macro
nameIntroduction
templateData[]
pageHow to article - Include Page stuff
addpanelfalse

Multiexcerpt fast include block macro
nameVideo
templateData[]
pageHow to article - Include Page stuff
addpanelfalse

Multiexcerpt fast include block macro
nameScript
templateData[]
pageHow to article - Include Page stuff
addpanelfalse

This example will loop through a folder called ‘Test Data’. This folder is in My Documents\Digital Workforce\Aura Digital Worker\Assets\. This folder is automatically checked for paths you reference by Aura. Aura will then loop through each Excel found in this folder, and loop through the rows in each file, and enter the data into the RPA Challenge website. This website has controls that move every time the page is refreshed, but not to worry, Aura can handle this easily!

Code Block
//This folder is in My Documents\Digital Workforce\Aura Digital Worker\Assets\
//This path is used to locate files and folders or you can also specify a full path below
$excelFile = ""
$folder = "Test Data"
$rpasite = "http://www.rpachallenge.com/"
navigate to $rpasite
foreach ($excelFile in $folder)
{
foreach ($row in $excelFile)
{
//Variables in foreach loops are auto generated
//Use inspector to get variable names,
//they will be the column headers without spaces and special characters
switch to $rpasite
Enter $_FirstName as "First Name" -forcedetection
Enter $_LastName as "Last Name"
Enter $_PhoneNumber as "Phone Number"
Enter $_CompanyName as "Company Name"
Enter $_RoleInCompany as "Role in Company"
Enter $_Email as "Email"
Enter $_Address as "Address"
Click "Submit" button
//We are finished inputting values, swith to Excel application/file to update a value
switch to $excelFile
Set value "Is Completed" as "Yes"
}
//This will add the result to be sent back to the user to open once workflow auttomation is complete.
//We could also use copy or move commands to copy files to another location
//The files are stored on Aura Worker if needed
Add Result $excelFile
}
//This command below will send the results stored to the Aura Desktop
//Once complete, look for a button labelled 'Open Results'
Send Results to Desktop

Multiexcerpt fast include block macro
nameResources
templateData[]
pageHow to article - Include Page stuff
addpanelfalse

View file
namechallenge.xlsx

Multiexcerpt fast include block macro
nameRelated Articles
templateData[]
pageHow to article - Include Page stuff
addpanelfalse
Filter by label (Content by label)
showLabelsfalse
max10
showSpacefalse
cqllabel in ( "kb-how-to-article-aria" , "excel" , "loop" , "foreach" , "kb-tech-aria" ) and label in ( "kb-command-reference-aria" , "kb-how-to-article-aria" , "kb-tech-aria" )
Include Page
Snippet - How-to Foot - Aria
Snippet - How-to Foot - Aria
Include Page
Snippet - Footer - Tech
Snippet - Footer - Tech