2007年12月1日 星期六

Import language transalation into Compiere how-to

For Compiere evaluation users, it's nice to have their locale interface to operate with. Please follow the steps to complete the language translation importation:
  1. Login Compiere with user 'System', there is only one Role 'System Administrator' and one Client 'System' to choose, press OK to continue.
  2. From top up menu tree, go to System Admin/General Rules/System Rules/Language


  3. Change view from 'List View' to 'Form View' by button Grid Toggle from menubar.
  4. Click button 'Language Maintenance' to populate those translatable tags into database. And press 'OK' to start process from current message dialog.
  5. On the maintain language translation in system dialog windows, please select 'Add missing translation' item and press 'OK' to continue.
  6. After a while, when Compiere comes back to Language form again, the missing translation tags were arranged ok await for translation. Close current windows and choose 'Translation import/export' under /Menu/System Admin/General Rules/System Rules.
  7. Please select 'System' item from Client combobox and the language translations you are going to import. Left the Table combobox blank, since you can import more than one table in the same time. Press button Import to continue.
  8. The last step is to indicate which folder contains the translation files. Only folder name is neccessary, since Compiere would detect hoe many files in this folder and import whole of them into database automitically. The screen below is just for example.
  9. Press button Open to start import job. This process would take minutes to complete. There is no progress bar this time, just waiting for screen to come back to what you have looked at step 6. Close the window and logout Compiere.
  10. Please login again with user 'SuperUser', don't forget to select the language you just added in, then select the role other than System Administrator(such as GardenWorld Admin, or gardenWorld User,,), you would see the big changes.

How does sqlplus know which SID to connect for Oracle 10g Express ?

After Oralce 10g express was installed and web console (http://oracle-xe-host-name:8080/apex) worked fine, how about now you apply sqlplus to connect the absolutely only one instance 'XE' in the same machine ? Since there is no Oracle 10g express client installed, sqlplus has no idea where TNS administration is located, it's therefore no way to connect instance 'XE'. Please try the followings to solve:
  • For Windows: Set system variable TNS_ADMIN equal to %ORACLE_XE_SERVER_HOME%\NETWORK\ADMIN
  • For Linux: Copy tnsnames.ora from $ORACLE_XE_SERVER_HOME/networ/admin to /etc