Shortcut: WD:TN

Wikidata:Translators' noticeboard

From Wikidata
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Translators' noticeboard
This is a noticeboard for all matters regarding translation of pages via the Translate extension, and a meeting place for the translation administrators. Useful links: Documentation for the translation extension, Tutorial for translators. See also the sisterpage m:Meta talk:Babylon.
On this page, old discussions are archived. An overview of all archives can be found at this page's archive index. The current archive is located at 2021/09.

Wikidata:WikiProject Performing arts

Hi,
Can you please "mark for translation" (I don't know what this really means) the page and subpages of Wikidata:WikiProject Performing arts? @Vero Marino, Dirac, Fjjulien Simon Villeneuve (talk) 13:41, 11 November 2020 (UTC)

I have done this for the main page and the header, will continue later with the other subpages if no one else does. --Ameisenigel (talk) 08:05, 12 November 2020 (UTC)
Thank you very much for your help, i will try to continue as well as you did. --Vero Marino (talk) 15:41, 12 November 2020 (UTC)
Wikidata:WikiProject Performing arts/Data structure is marked for translation now. --Ameisenigel (talk) 08:42, 13 November 2020 (UTC)
Thank you so much for your help!! --Vero Marino (talk) 15:01, 13 November 2020 (UTC)
@Ameisenigel, Eihel, Dirac, Simon VilleneuveThank you so much for your help but we need to translate the tables in the typologies page. Can you help us to insert tags in the page? it will be very appreciated. We have translate all the wikiproject but we need to close the work with this last content. Thank you very much for your support. --Vero Marino (talk) 19:20, 1 March 2021 (UTC)
@Vero Marino: You can now translate the tables as well. Happy translating! --Ameisenigel (talk) 16:20, 2 March 2021 (UTC)
Translation
Object Progression Note
Wikidata:WikiProject Performing arts/Tabs ✓ Done by Ameisenigel (20201112)
Wikidata:WikiProject Performing arts (Home) ✓ Done
Wikidata:WikiProject Performing arts/Data structure ✓ Done by Ameisenigel (20201113)
Wikidata:WikiProject Performing arts/Participants unnecessary
Wikidata:WikiProject Performing arts/Typologies (text) ✓ Done by Eihel (20201116)
Wikidata:WikiProject Performing arts/Typologies (tables) ✓ Done by Ameisenigel (20210302)
Wikidata:WikiProject Performing arts/Data sources ✓ Done by Ameisenigel (20210103)
Wikidata:WikiProject Performing arts/Tools & tasks ✓ Done by Ameisenigel (20201116)
Wikidata:WikiProject Performing arts/Statistics ✓ Done by Ameisenigel (20201119)
Wikidata:WikiProject Performing arts/Data sources/Carnegie Hall
Wikidata:WikiProject Performing arts/Data structure/Data modelling issues
Wikidata:WikiProject Performing arts/Data structure/Data modelling issues/organizations ✓ Done by PATH SLOPU
Wikidata:WikiProject Performing arts/à faire fr
Wikidata:WikiProject Performing arts/todolist en
Wikidata:WikiProject Performing arts/Reports/Ingesting Data about Professional Theatre Troupes in Switzerland
Wikidata:WikiProject Performing arts/Data sources/Ehrenreich
Wikidata:WikiProject Performing arts/Data sources/CH
Wikidata:WikiProject Performing arts/Data sources/Character roles
Wikidata:WikiProject Performing arts/Data sources/Operas and arias ✓ Done by PATH SLOPU

Query for translatable and translated pages

(This is a bit offtopic on this noticeboard, but I hope to find for expertise here.)

I would like to query the MediaWiki SQL database and retrieve these:

  • Some marker whether a page is a translatable page, such as Wikidata:Notability for instance
  • Some marker whether a page is a translated page, such as Wikidata:Notability/de for instance
  • Some relation between a translated page and the translation sections (the ones in "Translation" namespace)

Right now I have no clue where this information resides, so it is a bit difficult to get started. I do not need full SQL queries, just a pointer which tables I need to look at. Thanks, —MisterSynergy (talk) 06:20, 28 August 2021 (UTC)

@MisterSynergy: The PHP code checking the first two is in tag/TranslatablePage.php (TranslatablePage::isSourcePage and TranslatablePage::isTranslationPage methods, respectively). If I get the code correctly,
SELECT DISTINCT rt_page
	FROM revtag JOIN page ON rt_page = page_id
	WHERE rt_revision = page_latest AND rt_type IN ('tp:mark', 'tp:tag');
returns the list of all translatable pages; you can add more filters for the page table to find out whether a particular page is translatable (first question).
The second question is more difficult, as this information doesn’t seem to be stored in the DB: a page is considered translated if its base page is a translatable page (see first question) and its subpage title is a valid language code (this is a runtime information, not stored in the database).
I didn’t look up the third question, but I fear it also depends on a runtime bit of information, namely the namespace name: the translation units’ titles are in the format Translation:fullpagename/unitid/langcode, where fullpagename/langcode is the translation page; fullpagename contains the human-readable namespace name, not the numeric namespace ID. unitid is usually a number, although it’s not enforced.
Also, if you want to use this on Wikimedia sites, there’s one more slight issue: the revtag table is not available in public replica databases for some reason. I’m not sure if it’s intentional, though. —Tacsipacsi (talk) 22:08, 28 August 2021 (UTC)
Thanks a lot, this is extremely valuable for me.
Unfortunately I am trying to query this information for Wikidata, so the non-public revtag table is a problem here. I am going to talk to WMF technicians whether this can be changed or not. —MisterSynergy (talk) 22:36, 28 August 2021 (UTC)

ًwhere do I find this list !

Hello everyone,

I am just wondering where do I find the list of languages that appear in the header box in the item's pages?--Michel Bakni (talk) 13:28, 28 August 2021 (UTC)