Online Siebel Tutorials – Bookshelf » Blog Archive » What is Siebel EAI XSLT Service Business Service?

Learn by Sharing Siebel Knowledge…………

Loading

Home » EAI

What is Siebel EAI XSLT Service Business Service?

28 May 2009 4 Comments

The first question arises , why we need XSLT transformation, so here are some reasons -

- Suppose sometime we have the data in XML file but we want to present it in different ways depending on its contents.
- Or we need to read data of a email template from a file and email needs to be with colors, tables and more HTML look.
- Or when our email data is coming from different BCs or calculations in a Business Service, or Property Sets, and we are not able to use Siebel Communication Templates for sending emails.

In nutshell, when we want to generate nicely formatted data in HTML which can dynamically changed based on a XML file, we can make use of XSLT Transformation.

Reader, please suggest if you know any other way we can make use of Siebel XSLT Transformations.

XSLT Transformation Implementation:

The inputs/outputs arguments to business service – EAI XSLT Service –
Inputs:
XML file having data or any property set containing the XML data
XSL file or any property set containing XSL data which decides the Style and Logic to format the XML data. XSL data acts as Style Sheets (just like CSS files).

Output:
It will be UTF-16 or String output. See the last screen shot, you can see the output in Watch Window.

Before designing the workflow for XSLT Conversion, if you want to learn XSLT conversions using XSL and XML to HTML, visit http://www.w3schools.com/xsl/

You can use the below XML and XSL data to test in Siebel –
XML:

<?xml version="1.0" encoding="UTF-16"?>
<catalog>
<cd><title>Empire Burlesque</title>
<artist>fest</artist></cd>
<cd1><title>Hide your heart</title><artist>Test
</artist></cd1>
</catalog>

XSL:

<?xml version="1.0" encoding="UTF-16"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html><body><h2>My CD Collection</h2><table border="1"><tr bgcolor="#9acd32">
<th>Title</th><th>Artist</th></tr><tr><td><xsl:value-of select="catalog/cd/title"/>
</td><td><xsl:value-of select="catalog/cd/artist" /></td></tr></table></body>
</html></xsl:template>
</xsl:stylesheet>

NOTE: MAKE SURE TO PUT THE FULL XML/XSL MESSAGE IN WORKFLOW IN A SINLE LINE.

Key Checkpoints:

1. Below tag should always be there in XSL file –
<xsl:stylesheet version=”1.0″ xmlns:xsl=”http://www.w3.org/1999/XSL/Transform“>

2. Input XML and XSL data to EAI XSLT Service should be in UTF-16 format. If it is not, then make use of Transcode Service business service to convert UTF-8 data to String/UTF-16 data format.

Below are set of Screen Shots which will help creating a Workflow for XSLT transformation –

1.

Add a Process Property XMLOUT to store the output xml

2.

Add Input Arguments to EAI XSLT Service

3.

Provide the Output Process Property to Store Output Message

4.

While WF Simulation, you can see the Output Message in XMLOUT Property Set in Watch Window

You can also test XSL and XML conversion to generate HTML output using below weblink –
http://www.w3schools.com/xsl/tryxslt.asp?xmlfile=cdcatalog&xsltfile=cdcatalog_ex2

Read some more similar posts

Quizzeria – Siebel Workflow Interview Questions – Series: 3 (6)
This quiz talks about workflow topics and provides a bit of explanation to the answers. Please post your ...
How to use Transcode Service ? (0)
This has been nicely explained in a friends blog. Below is the description. ...
How Workflow Policy with Duration Works? (4)
This is for Workflow Policy which has a duration specified - 1. When the workflow policy conditions are ...
How Siebel Workflow Policy Works? (1)
Below is a detailed answer to certain questions like - - What happens when your workflow policy fire...
What is EAI Queuing? (0)
EAI Queuing is one of the Siebel integration tool to capture the SiebelMessage in a Integration Workflow ...