When i'm trying to automate excel data from orchestrator its showing error?

Learning Initatives Naan Mudhalvan Program
1

Hi All,

Actually My Motto is to automate excel data into rpachallenge.com.I’ve stored excel data in Queue name(RPAChallenge). But when i’m trying automate it showing error like this.

Screenshot 2024-08-21 154140
Screenshot 2024-08-21 1541401378×523 70.4 KB

Thanks & Regards
Jagadeesh

2

@jagadeesh,

Check what’s the data type of the LastName variable. It must be a string type.

Thanks,
Ashok :slight_smile:

3

Hie @jagadeesh i think it having some space inside the Last Name column Header thats why it throwing error after .tostring add trim function also like this .tostring.trim
try it and let me know …
write your code like this
image

4

Hi ashokkkarale,

The variable type of the “lastname” was in string.

Regards
Jagadeesh

5

Screenshot 2024-08-21 171833
Screenshot 2024-08-21 1718331258×462 79.6 KB

Regards
Jagadeesh

6

@jagadeesh,

Please share the screenshot of the assign activity what you are assigning and how.

If possible share the project xaml to analyze.

Thanks,
Ashok :slight_smile:

7

Hi @jagadeesh

Can you try to update UiPath.System.Activities Package
Show us the variables panel

Regards,

9

Hey @jagadeesh its throwing error because while you add the data into the Queue… the column Last Name include space in the last . write as i share with you now it work for you as well

The image shows a UiPath Studio interface with an open Expression Editor window for a "Write Line" activity, which is set to display the trimmed "Last Name" from the variable currentQueueItem's SpecificContent. (Captioned by AI)
The image shows a UiPath Studio interface with an open Expression Editor window for a "Write Line" activity, which is set to display the trimmed "Last Name" from the variable currentQueueItem's SpecificContent. (Captioned by AI)1366×688 59.1 KB

currentQueueItem.SpecificContent("Last Name ").ToString.Trim

10

1
1817×634 39 KB

2
2721×604 49.4 KB

3
31288×685 55.3 KB

The image depicts an automation workflow for filling a web form with address, email, and phone number fields, followed by clicking a submit button. (Captioned by AI)
The image depicts an automation workflow for filling a web form with address, email, and phone number fields, followed by clicking a submit button. (Captioned by AI)682×643 34.7 KB

Regards
Jagadeesh

11

challenge.xlsx (33.3 KB)

Regards
Jagadeesh

12

Hi Irterala

I’ve updated the UiPath.system.activities package. then i’ve runed the program then also it showing the same error.

Regards
Jagadeesh

13

@jagadeesh,

You will not be getting Specific content with Get Queue Items activity. It will return you null Specific Content.

Why is it so?
It’s big topic to explain it. Refer my blog on this here: Troubleshooting Guide: UuPath SpecificContent NULL

Best practice:

If you have to use Queue, you should be using ReFramework. Get Queue Items activity isn’t the right way to process the transactions.

Still if you want to use custom workflow, use Get Transaction Item activity. This will give you one transaction at a time which is in New state only.

After this use one If activity to check if Transactionitem isnot nothing this will hppen when there is no new state QueueItems.

Still got any question? feel free to connect.

Thanks,
Ashok :slight_smile:

14

RPAChallenge.zip (2.5 MB)

@jagadeesh

Here is sample code

1 Like
15

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