Sure, this can be done - as a simple generic solution, consider the following example, which creates a document element of <records> with each record output within a <record> element. The only caveat would be that all field names are valid XML element names so i've included an str_replace call to ensure that any spaces are converted to underscores in the element names of each field (created from each key in $record)...
Hi bayuobie,
Sure, this can be done - as a simple generic solution, consider the following example, which creates a document element of <records> with each record output within a <record> element. The only caveat would be that all field names are valid XML element names so i've included an str_replace call to ensure that any spaces are converted to underscores in the element names of each field (created from each key in $record)...
<?phpheader("Content-Type: text/xml");
require("MagicParser.php");
function myRecordHandler($record)
{
print "<record>";
foreach($record as $key => $value)
{
$key = str_replace(" ","_",$key);
print "<".$key."><![CDATA[".$value."]]></".$key.">";
}
print "</record>";
}
$filename = "data.csv";
$formatString = "csv|44|1|34";
print "<records>";
MagicParser_parse($filename,"myRecordHandler",$formatString);
print "</records>";
?>
Simply edit $filename and $formatString as required for your CSV source, and that should do the trick!
Hope this helps!
Cheers,
David
--
MagicParser.com