...
-macro |
---|
name | How to Article Header |
---|
templateData | [] |
---|
page | How to Article - Include Page Stuff |
---|
addpanel | false |
---|
|
Info |
---|
Use this page to find example workflows for Aura Digital WorkforceGenta Automation. |
...
Script
This example will prompt the user for an Excel file. Then loop through a folder called “Test Data”. This folder is in My Documents\Digital Workforce\Genta Digital Worker\Assets\. This folder is automatically checked for paths you reference in Genta. Genta will then loop through each Excel file found in this folder, loop through the rows in each file, and enter them into a the data into the RPA Challenge website. This website has controls that move every time the page is refreshed, but not to worry, Aura . Rest assured that 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. orYou 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.
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
//WeYou are now finished inputtinginputing values,. swithSwith to Excel or application/the file to update a value.
switch to $excelFile
Set value "Is Completed" as "Yes"
}
//This will addsend the result to be sent back to the user to open once workflow auttomationautomation is complete.
//WeYou could also use the copy"Copy" or move"Move" commands 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 to Genta Desktop.
//Once completed, 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 - How-to Foot - Aria | Snippet - How-to Foot - Aria |
|
Include Page |
---|
| Snippet - Footer - Tech |
---|
| Snippet - Footer - Tech |
---|
|