Hi Mukesh, can you please answer this for me? I understand it would be a long answer but if you can type it for me step by step how this multibot will work for this scenerio, It would be really helpful Q) Suppose I have a requirement where I need a data which is from a excel application. I need to read those data, lacks of records are there for processing daily for a bot. Requirement is, bot has to read the file, get all these data. There are 2 applications; one is SAP and one is web-based application. I need to fill in all these details into these 2 applications. Once the details are filled I need to get the item and update the status . Once all the transaction are completed I need to send a single transaction report. How would you design this? Requirement is records which are there for the days should get processed in that particular day.
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 '
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
Please make one video on Dynamic Selector with the help of for each loop
Have a look at this - we are using selector and Find children in a loop
ruclips.net/video/yTiti6vTTko/видео.html
Pls make a complete playlist on Communication Mining.
Thanks for the suggestion
Are u providing jobs on rpa uipath?
No , I am not a Job provider
@@MukeshKala ok sir, Thankyou.
Hi Mukesh, can you please answer this for me? I understand it would be a long answer but if you can type it for me step by step how this multibot will work for this scenerio, It would be really helpful
Q) Suppose I have a requirement where I need a data which is from a excel application. I need to read those data, lacks of records are there for processing daily for a bot. Requirement is, bot has to read the file, get all these data. There are 2 applications; one is SAP and one is web-based application. I need to fill in all these details into these 2 applications. Once the details are filled I need to get the item and update the status . Once all the transaction are completed I need to send a single transaction report. How would you design this? Requirement is records which are there for the days should get processed in that particular day.
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 😊
Hi sir
Can you make a mock interview for canadian companies
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
Jaldi se comment kar deta hun..
😅