HomeFlySpeed Data ExportInvalid XSD - WC3 generated ... Any trick or solution ?

Invalid XSD - WC3 generated ... Any trick or solution ?


All,

Seems to me that I should not be the only one to have such problem, so I post it on this Forum to know if someone has found a workaround.

When exporting data from a table into an XML + its associated XSD, the generated schema is invalid as it lack of the schema definition for the root none of the XML file.

Assuming I have a table with list of continent names and ID the generated XML would be something like below.
<?xml version="1.0" encoding="utf-16" standalone ="yes"?>
<Address xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="dbo.TblContinent.2011-05-31 08-57-02.xsd">
<dbo.TblContinent>
<Name>[Not defined]</Name>
<SourceID>0</SourceID>
</dbo.TblContinent>
<dbo.TblContinent>
<Name>Africa</Name>
<SourceID>6255146</SourceID>
</dbo.TblContinent>
[...]
</Address>


However the generated schema does not include definition for <Address> and therefore validation fails:

<?xml version="1.0" encoding="latin1" ?>
<xs:schema elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="dbo.TblContinent">
<xs:complexType>
<xs:sequence>
<xs:element name="Name" type="xs:string" />
<xs:element name="SourceID" type="xs:int" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

Anyone with a workaround or trick I didn't discover in the product as thsi is really a show stopper to buy it ?


Thanks
Pascal
Pascal | email
May 30 2011, 09:03 PM
This topic is closed