Question Re: Encoding version replacment in xml file in Technology Q&A

Encoding version replacment in xml file

former_member277492 — Thu, 26 Nov 2020 17:22:20 GMT

Hello Experts,

I have got a requirement where Incoming xml with encoding version 'UTF-8' as below and output file is expected with 'ISO-8859-1' tag.

Input:<?xml version="1.0" encoding="UTF-8"?>

Output: <?xml version="1.0" encoding="ISO-8859-1"?> (Required)

Sample file structure below;

<?xml version="1.0" encoding="UTF-8"?>

</SECCION7>

</EMPLEADO>

</EMPLEADOS>.

Do we have any groovy to fulfil this requirement. Please suggest.

Thanks in advance,

Best Regards,

Sree

Re: Encoding version replacment in xml file

Sriprasadsbhat — Thu, 26 Nov 2020 17:31:17 GMT

Hello Sreekar,

Before you send the data to Target system add content modifier and set the property with below parameters which changes the Encoding.

Action       Name                    Type                  Value
Create       CamelCharsetName        Constant              ISO-8859-1

Regards,

Sriprasad Shivaram Bhat

Re: Encoding version replacment in xml file

MortenWittrock — Thu, 26 Nov 2020 21:01:21 GMT

Hi Sreekar

You can't just change the value of the encoding attribute in the XML prolog (the <?xml .... ?> part at the beginning of your document). You need to change the actual encoding of the document and then reflect that in the encoding attribute. The answer from sriprasadshivaramabhat shows you how.

Regards,

Morten

Re: Encoding version replacment in xml file

former_member277492 — Wed, 02 Dec 2020 10:58:42 GMT

Hello Shivaram and Morten,

Thanks for your response.

I have configured content modifier after mapping step and configured the shared details and still in output payload i am getting UTF-8 only.

Kindly advise,

Best Regards,

Sree

Re: Encoding version replacment in xml file

former_member277492 — Wed, 02 Dec 2020 11:07:04 GMT

Hello Shivaram and Morten,

Thanks for your response.

I have configured content modifier after mapping step and configured the shared details and still in output payload i am getting UTF-8 only.

Enclsoing the screenshots for your kind perusal.

Best Regards,

Sree

Re: Encoding version replacment in xml file

former_member277492 — Thu, 03 Dec 2020 13:14:48 GMT

Hello Shivaram and Team,

Please could you suggest on above request on encoding version change.

Best Regards,

Sree

Re: Encoding version replacment in xml file

VijenderGouda — Sun, 06 Dec 2020 13:41:10 GMT

Hi sreekar ,

As explained above please store the value as a property" CamelCharsetName"

After that please use the below code in the mapping then you will achieve the data as output:

import com.sap.it.api.mapping.*;
import com.sap.it.api.mapping.MappingContext;
def String getProperty(String CamelCharsetName, MappingContext context) {
    def propValue= context.getProperty(property_name);
    return propValue;
}

Where You need to pass constant as " CamelCharsetName" to the Script and Map the target field.

Regards,
Vijender

Re: Encoding version replacment in xml file

former_member277492 — Wed, 09 Dec 2020 14:11:22 GMT

Hello Vijendra,

Thanks for the response.

I have tried the above provided approach. After Message Mapping I have used Content Modifier, set the below property and then i used the Groovy script before target.

Please let me know anything wrong am I doing or correct me any gap in my understanding

Thanks and Regards,

Sree

Re: Encoding version replacment in xml file

former_member277492 — Thu, 10 Dec 2020 08:43:02 GMT

Hello Vijendra and Team,

Please could you help me out on this.

Best Regards,

Sree

Re: Encoding version replacment in xml file

Sriprasadsbhat — Thu, 10 Dec 2020 10:00:41 GMT

Hello Sreekar,

Quick question which target adapter you are using and which format it should be.

Regards,

Sriprasad Shivaram Bhat

Re: Encoding version replacment in xml file

former_member277492 — Fri, 11 Dec 2020 07:37:40 GMT

Hello Shivaram,

