?
Solved

extract data from web

Posted on 2011-03-18
8
Medium Priority
?
184 Views
Last Modified: 2013-11-19
Hi,

collecting data from websites manually is very hard and time consuming, I'm looking for free application to extract data from web and put it in database or file. for example: I need to get the university information (faculties, department, members, contact information .. etc )

I found different application, but it is not free and hard to learn and customized. can you please guide me to find easy, free and powerful application that do the example mentioned above in a short time.

thanks
0
Comment
Question by:nmokhayesh
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 75

Expert Comment

by:Michel Plungjan
ID: 35170400
0
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 35173465
Do you want to search the contents of web sites, or do you want to copy the web sites?
0
 

Author Comment

by:nmokhayesh
ID: 35173574
I need to copy selected contents
for instance
list of all professors names and their contacts (email , tel, website, research interests)
list of all departments and contact information
list of schools and programs discription in each one

thank
 
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 111

Expert Comment

by:Ray Paseur
ID: 35173641
I have used httrack and it worked fairly well to make a copy of the web site onto my hard drive.  Selection of the contents was still the major issue.  Although the local web site was faster than using the internet, you would still have to manually or programmatically isolate the information you wanted to keep.

It might be possible to get a copy of Wrensoft Zoom Indexer and use that to spider the site.  Caveat: I have never tried that on a site that I did not control.

One other possibility might be to contact the site owners and ask if they can isolate this information for you.  Educational institutions are often willing to help with requests like this.
0
 

Author Comment

by:nmokhayesh
ID: 35216825
OK I need to extract selected data from some university web pages to XML or excel sheet file using web scraping software

can you please tell me which free web scraping application can do this job in easy way. I search it but i got a lot of application but I do not know which one is useful/efficient

Thanks
Naif
0
 
LVL 111

Accepted Solution

by:
Ray Paseur earned 1500 total points
ID: 35220096
There is no "easy way" because there is no clear vision of what you want to extract.  Each university web site is likely to be a bespoke application, so each such scraping and extraction algorithm will require custom programming.

That is why I recommended that you contact the site owners and ask if they can isolate this information for you.
0
 

Author Closing Comment

by:nmokhayesh
ID: 36710149
still not solved 100%
0
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 36710198
No, it will never get solved 100%, full stop.  Here is what you asked for back in March (how many months ago was that?)

...find easy, free and powerful application that do the example mentioned above in a short time.

It would surprise me if you find easy, free and powerful all in the same package.  Those things are like Ohm's law.  Fix any two variables and the third is determined.
0

Featured Post

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to write a Context Sensitive Help (an online help that is obtained from a specific point in state of software to provide help with that state) ,  first we need to make the file that contains all topics, which are given exclusive IDs. …
Although a lot of people devote their energy toward marketing for specific industries, there are some basic principles that can be applied to any sector imaginable. We’ll look at four steps to take and examine how those steps were put into action fo…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.
Suggested Courses

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question