CSV to XML

[jencinas69]

Hello I have to conver a CSV file to an XML file, I never done this before. Any one have had experience with CSV to XML?

here is a link to my csv file

media.yumasun.com/xml/csv.php

Thank you

Joaquin Encinas

 

[k5tm]

Joaquin,

Well, it is not a CSV file, so perhaps you can explain your problem a bit better...


Tom Morrison

http://www.liant.com

 

[jencinas69]

It is a parsed csv file that I need to convert to XML. Do you know a way to do it?

Thank you

 

[Diancecht]

CSV are just a bunch of values separated by commas. To convert it to XML first you need to define tags, so there's no way to help you without more details.

Cheers,
Dian

 

[jencinas69]

This is the tags I need

<ad adID="12345"
-
startingPrice="27995.00"
-
>
<title>
<![CDATA[2005 Toyota Truck $27,000]]>
</title>
<description>
<![CDATA[12,594 miles, $400/month]]>
</description>

But I need something that converts the csv into this dinamicaly

 

[Miros]

Since you've already got a parser (more or less), you simply need to add the appropriate tag to each output line instead of just writing the variable. If you're parsing with a loop in your php file, just make an array of the tag text.

I suspect there's a small problem with either your parser or your data in this area of your file:

CERTIFIED LIFEGUARD Seasonal, 30-40 hours/week, non-exempt, not-eligible -for-benefits position OPENS:


May 2, 2008 CLOSES:

since the closing date doesn't show up.

 

[lode004]

if you are using php you might want to read the info on the fgetcsv function:

http://www.php.net/manual/en/function.fgetcsv.php

there s some very good examples on how to loop trough an csv file

while looping trough the csv file you could use the simplexml (buildin) class or the safox class (sourceforge) to write to your xml file