Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 359198 - I find many translated values are equal to original value.
Summary: I find many translated values are equal to original value.
Status: CLOSED WORKSFORME
Alias: None
Product: Babel
Classification: Technology
Component: translations (show other bugs)
Version: unspecified   Edit
Hardware: All All
: P3 trivial (vote)
Target Milestone: ---   Edit
Assignee: Babel server inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-28 05:26 EDT by Satoru Yoshida CLA
Modified: 2011-12-01 08:26 EST (History)
0 users

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Satoru Yoshida CLA 2011-09-28 05:26:58 EDT 
Build Identifier: I20110924-0400 of weekly builds

Hello, I find many translated values are equal to original value.

So, the translated value, -but in truth untranslated- ,often seems to be useless and waste for me.
How can we remove the translated values in http://babel.eclipse.org/babel/translate.php ?

Reproducible: Always

Steps to Reproduce:
1. Download Babel Server weekly mysqldump and restore into mysql.
2. check with following sql.
SELECT t.`value`, f.`name`
FROM (translations t inner join strings s
ON s.`string_id` = t.`string_id` 
AND t.`language_id` = 8
AND t.`value` = s.`value` ) 
inner join files f 
on f.`file_id` = s.`file_id` 

3.Now you can see many untranslated texts into Japanese. (language_id 8 means Japanese)
Comment 1 Satoru Yoshida CLA 2011-10-01 08:58:16 EDT 
I update the SQL to reproduce.
For example, datatools 1.8

SELECT t.`value`, f.`name`
FROM (translations t inner join strings s
ON  t.`string_id` = s.`string_id`
AND t.`value` = s.`value`
AND t.`language_id` = 8 // Japanese
AND t.`possibly_incorrect` =1
AND t.`is_active` = 1
AND s.`is_active` = 1
AND  )
inner join files f
ON  f.`file_id` = s.`file_id`
AND f.`project_id` = 'datatools'
AND f.`version` = '1.8'
AND f.`is_active` = 1
order by 1,2
Comment 2 Satoru Yoshida CLA 2011-12-01 08:26:49 EST 
I will try to replace the texts to translated texts .
Target: next Babel language pack release.