1 On the database server, stop all database processes.
./stop.DBSetName
2 As a backup, rename the gui database.
mv gui.db guiold.db
3 From the MFG/PRO 9.0 installation directory, start MFG/UTIL.
./mfgutil
4 Select the Database menu and choose Load Data from Directory to create a new gui database with the translated data.
5 Complete the fields according to the following table.
6 Choose OK to begin the database creation.
7 When prompted to create the database, choose Yes. 8 Exit MFG/UTIL when finished.
Field Enter
From this Directory: /InstallDir/gui From this empty Database: guiempty To this Database Name: gui
Creating Language Databases
In order to compile any part of MFG/PRO for a non-English language, you must connect to a set of databases with translated schema labels. Follow these instructions to create databases with translated schema labels for the language you are installing.
Note You should use the language databases only for performing compilation. They are not needed for running MFG/PRO.
Copy Standard Databases
1 Change to the MFG/PRO installation directory, top level.
cd installDir
2 Copy the following database files to new names under your language sub-directory.
cp mfgempty.db ./LanguageDir/mfgLanguageCode.db cp guiempty.db ./LanguageDir/guiLanguageCode.db cp cfempty.db ./LanguageDir/cfLanguageCode.db cp hlpempty.db ./LanguageDir/hlpLanguageCode.db
3 Copy the following before image files to new names under your language sub-directory.
cp mfgempty.bi ./LanguageDir/mfgLanguageCode.bi cp guiempty.bi ./LanguageDir/guiLanguageCode.bi cp cfempty.bi ./LanguageDir/cfLanguageCode.bi cp hlpempty.bi ./LanguageDir/hlpLanguageCode.bi
Load Translated Labels
1 From the installation directory (InstallDir), start MFG/UTIL.
./mfgutil
2 In MFG/UTIL, select the Database menu and choose Load Translated Labels.
3 When the database connect window appears, complete the fields as follows.
4 Choose OK.
5 After a connection is made, complete the following field with the path and name of the xdc_mstr table.
Update This Database File: InstallDir /LanguageDir/xdc_mstr.d
Note Choose the button < Browse .db File > to search for this file. 6 Choose OK, and the load process begins.
7 Run Load Translated Labels for the remaining databases, using the preceding steps as a guide. Change the database name as appropriate.
• guiLanguageCode.db
• cfLanguageCode.db
• hlpLanguageCode.db
8 In the Additional Parameters field, use the appropriate -ld
parameter for each database. • Gui database — qadgui
• Help database — qadhelp
• Configurator database — qadcf
Field Description
Physical Database Name: Type mfgLanguageCode. Local Host Connection: Select this option.
Single-User Connection: Select this option.
Database Path: Type the explicit path to mfgLanguageCode. Additional Parameters: Type the parameters: -ld qaddb
Adding a Compile Database Set
Once you create databases for compiling in a given language, you should set up a compile database set in MFG/UTIL so you can compile with MFG/UTIL’s compile option.
1 From the installation directory (InstallDir), start MFG/UTIL.
./mfgutil
2 Select the Configure menu and choose Any Database Set. 3 In the Database Set Configuration window, choose New Set. 4 In the Database Sets window, type a descriptive name in the Set
Name field. For example, if you installed French, type FrCompile. Accept the default in all other fields and choose OK.
5 Add the following databases to this database set by choosing New Client and completing the Database Parameters window for each database.
6 Add server parameters for each database by selecting the database and choosing Edit Server. Use the following table as a guide.
7 Once the database set is complete, choose OK in the Database Set Configuration window to save your changes.
Physical Logical
Connect Parms
Connect Type Path
mfgLanguageCode qaddb -RO Local Explicit path to the language database. guiLanguageCode qadgui -RO Local Explicit path to the
language database. hlpLanguageCode qadhelp -RO Local Explicit path to the
language database. cfLanguageCode qadcf -RO Local Explicit path to the
language database.
Physical Path
mfgLanguageCode Explicit path to the language database. guiLanguageCode Explicit path to the language database. hlpLanguageCode Explicit path to the language database. cfLanguageCode Explicit path to the language database.
8 When you compile MFG/PRO for the language, specify this language database set.
Setting Up Users and Testing the
Language Installation
In MFG/PRO, you must assign languages to each user. Open User Maintenance (36.3.18) and modify the Language field to the appropriate two-letter language code.
For Windows clients using a non-English language, you must also deactivate the Microsoft WinHelp viewer help display. This way, the help displays from the help database, which contains the translated help. To deactivate WinHelp, open User Interface Profile, 36.20.4, select each non-English user, and deselect the WinHelp check-box. (It should be blank.)
Language Test
To test your language installation, start an MFG/PRO session and log on as a user who is set up with the language code you want to test.
Open menu item 1.4.1 (in English, Item Master Maintenance), and verify that the fields are translated.
Cleaning Up the System
Once you have completed your language test and verified that your MFG/PRO fields have been translated, delete the temporary language directories you created in “Loading an Additional Language on the Database Server” on page 74 and “Loading an Additional Language for Windows Clients” on page 76.
These directories were created to temporarily hold your additional language information until it was copied into your main installation directory. The temporary language directories are now duplicate directories and are no longer needed. Delete them to provide additional disk space.
Convert an Existing
Database
This chapter provides instructions for converting an MFG/PROVersion 7.3, 7.4, 8.5, or 8.6 database to Version 9.0. A conversion refers to the transition from one numbered release to the next.
Conversion Overview 86
1: Preparing Source Version Data 90
2: Preparing Reports for Data Verification 93 3: Creating Conversion Dump Files 94 4: Preserving Custom Default Data 95
5: Starting MFG/CONV and Answering Prompts 97