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

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

[@funedit732]

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

[@MukeshKala]

Thanks a ton

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

[@MukeshKala]

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

[@botsDNA]

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

[@MukeshKala]

Thanks and welcome

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

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

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

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

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

[@Robot2S]

Hi Mukesh, i have problem when i want to publish, and an erorr messgae appear in the output like this: Unexpected error has occurred during the library compilation process: Workflow 'C:\Users\unipath\Documents\UiPath\RoboticEnterpriseFramework_Post GL_New\RoboticEnterpriseFramework_Post GL\Tests\GetTransactionDataTestCase.xaml' is invoking workflow 'GetTransactionData' with argument 'out_TransactionItem' of type 'QueueItem' which is incompatible with the argument type 'DataRow' defined in workflow 'GetTransactionData'.

[@MukeshKala]

In GetTransactionData' xaml : 'out_TransactionItem' should be 'DataRow' and not 'QueueItem' . You forgot to update the datatype

[@Talntnyra]

Thanks Mukesh ..you are really awesome.

[@MukeshKala]

Thanks for sharing the feedback

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

[@TheHomeChronicles]

It... Just amazing and interesting too

[@MukeshKala]

Thank you😀

[@narendrababumupparaju2886]

Fantastic Explanation. Keep Rocking

[@MukeshKala]

Thanks Bro , Appreciate the feedback

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

[@PatilHarshadMtech]

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

[@MukeshKala]

Drop me a note on my mailId available in description

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

[@rpa6646]

awesome Tutorial.

[@MukeshKala]

Thank you 🙏

[@SyedAli-iq4ku]

Thank you so much sir.

[@MukeshKala]

Glad it was helpful 🙏

[@Priyesh246]

Sir I am getting "If maxConsecutiveSystemExceptions exceeded: The given key 'MaxConsecutiveSystemExceptions' was not present in the dictionary." exception while running. How to solve it?

[@MukeshKala]

Check your config file file - you might have deleted the key from constant tab …. Just got to config and add this key back

[@Priyesh246]

@@MukeshKala Sir now it shows this message "System exception at initialization: The given key 'MaxConsecutiveSystemExceptions' was not present in the dictionary. at Source: System.Private.CoreLib","

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

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

[@SyedSAhmed3]

amazing work done sir..thank u

[@MukeshKala]

Appreciate the feedback 😊

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

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

[@Ankit-Swara-vlog]

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

[@Ye_3timepagal]

TimeStamp 1:16:40 where the auto increment is happening, in my case the when ever the bot runs it still show the transactionitem - 1 , and it is running in loop where I am not able to track anycase of any error.

[@MukeshKala]

This happens in the set Transaction status - You can download the code from the website and compare it with yours

[@Ye_3timepagal]

@@MukeshKala nice idea... Just a simple question, I passed the DT to Process Transaction State, now I am not using the Transaction Item, may bcz of that it's showing me the count as 1 requiringly.

[@smnamng]

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.

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

[@유정민-f9u]

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

[@vikrampurohit3033]

Good explanation :)

[@MukeshKala]

Thanks! 😃

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

[@vishnuprasad9619]

👍

[@mariselvamm7038]

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

[@MukeshKala]

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

[@Ye_3timepagal]

ek saal ke baad thik se samjha me

[@MukeshKala]

Great

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

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

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

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

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

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