weird characters after decrypting the file

[Former Member]

Hi Experts,

My requirement is decrypting the file (.CSV) and send it as an attachment to ECC inbound proxy.

By using PGP decryption module I was able to decrypt the file and was able to send the file as an attachment to ECC through Java Mapping.

Once the decryption was done If I open the file content I can see some weird characters in that file.

Note: I have checked with user it seems they were just renaming the .xls file to .csv.. I observed that if they could properly save the file as CSV  extension decryption is working fine. But the procedure which they were doing from long time will not be changed.

Can anyone help me how to handle these weird characters in the file and send the same normal file to ECC as an attachment.

Thanks

Gayathri.

[former_member190293]

Hi Gayathri!

If you receive renamed .XLS file you should treat it like Excel file, not .csv, as I guess. Use java for parsing it into desired format and after that send it to ECC.

Regards, Evgeniy.

[Former Member]

Hi Evgeniy,

Thanks for your quick reply.

could you please help me with the java code as i am not aware how to read Excel file.

Thanks

Gayathri.

[former_member186851]

Gayathri,

check the below link

XLS to XML conversion using JAVA Mapping in SAP XI 7.0 - Netweaver Technology - SCN Wiki