StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5231011
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-03-08T10:11:33.607
FavoriteCount
0
LastActivityDate
2011-03-08T10:11:33.607
LastEditDate
LastEditorUserId
0
OwnerUserId
18865
ParentId
5094041
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
<h2>Creating the Schema from Scratch</h2> I think using the Flat File Schema Wizard even for moderately complex structures, like this one, is not worth the trouble. My suggestion, is to think about the overall structure, and provide an outline using the Schema Editor. So, you example calls for a schema that has the following structure : A single <code>Header</code> record typed <code>00</code>, followed by a sequence of records typed <code>07</code>, <code>08</code>, <code>09</code>and <code>10</code> respectively. Each typed record is a structure in and of itself, which contains any number of repeating records. Finally, the structure ends with a single <code>GroupTrailer</code> record typed <code>16</code>, followed by an overall <code>Trailer</code>record, typed <code>17</code>. This maps nicely to the following schema in BizTalk : <img src="https://i.stack.imgur.com/g2Bkf.png" alt="Flat File Schema Structure"> Now, you need to tweak various properties of the nodes in order to instruct the Flat File Disassembler how to parse your incoming messages. Root Record The <code>Root</code> record is just there to group the various child records together and is required for a properly structured XML document. However, it does not participate in the parsing of the incoming structure. Therefore, you should set the <code>Child Delimiter Type</code> to <code>None</code>. Header, GroupTrailer and Trailer Records The <code>Header</code>, <code>GroupTrailer</code> and <code>Trailer</code> records each occur a single time, so leave their <code>Min Occurs</code> and <code>Max Occurs</code> properties to their default value of <code>1</code>. Furthermore, each of these records are identified by an appropriate <code>Tag Identifier</code> of <code>00</code>, <code>16</code> and <code>17</code> respectively. Finally, those records each end with a trailing CR/LF pair or characters. Therefore, set their <code>Child Delimiter Type</code> properties to <code>Hexadecimal</code>, and their <code>Child Order</code> properties to <code>Postfix</code>. Type07, Type08, Type09 and Type10 Structures This is the tricky part. One way to look at those structures is that they contain repeating records, each delimited with a trailing CR/LF. However, the structures themselves appear only once. Another important point is that you only need a single CR/LF pair as a delimiter for both the structures and their child records. So, the settings of the <code>Child Delimiter Type</code> properties should reflect that. For the <code>Type07</code>, <code>Type08</code>, <code>Type09</code> and <code>Type10</code> records, leave the default settings. That is, set the <code>Child Delimiter Type</code> property to <code>None</code> and the <code>Child Order</code> property to <code>Conditional Default</code>. In particular, there is no <code>Tag Identifier</code> set for these records. Type07_Record, Type08_Record, Type09_Record and Type10_Record Structures However, the <code>Type07_Record</code>, <code>Type08_Record</code>, <code>Type09_Record</code> and <code>Type10_Record</code> are set to occur multiple times. Set their <code>Min Occurs</code> properties to <code>0</code> and <code>Max Occurs</code> properties to <code>unbounded</code>. Additionnaly, each repeating record ends with a trailing CR/LF pair. Therefore, set their <code>Child Delimiter Type</code> properties to <code>Hexadecimal</code>, their <code>Child Order</code> properties to <code>Postfix</code> and their <code>Child Delimiter</code> properties to <code>0x0D 0x0A</code>. Reference For reference, the resulting settings are : <ul> <li><code>Root</code> : Delimited, None, Conditional Default.</li> <li><code>Header</code> : Delimited, Hexadecimal, <code>0x0D 0x0A</code>, Postfix, Tag Identifier <code>00</code>.</li> <li><code><Sequence></code> : (optional), MinOccurs: 1, MaxOccurs: 1</li> <li><code>Type07</code> : Delimited, None, Conditional Default.</li> <li><code>Type07_Record</code> : Delimited, Hexadecimal, <code>0x0D 0x0A</code>, Postfix, Tag Identifier <code>07</code>.</li> <li><code>Type08</code> : Delimited, None, Conditional Default.</li> <li><code>Type08_Record</code> : Delimited, Hexadecimal, <code>0x0D 0x0A</code>, Postfix, Tag Identifier <code>08</code>.</li> <li><code>Type09</code> : Delimited, None, Conditional Default.</li> <li><code>Type09_Record</code> : Delimited, Hexadecimal, <code>0x0D 0x0A</code>, Postfix, Tag Identifier <code>09</code>.</li> <li><code>Type10</code> : Delimited, None, Conditional Default.</li> <li><code>Type10_Record</code> : Delimited, Hexadecimal, <code>0x0D 0x0A</code>, Postfix, Tag Identifier <code>10</code>.</li> <li><code>GroupTrailer</code> : Delimited, Hexadecimal, <code>0x0D 0x0A</code>, Postfix, Tag Identifier <code>16</code>.</li> <li><code>Trailer</code> : Delimited, Hexadecimal, <code>0x0D 0x0A</code>, Postfix, Tag Identifier <code>17</code>.</li> </ul>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POBiztalk Flat File Transform multiple unbound records causing Unexpected Data Error
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USMaxime Labelle
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POBiztalk Flat File Transform multiple unbound records causing Unexpected Data Error
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

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.