Eclipse Community Forums: Babel » Search and translate

Home » Eclipse Projects » Babel » Search and translate(How to search an original string and eventually translate it into another language)

Search and translate [message #747740]

Mon, 24 October 2011 04:55

Eclipse User

Dear Babel-Community,

I am searching for a plug-in / tool allowing me to search for a string (original language). The tool should return the package containing this string. Additionally it would be nice to have the possibility of translating the string out of the tool.

Is there a possibility of doing this?

Yours faithfully,
Sebastian Hätälä

Re: Search and translate [message #756388 is a reply to message #747740]

Sat, 12 November 2011 10:13

Eclipse User

Hello, Sebastian.

You can search for your interesting string as following.

1) download mysqldump named "Babel Server weekly mysqldump" from other downloads category in www.eclipse.org/babel/downloads.php .

note: actually not weekly.

2) import the mysqldump to your mysql .

3) query which project the string belongs in as following .

Quote:

SELECT f.`project_id`, f.`version`, f.`name`, t.`value`
FROM (strings s inner join files f
ON s.file_id = f.file_id
AND s.value like '%!!YourInterestingValue!!%'
AND f.is_active = 1
AND s.is_active = 1 )
left join translations t
ON s.string_id = t.string_id
AND t.language_id = !!YourLanguageId!!
AND t.is_active = 1
order by 1,2,3;

note: !!YourInterestingValue!! and !!YourLanguageId!! should be changed as your needs.

Thanks.
Satoru Yoshida

Re: Search and translate [message #756559 is a reply to message #747740]

Mon, 14 November 2011 05:19

Eclipse User

Thank you very much!
I am going to try it our right now but it sounds very promising Smile

Thanks.
Sebastian Hätälä

Re: Search and translate [message #811001 is a reply to message #756559]

Thu, 01 March 2012 15:05

Eclipse User

This SQL statement will generate completely usable URLs for English strings:

select distinct CONCAT("http://babel.eclipse.org/babel/translate.php?project=", f.project_id, "&version=", f.version, "&file=", f.name, "&string=", s.name) AS URL from files as f inner join strings as s on s.file_id = f.file_id where s.value IN("Data Cube", "Data Set") and s.is_active = 1;

Previous Topic:	How to upgrade a NLS project ?
Next Topic:	Basic Eclipse Strings

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Jul 07 09:22:41 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter