Cancelled

Excel Data Scraping Macro Script.

Hi to all,

We are small trading company in need for a custom made excel macro script.

Nature of the script is scarping of certain data from predefined set of websites.

Initial requiremant is script working with one website and then (due to different html structure of these websites) this functionality should be expanded to other websites of interest.

This is in short the idea behind the macro.

We would be using some screenshots in order to properly define what we need.

----------------------------------------------------------------------------------------------------

We have excel file and in one of the colums we have list of keywords. These keywords vary in size and they are sometimes only numbers, sometimes they are alphanumerical etc... keywords represent certan models, types or serial numbers of various devices like washing machines, dryers, owens, refrigirators etc...

This keyword list is the input data for the script.

Screenshot1: [url removed, login to view]

* Macro should take the first keyword, navigate the the specific website (you have the website address on the screenshots) use the search function on the website and preform the search for the specific keyword.

Screenshot2: [url removed, login to view]

* If there are search results for the keyword it should take the the specific data P1 and write it

in the column P1.

Screenshot3: [url removed, login to view]

* Then it should click on that product in order to enter the product page and for the specific keyword used in this exmple (100226) this product page looks like :

Screenshot4: [url removed, login to view]

* Then script should take P2, P3 and P4 data from the page and import it to the excel file:

Screenshot5: [url removed, login to view]

Screenshot6: [url removed, login to view]

After this step macro takes the next keyword and repeats the process while all keywords are processed.

----------------------------------------------------------------------------------------------------

Specific cases:

1. If there are no search results for some of the keywords, data fields P1 to P4 are left blank.

2. If there are more then one search result (2nd keywords in the exapmple file "101360")

script goes throught out all of them and separate the data in the P1 to P4 fields by ( ; ).

Screenshot7: [url removed, login to view]

Screenshot8: [url removed, login to view]

Screenshot9: [url removed, login to view]

----------------------------------------------------------------------------------------------------

Number of the keywords and their shape (numerical, alphanumerical...) may vary.

Macro should be able to handle unlimited number of keywords but usually there wont be more then 50-100 entries processed in a single run.

This script should work with the website used in the example but it would be extended to do the same thing on other websites of interest in the future so should be left "open" for extension.

Sample file used in this discription is available for download.

If additional information is needed we are available.

Thank you

Dean

Skills: Excel, Visual Basic

See more: what is data structure in c, what is data structure, what is data input, what is data in data structure, what is a data structure, what data structure, what are the types of data structure, what are data structure, use of data structure, types of use cases, types of data structure, types data structure, set in data structure, set data structure, search data structure, process data structure, list of data structure, list in data structure, list data structure, different types of data structure

About the Employer:
( 0 reviews ) In?ija, Serbia

Project ID: #9541888

Awarded to:

magentapowa

Hello Ok I just checked the code of the site and it is an easy task. I have a lot of experience scraping data with VBA, you will not be disappointed. Every website has a different source code so I will have to writ More

€90 EUR in 2 days
(3 Reviews)
1.6

21 freelancers are bidding on average €120 for this job

€230 EUR in 4 days
(226 Reviews)
7.1
€250 EUR in 3 days
(223 Reviews)
7.4
gokulanand

Hello I can get you a VBA Macro that does this job in the next 24 to 48 hours. Do let me know if you are interested Thanks

€90 EUR in 1 day
(86 Reviews)
5.9
dpune

Hi, I have more than 14 years of Web Scarping and VBA/Excel exp and I am expert in this kind of work. I have completed more than 270 projects. Please look at the feedback left by my employers to know more about More

€250 EUR in 15 days
(87 Reviews)
6.0
SigmaVisual

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of my similar experience: Amazon/Ebay Bots: [login to view URL] More

€147 EUR in 7 days
(15 Reviews)
5.4
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready More

€155 EUR in 3 days
(39 Reviews)
5.5
€50 EUR in 1 day
(6 Reviews)
3.9
vw7209238vw

Hi, I can do thata easy. I understood all you need. Have enough experience scraping and probably finish it shortly. You can see those videos when I show you some scraps done by me. [login to view URL] More

€99 EUR in 3 days
(4 Reviews)
2.8
mrdja962

Zemljace! Mislim da mogu da uradim ovo sto ti hoces . Meni je potreban prvi pozitivan posao i mislim da mozemo da se dogovorimo oko cene. Pozdrav!

€177 EUR in 3 days
(0 Reviews)
0.0
valeratomsk

Hello! I can do the job for 3-4 days. I've done a prototype application that can make web-queries and put the results in a worksheet cells. While it can not add new rows in the case when a search results contains More

€111 EUR in 3 days
(0 Reviews)
0.0
deliveryweb

I did a lot of scraping and excel generation. this wuote is reasonable. new on site so not that many reviews yet

€166 EUR in 4 days
(0 Reviews)
0.0
kattikartik

I have great amount of experience in building applications using excel macros. I have been working on excel macros for good bit of time. I'm confident that I can handle this project very well. If interested contact me More

€155 EUR in 3 days
(0 Reviews)
0.0
changbaisan

Hi, I’m pleased to check this project here as it perfectly match with my area of expertise. So if you need good quality work asap, then you can hire me. Now we can move forward to more details. I always do care o More

€155 EUR in 3 days
(0 Reviews)
0.0
Siegfr76

I will only work for your good feedback with a minimal cost. Trying to build client base with quality works. You will be satisfied.

€30 EUR in 5 days
(0 Reviews)
0.0
sulmanmughal

i will do it in less time and budget. i am new here to work. i am willing to do it. i am very hopefull to avail this chance to get my profile strong.

€34 EUR in 3 days
(0 Reviews)
0.0
justmilan

Pozdrav, imao sam danas vremena, pa sam uradio tabelu koja ti je bila potrebna. Ako zelis mozemo da se dogovorimo i van freelancer sajta. Pozdrav, Milan

€34 EUR in 3 days
(0 Reviews)
0.0
youthpassion

HI, I am a young enthusiastic IT Professional over 6 years of work experience in developing web based & desktop solutions as a software engineer. I have good command over Asp.Net, VB, C#, C++, SQL Server, JQuery, JavaS More

€75 EUR in 3 days
(0 Reviews)
0.0
web2printexpert

I have done similar task before but I need in more details from you to estimate sum and terms I have big experience (since 2004) in QB/Shopify API, MS Access, Visual Basic, VBA, Excel, Word, Visual [login to view URL], C# , C More

€34 EUR in 3 days
(0 Reviews)
0.0
€155 EUR in 3 days
(0 Reviews)
0.0
tmanikanta

Hello sir, I am a professional writer and I have written about 200 articles to my us client last month. I will provide my past work samples if you agree. the work will be quality and without grammer mistakes. If you wa More

€30 EUR in 7 days
(0 Reviews)
0.0