SSDN - EDI to XSD and validation

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Roel van der Hoeven

Subject: EDI to XSD and validation
Author: Roel van der Hoeven
Date: 04 Jun 2009 05:42 AM

I have an XSD which was made through the document wizzard in SS. It is the COPRAR message (EDIFACT, 95B) using attached SEF file.

The XSD give me all groups/elements, seems correct at first sight. In the XSD Group_1 there is a collection of the following segments:

TDT
RFF (VON)
RFF (SSX)
LOC

The EDI file reads:
UNB+UNOA:4+NLRHNTMR0.EDI+NLRTMECTDCD2+080429:1542+17312454X'
UNH+COPRAR1+COPRAR:D:95B:UN:ITG12'
BGM+45+DOC MSG NUMBER+9'
RFF+XXX:1'
TDT+20+VOYAGENR TDT+1++ROAD RUNNER:172:ZZZ'
RFF+VON:VOYAGENR VON'
RFF+SSX:REFERENCE SSX'
LOC+9+SUITE 542:139:6+PLACE:::OLENTANGY'
NAD+CA+ACCOUNTS PAYABLE:160:ZZZ'
NAD+MR+NAD MR:160:ZZZ'
EQD+CN+F45++++4'
RFF+CN:RFF CN'
MEA+AAE+G+KGM:750'
CNT+16:30'
UNT+14+COPRAR1'
UNZ+1+1'

Which is correct. If I try to validate in the XQuery:

let $input := ddtek:validate(/EDIFACT,'../dictionaries/applications/ecs/xsd/ECS_COPRAR_IN.xsd')
return
<a:xlCoprar>
<a:xlAgentsVoyageNumber>
{
let $RFF_VON := for $RFF in $input/EDIFACT/COPRAR/GROUP_1/RFF where $RFF/RFF0101/text() = 'VON' return $RFF/RFF0102/text()
return
if( string-length($RFF_VON) > 0 ) then
$RFF_VON
else
$input/EDIFACT/COPRAR/GROUP_1/TDT/TDT02/text()
}
</a:xlAgentsVoyageNumber>
</a:xlCoprar>

I get the validation error:
[DataDirect][XQuery]Error in call to ddtek:validate(): Error in complex type GROUP_1: Ambiguous content model, element <RFF> appears more than once

Any thoughts on this one?

ECS_COPRAR_M121(1).sef
SEF file

ECS_COPRAR_IN.xsd
XSD

ECS_COPRAR_M121.xquery
XQuery

COPRAR_var(1).edi
EDI

Roel van der Hoeven

Subject: EDI to XSD and validation
Author: Roel van der Hoeven
Date: 04 Jun 2009 06:10 AM

When I change the XSD from:

<xsd:complexType name="GROUP_1">
<xsd:sequence>
<xsd:element name="TDT" type="TDT"/>
<xsd:element name="RFF" type="RFF" minOccurs="0" maxOccurs="1"/>
<xsd:element name="RFF" type="RFF" minOccurs="0" maxOccurs="1"/>

<xsd:element name="LOC" type="LOC" minOccurs="0" maxOccurs="9"/>
</xsd:sequence>
</xsd:complexType>

to:
<xsd:complexType name="GROUP_1">
<xsd:sequence>
<xsd:element name="TDT" type="TDT"/>
<xsd:element name="RFF" type="RFF" minOccurs="0" maxOccurs="2"/>
<xsd:element name="LOC" type="LOC" minOccurs="0" maxOccurs="9"/>
</xsd:sequence>
</xsd:complexType>

It works, but then I get the error:
[DataDirect][XQuery]Error in call to ddtek:validate(): In content of element <GROUP_3>: The content model does not allow element <EQD> to appear here. Expected: NAD

The XSD (created by stylusstudio) reads:
<xsd:complexType name="GROUP_2">
<xsd:sequence>
<xsd:element name="NAD" type="NAD"/>
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="GROUP_3">
<xsd:sequence>
<xsd:element name="NAD" type="NAD"/>
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="GROUP_4">
<xsd:sequence>
<xsd:element name="EQD" type="EQD"/>
<xsd:element name="RFF" type="RFF"/>
<xsd:element name="MEA" type="MEA" minOccurs="0" maxOccurs="3"/>
</xsd:sequence>
</xsd:complexType>

So I got an NAD segment in group 2 and 1 in group 3. However when I check the raw output stylus studio gives it comes back with:

<GROUP_2>
<NAD>
<NAD01>CA</NAD01>
<NAD02>
<NAD0201>ACCOUNTS PAYABLE</NAD0201>
<NAD0202>160</NAD0202>
<NAD0203>ZZZ</NAD0203>
</NAD02>
</NAD>
</GROUP_2>
<GROUP_2>
<NAD>
<NAD01>MR</NAD01>
<NAD02>
<NAD0201>NAD MR</NAD0201>
<NAD0202>160</NAD0202>
<NAD0203>ZZZ</NAD0203>
</NAD02>
</NAD>
</GROUP_2>
<GROUP_3>
<EQD>
<EQD01>CN</EQD01>
<EQD02>
<EQD0201>F45</EQD0201>
</EQD02>
<EQD06>4</EQD06>
</EQD>
<RFF>
<RFF01>
<RFF0101>CN</RFF0101>
<RFF0102>RFF CN</RFF0102>
</RFF01>
</RFF>
<MEA>
<MEA01>AAE</MEA01>
<MEA02>
<MEA0201>G</MEA0201>
</MEA02>
<MEA03>
<MEA0301>KGM</MEA0301>
<MEA0302>750</MEA0302>
</MEA03>
</MEA>
</GROUP_3>

So It skips 1 group, and changes group 4 into group 3...

A bit confused now.......

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.