{"id":16820,"date":"2023-03-16T21:47:19","date_gmt":"2023-03-16T21:47:19","guid":{"rendered":"https:\/\/kiusi.com\/?p=16820"},"modified":"2023-03-16T21:47:20","modified_gmt":"2023-03-16T21:47:20","slug":"como-traducir-los-mensajes-internos-de-apex","status":"publish","type":"post","link":"https:\/\/kiusi.com\/en\/como-traducir-los-mensajes-internos-de-apex\/","title":{"rendered":"How to translate APEX internal messages"},"content":{"rendered":"

In today's globalized world it is so important to be able to have our applications well translated.<\/p>\n\n\n\n

In this post I want to show you how we can use the Oracle APEX Message function to translate text strings (or messages) generated from stored procedures, functions, triggers, packed procedures and PL\/SQL functions.<\/p>\n\n\n\n

Remember that Oracle APEX is translated into 10 languages including Spanish \ud83d\ude0a<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

But when we call procedures within our application, the internal APEX messages are in English, and that's why we use this APEX feature called \"Text Message\" to translate those messages.<\/p>\n\n\n\n

There are about 126 internal messages that need to be translated, as shown in the excerpt from the table below:<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

This table can be viewed in its entirety in the Oracle APEX documentation in the following link<\/strong><\/a>.<\/p>\n\n\n\n

In addition, there are also messages that require translation that correspond to the Interactive Grid.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

And of course, there are also messages to be translated that correspond to the Interactive Report.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

On the other hand, if we use the new APEX Progressive Web App (PWA) functionality we also need to translate the messages.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

When using smart filters and facet searches in our application, it is also necessary to translate the messages.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Here is an example of how to translate a message in APEX.<\/p>\n\n\n\n

We open our application in Oracle APEX.<\/p>\n\n\n\n

For this demonstration I have created a simple application in Oracle APEX.<\/p>\n\n\n\n

It is important to note that Oracle Application Express is translated by default into 10 languages, as I mentioned above (English, German, Spanish, French, Italian, Japanese, Korean, Brazilian Portuguese, Simplified Chinese and Traditional Chinese). Unfortunately, if our application uses a different language, we must translate ourselves the internal messages displayed by the APEX reporting engine, such as the Actions button, the search or the \"next\/previous, etc.\" links.<\/p>\n\n\n\n

But before we learn how to translate APEX internal messages, let's learn how APEX works with the \"Text Messaging<\/strong>\u201d.<\/p>\n\n\n\n

First of all, we define the language of our application in the globalization section of the application definition.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Save the changes.<\/p>\n\n\n\n

Next, we can create a greeting message for the user.<\/p>\n\n\n\n

To do this, we go to Shared Components => Text Messages<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Click on the button Create Text Message<\/strong>.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

The modal window for creating the Text Message opens.<\/p>\n\n\n\n

En primer lugar, ingresamos el nombre del mensaje de texto, por ejemplo, GREETING_MSG, seguidamente seleccionamos el idioma inglés y en el recuadro de texto colocamos: <h1>Good morning %0!<\/h1>.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Seguidamente, realizamos el mismo procedimiento para crear el texto en español, como sigue: <h1>Buen día %0!<\/h1>.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Click on the Create Text Message button.<\/p>\n\n\n\n

What we have done is to create a message called GREETING_MSG<\/strong> in our application in Spanish as Buen D\u00eda %0 and in English as Good morning %0.<\/p>\n\n\n\n

Let's see how we can now invoke this message:<\/p>\n\n\n\n

BEGIN\r\n--\r\n-- Print the greeting\r\n--\r\nHTP.P(APEX_LANG.MESSAGE('GREETING_MSG', V('APP_USER')));\r\nEND;\r<\/code><\/pre>\n\n\n\n
The way in which the attribute is defined\u00a0p_lang<\/strong> depends on how the APEX engine derives the main language of the application. For example, if we are running the application in Spanish and the above call is made to the APEX_LANG.MESSAGE API, the APEX engine first looks for a message called GREETING_MSG with a LANG_CODE of\u00a0is<\/strong>.\u00a0Si no encuentra nada, se revierte al\u00a0atributo Application Primary Language.\u00a0Si a\u00fan no encuentra nada, el motor\u00a0APEX\u00a0busca un mensaje con este nombre con un c\u00f3digo de idioma de\u00a0in<\/strong>.<\/p>\n\n\n\n
Function syntax:<\/strong><\/p>\n\n\n\n
APEX_LANG.MESSAGE (\r\n    p_name            IN VARCHAR2 DEFAULT NULL,\r\n    p0                IN VARCHAR2 DEFAULT NULL,\r\n    p1                IN VARCHAR2 DEFAULT NULL,\r\n    p2                IN VARCHAR2 DEFAULT NULL,\r\n    ...\r\n    p9                IN VARCHAR2 DEFAULT NULL,\r\n    p_lang            IN VARCHAR2 DEFAULT NULL,\r\n    p_application_id  IN NUMBER   DEFAULT NULL )\r\nRETURN VARCHAR2;\r<\/code><\/pre>\n\n\n\n
Parameter Meaning<\/strong><\/p>\n\n\n\n
Parameter<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
p_name<\/td>Message name as defined in Text Messages under Shared Components of your application in Oracle APEX .<\/td><\/tr>
p0 a trav\u00e9s de p9<\/td>Dynamic substitution value: p0 corresponds to %0 in the translation chain; p1 corresponds to %1 in the translation chain; p2 corresponds to %2 in the translation chain, and so on.<\/td><\/tr>
p_lang<\/td>Language code of the message to retrieve. If not specified, APEX uses the current language for the user as defined in the Application Language Derived From attribute.<\/td><\/tr>
p_application_id<\/td>Used to specify the ID of the application within the current workspace that owns the translated message you wish to return. Useful when encoding packages that may be called outside the scope of APEX, such as packages called from a database job.<\/td><\/tr><\/tbody><\/table>
Parameters description<\/figcaption><\/figure>\n\n\n\n
Now that we know this function, let's see how to implement it in our application.<\/p>\n\n\n\n
For example, on page 1 of our application we are going to greet the logged in user.<\/p>\n\n\n\n
In the breadcrumb bar region we create a dynamic content region and enter the following code:<\/p>\n\n\n\n
BEGIN\r\n--\r\n-- Print the greeting\r\n--\r\nHTP.P(APEX_LANG.MESSAGE('GREETING_MSG', V('APP_USER')));\r\nEND;\r<\/code><\/pre>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
As our application is defined in the primary language as Spanish (United States) (es-us), when running the application, we will see the user greeting in Spanish:<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
Now if we change the primary language of the application to English, we will see that when the page is executed, the message will be displayed in English.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
Now that we know how Text messages work in APEX, let's see how we can translate APEX internal messages.<\/p>\n\n\n\n
For this second demonstration we are going to define our application with the language Ukrainian (uk)<\/strong>. (I choose this language because I am proudly of Ukrainian descent, my mother was born in Poltawa, Ukraine, and I have a great affection for my mother's land, and a great love for my homeland Argentina where I was born and raised and now that I live and enjoy the United States I feel very globalized \ud83d\ude0a).<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
When running our application, nothing will be in Ukrainian, right? \ud83d\ude0a then let's create the text message for the greeting in Ukrainian (I trust google translator \ud83d\ude0a ).<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
And when executing we see the greeting \ud83d\ude0a<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
Now on the other hand, I have the interactive Employee report on page 2.<\/p>\n\n\n\n
What I can translate in my application I do on my own, for example the name of the navigation path entry we translate it from Employees to \u0421\u043f\u0456\u0432\u0440\u043e\u0431\u0456\u0442\u043d\u0438\u043a\u0438. <\/p>\n\n\n\n
Undoubtedly everything that we can translate such as the headers of the report, or when more data is found or if there are no records in the report, all of that we can translate from the same page designer without problems.<\/p>\n\n\n\n
But how can we translate for example the name of the Actions button or the Go button of the interactive report, because now the APEX engine cannot find a Ukrainian translation and it will show it in English.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
So let's see an example of how to translate the name of the Actions button, and the name of the Go button in the search bar into the Ukrainian language.<\/p>\n\n\n\n
Interactive Report Messages<\/strong><\/p>\n\n\n\n
We create two text messages:<\/p>\n\n\n\n
Text Message<\/strong><\/td>In English<\/strong><\/td>In Ukrainian<\/strong><\/td><\/tr>
APEXIR_GO<\/td>Go<\/td>\u0417\u043d\u0430\u0439\u0442\u0438<\/td><\/tr>
APEXIR_ACTIONS<\/td>Actions<\/td>\u0414\u0456\u0457<\/td><\/tr><\/tbody><\/table>
Description of text messages<\/figcaption><\/figure>\n\n\n\n
These text messages can be found in the table 21-3<\/strong><\/a> from the Oracle APEX documentation regarding the internal message translation issue that I mentioned earlier in this article.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
Now we run the application and we see that in the interactive employee report we can already see the translation of the Go button and the Actions button.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
This way we can translate internal messages in APEX using this \"Text Messaging\" functionality.<\/p>\n\n\n\n
I share with you this link<\/strong><\/a> where you can find the translation scripts for many languages made by the Pretius team.<\/p>\n\n\n\n
I hope this article has been useful!<\/p>\n\n\n\n
See you soon!<\/p>","protected":false},"excerpt":{"rendered":"
Hoy en d\u00eda en el que vivimos en un mundo globalizado es tan importante poder tener nuestras aplicaciones bien traducidas. En esta entrega quiero mostrarte c\u00f3mo podemos utilizar la funci\u00f3n Message de Oracle APEX para traducir cadenas de texto (o mensajes) generados a partir de procedimientos almacenados, funciones, disparadores, procedimientos empaquetados y funciones de PL\/SQL.Continue reading “C\u00f3mo traducir los mensajes internos de APEX”<\/span><\/a><\/p>","protected":false},"author":132749711,"featured_media":16858,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[121913,121887,122124],"tags":[122121,122122,122120,122119,122123],"class_list":["post-16820","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","category-oracle-apex","category-oracle-apex-22-2","tag-globalizacion","tag-lenguaje-primario","tag-mensajes-de-texto","tag-traducciones","tag-traducir-mensajes-internos-de-apex","entry"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2023\/03\/traduccir-mensajes-apex.jpg?fit=2949%2C1735&ssl=1","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paMvMS-4ni","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts\/16820","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/users\/132749711"}],"replies":[{"embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/comments?post=16820"}],"version-history":[{"count":17,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts\/16820\/revisions"}],"predecessor-version":[{"id":16860,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts\/16820\/revisions\/16860"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/media\/16858"}],"wp:attachment":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/media?parent=16820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/categories?post=16820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/tags?post=16820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}