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 build an idiot proof device and someone else will

    Joined:
    Sep 20, 2001
    Messages:
    28,118
    Likes Received:
    0
    Location:
    AZ, like a bauce!
    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 build an idiot proof device and someone else will

    Joined:
    Sep 20, 2001
    Messages:
    28,118
    Likes Received:
    0
    Location:
    AZ, like a bauce!
    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 build an idiot proof device and someone else will

    Joined:
    Sep 20, 2001
    Messages:
    28,118
    Likes Received:
    0
    Location:
    AZ, like a bauce!
    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 build an idiot proof device and someone else will

    Joined:
    Sep 20, 2001
    Messages:
    28,118
    Likes Received:
    0
    Location:
    AZ, like a bauce!
    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,486
    Likes Received:
    69
    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 OT Supporter

    Joined:
    Feb 24, 2002
    Messages:
    124,472
    Likes Received:
    564
    Location:
    Your mother.
  10. hsmith

    hsmith OT Supporter

    Joined:
    Feb 24, 2002
    Messages:
    124,472
    Likes Received:
    564
    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,486
    Likes Received:
    69
    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