Skip to main content



      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 04:55 Go to next message
Eclipse UserFriend
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 Go to previous messageGo to next message
Eclipse UserFriend
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 Go to previous messageGo to next message
Eclipse UserFriend
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 Go to previous message
Eclipse UserFriend
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:
  


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

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

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

Back to the top