Download - click-click IT Solutions
![Page 1: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/1.jpg)
no comprendo, SeñorAPEX Translation Mechanism
Peter Raganitschclick-click IT Solutions
Mittwoch, 19. Oktober 2011
![Page 2: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/2.jpg)
Peter Raganitschclick-click IT Solutions
[email protected]://www.click-click.at
http://www.oracle-and-apex.comhttp://apexlib.oracleapex.info
Mittwoch, 19. Oktober 2011
![Page 3: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/3.jpg)
APEX Translation Mechanism
Mittwoch, 19. Oktober 2011
![Page 4: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/4.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Mittwoch, 19. Oktober 2011
![Page 5: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/5.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
CorporateLanguage
Mittwoch, 19. Oktober 2011
![Page 6: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/6.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
APEX or Handmade?
Mittwoch, 19. Oktober 2011
![Page 7: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/7.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
What can be translated?
Labels
Data
Mittwoch, 19. Oktober 2011
![Page 8: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/8.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Supported by APEX
• all UI Texts (Item Label, Column Label, Region Title, ...)
• Messages
• Dynamic Translations
Mittwoch, 19. Oktober 2011
![Page 9: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/9.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
User Interface Text
inadvisable
Mittwoch, 19. Oktober 2011
![Page 10: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/10.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
User Interface Text• Application Computation• Application Definition• Application Process• Authentication Scheme• Authorization Scheme• Breadcrumb• Breadcrumb Template• Button Template• Calendar Template• Classic Report Column• Dynamic Action• Flash Chart• Flash Chart (Anychart5)• Flash Chart Series• Flash Chart Series (Anychart5)• Interactive Report• Interactive Report Column• Interactive Report Column Group• Item Label Template• List Entries• List Template• List of Values Entries
• Messages • Navigation Bar• Page Button• Page Computation• Page Definition• Page Item• Page Item Help• Page Processing• Page Validation• Parent Tab• Plugin• Plugin Attribute• Plugin Attribute Value• Plugin Event• PopUp LOV Template• Region• Region Template• Report Template• Shortcut• Tab• Template (general)
as in WWV_FLOW_TRANSLATABLE_COLS$
Mittwoch, 19. Oktober 2011
![Page 11: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/11.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Text Messages
Mittwoch, 19. Oktober 2011
![Page 12: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/12.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Dynamic Translations
Mittwoch, 19. Oktober 2011
![Page 13: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/13.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
4000
4001
4002
4003
APEX Concept
Main and Shadow
ApplicationMittwoch, 19. Oktober 2011
![Page 14: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/14.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Example
Mittwoch, 19. Oktober 2011
![Page 15: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/15.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Example
Mittwoch, 19. Oktober 2011
![Page 16: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/16.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Define Language
Shared Components > Globalization Attributes
Hint: Use Application Preference, Item Preference or Session to let the user choose.
Mittwoch, 19. Oktober 2011
![Page 17: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/17.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Translation ProcessShared Components > Translate
Mittwoch, 19. Oktober 2011
![Page 18: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/18.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
4000
4001
4002
4003
APEX Concept
Main and Shadow
ApplicationMittwoch, 19. Oktober 2011
![Page 19: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/19.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Language-Mapping
Hint: Main Application-ID * 100+ consecutive No
Must not end in Zero (used on the right side of the decimal point)
WWV_FLOW_LANGUAGE_MAP$
Mittwoch, 19. Oktober 2011
![Page 20: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/20.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Translation ProcessShared Components > Translate
Mittwoch, 19. Oktober 2011
![Page 21: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/21.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Seed Translatable Text
Seed copies all Text Strings into a Translation tableWWV_FLOW_TRANSLATABLE_TEXT$
Mittwoch, 19. Oktober 2011
![Page 22: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/22.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Translation ProcessShared Components > Translate
Mittwoch, 19. Oktober 2011
![Page 23: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/23.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Export XLIFF
“All translatable elements” = Source<>Target
Mittwoch, 19. Oktober 2011
![Page 24: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/24.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Export XLIFF
Mittwoch, 19. Oktober 2011
![Page 25: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/25.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Export XLIFF
S = UI TextT = Text MessageD = Dynamic Translation
ID of the Metadata table
Record-ID
Application-ID
Mittwoch, 19. Oktober 2011
![Page 26: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/26.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Translation ProcessShared Components > Translate
Mittwoch, 19. Oktober 2011
![Page 27: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/27.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
XLIFF Editor
Mittwoch, 19. Oktober 2011
![Page 28: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/28.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
XLIFF Editor
Mittwoch, 19. Oktober 2011
![Page 29: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/29.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
XLIFF 1.2
Mittwoch, 19. Oktober 2011
![Page 30: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/30.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Manually Edit
Mittwoch, 19. Oktober 2011
![Page 31: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/31.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Translation ProcessShared Components > Translate
Mittwoch, 19. Oktober 2011
![Page 32: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/32.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Upload XLIFF
Mittwoch, 19. Oktober 2011
![Page 33: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/33.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Translation ProcessShared Components > Translate
Mittwoch, 19. Oktober 2011
![Page 34: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/34.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Publish Application
Mittwoch, 19. Oktober 2011
![Page 35: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/35.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Pitfalls
Mittwoch, 19. Oktober 2011
![Page 36: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/36.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Pitfalls
• changing the Application ID
• “Loosing” the Translation Table (e.g. moving to another development environment)
• ongoing changes in the main application
• damaged XLIFF Structure (Texteditor)
• Problem with string length due to multibyte Characters
Mittwoch, 19. Oktober 2011
![Page 37: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/37.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Pitfalls
• Seed loads Text strings which aren’t ment for translation (but can possibly be changed by manual edit)
• Seed overwrites target text when source text is changed (correct typo).
• “Translating in the dark” without Context
• unclear status of translation progress
Mittwoch, 19. Oktober 2011
![Page 38: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/38.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Alternatives?
Mittwoch, 19. Oktober 2011
![Page 39: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/39.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
XLIFF 1.2
Development in Progress
Mittwoch, 19. Oktober 2011
![Page 40: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/40.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Translation Tool
Development in Progress
Mittwoch, 19. Oktober 2011
![Page 41: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/41.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Translation Tool
Mittwoch, 19. Oktober 2011
![Page 42: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/42.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Translation Tool
DEV TEST PROD
App App
TextText
Mittwoch, 19. Oktober 2011
![Page 43: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/43.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Translation Tool
• Integrated in development cycle
• Automatic Translations
• Context - where is this text displayed?
• Status of the translation progress
• soon at: http://www.click-click.at
Mittwoch, 19. Oktober 2011
![Page 44: click-click IT Solutions](https://reader033.vdocuments.us/reader033/viewer/2022052821/628fe3132f1d98546709284c/html5/thumbnails/44.jpg)
© c
lick-
clic
k IT
Sol
utio
ns
Peter Raganitschclick-click IT Solutions
Elisenstrasse 23A-1230 Wien
[email protected]://www.click-click.at
http://www.oracle-and-apex.comhttp://apexlib.oracleapex.info
Mittwoch, 19. Oktober 2011