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.
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 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.
@@qualityassurancelab7764 thankyou for this resolution. I m able to view the result now. Its working perfect. :) Thanks a lot for this project practice.
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??
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
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 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 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.
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
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.
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.
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
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.
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
Hello! Please I need help I am automating web scraping. I have the following problem: the site opens a new tab automatically. UIpath can open the new tab, but it returns automatically to the initial page (so, I cannot make clicks, etc on the page opened). I used the command Ctrl + Tab, but didnt work. How can I solve this? This is the example: 1: ibb.co/tBrcBbY 2: ibb.co/n3bth7w 3: ibb.co/3mQTvzK Thanks!
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.
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"
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
Please let me know at what activity this error was thrown? Also, was the webpage with title coronavirus (COVID -19)- Google News open, when you get the error ?
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.
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.
My data is not reflecting in excel sheet. No error m getting. message box displayed "data is extracted".. please help --> i tried using output table also.
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?????
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
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
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.
RemoteException wrapping System.Exception: Job stopped with an unexpected exit code: 0xC0000005 what can be the problem for this error it always come when i executed the above task.
You will have to update the Excel package. Please follow the below steps: Step 1. Move to Project Tab - > Dependencies Step 2. Right Click on Excel.Activities and click on Manage Step 3. Select the package “UiPath.Excel.Activities” Step 4. On right Pane, click on update
Hello! If I run this scenario which is on the video I've get this error prntscr.com/srkw1m. But if I open my excel file and run then all work ok, which actions I should select if I don't want open my file before?
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.
@@namespace5227 Such error mostly occur due to installation of the any Antivirus software in the system. Could you please disable antivirus temporarily and try again?
Hi it worked for me. After two days I have run these file But it's sending the same data which is first day scrapped. Can't we send this update data without editing the .xaml file
when i use datascrapping for covid table, the coulmn are getting misplaced ex : column1 is supposed to be 'location' .but i am getting all the values of locations names in column1.
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 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lt2p2o_OhPg.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 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-CgqpSLerjLs.html
please enable 2 step Authentication and generate App password - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-LI7RezRh76E.html Provide that app password in the project and try to execute again
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.
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