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

@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

how to store CSV file in database

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

[1] 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 …

@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

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

@swapnali1 I think selectors are changing please check it

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

Help

indra (Indra) July 6, 2018, 6:49am 6

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

CsvToDB.zip (2.0 KB)

How To insert Excel file data into MS SQL table

Your XAML Solutions for most common issues (WIKI POST, anyone can edit)

Reading Excel and inserting in to MS SQL server db

Issues in UiPath connectivity with MySQL

How can i create a table in sql server from excel file using UIpath and insert the same excel data?

How to insert a excel file in to Data base using Uipath

Read data from excel attachment

ODBC Database Connection

How could i store "DataTable" data in Database?

Issue @ DB insertion using "LOAD DATA LOCAL INFILE"

How to add excel data to mysql

Topic		Replies	Views
How to store scraped data into database Help	8	3135	August 6, 2018
Data Scraping then write to CSV file Help	9	4052	September 15, 2019
Very basic question about web scraping Studio activities , data_scraping , question	3	883	March 24, 2020
How to store a scrapped data to database Help database	1	1218	February 20, 2019
Web scrap and SQL database Studio datatable , studio , data_scraping , question , sql	3	1810	March 8, 2021

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

Related topics