UiPath Tutorial 25- UiPath ReFramework with Excel |UiPath Real Time Project

Поделиться
HTML-код
  • Опубликовано: 17 окт 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

Комментарии • 76

  • @qualityassurancelab7764
    @qualityassurancelab7764  4 года назад +13

    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!

    • @IamsoblessedJBJ
      @IamsoblessedJBJ 3 года назад +1

      Initially my status is not updating but after putting in else block its working fine, please suggest why it is happening

    • @qualityassurancelab7764
      @qualityassurancelab7764  3 года назад

      @@IamsoblessedJBJ Hi, what activity you placed in else block? and where you placed this else block?

    • @IamsoblessedJBJ
      @IamsoblessedJBJ 3 года назад

      @@qualityassurancelab7764 writerange activity for updating status in excel sheet in status column.

    • @qualityassurancelab7764
      @qualityassurancelab7764  3 года назад

      @@IamsoblessedJBJ It seems like your condition went False, that's why else block got executed

  • @vishnu_addagada
    @vishnu_addagada 3 года назад +6

    Finally found a clear explanation for RE Framework with Datatable. Thank you so much

  • @terencemupeti425
    @terencemupeti425 4 года назад +3

    By far the best Reframework video I have seen, job well well done

  • @nixonpa1550
    @nixonpa1550 4 года назад +2

    I have watched many videos about Refreamework u r beautifully explained everything other than anyone tku for this video

  • @maskoff1111
    @maskoff1111 3 года назад +2

    This is a perfect working tutorial of RE, you did a great work. Thanks

  • @azharuddinshaikh7195
    @azharuddinshaikh7195 2 года назад +1

    Awesome, very good explanation! I followed and was able to execute without any errors..

  • @viewers23
    @viewers23 Год назад +1

    thank you for putting this much of detailed explanation

  • @nikhilsapkal4638
    @nikhilsapkal4638 2 месяца назад

    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?

  • @pranavkashyap
    @pranavkashyap 3 года назад +1

    The best video for Reframework ...nice job thanks a lot for this.

  • @senthilKumar-bo2is
    @senthilKumar-bo2is 2 года назад +1

    insted of using ui explorer ,we can use anchor base activity also ?

  • @Artech.Ranjit
    @Artech.Ranjit 3 года назад +1

    If we r adding data to Queue, and taking filtered data from queue. where we need to put those, any suggestions please?

  • @robertrynard7397
    @robertrynard7397 3 года назад

    This was super helpful with you walking through the flow and steps of it all. Thank you.

  • @vikrampurohit3033
    @vikrampurohit3033 2 года назад

    Hi Maam,
    Why reading of excel is metioned in first run sequence, we can use it in initAllApplcation workflow instead, please guide me.

  • @mb26100
    @mb26100 3 года назад

    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 ?

  • @marcr2204
    @marcr2204 4 года назад +2

    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

    • @qualityassurancelab7764
      @qualityassurancelab7764  4 года назад +1

      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 - ruclips.net/video/QfCgvZcWwCQ/видео.html

  • @garhwaliboy3235
    @garhwaliboy3235 Год назад

    What a clean explanation.. thank u so much for this video.👌👌👌

  • @prabhukiran7866
    @prabhukiran7866 3 года назад +1

    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?

    • @qualityassurancelab7764
      @qualityassurancelab7764  3 года назад +1

      Hi, did you added BusinessRuleException in the catches block , after the work of try block?

    • @prabhukiran7866
      @prabhukiran7866 3 года назад

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

    • @shaggztravel
      @shaggztravel Год назад

      Any good, I am facing the same error :(

  • @mks2613
    @mks2613 Год назад

    thanks for the video quite helpful.
    is there anyway you can share entire workflow of this video.?

  • @muralimohan7005
    @muralimohan7005 3 года назад

    Good explanation about RE framework.Thank you.

  • @SenthilKumar-ue8pr
    @SenthilKumar-ue8pr 2 года назад

    wow finally i got solution from u ,thanks a lot mam

  • @nobi6139
    @nobi6139 3 года назад +1

    Very clear walkthrough! Thanks.

  • @marcr2204
    @marcr2204 4 года назад +1

    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?

    • @qualityassurancelab7764
      @qualityassurancelab7764  4 года назад

      Yes, you are right. Reframework provides only the structure of the project. And, we do modifications according to our project requirements

  • @mdanwarhabib8677
    @mdanwarhabib8677 2 года назад

    Excellent Video
    Learned many new things

  • @rpa-uipath1826
    @rpa-uipath1826 Год назад

    Hi, I am getting error as object reference not set to an instance of an obj at Transaction level

  • @deepakkumarbhuyan9002
    @deepakkumarbhuyan9002 2 месяца назад

    Why can't you write the status column using add data dow instead of using write cell activity.

  • @ajaykumar-kx1jd
    @ajaykumar-kx1jd 3 года назад +1

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

    • @qualityassurancelab7764
      @qualityassurancelab7764  3 года назад

      Please confirm that there is no space before and after 'Last Name' in the excel column header

  • @SyedAli-iq4ku
    @SyedAli-iq4ku 3 года назад

    I really appreciate with this explanation Thanks in advance.....

  • @humbertolimaferreira2587
    @humbertolimaferreira2587 3 года назад +1

    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"

  • @ashokreddybasham7474
    @ashokreddybasham7474 2 года назад

    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

  • @golakondababu7105
    @golakondababu7105 4 года назад +1

    Hi can you please make more vedios on UIPATH please. . .you are really awesome mam thanks for your time and patience. . . .

  • @Foodblogging_
    @Foodblogging_ 2 года назад

    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

  • @pranaykumarbose4466
    @pranaykumarbose4466 Год назад

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

  • @manojsadhu5514
    @manojsadhu5514 3 года назад

    Hi
    I need uipath studio 2020 software to practice. Because 2021 is not supporting to my windows 7 OS. Please provide 2020 software

  • @ShanuKumar-wm6yt
    @ShanuKumar-wm6yt 2 года назад

    Hi, your video is really helpful. can you please help me with Try Catch Set Transaction Status (BRE) block. I am getting error here.

  • @KunalKumar-tt4bt
    @KunalKumar-tt4bt 2 года назад

    what about transaction data data type is it going to be data table

  • @ShanuKumar-wm6yt
    @ShanuKumar-wm6yt 2 года назад

    i am able to do the success scenario but business case and system is giving error. Plz help if u can

  • @marcr2204
    @marcr2204 4 года назад +1

    Also, config is defined at the main level then @11:57 why this variable is not visible inside 'initialize All applications'?

    • @qualityassurancelab7764
      @qualityassurancelab7764  4 года назад

      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 - ruclips.net/video/QfCgvZcWwCQ/видео.html

  • @davidkishteev6710
    @davidkishteev6710 4 года назад +1

    Thank you very much! Really helpful video

  • @mokindbhosle1909
    @mokindbhosle1909 Год назад

    Expalined Very Well...😊😊

  • @b.sivakumarreddy1526
    @b.sivakumarreddy1526 Год назад

    Where did we declare "io_TransactionData"? I am strcked here. Can anyone do help?

  • @marcr2204
    @marcr2204 4 года назад +1

    As usual Awesome tutorials :))

  • @wesleyteenwesley
    @wesleyteenwesley 3 года назад +1

    Thank you simple and sweet❤️

  • @learningrpa7639
    @learningrpa7639 3 года назад +1

    am getting error ,object reference not set to an instance of an object from the first name onwards. please solve this issue.

  • @CINOJM
    @CINOJM Год назад

    Very useful video.can you please do one video using the orchestrator queue

  • @mamathad1727
    @mamathad1727 Год назад

    Hai i am getting an error called object refarence is not defined

  • @anwarsd9736
    @anwarsd9736 11 месяцев назад

    Thanks for awesome explanation....

  • @basitmirza7649
    @basitmirza7649 4 месяца назад

    Very help full

  • @negarmishu
    @negarmishu 4 года назад

    Do you have any plan to cover REFramework project with database ? I learn lots of thing from your channel.Thanks

    • @qualityassurancelab7764
      @qualityassurancelab7764  4 года назад

      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.

  • @sundarrajanjayachandran8668
    @sundarrajanjayachandran8668 3 года назад

    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.

  • @manishkumarsharma9509
    @manishkumarsharma9509 3 года назад +1

    Excellent....

  • @Vijaykumar-ct6ss
    @Vijaykumar-ct6ss 2 года назад +1

    16:00 transaction number changed 1 to zero. Before that transaction data vb changed as DATAROW

  • @RakeshKumar-py2vq
    @RakeshKumar-py2vq 3 года назад

    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

    • @parikshitlimkar3886
      @parikshitlimkar3886 2 года назад

      Hey Rakesh, in debug mode you will get stuck, however if you just 'run' the file instead of debugging, you wont face the issue

  • @sallugoni342
    @sallugoni342 3 года назад +1

    Always gud

  • @kasimacsys1
    @kasimacsys1 4 года назад +1

    Hi.. please consider to post videos for custom activity with visual studio and UIPath insights

  • @SyedAli-iq4ku
    @SyedAli-iq4ku Год назад

    Thank you so much

  • @ushasgowda8447
    @ushasgowda8447 Год назад

    Any one have the report for this project

  • @mariamalmushikes7661
    @mariamalmushikes7661 6 месяцев назад

    Thank you for this video. However, This video is old and not useful anymore. Many settings and configurations have been changed.