Page 1 of 1

Do u think this XML file structure is ok...???

Posted: Mon Feb 06, 2006 10:38 am
by kalpna
Hi!
can anyone figure out, if there is any structural problem with this xml schema?????


<?xml version="1.0" encoding="ISO-8859-1" ?>
- <messageListFromWcs xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="WcsToHost.xsd">
<datetime>2006-01-18T14:40:34</datetime>
<sequenceNo>00000598</sequenceNo>
- <purchaseOrdersToBW>
<extractDate>2006-01-18</extractDate>
<poNum>638508</poNum>
<poSplitNum>02</poSplitNum>
<sapDcSiteCode>D985</sapDcSiteCode>
<supplier>500362</supplier>
<orderDate>2006-01-18</orderDate>
<poLineNum>1</poLineNum>
<ean>5036581028381</ean>
<bnqCode>25206760</bnqCode>
<recomDueDate>2006-01-26</recomDueDate>
<delivDueDate>2006-01-26</delivDueDate>
<receivedDate>2006-01-18</receivedDate>
<orderedQty>00960</orderedQty>
<recdQty>100</recdQty>
<costprice>8.400</costprice>
<lineStatus>O</lineStatus>
<changeDate>2006-01-18</changeDate>
<poLineNum>2</poLineNum>
<ean>5036581028589</ean>
<bnqCode>25204827</bnqCode>
<recomDueDate>2006-01-26</recomDueDate>
<delivDueDate>2006-01-26</delivDueDate>
<receivedDate>2006-01-18</receivedDate>
<orderedQty>00072</orderedQty>
<recdQty>36</recdQty>
<costprice>10.200</costprice>
<lineStatus>O</lineStatus>
<changeDate>2006-01-18</changeDate>
</purchaseOrdersToBW>
</messageListFromWcs>

Thanks
Kalpna

Posted: Mon Feb 06, 2006 11:12 am
by alanwms
Have you tried using XMLSpy or other tool to help you verify the structure?

Posted: Mon Feb 06, 2006 11:22 am
by chulett
You probably should have let people know that it is related to this problem that you are having.

Posted: Tue Feb 07, 2006 4:53 am
by kalpna
Hi! Alan
Yes! I validated the file using XML spy..
it says..'Unable to load external DTD,schema or entity source 'WcsToHost.xsd'

I am completed new to this product..
Do u have any idea?

Posted: Tue Feb 07, 2006 4:59 am
by Thibal
You must create a schema file (named here WcsToHost.xsd) to describe your structure. Take a look at Google for XSD schema.

Posted: Tue Feb 07, 2006 5:04 am
by kalpna
Adding to that..
the schema def is like this:

!----Extract Date
! !---poNum
!-----------!---poSpitNum
!---sapDoSiteCode
!---Supplier
!---orderDate !----poLineNum
! !----ean
!---------------------- !----bnqCode
!-----recomDueDate
!----delivDueDate
!----receivedDate
!-----orderedQty
!----recdQty
!----costPrice
!-----lineStatus
!-----changeDate

will that file fits this def?

Posted: Tue Feb 07, 2006 5:08 am
by Thibal
No, it isn't the correct format.

-> http://www.w3schools.com/schema/schema_simple.asp

Posted: Tue Feb 07, 2006 5:08 am
by kalpna
Sorry!
that was weird!!!!!
I'll try to find that..
Thanks
kalpna

Posted: Tue Feb 07, 2006 6:09 am
by kalpna
Hi!
Iam able to open and also validate the schema file 'WcsToHost.xsd'.
and it is also placed in the same directory as the xml file.
but, its not recognising it..
i've tried this with XML Spy as well,
it warns the same ..

the well-formed ness is checked ok.
any clue???!!!

Thanks
kalpna