UiPath Tutorial | RE Framework Uipath Sample Project (2020 Chapter 5)

[@kelip182]

Really fantastic the way you are teaching. very easy to understand! Thanks

[@AutomatewithRakesh]

Glad to hear that!

[@chaithanyachaitu8116]

@@AutomatewithRakesh hi sir i did exactly how you do in video but am getting error in assign activity. Error : conversion from string to type integer is not vaild. Will please help me in this

[@jairaj1082]

I got a complete understanding of REFramework and successfully completed the project. I have gone through so many errors while doing the project but eventually i got the result and got a good clarity on each and every state, variables, arguments, activities, invoke methods in REFramework. You are the best. You deserve much more success in your life. Thank you for everything brother😍😍

[@AutomatewithRakesh]

Very good job Raj continue Your learning journey and keep commenting

[@23Ashishonelove]

Thanks for the info where you mentioned build datatable activity shouldn't be used inside a process state. Keep sharing more such minute details which will be helpful for beginners.

[@AutomatewithRakesh]

Thank you Ashish !

[@rohinidhepe8177]

This is a amazing video. Thank you Rakesh sir to teach us minutely with step by step.

[@AutomatewithRakesh]

My pleasure

[@sudeeptapillai4421]

@rohinidhepe8177 I am getting error in key "In_Name" is not found even though I can find it in orchestrator. Can you help me?

[@purushottamw]

This is nice solution. However, I did it with the help of append Range in the process itself and it worked. Hope this help. Thank you.

[@44441kaushik]

helpful

[@mohanvasan2629]

Thank you I was not aware of that activity, reading comments really gives new learnings.

[@sowmiyaangamuthu6343]

happy to see that the subscribers count keeps increasing everyday. i suggested ur channel to some of my friends aswell . could u pls shed some light on how to prepare for interview as a fresher? pls make a video on it .

[@AutomatewithRakesh]

Hey Sowmiya thank you 🙏 sure I will try to create some content around it. I am thankful for the help you do!

[@SyedAli-iq4ku]

Thank You so much Rakesh, I am really glad with this kind of real time scenarious.

[@AutomatewithRakesh]

Good job continue the learning journey

[@divtre]

Very well explained and crisp and short as it could....appreciate all efforts!!

[@ganityadav177]

one of the best Uipath trainer

[@AutomatewithRakesh]

Thank you Ganit

[@sivasankar566]

Thank you for this video it's rectify my issues 👍👍👍❤️❤️.

[@minalzope8692]

this is very much helpful...Thank you Rakesh.

[@AutomatewithRakesh]

You're most welcome

[@LearnAutomate]

After watching the previous video, I got the same doubt regarding the data table. before watching your solution i tried to fix it and below is the process is used -> I have stored the output of read range used to read the sheet1 in a Out Argument -> Also I have set the TotalDue as Out Argument in the process stage ->Initialized a Counter (var_dtRowNumber) with default value 0 -> assigned the TotalDue value to the DataTable using. dt_ExcelExtract.Rows(var_dtRowNumber)("Total Amount Due") = var_TotalDue ->increased the counter, so that in the next iteration the value will get stored in next row -> Wrote the DataTable to the same sheet, this time with totalDue amount added in "End Process" Stage this way I could reduce the number of interactions with the excel sheet less nukber of variables used in the process.

[@AutomatewithRakesh]

That’s awesome

[@ssridevi1111]

Hi Rakesh I find all your videos useful Thank you for your time and what your doing is simply great .Kindly post more videos and If possible Video on Enhanced RE Framework will be useful to all

[@AutomatewithRakesh]

Sure

[@vishalpatil6696]

Sir as u putting read range in initall application of intilization state ,if system exception occurs it wil be readed again on retry

[@Adityasingh-ru1dj]

Wow great teaching skill

[@AutomatewithRakesh]

Thank you Aditya

[@muralikrishna-o7r]

really fantastic bro your way of explanation

[@sarithag3757]

Revision of the topic is excellent..Appreciable efforts!! Complex topic is explained utmost Clearly..thankyou so much....

[@AutomatewithRakesh]

Thank you For writing and continue your learning journey

[@SelvakumarSun]

Thanks Rakesh. Good explanation.

[@AutomatewithRakesh]

Keep watching

[@ashokdondapati7666]

Very practical... Bro.. Thanks..

[@sureshkumar-gz4ti]

