Databases
StackOverflow2013
Postsdbo
POValidate a XML against a XSD: Undeclared XSD element
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POValidate a XML against a XSD: Undeclared XSD element
    primarykey
    data
    text
    <p>I'm trying to validate a xml against a xsd file but returns de error:</p> <pre><code>1.xsd#/schema/element[1][@name = 'envioLote']/complexType[1]/sequence[1]/element[4] Undeclared XSD element : '{http://www.w3.org/2000/09/xmldsig#}Signature' </code></pre> <p>I'm using the following code</p> <pre><code>var DOMDocument : IXMLDOMDocument3; ParseError : IXMLDOMParseError; Schema : XMLSchemaCache; sNameSpace : String; begin DOMDocument := CoDOMDocument50.Create; DOMDocument.async := False; DOMDocument.resolveExternals := True; DOMDocument.validateOnParse := True; DOMDocument.loadXML(sXml); Schema := CoXMLSchemaCache50.Create; Schema.add( '', 'c:\1.xsd' ); DOMDocument.schemas := Schema; ParseError := DOMDocument.validate; Result := (ParseError.errorCode = 0); if not result then showmessage(ParseError.reason); DOMDocument := nil; ParseError := nil; Schema := nil; end; </code></pre> <p><a href="https://docs.google.com/file/d/0B4M8jpzZrtdINmtlQU1KSzAzeE0/edit?usp=sharing" rel="nofollow">1.xsd file </a></p> <pre><code> &lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" elementFormDefault="qualified" attributeFormDefault="unqualified"&gt; &lt;xs:import namespace="http://www.w3.org/2000/09/xmldsig#" schemaLocation="xmldsig-core-schema_v1.01.xsd"/&gt; &lt;xs:element name="envioLote"&gt; &lt;xs:complexType&gt; &lt;xs:sequence&gt; &lt;xs:element name="CNPJ" type="TCnpj"/&gt; &lt;xs:element name="dhTrans" type="TDataHora"/&gt; &lt;xs:element ref="NFS-e" minOccurs="1" maxOccurs="500"/&gt; &lt;xs:element ref="ds:Signature" minOccurs="0" maxOccurs="1"/&gt; &lt;/xs:sequence&gt; &lt;xs:attribute name="versao" type="xs:string" use="required"/&gt; &lt;/xs:complexType&gt; &lt;/xs:element&gt; &lt;xs:element name="NFS-e"&gt; &lt;xs:complexType&gt; &lt;xs:sequence&gt; &lt;xs:element ref="infNFSe"/&gt; &lt;/xs:sequence&gt; &lt;/xs:complexType&gt; &lt;/xs:element&gt; &lt;xs:element name="infNFSe"&gt; &lt;xs:complexType&gt; &lt;xs:sequence&gt; &lt;xs:element ref="Id"/&gt; &lt;xs:element ref="prest"/&gt; &lt;xs:element ref="TomS"/&gt; &lt;xs:element ref="det" minOccurs="1" maxOccurs="999"/&gt; &lt;xs:element ref="total"/&gt; &lt;xs:element name="infAdicLT" type="TCodMunIBGE" minOccurs="1" maxOccurs="1"/&gt; &lt;xs:element name="infAdicES" type="TSimNao" minOccurs="0" maxOccurs="1"/&gt; &lt;/xs:sequence&gt; &lt;xs:attribute name="versao" type="xs:string" use="required"/&gt; &lt;/xs:complexType&gt; &lt;/xs:element&gt; &lt;xs:element name="Id"&gt; &lt;xs:complexType&gt; &lt;xs:sequence&gt; &lt;xs:element name="cNFS-e" type="TNumAleatorio"/&gt; &lt;xs:element name="mod" type="TModelo"/&gt; &lt;xs:element name="serie" type="TSerie"/&gt; &lt;xs:element name="nNFS-e" type="TNF"/&gt; &lt;xs:element name="dEmi" type="TData"/&gt; &lt;xs:element name="hEmi" type="THora"/&gt; &lt;xs:element name="tpNF" type="TNFSe"/&gt; &lt;xs:element name="refNF" type="TChaveAcesso"/&gt; &lt;xs:element name="tpEmis" type="TEmissao"/&gt; &lt;xs:element name="ambienteEmi" type="TCharInt"/&gt; &lt;xs:element name="formaEmi" type="TCharInt"/&gt; &lt;xs:element name="empreitadaGlobal" type="TCharInt"/&gt; &lt;/xs:sequence&gt; &lt;/xs:complexType&gt; &lt;/xs:element&gt; &lt;xs:element name="prest"&gt; &lt;xs:complexType&gt; &lt;xs:sequence&gt; &lt;xs:element name="CNPJ" type="TCnpj"/&gt; &lt;xs:element name="xNome" type="TString150"/&gt; &lt;xs:element name="IM" type="TString15"/&gt; &lt;xs:element ref="end"/&gt; &lt;xs:element name="regimeTrib" type="TCharInt"/&gt; &lt;/xs:sequence&gt; &lt;/xs:complexType&gt; &lt;/xs:element&gt; &lt;xs:element name="end"&gt; &lt;xs:complexType&gt; &lt;xs:sequence&gt; &lt;xs:element name="xLgr" type="TString100"/&gt; &lt;xs:element name="nro" type="TString6"/&gt; &lt;xs:element name="xBairro" type="TString100"/&gt; &lt;xs:element name="cMun" type="TCodMunIBGE"/&gt; &lt;xs:element name="xMun" type="TString60"/&gt; &lt;xs:element name="UF" type="TString2"/&gt; &lt;xs:element name="CEP" type="TCep"/&gt; &lt;xs:element name="cPais" type="TcPais"/&gt; &lt;xs:element name="xPais" type="TString100"/&gt; &lt;/xs:sequence&gt; &lt;/xs:complexType&gt; &lt;/xs:element&gt; &lt;xs:element name="TomS"&gt; &lt;xs:complexType&gt; &lt;xs:sequence&gt; &lt;xs:choice&gt; &lt;xs:element name="CNPJ" type="TCnpj"/&gt; &lt;xs:element name="CPF" type="TCpf"/&gt; &lt;/xs:choice&gt; &lt;xs:element ref="ender"/&gt; &lt;/xs:sequence&gt; &lt;/xs:complexType&gt; &lt;/xs:element&gt; &lt;xs:element name="ender"&gt; &lt;xs:complexType&gt; &lt;xs:sequence&gt; &lt;xs:element name="cMun" type="TCodMunIBGE"/&gt; &lt;xs:element name="xMun" type="TString60"/&gt; &lt;xs:element name="UF" type="TString2"/&gt; &lt;xs:element name="cPais" type="TcPais"/&gt; &lt;xs:element name="xPais" type="TString100"/&gt; &lt;/xs:sequence&gt; &lt;/xs:complexType&gt; &lt;/xs:element&gt; &lt;xs:element name="dadosDaObra"&gt; &lt;xs:complexType&gt; &lt;xs:sequence&gt; &lt;xs:element name="xLogObra" type="TString100"/&gt; &lt;xs:element name="xComplObra" type="TString100" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="vNumeroObra" type="TString15" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="xBairroObra" type="TString100" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="xCepObra" type="TCep" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="cCidadeObra" type="TCodMunIBGE"/&gt; &lt;xs:element name="xCidadeObra" type="TString60"/&gt; &lt;xs:element name="xUfObra" type="TString2"/&gt; &lt;xs:element name="cPaisObra" type="TcPais"/&gt; &lt;xs:element name="xPaisObra" type="TString100"/&gt; &lt;xs:element name="numeroArt" type="TString12" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="numeroCei" type="TString12" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="numeroProj" type="TString15" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="numeroMatri" type="TString15" minOccurs="0" maxOccurs="1"/&gt; &lt;/xs:sequence&gt; &lt;/xs:complexType&gt; &lt;/xs:element&gt; &lt;xs:element name="transportadora"&gt; &lt;xs:complexType&gt; &lt;xs:sequence&gt; &lt;xs:element name="xNomeTrans" type="TString100"/&gt; &lt;xs:element name="xCpfCnpjTrans" type="TString15" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="xInscEstTrans" type="TString15" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="xPlacaTrans" type="TPlacaVeic" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="xEndTrans" type="TString100" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="cMunTrans" type="TCodMunIBGE" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="xMunTrans" type="TString60" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="xUfTrans" type="TString2" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="cPaisTrans" type="TcPais" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="xPaisTrans" type="TString100" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="vTipoFreteTrans" type="TFrete" minOccurs="0" maxOccurs="1"/&gt; &lt;/xs:sequence&gt; &lt;/xs:complexType&gt; &lt;/xs:element&gt; &lt;xs:element name="det"&gt; &lt;xs:complexType&gt; &lt;xs:sequence&gt; &lt;xs:element name="nItem" type="TOrdemSeq"/&gt; &lt;xs:element ref="serv"/&gt; &lt;/xs:sequence&gt; &lt;/xs:complexType&gt; &lt;/xs:element&gt; &lt;xs:element name="serv"&gt; &lt;xs:complexType&gt; &lt;xs:sequence&gt; &lt;xs:element name="cServ" type="TString60"/&gt; &lt;xs:element name="cLCServ" type="TLCServ"/&gt; &lt;xs:element name="xServ" type="TString256"/&gt; &lt;xs:element name="localTributacao" type="TCodMunIBGE"/&gt; &lt;xs:element name="localVerifResServ" type="TCharInt"/&gt; &lt;xs:element name="uTrib" type="TString2"/&gt; &lt;xs:element name="qTrib" type="TDec_1302"/&gt; &lt;xs:element name="vUnit" type="TDec_1302"/&gt; &lt;xs:element name="vServ" type="TDec_1302"/&gt; &lt;/xs:sequence&gt; &lt;/xs:complexType&gt; &lt;/xs:element&gt; &lt;xs:element name="ISSST"&gt; &lt;xs:complexType&gt; &lt;xs:sequence&gt; &lt;xs:element name="vBCST" type="TDec_1302"/&gt; &lt;xs:element name="pISSST" type="TDec_0302"/&gt; &lt;xs:element name="vISSST" type="TDec_1302"/&gt; &lt;/xs:sequence&gt; &lt;/xs:complexType&gt; &lt;/xs:element&gt; &lt;xs:element name="total"&gt; &lt;xs:complexType&gt; &lt;xs:sequence&gt; &lt;xs:element name="vServ" type="TDec_1302"/&gt; &lt;xs:element name="vtNF" type="TDec_1302"/&gt; &lt;xs:element name="vtLiq" type="TDec_1302"/&gt; &lt;/xs:sequence&gt; &lt;/xs:complexType&gt; &lt;/xs:element&gt; &lt;xs:element name="ISS"/&gt; &lt;xs:element name="Ret"&gt; &lt;xs:complexType&gt; &lt;xs:sequence&gt; &lt;xs:element name="vRetIR" type="TDec_1302" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="vRetPISPASEP" type="TDec_1302" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="vRetCOFINS" type="TDec_1302" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="vRetCSLL" type="TDec_1302" minOccurs="0" maxOccurs="1"/&gt; &lt;xs:element name="vRetINSS" type="TDec_1302" minOccurs="0" maxOccurs="1"/&gt; &lt;/xs:sequence&gt; &lt;/xs:complexType&gt; &lt;/xs:element&gt; &lt;xs:element name="faturas"&gt; &lt;xs:complexType&gt; &lt;xs:sequence&gt; &lt;xs:element ref="fat" minOccurs="1" maxOccurs="999"/&gt; &lt;/xs:sequence&gt; &lt;/xs:complexType&gt; &lt;/xs:element&gt; &lt;xs:element name="fat"&gt; &lt;xs:complexType&gt; &lt;xs:sequence&gt; &lt;xs:element name="nItem" type="TOrdemSeq"/&gt; &lt;xs:element name="nFat" type="TNumFatura"/&gt; &lt;xs:element name="dVenc" type="TData"/&gt; &lt;xs:element name="vFat" type="TDec_1302"/&gt; &lt;/xs:sequence&gt; &lt;/xs:complexType&gt; &lt;/xs:element&gt; &lt;xs:simpleType name="TCep"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para Codigo Postal&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:token"&gt; &lt;xs:pattern value="[0-9]{8}"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TCharInt"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para caracter numerico&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:token"&gt; &lt;xs:pattern value="[0-9]{1}"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TChaveAcesso"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para chave de acesso &lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:maxLength value="39"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TCnpj"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo Número do CNPJ&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:token"&gt; &lt;xs:pattern value="[0-9]{14}"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TCodMunIBGE"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo Código do Município da tabela do IBGE&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:token"&gt; &lt;xs:pattern value="[0-9]{7}"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TcPais"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para Codigo do Pais&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:token"&gt; &lt;xs:pattern value="[0-9]{5}"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TCpf"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo Número do CPF&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:token"&gt; &lt;xs:pattern value="[0-9]{11}"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TData"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt; Tipo data AAAA-MM-DD&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:date"&gt; &lt;xs:pattern value="\d{4}-\d{2}-\d{2}"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TDataHora"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt; Tipo datetime AAAA-MM-DD HH:MM:SS&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:whiteSpace value="preserve"/&gt; &lt;xs:pattern value="\d{4}-\d{2}-\d{2}(\s\d{2}:\d{2}:\d{2})?"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TDec_0302"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo Decimal com 5 dígitos, sendo 3 de corpo e 2 decimais&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:minLength value="0"/&gt; &lt;xs:whiteSpace value="preserve"/&gt; &lt;xs:pattern value="|0|0\.[0-9]{2}|[1-9]{1}[0-9]{0,2}(\.[0-9]{2})?"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TDec_1302"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo Decimal com 15 dígitos, sendo 13 de corpo e 2 decimais&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:minLength value="0"/&gt; &lt;xs:whiteSpace value="preserve"/&gt; &lt;xs:pattern value="|0|0\.[0-9]{2}|[1-9]{1}[0-9]{0,12}(\.[0-9]{2})?"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TEmissao"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para forma de emissao &lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:token"&gt; &lt;xs:pattern value="[NC]{1}"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TFone"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para numero do telefone &lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:token"&gt; &lt;xs:pattern value="|[0-9]{1,14}"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TFrete"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para frete de transportadora &lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:token"&gt; &lt;xs:pattern value="[0-9]{1}"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="THora"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt; Tipo time HH:MM&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:whiteSpace value="preserve"/&gt; &lt;xs:pattern value="\d{2}:\d{2}"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TImpressao"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para formato de impressao &lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:integer"&gt; &lt;xs:minInclusive value="1"/&gt; &lt;xs:maxInclusive value="1"/&gt; &lt;!-- Em Caxias uma NFSe somente pode ser impressa no modo retrato --&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TLCServ"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para Lei Complementar 116 &lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:positiveInteger"&gt; &lt;xs:maxInclusive value="9999"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TModelo"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para modelo de uma NFSe &lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:minLength value="1"/&gt; &lt;xs:maxLength value="2"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TMotCanc"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para motivo de cancelamento&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:token"&gt; &lt;xs:pattern value="[0-9]{1}"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TNF"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo Número do Documento Fiscal&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:token"&gt; &lt;xs:pattern value="[0-9]{0,9}"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TNFSe"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para uma NFSe &lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:integer"&gt; &lt;xs:minInclusive value="1"/&gt; &lt;xs:maxInclusive value="1"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TNumAleatorio"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para numero aleatorio &lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:positiveInteger"&gt; &lt;xs:maxInclusive value="999999999"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TNumFatura"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo Número de Fatura em NFS-e&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:token"&gt; &lt;xs:pattern value="[0-9]{0,3}"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TOrdemSeq"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para ordem sequencial de itens &lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:positiveInteger"&gt; &lt;xs:maxInclusive value="999"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TPlacaVeic"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo String para placa de veiculo com tamanho maximo 7&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:token"&gt; &lt;xs:pattern value="[a-zA-Z]{2,3}[0-9]{3,4}"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TSerie"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo String de tamanho maximo 3&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:maxLength value="3"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TSimNao"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para Sim/Nao &lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:token"&gt; &lt;xs:pattern value="[SN]{1}"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TSituacaoCancelamentoNota"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para situacao de cancelamento de uma NFSe &lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:positiveInteger"&gt; &lt;xs:maxInclusive value="999"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TSituacaoLote"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para situacao de um lote de NFSe &lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:positiveInteger"&gt; &lt;xs:maxInclusive value="999"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TSituacaoNFSe"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para situacao de uma NFSe &lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:token"&gt; &lt;xs:pattern value="[0-9]{1}"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TSituacaoNota"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para situacao de uma nota dentro de um lote submetido &lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:positiveInteger"&gt; &lt;xs:maxInclusive value="999"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TString2"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para string de tamanho maximo 2&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:maxLength value="2"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TString3"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para string de tamanho maximo 3&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:maxLength value="3"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TString5"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para string de tamanho maximo 5&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:maxLength value="5"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TString6"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para string de tamanho maximo 6&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:maxLength value="6"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TString12"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para string de tamanho maximo 12&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:maxLength value="12"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TString13"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para string de tamanho maximo 13&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:maxLength value="13"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TString15"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para string de tamanho maximo 15&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:maxLength value="15"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TString50"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para string de tamanho maximo 50&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:maxLength value="50"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TString60"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para string de tamanho maximo 60&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:maxLength value="60"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TString100"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para string de tamanho maximo 100&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:maxLength value="100"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TString120"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para string de tamanho maximo 120&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:maxLength value="120"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TString150"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para string de tamanho maximo 150&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:maxLength value="150"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;xs:simpleType name="TString256"&gt; &lt;xs:annotation&gt; &lt;xs:documentation&gt;Tipo para string de tamanho maximo 256&lt;/xs:documentation&gt; &lt;/xs:annotation&gt; &lt;xs:restriction base="xs:string"&gt; &lt;xs:maxLength value="256"/&gt; &lt;/xs:restriction&gt; &lt;/xs:simpleType&gt; &lt;/xs:schema&gt; </code></pre> <p><a href="https://docs.google.com/file/d/0B4M8jpzZrtdIWWM5alFORFFJZWs/edit?usp=sharing" rel="nofollow">Content of "sXml" </a></p> <pre><code> &lt;?xml version="1.0" encoding="utf-8"?&gt; &lt;envioLote versao="1.0"&gt; &lt;CNPJ&gt;93120350000172&lt;/CNPJ&gt; &lt;dhTrans&gt;2013-06-17 16:12:45&lt;/dhTrans&gt; &lt;NFS-e&gt; &lt;infNFSe versao="1.1"&gt; &lt;Id&gt; &lt;cNFS-e&gt;12&lt;/cNFS-e&gt; &lt;mod&gt;55&lt;/mod&gt; &lt;serie&gt;S&lt;/serie&gt; &lt;nNFS-e&gt;12&lt;/nNFS-e&gt; &lt;dEmi&gt;2013-06-17&lt;/dEmi&gt; &lt;hEmi&gt;13:48&lt;/hEmi&gt; &lt;tpNF&gt;1&lt;/tpNF&gt; &lt;refNF&gt;439312035000017255S00000000012850064870&lt;/refNF&gt; &lt;tpEmis&gt;N&lt;/tpEmis&gt; &lt;ambienteEmi&gt;2&lt;/ambienteEmi&gt; &lt;formaEmi&gt;2&lt;/formaEmi&gt; &lt;empreitadaGlobal&gt;2&lt;/empreitadaGlobal&gt; &lt;/Id&gt; &lt;prest&gt; &lt;CNPJ&gt;93120350000172&lt;/CNPJ&gt; &lt;xNome&gt;CFC ELITRONIC CAR BETA 2 LTDA&lt;/xNome&gt; &lt;IM&gt;8198&lt;/IM&gt; &lt;end&gt; &lt;xLgr&gt;RUA X&lt;/xLgr&gt; &lt;nro&gt;120&lt;/nro&gt; &lt;xBairro&gt;BAIRRO&lt;/xBairro&gt; &lt;cMun&gt;4305108&lt;/cMun&gt; &lt;xMun&gt;CAXIAS DO SUL&lt;/xMun&gt; &lt;UF&gt;RS&lt;/UF&gt; &lt;CEP&gt;97015530&lt;/CEP&gt; &lt;cPais&gt;01058&lt;/cPais&gt; &lt;xPais&gt;BRASIL&lt;/xPais&gt; &lt;/end&gt; &lt;regimeTrib&gt;3&lt;/regimeTrib&gt; &lt;/prest&gt; &lt;TomS&gt; &lt;CPF&gt;00295819073&lt;/CPF&gt; &lt;ender&gt; &lt;cMun&gt;4305108&lt;/cMun&gt; &lt;xMun&gt;CAXIAS DO SUL&lt;/xMun&gt; &lt;UF&gt;RS&lt;/UF&gt; &lt;cPais&gt;01058&lt;/cPais&gt; &lt;xPais&gt;BRASIL&lt;/xPais&gt; &lt;/ender&gt; &lt;/TomS&gt; &lt;det&gt; &lt;nItem&gt;1&lt;/nItem&gt; &lt;serv&gt; &lt;cServ&gt;10&lt;/cServ&gt; &lt;cLCServ&gt;1405&lt;/cLCServ&gt; &lt;xServ&gt;AULA PRATICA - CATEGORIA A&lt;/xServ&gt; &lt;localTributacao&gt;4305108&lt;/localTributacao&gt; &lt;localVerifResServ&gt;1&lt;/localVerifResServ&gt; &lt;uTrib&gt;UN&lt;/uTrib&gt; &lt;qTrib&gt;20&lt;/qTrib&gt; &lt;vUnit&gt;29.95&lt;/vUnit&gt; &lt;vServ&gt;599.00&lt;/vServ&gt; &lt;/serv&gt; &lt;/det&gt; &lt;total&gt; &lt;vServ&gt;599.00&lt;/vServ&gt; &lt;vtNF&gt;599.00&lt;/vtNF&gt; &lt;vtLiq&gt;599.00&lt;/vtLiq&gt; &lt;/total&gt; &lt;infAdicLT&gt;4305108&lt;/infAdicLT&gt; &lt;/infNFSe&gt; &lt;/NFS-e&gt; &lt;Signature xmlns="http://www.w3.org/2000/09/xmldsig#"&gt; &lt;SignedInfo&gt; &lt;CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/&gt; &lt;SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/&gt; &lt;Reference URI=""&gt; &lt;Transforms&gt; &lt;Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/&gt; &lt;Transform Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/&gt; &lt;/Transforms&gt; &lt;DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/&gt; &lt;DigestValue&gt;JJtzvD6DJIlwd/ciT6gF1KZl7DA=&lt;/DigestValue&gt; &lt;/Reference&gt; &lt;/SignedInfo&gt; &lt;SignatureValue&gt; DCD5WbABTQpfS8GvmNBBP2+LRUZVWX35fSXA1lX6Thbwf/uyXaD0OdeDhC0Oz6hB5TnqKkUX Bgerr7PwUG0/jicrL2V7vTKZ+08DPhU+GwDPgkd8g5jk367rMsUe+rWq70e+98SjWpGNaFZn zY1Q7Wqu+uT9DPlDS6hci5Hi5Bg= &lt;/SignatureValue&gt; &lt;KeyInfo&gt; &lt;X509Data&gt; &lt;X509SubjectName&gt;CN=SB SISTEMAS LTDA:07081093000175, OU=AR SERASA, OU=RFB e-CNPJ A3, OU=Secretaria da Receita Federal do Brasil - RFB, O=ICP-Brasil, L=MARAU, S=RS, C=BR&lt;/X509SubjectName&gt; &lt;X509Certificate&gt;MIIGQjCCBSqgAwIBAgIIFHpqkzogjv8wDQYJKoZIhvcNAQEFBQAwdTELMAkGA1UE BhMCQlIxEzARBgNVBAoTCklDUC1CcmFzaWwxNjA0BgNVBAsTLVNlY3JldGFyaWEg ZGEgUmVjZWl0YSBGZWRlcmFsIGRvIEJyYXNpbCAtIFJGQjEZMBcGA1UEAxMQQUMg U0VSQVNBIFJGQiB2MTAeFw0xMTExMTgyMzAwMDBaFw0xNDExMTcyMzAwMDBaMIHN MQswCQYDVQQGEwJCUjELMAkGA1UECBMCUlMxDjAMBgNVBAcTBU1BUkFVMRMwEQYD VQQKEwpJQ1AtQnJhc2lsMTYwNAYDVQQLEy1TZWNyZXRhcmlhIGRhIFJlY2VpdGEg RmVkZXJhbCBkbyBCcmFzaWwgLSBSRkIxFjAUBgNVBAsTDVJGQiBlLUNOUEogQTMx EjAQBgNVBAsTCUFSIFNFUkFTQTEoMCYGA1UEAxMfU0IgU0lTVEVNQVMgTFREQTow NzA4MTA5MzAwMDE3NTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAjSzGFveA HxAaIc+bN3L9JqVUdnu2U0vWmMfrI8++uka9xpIF96omAwlfMmP+MAxop2W6KjT4 ahSP/ZZkgn32HuHu8Su+YEC6jVJntFfI+/M335G3Vcs0khqi6iIHQwQwM+yeRQ5v bcLy6s8QImUzeavKrRUUGu2X9X/Bjd9HDkkCAwEAAaOCAv8wggL7MAkGA1UdEwQC MAAwDgYDVR0PAQH/BAQDAgXgMB0GA1UdJQQWMBQGCCsGAQUFBwMCBggrBgEFBQcD BDAfBgNVHSMEGDAWgBSa3SK29nfpQm9IwlFAoFbi83Q/uzCBsgYDVR0RBIGqMIGn gRRDT05UQVNPRlRAVklBLVJTLk5FVKAbBgVgTAEDAqASExBMVUlTIEFOVE9OSU8g QkVOoBkGBWBMAQMDoBATDjA3MDgxMDkzMDAwMTc1oD4GBWBMAQMEoDUTMzI5MTEx OTg1MDA3NzE1ODAwODgxMjg1NzAwMDY3OTAwMDAwNTA3NDA3NDQ2OFNTUCBSU6AX BgVgTAEDB6AOEwwwMDAwMDAwMDAwMDAwVwYDVR0gBFAwTjBMBgZgTAECAwowQjBA BggrBgEFBQcCARY0aHR0cDovL3d3dy5jZXJ0aWZpY2Fkb2RpZ2l0YWwuY29tLmJy L3JlcG9zaXRvcmlvL2RwYzCB8wYDVR0fBIHrMIHoMEqgSKBGhkRodHRwOi8vd3d3 LmNlcnRpZmljYWRvZGlnaXRhbC5jb20uYnIvcmVwb3NpdG9yaW8vbGNyL3NlcmFz YXJmYnYxLmNybDBEoEKgQIY+aHR0cDovL2xjci5jZXJ0aWZpY2Fkb3MuY29tLmJy L3JlcG9zaXRvcmlvL2xjci9zZXJhc2FyZmJ2MS5jcmwwVKBSoFCGTmh0dHA6Ly9y ZXBvc2l0b3Jpby5pY3BicmFzaWwuZ292LmJyL2xjci9TZXJhc2EvcmVwb3NpdG9y aW8vbGNyL3NlcmFzYXJmYnYxLmNybDCBmQYIKwYBBQUHAQEEgYwwgYkwSAYIKwYB BQUHMAKGPGh0dHA6Ly93d3cuY2VydGlmaWNhZG9kaWdpdGFsLmNvbS5ici9jYWRl aWFzL3NlcmFzYXJmYnYxLnA3YjA9BggrBgEFBQcwAYYxaHR0cDovL29jc3AuY2Vy dGlmaWNhZG9kaWdpdGFsLmNvbS5ici9zZXJhc2FyZmJ2MTANBgkqhkiG9w0BAQUF AAOCAQEAD9Os0wUgI132kd4LcTjvqfO+nnBwt3uab6kx1zkoDxrngMt1GJCNa9+E OsxoHSqaDoC1CDuNEGLdnI+5jZawk+VlXmpnyaLn63ZKTBefq+ShSWhLx9CX+DMe 47PeVg0j0YiywRQbDpiy3ANrh+Jb+zaabLBe+6/fAdHoSSgioKZsPEfezSR/MMX+ 2Ay8WPSDxNgiIcMYe2kL12q7o/YT5pqBpBOtt8xo8bRNxx9aA41yifpS16z9iYKN bQB/B0Ebp9E09Vm2AsbuKSb8thHmRys+/tgVjkIWpNeTq6p5K/E/sZ/quKNqmVuC mdsVxTeGWXU+GXnUwjJqaFFMCJ/pAQ==&lt;/X509Certificate&gt; &lt;/X509Data&gt; &lt;/KeyInfo&gt; &lt;/Signature&gt; &lt;/envioLote&gt; </code></pre> <p>I've used this same code earlier without problems, I do not have much experience with xsd, so if anyone can give me a help would be grateful</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAlberto
    1. USRigotti
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POValidate a XML against a XSD: Undeclared XSD element
      1. USRigotti
      1. VTFavorite
    2. VO
      singulars
      1. POValidate a XML against a XSD: Undeclared XSD element
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POValidate a XML against a XSD: Undeclared XSD element
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThe links to your documents don't work. Google Docs fails with too many redirects. Please copy and paste your files directly into your question here on Stack Overflow. If they're too long to share here, then shorten them first. When you've shortened them, make sure they still exhibit the problem you're trying to solve.
      singulars
      1. POValidate a XML against a XSD: Undeclared XSD element
      1. USRob Kennedy
    2. CO+1 thanks for the edit. much better question now.
      singulars
      1. POValidate a XML against a XSD: Undeclared XSD element
      1. USJeroen Wiert Pluimers
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload