{"id":401,"date":"2007-02-11T01:19:15","date_gmt":"2007-02-11T07:19:15","guid":{"rendered":"http:\/\/www.mooreds.com\/wordpress\/archives\/000401"},"modified":"2007-02-16T22:46:04","modified_gmt":"2007-02-17T04:46:04","slug":"using-excel-to-ease-java-i18n-processes","status":"publish","type":"post","link":"https:\/\/www.mooreds.com\/wordpress\/archives\/401","title":{"rendered":"Using Excel to ease Java i18n processes"},"content":{"rendered":"<p>Ah, the perils of reading Bloglines before going to sleep.  (I&#8217;ll just catch up on one more blog&#8230;)<br \/>\nI gave a BJUG talk 18 months ago <a href=\"http:\/\/www.mooreds.com\/wordpress\/archives\/000262\">about large websites and internationalization (i18n)<\/a>.  (Links and powerpoint <a href=\"http:\/\/www.mooreds.com\/i18n\/\">here<\/a>.)  The talk was based on my experiences of a smooth operation, created and executed by <a href=\"http:\/\/www.ziaconsulting.com\">Zia Consulting<\/a>.<\/p>\n<p>A crucial part of this i18n process was creating and moving around Excel files containing keys and translations.  In addition, there was an Access database and a VB script that converted the keys and translations to properties files.  The reason to do this is that the typical Java developer wants to use <a href=\"http:\/\/java.sun.com\/j2se\/1.4.2\/docs\/api\/java\/util\/ResourceBundle.html\">ResourceBundles<\/a> for i18n, which typically involves properties files.  And the typical translator is much more comfortable with Excel.  So, Zia built a process which bridged that gap.<\/p>\n<p>It looks like <a href=\"https:\/\/excelbundle.dev.java.net\/\">someone else solved the same problem with translators and Excel files<\/a>, and open sourced the solution.<\/p>\n<p>Via <a href=\"http:\/\/jroller.com\/page\/rickard?entry=new_resourcebundle_translation_tool_released\">Rickard<\/a>.<\/p>\n<p><em>Updated 2\/16, fixed typo and a small formatting change.<\/em><\/p>\n<p>[tags]i18n,excelbundle[\/tags]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ah, the perils of reading Bloglines before going to sleep. (I&#8217;ll just catch up on one more blog&#8230;) I gave a BJUG talk 18 months ago about large websites and [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,5],"tags":[],"class_list":["post-401","post","type-post","status-publish","format-standard","hentry","category-bjug","category-java"],"_links":{"self":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/posts\/401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/comments?post=401"}],"version-history":[{"count":0,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/posts\/401\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/media?parent=401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/categories?post=401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/tags?post=401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}