Converting XML to CSV?

Discussion in 'Mac Apps and Mac App Store' started by oli2140, Jun 10, 2009.

  1. oli2140 macrumors 6502

    Joined:
    Jan 13, 2008
    #1
    Hi all,

    Anyone know of an easy way to convert XML files to CSV files?

    Thanks
    Oli
     
  2. SilentPanda Moderator emeritus

    SilentPanda

    Joined:
    Oct 8, 2002
    Location:
    The Bamboo Forest
    #2
    Depending on the XSD your XML might not fit well into a CSV format. We'd probably need to see some example data or the XSD.
     
  3. oli2140 thread starter macrumors 6502

    Joined:
    Jan 13, 2008
    #3
    Here's an example, note that it does have embedded picture links :eek:

    Code:
    <?xml version="1.0" encoding="UTF-8" standalone="yes">
    <Directory>
    <students>
    <fullname>NAME</fullname>
    <email>EMAIL</email>
    <mobile>MOBILE</mobile>
    <house>HOUSE</house>
    <dob>DOB</dob>
    <national1>NATIONALITY1</national1>
    <flag1 href='file:///...example.gif'></flag1>
    <jointime>3rd Year</jointime>
    <futureplans>FUTURE PLANS</futureplans>
    <yourspace>TEXT</yourspace>
    <profpic href='file:///Link To Picture.jpg'>
    </students>
     
  4. angelwatt Moderator emeritus

    angelwatt

    Joined:
    Aug 16, 2005
    Location:
    USA
    #4
    I generally have used XSLT to do the conversion. It's not too complicated once you learn the basics. I've also used it for converting XML into vCards and iCal files. Unfortunately it's hard to find a direct tutorial for doing this XSLT so I can't link much at the moment.
     
  5. angelwatt Moderator emeritus

    angelwatt

    Joined:
    Aug 16, 2005
    Location:
    USA
    #5
    How are you wanting to handle those embedded links i.e., skip them, just have the URL, etc.?
     

Share This Page