on 11-16-2005 1:11 PM
Hi,
I am reading a fixed width file using File sender adapter.
The data in the fixed width file is
Header1
Item1
Item2
Item3
Header2
Item1
Item2
Header3
Item1
In the recordset structure it is defined Header,,Item,
Header.fieldFixedLengths = 1,22
Header.endSeparator = 'nl'
Header.fieldNames = TYPE,CODE
Header.keyFieldName = 'H'
Header.lastFieldsOptional = YES
Header.ignoreRecordsetName = true
Item.fieldFixedLengths = 1,10
Item.endSeparator = 'nl'
Item.fieldNames = TYPE,QTY
Item.keyFieldName = 'I'
Item.lastFieldsOptional = YES
Item.ignoreRecordsetName = true
In the data type the definition of file is
<Message Type>
<Recordset>
<Header> Ocurrance 1 to unbounded
<TYPE>
<CODE>
<Item> Occurance 1 to unbounded
<Type>
<QTY>
The file is read but not shown in Message monitoring and SXMB_MONI.
but if i change the cardinality of recordset structure from Header,1,Item,1
I get the file in sxmb_moni but the structure is wrong.
Can any one tell what is wrong ?
Regards,
Monzy
Check if you have changed <i>Recordset Sequence</i> to <i>Variable</i>
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Monzy
I dont think there is a Name value pair key called..
<field>.keyFieldName
Check this one..it should be
Key Field Name = TYPE in the content conversion params and these entries in the namevalue pairs
Header.keyFieldValue=H
Item.keyFieldValue=I
Remember to remove the quotes - ' from the Value..The records pciked have to be chked for H not 'H'
Hope this solves ur issue
Hi Monzy,
I don't think there is
>> Header.ignoreRecordsetName = true/false
or
>> Item.ignoreRecordsetName = true/false
There is only ignoreRecordsetName = true/false.
Hence, due to the above conf, ignoreRecordsetName is always false for you!
Just give
<b>ignoreRecordsetName = true</b>
Best regards,
Felix
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.