1
Programming / Re: [Classic Rexx] Translation database
« on: November 03, 2025, 08:53:43 pm »
Related topic: [Classic Rexx] How can one pipe data to application?
I've been bussy to rewrite the script.
It take ISO files with OS/2-eCS-ArcaOS, source language and target language, extract and interpret various file formats/resoruces and add translations to a database (SQLite), but also use online resources (database and google) when possible to translate text.
This version is more capable, but I still need your help.
I need your help to find more translation sources and add how to parse and add them.
This script is currently available in English and Swedish... and with your help soon also in your language
It is built as a menu system that use .msg files to output text, thus need your time to translate it. (See files in the folder TRN_MSG_TXT)
It is intended to be able to translate itself, but it is unlikely right now since the word-to-word translations available, focus on other phrases and words.
The current sources for translations are:
https://download.wikdict.com/dictionaries/sqlite/
http://translate.googleapis.com/translate_a/
saldo.xml or swesaurus.xml specifically for Swedish
and the OS/2 centric ftp://ftp.zx.net.nz/pub/archive/service.boulder.ibm.com/ps/products/os2/fixes/
Someone may want to create a function that can parse either the 19Gb large jsonl within https://kaikki.org/dictionary/raw-wiktextract-data.jsonl.gz or the smaller kaikki.org-dictionary-<Language>.jsonl and help me here! and/or perhaps mare the related python scripts available... whatever it can be used for.
What is lacking that also need your assistance to solve:
Caseless comparison of phrases/words within the sqlite database when used with national characters.
Code to use additional online and offline translation sources.
SQL views within the database that can be useful to output translations into various useful file formats.
Graphical software to add and use translations!
Good to have tool: DB Browser for SQLite by TeLLie
Interactive guide
=============
1. Information
2. Preparations
3. Usage
4. Change default language/country
5. Start
0. Exit
Type a number from the list above: 5
Start
====
1. Combine translation of OS/2, eComStation or ArcaOS
2. Combine translation between en and fr
3. Create database for translation between en and fr
4. Import text to translate between en and fr
5. Change source language from en to translate from
6. Change target language from fr to translate to
0. Exit
Type a number from the list above (Enter to return): 1
Source ISO-file of OS/2, eComStation or ArcaOS in en: C:\var\ArcaOS-5.0.7.iso
The Process Identification Number is 5474.
Path to ISO-file of OS/2, eComStation or ArcaOS in fr (or Empty): E:\Operatingsystem\OS2 Warp 4\Warp_4_fr.ISO
The Process Identification Number is 5481.
I've been bussy to rewrite the script.
It take ISO files with OS/2-eCS-ArcaOS, source language and target language, extract and interpret various file formats/resoruces and add translations to a database (SQLite), but also use online resources (database and google) when possible to translate text.
This version is more capable, but I still need your help.
I need your help to find more translation sources and add how to parse and add them.
This script is currently available in English and Swedish... and with your help soon also in your language

It is built as a menu system that use .msg files to output text, thus need your time to translate it. (See files in the folder TRN_MSG_TXT)
It is intended to be able to translate itself, but it is unlikely right now since the word-to-word translations available, focus on other phrases and words.
The current sources for translations are:
https://download.wikdict.com/dictionaries/sqlite/
http://translate.googleapis.com/translate_a/
saldo.xml or swesaurus.xml specifically for Swedish
and the OS/2 centric ftp://ftp.zx.net.nz/pub/archive/service.boulder.ibm.com/ps/products/os2/fixes/
Someone may want to create a function that can parse either the 19Gb large jsonl within https://kaikki.org/dictionary/raw-wiktextract-data.jsonl.gz or the smaller kaikki.org-dictionary-<Language>.jsonl and help me here! and/or perhaps mare the related python scripts available... whatever it can be used for.
What is lacking that also need your assistance to solve:
Caseless comparison of phrases/words within the sqlite database when used with national characters.
Code to use additional online and offline translation sources.
SQL views within the database that can be useful to output translations into various useful file formats.
Graphical software to add and use translations!
Good to have tool: DB Browser for SQLite by TeLLie
Interactive guide
=============
1. Information
2. Preparations
3. Usage
4. Change default language/country
5. Start
0. Exit
Type a number from the list above: 5
Start
====
1. Combine translation of OS/2, eComStation or ArcaOS
2. Combine translation between en and fr
3. Create database for translation between en and fr
4. Import text to translate between en and fr
5. Change source language from en to translate from
6. Change target language from fr to translate to
0. Exit
Type a number from the list above (Enter to return): 1
Source ISO-file of OS/2, eComStation or ArcaOS in en: C:\var\ArcaOS-5.0.7.iso
The Process Identification Number is 5474.
Path to ISO-file of OS/2, eComStation or ArcaOS in fr (or Empty): E:\Operatingsystem\OS2 Warp 4\Warp_4_fr.ISO
The Process Identification Number is 5481.