Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Newbie: Flat file input sequence does not match Schema
- This topic has 4 replies, 1 voice, and was last updated 9 years, 2 months ago by
community-content.
-
AuthorPosts
-
-
November 29, 2006 at 6:58 PM #16606
Hello,
I created an Invoice schema using the flat file wizard after reading the "Creating a Flat file Schema from a document instance walkthrough".
My flat file may have one or more product records per invoice, a serial number record may or may not exist for each product record, none or multiple freight records may exists for each invoice. A sample of file record sequence is listed below:
IVA (Invoice)
IVB (product)
IVS (serial#)
IVB (product)
IVF (freight)
IVF (freight)
IVA (Invoice)
IVB (product)
IVF (freight)
When I tested this using validate instance in Visual Studio it failed with error message :
error BEC2004: Unexpected data found while looking for:
'IVF'
'IVS'
The current definition being parsed is Base. The stream offset where the error occured is 405. The line number where the error occured is 4. The column where the error occured is 0.
C:\BizInvoice\BzInvoiceSolution\BizInvoiceSchemas\IMInvoice.xsd: error BEC2004: Validate Instance failed for schema IMInvoice.xsd, file:
Component invocation succeeded.
I think if failed because it was not expecting another IVB in line 4. How do I set up the schema for multiple IVB records?
I have also tried creating a schema where:
- IVB is a child record of IVA
- IVS is a child record of IVB
- IVF is a child record of IVA
But I think it was confused with the child delimiter (not recognising the CRLF).
Any help would be much appreciated.
Cheers
-
November 29, 2006 at 8:13 PM #16610
Is it possible to email me your schema and a sample flat file
-
November 30, 2006 at 7:12 PM #16647
Hello Greg,
Thanks for your offer. I actually found the solution in a reply that you made to post #3557 that you made to someone else!
Cheers
-
April 21, 2009 at 8:44 PM #22185
Hi Greg,
If you are interested, I have a flat file similar to the one above and having lots of trouble creating a schema in biztalk for it. If I could send you through a sample of the flat file do you think you could pass on some help with how to create the schema.
Thanks
-
April 21, 2009 at 10:25 PM #22186
Sure, my email is greg.forsythe at gmail.com
-
-
-
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.