Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Babel » Search and translate(How to search an original string and eventually translate it into another language)
icon5.gif  Search and translate [message #747740] Mon, 24 October 2011 08:55 Go to next message
Sebastian Hä älä is currently offline Sebastian Hä äläFriend
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ä

Re: Search and translate [message #756388 is a reply to message #747740] Sat, 12 November 2011 15:13 Go to previous messageGo to next message
Satoru Yoshida is currently offline Satoru YoshidaFriend
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
Re: Search and translate [message #756559 is a reply to message #747740] Mon, 14 November 2011 10:19 Go to previous messageGo to next message
Sebastian Hä älä is currently offline Sebastian Hä äläFriend
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ä
Re: Search and translate [message #811001 is a reply to message #756559] Thu, 01 March 2012 20:05 Go to previous message
Denis Roy is currently offline Denis RoyFriend
Messages: 357
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
Previous Topic:How to upgrade a NLS project ?
Next Topic:Basic Eclipse Strings
Goto Forum:
  


Current Time: Mon Dec 22 11:21:41 GMT 2014

Powered by FUDForum. Page generated in 0.03806 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software