WEB XML to CSV??! anyone know how

Discussion in 'OT Technology' started by LowClass, Oct 16, 2009.

  1. LowClass

    LowClass New Member

    Joined:
    Sep 5, 2007
    Messages:
    890
    Likes Received:
    0
    Location:
    USA
    I have a bunch of XML docs i need to convert to a CSV. I am no programmer. I search the google machine and i downloaded some freeware.... but it didnt exactly let me map anything and convert it.

    ANyone know how to do this fairly simple, maybe even a script or something i could run on it? anything?
     
  2. SLED

    SLED custom title

    Joined:
    Sep 20, 2001
    Messages:
    28,122
    Likes Received:
    12
    Unless the XML is flat (which would somewhat defeat the purpose of xml) then you can't really create a "spreadsheet" out of the data
     
  3. LowClass

    LowClass New Member

    Joined:
    Sep 5, 2007
    Messages:
    890
    Likes Received:
    0
    Location:
    USA
    It is sort of flat. the data is all lined up that i need. Its only provided in XML though. Imagine if Amazon gave you a xml dump of a brands products they sell. it would have sku, price, color etc. thats what this looks like. So it could technically be organized into a spreadsheet. i just have no idea how to do that.
     
  4. SLED

    SLED custom title

    Joined:
    Sep 20, 2001
    Messages:
    28,122
    Likes Received:
    12
    Load up an XML parser with your language of choice, loop through the nodes that you need, append to a file with commas :dunno:
     
  5. SLED

    SLED custom title

    Joined:
    Sep 20, 2001
    Messages:
    28,122
    Likes Received:
    12
    is php your poison?
     
  6. LowClass

    LowClass New Member

    Joined:
    Sep 5, 2007
    Messages:
    890
    Likes Received:
    0
    Location:
    USA
    No thats what i mean i am no programmer. Im sure it can be done in PHP, i just dont know how to write it. So i am looking for a work around for now to get these all into a CSV, or even a database that i could export a CSV from.
     
  7. SLED

    SLED custom title

    Joined:
    Sep 20, 2001
    Messages:
    28,122
    Likes Received:
    12
    I'm not sure if there is a "tool" that will take any xml document and output it to csv. You're probably better off just hiring some code monkey to do it for 1-2hrs of work
     
  8. White Stormy

    White Stormy Take that, subspace!

    Joined:
    Sep 17, 2002
    Messages:
    85,599
    Likes Received:
    109
    Location:
    Sparkopolis
    I imagine that would be really simple in PHP. if it's not sensitive data, just post it and someone might be bored enough to knock it out
     
  9. hsmith

    hsmith Well-Known Member

    Joined:
    Feb 24, 2002
    Messages:
    126,211
    Likes Received:
    2,209
    Location:
    Your mother.
  10. hsmith

    hsmith Well-Known Member

    Joined:
    Feb 24, 2002
    Messages:
    126,211
    Likes Received:
    2,209
    Location:
    Your mother.
  11. Ender0910

    Ender0910 woot!

    Joined:
    Jun 1, 2004
    Messages:
    3,039
    Likes Received:
    0
    Location:
    Redmond/Bay Area
    newer versions of excel can import XML. and then just export to CSV
     
  12. illectronic

    illectronic I'm Coming Home OT Supporter

    Joined:
    Jan 19, 2005
    Messages:
    16,950
    Likes Received:
    0
    Location:
    Brooklyn
    this
     
  13. White Stormy

    White Stormy Take that, subspace!

    Joined:
    Sep 17, 2002
    Messages:
    85,599
    Likes Received:
    109
    Location:
    Sparkopolis
    http://docs.google.com/support/bin/answer.py?hl=en&answer=75507
    Theoretically that should work..
    then you can rearrange it in the spreadsheet and download a CSV file
     
  14. LowClass

    LowClass New Member

    Joined:
    Sep 5, 2007
    Messages:
    890
    Likes Received:
    0
    Location:
    USA
    Unfortunatley for me it is sensitive data that i can't post otherwise that would make it easy for me to explain. I tried importing it in excel and it seems like it split it up correct, im going to try a few other of the xml files. i just think this one has a bunch of blank attributes which is why its scattered.

    All the XML programs are just confusing thus far. I will report back when i try a few other files in excel. ovbiousl php would be easy to use to open all of these and change em over so i might have to hire a code money to do it if this doesnt work.
     
  15. sandor3kgt

    sandor3kgt New Member

    Joined:
    Nov 1, 2006
    Messages:
    646
    Likes Received:
    0
  16. LowClass

    LowClass New Member

    Joined:
    Sep 5, 2007
    Messages:
    890
    Likes Received:
    0
    Location:
    USA

Share This Page