on 07-18-2007 7:38 AM
Hi,
I am Working on Idoc to File scenario.
I would like to know the content conversion partmenrts for the follwoing structure.
Structrure is as below:
Message Type
Header Record 1..unbounded
. Field1 0...1
. Field2 0...1
. Field3 0...1
.. Detaillines 0...unbounded
... Field3 0..1
... Field4 0..1
.. Detaillines2 0..unbounded
... Field6 0...1
... Field7 0...1
Can you please advise.
Regards,
Manoj Kumar
I worked with field fixed length option.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Manoj,
Try this Content Conversion parameters:
RecordSet Structure - Header,, Detaillines1,, Detaillines2,*
Header.addHeaderLine - 0
Header.fieldFixedLength- Length of Field1,Field2,Field3
Header.endSeparator-'nl'
Detaillines1.addHeaderLine - 1
Detaillines1.fieldFixedLength - length of Field4, Field5
Detaillines1.endSeparator -'nl'
Detaillines2.addHeaderLine - 2
Detaillines2.fieldFixedLength - length of Field6, filed7
Detaillines2.endSeperator- 'nl'
regards
Vikas
Message was edited by:
Vikas Agarwal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vikas,
I used the content conversion, but i landed with the follwing error.
Conversion initialization failed: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Parameter '.fieldFixedLengths' or '.fieldSeparator' is missing
Please advise.
Thanks and Regards,
Manoj
Hi,
I used the follwing parameters.
HeaderRecord.fieldFixedLengths 1,1,10,2,4,12,3,1,9,1,4,1,1,1,2,1,4,4,2,3,1,8,4
HeaderRecord.fieldNames field name with comma seperator
HeaderRecord.endSeparator 'nl'
HeaderRecord.fixedLengthTooShortHandling ignore
Detaillinesforeachpart.fieldFixedLengths 1,1,10,12,7,49
Detaillinesforeachpart.fieldNames fieldnames with comma seperatoer
Detaillinesforeachpart.endSeparator 'nl'
Detaillinesforeachpart.fixedLengthTooShortHandling ignore
Trailerrecord.fieldFixedLengths 1,79
Trailerrecord.fieldNames field names with comma seperator
Trailerrecord.endSeparator 'nl'
Trailerrecord.fixedLengthTooShortHandling ignore
Please let me know, if some thing to be added.
Regards,
Manoj
RecordSet Structure = Header,,Detaillnes,,Detaillines2,* is the right one.
But stantosh ain't those fcc parameters for file as sender ? In this case itz receiver .
Cheers
<b>*RAJ*
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
<i>Header Record 1..unbounded
. Field1 0...1
. Field2 0...1
. Field3 0...1
.. Detaillines 0...unbounded
... Field3 0..1
... Field4 0..1
.. Detaillines2 0..unbounded
... Field6 0...1
... Field7 0...1</i>
>>
Is Detaillines & Detaillines2 under the node Header ? Or is it at the same level as of Header ?
If Detaillines & Detaillines2 are under the node Header, you cannot do content conversion using the features provided by File adapter. You will have to have them at the same level of header and then build the logic in your mapping.
Note that the drawback of File adapter is that it cant handle hierarchy.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey,
RecordSetStructure= Header, Detaillines,Detaillines2
Header.addHeaderLine = 0 or 1.
Header.fieldFixedLengths= you have 3 fields so give their lengths
Header.fixedLengthTooShortHandling = ignore.
Header.fieldSeparataor = as you wish *Most widely used ( , ).
Header.endSeparataor = 'nl'.
Detaillines.fieldFixedLengths= you have 2 fields so give their lengths
Detaillines.fixedLengthTooShortHandling = ignore.
Detaillines.fieldSeparataor = as you wish *Most widely used ( , ).
Detaillines.endSeparataor = 'nl'.
Detaillines2.fieldFixedLengths= you have 2 fields so give their lengths
Detaillines2.fixedLengthTooShortHandling = ignore.
Detaillines2.fieldSeparataor = as you wish *Most widely used ( , ).
Detaillines2.endSeparataor = 'nl'.
wroks >?
Cheers
<b>*RAJ*
*REWARD POINTS IF FOUND USEFULL*</b>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Your FCC parmaters would look like this
Recordset Structure MessageType,Header,Detaillines,Detaillines2
you need to have
addHeaderLine
fieldFixedLengths
endSepartor
This link will also help you. for receiver FCC
/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion
Regards,
Ramesh P
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Manoj
Give the FCC parameter as
RecordSet Structure = Header,,Detaillnes,,Detaillines2,*
Header.endSeparator = 'nl'
Header.fieldFixedLengths = field length
Header.fieldFixedLengthType = char/byte
Header.fieldNames = field1,field2,field3,.....
Header.keyFieldValue = Header
Detaillnes.endSeparator = 'nl'
Detaillnes.fieldFixedLengths = field length
Detaillnes.fieldFixedLengthType = char/byte
Detaillnes.fieldNames = field1,field2,field3,.....
Detaillnes.keyFieldValue = Detaillnes
Detaillines2.endSeparator = 'nl'
Detaillines2.fieldFixedLengths = field length
Detaillines2.fieldFixedLengthType = char/byte
Detaillines2.fieldNames = field1,field2,field3,.....
Detaillines2.keyFieldValue = Detaillines2
The keyFieldValue should be the Value which identifies your record either as Header/Detaillines/Detaillnes2.
Regards
Santhosh
Message was edited by:
Santhosh Kumar V
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.