I apologize but I'm coming into this thread a little late. FWIW, I wanted to mention that this is what we use to generate a list of languages[0] for the Wikipedia Android app.
Less to your question but similar, we also generate localized main page title and site name[1], and namespace titles[2]. There's also a related thread in T121936[3] discussing the localized name of all Wikimedia sites. [0] https://wikistats.wmflabs.org/api.php?action=dump&table= wikipedias&format=csv&s=good [1] https://es.wikipedia.org/w/api.php?action=query&meta= siteinfo&format=json&siprop=general [2] https://fr.wikipedia.org/w/api.php?action=query&meta= siteinfo&format=json&siprop=namespaces [3] https://phabricator.wikimedia.org/T121936 On Fri, Sep 30, 2016 at 3:21 AM, Markus Bärlocher < markus.baerloc...@lau-net.de> wrote: > Thanks Denny for this: > > is this what you look for? > > It's based on the query by Jérémie a few mails back. > > http://tinyurl.com/h2zky8p > > Yes this helps very much :-) > > But there are some inconsistencies: > > 360 WP-languages from your query > 294 WP-languages in https://meta.wikimedia.org/wiki/List_of_Wikipedias > 277 WP-languages in https://de.wikipedia.org/wiki/Wikipedia:Sprachen > > 73 'localname' in the query are empty > > 9 'name' in the query are double > (ell, gsw, lzh, mrj, nan, ron, rup, sgs, vro) > > There are some problems with characters/charset > when I copy&paste the query result to Excel: > Burmese, Gothic, Northern Thai, shows only squares as 'local language' > > But copying after the squares from Excel to Thunderbird works: > Burmese မြန်မာဘာသာစကား mya > Gothic language 𐌲𐌿𐍄𐌰𐍂𐌰𐌶𐌳𐌰 got > Northern Thai ᨣᩴᩤᨾᩮᩥᩬᨦ nod > > All the rest works fine :-) > > It would be good to work out a valid and complete table > of the WP-languages... > > Best regards, > Markus > > > > > > > > Until now I have a CSV with 294 languages in two columns: > > - name of language in English > > - name of language local in local writing system > > > > I look for: > > - ISO-639-3 short code (corresponding to the names) > > > > Best regards, > > Markus > > > > > > _______________________________________________ > > Wikidata mailing list > > Wikidata@lists.wikimedia.org <mailto:Wikidata@lists. > wikimedia.org> > > https://lists.wikimedia.org/mailman/listinfo/wikidata > > > > > > > > _______________________________________________ > > Wikidata mailing list > > Wikidata@lists.wikimedia.org > > https://lists.wikimedia.org/mailman/listinfo/wikidata > > > > > _______________________________________________ > Wikidata mailing list > Wikidata@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikidata >
_______________________________________________ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata