CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Any method to generate translated SQL for installation?
Pages: [1]

Author Topic: Any method to generate translated SQL for installation?  (Read 1930 times)

jimyhuang

  • I post occasionally
  • **
  • Posts: 35
  • Karma: 3
Any method to generate translated SQL for installation?
July 15, 2010, 02:16:28 am
I know there are many string will write it into database when install a new CiviCRM. I would like to regenerate the string for improve some translation, but I can't find the document of script to doing that.

Anyone have idea to give me some guide for how to regenerate the SQL installation file for installation?
(installation file like sql/civicrm_data.zh_TW.mysql )

xcf33

  • I post frequently
  • ***
  • Posts: 181
  • Karma: 7
  • CiviCRM version: 3.3.2
  • CMS version: Drupal 6.19/6.20
  • MySQL version: 5.x
  • PHP version: 5.2.6
Re: Any method to generate translated SQL for installation?
July 15, 2010, 06:57:07 am
Hi Jimmy,

I'm not exactly sure but look into

modules/civicrm/sql/civicrm.sql

If you have a list of string that needs to be translated from the installation, you can always run a script to translate the sql dump file and then run the installer.


Chang

jimyhuang

  • I post occasionally
  • **
  • Posts: 35
  • Karma: 3
Re: Any method to generate translated SQL for installation?
July 17, 2010, 06:48:47 am
I found some {ts} english string {/ts} markup in civicrm/sql/civicrm_data.mysql.

Seems we can use build-in function or script for translate the whole SQL.
I'm still try to find out how to implement this.

jimyhuang

  • I post occasionally
  • **
  • Posts: 35
  • Karma: 3
Re: Any method to generate translated SQL for installation?
July 20, 2010, 05:04:25 am
Still can't find a easy way to replace the string of civicrm_data.mysql. It's because some string doesn't have {ts} string {/ts}  encloser. Especially the status string.
Any others have idea?

Michał Mach

  • Moderator
  • Ask me questions
  • *****
  • Posts: 748
  • Karma: 59
    • CiviCRM site
  • CiviCRM version: latest
  • CMS version: Drupal and Joomla latest
  • MySQL version: numerous
  • PHP version: 5.3 and 5.2
Re: Any method to generate translated SQL for installation?
July 20, 2010, 09:24:41 am
Hey Jimmy,

Language specific data files are generated when you run bin/setup.sh. Language specific SQL files are located in sql/ directory - it would be civicrm_data.zh_TW.mysql in your case. The template file that's used for generating it is located here: xml/templates/civicrm_data.tpl. All of the translatable strings should be tagged there, if some are not, it's a bug. Please note, that in case of statuses, the name is repeated twice - once as English status name that's used as an identifier and cannot be translated, and once as label, which can.

Thx,
m
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My absolute favourite: Wordpress Integration!.

Donate Now!

jimyhuang

  • I post occasionally
  • **
  • Posts: 35
  • Karma: 3
Re: Any method to generate translated SQL for installation?
August 02, 2010, 10:42:30 am
Michal,
Thanks for reply. I'm trying now!!

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Any method to generate translated SQL for installation?

This forum was archived on 2017-11-26.