Wikimedia Bugzilla is closed!

-------------------------------------------------------------------------------
From: Tim Sears <sears.tim@gmail.com>
Date: Wed, 05 Jan 2011 03:01:19
-------------------------------------------------------------------------------

So for each article linked on [[User:Mahir78/List_of_towns_and_cities_in_India]], you want the langlink titles in english, hindi and tamil. So for example:

English:[[Barddhaman]]  
Hindi:बर्धमान

Correct?

-------------------------------------------------------------------------------
From: Mahir <mahir78@gmail.com>
Date: Wed, 05 Jan 2011 07:45:56
-------------------------------------------------------------------------------

Thanks Tim Sears.

You are correct. If you can provide like this that will be great.

<item>  
<english>Barddhaman</english>  
<hindi>बर्धमान</hindi>  
<tamil></tamil>  
</item>  
<item>  
<english>Chennai</english>  
<hindi>चेन्नई</hindi>  
<tamil>சென்னை</tamil>  
</item>

Thanks & Regards  
Mahir

-------------------------------------------------------------------------------
From: Hoo man <hoo@online.de>
Date: Thu, 06 Jan 2011 20:20:45
-------------------------------------------------------------------------------

I've executed the query you wanted, but I haven't yet been able to convert it into the XML format you requested. May I'm going to convert it later, but for now I've uploaded the results in 3 formats in the hope that you can use one ![][1]

SQL:
    
    SELECT pagelinks.pl_title as en_title, langlinksta.iw_title as ta_title, langlinkshi.iw_title as hi_title FROM page INNER JOIN pagelinks ON page.page_id = pagelinks.pl_from LEFT JOIN (SELECT langlinks.ll_title as iw_title, page.page_title as title FROM page INNER JOIN langlinks ON page.page_id = langlinks.ll_from WHERE langlinks.ll_lang = 'ta') as langlinksta ON langlinksta.title = pagelinks.pl_title LEFT JOIN (SELECT langlinks.ll_title as iw_title, page.page_title as title FROM page INNER JOIN langlinks ON page.page_id = langlinks.ll_from WHERE langlinks.ll_lang = 'hi') as langlinkshi ON langlinkshi.title = pagelinks.pl_title WHERE page.page_namespace = 2 AND page.page_title = 'Mahir78/List_of_towns_and_cities_in_India' AND pagelinks.pl_namespace = 0 GROUP BY en_title;

  
Result:  
http://toolserver.org/~hoo/dbq/dbq-116.txt (plain text)  
http://toolserver.org/~hoo/dbq/dbq-116_html.txt (xhtml table)  
http://toolserver.org/~hoo/dbq/dbq-116_wiki.txt (wiki table)

   [1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif

-------------------------------------------------------------------------------
From: Hoo man <hoo@online.de>
Date: Thu, 06 Jan 2011 20:36:23
-------------------------------------------------------------------------------

That was easier as I thought it would be, so here is your custom format:  
http://toolserver.org/~hoo/dbq/dbq-116_custom.txt ![][1]

   [1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif

-------------------------------------------------------------------------------
From: Mahir <mahir78@gmail.com>
Date: Wed, 12 Jan 2011 18:52:53
-------------------------------------------------------------------------------

Hoo man

Just another (repeated) task for you ![][1] or someone else? 

Can you please run this same query in hindi wikipedia and in tamil wikipedia so that i can get missed articles in tamil and this will help to avoid redoing tranliteration work. 

I wish to transliterate from hindi to tamil using a tool then create pages in tawiki. (had discussed with our ta community).

This will help us to create few hundred articles for tawiki alteast not thousands.

This time just text with tab space is enough no need of three files.

Thanks for your work.

Regards  
Mahir

   [1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif

-------------------------------------------------------------------------------
From: Mahir <mahir78@gmail.com>
Date: Wed, 12 Jan 2011 18:54:38
-------------------------------------------------------------------------------

I just reopen to run the query in other wiki (hindi and in tamil)

-------------------------------------------------------------------------------
From: Hoo man <hoo@online.de>
Date: Thu, 13 Jan 2011 19:07:50
-------------------------------------------------------------------------------

But with which list? Have you created a custom list on those wikis, or should I use the results from enwiki as source?

-------------------------------------------------------------------------------
From: Mahir <mahir78@gmail.com>
Date: Tue, 01 Feb 2011 05:04:11
-------------------------------------------------------------------------------

sorry for the late reply... from the same list.

http://en.wikipedia.org/wiki/User:Mahir78/List_of_towns_and_cities_in_India

-------------------------------------------------------------------------------
From: Hoo man <hoo@online.de>
Date: Tue, 01 Feb 2011 15:39:29
-------------------------------------------------------------------------------

I'm sorry, but on tawiki, not a single page of the above exists and on hiwiki only a few redirects (about ten), therefore I have no results. The only think that IMO could be useful is to use the results gathered on enwiki.

-------------------------------------------------------------------------------
From: Mahir <mahir78@gmail.com>
Date: Tue, 01 Feb 2011 16:04:45
-------------------------------------------------------------------------------

oh, sorry it was my mistake, like we will not have tamil articles in english wiki. so it was wrong. 

Now, I wish I should have a php tool for this work so that i can get my own data instead of pinging to you.

I am translating lists type articles from english to tamil. Idea is i can copy paste the list in left side textarea (one by one) clicking on a button will populate the langlinks. en->ta and ta->en.

Please help me where i can post this requirement?

-------------------------------------------------------------------------------
From: Hoo man <hoo@online.de>
Date: Mon, 24 Oct 2011 20:22:37
-------------------------------------------------------------------------------

Is that tool still needed? If so, feel free to open a request over here: https://jira.toolserver.org/browse/hoo this is the wrong Project for that ![][1]

   [1]: https://jira.toolserver.org/images/icons/emoticons/wink.gif

This bug was imported as RESOLVED. The original assignee has therefore not been
set, and the original reporters/responders have not been added as CC, to
prevent bugspam.

If you re-open this bug, please consider adding these people to the CC list:
Original assignee: hoo@online.de
CC list: hoo@online.de, mahir78@gmail.com