MessageTransformationBean Problem

[Senthilprakash1]

Hi Guys,

I have a .txt file with below structure

Plant|Contact_ID|Contact_Name
017S|96630|GIL1
017S|96630|GILami
017S|96630|ssss
017S|96630|ffff


The first line is Header Value and Rest of the lines are Item values.

and I dont want the Header Value into my system during conversion.

If i was using File Adapter FCC parameter, i would easly use Document Offset paramet with value to 1. and i will have a simple structure for conversion (only item values will be read into the system).

How to perform the samething using MessageTransformationBean?

I dont want to send the Header information to receiver system (prxy connection).

PS: I am not using any mapping here as well. and i cannot ask Source system to not to send the Header LIne in the text file.

Do help me. i know its bit tricky one.

[Former Member · Accepted solution]

chk this:

xml.documentSkipFirstRows=<noOfRows>

chk Stefan's reply:

[vishnu_pallamreddy · Accepted solution]

Hi Amit

In our file we have unnecessary data at the bottom of file, we want to omit that data also.

what is the solution for that?

Thanks in Advance,

vishnu pallamreddy.

[Senthilprakash1]

Hi Got the answer by myself.

I am updating here so that others can benefit from it.

if the Module parameter xml.conversionType =StructXML2Plain

then use the Parameter: xml.documentSkipFirstRows = <specify number of rows to be omitted>

If the Module Parameter  xml.conversionType = SimpleXML2Plain

then insert value for pameter xml.processFieldNames = fromFile

Description: *fromFile* means that the field name information is located in the header line of the file to be converted.

hope this helps.

Prakash.

Edited by: senthilprakash selvaraj on Aug 3, 2011 11:55 AM