Special Chars in XML input

[#1]

Hi Guru's,

I am doing a FIle(XML) to Proxy scenario. Unfortunately the file sent by 3rd party system contains some special chars like "&".

Here is what I get into XI. <Program>FY08 Pilsner - National Media & Fees</Program>. When I manually change it to <Program><![CDATA[FY08 Pilsner - National Media & Fees]]></Program> it works.

After reading some of the forum threads I came to know that we can do this using JAVA mapping before doing the actual graphical mapping. I need to what exactly I should be doing in JAVA mapping and I need some sample JAVA mapping code if somebody has already implemented this solution.

Thanks.

Srini Vaidyam

[Former Member]

I would suggest you do follow three things:

1.) Specify the character enconding at both sender and receiver side so that the file is successfully picked. The encoding must be in the xml declaration.

2.) Get the complete message (Main Window) in RWB and check, at which column i.e. (:main:, row:1, col:1) are you getting this error. Many times I attributed the error to special character but it turned out something else.

3.) Althogh, java mapping is an option but its not necessaily needed. (I tried a mapping with one field &&& and it worked OK).

But first confirm in trace that its & bothering you.

Regards,

AV.

[Former Member]

Thanks for all the helpful answers. I awarded points for all those hints that were helpful.

Here is how I resolved it. I persued with the 3rd party who sent us the XML file to encode the 4 special characters. It was not that bad on their end to encode these special chars.

Thanks.

Srinivas Vaidyam