Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parsing XML with DOM
Message
From
22/11/2004 23:45:24
 
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Environment versions
Visual FoxPro:
VFP 7
Miscellaneous
Thread ID:
00962465
Message ID:
00963716
Views:
8
Martin -
Thanks again for your code sample. I am slowly working my way through and making some progress. Your code will work fine with the sample file but does not work with the real file which is much bigger. I believe the reason for this is because the real file has additional header information at the beginning, so I expect the pathing to the data sections needs to be adjusted. The complete header is as follows:
<?xml version='1.0' encoding='utf-8'?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/' xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:SOAP-ENC='http://schemas.xmlsoap.org/soap/encoding/'>

<SOAP-ENV:Body>
<ns1:downloadResponse
SOAP-ENV:encodingStyle='http://schemas.xmlsoap.org/soap/encoding/'
xmlns:ns1='urn:TMSWebServices'>
<xtvdResponse xsi:type='ns1:xtvdResponse'>
<messages xsi:type='ns1:messages'>
<message>The endTime you specified 07:00:00Z is not in a valid format, and has been corrected to a default value.</message>
<message>The endTime you specified was invalid and has been corrected to 2004-11-27T07:00:00Z.</message>
<message>Your subscription will expire: 2005-01-29T23:55:24Z</message>
</messages>
<xtvdDocument xsi:type='ns1:xtvd'>
<xtvd from='2004-11-22T07:00:00Z' to='2004-11-27T07:00:00Z' schemaVersion='1.3' xmlns='urn:TMSWebServices' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='urn:TMSWebServices http://docs.tms.tribune.com/tech/xml/schemas/tmsxtvd.xsd'>
<stations>
<station id='10021'>
<callSign>AMC</callSign>
<name>AMC</name>
<affiliate>Satellite</affiliate>
</station>
This includes the first record for stations which is where my data begins. The are just for information and not a true part of the data. Could you suggest how to modify your previous code to get it to work with the above header? I have the tmsxtvd.xsd file but it offers no help to me since I am too much of a beginner.

Thanks again.
- Don
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform