Neuron ESB User Network

The Service Bus for the Connected Business

Special characters in XSLT transformations?

All,

A common pattern I've been using within NeuronESB is transforming an XML message into a CSV file, using an XSLT Step within a Process. I typically craft the XSLT as an XSLT transformation within the 'Repository', and then import the XSLT from the Repository into the XSLT Process Step.

For some CSV files, I have been including a HTML character for carriage return: 

Including the special character within the XSLT in the Repository works fine, and the output from the 'Test' button creates the CSV in the format I expect.

However, when I import the XSLT saved in the Repository into an XSLT Process Step, the carriage return is removed from the Transform editor (in the Process), and the CSV output from the Process does not include the carriage return.

Within the XSLT Transform editor (in the Process), I see the following:

  1. Even if I manually add the 
 to the XSLT, once I close the editor and re-open it, the 
 character is not displayed in the editor.
  2. The &#13; character is entirely removed if it is the only character within TEXT tags. example: <xsl:text>&#13;</xsl:text> (the character is removed from the editor, and the transform does not inject the carriage return during the Process)
  3. The carriage return will be injected into the CSV during the transform if there is another character as a prefix (ex: <xsl:text>,&#13;</xsl:text>), however, the &#13; display of the character is still removed from the editor.

Is there a more advisable method of creating carriage returns within an XSLT transformation?

Is there an alternative to having to re-edit an XSLT transformation in a Process Step to re-add carriage returns that already exist within an XSLT Transformation in the Repository?

Thanks!  

Views: 513

▶ Reply to This

Replies to This Discussion

Permalink Reply by Martin Wasznicky on April 3, 2017 at 9:14am

can you send us a project that includes the documents and steps to replicate?

Permalink Reply by Garrett Dieckmann on April 3, 2017 at 9:15am

Additionally, I have tried using the 'Enter' key on my keyboard to code a carriage return within the XSLT Transformation in the Repository. The 'Enter' key also adds a carriage return into the CSV output.

However, when I import an XSLT into a Process Step that has an 'Enter' key in the XSLT Transformation in the Repository, that character is also removed from the XSLT editor in the Process Step.

Permalink Reply by Manoj Talreja on April 3, 2017 at 9:50am

Please try it ‘&amp;#13' instead of  '&#13'

Permalink Reply by Garrett Dieckmann on April 3, 2017 at 9:58am

‘&amp;#13' does not seem to work in the Repository tester, nor during the Process Step.

In the Repository editor, the output is literally &amp;#13; within the Output.

Within the Process Step, the only output is the value '13' (with no other output).

Permalink Reply by Garrett Dieckmann on April 3, 2017 at 9:51am

Attached a project, as well as documentation to replicate.

Attachments:
Permalink Reply by Garrett Dieckmann on April 4, 2017 at 12:53pm

Manoj,

Can you provide the steps you used to verify that this works?

When I used <xsl:text><![CDATA[&#13;]]></xsl:text> within the XSL Transformation tester, the output nearly contained the literal, and displays as: &amp;#13;

When I used <xsl:text><![CDATA[&#13;]]></xsl:text> within the XSL Transform Process Step, the Trace output is simply 13;

Am I misunderstanding where this tag can be used?

Permalink Reply by Manoj Talreja on April 4, 2017 at 2:03pm

Garrett, 

I figured later it is not working with CDATA as well, so I have taken out that reply, What Neuron build you are using? we actually have to give you new build with this fix...

Thanks,

Manoj

Permalink Reply by Garrett Dieckmann on April 4, 2017 at 4:36pm

Manoj,

We are currently using 3.5.4.840.

Thanks,

Garrett

Permalink Reply by Manoj Talreja on April 6, 2017 at 1:24pm

Hi Garret, 

Please use the following xslt document, this should work :)

Attachments:
Permalink Reply by Garrett Dieckmann on April 7, 2017 at 9:40am

Hi Manoj,

Thank you for the attached XSLT. I did use the 'nl' variable construct, and that did resolve the issues that I was seeing in my original post.

Thank you,

Garrett

Permalink Reply by Garrett Dieckmann on April 6, 2017 at 8:40am

Can a document be provided that shows how it was verified that this issue was resolved in builds 981 and subsequently 982?

I've upgraded to 982, and do not see that the original cases have been resolved.

Permalink Reply by Manoj Talreja on April 6, 2017 at 12:39pm

Hi Garret, 

Can you provide me your email address?

RSS

Neuron ESB Product Support Forums and Communities

Latest Activity

Anupama Nair posted a discussion

Marketo Adapter Invalid Token

Hi,We are using the Marketo adapter to push account updates to Marketo. It works well for some time then starts failing with Invalid Token unless restarted. Is there a configuration that can be done so it can auto refresh the token when required?Thanks!See More
Nov 6, 2023
1 Comment
Sayantini Basak posted a discussion

Maximum payload size(REST API) for requests interfacing to NeuronESB

I am new to Neuron ESB and in our current scenario,We need to process batch transactions comprising of ~1000 records and send them to Neuron ESB for further processing. I would like to understand what is the maximum size of payload that can be transferred using REST interface to Neuron ESB.See More
Jul 22, 2022
0 Comments
Profile IconRobert E Dunie and Sayantini Basak joined Neuron ESB User Network
Apr 28, 2022
Profile IconDayanand, Frederic C, Steffen Greve-Oksfeldt and 1 more joined Neuron ESB User Network
Mar 16, 2022
Profile IconCam Vong and Mitja Luznar joined Neuron ESB User Network
Jan 27, 2022
Profile IconWill Hitzges, Chad Parsons, michael larsen and 4 more joined Neuron ESB User Network
Jun 11, 2021
Anupama Nair posted a discussion

ODBC stored proc polling with temporary tables

We have set up an ODBC adapter to poll a stored proc.We found that if the stored proc has a temporary table defined the rows returned are always 0.Any idea why this would be and what we can do to get around it?See More
Dec 14, 2020
3 Comments
Prasanth Kharade is now a member of Neuron ESB User Network
Dec 30, 2019
Welcome Them!

Badge

Loading…

Get Badge

© 2024   Created by Neuron Admin.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Sign in to chat!