...
Info |
---|
Use this page to find example workflows for Aura Digital Workforce. |
Multiexcerpt fast include block macro |
---|
name | Introduction |
---|
templateData | [] |
---|
page | How to Article - Include Page Stuff |
---|
addpanel | false |
---|
|
Multiexcerpt fast include block macro |
---|
name | Video |
---|
templateData | [] |
---|
page | How to Article - Include Page Stuff |
---|
addpanel | false |
---|
|
Multiexcerpt fast include block macro |
---|
name | Script |
---|
templateData | [] |
---|
page | How to Article - Include Page Stuff |
---|
addpanel | false |
---|
|
...
Script
This example will loop through a folder called ‘Test Data’“Test Data”. This folder is in My Documents\Digital Workforce\Aura Genta Digital Worker\Assets\. This folder is automatically checked for paths you reference in AuraGenta. Aura Genta will then loop through each Excel file found in this folder, 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. Rest assured that Aura Genta can handle this easily!
Code Block |
---|
//This folder is in My Documents\Digital Workforce\AuraGenta Digital Worker\Assets\.
//This path is used to locate files and folders. or youYou 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,.
//theyThey 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
//You are now finished inputtinginputing values. Swith to Excel applicationor orthe file to update a value.
switch to $excelFile
Set value "Is Completed" as "Yes"
}
//This will send the result back to the user to open once workflow automation is complete.
//You could also use the "Copy" or "Move" commandcommands to copy files to another location.
//The files are stored on AuraGenta Worker if.
needed
Add Result $excelFile
}
//This command below will send the results stored onto theGenta AuraDesktop.
Desktop
//Once completecompleted, look for a button labeled 'Open Results'.
Send Results to Genta Desktop |
...
...
Resources
...
Include Page |
---|
| Snippet - How-to Foot - Aria |
---|
| Snippet - How-to Foot - Aria |
---|
|
...
Related Articles
...
Filter by label (Content by label) |
---|
showLabels | false |
---|
max | 10 |
---|
showSpace | false |
---|
cql | label 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 - Footer - Tech |
---|
| Snippet - Footer - Tech |
---|
|