I am using SFTP adapter and output structure is xml.

Thanks!!

Sree

Re: Encoding version replacment in xml file

former_member277492 — Mon, 14 Dec 2020 07:47:17 GMT

Hello Shivaram,

Any clue on above mentioned topic please.

Best Regards,

Sree

Re: Encoding version replacment in xml file

former_member277492 — Mon, 14 Dec 2020 13:24:48 GMT

Hello Shivaram,

Any clue about above issue.

Thanks in advance,

Sree

Re: Encoding version replacment in xml file

Sriprasadsbhat — Mon, 14 Dec 2020 14:25:20 GMT

Hello Sreekar,

Below should help you.I have tried to replicate your scenario ( without receiving system ).

Step 1:

Add input XML

<?xml version='1.0' encoding='UTF-8'?>
<Root>
	<Record>
		<CustomerName>üzüm bağları</CustomerName>
		<CustomerID>C1</CustomerID>
		<OrderNo>Ord1</OrderNo>
		<OrderDesc>Headset</OrderDesc>
		<OrderDate>15-11-2020</OrderDate>		
	</Record>
	<Record>
		<CustomerName>XYS Corp</CustomerName>
		<CustomerID>C2</CustomerID>
		<OrderNo>Ord12</OrderNo>
		<OrderDesc>HardDisc</OrderDesc>
		<OrderDate>11-11-2020</OrderDate>
	</Record>
	<Record>
		<CustomerName>üzüm bağları</CustomerName>
		<CustomerID>C3</CustomerID>
		<OrderNo>Ord22</OrderNo>
		<OrderDesc>Mouse</OrderDesc>
		<OrderDate>12-11-2020</OrderDate>
	</Record>
</Root>

Step 2:

Add below script if you want to convert encoding of input data ( content )

import com.sap.gateway.ip.core.customdev.util.Message;
import java.util.HashMap;
def Message processData(Message message) {
       //Get Body 
       def body = message.getBody();       
       def map = message.getProperties();
	  
       def op=new String(body.getBytes("UTF-8"), "ISO-8859-1");
       message.setBody(op);      
       message.setProperty("CamelCharsetName", "ISO-8859-1");      
       return message;    
}

Step 3:

Add XSLT mapping to remove XML declaration tag (which contains UTF-8)

<xsl:stylesheet version="3.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="xml" omit-xml-declaration="yes" />
  <xsl:template match="@*|node()">
    <xsl:copy>
      <xsl:apply-templates select="@*|node()"/>
    </xsl:copy>
  </xsl:template>
</xsl:stylesheet>

Step 4:

Add content modifier to set the XML declaration tag you are looking for.

<?xml version="1.0" encoding="ISO-8859-1"?>
${in.body}

Regards,

Sriprasad Shivaram Bhat

Re: Encoding version replacment in xml file

former_member277492 — Mon, 14 Dec 2020 18:31:20 GMT

Hello Shivaram,

Thank you for the prompt response.

I have Implemented recommended steps and achieved the requirement as output xml with ISO encoding tag.

I have used XSLT and set the xml declaration tag before target.

Thank you once again for your time and help!!

Best Regards,

Sree

Re: Encoding version replacment in xml file

Sriprasadsbhat — Tue, 15 Dec 2020 05:29:18 GMT

Hello Sreekar,

Please close the thread if above answers your query by accepting correct answer.

Regards,

Sriprasad Shivaram Bhat

Re: Encoding version replacment in xml file

former_member277492 — Tue, 15 Dec 2020 08:50:28 GMT

Hello Shivaram,

I have accepted the answer and closed the thread.

Thanks,

Best Regards,

Sree

Re: Encoding version replacment in xml file

former_member105769 — Wed, 10 May 2023 09:48:24 GMT

The code in Step 2 gives an error:

Error Details

java.lang.NoSuchMethodException: No signature of method: org.apache.camel.component.cxf.converter.CachedCxfPayload.getBytes() is applicable for argument types: (java.lang.String) values: [UTF-8] Possible solutions: getAt(java.lang.String), getClass(), getBody()