Rafael - thanks for getting back to me. (FYI - below message is trimmed
for brevity...)
I was able to successfully export an XML file using my own tables, and
then even import that XML data back into those tables(after wiping the
content from the tables) - and that all works fine.
The real problem is being able to import an XML file that I receive thru
this EDI process. As mentioned below - I was able to obtain a Schema
file from that XML file. But, upon trying to use that Schema file - I
get the error message:
"XML Schema is Too complex"
On the M$ website it states:
"The LoadXML method was unable to fully understand the supplied
XML Schema. Check to make sure the supplied schema contains valid XSD
data types or the schema and XML format is supported by Visual FoxPro."
You can find that here:
http://msdn.microsoft.com/en-us/library/aa976843(VS.71).aspx
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?
Thanks,
-K-
-----Original Message-----
From: [email protected] [mailto:[email protected]]
On Behalf Of Rafael Copquin
Sent: Tuesday, February 17, 2009 7:39 AM
Hi Kurt
Sorry for not replying earlier. If I get you correctly, you need to
import
an XML file into VFP.
To be quite honest with you, I never used a schema file. But I do send
data
over the web in the manner I showed you in my earlier post...
Regards
Rafael Copquin
----- Original Message -----
From: "Kurt Wendt" <[email protected]>
Sent: Friday, February 13, 2009 7:00 PM
> Hey there Rafael,
>
> ...I had this sample XML file - an EDI Order file - for which I
eventually
> need to import into the VFP database system here. Problem is - I did
not
> have a Schema file for this XML file. And, since I figured I needed
the
> Schema in order for me to import the file into VFP - I opened up the
XML
> file in MS VS - and I found I could Export from MS VS a Schema file.
>
> At that point I tried to use this newly created Schema file, along
with
> the sample XML file - but, I ended up getting a strange error when the
> .LoadXML command attempted to execute. It claimed that:
> "XML Schema is Too complex"!
>
> When I opened that Schema file up in MS VS - the tree diagram shows it
> as 4 levels deep. Can that be the case - that VFP and the XMLAdapter
is
> unable to handle something like 4 levels deep???
>
> TIA,
> -K-
_______________________________________________
Post Messages to: [email protected]
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/289ea162f5642645b5cf64d624c66a14048e6...@us-ny-mail-002.waitex.net
** 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.
