Hello there
I'm trying to parse a positional flat file into BizTalk 2006, the file
contains a header, detail & a trailer.
Thus far I have created a schema similar to that depicted below :-
<Schema>
<CEInputFile> ---- Root Node
<Header> ----- Child Record
<HO> ---- Child
Element
<FileCreationDate>
--- Child Element
<ChannelID> --
Child Element
<.....> --- Child
Element
<CEDetail>
----------------------- Child Record
<....> Child
Element
<....>
.
.
.
<Trailer> ------ Child
Record
<....> Child
elements
I have set the Child Delimited type of the ROOT node to Delimited
Child Delimiter to - 0x0D 0x0A
Child Order to - PostFix
For the Child Record Nodes (Header, CEDetail & Trailer) I have set the
Structure to - Positional.
For the Header & Trailer I have set the :-
Max Occurs = 1
Min Occurs = 1
For the Detail I have set the :-
Max Occurs = Unbounded
Min Occurs = 1
I am able to Validate my Schema, but when I try to Validate an Instance
of the Schema, I get the following error.
C:\Tutorial\Lessons\TranformFile\FileDrop\sourceFile.okm: error BEC2004:
Unexpected data found while looking for:
'\r\n'
The current definition being parsed is CEInputFile. The stream offset
where
the error occured is 77. The line number where the error occured is 2. The
column where the error occured is 6.
The first few records of my source file are pasted below
I would be awfully grateful if someone could please give me pointers
on what I might be doing wrong.
Regards
Ghost
HOBEST 070531ProfiBanka-ex****t trans. hist.Pouze ucetni transakce
6789012345678901234567890123456789012345678901234567890123456789012345678901234567890
510000000029990247200705301082007052901858000000237303242+000000388175956+000000000000000+000000150872714+EUPHONY
CZECH REPUBLIC A.S. CZ3201000000000029990247
52001300000000029990247000019226735028700001001CZK000000000011950CZK0000000000119500
301-30052007 1604 705102
105225007041280300704128030000000308000000000000000000002007053020070530200705302007053015
00000SERCLOVA JARMILA
Platba ve prospech
vaseho
uctuSERCLOVA JARMILA
52003170000000029990247000000501022900400026001CZK000000000011950CZK0000000000119500
120-20070529 0005 29000112S
007041161000704116100000000308000000000000000000002007052920070530200705292007053014
00000VLADIMIR HANZIK
Uhrada z jine banky
VLADIMIR HANZIK