Hi Rakesh, i am not able to create arguments, after i created the argument its not saving at all, please advice on this.

[@Arivunithi13]

Hi Rakesh We are done output but where it's save total due amount? In orchestrator? Or any other file ?

[@mpumisetshedii]

still getting the same error, i mapped out the read range dt to the argument with out direction, made the variable in main then mapped it to the argument created in process , still getting the same error

[@devasishbanerjee6520]

Solved at last. Thanks!!!

[@AutomatewithRakesh]

Good job continue the learning journey

[@szehansha55]

Here assign activity is string . How can change to integer type . Please tell me

[@ganityadav177]

Hey, I want to know that this config file should be in developers machine or target machine, Bcs this will get created when devloper code in uipath studio and incorporate reframework at tht time, so i m confused whether it should be in target machine or developers machine

[@AutomatewithRakesh]

Hi Ganit, the config file is part of the project folder. When the package is uploaded to Orchestrator, it goes along with it. Any changes needs to be done in the future, the developer needs re-upload the next version of the package.

[@ganityadav177]

@@AutomatewithRakesh ooohh,, thanks for this useful information

[@mohanvasan2629]

Hi Rakesh, My values are stored as a text in Excel file, what would be the reason for that.

[@bharathkumarchalla4937]

while running file it is saying { Add Data Row: Object reference not set to an instance of an object.} though i followed what u have said...im stuck can u give me a solution thankyou

[@szehansha55]

I got an error . The given key was not present in the dictionary.

[@szehansha55]

My process can't change to string to integer. 'Cint' it was not working

[@MrSaicharancherry]

A part from this...can we add counter to this.Like "A2+counter"in write range and counter gets incremented....

[@madhanraj7220]

instead of using write range , can use append range simply... it worked fine without doing any stuff..!!!!

[@rajashrees992]

Thanks a lot for this video :)

[@minalzope8692]

AS you mentioned to initialize the object , I have done it But for Add Data Row Activity, the same error that Add Data Row: Object reference not set to an instance of an object. is coming...can you solve it.

[@hello_makkale4800]

Getting same error...plz assist..is possible to write output in same sheet.. instead of creating a new sheet..?

[@phalgunvempati]

Thank you, bro, it helped me a lot for my Learning.

[@AutomatewithRakesh]

Phalgun, Thank you so much

[@jayasudharajendran5209]

hi.. how about using a flag for build data table.. first transaction the flag is not set it builds data table and sets the flag.. for the second transaction it wont enter the loop since the flag is set and the data is not built

[@AutomatewithRakesh]

Yes that’s good logic. However as you proceed with the playlist you will see how I have designed the dispatcher and performer sequence

[@jayasudharajendran5209]

I really appreciate ur dedication and hard work. You deserve more subscribers.. unfortunately I can give only one like.. if there is option for multiple likes I will give as much as I can

[@sanvithareddy123]

Hello Rakesh! While Adding Data Row i am getting a compilation error "value of type integer can not be converted to object error ". Please Help

[@AutomatewithRakesh]

You need to check the expression somewhere wrong

[@bhargavimayurri1812]

I m also getting the same error, I followed the video step by step, did a through check, but couldn't resolve.

[@bhargavimayurri1812]

Hi Rakesh, Thanks for the video, I have a few doubts. When i try to add the data in the process.xaml file using Add data row, i m getting the error as couldnt atore value in the data column. Expected type is object[] at source Add data row. Could you pls help.

[@VamsiKrishna-wv4os]

Hi Sir, will the data can be written in same excel file? please explain

[@saahilshaikh7445]

Hello Rakesh which language will be good to learn with RPA is it C# with sql server and is it necessary to have experience or to learn dot net to get a job into RPA. It would be good if you cover this in a upcoming video because there are many like me having this doubt in mind and have rejected from being get hired.

[@AutomatewithRakesh]

Hello Saahil Let me give you some quick help here. Please read this article and reply from Jen O'Neil, Strategic Software Developer Partner at Chetu (2016-present). www.quora.com/What-programming-languages-are-used-in-UiPath

[@saahilshaikh7445]

@@AutomatewithRakesh yes i have read this article but still its not clear. If we have learn a programming language or not. I am asking you this because i understand that we can work with uipath by searching some code on internet still the hiring company asked to have background experience in dot net and sql. so was having concern as i do not know C# or VB Will they hire me or not.

[@gayathrima5970]

