Hi I want to automate excel data into Rpa challenge website.But when im run the program showing error in the multple activity.Please check attached details below

Learning Initatives Naan Mudhalvan Program
1

Screenshot 2024-08-25 114403
Screenshot 2024-08-25 114403903Ă—349 52.6 KB

the program details please check below screenshots

The image shows a UiPath workflow named "GetQueueData_publish_process_asset_Triggering," which retrieves two assets, reads data from an Excel sheet, and then adds the data to a queue in the Orchestrator. (Captioned by AI)
The image shows a UiPath workflow named "GetQueueData_publish_process_asset_Triggering," which retrieves two assets, reads data from an Excel sheet, and then adds the data to a queue in the Orchestrator. (Captioned by AI)1231Ă—645 28.2 KB

The image shows a sequence of actions in RPA, including bulk adding queue items, opening a browser, getting queue items, and assigning transaction queue item values to variables using UiPath. (Captioned by AI)
The image shows a sequence of actions in RPA, including bulk adding queue items, opening a browser, getting queue items, and assigning transaction queue item values to variables using UiPath. (Captioned by AI)1073Ă—662 30.4 KB

The image shows a sequence of actions in an automation workflow, where information such as first name, last name, and company name is being assigned and entered into corresponding fields. (Captioned by AI)
The image shows a sequence of actions in an automation workflow, where information such as first name, last name, and company name is being assigned and entered into corresponding fields. (Captioned by AI)714Ă—623 29.2 KB

The image shows a workflow for an automated form filling process, including fields for company name, role in company, address, email, and phone number, followed by a submit button. (Captioned by AI)
The image shows a workflow for an automated form filling process, including fields for company name, role in company, address, email, and phone number, followed by a submit button. (Captioned by AI)743Ă—618 22.6 KB

Regards
Jagadeesh

2

@jagadeesh

Use for each data row

and follow the below syntax:

First_name= currentrow(“FirstName”).tostring
Last_name= currentrow(“LastName”).tostring
and so on…

3

You are trying to pass the data from queue since you are reading the input from excel you need to pass from the datatable

4

if you already added the input data to queue than try as below:

  1. Get Transaction Item (output: transactionQueueItem)
  2. Assign fullname:
    If transactionQueueItem.SpecificContent.ContainsKey(“FullName”) Then
    fullname = transactionQueueItem.SpecificContent(“FullName”).ToString()
    Else
    fullname = “Default Name” ’ or handle as needed
    End If
  3. Log Message: fullname
5

Hi
Sir

The image shows the UiPath Expression Editor with a value input that retrieves and converts the "Last Name" from the specific content of a transaction queue item to a string. (Captioned by AI)
The image shows the UiPath Expression Editor with a value input that retrieves and converts the "Last Name" from the specific content of a transaction queue item to a string. (Captioned by AI)815Ă—256 9.13 KB

I 've followed as you say

But showing error

Regards
Jagadeesh

6

Can you please share the photo of the complete work flow ??

7

@jagadeesh,

Get Queue Items doesn’t give you Specific contents anymore.

You will have to use Get Transaction Item.

Thanks,
Ashok :slightly_smiling_face:

8

Please follow the below steps:

1.Read the input excel using read range activity save as dtInput.
2. Use the for each row activity and pass the variable dtinput.
3. Use multi assign activity like in the body section of for each loop
FirstName= currentrow(“FirstName”).tostring
LastName= currentrow(“Lastname”).tostring
and so on
4. then use Add queue item activity:
in properties section of the Add queue item activity i.e (click on collection)then write as below:

An interface defines two input arguments, "in_FirstName" and "in_LastName," both of type String. (Captioned by AI)
An interface defines two input arguments, "in_FirstName" and "in_LastName," both of type String. (Captioned by AI)1596Ă—103 11.2 KB

9

Hi Sir,
I’ve followed what did you says. But it showing eror

getransaction item error
getransaction item error1341Ă—730 33.8 KB

Regards
Jagadeesh

10

Hi Sir,

I don’t now how to share complete workflow.can you please tell me the how to take capture the complete worklow?

Thanks&Regards
Jagadeesh

11

if you are using Re Framework use as below:

in_transactionitem.specificcontent(“FirstName”).tostring and so on

12

Please refer this video:

13

Hi Sir,

Actually I don’t have license to do on RE Frame Work. Present i’m doing on studio only for practice purpose only.

Thanks & Regards
Jagadeesh

14

You dont want any license for that , you can open using the UiPath studio by clicking on REFramework instead of blank process

15

@jagadeesh,

Refer this projects. Make sure you are changing the QueueName and QueueFolder as per your Orchestrator setup. This is to be done for bot dispatcher and performer.

RPAChallenge_Dispatcher.zip (1.2 MB)
RPAChallenge_Performer.zip (2.0 MB)

The image shows an Excel spreadsheet named "Config - Excel," specifically the "Settings" tab, containing a table with "Name," "Value," and "Description" columns filled with some example entries related to an Orchestrator queue configuration. (Captioned by AI)
The image shows an Excel spreadsheet named "Config - Excel," specifically the "Settings" tab, containing a table with "Name," "Value," and "Description" columns filled with some example entries related to an Orchestrator queue configuration. (Captioned by AI)1918Ă—1006 82 KB

This config file is available in this location in bot bots.

The image shows a UiPath project explorer with a file named "Config.xlsx" circled in red within the "Data" folder. (Captioned by AI)
The image shows a UiPath project explorer with a file named "Config.xlsx" circled in red within the "Data" folder. (Captioned by AI)420Ă—781 22.3 KB

After Queuename and foldername change in both project, run Dispatcher first which will add the queue items to Queue then run the Performer project, which will process the queue items one by one.

This two project approach is one of the best practices we follow in UiPath development. Refer this awesome blog for understanding it thoroughly.

Thanks,
Ashok :slight_smile:

1 Like
16

Hi Sir,

Sir can i use RE Frame Work without license?

Thanks & Regards
Jagadeesh

17

Yes you can use it with out license.
Using community version it is free only

1 Like
18

Please refer this:

1 Like
19

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.