1. This website uses cookies to improve service and provide a tailored user experience. By using this site, you agree to this use. See our Cookie Policy.
    Dismiss Notice

Help with XML / SAX Parser

Discussion in 'BlackHat Lounge' started by TapTapper, Dec 14, 2009.

  1. TapTapper

    TapTapper Junior Member

    Apr 15, 2009
    Likes Received:
    coder, webstore mangler
    Home Page:
    Hey Guys

    One of my vendors killed their csv download for product updates and now it's only XML. And it's a huge wonking XML file too, 20 MB and over 500,000 lines. XL07 can't read the schema. This thing has 25 or so data columns and XL07 can only parse 8 or so. Dreamweaver only sees 80K rows, Chrome, FF and IE all crash if I try to open it in them. I need some other program. I've read that maybe it can get sucked into SQL Srvr or mysql, but WHY the F do I have to mirror their db locally??

    Their coder told me this:

    I don't know why this bozo thinks I've got C programmers just sitting around with nothing else to do, or that I want to spend time writing an app because THEY killed their perfectly useful text download. I had apps written around the old files to get the info I need and now all that work is trashed.

    ANYWAY, I can't find a reasonable SAX parser GUI. I've found a couple links to php code that will be a pain in the ass to implement. WTF should my browser have to parse and open a 20 MB text file?

    Tools at hand: enterprise and pro versions of vis studio 2008, sql srvr, cs4, office 07.

    How can I parse this monster every few days and just get on with my life?? Any advice is appreciated! I'm at a loss
    Last edited: Dec 14, 2009
  2. anon_anon

    anon_anon Newbie

    Dec 18, 2009
    Likes Received:
    SAX is a difficult API to use because of its lack of random access, You may want to try some other XML API such as vtd-xml