Software development, photography, jokes, ....

Sites by me

 
tas-logoTransportation Administration System
snoezelkussen-logo-kleinstSnoezelen Pillows for Dementia
ikzoekeenbegeleider-logoBegeleiders voor gehandicapten
Laat uw hond het jaarlijkse vuurwerk overwinnen
Betuweroute en Kunst
logo 50x50Hey Vos! Je eigen naam@vos.net emailadres?
Kunst in huis? Nicole Karrèr maakt echt bijzonder mooie dingen
nettylogo2Kunst in huis? Netty Franssen maakt ook bijzonder mooie dingen
Professionele opvang bij Gastouderbureau
Kind-Zijn
Salarisadministratie en belastingadvies bij
De Zaak Loont
Zutphense Bomenstichting

Hosting Favorites

 
ANU Internet Services
XelMedia .internet services
register.com
GoDaddy.com

Blogroll

 
Bomenstichting
MacFreak
Google Translate
PHP
MySQL
jQuery
jQuery UI
codecademy
YourHead Stacks API
Favicon Generator. For real.
Check HTTPS problems



Marc's Place

 

E$LNGU - Update a Language Message file

Start Command

call e$lngu

Call Parameters

*N/A

Return Parameters

*N/A

What it does

With this program you can update a Language Message File quick and easy by filling the work file E$LNGUPD with data from, for example, MS-Excel. E$LNGUPD has the following fields:

E$MSGK   Message ID (a7)
E$TEXT Message Text (a132)

When you start E$LNGU, you have to choose the language you are going to update. Choosing a language does not change your library list as E$LNGS does. Next, program E$LNGU1 starts and performs a CHGMSGD for each E$MSGK in the work file.

A smart way to translate and update Language Message Files is the follwoing:

  1. Load the fields E$TEXT, E$TLEN and E$MSGK of E$LNGREF using ODBC into MS-Excel.
  2. Create in MS-Excel a fourth column for the other language you want.
  3. Put the translations in the fourth column.
  4. When you are done, select the columns 3 and 4 and press CTRL-C to copy them to the clipboard.
  5. Start a plain ASCII editor and paste the TAB-delimited text.
  6. Remove the first line (column titles) and replace all TAB-characters with nothing using 'replace all'.
  7. Copy this textfile using FTP or so to the AS/400 into E$LNGUPD.
  8. Start E$LNGU.

Special Options

1 - Select
Use this option to select a language. Only the first record with a 1 is taken when multiple are selected.

Examples

Here is an example of the steps described above.

Create the MS-Excel sheet and copy the last two columns:


Start a plain ASCII editor and paste the TAB-delimited text:


Then, with FTP, upload it directly into E$LNGUPD:


Here is the DSPPFM result of E$LNGUPD:


And the last step is to start E$LNGU and choose the language of which the corresponding message file should be updated:

 
Go to download page
© 1997- Marc Vos (and others) Contact Me