Import data and scrape

### Description


Scraping/Excel/SQL Server Tables

Hi can look at our browser([url removed, login to view]) and see we have sites for many icon in our tool bar that take users to view special sites for that specific category.

Task #1: Import data from SS Given To right category. we have like 20 simple SS with sites that you need to enter to any of the 10-12 categories.

We like to fill this info from taking the attached Spreadsheet and add it to the correct category

(if any questions let me know). DO duplicated and all sites in right category. No excpetion

we will show. some SS like 2-3 and about 100 sites in each you have to divide them across 2 categories.

I can give you access to our SQL Server to work and upload all to the empty tables

and for the ones you are adding. You need to create 6 new tables same format like we have now.

for these new icons we might needs to create similar tables like for: Movies, Holiday, Food, etc

You can do that on DB end. All sites unique no duplicate and addition of all sites listed in Sheet(look at additional Tabs also) to the right category/icon we have and the new icons..not shown and for that u create the tables and their site data based on same structure like other live icons/tables.

Task #2:

web scrape a site with a lot of sites and add(no duplicate) to our right categories.

This will be done via script and not manually. site and what we want to scrape will be given

Data from #2 will be entered to correct tables - estimate data to scrape about 50K-100K can be much less. All auto scraping from various site sections. I want a master scraper on this

if you do not know how to do it. do not bid. u must know how how to scrape with app from a site and import all links and their associated category. also some categories i will give you are found only in search and u will need to do those. so web scraping and import to our tables and added to our content

* IMPORTANT: you might need if we request ti divide all links by 3 age groups. No exception

ofcourse u will get guidance.

Task # 3: see doc attached + more

Habilidades: MySQL, SQL

Veja mais: what data structure, what are data structure, web for create icon app, tables in data structure, simple data structure, search data structure, questions of data structure, new spreadsheet app, new data structure, data structure questions, data structure.com, app script spreadsheet, about data structure, how to master excel, sql import, simple web scraping fill in a spreadsheet with data, scrape for links, scrape excel, scrape a web, master data, import sql, excel with sql server, create simple task app, create simple scraping, groups auto

Acerca do Empregador:
( 59 comentários ) Northridge, United States

ID do Projeto: #3055103

2 freelancers estão ofertando em média $340 para esse trabalho


See private message.

$255 USD in 10 dias
(0 Comentários)

See private message.

$425 USD in 10 dias
(2 Comentários)