on 2014 Feb 09 1:52 PM
Hi,
we are recieveing a CSV file as attachement through mail, wherein I would need to strat processing from 2nd line of the CSV file.
can you please suggest how can I process as above directly from mail.
Thank you.
John
Hello,
>> wherein I would need to strat processing from 2nd line of the CSV file.
I think only specifying "xml.documentSkipFirstRows" parameter will not help u to to skip rows, check Rene's reply
http://scn.sap.com/thread/1223739
Thanks
Amit Srivastava
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I see that you have added the module but the relevant parameters are missing for payload swap beam.
Please add the paramters as per the below blog to convert the attachment to main payload.(swap.keyname &swap.keyvalue)
Also for the MTB, please add another paramter - xml.documentSkipFirstRows and set it to 1.
Message was edited by: Hareesh Gampa
sorry i over looked.
Use the payload swapbean in the mail adapter to convert the attachment to main payload and then using Message Tranformation Bean
and the parameter "xml.documentSkipFirstRows" can be used to ignore the first lines..
Message was edited by: Hareesh Gampa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
73 | |
10 | |
9 | |
8 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.