1. UiPath RPA Use Case : Create Card | ReFramework without Orchestrator Queue | With Excel Datatable
ฝัง
- เผยแพร่เมื่อ 26 มิ.ย. 2024
- ► Use Case Name : Create Cards (Id / Visitor Pass / Employee Cards )
► Concept : Re Framework without Queue / Re Framework with Datatable and Excel
👉 We are creating a Robot to Generate Id Cards.
👉 We would be converting the Re Framework to work without Queues.
👉 See a Step by Step Demonstration
This Use case is divided into 2 Parts. This is the Part 1 of the video -
Part 2 Link : • 2. UiPath RPA Use Case...
►►►► To Get the Files ◀◀◀◀◀◀
I have uploaded all the materials to my newly created Website.
👉 Visit Website : mukeshkala.com
👉Go to : Download ► Select the Video ► Download .
👉 Please let me know if you got the Files and drop a Mail - If you face any problem .
►►►►►► This Video covers the Following ◀◀◀◀◀◀◀◀
► Timestamps ◀
0:00 : Introduction
2:00 : Sneak Peak to Automation
4:34 : As is Vs To Be Process
6:44 : Solution Design Approach
8:55 : Demonstrating Files and Folder
10:32 : Templates for generating Id cards
10:55 : Exception Scenarios
12:20 : Division of Videos
13:15 : Start Code
13:29 : Setting to Classic Design
14:05 : Create a new project
17:04 : Config File in Re Framework
18:29 : Init All Settings xaml
19:50 : Kill All Process xaml
22:15 : Getting the Process Name
23:29 : Max Consecutive System Exceptions
24:55 : Init All Applications Workflow
30:10 : Understanding the Transactions
31:20 : Read the complete Transaction Data
34:31 : Create Sequence for reading Inputs
38:32 : Exception Handling in reading Data
43:44 : Pass Data from Init to get Transaction Data
58:26 : Pass Data from Init to get Transaction Data
1:00:43 : Get DataRow One by One from DataTable
1:17:55 : Test to validate transaction Items
1:27:06 : Recap and Next Steps
►►►►►► Changes : Convert RE Framework to Work Without Queues ◀◀◀◀◀◀◀◀
Change 1 : 54:01 - Change the transaction Item
Change 2 : 55:19 - Disable the get Transaction Item
Change 3 : 55:48 - Update Transaction Item
Change 4 : 1:00:43 - Update Out_TransactionItem
Change 5 : 1:13:53 - Update Transaction Item in Process xaml
Change 6 : 1:15:12 - Update Transaction Item in Set Transaction Status xaml
Change 7 : 1:15:35 - Disable Set Transaction Status - Success
Change 8 : 1:15:46 - Disable Set Transaction Status - Business Exception
Change 9 : 1:16:11 - Disable Set Transaction Status - System Exception
►►►►►► Links to Refer ◀◀◀◀◀◀◀◀
👉👉 RE Framework Complete Playlist
• Robotic Enterprise Fr...
👉👉 UiPath Exception Handling Playlist
• UiPath - Exception Han...
👉👉 HR UseCase | Generate Offer Letters - PART1| RE Framework| Dispatcher |
• PART 1 - UiPath | HR U...
👉👉 HR UseCase | Generate Offer Letters - PART2 | REFramework | Performer |
• PART 2 - UiPath | HR U...
👉👉 Arguments in UiPath | Pass Data across xaml
• 🔴 5. LIVE | Arguments...
Happy Automation!
►►►►►► Social Media Links ◀◀◀◀◀◀◀◀
👉 Instagram : / uipathtutorials
👉 LinkedIn : / mukeshkala
👉 Twitter : / tweetmukeshkala
👉 Facebook: / uipathfb
👉 TH-cam : / tutorialsbymukeshkala
👉 Mail : mailmukeshkala@gmail.com
#UiPath #RPA #Automation #mukeshkala #Discover #UiPathCommunity
►►►►►► Tags ◀◀◀◀◀◀◀◀
Tutorials by Mukesh Kala
UiPath Tutorials by Mukesh Kala
uipath
mukesh kala
uipath tutorial
uipath projects
rpa tutorial for beginners
uipath tutorial for beginners
rpa interview questions and answers
rpa projects
ui path
uipath rpa
rpa uipath tutorial
UiPath RPA use Cases
Re Framework without Orchestrator
Re Framework with DataTables
Re Framework UiPath Example
UiPath RPA Tutorial for Beginners
Re Framework Without Queue
Re Framework Without Orchestrator
Re Framework With Excel
Re Framework With DataTable
UiPath Re Framework Without Orchestrator
►►►► To Get the Files ◀◀◀◀◀◀
I have uploaded all the materials to my newly created Website.
👉 Visit Website : mukeshkala.com
👉Go to : Download ► Select the Video ► Download .
👉 Please let me know if you got the Files and drop a Mail - If you face any problem .
Thanks Mukesh ..you are really awesome.
Thanks for sharing the feedback
Great Video Mukesh Kala, Very Useful Use case , thanks for sharing your knowledge
Thanks and welcome
👉👉 RE Framework Complete Playlist
th-cam.com/play/PLEYSwx3duQ2BoRamKrEQ6qrZvrL-mAm7p.html
No words for you sir.... It's just outstanding.... Your concept your way of teaching.. Every thing....... 💐
Thanks a ton
Very good explanation and very helpful as you taken a use case and explained it completely from PDD, SDD to execution. Thank you
Glad it was Helpful
Hi Mukesh been followling your videos for a quiet long time you are doing an amazing job with the videos👍🏻👌🏻🙂
Thanks a ton
Fantastic Explanation. Keep Rocking
Thanks Bro , Appreciate the feedback
Great video Mukesh, explained very clearly. Request to you please make the videos , How to used APIs etc...
Thank you 🙏 , I will make and share
amazing work done sir..thank u
Appreciate the feedback 😊
Thank you so much sir for such a great explanation, It help us a lot to understand RE framework, You make it so simple
Please add more Use cases like this
Yes I will , thank you
It... Just amazing and interesting too
Thank you😀
👍
Thank you so much sir.
Glad it was helpful 🙏
Good explanation :)
Thanks! 😃
please put the input files link, so that, i will reach more people especially uipath aspirants who wants to get hands-on
thank you for ur clear explanation
Sent you the files over email
awesome Tutorial.
Thank you 🙏
great video mukesh..explained very clearly..can u send the input files for practice..
Hello Rajeev, If You could drop me a note on my mailid available in description , I shall forward the Files - Thank you for Feedback.
A quick Question time stamp 1:02:32, here the count starts from 0 , does it consoder Headers as 0 or it takes the only data except headers
The Data in the Datatable starts with index 0 excluding the Header
Great Learning sir. Can you share the files for my understanding.
Drop me a note on my mailId available in description
Hello Sir , I don't have Excel in my desktop , and when i run the project , it's giving an error like this "
The error message "Error opening workbook. If Excel is installed, run the 'Repair Tool for Microsoft Office Interop' from the Tools tab on the Home screen" typically occurs when there is an issue with the Excel installation or the Microsoft Office Interop libraries used by UiPath to interact with Excel." , Please tell me how i will do this.
In case you don't have excel installed - use the workbook activities ... Sharing the reference video : th-cam.com/video/qhqBjjZmxpc/w-d-xo.htmlsi=-ISyQi2j3-HzGOZj
Hello, I dont understand your explains. Why index 15 equals transactionitem(14) ?
Index start from zero
Index 0 = Item 1
Index 1 = Item 2
Index 2 = Item 3 and so on
Sir I have questions when I write data in excel there are random popup message and don’t know which position it will come so please guide me how to resolve this type of task
Take Parallel Activity -
Handle the pop up one side and actual automation in other side
Sir can we have a video on word automation from base level ,covering all word activities and application of word automation in real life cases
Hello , I have started it - Sharing the Link for refence - will keep adding to the playlist.
th-cam.com/play/PLEYSwx3duQ2ADWdLg0lleegs02ogrsVKK.html
@@MukeshKala Yes sir Thank you for the reply. Ya I already saw that videos . I was saying to do more videos on word ,if possible do a single video as done for files and folder .I found files and folder explanation Vedio very helpful for me.Your videos and way of explanation is very good I just wanted to explore more about word automation
Noted , Will Add More to playlist
@@MukeshKala Thank you sir
Thank you for your clear explanation. Please send me the input files
If you could pls drop me a note on my mail id available in description... I shall forward the files to you
Mukesh, In SetTransactionStatus.xaml, we disabled the "If TransactionItem is a QueueItem" sequence and used "write cell" activity for updating transaction status in excel file for success, BE and SE.
And my doubt is that why we are disabling it, instead of removing it. I don't see any reason. I think it works fine.
Anyways disabling it won’t execute it … so we can delete it as well
@@MukeshKala yeah that's my point. We don't use it so we can delete it.
@@girishkrishna4654 Yes
1:26:53
Mukesh, when i debug the automation writeline activity was successful but the value not printed in the output panel. But when i ran the automation, writeline activiy value got printed in output.
Why it didn't print during debug?
That SHould not Happen , Only way to find this out is to run in debug mode and see what value is getting passed to the writeline./
@@MukeshKala value passed correctly, i checked it in local panel.
But that value was not printed in output. I even used breakpoint to that activity and checked. Nothing happened.
Try using log message activity
@@MukeshKala ok
I don't have word application, what other option replace pic I can use?
You can use any online Doc Editor - such as Google Doc or any other editor .. but that you need to first integrate with UiPath
25:28, Mukesh, what are SAP?
SAP stands for System Applications and Products in Data Processing. SAP is the market leader in ERP software and helps companies of all sizes. It is widely used in companies as ERP (Enterprise resource planning ) type of software that organizations use to manage day-to-day business activities such as accounting, procurement etc.
in get transactionitems workflow i was getting if condition error like "If: Object reference not set to an instance of an object." these one please help to solve it sir
Your Transaction Item is Null
@@MukeshKala how can I sort this error sir I was set transaction data also but given same error
@@bhuvanagiripavangurukalyan8909 This error simply means that the robot has nothing to process , There can be many reasons for that - The excel file is not read properly / there are no new items / the DT variable is losing the values anything ... You need to run the automation in debug mode and then analyse the code - Also for reference i have shared the code on my website - you can downlaod and compare with yours
@@MukeshKala yes sir ai was cross checked the code also but still in get transaction data workflow retryscope was getting same error object reference is not set to an instance of an object getting same error
@@bhuvanagiripavangurukalyan8909 Run in debug mode and see if the Trnsaction data is correctly flowing from Init section and it should not be null
how can i get the data that you used in this case Mukesh ?
Hey ,
Thank you for your comment ..
I have uploaded all the materials to my newly created Website.
Website : mukeshkala.com
Go to : Download >> Select the Video >> Download .
Please let me know if you got the Files and revert If you face any problem .
Would Appreciate your feedback on the website as well.
hi bro , uipath la how to use python bro and i need any mini project
rpabotsworld.com/python-integration-with-uipath/
Can you please share the practice files
Please Drop me a note on my mailid available in description and I shall forward the files
1:03:22 index value is 15 NOT 14
Yes , I said it wrong and that’s why put the caption in video at the same time .. Thank you for sharing 🙋
Hello Sir, in my project have to insert multiple images and their respective headers into Outlook body not as mail attached but as an displaying image. I'm not able to embed screenshot. Requesting to kindly do video on it!!!
forum.uipath.com/t/send-an-image-in-body-of-an-email/325333/3 - See this Thread
I already saw this video and performed accordingly but not working. My bot code is inside the VDI, when I gave image path inside Outlook body as HTML but out of VDI Outlook I am getting 'x' mark and when I gave image path inside send Outlook add files they are reflecting as attachments. Kindly help me
Sir, can you help me by making video on convert base64 image this sends image mails successful out of VDI, and your videos will be clear, smoth & easy to understand complexity so!!!!!
@@chethanchintumj4162 The Behavior is correct , the Image path would be not available outside hence you are getting that X mark - To make it work , upload the image in some remote path , such as a drive / SharePoint / cloud with access as public , so that the image is available to the receiver.
@@chethanchintumj4162 I have limited access to VDI - Will try
Can you please share the practice file?.
Hello , if you could please drop me a note on my mailid available in description , I shall forward you the files
Hi Sir
Can you send me the Input File
Hey 🙋♂️ , Thank you for reaching out …... I have uploaded all the materials to my newly created Website……. 🌎 Website : mukeshkala.com 🔴Go to : Download >> Select the Video >> Download . 🙂 Please let me know if you got the Files and revert If you face any problem . ….. 😇 Would Appreciate your feedback on the website as well
Hi, Could you please send me the input files over my email. Thank you
Sure , Please drop me a note on mailid which is available in Description and I shall revert with the code and the files
Hello Sir, Can you please send me the input files to my mail,Thank you
All the files are now uploaded in my website - Sharing the Download Page - Go to the Video and select Download.
mukeshkala.com/videos-download/
Let me know you feedback on the website :)
@@MukeshKala thank you sooo much
Hope you were able to get the files 👍
@@MukeshKala yes i find all the files and i have done the project also...explanation of the video is also very nice...
please make more re framework projects for practise..
Thankyou
Sure I will
Hi, Could you please send me the input files to my mail,Thank you
Sure , please send me an mail on my mail id available in description