on 01-16-2008 5:13 AM
Hi mates,
I have a requirement where I have to pick the attachment(.csv format) of an incoming mail and store this file ( in .csv format)onto a file server using a reciever file adapter.
Please suggest how can i go about it ?
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Friends,
This is a very urgent requirement....please help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>>This is a very urgent requirement....
Please read the Rules of engagement. Using the word urgent will not help you in any means.
You have to use standard module "Payload swap bean" to bring the contents of attachment to payload coz. File receiver adapter can not process attachments.
Regards,
Jai Shankar
I understand that by saying that its not going to help but it can bring my question up in the queue
Jai, I have already done that and used payloadswapbean in my sender mail adapter to swap the original payload with the attachment.
What i wanted to know is that whether I can do this scneario without creating design objects also ?
Hi Snehal,
If you dont intend to do any changes the payload, then you can go ahead without creating IR objects. The output file will be exactly similar to the attachment you have.
P.S: Using the word ugent is considered rude by many the forums. Hence suggested you to refrain from doing that.
Regards,
Jai Shankar
Thanks Jai for your reply.
I have configured the scenario as u suggested (w/o design objects) but I am getting this error in CC monitoring of file reciever:
Could not process due to error: sun.io.MalformedInputException
Also, I would like to know if I need to use FCC at the reciever side. if yes then what could be the structure.
My mail attachment looks like this (obviously in csv, these fields would be comma seperated):
Lead code:12929
Order ref: sp/jaksd/1212
order type: S
Item code Qty
1221231 123
1212232 78
........... ...
end
Please help.
Jai,
After changing the transfer mode from text to Binary.
The XI system is creating a file but the data inside that file is junk. For e.g :
" "$"#,##0.00_);[Red]("$"#,##0.00) 7 * 2 ("$"* #,##0);_("$"* (#,##0);_("$"* "-"_);_(@_) . ) ) (* #,##0);_(* (#,##0);_(* "-"_);_(@_) ? , : ("$"* #,##0.00);_("$"* (#,##0.00);_("$"* "-"??_);_(@_) 6 + 1 (* #,##0.00);_(* (#,##0.00);_(* "-"??_);_(@_)à õÿ À à õÿ ô À à õÿ ô À à õÿ ô À à õÿ ô À à õÿ ô À à õÿ ô À à õÿ ô À à õÿ ô À à õÿ ô À à õÿ ô À à õÿ ô À à
This looks like when you open a CSV file in a notepad.
Please help how can i format this data so that it lokks like normal comma seperated form.
In a previous scneaio, I have worked on a simlar scenario but there my attachent was in txt format and the target file format was also .txt . Then, I got an advice from fellow SDN'ers to go without the creation of design objects(DT,MT, MI,MM,IM) and give somy dummy values for MI and interface namespace in configurations objects. Can i use that methodology here.
Please help ....prompt and precise replies would be very helpful and highly rewarded .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.