RE: Validating a (wrong) message just succeeds

From: Shaheer Abubucker (shaheera_at_online.microsoft.com)
Date: 05/03/04 

Date: Mon, 03 May 2004 14:52:51 GMT

Sebastian,

Please attach to this post or email me the schema, a good csv file, and a
bad csv file that reproducess the problem so that I can look into this.

Thanks,
Shaheer Abubucker
Microsoft Biztalk Server Team
This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at
http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
&SD=msdn

--------------------
| Thread-Topic: Validating a (wrong) message just succeeds
| thread-index: AcQt7CGc2H4UaLiCQD+hoeTFxtvqJA==
| X-WN-Post: microsoft.public.biztalk.general
|
| Good afternoon (CET),

I'm running into validation problems with Biztalk 2004.
I have a csv-file, with multiple lines.

Each line is a record, delimited by 0x0D 0x0A, postfix

Each field within these records is delimited by ; (semi-colon), infix
Furthermore, the fields do not need to be filled, it can be that here are
two semi-colon repeating eachother (i.e. 1234;12;;445)

Everything works when I validate an instance and the isntance is correctly
formatted.
121212;1212;abcd;;567;899;999;99 (8 fields, ending with \r\n)
;1212;345;453;2234;abcdfeg;4455 (8 fields ending with \r\n !!!!)

What I would like to have is a validation that all fields are there, but
not more than the one in the schema of course.
So
121212;1212;abcd;;567;899;999;99;901 ( 9 fields, ending with
\r\n)!!!!!!!!!!!!!
;1212;345;453;2234;333;4455 (8 fields ending with \r\n !!!!)

this should not work, but validation does succeed. When I look at the
generated XML file, the 9th field of the first record (901 value) is simple
added to the 8th field, so that value becomes "99;901" .
If I have less then 8 fields in the first record, than ALL the fields of
the first record are filled (with values from the second record also) and
the remaining second record fields are put into the last field of the first
record

Of course, I have made a pipeline that containes a flat file disassembler.
There I put validate document structure to TRUE and I used the docspec of
the receive schema.
That didn't work.
Second, I added a XML validator and used the receive docspec again.
Didn't work either.

I tried setting the fields property 'Use requirements', but that doesn't
work aswell.

Any suggestions are greatly appreciated.

Regards,

Sebastian Hek
Accenture NL

|

Relevant Pages

  • Re: Mapping a CSV file to an Xml Schema
    ... These records are going to be inserted into a table which I have the schema ... Anothr goodness of schema is that if the business rules for validation is ... >> Can I map it to some sort of xml schema or something? ... > If you still want to go ahead and map the CSV file to an XML document, ...
    (microsoft.public.dotnet.xml)
  • Re: What is the logic of storing XML in a Database?
    ... I thought XML was supposed to be used for transport? ... The validation ... schema describing that CSV file, for the simple reason that no such ... standard schema exists. ...
    (comp.databases.theory)
  • Re: mandatory fields....
    ... I don't like writing WSDL and just wanted to clairfy that you don't have to ... write the WSDL first to adhere to 'contract first' develpoment and that you ... As for the answer for the validation logic that is contained in the XSD, ... > validation logic defined in the schema. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: XmlValidatingReader - just the FAQS?
    ... > read an xml file and an xsd file and validate the xml file using ... The XML schema is fine, and your instance document is valid by it, ... > Validation Error: The 'Name' element is not declared. ... The XmlSchema constructor should only appear in applications ...
    (microsoft.public.dotnet.xml)
  • Re: validating if a file is a true valid xml file that fits a cert
    ... ValidateXmlFileException if the XML stream or XML Schema fails validation. ... Public Sub ValidateXmlFile(ByVal SchemaNamespace As String, ...
    (microsoft.public.dotnet.languages.vb)