Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Problem in creating an Input Schema for the Positional Flat File
- This topic has 0 replies, 1 voice, and was last updated 9 years, 10 months ago by
community-content.
-
AuthorPosts
-
-
October 19, 2006 at 2:58 AM #16116
I am facing problems in creating the input schema for the given inputs (types defined below).
The Input Schema has been defined as:
OrderRoot
| – Order Records (Repeating – max Occurs = Unbounded)
|— Header Rec (Non Repeating – max Occurs = 1)
|— Parent Rec (Non Repeating – max Occurs = 1, min Occurs = 0)
|— Child (Repeating)
|— Child Rec (Non-Repeating)
|— Grandchild 1 (Non-Repeating)
|— Grandchild 2 (Repeating)
|— Trailer Rec (Non-Repeating)
There can be many occurrences of Order Records and many Child records for a Parent Rec and many Grandchild 2 Rec for a single Child.
There can be 2 kinds of Inputs:
A Parent Order would look like
‘00’ Header
‘05’ Parent
‘10’ Child 1
‘15’ Grandchild 1A for Child 1
‘20’ Grandchild 2A for Child 1
‘20’ Grandchild 2B for Child 1
‘10’ Child 2
‘15’ Grandchild 1B for Child 2
‘20’ Grandchild 2C for Child 2
‘20’ Grandchild 2D for ‘Child 2
‘99’ Trailer
And a Child Only Order would look like
‘00’ Header
‘10’ Child
‘15’ Grandchild for Child
‘20’ Grandchild 2A for Child
‘20’ Grandchild 2B for Child
‘99’ Trailer
That is
Child has a record ChildRec.
It has 2 children of which one (grandchild2) has many occurrences.
The flat file consists of many Orders ( mixture of Parent Orders and Child Only Orders).
The concern:
Parent Rec has to be made Optional. Despite making min Occurs for Parent Rec as 0 , the Input schema fails for Child Only Order type Inputs. I tried manipulating other properties like Group min occurs and use Group Order sequence as choice, but the Child Only Order Input does fail. (Throwing Errors like – Incomplete Content: missing parent records or errors like found unexpected data while searching for ‘05’). The Input Schema works fine when Parent Order type Inputs are given.
I would like to know what modifications must be done to the input schema so that both the inputs succeed against the schema.
Thanks
Ankit
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.