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)

Show: Today's Messages :: Show Polls :: Message Navigator

Search and translate [message #747740]

Mon, 24 October 2011 08:55

Sebastian Hä älä

Messages: 11
Registered: October 2011

Junior Member

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ä

Report message to a moderator

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

Sat, 12 November 2011 15:13

Satoru Yoshida

Messages: 17
Registered: November 2011

Junior Member

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

Report message to a moderator

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

Mon, 14 November 2011 10:19

Sebastian Hä älä

Messages: 11
Registered: October 2011

Junior Member

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

Thanks.
Sebastian Hätälä

Report message to a moderator

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

Thu, 01 March 2012 20:05

Denis Roy

Messages: 426
Registered: October 2004
Location: Ottawa, Ontario, Canada

Senior Member

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;

Denis Roy
Eclipse Webmaster -- webmaster@eclipse.org

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 19 11:54:43 GMT 2017

.:: Contact :: Home ::.