Flat File Schema Validates unexpectedly

Home Page Forums BizTalk 2004 – BizTalk 2010 Flat File Schema Validates unexpectedly

Viewing 1 reply thread
  • Author
    Posts
    • #23062

      Hi,

      I had the following data:-

      “HEADER”,”HeaderValue1″,”HeaderValue2″

      “ITEM”,”ItemValue1″,”ItemValue2″,”ItemValue3″

      “FOOTER”,”FooterValue1″

       

      Generated schema for the above using the Flat File Schema Wizard with the following tag identifier:-

      “HEADER”,”

      “ITEM”,”

      “FOOTER”,”

      and the ChildDelimiter would be “,”

      I also had change the following Root’s settings:-

      – ChildDelimiterType : Hexadecimal

      – ChildDelimiter : 0x22 0x0D 0x0A

       

      This schema works fine with the above data but it works unexpectedly when validate the following data:-

      “HEADER”,”HeaderValue1″,”HeaderValue2″

      “ITEM”,”ItemValue1″,”ItemValue2″,”ItemValue3″,”AdditionalData”

      “FOOTER”,”FooterValue1″

       

      Record ITEM had an additional field and schema SHOULD failed this data but VS schema validation passes unexpectedly. Check the generated output and shows the following:-

      <ItemValue3>ItemValue3″,”AdditionalData</ItemValue3>

       

      Anyone could help?

      Thanks in advance.

    • #23063

      I would suggest using the Wrap Character and set it to ” (double quote) for each field.

      You can change your Tags to be just “HEADER”, the record separator to 0x0D 0x0A and the field delimiter to ,

      This definitely fails when you add additional fields to ITEM

      • #23064

        Hi Greg,

        The your suggestion works like charm but when there is a ” (double quote) in one of the Field (string) it will failed. There is a possibility that ” exists as part of data as some fields are free text.

        Any other suggestion?

        Thank you.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.