I used to parse large XML with MSXML but I also did damage to the walls in dealing with it. The performance was awful and each new version of MSXML had it's benefits and detractions.
I ended up parsing the XML myself using a series of STREXTRACT() calls and it settled down nicely and performed on an order of magnitude faster as well. Just my $0.02. -Kevin CULLY Technologies, LLC Ken Kixmoeller/fh wrote: >>> So - I guess that begs the next question - how can I find out EXACTLY >>> what Schema & XML formats are supported by VFP??? Or - could it >>> simply >>> be that VFP can't handle a schema that is like 4 levels deep? >> Not sure exactly what VFP supports but it looks like you will need to >> use something like MSXML to import this: >> http://msdn.microsoft.com/en-us/library/ms763742.aspx > > I had a situation like this, except I couldn't get a schema file. The > XML files defied all attempts to decode them with xmltocursor() or > any of the VFP stuff. After creating a few head-sized holes in my > wall, I figured that everything else I had seen from the programming > shop that produced the XML bore the stench, er "stamp" of Redmond, so > I cheated. I used automation to open the file in Excel and save it as > a DBF. All of the defaults in Excel converted the XML perfectly, and > the DBF suited my purposes just fine. > > I'm sure the next release of Excel will break it, but for now: it > works, the client is happy, and I am happy to have this pig off of my > lap. > > Ken > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/499b20ca.8050...@cullytechnologies.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
