Need advice from someone who is an expert in Excel VBA, SOLR, Elasticsearch for which would be the best way to organize data through scraping

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

Please note: this project is only for ADVISING – so should not take more than 1-2 hours of your time. If you’re interested in actual implementation of this, please message separately BUT FOR NOT ONLY BID FOR ADVICE.

Need advice from someone who is an expert in Excel VBA, SOLR, Elasticsearch for which would be the best way to organize data through scraping

1. We have around 2000 categories (3rd level, Level 1 is around 12 only) for our internal website

2. We have a “historical database” (excel file) of over half a million items sold, each item showing which of the 2000 categories it belongs to, fields such as Brand, Model, city/state/country, serial number, year of manufacture, etc.

What we want to do:

1. We want to “scrape” over a 100 other “source sites” which offer the same items and list them as an “aggregator” website.

2. Each of these source sites have their own category structure, and number of categories can vary from none to a couple of hundred, but substantially less than our 2000. The OBJECTIVE is to map each of their items to one of our (3rd level) 2000 categories.

I don’t have experience in data analysis or programming, hence am relying on freelancers to create my product. I would like someone who is an expert in this to advice which would be the best way to go about doing this. Without being an expert, and with my limited understanding and research, I have some insights (which, mind you, may be naïve or amateurish) on how to go about doing this and here’s a one pager: [login to view URL]

I would like you to create a similar brief document of a few pages on what you feel would be the best way to go about achieving the OBJECTIVE stated above.

Apache Solr Elasticsearch Excel VBA Software Architecture Web Scraping

Project ID: #17650195

About the project

8 proposals Remote project Active 5 years ago

8 freelancers are bidding on average $113 for this job

schoudhary1553

Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 390 + projects with 100% client satisfaction. I can help you More

$250 USD in 4 days
(173 Reviews)
7.5
waema

as i understand u need to scrap websites with different category than your site and import their data into your own categories. I don't think u need vba for this. The scraping bot will take care of all their categories More

$150 USD in 3 days
(97 Reviews)
6.8
DarkKnight2206

I am a python developer.\nI have great experience in web scraping and I am an expert in it.\nI have all necessary skills by which I can scrape any website. I have even scraped sites like google, whatsapp web, etc. whic More

$250 USD in 2 days
(34 Reviews)
5.5
vmadhavan15

BUT FOR NOT ONLY BID FOR ADVICE... I have 16 years of expertise with various project exposure.. Please ping me if you are interested with my proposal and thank you..

$55 USD in 3 days
(21 Reviews)
4.8
rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself for this project. please contact with me. Thanks.

$45 USD in 1 day
(3 Reviews)
3.8
nehameshram13

Hello Client, I have read your requirement about -an expert in Excel VBA, SOLR, Elasticsearch and I am sure I can complete it as per the given description. I do have skills like Software Architecture, Web Scra More

$51 USD in 3 days
(0 Reviews)
0.0