Hi, Everytime I run the workflow ,the queue item adding the data again into queue and in excel file too , could you please give a solution?

[@AutomatewithRakesh]

Develop a separate workflow for dispatcher. Take it out from init state if you have it already

[@laliteshpothukuchi5076]

It's been Fun'tastic bro learning from scratch in a very simple way. Really Great. But I have a small doubt, we are writing the values to the different sheet right, instead can't we write in the same sheet in different columns!!

[@AutomatewithRakesh]

Yes you can build any logic that fits the requirements

[@mohinichaudhari2610]

Hello sir,in process transaction..assign activity the error is occurs "key was not present in the dictionary"...?

[@AutomatewithRakesh]

Looks to me the config file has been modified or data has been deleted by mistake

[@mohinichaudhari2610]

@@AutomatewithRakesh Done👍

[@szehansha55]

@@mohinichaudhari2610 How to fix this error problem. I have same issue facing could you explain me

[@kalyang9950]

Thank you Rakesh

[@AutomatewithRakesh]

You are most welcome

[@minalzope8692]

I am getting Error in my project as " Add Data Row: Object reference not set to an instance of an object."....Can you give me solution of it...

[@AutomatewithRakesh]

HI Minal, hope this video may help you to understand the cause of the error: kzbin.info/www/bejne/gYGpoHmpf9mZn6c

[@vishwatejaj7419]

hello brother, how to use write cell activity to write in the same sheet

[@Khush0602]

hello Rakesh , while debugging it throws an error from process state , Assign:The given key was not present in the dictionary . how to fix that problem?

[@AutomatewithRakesh]

Hard to figure out just with the error message, I think you need to check which assign activity is throwing that error and try to see. Looks to me you may have done some changes in the config file

[@mohinichaudhari2610]

Hello khusboo..how to fix this error

[@amanrawat6656]

Thank you sir

[@TechNode23]

very much useful

[@himanshuprataprana6867]

After changing a arguments, comes an error(Add Data Row: Object reference not set to an instance of an object.)

[@himanshuprataprana6867]

How can resolved it?

[@docoRPA]

Uploading data to the queue in the Initialization without explaining that this is NOT where you should be doing this could be misleading to some people. Would have been much better if you explained that ReFramework is a "Performer" . The "Dispatcher" process should be completely separate . ReFramework can also be used as a Dispatcher, but it will be a completely different project

[@001ather]

Hi Rakesh. Thanks for sharing the in depth knowledge on UIpath automation. I have been following all your RE Framework videos till now. and I am finding these videos really helpful. So thanks again. But, there is 1 thing I am not able to understand ,neither I could find the answer to it anywhere on the internet. The question is How do a workflow created in RE framework works actually on different robots running on different machines. Is the process to publish the RE framework workflow to the orchestrator same as like an ordinary workflow? And when this REFramwework process created by me would run on some other machine, then would it run from the initializing state on that machine too? meaning that particular machine would also has to have the input file ( lets suppose an excel) saved on it locally so that it could upload/download to the orchestrator queue? If that is the case then what is the point of uploading / downloading the data to the orchestrator on each run of the process when the data has to be present locally on each machine, if we go by the Re framework structure. I know I am missing something somewhere and that is why I am reaching out to you here. Thanks for your support in advance, Ather

[@AutomatewithRakesh]

Hi There, if you are comfortable you may join my Weekend Classes, where I demonstrate these concepts and provide clear cut guidance to my students!

[@001ather]

I got the answer. I got to know about dispatcher and performers. Thanks

[@ajay397]

just asking rakesh..we can initialize counter variable in process transaction state right..and we can write in the excel using write cell activity..please let me know if I'm wrong.

[@AutomatewithRakesh]

Yes you are right Ajay, you can do that

[@ajay397]

@@AutomatewithRakesh thanks rakesh

[@shrutikadongre1046]

I am not able to see your video, the format seems corrupted, can you please check once..

[@AutomatewithRakesh]

It’s It’s working fine please check the internet connection how are you connected

[@shrutikadongre1046]

@@AutomatewithRakesh I am very well connected to the Internet.. anyways, I will watch your other video on ReFramework (2021) as this is not loading

[@AutomatewithRakesh]

@@shrutikadongre1046 not really sure

[@44441kaushik]

Wonderful., is it possible to write the final output to the same sheet of the excell from where we read the input ?

[@AutomatewithRakesh]

Yes logically possible

