Bursting & Translation

I see this question very often. Yes, bursting supports the translation and the implementation depends on the flavor. Lets go through the different scenario through these examples

Using bursting control file where layout templates and xlf files are on file system. In this
scenario, set the translation attribute under template section to xlf file path.


<xapi:document key="${EMPNO}"
output="c:\burst\sample\${EMPNO}_${ENAME}.pdf"
output-type="pdf" delivery="123">
<xapi:template type="rtf" locale="de-DE"
location="d:\burst_test\deptSummary.rtf"
filter=".//EMPLOYEE [locale='de-DE']"
translation="d:\burst_test\translation\deptSummary_de_DE.xlf" />
<xapi:template type="rtf" locale="en-US"
location="d:\burst_test\deptSummary.rtf"
filter=".//EMPLOYEE [locale='en-US']"
translation="d:\burst_test\translation\deptSummary_en_US.xlf" />

<xapi:template type="rtf" locale="ja-JP"
location="d:\burst_test\deptSummary.rtf"
filter=".//EMPLOYEE [locale='ja-JP']"
translation="d:\burst_test\translation\deptSummary_ja_JP.xlf" />
</xapi:document>




Bursting-EBS integration where layout template and xlf stored in Template Manager repository. Use the
XDO protocol to define the template location.


<xapi:document key="${TRX_NUMBER}" output="${TRX_NUMBER}"
output-type="pdf" delivery="file1"> <xapi:template type="rtf" locale=""
location="xdo://AR.RAXINV.${language}.${territory}/?getSource=true"
translation="" filter="" />
</xapi:document>


Based on Template code, Application Code, Language and Territory, process extracts the
translated layout from Template Manager repository.

In Enterprise release, Bursting is based on SQL query that we define in Bursting criteria page
of the Report. The Translation is based on the Locale value in SQL Query.

SELECT
CUSTOMER_ID KEY,
CST_TEMPLATE TEMPLATE,
TMPL_TYPE TEMPLATE_FORMAT,
CST_LOCALE LOCALE,
CST_FORMAT OUTPUT_FORMAT,
CST_DEL_CHAN DEL_CHANNEL,
CST_EMAIL PARAMETER1,
'accounts.receivable@oracle.com' PARAMETER2,
'bip-collections@oracle.com'PARAMETER3,
'Your Invoices' PARAMETER4,
'Hi'||CUST_FIRST_NAME||chr(13)|| 'Please find attached your
invoices.' PARAMETER5,
'true' PARAMETER6,
'donotreply@nowhere.com' PARAMETER7
FROM CUSTOMERS

Sample Control files are available here

Comments:

I have not been able to figure out how to format the e-mail address so that the full name is displayed. Example: 'Jack Smith '. Do you happened to know how to do it?

Posted by James O'Connor on December 22, 2009 at 10:04 PM PST #

DeliveryManager dm = new DeliveryManager(); // create a delivery request DeliveryRequest req = dm.createRequest(DeliveryManager.TYPE_SMTP_EMAIL); // set email subject req.addProperty(DeliveryPropertyDefinitions.SMTP_SUBJECT,"test mail"); // set SMTP server host req.addProperty( DeliveryPropertyDefinitions.SMTP_HOST, "mail.abc.com"); // set the sender email address req.addProperty(DeliveryPropertyDefinitions.SMTP_FROM, "first.last@host.com"); // set the destination email address req.addProperty( DeliveryPropertyDefinitions.SMTP_TO_RECIPIENTS, "\"Firstname Lastname , Mr.\" <first.last@host.com >" ); // set the content type of the email body req.addProperty(DeliveryPropertyDefinitions.SMTP_CONTENT_TYPE, "text/html;charset=UTF-8"); // set the document file name appeared in the email req.addProperty(DeliveryPropertyDefinitions.SMTP_CONTENT_FILENAME, "test.pdf"); // set the document to deliver req.setDocument("D:\\test.pdf"); Attachment attachment = new Attachment(); attachment.addHtmlAttachment("D:\\burst_test\\sample\\out\\2.html"); req.addProperty(DeliveryPropertyDefinitions.SMTP_ATTACHMENT, attachment); req.submit(); // close the request req.close();

Posted by ashish.shrivastava on July 01, 2010 at 07:24 PM PDT #

Hi, Please let me know if we can translate email subject and message body also using bursting. Thanks.

Posted by Manisha on May 11, 2011 at 01:15 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

bocadmin_ww

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today