|
|
|
|
| Re: Implement XML Publisher and Bursting using same RTF template [message #416058 is a reply to message #415864] |
Thu, 30 July 2009 05:17   |
suman.g
Messages: 89
Registered: June 2009
|
Member |
|
|
====================================================================
I have uploaded .rtf (English,US)file and translation file for "de-DE" i.e. 'xx_xmlpb_test_de_DE.xlf'.
While uploading .xlf file for 'en-Us' it's giving error:
Error:The uploaded translation file is invalid. It should specify a valid target language and territory. Please verify that the file is in the correct format.
Is .rtf file in German language is also required to upload?
Please check if anything missing or need to be modified and what to do for this error.
This is my control file:
<?xml version="1.0" encoding="UTF-8"?>
<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="Bursting">
<xapi:request select="/XX_REQ_XMLPB_TEST_REP/LIST_G_REQUISITION_NUM">
<xapi:delivery>
<xapi:filesystem output="/path/11.5.0/out/">
</xapi:filesystem>
<xapi:email server="server mail id" port="25"
from="from email id">
<xapi:message id="${CF_REQID}" to="${CF_EMAIL}"
attachment="true" content-type="text/html" subject="XX Requisition XMLPB Test">
<font face="arial" size="3">
Dear iProcurement-User,<br/>
Please find the 'XX Requisition XMLPB Test' Report attached. <br/>
</xapi:message>
</xapi:email>
</xapi:delivery>
<xapi:document output="XX Requisition XMLPB Test" output-type="pdf" delivery="${CF_REQID}">
<xapi:template type="rtf" locale="en-US"
location="/ path/XMLPUB_TMP/xx_req_xmlpb_test_rep.rtf" filter="" translation="xx_xmlpb_test_en_US.xlf" >
</xapi:template>
<xapi:template type="rtf" locale="de-DE"
location="/path/XMLPUB_TMP/xx_req_xmlpb_test_rep.rtf" filter="" translation="xx_xmlpb_test_de_DE.xlf" >
</xapi:template>
</xapi:document>
</xapi:request>
</xapi:requestset>
Thanks in advance.
Kind Regards,
Suman
=============================================
|
|
|
|
|
|
| Re: Implement XML Publisher and Bursting using same RTF template [message #416224 is a reply to message #416059] |
Fri, 31 July 2009 04:51 |
suman.g
Messages: 89
Registered: June 2009
|
Member |
|
|
Hi All,
Now I am able to implement the bursting with translations successfully.
Data is coming correctly as per the trnslations in request output but in the attachment that bursting sending with
mail is not coming as in translation files. It's coming in US language only irrespective of the language chosen.
I have uploaded transaltion for German 'de_DE' and 'de_00' but mail attachment is not considering.
My control file is:
<?xml version="1.0" encoding="UTF-8" ?>
<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="Bursting">
<xapi:request select="/XX_REQ_XMLPB_TEST_REP/LIST_G_REQUISITION_NUM">
<xapi:delivery>
<xapi:filesystem output="/path/out/" />
<xapi:email server="mailrelay.tui.de" port="25" from="from_mailid">
<xapi:message id="${CF_REQID}" to="${CF_EMAIL}" attachment="true" content-type="text/html"
subject="XX Requisition XMLPB Test"><font face="arial" size="3"> Dear iProcurement-User,<br/>
Please find the 'XX Requisition XMLPB Test' Report attached. <br/></xapi:message>
</xapi:email>
</xapi:delivery>
<xapi:document output="XX Requisition XMLPB Test" output-type="pdf" delivery="${CF_REQID}">
<xapi:template type="rtf" locale="en-US"
location="path/xx_req_xmlpb_test_rep.rtf" filter="" />
<xapi:template type="rtf" locale="de-DE"
location="/path/xx_req_xmlpb_test_rep.rtf" filter=""
translation="xx_xmlpb_test_de_DE.xlf" />
<xapi:template type="rtf" locale="de-00"
location="/path/xx_req_xmlpb_test_rep.rtf" filter=""
translation="xx_xmlpb_test_de_00.xlf" />
</xapi:document>
</xapi:request>
</xapi:requestset>
Any reply is appreciated.
Thanks & Regards,
Suman
[Updated on: Fri, 31 July 2009 04:57] Report message to a moderator |
|
|
|
|
|
| Re: Implement XML Publisher and Bursting using same RTF template [message #417104 is a reply to message #416450] |
Thu, 06 August 2009 01:36 |
suman.g
Messages: 89
Registered: June 2009
|
Member |
|
|
Hi All,
In my report, everything in my report is working fine except amount format when running with German template language.
In my report I have taken the template language to filter the report. It's working fine but when running with template language as German, in request output headers and amount format is coming fine as 1.000,00 but in mail output headers are coming fine but amount format is coming as English format 1,000.00. Means Request output amount (correct) and report output amount (incorrect) is not matching.
My control file is given(I am not using translations but using different .rtf for English and German):
<?xml version="1.0" encoding="UTF-8"?>
<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="Bursting">
<xapi:request select="/XX_REQ_XMLPB_TEST_REP/LIST_G_REQUISITION_NUM">
<xapi:delivery>
<xapi:filesystem output="/u01/dev/11.5.0/out/">
</xapi:filesystem>
<xapi:email server="mailrelay.de" port="25"
from="apps@enttapp1.tui.de">
<xapi:message id="${CF_LANG}" to="${CF_EMAIL}"
attachment="true" content-type="text/html" subject="XX Requisition XMLPB Test">
<font face="arial" size="3">
Dear iProcurement-User,<br/>
Please find the 'XX Requisition XMLPB Test' Report attached. <br/>
</xapi:message>
</xapi:email>
</xapi:delivery>
<xapi:document output="XX Requisition XMLPB Test" output-type="excel" delivery="${CF_LANG}">
[COLOR=darkblue]<xapi:template type="rtf" locale="en-US"
location="xdo://TNC.XXREQXMLPB.en.US/?getSource=true"
filter=".//G_REQUISITION_NUM[CF_LANG='en']" > </xapi:template>
<xapi:template type="rtf" locale="en-US"
location="xdo://TNC.XXREQXMLPB.de.DE/?getSource=true"
filter=".//G_REQUISITION_NUM[CF_LANG='de']" > </xapi:template>[/COLOR]
</xapi:document>
</xapi:request>
</xapi:requestset>
I have also tried with giving
<xapi:template type="rtf" locale="en-US"
location="xdo://TNC.XXREQXMLPB.en.US/?getSource=true"
filter=".//G_REQUISITION_NUM[CF_LANG='en']" > </xapi:template>
<xapi:template type="rtf" locale="en-US"
location="xdo://TNC.XXREQXMLPB.de.DE/?getSource=true"
filter=".//G_REQUISITION_NUM[CF_LANG='de']" > </xapi:template>
<xapi:template type="rtf" locale="de-DE"
location="xdo://TNC.XXREQXMLPB.de.DE/?getSource=true"
filter=".//G_REQUISITION_NUM[CF_LANG='en']" > </xapi:template>
<xapi:template type="rtf" locale="de-DE"
location="xdo://TNC.XXREQXMLPB.de.DE/?getSource=true"
filter=".//G_REQUISITION_NUM[CF_LANG='de']" > </xapi:template>
One more doubt I have is, is it mandatory to filter the report on some criteria??
I don't want to filter my report, I just want to send whole report output to the mail Ids given as parameter and I don't have any criteria to filter.
I want that If I select template language as English then it should send report as per the English .rtf format and when select German as template language should send as per the German .rtf format.
Is this possible..??
Many thanks!!!
Suman
|
|
|
|
|
|
| Re: Implement XML Publisher and Bursting using same RTF template [message #419349 is a reply to message #419339] |
Fri, 21 August 2009 07:01 |
suman.g
Messages: 89
Registered: June 2009
|
Member |
|
|
Hi Omkar,
| Quote: | I am getting same err as you mentioned above. I manually exported English template to XLIFF and manually updated file with French Text.
Error:The uploaded translation file is invalid. It should specify a valid target language and territory. Please verify that the file is in the correct format.
|
Export translations freshly from template tab and save with .xlf format.
Open your .xlf file only with Internet Explorer > right click > view source-- this will open the text in notepad >
make your changes.. target language and target translations etc. save and close.
right click on IE opened text > refresh.
after refreshing this code should come fine without any error.
now upload this to your template.
Cheers,
Suman
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
