Developer forum

Forum » Integration » Data Integration XSL Entity

Data Integration XSL Entity

E-mail notifications
António Ramos
Reply
Posted on 21/11/2015 11:18:38

Hi,

We are importing some products from an XML File with a XSL Transformation. Several product names have  ® reg and ™ trade symbols and when rendering without any output escaping in front-end the product/page title will render  reg;. 

To solve this we need to use disable-output-escape in XSL but when we enter on data integration setup, it displays this message "Reference to undeclared entity 'trade'. Line 1, position 423".

For this error we try <!DOCTYPE xsl:stylesheet [    <!ENTITY nbsp "&#160;">  ]> at XSL file and we get another error when running the integration "Error occured: XSLT compile error.".

I'm out of options... Anyone knows if there is any bug in data integration related to this? Or any workaround?

BR,

António Ramos


Replies

 
Morten Snedker
Posted on 23/11/2015 10:15:14
Reply

Hi António,

Working without XSLT it works fine for me. So I take it that the problem lies within the handling through our XSL.

<?xml version="1.0" encoding="utf-8"?>
<tables>
  <table tableName="EcomProducts">
    <item table="EcomProducts">
      <column columnName="ProductId"><![CDATA[PROD1]]></column>
      <column columnName="ProductName"><![CDATA[® Awesome product ™]]></column>
    </item>
  </table>
</tables>

This piece of XML is imported just fine, using XML for source and Ecom Provider for destination. Are you wrapping text in CDATA?

 

BR Snedker 

 
António Ramos
Posted on 23/11/2015 16:29:21
Reply

Hi Morten,

Thank you for your response. 

Wrapping inside CDATA generally works but we are struggling because our limitations: 

  • XML is external and generated by a tool
    • Node structure must be transformed
    • CDATA is inserted via XSL
  • ​Reg and trademarks comes encoded:
    • ​&amp;reg;
    • ​&amp;trade;
      • When disable-output-escaping it only give us &trade;

When rendered at front-end the page title renders &trade, even if we decode the string. Do you see any possible solution for this?

Thanks in advance.

BR,

António Ramos

 

You must be logged in to post in the forum