TranslateTable

Question

Question

Michael Gosselin · Dec 9, 2020

#InterSystems IRIS for Health

Probably a simple question, but where do I find the list of Translate Tables? The documentation wasn't clear.

Thank you,

Product version: IRIS 2020.2

$ZV: IRIS for UNIX (Ubuntu Server LTS for x86-64 Containers) 2020.2 (Build 211U) Fri Jun 26 2020 13:36:43 EDT

Discussion (6)1

Log in or sign up to continue

Julius Kavay · Dec 9, 2020

SystemAdministration-->Configuration-->NationalLanguageSettings-->Defaults/Defs/Imp/Exp

First you have to start with a predefined/default table, copy under a new name, select this new table and click on the properties.

1 0

Eduard Lebedyuk · Dec 10, 2020

Zn "%SYS"
Set Ref = ##class(Config.NLS.Locales).OpenCurrent(.Sc)
Write "Locale name: ",Ref.Name, !
Do Ref.GetTables(.Tables)
Set Key = ""
For { Set Key = $O(Tables("XLT", Key)) Quit:Key=""  Write Key,!}

1 0

score 0 · Answer 1 · 2020-12-09T13:39:08-05:00

Vitaly Furman · Dec 9, 2020

Hi Michael,

Are you talking about Translation Maps in HealthShare Terminology Management?

0 0

score 0 · Answer 2 · 2020-12-09T14:10:00-05:00

Michael Gosselin · Dec 9, 2020

Thanks, Vitaly. No, I meant the tables such as cp1252 or UTF-8.

Thanks again,

0 0

score 0 · Answer 3 · 2020-12-09T15:18:24-05:00

Thank you. Unfortunately, I don't have that access in Iris, but I do have access to my personal copy of Ensemble 2017.

This is what I have:

<XLTTables>

      <XLTTablesItem XLTTablesKey="CP1250">CP1250,Unicode,Unicode,CP1250</XLTTablesItem>

      <XLTTablesItem XLTTablesKey="CP1251">CP1251,Unicode,Unicode,CP1251</XLTTablesItem>

      <XLTTablesItem XLTTablesKey="CP1252">CP1252,Unicode,Unicode,CP1252</XLTTablesItem>

      <XLTTablesItem XLTTablesKey="CP1253">CP1253,Unicode,Unicode,CP1253</XLTTablesItem>

      <XLTTablesItem XLTTablesKey="CP1255">CP1255,Unicode,Unicode,CP1255</XLTTablesItem>

      <XLTTablesItem XLTTablesKey="CP437">CP437,Unicode,Unicode,CP437</XLTTablesItem>

      <XLTTablesItem XLTTablesKey="CP850">CP850,Unicode,Unicode,CP850</XLTTablesItem>

      <XLTTablesItem XLTTablesKey="CP852">CP852,Unicode,Unicode,CP852</XLTTablesItem>

      <XLTTablesItem XLTTablesKey="CP866">CP866,Unicode,Unicode,CP866</XLTTablesItem>

      <XLTTablesItem XLTTablesKey="CP874">CP874,Unicode,Unicode,CP874</XLTTablesItem>

      <XLTTablesItem XLTTablesKey="EBCDIC">EBCDIC,Unicode,Unicode,EBCDIC</XLTTablesItem>

      <XLTTablesItem XLTTablesKey="Latin2">Latin2,Unicode,Unicode,Latin2</XLTTablesItem>

      <XLTTablesItem XLTTablesKey="Latin9">Latin9,Unicode,Unicode,Latin9</XLTTablesItem>

      <XLTTablesItem XLTTablesKey="LatinC">LatinC,Unicode,Unicode,LatinC</XLTTablesItem>

      <XLTTablesItem XLTTablesKey="LatinG">LatinG,Unicode,Unicode,LatinG</XLTTablesItem>

      <XLTTablesItem XLTTablesKey="LatinH">LatinH,Unicode,Unicode,LatinH</XLTTablesItem>

      <XLTTablesItem XLTTablesKey="LatinT">LatinT,Unicode,Unicode,LatinT</XLTTablesItem>

    </XLTTables>

If I'm wrong, please LMK.

score 0 · Answer 4 · 2020-12-10T09:01:55-05:00

Michael Gosselin · Dec 10, 2020

Thank you; this also works.

0 0