nice descriptive subject there
okay, I
am now fine with putting CSV data into mysql database and doing stuff with it from there. easy.
but then I come across crazy merchants with xml feeds! really what are they playing at, anyway its just your normal xml like:
<?xml version="1.0"?>
<Products>
blah blah
</Products>
with lots of stuff in the middle that I want.
I was hoping excel would open it up how I wanted, but it hasn't so im a bit stumped as to where to go next.
Idealy Id like some script to parse that into proper CSV then I could run thatthrouhg the other script wich puts it into database. But if thats going to be a bit tricky just something that could get it as CSV on my computer and id upload from there.
Just looking for pointers really, what should I be searching for?
as always, help much appreciated