Getting data from Website

[erguntmzkn]

Hi,

I want to pull data from a website which contains publicly available data (which means there is no illegal situation) from website

http://www.fittingo.com/Kalori_Cetveli.aspx

There is a box which you can type the food (in Turkish) that you want to learn its calories and other values. Lets say this website is a kind of myfitnesspal for Turkish foods.

Is there any way to pull data from this website?

Thanks.

[Kyle123]

I haven't got time right now to finish this off for you - I don't know exactly which data you want to extract, but this pulls it all back for a given search term.

Please Login or Register  to view this content.

[Kyle123]

Also:
Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

[erguntmzkn]

Ok. I got the point. Sorry for crosspost.

[erguntmzkn]

Additionally,

I have tried your code which you stated on your previous post but nothing happened. Actually I want to pull all the data. On the website when you type the food that you ate you may learn the calories or etc. inside it but I need a complete list of this. Since I can not type c. 5k different foods/drinks easily, I need some tools to pull the data from there. Can you help me please?

Thank you.

[Kyle123]

It prints the output to the immediate window, do you have it open?


Sent from my iPhone using Tapatalk

[erguntmzkn]

I have opened a new excel sheet and inserted a module. Then pasted your code and let it run. But nothing happened. The website is open in IE btw.

[Kyle123]

You need to view the immediate window, it's in the VBA IDE

[erguntmzkn]

Oh sorry. I got it now. Is there a way to pull all data without entering search term? Many thanks by the way.

[Kyle123]

I don't think so, the most I could get the service to return was 60 records, so I'm guessing that's the hard limit - (by entering a blank search term). You could perhaps loop through the alphabet?

[erguntmzkn]

Ok. I am trying to cover all the possible probabilities of foods/drinks. But one last question. I wrote that you could got 60 records and that was the hard limit. What if I type lets say "ab" and the foods include the letters "ab" are more than 60? Will I get a result of 60 or more?

Edit : I have tried it by typing "ab" and got the result of 60 items. So that means it is the limit but is there a way to overcome?

[erguntmzkn]

I don't think so, the most I could get the service to return was 60 records, so I'm guessing that's the hard limit - (by entering a blank search term). You could perhaps loop through the alphabet?

I have typed down all the letters that is possible to the excel file and could you please tell me is there a way to automatize this ? Because it takes too long to change the letters every time.

Many thanks.

[erguntmzkn]

Hi again. I am still trying to get this data via excel but the code that is stated below takes too long to get the data appr. 10 days.
Is there a way to fasten this ?

Thanks.

Please Login or Register  to view this content.