How to Dump scarped data into database which is scraped using data scrapping


#1

Hello
I have already done save scrapped data into CSV file. But now I want to dump a data into database which is get by Data scraping.
Please help


#2

@swapnali1 Store your csv file to one Datatable and use connect activity to connect to database than use Insert data table actvity and pass csv Datatable variable With your database table name


#3

how to store CSV file in database


#4

@use read csv activity and pass that variable to Insert data table actvity as mentioned steps above


#5

thank you


#6

@swapnali1 Download attach file and change Db configuration and Db table name

CsvToDB.zip (2.0 KB)


Issues in UiPath connectivity with MySQL
Read data from excel attachment
ODBC Database Connection
#7

@indra thank you…


#8


Hello
I am scraping data with the help of Data Scraping in UiPath. And I want to store that scarped data into csv file. Above picture shows the how I am trying to create file. But it only create file data is not filled in it. But when I scrape data from flipkart It will genrate CSV file but when trying to scrape from google search it is not possible.
please help


#9

@swapnali1 Use @names while replying otherwise community member wont get notification to reply

From the above Extract Structure Data is not extracting so you are not able to store in csv. You can try this create new data table variabe and pass that in Extract Data Table actvity


#10

@indra ok thank you…I am trying by creating new variable but still it is not working.


#11

@swapnali1 I think selectors are changing please check it


#12

@indra Will you tell me, Can we scrape data from google search. in UiPath Data scraping. because when I am trying to scrape data from google search it can not work but when I am scraping data from websites like flipkart, amazon etc. It will work.
Please Help


#13

@swapnali1 you can scrap from google search


#14

@indra How?