Hello everyone!

Can anyone write an XSD or XDR schema for this XML? For use with the
sqlXMLBULKLOAD object.... I have tried and tried to no avail. The ID
attribute for Customer is stumping me.


THANKS!!


<?xml version="1.0" encoding="windows-1252" ?>
<CALLS>

<Call id="99999999">
<DID>99999999</DID>
<Date Format="mm/dd/yyyy hh:nn:ss">7/16/2003 4:59:16 PM</Date>
<Result code="10">Connect</Result>
<Duration Unit="seconds">520</Duration>
<Target>99999999</Target>
<ANI>99999999</ANI>
<Customer id="99999999"/>
</Call>

<Call id="99999999">
<DID>99999999</DID>
<Date Format="mm/dd/yyyy hh:nn:ss">7/22/2003 11:57:04 AM</Date>
<Result code="12">Abandoned</Result>
<Duration Unit="seconds">0</Duration>
<Target>99999999</Target>
<ANI>99999999</ANI>
<Customer id="99999999"/>
</Call>

</CALLS>

The attribute ID should be strting with a alphabet. Pure number is not
acceptable. Type is xs:ID. It shlud work. I have a very similar schema. If
you still have problem let me know.

Rohit


"Paul McKirdy" <paul (AT) traderonline (DOT) com> wrote