message monitoring

[Former Member]

hi all.

here i have developed a file to file scenario.

but the thing is xi is sucess in sending data from sender to reciever but when i look at sxmb_moni its showing only header and trailer but i cont find body .

the following is the body

HEADER|22012007|WMD

5000000303|220.05

5000001200|1230.05

5000001604|11345.05

5000001706|320.05

5000001707|21259

5000001800|232.05

5000003800|200.00

5000003804|38.05

5000003806|5213.10

5000003100|298.05

5000002801|228.10

TRAILER|12|40843.55

but how i can declare to identify body in sender Communication channel.

waiting for u r response.

bye.

regards.

seeta ram.

[Former Member]

Hi Ram,

What is the FCC parameters that you have used in your file adapter?

Did u use key field ? If not for header use the keyfield as Header, For body you can use | as keyfield

5000000303| and for trailer you can use Trailer as keyfield.

Check this blog by Shabarish Vijayakumar

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

Regards,

Sumit

Message was edited by:

Sumit Khetawat

[Former Member]

hi sumit.

thans fr your answer.

but as u said i have to use keyfieldname as | then what about keyfieldvalue.

which parameter do i need to pass for keyFieldValue .

waiting foryour rsponse.

bye.

regards.

seeta ram.

[Former Member]

Hi Ram,

Keyfield value will be |

What i am trying to say is in your input file for body you have data like this way..

5000003800|200.00

Of the above you can specify

5000003800 as field1,

as keyfield,

200.00 as field3.

So in your adapter you will write ..

BODY.fieldNames field1,keyField,field3

BODY.keyFieldValue

Regards,

Sumit

[Former Member]

hi sumit

what ur saying is body.keyfieldname keyfield

body.keyfieldvalue |

is it the above that what u r trying to say.

if then what about design.

do i need to cange the data type.

waiting for your response.

bye.

regards.

seeta ram.

[Former Member]

Hi Seeta,

yes that is what i meant.

You have to change your datatype to reflect | . Just add one more field.

Regards,

Sumit

[Former Member]

i have done what u said but still the body is not coming to sxmb_moni.

can u give me the exact answer.

bye.

regards.

seeta ram.

[Former Member]

Hi Ram,

Can you tell us what is your DT structure and what is the FCC parameters which you have mentioned in the adapter.

Regards,

Sumit

[Former Member]

my data structure is

DT_lccTolcc3

accdetails

header

keyfield

docdate

siteid

body

accno

keyfield

amount

trailer

keyfield

totalrec

totmat

and my fcc parameters

header,1,detailed,*,trailer,1

header.fieldNames keyfield,docdate,siteid

header.keyFieldValue HEADER

header.keyFieldName keyfield

detailed.fieldNames accno,keyfield,amount

detailed.keyFieldName keyfield

detailed.keyFieldValue |

detailed.fieldSeparator |

trailer.fieldNames keyfield,totalrec,totalamt

trailer.fieldSeparator |

trailer.keyFieldName keyfield

WAITING FOR YOUR GREAT ANSWER.

BYE

regards.

seeta ram.

[Former Member]

Hi Seeta,

I overlooked the sample file.

The below parameter will not work since theres only 1 | in your detail row.

detailed.keyFieldValue |

detailed.fieldSeparator |

Try with detailed.fieldFixedLengths .. ie if you can get a fixed length file..

Another easy option you can go for is ..

Read a row as a single line.

Now in your mapping you can write java code to seperate the header and detail record.

Regards,

Sumit

[Former Member]

Hi,

You can see full message in 'payload'.Check once again and aslo check your mapping.

Regards,

srinivas

[Former Member]

hi srinivas

in sender cc i have mentioned header.key fieldname as header

Value as HEADER

trailer.keyfieldname as trailer

trailer.keyfieldValue as TRAILER.

but i dont know how to deal with body because there is no key field foe body.

waiting for u r response.

bye.

regards.

seeta ram.

[Former Member]

Hi Seetha,

For BOdy use the keyField as |

5000001707|21259

Example :

body.fieldNames itemNo,keyField,sNo.

body.keyFieldValue |

Regards,

Sumit