dbTalk Databases Forums  

Oracle 10g Reports to Translation Hub

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss Oracle 10g Reports to Translation Hub in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
unique
 
Posts: n/a

Default Oracle 10g Reports to Translation Hub - 09-21-2007 , 01:23 PM






Hi!
I just figured out how to do this, as we're running a multilingual
application, and it's been recently discovered that a contract was
signed, implying that we can provide french reports - before they
asked us!!
Flip side is, that this is all with Oracle 10g install. On the plus
side, it's actually pretty easy:

1) Open Reports Builder.
2) Go To: Tools/File Conversion
3) Convert reports desired to ".rex"
4) Load .rex reports into Translation Hub
5) Run through Translation Hub
6) Convert files *back* to ".rdf"
7) Open reports in Reports Builder
8) Add line of Code, in AfterPForm or BeforeReport triggers:
a. "SRW.DO_SQL('alter session set NLS_LANGUAGE = ''FRENCH''');"
b. of course, replace ''FRENCH'' with
whatever language you're using.
c. the quotes are ALL single quotes.
9) Recompile and save reports.
10) Upload to where you'll use them!

These instructions have been written assuming that the application has
a base language, and a secondary language, and that there are actually
two different copies of each form on the application. You would store
the french reports with the french application. Or whatever the
language is.

Hope this helps someone!!


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.