Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 359198

Summary:	I find many translated values are equal to original value.
Product:	[Technology] Babel	Reporter:	Satoru Yoshida <ramat>
Component:	translations	Assignee:	Babel server inbox <babel.server-inbox>
Status:	CLOSED WORKSFORME	QA Contact:
Severity:	trivial
Priority:	P3
Version:	unspecified
Target Milestone:	---
Hardware:	All
OS:	All
Whiteboard:

Description Satoru Yoshida

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

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

2011-12-01 08:26:49 EST

I will try to replace the texts to translated texts .
Target: next Babel language pack release.