UiPath Tutorial 25- UiPath ReFramework with Excel |UiPath Real Time Project
Вставка
- Опубліковано 8 вер 2024
- This video explains how to create a UiPath ReFramework Project with Excel as data source. Project will read input data from excel and write the execution status in excel.
References -
UiPath Reframework Overview - • UiPath Tutorial 19 - U...
UiPath State Machine - • UiPath Tutorial 07 - W...
Read data from Config file and write them to Dictionary - • UiPath Tutorial 16 - R...
Invoke Workflow File Activity with Arguments - • UiPath Tutorial 15- In...
UiPath Excel Automation - • UiPath Tutorial 08 A -...
Application used for Demo - www.rpachalleng...
=========================================================
Automation Anywhere Tutorial Playlist:
• Automation Anywhere A1...
Automation Anywhere A2019 Tutorial Playlist:
• Automation Anywhere A2019
UiPath Tutorial Playlist:
• UiPath Tutorial
JMeter Tutorial Playlist:
• JMeter Tutorial
Git and GitHub Tutorial Playlist:
• Git and GitHub Tutorial
Subscribe for more tutorials - / @qualityassurancelab7764
Linkedin - / quality-assurance-lab-...
Facebook - / quality-assurance-lab-...
Twitter - / labassurance
Medium - / labassurance
Join Channel Membership - / @qualityassurancelab7764
Hi Guys! Hope you found this video useful. Please like, share and subscribe to my channel. This will motivate me to create more good contents. Thanks!
Initially my status is not updating but after putting in else block its working fine, please suggest why it is happening
@@vaishalichauhan7909 Hi, what activity you placed in else block? and where you placed this else block?
@@qualityassurancelab7764 writerange activity for updating status in excel sheet in status column.
@@vaishalichauhan7909 It seems like your condition went False, that's why else block got executed
Finally found a clear explanation for RE Framework with Datatable. Thank you so much
thank you for putting this much of detailed explanation
By far the best Reframework video I have seen, job well well done
I have watched many videos about Refreamework u r beautifully explained everything other than anyone tku for this video
This is a perfect working tutorial of RE, you did a great work. Thanks
Awesome, very good explanation! I followed and was able to execute without any errors..
The best video for Reframework ...nice job thanks a lot for this.
Very help full
I really appreciate with this explanation Thanks in advance.....
Good explanation about RE framework.Thank you.
What a clean explanation.. thank u so much for this video.👌👌👌
Thank you simple and sweet❤️
Excellent Video
Learned many new things
wow finally i got solution from u ,thanks a lot mam
Very clear walkthrough! Thanks.
This was super helpful with you walking through the flow and steps of it all. Thank you.
Thank you very much! Really helpful video
Expalined Very Well...😊😊
Thanks for awesome explanation....
Hi can you please make more vedios on UIPATH please. . .you are really awesome mam thanks for your time and patience. . . .
Thank you, I will share more videos on UiPath
Thank you so much
Excellent....
Always gud
Great explanation !! I need one help. Actually i want to retrieve row index in reframe-work for the corresponding input data row. Could you pls tell?
16:00 transaction number changed 1 to zero. Before that transaction data vb changed as DATAROW
As usual Awesome tutorials :))
Very useful video.can you please do one video using the orchestrator queue
thanks for the video quite helpful.
is there anyway you can share entire workflow of this video.?
If we r adding data to Queue, and taking filtered data from queue. where we need to put those, any suggestions please?
insted of using ui explorer ,we can use anchor base activity also ?
Mam your explanation was too good.. I Recently started my RPA ui path training I have a small doubt how to we know drag that particular activity only are any other activities we also use the same process can you plsss tell Mee maaam
Hi. Thank you for posting. So, @ 5:51 where it says invoke 'initAllsettings workflow' box and you click on the 'import Arguments Box' it says 3 args but the first two arguments in_ConfigFile and in_ConfigSheets the default values are mentioned so no confusion there but the third one out parameter out_Config --> config variable so it is getting assigned from let to right? I tried to switch around and it is not recognizing so that's what is seem like .:)) will continue to rest of the tutorial
Hello!
If you notice the direction of argument out_Config, it is "Out", which means value of out_Config will come out from InitAllSettings workflow to Main workflow, and will be assigned to Config variable.
Which is reverse in case of other 2 arguments - in_ConfigFile and in_ConfigSheets
You will get more clarification on passing arguments with In/Out Direction under Invoke Workflowfile activity here - ua-cam.com/video/QfCgvZcWwCQ/v-deo.html
good afternoon, and you can check when i use the append range, the data is recorded, however if i open the file and make some changes and save the file and the robot will extract the data again for this file, it gives error !! ! .Or the excel files cannot be manipulated manually which gives the error? error that is giving is this "Append Range: Sequence contains no matching element"
Hello, are you making changes during the run time? what changes you made?
Hi
my flow is getting stopped at the "throw" activity which we have used in Process transaction. It's just printing the follwing message on the Output Panel and stopping the execution.
"Throw: Business Rule Exception occured, Firstname should not be null or contain whitspace".
Any suggestion??how Can i rectify this one?
Hi, did you added BusinessRuleException in the catches block , after the work of try block?
@@qualityassurancelab7764
Thanks for your reply. I just kept the same. Arch block which RE Framework provided. I did not added explicitly on my own. I can’t add screenshot in this comments section otherwise I should have showed you that.
Any good, I am facing the same error :(
Hi.. please consider to post videos for custom activity with visual studio and UIPath insights
Sure, i will post!
Hi Maam,
Why reading of excel is metioned in first run sequence, we can use it in initAllApplcation workflow instead, please guide me.
Hi, your video is really helpful. can you please help me with Try Catch Set Transaction Status (BRE) block. I am getting error here.
The tutorial was definitely good..... But my project didn't work. As I am working with the newer version of UiPath Studio... So many new activities and elements has been added.... Don't no weather those some changes needs to me made.... I followed the tutorial and did as mentioned.... The execution ends with no errors but the requirement is not fulfilled as data is not being added to the excel file (Success data) as well no chrome activities happened(Filling of the form in RPA challenge)..
When I use Read Range, why do I have to give this Config(("InputFilePathforQueue").ToString).ToString ? If I do not give that extra ToString, it shows Compiler error. Any reason ?
Hii , I'm getting error when reading lastname from excel.
it is showing that column 'Last Name' does not belong to dataTable. can u please help me..
Please confirm that there is no space before and after 'Last Name' in the excel column header
Can you think of any scenario where UiPath framework is not applicable? In the sense that we can use UiFramework for any activity with some modifications, Is that the right assumption?
Yes, you are right. Reframework provides only the structure of the project. And, we do modifications according to our project requirements
Also, config is defined at the main level then @11:57 why this variable is not visible inside 'initialize All applications'?
initialize All applications is a different workflow which gets invoked by Main workflow.
Config is defined in the Main Workflow, it is not a part of initialize All applications, so not visible.
Please checkout this video to learn on Arguments , variables and Invoke WworkflowFile activity - ua-cam.com/video/QfCgvZcWwCQ/v-deo.html
Hi, I am getting error as object reference not set to an instance of an obj at Transaction level
what about transaction data data type is it going to be data table
Thanks for the video. When I followed the same steps i got the below error message while executing.
If a new transaction item is retrieved, get additional information about it: Object reference not set to an instance of an object.
I got the same Error what to do now
Where did we declare "io_TransactionData"? I am strcked here. Can anyone do help?
am getting error ,object reference not set to an instance of an object from the first name onwards. please solve this issue.
Let me know the expression you used in the activity which threw this error
Hi ... thanks for uploading this video great job it is very useful keep up the good.. i have done the same process as your but in the process state in the else part u have place one throw activity for bussiness rule exception, i also place and gave the same condition as your but in the throw part im getting this error. my bot stops at that place can you please help me out from this
Hey Rakesh, in debug mode you will get stuck, however if you just 'run' the file instead of debugging, you wont face the issue
i am able to do the success scenario but business case and system is giving error. Plz help if u can
Hi
I need uipath studio 2020 software to practice. Because 2021 is not supporting to my windows 7 OS. Please provide 2020 software
Do you have any plan to cover REFramework project with database ? I learn lots of thing from your channel.Thanks
Hi, I'm glad that you found my videos helpful. I do not have such video as of now, I will plan for the same.
Hai i am getting an error called object refarence is not defined
I have followed the same process as you did but when i have added chrome in kill process, in between of process of adding data into rpa challenge website.its closing chrome. Can you help in this
Did you find the solution?
Thank you for this video. However, This video is old and not useful anymore. Many settings and configurations have been changed.
Any one have the report for this project
Why can't you write the status column using add data dow instead of using write cell activity.