Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XMLAdapter Load XML ignoring .xsd
Message
 
 
To
09/03/2016 11:09:44
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01632680
Message ID:
01632755
Views:
46
>>>>Hi,
>>>>
>>>>Is it possible to load an XML file into XMLAdapter ignoring the .xsd file defined in the .XML file? For example, the top of the XML looks like this:
>>>>
>>>>
>>>><?xml version="1.0" encoding="utf-8" ?>
>>>><EmailList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
>>>>	xsi:noNamespaceSchemaLocation="EmailList.xsd" >
>>>>
>>>>
>>>>But I want to load the XML ignoring this EmailList.xsd because XML may have elements NOT defined in the XSD file. Can it be done?
>>>>
>>>>TIA
>>>
>>>Ignore inline or referenced schema:
>>>
>>>m.loXMLAdapter.XMLSchemaLocation = ""
>>>
>>
>>Thank you. But something does not work. I added this line in the following segment:
>>
>>
>>oXMLAdapter = NEWOBJECT('XMLAdapter') 
>>oXMLadapter.XMLSchemaLocation = ""
>>oXMLadapter.LoadXML( "emaillist.xml", .T.)
>>oXMLadapter.Tables.Item(1).ToCursor(.F.,cCursorName)   && this is the line on which error occurs.
>>
>>
>>but then I get error "Index or expression does not match an existing member of the collection"
>
>You said "ignore the schema". That lead VFP to be unable to create a table.
>
>
>oXMLadapter.LoadXML( "emaillist.xml", .T.)
>IF oXMLadapter.Tables.Count = 0
>  MESSAGEBOX("No tables were created...")
>ELSE
> oXMLadapter.Tables.Item(1).ToCursor(.F.,cCursorName)
>ENDIF
>
>
>Can you provide a sample document with no sensitive information and describe what are you looking after?

I will provide an example. But what confused me is that if I don't provide the schema, I thought that XMLAdapter will still create a table based on the elements of the XML file. I see now that that does not work.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform