Drupalistas needed for translation portal

 

ptyler's picture

If you or someone you know is a Drupal programmer--and you have an interest in translating xTuple ERP--then we have some news for you. Earlier this summer, xTuple published the source code for its Translation Portal software. This is the same software currently hosting 28 language projects on the xTuple community website. The source code was released as part of the PostBooks project and is available under the same open source license (CPAL) as PostBooks. So how does this affect you? And more importantly, how could this impact the growing international community? The answers are fairly straightforward.

Since xTuple began hosting the Translation Portal over two years ago, we've seen good progress on the translation front. As I mentioned, we're now hosting 28 language projects--and there are nearly 200 users who have signed up to help translate. That's not bad! At the same time, we've gotten feedback from translators who say the user experience on the Translation Portal could be better. We've strived to make user interface improvements--and we keep the translation files up-to-date. But we agree more could be done. That's why we've released the Translation Portal source code. Our hope is that someone (or a group of people) will take up the torch and help move the project along. Make the changes you think should be made. Improve the software--for yourself and for everyone.

Some background

The Translation Portal was originally conceived as a tool to facilitate asynchronous collaboration between users working to translate the same language files. The interface was written as a Drupal module, with translations being stored in a Postgres database in the back end. The software was designed primarily for translating the xTuple ERP user interface. However, it could be adapted to translate other software applications written using Qt. You can find and download the Translation Portal source code by browsing the PostBooks SVN repository. Look for the 'xttranslate' project. Here's a direct link: http://postbooks.svn.sourceforge.net/viewvc/postbooks/xttranslate/.

We'd like to hear from anyone who wants to work on this project--whether you're a Drupal programmer or someone who knows a Drupal programmer. We will make every effort to incorporate your changes back into the Translation Portal we host so that everyone in the community can benefit.

And last, but not least, we have also published under CPAL a tool designed to generate translation (.ts) files from report definitions stored in an xTuple ERP database. The tool, called ReportTSGenerator, was designed by our Canadian partners Groupe Concerti, Inc. who agreed to make the tool publicly available. ReportTSGenerator is currently being used to generate .ts files for the Translation Portal, where users can then have access to and translate the labels found on all xTuple reports.

 
arthurkkk's picture
Offline
Joined: 05/21/2010
Howto setup

Hi Pierce,

Could you please tell me, step-by-step publish the 'xttranslate'?

I follow the Readme.txt, installed the Drupal 6.22 + views-6.x-2.12 + dataTables-1.6.2 + datatables-6.x-1.0

Best Regards!

Robin
2011.8.17

 
cryan's picture
Offline
Joined: 12/10/2008
You can check out the sources

You can check out the sources and you would extract the datatables code into the drupal subfolder of the checkout. To install on a drupal system you would copy the drupal folder into the all/modules directory, ideally as a different name like xttranslate. From there you should just need to enable the module.

 
makedin's picture
Offline
Joined: 02/17/2013
doubt

hello, I am a new user on this page, I want to use openRPT in my application that it's made in c++ with qt, I don't know how to make a pass of parameters with an array...for example:

my parameter is a list that contains 5 ids of employees:

list_employees [ ] ={ 12, 13, 14, 15, 16 }

 

in my query I put a parameter so:

WHERE id_employee  =  < ? value ("list_employees") ? >

but, I don't know how to get all parameters of the list???

how can I implement to the FOR EACH statement???

........<?for each value(" list_employees") ?>

please....help me!!!

 
arthurkkk's picture
Offline
Joined: 05/21/2010
Hi Chris, I got the error

Hi Chris,

I got the error below, when enable the module.

* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL, `id` INT NOT NULL auto_increment, PRIMARY KEY (id) ) /*!40100 DEFAUL' at line 3 query: CREATE TABLE ac_xttranslate_context ( `context` TEXT NOT NULL, `base` NOT NULL, `id` INT NOT NULL auto_increment, PRIMARY KEY (id) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\xampp\htdocs\drupal-6.22\includes\database.inc on line 550.
* user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: CREATE TABLE ac_xttranslate_context_version ( `version` TEXT NOT NULL, `id` INT NOT NULL auto_increment, `contextid` INT NOT NULL auto_increment, PRIMARY KEY (id) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\xampp\htdocs\drupal-6.22\includes\database.inc on line 550.
* user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: CREATE TABLE ac_xttranslate_consource ( `sourceid` INT unsigned NOT NULL, `id` INT NOT NULL auto_increment, `contextid` INT NOT NULL auto_increment, PRIMARY KEY (id) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\xampp\htdocs\drupal-6.22\includes\database.inc on line 550.
* user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: CREATE TABLE ac_xttranslate_consource_version ( `id` INT NOT NULL auto_increment, `consourceid` INT NOT NULL auto_increment, `version` TEXT NOT NULL, PRIMARY KEY (id) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\xampp\htdocs\drupal-6.22\includes\database.inc on line 550.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT 'true', `id` INT NOT NULL auto_increment, PRIMARY KEY (id) ) ' at line 5 query: CREATE TABLE ac_xttranslate_languages ( `language` TEXT NOT NULL, `hide` INT unsigned NOT NULL DEFAULT 0, `code` TEXT NOT NULL, `official` NOT NULL DEFAULT 'true', `id` INT NOT NULL auto_increment, PRIMARY KEY (id) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\xampp\htdocs\drupal-6.22\includes\database.inc on line 550.
* user warning: Invalid default value for 'time' query: CREATE TABLE ac_xttranslate_source ( `source` TEXT NOT NULL, `time` DATETIME NOT NULL DEFAULT 'now()', `id` INT NOT NULL auto_increment, PRIMARY KEY (id) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\xampp\htdocs\drupal-6.22\includes\database.inc on line 550.
* user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: CREATE TABLE ac_xttranslate_source_location ( `location` TEXT NOT NULL, `id` INT NOT NULL auto_increment, `consourceid` INT NOT NULL auto_increment, PRIMARY KEY (id) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\xampp\htdocs\drupal-6.22\includes\database.inc on line 550.
* user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: CREATE TABLE ac_xttranslate_source_version ( `version` TEXT NOT NULL, `id` INT NOT NULL auto_increment, `sourceid` INT NOT NULL auto_increment, PRIMARY KEY (id) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\xampp\htdocs\drupal-6.22\includes\database.inc on line 550.
* user warning: BLOB/TEXT column 'current_version' used in key specification without a key length query: CREATE TABLE ac_xttranslate_product_version ( `product` TEXT NOT NULL, `current_version` TEXT NOT NULL, PRIMARY KEY (current_version) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\xampp\htdocs\drupal-6.22\includes\database.inc on line 550.
* user warning: Invalid default value for 'time' query: CREATE TABLE ac_xttranslate_qmdownload ( `id` INT NOT NULL auto_increment, `username` TEXT NOT NULL, `time` DATETIME NOT NULL DEFAULT 'now()', `version` TEXT NOT NULL, `language` TEXT NOT NULL, `country` TEXT NOT NULL, PRIMARY KEY (id) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\xampp\htdocs\drupal-6.22\includes\database.inc on line 550.

 
arthurkkk's picture
Offline
Joined: 05/21/2010
Is it my XAMPP too old -- ver

Is it my XAMPP too old -- ver 1.7.2
MySQL 5.1.37

 
bcwilson's picture
Offline
Joined: 12/30/2008
Tested on Postgresql

Arthur,

At xTuple we develop using Postgresql. We have not tested this module with mysql. It looks like you are running into db-specific errors.

Suggestions to resolve this: you could try installing your drupal site on a postgres db, or, if you are committed to mysql and a believer in the open source creed, jump into the code and iron it out to work on mysql. We put it out there on SourceForge in the hope that the community would pick it up and help carry it forward.

Thanks.
BC

 
arthurkkk's picture
Offline
Joined: 05/21/2010
BC, Thanks for your answer,

BC,

Thanks for your answer, I will try it with Postgres.

Robin
2011.8.17

 
arthurkkk's picture
Offline
Joined: 05/21/2010
When I enable

When I enable xttranslate(xtpackage translation tool) module on drupal, got the error as below:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "NOT" at character 70 in /var/www/html/drupal-6.22/includes/database.pgsql.inc on line 138.
* user warning: query: CREATE TABLE ac_xttranslate_context ( context text NOT NULL, base NOT NULL, id serial, PRIMARY KEY (id) ) in /var/www/html/drupal-6.22/includes/database.inc on line 550.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "NOT" at character 146 in /var/www/html/drupal-6.22/includes/database.pgsql.inc on line 138.
* user warning: query: CREATE TABLE ac_xttranslate_languages ( language text NOT NULL, hide int CHECK (hide >= 0) NOT NULL default 0, code text NOT NULL, official NOT NULL default 'true', id serial, PRIMARY KEY (id) ) in /var/www/html/drupal-6.22/includes/database.inc on line 550.

 
arthurkkk's picture
Offline
Joined: 05/21/2010
OK, I setup the

OK, I setup the xttranslate.

But when I Add Language(Administer->Site configuration->Translation Portal->Add Language), get the error as below:

Add Language

* Count not get countries from database.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "translate_product_version" does not exist at character 29 in /var/www/html/drupal-6.22/includes/database.pgsql.inc on line 138.
* user warning: query: select current_version from translate_product_version where lower(product) = lower('PostBooks') in /var/www/html/drupal-6.22/sites/all/modules/xttranslate/tags/INITIAL_IMPORT/drupal/xttranslate.admin.inc on line 1014.
* warning: Invalid argument supplied for foreach() in /var/www/html/drupal-6.22/includes/form.inc on line 1435.
* warning: Invalid argument supplied for foreach() in /var/www/html/drupal-6.22/includes/form.inc on line 1435.

 
arthurkkk's picture
Offline
Joined: 05/21/2010
I check the tables in

I check the tables in postgres, there is not "translate_product_version" table.

drupal622=# \dt
关联列表
架构模式 | 名称 | 型别 | 拥有者
----------+----------------------------------+--------+--------
public | ac_xttranslate_consource | 资料表 | drupal
public | ac_xttranslate_consource_version | 资料表 | drupal
public | ac_xttranslate_context_version | 资料表 | drupal
public | ac_xttranslate_product_version | 资料表 | drupal
public | ac_xttranslate_qmdownload | 资料表 | drupal
public | ac_xttranslate_source | 资料表 | drupal
public | ac_xttranslate_source_location | 资料表 | drupal
public | ac_xttranslate_source_version | 资料表 | drupal
public | access | 资料表 | drupal
public | actions | 资料表 | drupal
public | actions_aid | 资料表 | drupal
public | authmap | 资料表 | drupal
public | batch | 资料表 | drupal
public | blocks | 资料表 | drupal
public | blocks_roles | 资料表 | drupal
public | blogapi_files | 资料表 | drupal
public | book | 资料表 | drupal
public | boxes | 资料表 | drupal
public | ca_predicates | 资料表 | drupal
public | cache | 资料表 | drupal
public | cache_block | 资料表 | drupal
public | cache_filter | 资料表 | drupal
public | cache_form | 资料表 | drupal
public | cache_menu | 资料表 | drupal
public | cache_page | 资料表 | drupal
public | cache_uc_price | 资料表 | drupal
public | cache_update | 资料表 | drupal
public | cache_views | 资料表 | drupal
public | cache_views_data | 资料表 | drupal
public | comments | 资料表 | drupal
public | cutemenu_block | 资料表 | drupal
public | cutemenu_menu_item | 资料表 | drupal
public | files | 资料表 | drupal
public | filter_formats | 资料表 | drupal
public | filters | 资料表 | drupal
public | flood | 资料表 | drupal
public | forum | 资料表 | drupal
public | history | 资料表 | drupal
public | languages | 资料表 | drupal
public | locales_source | 资料表 | drupal
public | locales_target | 资料表 | drupal
public | menu_custom | 资料表 | drupal
public | menu_links | 资料表 | drupal
public | menu_router | 资料表 | drupal
public | node | 资料表 | drupal
public | node_access | 资料表 | drupal
public | node_comment_statistics | 资料表 | drupal
public | node_counter | 资料表 | drupal
public | node_revisions | 资料表 | drupal
public | node_type | 资料表 | drupal
public | permission | 资料表 | drupal
public | profile_fields | 资料表 | drupal
public | profile_values | 资料表 | drupal
public | role | 资料表 | drupal
public | search_dataset | 资料表 | drupal
public | search_index | 资料表 | drupal
public | search_node_links | 资料表 | drupal
public | search_total | 资料表 | drupal
public | semaphore | 资料表 | drupal
public | sessions | 资料表 | drupal
public | system | 资料表 | drupal
public | taxonomy_menu | 资料表 | drupal
public | term_data | 资料表 | drupal
public | term_hierarchy | 资料表 | drupal
public | term_node | 资料表 | drupal
public | term_relation | 资料表 | drupal
public | term_synonym | 资料表 | drupal
public | uc_attribute_options | 资料表 | drupal
public | uc_attributes | 资料表 | drupal
public | uc_cart_link_clicks | 资料表 | drupal
public | uc_cart_products | 资料表 | drupal
public | uc_catalog_images | 资料表 | drupal
public | uc_class_attribute_options | 资料表 | drupal
public | uc_class_attributes | 资料表 | drupal
public | uc_countries | 资料表 | drupal
public | uc_file_products | 资料表 | drupal
public | uc_file_users | 资料表 | drupal
public | uc_files | 资料表 | drupal
public | uc_order_admin_comments | 资料表 | drupal
public | uc_order_comments | 资料表 | drupal
public | uc_order_line_items | 资料表 | drupal
public | uc_order_log | 资料表 | drupal
public | uc_order_products | 资料表 | drupal
public | uc_order_statuses | 资料表 | drupal
public | uc_orders | 资料表 | drupal
public | uc_product_adjustments | 资料表 | drupal
public | uc_product_attributes | 资料表 | drupal
public | uc_product_classes | 资料表 | drupal
public | uc_product_features | 资料表 | drupal
public | uc_product_kits | 资料表 | drupal
public | uc_product_options | 资料表 | drupal
public | uc_product_stock | 资料表 | drupal
public | uc_products | 资料表 | drupal
public | uc_store_footers | 资料表 | drupal
public | uc_zones | 资料表 | drupal
public | upload | 资料表 | drupal
public | url_alias | 资料表 | drupal
public | users | 资料表 | drupal
public | users_roles | 资料表 | drupal
public | variable | 资料表 | drupal
public | views_display | 资料表 | drupal
public | views_object_cache | 资料表 | drupal
public | views_view | 资料表 | drupal
public | vocabulary | 资料表 | drupal
public | vocabulary_node_types | 资料表 | drupal
public | watchdog | 资料表 | drupal
(106 行记录)

 
cryan's picture
Offline
Joined: 12/10/2008
On the admin page try setting

On the admin page try setting the db prefix value to "ac_xt" as that is what the table name used as a defualt to create from the .install file.

In regards to the earlier message about the NOT when creating the table that was due to an invalid type being specified by the .install. You could change the 'boolean' type to 'int' but that in and of itself will probably lead to other problems. It may be easier to create the table by hand with the correct type.

 
arthurkkk's picture
Offline
Joined: 05/21/2010
Hi Chris, May I need

Hi Chris,

May I need reinstall Drupal? I am newbie of Drupal, which is the "admin page"?

 
cryan's picture
Offline
Joined: 12/10/2008
If you log in as an admin

If you log in as an admin there should be a black menu bar at the top of the site. With the options "Site Configuration | Translation Portal | Setting" where the Database Prefix option can be set. This option I think may require that you have the drupal module http://drupal.org/project/admin_menu installed for that to work.

 
arthurkkk's picture
Offline
Joined: 05/21/2010
I follow your post, then I

I follow your post, then I get the below error message:
* Could not get languages from database.
* The settings have not been saved because of the errors.
* warning: Invalid argument supplied for foreach() in /var/www/html/drupal-6.22/includes/form.inc on line 1435.
* warning: Invalid argument supplied for foreach() in /var/www/html/drupal-6.22/includes/form.inc on line 1435.

 
arthurkkk's picture
Offline
Joined: 05/21/2010
I tried some action on

I tried some action on Settings screen:
1. "Base Contry" and "Base Language" drop list is empty
2. Fill ac_xt in "Database Prefix"
3. Save configuration

Then add "Please enter a path to QT's release" error message.

I have not installed QT on the CentOS system, the "QT Path" is blank.