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

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
kalpna
Premium Member
Premium Member
Posts: 78
Joined: Thu Feb 02, 2006 3:56 am

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

Post 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
alanwms
Charter Member
Charter Member
Posts: 28
Joined: Wed Feb 26, 2003 2:51 pm
Location: Atlanta/UK

Post by alanwms »

Have you tried using XMLSpy or other tool to help you verify the structure?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You probably should have let people know that it is related to this problem that you are having.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kalpna
Premium Member
Premium Member
Posts: 78
Joined: Thu Feb 02, 2006 3:56 am

Post 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?
Thibal
Participant
Posts: 56
Joined: Tue Mar 30, 2004 3:43 am
Location: Nanterre, France

Post by Thibal »

You must create a schema file (named here WcsToHost.xsd) to describe your structure. Take a look at Google for XSD schema.
kalpna
Premium Member
Premium Member
Posts: 78
Joined: Thu Feb 02, 2006 3:56 am

Post 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?
Thibal
Participant
Posts: 56
Joined: Tue Mar 30, 2004 3:43 am
Location: Nanterre, France

Post by Thibal »

No, it isn't the correct format.

-> http://www.w3schools.com/schema/schema_simple.asp
kalpna
Premium Member
Premium Member
Posts: 78
Joined: Thu Feb 02, 2006 3:56 am

Post by kalpna »

Sorry!
that was weird!!!!!
I'll try to find that..
Thanks
kalpna
kalpna
Premium Member
Premium Member
Posts: 78
Joined: Thu Feb 02, 2006 3:56 am

Post 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
Post Reply