[@saahilshaikh7445]

Hi Rakesh.rather than this we can use counter. Can you make counter example.

[@AutomatewithRakesh]

sure Saahil, can you please explain your use case bit in detail!

[@saahilshaikh7445]

@@AutomatewithRakesh you can take the same example and use with counter to right the total value in the total column with counter rather than appending the whole value it will append the single value at a time in the data row.

[@vikrampurohit3033]

Hi SIr, Code is continuously running, could you please do the needful.

[@AutomatewithRakesh]

Try to check if you are feeding the data in the Init block

[@AutomatewithRakesh]

At the time of exception the flow goes back to Initial block and entire process repeats so try to check how you are feeding the data

[@rpa6646]

Dear ExpoHub Team, How to add re-try mechanism for a single activity in re-framework. Suppose in process transaction I have processed two files and want to upload the files in some application. During upload of files if the activity fails how can I retry only the activity (uploading of files) without going again through the entire processing of files.

[@AutomatewithRakesh]

Hi Marina, we would suggest you To upload files to the application in the processing state it self, provided all the transaction items are coming from Orchestrator Queue. Processing state has the mechanism of application error handling such as application not responding. At the time of application not responding in the processing state it will access the try catch exception block And create a new transaction item of the same file which had error and will re-try

[@AutomatewithRakesh]

You can get more details about it in the application exception handling video

[@rpa6646]

Actually I am not using any queue item here as I am downloading only two input files. Those two input files I have kept in Initialization block. As again and again I am not using multiple transaction data so kept in init block. From those two input files kept in init block, i am processing two set of output files by running macro in process transaction workflow. Now these two files I have to upload in an application. While uploading i need to add re-try mechanism where in case the uploading fails it can retry again. How to add the re-try mechanism only in the process transaction workflow only for this particular activity( uploading activity) without again going through the entire activity(processing of files from beginning).

[@AutomatewithRakesh]

You need to create a separate workflow just like the set transaction state workflow in processing state

[@AutomatewithRakesh]

You can simply create a try catch block and use the methods in set transaction state

[@maheshch8444]

Thanks a lot..!

[@AutomatewithRakesh]

You're welcome!

[@WanderRoads]

It will be great if you can share the link of sheet / sheet data.

[@anandnaidu6589]

I want the config file after successful run of the re freamework.

[@dhachanamurthydhachanamurt8447]

Hi sir... U r awesome and got clr all my doubts... One more doubt,, can you provide me the ideas of converting excel to word in dynamically generation of offer letter sir...

[@AutomatewithRakesh]

I think I need to create a video on it: however you can read the excel and write to a template in word document. Will create a video

[@dhachanamurthydhachanamurt8447]

Tq soi much for ur reply sir.. And my request to post the vidoe soon sir

[@kenhtintuc3478]

Why does this video have no subtitles?

[@xavierdsouza8885]

Uipath promised automation as citizen developers and actual automation is so difficult...no wonder the stocks have fallen to lowest

[@KB-th4nh]

Very nice, only problem is your screen is blurred

[@AutomatewithRakesh]

Try to check the Pixel keep it to 1080 they are all high definition contents

[@hemanthk2561]

Waiting for more new projects in REFrame-work bro....

[@AutomatewithRakesh]

Sure Hemanth we ll come up with lot many

[@AutomatewithRakesh]

We are going step by step covering concepts

[@AutomatewithRakesh]

Then will come with lot many sample projects

[@hemanthk2561]

@@AutomatewithRakesh waiting...?

[@dhachanamurthydhachanamurt8447]

Tq so much

[@ponnanikhil9611]

Its confused..when your using arguments for datatable. In Init and process.

[@AutomatewithRakesh]

Let me know where exactly in init state you had confusions

[@jayaseelans370]

Please upload an example for email automation using RE_Framework.

[@waldemarzielinski6958]

hi rakesh , thanks for the video too bad you lost me in the end with the argument and why do you need read range for REfinal if it is empty

[@varikuppalasriram2189]

yes its useless

[@varikuppalasriram2189]

also at the end of process state need to use append range instead of write range

[@C0rrupt3d-D3m0n]

Sorry to say but the adding the argument was too complicated.First creating the argument and then initialising and also the direction in/out was so confusing. Can you please prepare in simple way that first create argument like this then initialise it and that 3rd step passing the value. Thanks,

[@juannepomuzeno4517]

completedddddddddddddddddddddddddd