Hi Ma'am - Is there any way to grab one data table - For .eg - Only of Japan? Also, We have to tap "OK" Each time to message in able to proceed further? So We have to remove the "Message" to make it in flow without an interrupt? Please advice, Thank you! :)
you probably dont give a shit but does someone know a way to get back into an instagram account?? I somehow lost the account password. I love any tricks you can give me
For those who couldn't get Column One, I used Data Scraping twice. first time as instructed in video, then second time is to obtain the list of countries.
Very nice video and superb explanation. please create more videos on Selectors and handling dynamic web elements. This wil b helpful for Real time projects.
Nice explanation I have tried and I get an error excel file is already used by another process or corrupted failed to open error....I got how can I resolve the issue
We can use a log message by putting a syntax in it. Let's suppose, if you have a data table variable called COUNTRY then you can write in log message Country.rows.count.tostring Your count will be appeared.
hi I faced 2 issues while following this tutorial 1. Data is not persistent in the excel file, it automatically getting deleted on process termination. 2. Email thing is not working properly, it is saying "Username and password not accepted". Please help.
Hi, for the first issue, please add output data table and message box to check the values fetched into the data table. For second issue, Turn on less secured app security settings in gmail - myaccount.google.com/lesssecureapps?pli=1
Hi Ousman, the difference between flowchart and sequence is that flowchart is used for small or easy projects whereas sequence is used when the project is very lengthy or difficult or you can say multiple activities are used in other language.
I have a doubt. I followed all the steps as you mentioned but I dont know for some reason, the email part is not working for me. It gives username and password error. I have put in the correct email and password. smtp port as 587 but still getting error. tried it multiple times.
@Quality Assurance Lab I scrolled down for similar error and I found it. thankyou for this resolution. I m able to view the result now. Its working perfect. :) Thanks a lot for this project practice.
Hi, while trying to use a website like amazon or flipkart for extracting the data for all the models for a single product, the data extraction is working only for the first page, even though all the pages with the models for that product are being loaded.
Hi Timsi , Getting runtime error as "Uipath executor has stopped" and 20.4.1 Message: Job stopped with an unexpected exit code: 0x000000FF Exception Type: System.Exception RemoteException wrapping System.Exception: Job stopped with an unexpected exit code: 0x000000FF. This is happening for me whenever there is an Excel application scope or Write range in our sequence or flow chart, Could you please suggest on this.
Hello, My question is if i want to send mail to multiple user which I have maintained in my excel file, can we read this excel file and add all the recepient emails address and send mail to all.
Hi @@tinkumandal4830 If you observe, the entire first column(Location) is written on the single cell of the excel. If you click on A1 cell of your excel, you will get all location items present. Reason - When I created this project, all Location elements of the Web Table were present under td tag ( Element tags can checked from developer tool) But now, the Web Table has been modified , location elements are under div tag within th tag. Because of this, entire first column is written on the single cell of the excel. If you click on A1 cell of your excel, you will get all location items present. So, yes, the Web table format which is extricated is off, I will work on the solution and will get back to you.
Hi Quality Assurance Lab Channel, I tried to scrape data the same way you showed but am unable to scrape out entire table . After clicking on "Worldwide" , the table is showing location columns as counts of Confirmed cases in the corresponding location. Please help me
Hi Priyanka, If you observe, the entire first column(Location) is written on the single cell of the excel. If you click on A1 cell of your excel, you will get all location items present. Reason - When I created this project, all Location elements of the Web Table were present under td tag ( Element tags can checked from developer tool) But now, the Web Table has been modified , location elements are under div tag within th tag. Because of this, entire first column is written on the single cell of the excel. If you click on A1 cell of your excel, you will get all location items present. So, yes, the Web table format which is extricated is off, I will work on the solution and will get back to you.
Hello. While "Data Scrapping", only few are entries are getting written to the Excel. Not the entire data. Why so?? And for sending E-mail ; the port is "465" or " 587"; it is working for both. Which is the correct one? Looking for a reply. Thanks is advance.
@@qualityassurancelab7764 thankyou for this resolution. I m able to view the result now. Its working perfect. :) Thanks a lot for this project practice.
Hi Mam, My bot executed without any error but it didnt write any data extracted from the Datatable in the Excel sheet. This file displays blank data. Can you guide on why the bot didnt write any data in the excel sheet
Could you please try below steps and let me know the results: Add Output DataTable Activity after Data Scraping Activity. Move to properties -> Input -> DataTable . Provide the DataTable value ExtractedDataTable Move to properties -> Output -> Text. Create a String variable (Say ExtractedData) Add a message box and put the variable - ExtractedData Run the project. Please let me know if the message box displays the values extracted from the web table.
Hello mam I m b.com graduate applying for a job for last 2 months but my profile is not getting shortlisted. Is there any way I could boost my profile??
Hi Ma'am - Is there any way to grab one data table - For .eg - Only of Japan? Also, We have to tap "OK" Each time to message in able to proceed further? So We have to remove the "Message" to make it in flow without an interrupt? Please advice, Thank you! :)
Yes, you can grab the table for Japan. For that, use activities to select Japan and click on that. Then capture the complete table for Japan. Message boxes are only for debug purpose to check if the flow works fine or not. Those must be removed during the final execution to run the workflow without any interrupt.
@@qualityassurancelab7764 Thank you - Also Is there any tutorials available of yours in which we can let browser open any URL of News and It grab the data listing ( Web Scrapping) and save it as Document file?
@@harshprajapati5392 Please checkout this to launch url, do data scraping and save result in csv file - ua-cam.com/video/lt2p2o_OhPg/v-deo.html Moreover, in some cases of data scraping, you'll have to resolves several issues which occurs during web data extraction using Data . Please refer this for the same - ua-cam.com/video/CgqpSLerjLs/v-deo.html
Iam finding this error Send SMTP Mail Message: 535: 5.7.8 Username and Password not accepted. Learn more at 5.7.8 support.google.com/mail/?p=BadCredentials 195sm13293450pfb.206 - gsmtp
Could you please try below steps and let me know the results: Add Output DataTable Activity after Data Scraping Activity. Move to properties -> Input -> DataTable . Provide the DataTable value ExtractedDataTable Move to properties -> Output -> Text. Create a String variable (Say ExtractedData) Add a message box and put the variable - ExtractedData Run the project. Please let me know if the message box displays the values extracted from the web table.
@@ss-ye6pl okay, was the data available in Preview Data section of Data scraping? What value you provided in Maximum number of results? Also, please validate the selectors for all activities present under Data Scraping sequence.
@@qualityassurancelab7764 , Yes it was viewable only. The extractdatatable variable was duplicated. On post correct i am able to get the data's in output datable activity. thanks for reply.
I learning 3 RPA tool mam uipath bp and AA I like all your video mam and i want more real time projects by you mam and I am waiting for AA 2019 video and make video about 3 RPA tool which is most used how we select tool mam
I am glad you found my videos helpful, I will share AA2019 and RPA tool comparison videos soon. Keep learning and please share these videos with your friends as well.
Hello Mam, -> First the Library of video you have here is amazing thank you sharing Knowledge -> In this particular tutorial and in upcoming tutorials, if you could not find options like Open Application , Open Browser, Attach Window, Attach Browser, Element Scope, Close Window, Start Process and more options. Activities brief comment.
Hello mam Thanks for the video I am facing a small issue when i extract the data from the web its not getting store or saved in excel no errors is been given please help in solving this issue.
@@qualityassurancelab7764 ya it got created thanks for reply in variables I was Making mistake after that what's happening is is the location column am getting the data of cases all over the column
@@hemantkumargahlot287 If you observe, the entire first column(Location) is written on the single cell of the excel. If you click on A1 cell of your excel, you will get all location items present. Reason - When I created this project, all Location elements of the Web Table were present under td tag ( Element tags can checked from developer tool) But now, the Web Table has been modified , location elements are under div tag within th tag. Because of this, entire first column is written on the single cell of the excel. If you click on A1 cell of your excel, you will get all location items present. So, yes, the Web table format which is extracated is off
Your videos are really helpful. But here having one doubt. Here what the ‘Sender - From’ property of ‘Send SMTP Mail Message’ specifies? How it is different from ‘Logon EmailId’ and what if we miss it or give some other mailId, other than the logon mailId? Thanks in advance.
1.data scraping activity 2.inside data scraping(workbook write range) 3.create one sample excel file 4.print the data is it possible to execute without using excel application scope?????
Hi , I m not able to extract the particular element from website , can you please help me . when i try to do the whole page is getting selected and later pop up with "This control does'ntnot support"
Hi. I cannot find where is extractDataTable to excel. Only have 1 function is ExtractData. But UIpath say: "ExtractData" is a type, and cannot be used as an expression
Ma'am how if I only want to extract certain rows of data that contains certain text that I defined? For example I just want rows that contain text "In" and "United", so the output are like India, Indonesia, United Kingdom, United Arab Emirate etc
I am not able to sent the mail on mail IDs. Error : The specified string is not in the form of required for an e-mail address Exception Types: System.FormatException
Hello mam, it is possible to get the job as a fresher in rpa uipath because when i search the job as a rpa developer i foud that all the jobs for experience atleast 2 and 3 year in IT. what is the way to get a job as a fresher.please guide me
hello. fully appreciative of the videos. they are very helpful. I followed the steps to the letter but i seem to be having a problem saving the extracted table to the worksheet. the table won't save. I've also tried to add a Save Workbook activity but that doesn't work as well.
Thanks for your time and feedback. Did you get any error or simply data not written to excel file? Also. Could you please try below steps and let me know the results: Add Output DataTable Activity after Data Scraping Activity. Move to properties -> Input -> DataTable . Provide the DataTable value ExtractedDataTable Move to properties -> Output -> Text. Create a String variable (Say ExtractedData) Add a message box and put the variable - ExtractedData Run the project. Please let me know if the message box displays the values extracted from the web table.
@@qualityassurancelab7764 thanks for the reply. I'm not getting an error. the table won't write to the excel file. I also tried what you listed; adding an output data table after the data scraping activity. but the message box just comes out blank. I'm looking at the data scraping portion and I'm confident the automation is capturing the correct table from the website. i'm also seeing an excerpt of the table within the Data Scraping sequence. might be with the ExtractDataTable variable? i have it as Data Table under variable type; Flowchart under scope and NewSystem.Data.Data.Table under Default. is this correct?
@@alainarielbendijo2939 Every step you did looks good. One thing I noticed, the url - google.com/covid19-map/?hl=en which I demoed in the video is now redirected to news.google.com/covid19/map?hl=en-IN&gl=IN&ceid=IN:en Could you please try one more time with new url - news.google.com/covid19/map?hl=en-IN&gl=IN&ceid=IN:en Please add this new url in Open Browser Activity and perform the Data Scraping on the web page directed by this new url If still the issue not fixed , could you please share your project with me at labqualityassurance@gmail.com?
Variables are used to pass data between activities of a specific workflow. Whereas, Arguments are used to pass data between different workflows Checkout this video for complete demo on arguments - ua-cam.com/video/QfCgvZcWwCQ/v-deo.html
Hey, I have a problem in Mailing section in smtp. There is a column for secure password along with email and password and i am not getting what to put in that. It always shows error. I hope you will give the solution to that.
I got an error mam. Message:the specified string is not in the form of required email address Exception type :system. Formatexception Please resolve it
Hi, are you trying to send email to multiple receivers? Also, please confirm that email address format is correct under the property filed - Receiver -> To, Cc , Bcc and, Logon -> Email Display Name (if you have created argument here as shown in the video, make sure that argument type is string)
Hi, just remove the properties->sender->From and Name. I also faced the same problem. I hope this link will help you. Link: forum.uipath.com/t/uipath-gmail-smtp-error/14288/6
Mam I got a runtime execution error says that Message:the process cannot access the file '(my file location) ' because it is being used by another process Exception type:System.IO.IOException Plz help me out mam.
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!
Madam Can u Plz provide this Project (ajit.chowdary@gmail.com)
Hi Ma'am - Is there any way to grab one data table - For .eg - Only of Japan? Also, We have to tap "OK" Each time to message in able to proceed further? So We have to remove the "Message" to make it in flow without an interrupt?
Please advice, Thank you! :)
you probably dont give a shit but does someone know a way to get back into an instagram account??
I somehow lost the account password. I love any tricks you can give me
hi ma'am, for me i am nt getting mail
Really help full mam
You have replied for everyone who had doubt. That's quite impressive... keep up the dedication. Happy Learning !!!
Thank you so much
Excellent tutorial. Thanks for including several concepts on a single video/tutorial.
You are welcome, keep learning!
@@qualityassurancelab7764 mam pls make a video cowin vaccine automatically book ... So pls make avideo step by step pls mam
ur explanation is very nice way madam
Superb explanation, clear cut explanation.....
What a crystal clear voice👌
Nice explanation thanQ
For those who couldn't get Column One, I used Data Scraping twice. first time as instructed in video, then second time is to obtain the list of countries.
nice explanation i would like to thank
You're welcome
wow its complete amazing.thanks to make my uipath learning so so esy.
It helped to understand scraping feature, thanks much (y)
Superb explain, very nice. Please try to provide such more insterting projects for brainstroming
Thanks its very very use full videos for biginers
Clear explanation useful video
Very concise tutorial. Thank you.
very good tutorial to learn uipath. very nicely explained.
Very nice video and superb explanation. please create more videos on Selectors and handling dynamic web elements. This wil b helpful for Real time projects.
Thank you, here you go for Selector Session - ua-cam.com/video/Z5QaaRoynLA/v-deo.html
Really awesome mam its so good please share more project mam
All concepts are packaged together beautifully Thank you so much for sharing this video with us.
Useful video. Thank you.
I have many things to learn from here.
Very informative video 👍🏻
Love u so much tqs for clear explanations do more videos on real projects mam it helps us
Supperrrr ma`am, thank you very much for this video....
Thanks very well explained
Thanks. Please create more videos on UI path.
Excellent project
Excellent explanation, thank you
This is very impressive. Put more videos on different cases. Best luck
Very informative pls do more like this
Thanks maa'm finally got the output
Sounds good!
Could you please let us know how you resolved the issue? It would help others if they face the same issue.
Thank you!
Thank you so much mam.. It helped me alot..
Great video!!! Thank you
quick and very useful. Thank you :)
Very useful .... Make some new real time application project on uipath plz
Thanks, I will share other videos too. Keep learning!
I had made this similar project on March months from extracting the vivid data from WHO website and rest of the details where same
Excellent and detailed informative video.
If possible, try showing the same in re-framework as well
magaling!
Which is better uipath or automation anywhere
Thanks for your videos, they are very useful. Hope you can create a tutorial about Recorder and Schedule Task in UiPath.
I am glad my videos are useful to you. I will share the requested videos soon. Keep learning and please share the videos with your friends.
Nice explanation I have tried and I get an error excel file is already used by another process or corrupted failed to open error....I got how can I resolve the issue
Hi mam,
Please show some video on servicenow tool data export
Thanks for the tutorial. However, wonder why we have to close the browser?
Hi andi which tool having good growth in future between uipath,RPA,protactor, Tosca
If you want to count how many countries we have in rapport, how can we do that? BTW - great tutorial as always, very clear from start to the end!
We can use a log message by putting a syntax in it. Let's suppose, if you have a data table variable called COUNTRY then you can write in log message Country.rows.count.tostring Your count will be appeared.
Brilliant
hi
I faced 2 issues while following this tutorial
1. Data is not persistent in the excel file, it automatically getting deleted on process termination.
2. Email thing is not working properly, it is saying "Username and password not accepted".
Please help.
Hi, for the first issue, please add output data table and message box to check the values fetched into the data table.
For second issue, Turn on less secured app security settings in gmail - myaccount.google.com/lesssecureapps?pli=1
the same issue I faced while running the program
@@kanishkkumar3585 2nd solution is correct
And I haven't checked 1st one
Because I figured out some another way to accomplish the task.
super madam
In host section port display name are same in all ?
yes, port display name is in small.
Hii mam..!! Can u pls suggest me some projects are in RPA using uipath...would be better for my academic curriculum..!!
Hi! Can I ask why you used a flowchart and not a sequence ? Im new to UIPATH, so I haven’t learned the difference yet. Also, great video!!
Hi Ousman, the difference between flowchart and sequence is that flowchart is used for small or easy projects whereas sequence is used when the project is very lengthy or difficult or you can say multiple activities are used in other language.
Thank you so much 🥰
I have a doubt. I followed all the steps as you mentioned but I dont know for some reason, the email part is not working for me. It gives username and password error. I have put in the correct email and password. smtp port as 587 but still getting error. tried it multiple times.
@Quality Assurance Lab I scrolled down for similar error and I found it. thankyou for this resolution. I m able to view the result now. Its working perfect. :) Thanks a lot for this project practice.
How can I add some buffer time? for some files, the data is not updated quickly and the bot moves on to the next task.
You can use Delay activity and provide delay time in miliseconds in the Duration property as - TimeSpan.FromMilliseconds(waitvaluein milisec)
@@qualityassurancelab7764 is there any video on how to add delay activity? Where can I find this? Where do I add code?
what is the arguement type that u r using in Email and paswrd?
Good explanation , could you please explain how to handle website failure exception ? Thank you
Hi, while trying to use a website like amazon or flipkart for extracting the data for all the models for a single product, the data extraction is working only for the first page, even though all the pages with the models for that product are being loaded.
Ma'am when I try to extract data using data scrapping tool it extracts only till recovered column and the column of death is left blank
good explanation but how do we come to know all these activities ?
hi in uipath we are using python or not
Yes, you can use Python, please refer - docs.uipath.com/activities/docs/invoking-a-python-script
Hi Timsi ,
Getting runtime error as "Uipath executor has stopped" and
20.4.1
Message: Job stopped with an unexpected exit code: 0x000000FF
Exception Type: System.Exception
RemoteException wrapping System.Exception: Job stopped with an unexpected exit code: 0x000000FF.
This is happening for me whenever there is an Excel application scope or Write range in our sequence or flow chart, Could you please suggest on this.
Hi, such error occurs when Excel is not supported by Uipath. Could you please let me know which version of excel and UiPath are you using?
@@qualityassurancelab7764 Okay , i had upgraded my excel and the issue is resolved , Thanks:)
rather then creating arguments do i create variables
yes, you can create variables
Hello,
My question is if i want to send mail to multiple user which I have maintained in my excel file, can we read this excel file and add all the recepient emails address and send mail to all.
Yes, you can send mail to multiple recipients by providing all email ids, separated by semi colon
Hello ma'am, I am facing problem in data scraping. 1st column data not coming in 1st column its coming in 1st row
Please reply and help me ma'am
Hi @@tinkumandal4830
If you observe, the entire first column(Location) is written on the single cell of the excel. If you click on A1 cell of your excel, you will get all location items present.
Reason -
When I created this project, all Location elements of the Web Table were present under td tag ( Element tags can checked from developer tool)
But now, the Web Table has been modified , location elements are under div tag within th tag.
Because of this, entire first column is written on the single cell of the excel. If you click on A1 cell of your excel, you will get all location items present.
So, yes, the Web table format which is extricated is off, I will work on the solution and will get back to you.
Hi Quality Assurance Lab Channel,
I tried to scrape data the same way you showed but am unable to scrape out entire table .
After clicking on "Worldwide" , the table is showing location columns as counts of Confirmed cases in the corresponding location. Please help me
Hi Priyanka, If you observe, the entire first column(Location) is written on the single cell of the excel. If you click on A1 cell of your excel, you will get all location items present.
Reason -
When I created this project, all Location elements of the Web Table were present under td tag ( Element tags can checked from developer tool)
But now, the Web Table has been modified , location elements are under div tag within th tag.
Because of this, entire first column is written on the single cell of the excel. If you click on A1 cell of your excel, you will get all location items present.
So, yes, the Web table format which is extricated is off, I will work on the solution and will get back to you.
Hello. While "Data Scrapping", only few are entries are getting written to the Excel. Not the entire data. Why so??
And for sending E-mail ; the port is "465" or " 587"; it is working for both. Which is the correct one?
Looking for a reply.
Thanks is advance.
Gmail is not allowing uipath studio to open mail id..can u suggest an alternative
mam I am facing source: smtp mail messege problem in which it is written wrong user name and password could not log in 535. 5.7.8 messege problem
Please enable less secure apps for you google account - myaccount.google.com/lesssecureapps?pli=1 and try again
@@qualityassurancelab7764 thankyou for this resolution. I m able to view the result now. Its working perfect. :) Thanks a lot for this project practice.
Hi Mam, My bot executed without any error but it didnt write any data extracted from the Datatable in the Excel sheet. This file displays blank data. Can you guide on why the bot didnt write any data in the excel sheet
Could you please try below steps and let me know the results:
Add Output DataTable Activity after Data Scraping Activity.
Move to properties -> Input -> DataTable . Provide the DataTable value ExtractedDataTable
Move to properties -> Output -> Text. Create a String variable (Say ExtractedData)
Add a message box and put the variable - ExtractedData
Run the project.
Please let me know if the message box displays the values extracted from the web table.
@@qualityassurancelab7764 Message box is displaying the values extracted from the web Table. Thank You for your guidance
Hello mam I m b.com graduate applying for a job for last 2 months but my profile is not getting shortlisted. Is there any way I could boost my profile??
Could you please send me email with your job profile at labqualityassurance@gmail.com, I'll take a look
@@qualityassurancelab7764 Thank u so much mam.
Hi Ma'am - Is there any way to grab one data table - For .eg - Only of Japan? Also, We have to tap "OK" Each time to message in able to proceed further? So We have to remove the "Message" to make it in flow without an interrupt?
Please advice, Thank you! :)
Yes, you can grab the table for Japan. For that, use activities to select Japan and click on that. Then capture the complete table for Japan.
Message boxes are only for debug purpose to check if the flow works fine or not. Those must be removed during the final execution to run the workflow without any interrupt.
@@qualityassurancelab7764 Thank you -
Also Is there any tutorials available of yours in which we can let browser open any URL of News and It grab the data listing ( Web Scrapping) and save it as Document file?
@@harshprajapati5392 Please checkout this to launch url, do data scraping and save result in csv file - ua-cam.com/video/lt2p2o_OhPg/v-deo.html
Moreover, in some cases of data scraping, you'll have to resolves several issues which occurs during web data extraction using Data . Please refer this for the same - ua-cam.com/video/CgqpSLerjLs/v-deo.html
hi mam i tried to built this bot
iam getting this error
Excel Application Scope: The given path's format is not supported
Hi, could you please share the File Path which you provided under Excel Application Scope?
@@qualityassurancelab7764 "C:\Users\Hemalatha\Desktop\Excel\Covid Report.xlsx"
Iam finding this error
Send SMTP Mail Message: 535: 5.7.8 Username and Password not accepted. Learn more at
5.7.8 support.google.com/mail/?p=BadCredentials 195sm13293450pfb.206 - gsmtp
@@hemalathaa7750 Could you please try again by Turning on less secured app security settings in gmail - myaccount.google.com/lesssecureapps?pli=1
My bot is running successfully but while doing data scraping ...datatable is not scrapping location column please help me
The data is not written in the excel sheet. It looks empty after compiling
Could you please try below steps and let me know the results:
Add Output DataTable Activity after Data Scraping Activity.
Move to properties -> Input -> DataTable . Provide the DataTable value ExtractedDataTable
Move to properties -> Output -> Text. Create a String variable (Say ExtractedData)
Add a message box and put the variable - ExtractedData
Run the project.
Please let me know if the message box displays the values extracted from the web table.
@@qualityassurancelab7764 No it was not print any values. table value is empty. plz let me know.
@@ss-ye6pl okay, was the data available in Preview Data section of Data scraping? What value you provided in Maximum number of results?
Also, please validate the selectors for all activities present under Data Scraping sequence.
@@qualityassurancelab7764 , Yes it was viewable only. The extractdatatable variable was duplicated. On post correct i am able to get the data's in output datable activity. thanks for reply.
@@ss-ye6pl Great, thanks for confirming
I learning 3 RPA tool mam uipath bp and AA I like all your video mam and i want more real time projects by you mam and I am waiting for AA 2019 video and make video about 3 RPA tool which is most used how we select tool mam
I am glad you found my videos helpful, I will share AA2019 and RPA tool comparison videos soon.
Keep learning and please share these videos with your friends as well.
@@qualityassurancelab7764 sure mam tq so much
I am not able to send the mail does it require 2 step verfication to be done for uipath
what error you received?
could you please try by turning on less secured app security settings in gmail - myaccount.google.com/lesssecureapps?pli=1
Hello Mam,
-> First the Library of video you have here is amazing thank you sharing Knowledge
-> In this particular tutorial and in upcoming tutorials, if you could not find options like
Open Application
, Open Browser, Attach Window, Attach Browser, Element Scope, Close Window, Start Process and more options.
Activities
brief comment.
Hello mam
Thanks for the video I am facing a small issue when i extract the data from the web its not getting store or saved in excel no errors is been given please help in solving this issue.
Hi, you are welcome!
During Data Scraping, did the datatable ExtractDataTable got created?
@@qualityassurancelab7764 ya it got created thanks for reply in variables I was Making mistake after that what's happening is is the location column am getting the data of cases all over the column
@@hemantkumargahlot287 If you observe, the entire first column(Location) is written on the single cell of the excel. If you click on A1 cell of your excel, you will get all location items present.
Reason -
When I created this project, all Location elements of the Web Table were present under td tag ( Element tags can checked from developer tool)
But now, the Web Table has been modified , location elements are under div tag within th tag.
Because of this, entire first column is written on the single cell of the excel. If you click on A1 cell of your excel, you will get all location items present.
So, yes, the Web table format which is extracated is off
Your videos are really helpful. But here having one doubt. Here what the ‘Sender - From’ property of ‘Send SMTP Mail Message’ specifies? How it is different from ‘Logon EmailId’ and what if we miss it or give some other mailId, other than the logon mailId? Thanks in advance.
Can you please provide the links for the details mentioned in the videos. For example, the covid 19 google portal link is missing.
1.data scraping activity
2.inside data scraping(workbook write range)
3.create one sample excel file
4.print the data
is it possible to execute without using excel application scope?????
Hi , I m not able to extract the particular element from website , can you please help me . when i try to do the whole page is getting selected and later pop up with "This control does'ntnot support"
i have excel 2007... is uipath not support...????
No, UiPath will not support. The UiPath.Excel.Activities pack is compatible with the following Microsoft Excel versions:
2010
2013
2016
Office 365
@@qualityassurancelab7764 that's why my projects not run
Hi. I cannot find where is extractDataTable to excel.
Only have 1 function is ExtractData. But UIpath say: "ExtractData" is a type, and cannot be used as an expression
Ma'am how if I only want to extract certain rows of data that contains certain text that I defined? For example I just want rows that contain text "In" and "United", so the output are like India, Indonesia, United Kingdom, United Arab Emirate etc
I am not able to sent the mail on mail IDs.
Error : The specified string is not in the form of required for an e-mail address
Exception Types: System.FormatException
Hey is there some way to use uipath for compiling reports from service now
Can we host workflow?
could you please explain more, where you want to host the workflow?
Hello mam, it is possible to get the job as a fresher in rpa uipath because when i search the job as a rpa developer i foud that all the jobs for experience atleast 2 and 3 year in IT. what is the way to get a job as a fresher.please guide me
when i add table via enternet explore they give message to install extension-for-edge.....?
Could you please let me know the version of Internet explorer and UiPath you are using?
hello. fully appreciative of the videos. they are very helpful.
I followed the steps to the letter but i seem to be having a problem saving the extracted table to the worksheet. the table won't save. I've also tried to add a Save Workbook activity but that doesn't work as well.
Thanks for your time and feedback.
Did you get any error or simply data not written to excel file?
Also. Could you please try below steps and let me know the results:
Add Output DataTable Activity after Data Scraping Activity.
Move to properties -> Input -> DataTable . Provide the DataTable value ExtractedDataTable
Move to properties -> Output -> Text. Create a String variable (Say ExtractedData)
Add a message box and put the variable - ExtractedData
Run the project.
Please let me know if the message box displays the values extracted from the web table.
@@qualityassurancelab7764 thanks for the reply. I'm not getting an error. the table won't write to the excel file. I also tried what you listed; adding an output data table after the data scraping activity. but the message box just comes out blank. I'm looking at the data scraping portion and I'm confident the automation is capturing the correct table from the website. i'm also seeing an excerpt of the table within the Data Scraping sequence. might be with the ExtractDataTable variable? i have it as Data Table under variable type; Flowchart under scope and NewSystem.Data.Data.Table under Default. is this correct?
@@alainarielbendijo2939 Every step you did looks good.
One thing I noticed, the url - google.com/covid19-map/?hl=en which I demoed in the video is now redirected to news.google.com/covid19/map?hl=en-IN&gl=IN&ceid=IN:en
Could you please try one more time with new url - news.google.com/covid19/map?hl=en-IN&gl=IN&ceid=IN:en
Please add this new url in Open Browser Activity and perform the Data Scraping on the web page directed by this new url
If still the issue not fixed , could you please share your project with me at labqualityassurance@gmail.com?
Does the count update automatically?
whats the difference between Variables and Arguments in UiPath
Variables are used to pass data between activities of a specific workflow.
Whereas, Arguments are used to pass data between different workflows
Checkout this video for complete demo on arguments - ua-cam.com/video/QfCgvZcWwCQ/v-deo.html
I am unable to find excel application scope but it. Is showing excel process scope
Hey, I have a problem in Mailing section in smtp.
There is a column for secure password along with email and password and i am not getting what to put in that. It always shows error. I hope you will give the solution to that.
Mam how to send the email to other person email id in uipath SMTP protocol
To send email to multiple email address, put semi-colon(;) between different email address in the Receiver Property (To/cc/bcc)
I'm not getting the above webpage
Please help me.. I have no data scraping, scraping in design.. How I take... Please help me.. Urgent
I got an error mam.
Message:the specified string is not in the form of required email address
Exception type :system. Formatexception
Please resolve it
Hi, are you trying to send email to multiple receivers?
Also, please confirm that email address format is correct under the property filed - Receiver -> To, Cc , Bcc
and, Logon -> Email Display Name (if you have created argument here as shown in the video, make sure that argument type is string)
Hi, just remove the properties->sender->From and Name. I also faced the same problem. I hope this link will help you.
Link: forum.uipath.com/t/uipath-gmail-smtp-error/14288/6
Ma'am can we use this automation in our website? If yes how?
Yes you can use. It will depend on your website and what you want to automate there
Mam I got a runtime execution error says that
Message:the process cannot access the file '(my file location) ' because it is being used by another process
Exception type:System.IO.IOException
Plz help me out mam.
I believe your Excel file was open when you ran the project.
Please close the excel file and try to run the project again.
I did close the excel file and tried it. But I still get the same error. Could u help me please
Hi... Can we get these data in every 10 min automatically.... Updated