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.
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