Extended Translation

See http://wiki.idempiere.org/wiki/Extended_Translations for the official page.

This page here is a scratchpad for personal thoughts of me.

new Tables

Table TranslationServer

(there can be more than one of these)

• Servername
• port
• username
• password
• mailaddress

Table TranslationPackage

• (parent key to translationserver)

• synchronized with cts (centralized translation server):
  • search key
  • name
  • maintainer
  • website

• local fields:
  • synchronize with server (never, on demand, automatic)
  • last synchronize with server (read-only date)
  • synchronize with server now (Button)
  • transfer to database (never, on demand, automatic)
  • last transfer to database (read-only date)
  • transfer to database now (Button)
  • isActive

Table TranslationBasePackage

• (parent key (by uuid) to TranslationPackage)
• name (reference by search key)
• SeqNo
• isActive

TranslationElement

• (parent key (by uuid) to TranslationPackage)
• translated table (reference of *_Trl as uuid, may be a not-guilty value)
• createTable (if not exists - Y/N, e.g. for SystemElement)
• column to translate (reference by uuid, may be a not-guilty value)
• english value (read-only, calculated value)
• old value (read-only, calculated value)

• new translation value
• new boolean value (if column is equal "centrally maintained")
• new uuid value (if column is equal "system element")
• isActive

TranslationClientElement

• translated table (reference of *_Trl as uuid, may be a not-guilty value)
• column to translate (reference by uuid, may be a not-guilty value)
• english value (read-only, calculated value from search key)

new Processes

• read package list from server
• synchronize with server
• transfer to database
• transfer from database
• call already existing process "synchronize terminology"
• transfer single value to database
• transfer single column to database

Links

• http://blog.endpoint.com/2010/07/postgresql-dynamic-sql-function.html