Website to CSV

Reply

Join Date: Aug 2007
Posts: 64
Reputation: nil_gh_80 is an unknown quantity at this point 
Solved Threads: 0
nil_gh_80's Avatar
nil_gh_80 nil_gh_80 is offline Offline
Junior Poster in Training

Website to CSV

 
0
  #1
Dec 18th, 2008
Dear members,

I'm in serious problem. I need a tool which can get all content information of a website and at the end these information will produce a CSV. That CSV will be imported in another database...can anyone help me regarding this issue..
Reply With Quote Quick reply to this message  
Join Date: Aug 2007
Posts: 64
Reputation: nil_gh_80 is an unknown quantity at this point 
Solved Threads: 0
nil_gh_80's Avatar
nil_gh_80 nil_gh_80 is offline Offline
Junior Poster in Training

Re: Website to CSV

 
0
  #2
Dec 18th, 2008
come on man some one plzzzzzzz rply
Reply With Quote Quick reply to this message  
Join Date: Aug 2007
Posts: 8
Reputation: gotmick is an unknown quantity at this point 
Solved Threads: 0
gotmick gotmick is offline Offline
Newbie Poster

Re: Website to CSV

 
0
  #3
Dec 27th, 2008
Originally Posted by nil_gh_80 View Post
I need a tool which can get all content information of a website and at the end these information will produce a CSV. That CSV will be imported in another database...can anyone help me regarding this issue..
Can't you just use phpMyAdmin? It will export as csv, but why csv over sql? Are you just moving the site?
Reply With Quote Quick reply to this message  
Join Date: Apr 2008
Posts: 10
Reputation: joshmac is an unknown quantity at this point 
Solved Threads: 1
joshmac joshmac is offline Offline
Newbie Poster

Re: Website to CSV

 
0
  #4
Dec 27th, 2008
I've used something like this:

  1. ini_set ('display_errors', 1);
  2. error_reporting (E_ALL & ~ E_NOTICE);
  3.  
  4. ##################################################################
  5.  
  6. $csv_output = "Last Name,First Name,Address 1,Address 2,City,State,Zip,Phone,Email,DOB,Member";
  7. $csv_output .= "\n";
  8. $result = mysql_query("SELECT * FROM members");
  9.  
  10. while($row = mysql_fetch_array($result)) {
  11. $csv_output .= "$row[last_name],$row[first_name],$row[address1],$row[address2],$row[city],$row[state],$row[zip],$row[phone],$row[email],$row[age],$row[member]\n";
  12. }
  13.  
  14. header("Content-type: application/vnd.ms-excel");
  15. header("Content-disposition: attachment; filename=" . date("Y-m-d").".xls");
  16. print $csv_output;
  17. exit;

I hope this helps.
Reply With Quote Quick reply to this message  
Join Date: Jan 2009
Posts: 1
Reputation: toolsmith is an unknown quantity at this point 
Solved Threads: 0
toolsmith toolsmith is offline Offline
Newbie Poster

Re: Website to CSV

 
0
  #5
Jan 4th, 2009
Originally Posted by nil_gh_80 View Post
Dear members,

I'm in serious problem. I need a tool which can get all content information of a website and at the end these information will produce a CSV. That CSV will be imported in another database...can anyone help me regarding this issue..
Hi: I have had great success building scripts over the last several years that convert websites to csv and other formats. A previous project mined data from over 300,000 pages. I would need more information to be sure I can help you, as much depends on the structure of the data on the original site. Please contact me if you would like to discuss this further.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC