Hi everybody
I would like to share my experience/solution for rapidly translation a lots of node (codice, title, doby) operating directly with database tables, in my case the translation is from IT to EN.
The steps are:
1) export from database into excel the node to translate with a query:
SELECT
tab_it.nid,
tab_it.tnid,
(select field_codice_value from `field_revision_field_codice` where entity_id=tab_it.nid) as codice_it ,
tab_it.title,
(select body_value from `field_data_body` where entity_id=tab_it.nid) as body_value_it ,
tab_en.nid,
tab_en.tnid,
(select field_codice_value from `field_revision_field_codice` where entity_id=tab_en.nid) as codice_en ,
tab_en.title,
(select body_value from `field_data_body` where entity_id=tab_en.nid) as body_value_en
FROM
`node` tab_it
INNER JOIN
`node` tab_en
ON
tab_en.tnid=tab_it.tnid
WHERE
tab_it.type='gioiello' and tab_it.language='it'
AND
tab_en.type='gioiello' and tab_en.language='en';
2) translate string (title, body) directly into excel
3) build UPDATE query from your excel for every row you translated
UPDATE `field_data_body` SET body_value='xxx' where entity_id=679;
UPDATE `field_data_body` SET body_value='yyy' where entity_id=..........;
It's all.
BYE
Stefano
