cancel
Showing results for 
Search instead for 
Did you mean: 

Reg usage of XSLT Mapping

Former Member
0 Kudos

Hi All,

We need to build an interface from PI to some database using JDBC adapter to send out emails to business users of the exception records created in the table.please help in using the xslt mapping for this interface.

Thanks in Advance,

Accepted Solutions (0)

Answers (5)

Answers (5)

former_member200962
Active Contributor
0 Kudos

Hi,

You can build your scenario as follows:

1) If the emails have to be sent from PI then you need to get back a response from the database.....if this is failure message then initiate your send email process...the whole process can be implemented using a BPM: Source ---> PI ---> JDBC --->PI ---> Email

2) You need to use a receiver mail adapter to send emails

3) Refer this blog of michal in which it is mentioned how to use the XSLT mapping and configuration for sending the emails:

/people/michal.krawczyk2/blog/2005/11/23/xi-html-e-mails-from-the-receiver-mail-adapter

You can also refer: http://www.riyaz.net/blog/xipi-sending-emails-using-xi-mail-adapter/

For more clarification you can also refer my answer in this thread:

The XSLT mapping that you need will be only in the PI ---> Email scenario...

Make sure that you download the desired email structure from service market place before you start with the scenario.......do let me know if my answer helps.

Regards,

Abhishek.

former_member181955
Contributor
0 Kudos

Hi

Check this blog for basic undestanding of xslt mapping.

/people/prasadbabu.nemalikanti3/blog/2006/03/30/xpath-functions-in-xslt-mapping

Thanks

Prasad Nemalikanti

Former Member
0 Kudos

Hi,

Please be specific with the input fields .I would like to know whether there will be some looping which has to be taken care.

For xslt you can refer. http://w3schools.com/xsl/default.asp

Thanks,

Tiny

Former Member
0 Kudos
Former Member
0 Kudos

I didn't get your question.

what is the scenario you are doing.....please brief me the req.

Please have a look at these video for XSLT mapping

http://www.altova.com/videos.asp?type=0&video=xmlmapping

Doc aswell

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/soa/soa-middleware...

Edited by: PSRK on Feb 13, 2009 2:31 AM