?
Solved

Pls explain how to grab text from a website

Posted on 2008-10-17
7
Medium Priority
?
362 Views
Last Modified: 2013-12-13
My background:
Total new to programming language
Linux web hosting
I will hire someone to achieve this task.

Dear experts

I plan to grabs some texts and images from a classified website.
I need to know how things work so that I can explain to programmers what I need to achieve.
The programmer will need to create an automated tool.
The main page of the website are updated every few minutes with new listing.
The tool will need to click on each of this listing, and grab Topic, Description, Image etc from the listing and put into a database... The tool will also need to check the main page for un-grab listing hourly.
My questions
a, Is this call data parsing?
b, what programming language are commonly used to create the tool? Can php be use?
c, once the programmer create the codes, I will put the files in my linux web server and run it myself . Is this alright?
d, the tool will grab the data and put in MYSQL?

Did I left out anything that worth mentioning?
Your details explanation is much appreciated.
thx


0
Comment
Question by:royalgoldleaf
[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
  • 3
  • 3
7 Comments
 
LVL 26

Expert Comment

by:Umesh
ID: 22745737
I think php,perl or any shell script will do this stuff..

PHP -> use curl to grab text from remote web site, extract the required data from the copied text & put this into MySQL
 
Bash/sed/awk - > Using lynx copy the entire text    into a text file, extract the required data and format according to MySQL compatible (csv or tsv) and just load this into MySQL (using heredoc, non-interactive mode).

Perl-> can be done...
0
 
LVL 5

Expert Comment

by:RightNL
ID: 22747518
have a look at snoopy
it's a really nice class that does it for you..
snoopy.sourceforge.com  
0
 
LVL 5

Expert Comment

by:RightNL
ID: 22747531
sorry I didn't fully read the threath ;)
it can all be done in php...
using snoopy you'd grab the full page and then strip out the stuff you like and put it in the database..
any php programmer should be able to do this..
 
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:royalgoldleaf
ID: 22749160
Any pre-written scripts that i can customize to do the job?
Cant find in snoopy..
0
 
LVL 26

Accepted Solution

by:
Umesh earned 1000 total points
ID: 22755803
0
 
LVL 5

Assisted Solution

by:RightNL
RightNL earned 1000 total points
ID: 22755843
snoopy can be found : http://sourceforge.net/projects/snoopy/
it's a highly customable php class. which you can just point the url to...
 
0
 
LVL 26

Expert Comment

by:Umesh
ID: 22887433
Thanks for the points!

Thanks,
Umesh
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.
Suggested Courses

752 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