Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Biz Talk NonXML > Positional Flat...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 942 of 978
Post > Topic >>

Positional Flat file Query

by =?Utf-8?B?R2hvc3RyaWRlcg==?= <Ghostrider@[EMAIL PROTECTED] Jun 28, 2007 at 04:52 AM

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
 




 3 Posts in Topic:
Positional Flat file Query
=?Utf-8?B?R2hvc3RyaWRlcg=  2007-06-28 04:52:00 
Re: Positional Flat file Query
Jan Eliasen <eliasen@[  2007-06-28 21:37:08 
Re: Positional Flat file Query
Jan Eliasen <eliasen@[  2007-07-11 22:19:53 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 6:39:21 CST 2008.