[SOLVED] Can you convert a XML file to a .CSV

[mazman13]

Is it possible to convert an XML file to a .CSV.

 

I'm waiting to store a feed in a table...and I didn't know if that was

possible.

Thanks

[Barand]

sample

<?php
$str = '<rss>
<channel>
</channel>
<item>
       <a>aaa</a>
       <b>bbb</b>
       <c>ccc</c>
</item>
<item>
       <a>ddd</a>
       <b>eee</b>
       <c>fff</c>
</item>
<item>
       <a>ggg</a>
       <b>hhh</b>
       <c>jjj</c>
</item>
</rss>';

$xml = simplexml_load_string($str);

$fp = fopen('my.csv', 'w');
foreach ($xml->item as $i)
{
    fputcsv($fp, get_object_vars($i));
}
fclose($fp);
?>

my.csv-->

aaa,bbb,ccc
ddd,eee,fff
ggg,hhh,jjj

[mazman13]

Wow. That's simple. I didn't even know you could do something like that. Thanks!