You're welcome!

Awesome, glad you found it helpful!

You are welcome! 😄

Have a look at this - we are using selector and Find children in a loop kzbin.info/www/bejne/r4XMpZxsq7mHodE

Some steps to follow : Ensure the correct `ServerName\InstanceName` is used in the connection string. Check SQL Server settings in SSMS to ensure "Allow remote connections" is enabled. Confirm the SQL Server Browser Service is running and set to Automatic. Use SQL Server Configuration Manager to enable TCP/IP and Named Pipes for the instance. Allow inbound traffic on port 1433 (default) or the dynamic port used by the named instance.

I don’t have any paid courses currently, but my content is free for everyone to learn on KZbin , we have all the materials uploaded on KZbin

In the asset you have a setting to add value per robot / user so you can use that … with this you can have same asset and 2 values … these values are robot specific

Thank you so much for the explanation

Great job 👏

Sharing a vide0 : Here we are downloading studio and setting up an unattended licence kzbin.info/www/bejne/bHjVqWiQat6Ve8U

You need to restart the assistant after its enabled and make sure in the automation ops - all conditions are satisfied

Superb !

Thanks for the suggestion

No , I am not a Job provider

@@MukeshKala ok sir, Thankyou.

Technically all the questions and comfort us would be same for any company working with rpa - for Canadian companies , are you aware what additional they ask - happy to cover those

Great! 👍

No, I don't - whatever jobs i get from m connections are shared on my instagram

The CRM is an exe and unfortunately i cannot share the exe file - It is from the uipath academy lessons

Good Question : Let me try to explain The process begins in the Input Layer, where the bot reads the data from an Excel file stored in a shared folder, email attachment, or database. Using the `Read Range` activity, the bot loads the data into a DataTable and validates each record to ensure completeness. Valid records are then added as separate transaction items to an Orchestrator Queue, which facilitates parallel processing, ensures fault tolerance, and tracks transaction statuses. The Process Layer forms the core of the solution and handles transaction processing through the Process.xaml file of the REFramework. For each transaction, the bot interacts with two systems: SAP and a web-based application. SAP automation is performed using UiPath’s SAP-specific activities to ensure seamless data entry, while web-based application interactions are automated using browser-based tools or APIs for efficiency. Both steps include validation to ensure successful data submission. Upon completing the data entry for both applications, the bot updates the transaction status in the Orchestrator queue and records the results, such as confirmation numbers or error messages, in a summary DataTable or directly in the source Excel file. At the end of the workflow, the bot retrieves all transaction statuses (Success, Failed, or Retry) from the Orchestrator queue and creates a comprehensive report in Excel or CSV format. This report includes key metrics such as the total number of records processed, success count, and failure count with error details. The report is then sent to stakeholders via email using the `Send Outlook Mail Message` activity or equivalent, ensuring visibility into the automation’s performance. The architecture supports scalability by enabling multiple bots to process transactions concurrently from the Orchestrator queue Retry mechanisms and logging are implemented for transient issues, ensuring that failed transactions are retried appropriately or logged for manual review.

@@MukeshKala Thank you so much for your long and detailed solutions. So, 1) Does the performer bot fill in details in SAP and Web applications ? 2) please correct me if I am wrong. So there will be 2 bots (Dispatcher and performer) that will get used. Which bot will send the consolidated email? And in which state of Re framework it will send? 3) As we are dealing with multibot here, can we directly send the final email using send outlook? Or for multi bot we need to create a locking mechanism to send the email? Sorry for bothering you much with my questions. I just wanted to have a clear understanding of concepts. And Thank you so much as always.

@@abhimansahoo2211 Yes, the Performer bot is responsible for processing individual transactions The performer can send the report only when all transactions are completed or we can have a separate robot only made for reporting Queues make sure that transactions are not locked so you can use any email app to send final email '

@@MukeshKala Thank you so much and I truly respect your time and effort. You are always my goto person 😊

Run in Debug mode and validate the extractions - it might have been classified incorrectly

Most welcome!

Can you try restarting the SSMS Service ?

You're welcome!

😅

Its not possible in Community version. You need to have an enterprise licence for that

Yeah !

Good Score

Thanks

You can create a new account and use the trial wisely :)

Great Progress

2023.4

Hoping to see you compete the project

@MukeshKala I was suppose to do this long back ..lekin aaaj toh me complete kar k hi khana khaunga

Glad this helped

Yes , you need unattended licences

That is your automation logic - once the items are processed you can move them to different folder from inbox or mark the item as read … to change which folder to read - you can edit the configuration

@@MukeshKala by default Integration service checking inbox, and every 5 mins polling it is checking and running the bot, but I will give that logic, so it will not process further when it Mark as read, but question is, bot will be triggered right?? It will process or not be based on logic but it will trigger the bot.? By default Integration service checking inbox, or we can set which folder integration service look for..bcs I can have different folder for different purposes.

Great 👍

Great to hear it was helpful!

UiPath Orchestrator kzbin.info/aero/PLEYSwx3duQ2D2nZE1xzuwSh02cHCsWyzp You can also check my detailed orchestrator course on udemy www.udemy.com/course/fundamentals-of-uipath-orchestrator/?couponCode=24T3MT120924

@@MukeshKala Thanks alot ! :)

Nice 😊

forum.uipath.com/t/convert-from-studio-x-to-studio/712038/7

Great Job!

I haven’t but I will add to my watch list 🙋‍♂️

Glad to hear that

Provide the access to the automation , make sure that file and folder is not read only and run uipath as admin

@MukeshKala it's not in read only,but facing same issue

@ try with file in some other folder

Re check the credentials and make sure that you are not behind firewall

Great! Let's get you automating!

Do you provide training online in Hindi?

Yes absolutely - Here is the video 15. How to Use Pick and Pick Branch Activity in UiPath | UI Synchronization Activities | RPA kzbin.info/www/bejne/i4G8qq2Vf6Z8irM

Yes