Forum Moderators: open

Message Too Old, No Replies

XML to MYSQL database

         

matthewamzn

4:43 pm on Aug 13, 2005 (gmt 0)

10+ Year Member



I currently have a site where people can search through a mysql database with a php script. I would like to add some more data to the database, but I can only get an xml feed.

Is there a way to convert the results of a xml datafeed to a txt or csv file? Then I could insert it into my database.

dmorison

4:49 pm on Aug 13, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Microsoft Excel (as of version 2003 I think) will have a stab at opening any XML document. You can then save it as CSV file using the normal File, Save As... functionality.

choster

4:01 pm on Aug 18, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



See for instance, at the XSLT FAQ, [dpawson.co.uk...]
.