1. UiPath RPA Use Case : Create Card | ReFramework without Orchestrator Queue | With Excel Datatable

► 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 : kzbin.info/www/bejne/aZO8knZjas1leZo
►►►► 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
kzbin.info/aero/PLEYSwx3duQ2BoRamKrEQ6qrZvrL-mAm7p
👉👉 UiPath Exception Handling Playlist
kzbin.info/aero/PLEYSwx3duQ2DGsE2Up1DPLAxsJ_3F8Jzo
👉👉 HR UseCase | Generate Offer Letters - PART1| RE Framework| Dispatcher |
kzbin.info/www/bejne/oGmodpSXgcZ5ipY
👉👉 HR UseCase | Generate Offer Letters - PART2 | REFramework | Performer |
kzbin.info/www/bejne/i2jQhWN8bJmbqNE
👉👉 Arguments in UiPath | Pass Data across xaml
kzbin.info/www/bejne/oWWpZWyqjLCIirc
Happy Automation!
►►►►►► Social Media Links ◀◀◀◀◀◀◀◀
👉 Instagram : uipathtutorials
👉 LinkedIn : www.linkedin.com/in/mukeshkala/
👉 Twitter : tweetmukeshkala
👉 Facebook: UiPathFB/
👉 KZbin : kzbin.info
👉 Mail : [e-mail]
#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

[@MukeshKala]

►►►► 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 .

[@botsDNA]

Great Video Mukesh Kala, Very Useful Use case , thanks for sharing your knowledge

[@MukeshKala]

Thanks and welcome

[@keerthishanmukh3485]

Very good explanation and very helpful as you taken a use case and explained it completely from PDD, SDD to execution. Thank you

[@MukeshKala]

Glad it was Helpful

[@funedit732]

No words for you sir.... It's just outstanding.... Your concept your way of teaching.. Every thing....... 💐

[@MukeshKala]

Thanks a ton

[@taurean.abhishek]

Hi Mukesh been followling your videos for a quiet long time you are doing an amazing job with the videos👍🏻👌🏻🙂

[@MukeshKala]

Thanks a ton

[@rameshwarrathod920]

Great video Mukesh, explained very clearly. Request to you please make the videos , How to used APIs etc...

[@MukeshKala]

Thank you 🙏 , I will make and share

[@ajinkyajorwekar3349]

Thank you so much sir for such a great explanation, It help us a lot to understand RE framework, You make it so simple

[@ajinkyajorwekar3349]

Please add more Use cases like this

[@MukeshKala]

Yes I will , thank you

[@narendrababumupparaju2886]

Fantastic Explanation. Keep Rocking

[@MukeshKala]

Thanks Bro , Appreciate the feedback

[@ranjeetasutar6277]

Thanks Mukesh ..you are really awesome.

[@MukeshKala]

Thanks for sharing the feedback

[@SyedSAhmed3]

amazing work done sir..thank u

[@MukeshKala]

Appreciate the feedback 😊

[@TheHomeChronicles]

It... Just amazing and interesting too

[@MukeshKala]

Thank you😀

[@mamathaj4850]

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

[@MukeshKala]

Sent you the files over email

[@rajeevengile2980]

great video mukesh..explained very clearly..can u send the input files for practice..

[@MukeshKala]

Hello Rajeev, If You could drop me a note on my mailid available in description , I shall forward the Files - Thank you for Feedback.

[@SyedAli-iq4ku]

Thank you so much sir.

[@MukeshKala]

Glad it was helpful 🙏

[@vishnuprasad9619]

👍

[@vikrampurohit3033]

Good explanation :)

[@MukeshKala]

Thanks! 😃

[@rpa6646]

awesome Tutorial.

[@MukeshKala]

Thank you 🙏

[@PatilHarshadMtech]

Great Learning sir. Can you share the files for my understanding.

[@MukeshKala]

Drop me a note on my mailId available in description

[@shivanigupta3184]

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.

[@MukeshKala]

In case you don't have excel installed - use the workbook activities ... Sharing the reference video : kzbin.info/www/bejne/p5nUc52gj9KrpsUsi=-ISyQi2j3-HzGOZj

[@Ye_3timepagal]

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

[@MukeshKala]

The Data in the Datatable starts with index 0 excluding the Header

[@girishkrishna4654]

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.

[@MukeshKala]

Anyways disabling it won’t execute it … so we can delete it as well

[@girishkrishna4654]

@@MukeshKala yeah that's my point. We don't use it so we can delete it.

[@MukeshKala]

@@girishkrishna4654 Yes

[@user-rh8py5ce1j]

Hello, I dont understand your explains. Why index 15 equals transactionitem(14) ?

[@MukeshKala]

Index start from zero Index 0 = Item 1 Index 1 = Item 2 Index 2 = Item 3 and so on

[@ankitsingh3572]

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

[@MukeshKala]

Take Parallel Activity - Handle the pop up one side and actual automation in other side

[@poojasuchithran3470]

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

[@MukeshKala]

Hello , I have started it - Sharing the Link for refence - will keep adding to the playlist. kzbin.info/aero/PLEYSwx3duQ2ADWdLg0lleegs02ogrsVKK

[@poojasuchithran3470]

@@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

[@MukeshKala]

Noted , Will Add More to playlist

[@poojasuchithran3470]

@@MukeshKala Thank you sir

[@ShabbirKhan-zs8bt]

Thank you for your clear explanation. Please send me the input files

[@MukeshKala]

If you could pls drop me a note on my mail id available in description... I shall forward the files to you

[@MukeshKala]

👉👉 RE Framework Complete Playlist kzbin.info/aero/PLEYSwx3duQ2BoRamKrEQ6qrZvrL-mAm7p

[@girishkrishna4654]

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?

[@MukeshKala]

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./

[@girishkrishna4654]

@@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.

[@MukeshKala]

Try using log message activity

[@girishkrishna4654]

@@MukeshKala ok

[@BLRCREATION]

I don't have word application, what other option replace pic I can use?

[@MukeshKala]

You can use any online Doc Editor - such as Google Doc or any other editor .. but that you need to first integrate with UiPath

[@bhuvanagiripavangurukalyan8909]

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

[@MukeshKala]

Your Transaction Item is Null

[@bhuvanagiripavangurukalyan8909]

@@MukeshKala how can I sort this error sir I was set transaction data also but given same error

[@MukeshKala]

@@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

[@bhuvanagiripavangurukalyan8909]

@@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

[@MukeshKala]

@@bhuvanagiripavangurukalyan8909 Run in debug mode and see if the Trnsaction data is correctly flowing from Init section and it should not be null

[@Ye_3timepagal]

ek saal ke baad thik se samjha me

[@MukeshKala]

Great

[@girishkrishna4654]

25:28, Mukesh, what are SAP?

[@MukeshKala]

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.

[@chethanchintumj4162]

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!!!

[@MukeshKala]

forum.uipath.com/t/send-an-image-in-body-of-an-email/325333/3 - See this Thread

[@chethanchintumj4162]

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

[@chethanchintumj4162]

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!!!!!

[@MukeshKala]

@@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.

[@MukeshKala]

@@chethanchintumj4162 I have limited access to VDI - Will try

[@RPACoder]

how can i get the data that you used in this case Mukesh ?

[@MukeshKala]

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.

[@mariselvamm7038]

hi bro , uipath la how to use python bro and i need any mini project

[@MukeshKala]

rpabotsworld.com/python-integration-with-uipath/

[@girishkrishna4654]

1:03:22 index value is 15 NOT 14

[@MukeshKala]

Yes , I said it wrong and that’s why put the caption in video at the same time .. Thank you for sharing 🙋

[@navyaharitha140]

Can you please share the practice files

[@MukeshKala]

Please Drop me a note on my mailid available in description and I shall forward the files

[@shoaibansari4282]

Can you please share the practice file?.

[@MukeshKala]

Hello , if you could please drop me a note on my mailid available in description , I shall forward you the files

[@TejswiniJane]

Hi Sir Can you send me the Input File

[@MukeshKala]

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

[@nishantjaiswal1797]

Hi, Could you please send me the input files over my email. Thank you

[@MukeshKala]

Sure , Please drop me a note on mailid which is available in Description and I shall revert with the code and the files

[@mayurisarode1329]

Hello Sir, Can you please send me the input files to my mail,Thank you

[@MukeshKala]

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 :)

[@mayurisarode1329]

@@MukeshKala thank you sooo much

[@MukeshKala]

Hope you were able to get the files 👍

[@mayurisarode1329]

@@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

[@MukeshKala]

Sure I will

[@bhargavimanepalli]

Hi, Could you please send me the input files to my mail,Thank you

[@MukeshKala]

Sure , please send me an mail on my mail id available in description