on 2014 Sep 18 4:50 AM
Hello Guys,
I have a scenario where I would need to convert a plain text file with 14 columns into an XML file with only the first and tenth column from the text file.
This XML file would be sent to one receiver.
I also need to send the same text file to another receiver as text file (without any conversion).
I know that the easiest way to get this done is to ,
However, I am trying to avoid any ESR objects and trying the following approach
1. Use a Sender channel without any FCC to poll the 14 Column text file.
2. Send this file directly to First and Second receiver channel
3 Use a MessageTransformationBean in the first to convert the flat file to XML.(SimplePlain2XML)
But the only issue I face here is that I am unable to restrict the XML to have only 2 columns in it. I get all the 14 columns in the XML.
Is there a way to restrict the XML to contain pnly the desired fields during the plain to XML conversion in the module ?
Thanks in Advance,
Senthil
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Natarajan,
you can create the 2 interfacess for this case.
1 ) CSV(FCC) to XML - please map the first field and last field in to the target structure
2) with out mapping you need to create the different scenario to send same text file to another folder.
Regards
Srinivas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Btw, it is a CSV file and the field lengths are not fixed , hence I am using the field separator as comma to parse the file.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
79 | |
11 | |
10 | |
8 | |
7 | |
6 | |
5 | |
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.