fbenoist68
/
mobileportal
1
0
Fork 0
Code Issues 739 Pull Requests Packages Projects Releases Wiki Activity

[FogBugz #218] I18N #280

New Issue
Open
opened 2023-07-03 23:57:55 +02:00 by fbenoist68 · 11 comments
fbenoist68 commented 2023-07-03 23:57:55 +02:00
Owner

Assigned To: CLOSED
Project: Mobile Portal
Area: Divers
Category: Fonctionnalité
Priority: A fixer impérativement

Assigned To: CLOSED Project: Mobile Portal Area: Divers Category: Fonctionnalité Priority: A fixer impérativement
fbenoist68 commented 2023-07-03 23:57:58 +02:00
Poster
Owner

Event ID: 1001
Date: 2013-11-22T14:41:52Z
Person: Frederik Benoist
Description: Fermé par Frederik Benoist

Event ID: 1001 Date: 2013-11-22T14:41:52Z Person: Frederik Benoist Description: Fermé par Frederik Benoist
fbenoist68 commented 2023-07-03 23:58:00 +02:00
Poster
Owner

Event ID: 1000
Date: 2013-11-22T14:41:52Z
Person: Frederik Benoist
Description: Resolved (Implemented) and assigned to Frederik Benoist by Frederik Benoist

Event ID: 1000 Date: 2013-11-22T14:41:52Z Person: Frederik Benoist Description: Resolved (Implemented) and assigned to Frederik Benoist by Frederik Benoist
fbenoist68 commented 2023-07-03 23:58:02 +02:00
Poster
Owner

Event ID: 961
Date: 2013-11-13T22:34:49Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

gelem :

 

XMLCAST (
                   NVL (
                      XMLQUERY (
                         v_xpath_langage
                         PASSING XMLPARSE (CONTENT mqe.libelle)
                         RETURNING CONTENT),
                      XMLQUERY (
                         '/trad/fr'
                         PASSING XMLPARSE (CONTENT mqe.libelle)
                         RETURNING CONTENT)) AS VARCHAR2 (256))
                   AS libelle,
Event ID: 961 Date: 2013-11-13T22:34:49Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p> gelem :</p> <p> &nbsp;</p> <div> XMLCAST (</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NVL (</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; XMLQUERY (</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;v_xpath_langage</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PASSING XMLPARSE (CONTENT mqe.libelle)</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RETURNING CONTENT),</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; XMLQUERY (</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&#39;/trad/fr&#39;</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PASSING XMLPARSE (CONTENT mqe.libelle)</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RETURNING CONTENT)) AS VARCHAR2 (256))</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS libelle,</div>
fbenoist68 commented 2023-07-03 23:58:04 +02:00
Poster
Owner

Event ID: 960
Date: 2013-11-13T22:34:17Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

 

 XMLCAST (
                                        NVL (
                                           XMLQUERY (
                                              v_xpath_langage
                                              PASSING XMLPARSE (CONTENT mqe.libelle)
                                              RETURNING CONTENT),
                                           XMLQUERY (
                                              '/trad/fr'
                                              PASSING XMLPARSE (CONTENT mqe.libelle)
                                              RETURNING CONTENT)) AS VARCHAR2 (256))
                                        AS libelle
Event ID: 960 Date: 2013-11-13T22:34:17Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p> &nbsp;</p> <div> &nbsp;XMLCAST (</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NVL (</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XMLQUERY (</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; v_xpath_langage</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PASSING XMLPARSE (CONTENT mqe.libelle)</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RETURNING CONTENT),</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XMLQUERY (</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &#39;/trad/fr&#39;</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PASSING XMLPARSE (CONTENT mqe.libelle)</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RETURNING CONTENT)) AS VARCHAR2 (256))</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS libelle</div>
fbenoist68 commented 2023-07-03 23:58:06 +02:00
Poster
Owner

Event ID: 959
Date: 2013-11-13T21:19:12Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

 

SELECT XMLCAST (
          NVL (
             XMLQUERY ('/trad/it' PASSING XMLPARSE (CONTENT mce.libelle) RETURNING CONTENT),
             XMLQUERY ('/trad/fr' PASSING XMLPARSE (CONTENT mce.libelle) RETURNING CONTENT))
          AS VARCHAR2 (256)) AS traduction
  FROM mr_controle_element mce
 WHERE mce.id_controle_element = 29;
Event ID: 959 Date: 2013-11-13T21:19:12Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p> &nbsp;</p> <div> SELECT XMLCAST (</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NVL (</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XMLQUERY (&#39;/trad/it&#39; PASSING XMLPARSE (CONTENT mce.libelle) RETURNING CONTENT),</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XMLQUERY (&#39;/trad/fr&#39; PASSING XMLPARSE (CONTENT mce.libelle) RETURNING CONTENT))</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS VARCHAR2 (256)) AS traduction</div> <div> &nbsp; FROM mr_controle_element mce</div> <div> &nbsp;WHERE mce.id_controle_element = 29;</div>
fbenoist68 commented 2023-07-03 23:58:09 +02:00
Poster
Owner

Event ID: 958
Date: 2013-11-13T21:02:24Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

 

 
SELECT XMLCAST (
          XMLQUERY ('/trad/fr'
                    PASSING XMLPARSE (CONTENT mce.libelle) RETURNING CONTENT
                   ) AS VARCHAR2 (100))
          AS traduction
  FROM mr_controle_element mce
 WHERE mce.id_controle_element = 29;
Event ID: 958 Date: 2013-11-13T21:02:24Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p> &nbsp;</p> <div> &nbsp;</div> <div> SELECT XMLCAST (</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; XMLQUERY (&#39;/trad/fr&#39;</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PASSING XMLPARSE (CONTENT mce.libelle) RETURNING CONTENT</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;) AS VARCHAR2 (100))</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS traduction</div> <div> &nbsp; FROM mr_controle_element mce</div> <div> &nbsp;WHERE mce.id_controle_element = 29;</div>
fbenoist68 commented 2023-07-03 23:58:10 +02:00
Poster
Owner

Event ID: 957
Date: 2013-11-12T20:18:48Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

 

WITH question
     AS (SELECT '<trad><fr>section</fr><it>Sezionne</it></trad>' AS fieldvalue
           FROM DUAL)
SELECT NVL (
          xmltype (question.fieldvalue).EXTRACT ('trad/it/text()'),
          xmltype (question.fieldvalue).EXTRACT ('trad/fr/text()')).getStringval ()
          AS trad
  FROM question;
Event ID: 957 Date: 2013-11-12T20:18:48Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p> &nbsp;</p> <div> WITH question</div> <div> &nbsp; &nbsp; &nbsp;AS (SELECT &#39;&lt;trad&gt;&lt;fr&gt;section&lt;/fr&gt;&lt;it&gt;Sezionne&lt;/it&gt;&lt;/trad&gt;&#39; AS fieldvalue</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FROM DUAL)</div> <div> SELECT NVL (</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; xmltype (question.fieldvalue).EXTRACT (&#39;trad/it/text()&#39;),</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; xmltype (question.fieldvalue).EXTRACT (&#39;trad/fr/text()&#39;)).getStringval ()</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS trad</div> <div> &nbsp; FROM question;</div>
fbenoist68 commented 2023-07-03 23:58:12 +02:00
Poster
Owner

Event ID: 956
Date: 2013-11-12T06:13:55Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Mettre dans les champs à traduire les traductions en XML

 

<?xml version="1.0" ?> 
<trad fr="section">
  <it>Sezionne</it>
</trad>

   

Event ID: 956 Date: 2013-11-12T06:13:55Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p> Mettre dans les champs &agrave; traduire les traductions en XML</p> <p> &nbsp;</p> <div> &lt;?xml version=&quot;1.0&quot; ?&gt;&nbsp;</div> <div> &lt;trad fr=&quot;section&quot;&gt;</div> <div> &nbsp; &lt;it&gt;Sezionne&lt;/it&gt;</div> <div> &lt;/trad&gt;</div> <p> &nbsp; &nbsp;</p>
fbenoist68 commented 2023-07-03 23:58:15 +02:00
Poster
Owner

Event ID: 955
Date: 2013-11-12T05:56:44Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

 

<?xml version="1.0" encoding="windows-1252" ?>
<xliff version="1.1" xmlns="urn:oasis:names:tc:xliff:document:1.1">
  <file source-language="en" original="myResources" datatype="xml">
    <body>
      <trans-unit id="NAME">
        <source>Name</source>
        <target/>
        <note>Name of employee</note>
      </trans-unit>
      <trans-unit id="HOME_ADDRESS">
        <source>Home Address</source>
        <target/>
        <note>Adress of employee</note>
      </trans-unit>
      <trans-unit id="OFFICE_ADDRESS">
        <source>Office Address</source>
        <target/>
        <note>Office building </note>
      </trans-unit>
    </body>
  </file>
</xliff>
Event ID: 955 Date: 2013-11-12T05:56:44Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p> &nbsp;</p> <pre class="oac_no_warn"> &lt;?xml version=&quot;1.0&quot; encoding=&quot;windows-1252&quot; ?&gt; &lt;xliff version=&quot;1.1&quot; xmlns=&quot;urn:oasis:names:tc:xliff:document:1.1&quot;&gt; &lt;file source-language=&quot;en&quot; original=&quot;myResources&quot; datatype=&quot;xml&quot;&gt; &lt;body&gt; &lt;trans-unit id=&quot;NAME&quot;&gt; &lt;source&gt;Name&lt;/source&gt; &lt;target/&gt; &lt;note&gt;Name of employee&lt;/note&gt; &lt;/trans-unit&gt; &lt;trans-unit id=&quot;HOME_ADDRESS&quot;&gt; &lt;source&gt;Home Address&lt;/source&gt; &lt;target/&gt; &lt;note&gt;Adress of employee&lt;/note&gt; &lt;/trans-unit&gt; &lt;trans-unit id=&quot;OFFICE_ADDRESS&quot;&gt; &lt;source&gt;Office Address&lt;/source&gt; &lt;target/&gt; &lt;note&gt;Office building &lt;/note&gt; &lt;/trans-unit&gt; &lt;/body&gt; &lt;/file&gt; &lt;/xliff&gt;</pre>
fbenoist68 commented 2023-07-03 23:58:16 +02:00
Poster
Owner

Event ID: 954
Date: 2013-11-12T05:56:27Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist

Event ID: 954 Date: 2013-11-12T05:56:27Z Person: Frederik Benoist Description: Attribué à Frederik Benoist par Frederik Benoist
fbenoist68 commented 2023-07-03 23:58:18 +02:00
Poster
Owner

Event ID: 953
Date: 2013-11-12T05:56:27Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist

Event ID: 953 Date: 2013-11-12T05:56:27Z Person: Frederik Benoist Description: Ouvert par Frederik Benoist
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
main
Labels
Clear labels
No items
No Label
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: fbenoist68/mobileportal#280
There is no content yet.
Delete Branch "%!s(<nil>)"

Deleting a branch is permanent. Although the deleted branch may exist for a short time before cleaning up, in most cases it CANNOT be undone. Continue?