Welcome to Wikidata, Jean-Frédéric!

Wikidata is a free knowledge base that you can edit! It can be read and edited by humans and machines alike, and you can help. Go to any item page now and add to this ever-growing database!
Need some help getting started? Here are some pages you can familarise yourself with:

If you have any questions, please ask me on my talk page. If you want to try out editing, you can use the sandbox to try. Once again, welcome, and I hope you quickly feel comfortable here, and become an active editor for Wikidata.

Regards, --Fabrice Ferrer (talk) 00:44, 2 November 2012 (UTC)

Fabrice Ferrer (talk) 00:44, 2 November 2012 (UTC)


I deleted your translation, as I decided to generalize Province into an administrative subdivision. Techman224Talk 19:41, 4 February 2013 (UTC)

Sure. I was merely looping on the Properties and translating stuff ; but thanks for notifying me :). Jean-Frédéric (talk) 19:44, 4 February 2013 (UTC)

Update French translationEdit

Please translate into French this "'close': 'Close'" phrase in MediaWiki:Gadget-RequestDeletion.js. --Vivaelcelta (talk) 09:23, 11 March 2013 (UTC)

  Done. Jean-Frédéric (talk) 09:55, 11 March 2013 (UTC)

Ministère de la cultureEdit

Bonjour, j'ai un peu modifié ton édit sur le ministère de la culture, parce que l'article anglais parle en fait du ministre, pas du ministère. Et j'ai voulu en profiter pour ajouter le numéro VIAF du ministère, mais la notice BNF est incorrecte. Il faudrait mettre indiquée dans le "regroupé par" de [1], mais le lien bugge, tu saurais pas ce qui va pas ? --Zolo (talk) 21:44, 2 May 2013 (UTC)

Property talk:P268#parameter_value_normalizationEdit

Hi! Please see Property talk:P268#parameter_value_normalization. Can you help please? לערי ריינהארט (talk) 13:17, 9 October 2013 (UTC)

Dewey Decimal Classification (P1036)Edit

Hi Jean-Frédéric! I found and modified it. Is it OK now? Are you using skype? Regards gangLeri לערי ריינהארט (talk) 09:35, 27 May 2014 (UTC)

Wikidata:WikiProject sum of all paintings/Location/FranceEdit

Good use more entries. Multichill (talk) 11:06, 9 August 2014 (UTC)

We talked about Joconde work ID (P347) last night. Looks like some existing items need to be tagged and that's only the list for the Louvre.
Also Napoleon Crossing the Alps (Q59201) is a nice one to untangle. That's one item about 5 different paintings! Multichill (talk) 17:35, 19 August 2014 (UTC)

Cycle d'EnderEdit

Oui, c'est exactement ça Ender's Game hexalogy (Q2642928) c'est une œuvre (enfin un ensemble d'œuvres) mais pas un univers. Son instance of (P31) « hexalogie » est un dérivé de « œuvre », pas d'univers de fiction, donc c'est P:1441 et pas P:1080  . Mais pour les persos qui n'apparaissent pas dans tous les ouvrages, il vaut mieux préciser dans lesquels (de la même façon, on peut signaler dans quels épisodes d'une série télé un élément apparaît, au lieu de juste mettre "dans la série Machin", mais mieux vaut ça que rien du tout). --Harmonia Amanda (talk) 16:21, 8 September 2014 (UTC)


Hi Jean-Frédéric, before importing more Tate (Q430682) paintings, a bit of clean up is needed. For some paintings the collection (P195) is set to Tate Britain (Q195436), Tate Modern (Q193375) or one of the other Tates. See for example this list. This needs to be fixed, otherwise you end up with a bunch of duplicates. What I did: Copy collection to location, update collection to Tate, update collection qualifier of the inventory number to Tate. Tate Modern is done, haven't checked the others yet. Multichill (talk) 20:32, 12 April 2016 (UTC)

Leading zero?Edit

Hello Jean-Frédéric, Can you explain why this edit was made? Did I overlook cases where the Tate-identifeir had an initial 0? Lymantria (talk) 07:50, 16 April 2016 (UTC)

Hello Lymantria,
Thanks for your message − and apologies I did not make use of the edit summary to explain why I was doing this :)
I encountered Edwin Austin Abbey (Q259538) which has an ID of 0. That special case does not warrant my edit though − I don’t believe there are any identifiers with leading zeroes ; with my edit 0123 would be valid although it should not. I reverted myself on that one.
My regex-fu can be a bit rusty, but I do not see any better than something like /[0|[1-9]\d*]/ ? Looks convoluted...
Thanks for the catch :) Jean-Fred (talk) 14:07, 16 April 2016 (UTC)
Yes, that would be convoluted. Luckily the constraint template accepts exceptions. :) Lymantria (talk) 14:28, 16 April 2016 (UTC)


Hello Jean-Frédéric you have spent alot of time on here helping so i thank you!

About Jules (Q56173658)Edit

I write here because I have deleted the item: yes is the same (almost) I moved the sitelink, but don't merged the item because my item was wrong, so I deleted item and discussion page. Thanks --ValterVB (talk) 18:22, 7 November 2018 (UTC)

Cool, thanks for following-up on this :) Jean-Fred (talk) 15:42, 8 November 2018 (UTC)

Les bases de données de jeux vidéoEdit

Salut Jean-Fred ! Comme je sais que tu es un spécialiste sur les jeux vidéos ici, je me suis demandé si tu pouvais me renseigner sur toutes les propriétés concernant les bases de données des jeux vidéos, et plus généralement sur toutes les propriétés qu'un jeu vidéo peut avoir.
Par ailleurs, sais-tu si on peut ajouter des notes de test comme propriété ?
En te souhaitant une très bonne année ! YotaMoteuchi (talk) 22:36, 9 January 2019 (UTC)

Salut @YotaMoteuchi: et bonne année à toi aussi :)
On maintient une liste de ces propriétés sur Wikidata:WikiProject Video games/Properties, et une sous-page en particulier pour les identifiants externes Wikidata:WikiProject Video games/Properties/identifiers.
Pour les notes de test : oui, il y a review score (P444) pour ça − les anglophones ont un guide sur Wikipedia:WikiProject_Video_games/Wikidata#Reviews. C’est pas super-répandu pour le moment − seulement 180 items l’utilisent[1], avec 637 notes au total[2]
En espérant avoir répondu :) Jean-Fred (talk) 08:38, 10 January 2019 (UTC)
  1. SELECT DISTINCT ?item ?itemLabel WHERE {
      ?item wdt:P31 wd:Q7889.
      ?item wdt:P444 [].
      SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
    Try it!
  2. SELECT ?item ?itemLabel ?score ?reviewerLabel ?platformLabel WHERE {
      ?item wdt:P31 wd:Q7889.
      ?item p:P444 ?statement.
      ?statement ps:P444 ?score.
      OPTIONAL { ?statement pq:P447 ?reviewer. }
      OPTIONAL { ?statement pq:P400 ?platform. }
      SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
    Try it!
Salut Jean-Fred ! Les exemples ne fonctionnent pas pour moi : "La requête est mal formulée: Encountered "<EOF>" at line 4, column 71" pour la première requête par exemple.
Ceci dit, je m'aperçois que la note de la critique doit être "associée" (je ne sais pas si c'est le terme) à une propriété d'un identifiant d'une base de données. Si maintenant, la note provient d'un magazine papier, est-ce possible ? Et si oui, comment ?
Et sinon, merci pour toutes ces propriétés, je pense qu'elles me seront très utiles à l'occasion ! YotaMoteuchi (talk) 09:32, 10 January 2019 (UTC)
Ah bah tiens, ça m’apprendra à pas vérifier mes liens ^_^'. Ça devrait marcher maintenant.
Ça semble encore moins répandu (pour l’instant les anglophones mettent les notes surtout pour les aggrégateurs, en particulier Metacritic), mais ça se fait aussi − example sur Q17048660#P444.
Jean-Fred (talk) 09:41, 10 January 2019 (UTC)
Merci beaucoup ! Je garde précieusement cette discussion !!! Il y a tant de choses à faire... YotaMoteuchi (talk) 22:42, 10 January 2019 (UTC)

Newer PCGamingWiki dataset on Mix'n'matchEdit

I'm not sure how much you use the PCGW dataset on Mix'n'Match, but I figured I should let you know I've uploaded a better version with corrected URLs (the only exception is game titles with slashes in them are still broken, unfortunately, but I think that's a mix'n'match problem):

Unfortunately I didn't think about changing all the descriptions for items to "video game" so that item creation wouldn't result in an item with a description of "n/a", but I guess it's too late to fix that now.

Best, Nicereddy (talk)

Thanks for letting me know! I marked the old catalogue as “Inactive” (one needs Catalog Editor rights on Mix’n’match to do it). Regarding the description: too bad, but that can be fixed at the next update ;-).
Funny that the auto-match again did not do a good job − it should for example have matched this to Agricultural Simulator 2012 (Q11849886)… I’ll poke Magnus about it :)
Jean-Fred (talk) 21:35, 7 February 2019 (UTC)
Actually the auto-match acted really bizarrely. It ended up with about 1500 matches, but 700 or so of them weren't instances of video games, so I had to spend a while going through and removing the bad matches.
Did the auto-match work on the original import? I never saw it if it did. Nicereddy (talk)
Ah I see. So, there were no auto-matches at all on the original import, which I feel it definitely should have − there were plenty of exact matches to make. It’s 'good' that it worked this time but very strange it only did crappy matches. Over 40 catalogues imported and I only had good experience with the auto-match. The only exception was cpcrulez but I thought the bad matches were because I had not specified a default type (which you did).
Strange strange strange :)
Jean-Fred (talk) 09:17, 8 February 2019 (UTC)

Reports/Platform/Disk Operating System vs. Reports/Platform/DOSEdit

Aren't these platforms pretty much the same? Does it make any sense to have two of these lists? Trade (talk) 23:05, 20 February 2019 (UTC)

They are indeed ; I had not noticed the latter, as I was creating missing ones from Wikidata:WikiProject Video games/Statistics/Platform (which makes a link based on the English label − not very robust method but should do for now). One can be redirected to the other I’d say :)
By the way, thanks for creating many of these per-platform lists!
Jean-Fred (talk) 08:37, 21 February 2019 (UTC)



J'ai remarqué que les anglais mettaient les redirections sur les items jeux vidéo - exemple : Q3285262

Il faut faire pareil en français ?

a+ FR (talk) 19:38, 14 March 2019 (UTC)

Le système est expliqué sur Help:Sitelinks/fr:
Notez que chaque page Wikimedia/Wikipédia ne peut contenir qu'un lien (sitelink) sur une page d'élément Wikidata. Vous recevrez un message d’erreur si vous tentez d’ajouter un nouveau lien si la page est déjà connectée à une autre page d'élément (même lorsque vous essayez de créer un lien vers une page de redirection pointant vers cette page particulière).
Ça veut dire que Wikidata considère la cible de la redirection, pas la redirection elle-même, et qu’une seule page par wiki peut être liée à Wikidata.
En pratique, si tu essayes de lier fr:Gangstar Rio: City of Saints sur Gangstar Rio: City of Saints (Q3285262), tu te fais bouler avec un “Site link frwiki:Gangstar is already used by item Gangstar (Q3758110)
Ce qui s’est passé avec l’article anglais, c’est que au moment où l’item Wikidata a été lié à la page en:Gangstar Rio: City of Saints, c’était un vrai article, et c’est entre temps que l’article a été transformé en redirect.
Donc, en gros, c’est pas possible :)
Woilà, j’espère que c’est clair ^_^
Jean-Fred (talk) 22:28, 14 March 2019 (UTC)
Ok merci ! Et il faut supprimer les redirects dans ce cas ?
Et la question corollaire : il y a un moyen de faire en sorte que les redirections soient bleuies sur [2] ? FR (talk) 10:09, 15 March 2019 (UTC)

BTVA video games IDEdit

Hello Jean! In these days, You may have noticed that I am replenishing with the help of mix'n'match the VGMdb product ID property. I would like to make same thing (catalog) for BTVA video games ID property. I tried to make it myself with mix'n'match importer, but I don't know how to do it. Therefore, I want to ask if You could import catalog? I will be very grateful and thank you in advance. Kirilloparma (talk) 14:55, 29 March 2019 (UTC)

Sorry for the delay − had a look and then forgot about it ^^. Had another look now and realised this had been done already :D
Jean-Fred (talk) 08:35, 3 May 2019 (UTC)

New PCGamingWiki mix'n'matchEdit

Once again I have added a new dataset to mix'n'match, for whatever reason when I try to mark it as inactive it doesn't do anything. Could you work your magic same as last time? :) Old:, New:

Thanks! Nicereddy (talk) 05:03, 16 April 2019 (UTC)

  Done! Thanks for keeping that dataset updated :) Jean-Fred (talk) 07:44, 16 April 2019 (UTC)

One more external databaseEdit

Hi Jean-Frédéric, while adding Killing Time at Lightspeed (Q63436910), I found IFDB, which could be a good identifier to add on your TODO list. (a bit late in the night to do a property proposal, and telling you in case I do forget) --Misc (talk) 23:24, 2 May 2019 (UTC)

Ok so I couldn't sleep, and went ahead on Wikidata:Property_proposal/Interactive_Fiction_Database_ID. --Misc (talk) 00:00, 3 May 2019 (UTC)
Had never heard of that website − looks like a good addition − thanks for the proposal :) Jean-Fred (talk) 08:35, 3 May 2019 (UTC)

property statEdit

Hi Jean-Frédéric,

Nice tool. Thanks for building it.

Here, I tried to add a "higher grouping" by continent. It works for most of it. Somehow the numbers for the US get doubled (two continents, even if only one is shown). Percentages dropped. Maybe the query can use a "DISTINCT" in count. Couldn't figure out why Netherlands appears with Africa and Tunisia without any continent. The text "(used at least 10 times per grouping)" above the columns is that from an earlier version? --- Jura 23:01, 20 May 2019 (UTC)

Another thing: at US, I tried to group by state, but that would require a more complex first level grouping (I tried "P131/wdt:P131*/wdt:P5086"). --- Jura 09:36, 21 May 2019 (UTC)

  • I found a (ugly) solution for that, but it times out. --- Jura 10:36, 21 May 2019 (UTC)
Glad you like it − thanks for using it :)
  • Good catch with the double-counting − filed myself phab:T224090, will add a DISTINCT to the query.
  • I intended integraality to have a very simple interface (ie, simple parameters) so that folks with little SPARQL-fu could use it ; but by doing so, I kind-of arbitrarily restricted the kind-of grouping possible. I might relax that constraint, by providing an alternative grouping_sparql.
Jean-Fred (talk) 08:56, 22 May 2019 (UTC)
Fixed the double-count by adding a DISTINCT − thanks for the tip :) Jean-Fred (talk) 13:37, 22 May 2019 (UTC)
Thanks. It improved the numbers here too. BTW, I'd favor inputing also the variables ?entity and ?grouping , but I understand your general objective. I tried to find a way to do subnational groupings. It worked for US/IN/AU, but it tends to time-out if there is much data involved (IT, FR). Subnationals groups are a bit tricky, as it requires using an additional time "*" which generally leads to time-outs. While I can generally get queries to work, I'm not sure what optimizations to suggest. Maybe the tool could first do a mere count and then try to work out the groups. Specialists at Request_a_query might have more suggestions. --- Jura 14:31, 22 May 2019 (UTC)
I filed phab:T224229 to discuss/design the grouping interface. Jean-Fred (talk) 15:00, 23 May 2019 (UTC)
  • Somehow grouping_threshold seems to be applied to every cell, even if the row has more than grouping_threshold items. --- Jura 21:52, 22 May 2019 (UTC)

Property dashboardEdit

Salut, j'essaye de paramétrer le modèle pour avoir un tableau des églises par département, mais il me semble que ce n'est pas possible en l'état actuel des choses. Tu me confirmes ? Merci par avance. Ayack (talk) 16:17, 22 May 2019 (UTC)

Alors, je suis pas sûr de comprendre la question, alors double-réponse :-)
Pour le higher-grouping un peu moche qui affichait Belgique: À la base l’outil considère que les groupes sont des Qids (et les affiche dans {{Q}}), excepté pour le `country` (qui les affiche dans {{Flag}}). J’ai codé vite fait un type `string` et ajouté ça à ton dashboard − mais en fait c’est un peu idiot, l’outil devrait être capable de déterminer quel est le datatype − j’ai saisi phab:T224212 pour ça.
Sinon c’était possible de récupérer le Qid du département plutôt que son numéro.
Seconde interprétation de la question:
Si tu voulais pas la colonne “Ville”, mais directement le département, alors oui c’est un peu compliqué pour le moment − pour les raisons abordées sur phab:T224229. Je pense que tu peux tricher avec le SPARQL comme sur User:Seav/Sandbox, mais c’est pas vraiment idéal. Je suis preneur de suggestions de comment faire :)
Jean-Fred (talk) 14:41, 23 May 2019 (UTC)

Prop dashboardEdit

Very very nice!!! Thank you!

I created a dashboard for some maps I am working on:


but I am a bit surprised that, although 6 and 12 maps register in the totals line for the depicts (P180) and main subject (P921) columns, there are no counts in the corresponding column entries for the specific volumes (all should be in Vol 3 Germany and Vol 5 England).

Is there something I have missed?

Thanks again, Jheald (talk) 15:41, 24 May 2019 (UTC)

Just updated the page. Seemingly, numbers may appear in these columns once they get above a particular threshold. But when there are only 6 or 7 instances in a box, that gets reported as zero. If a column is present, it would be nice to have the actual numbers, with no thresholding. Jheald (talk) 10:05, 29 May 2019 (UTC)
User:Jura1 seems to have fixed the page with this diff -- apparently need to set both grouping_threshold and property_threshold to zero to work around this.
One other thing that would be nice would be to be able to define an initial sort ordering -- here the value of volume (P478), cast to a xsd:integer would be nice. Jheald (talk) 11:57, 29 May 2019 (UTC)

Now giving the error <class 'OSError'> [Errno 116] Stale file handle. Jheald (talk) 10:19, 30 May 2019 (UTC)

Fairly sure that last one is Toolforge related − tracking at phab:T224651. Not sure what I can do about it at the moment though :-/ Jean-Fred (talk) 11:04, 30 May 2019 (UTC)

Steam Greenlight (Q61905393)Edit

Valve Corporation (Q193559) discontinued Steam Greenlight (Q61905393) many months ago and i'm worried that they might soon take the website down. I think we should create an identifier before it happens. Unfortunately, Steam Greenlight (Q61905393) is somewhat complicated and i'm not sure how to go on about creating an identifier for it.

Kind regards, Trade (talk) 21:23, 25 May 2019 (UTC)

Tv Tropes identifierEdit

Hey. I've removed all three constraint that you added to this property because I've been putting it on pages for a few days and I have violated all three. Tvtropes often merges or split things in far less (or far more) specific ways than Wikipedia, so neither distinct values constraint (Q21502410) nor single value constraint (Q19474404) are usable, and a type constraint (Q21503250) in particular would need to be so broad as to be pointless. Tvtropes may be best known for its coverage of fandom writ large, but it has thousands of pages about people, brands, companies etc. No notability requirements mean almost anything that's on wikipedia could theoretically be on Tvtropes. Circeus (talk) 12:03, 17 June 2019 (UTC)

Thanks for the adviceEdit

Thank you for the advice. I'm new to wikidata and every advice is welcome. --Arosio Stefano (talk) 10:03, 27 July 2019 (UTC)


Hi there, what is the relationship between Q66251013 and Q66250903? Maybe a translation? Would it be useful then to add a label in English for those of us not able to see all labels? (Labelslister somehow does not do the trick for me.) Thanks! --Chanuga (talk) 09:27, 18 August 2019 (UTC)

software engineEdit

thanks, yes, I didn't know about that at the time (and I believe it was added after for that item). Arlo Barnes (talk) 08:17, 25 August 2019 (UTC)

@Arlo Barnes: Ok, thanks for the answer :) Jean-Fred (talk) 13:02, 26 August 2019 (UTC)

Game Soundtracks and WikidataEdit


Do you happen to know if soundtracks are valid Wikidata items? This collection contains a lot of them Teiron (talk) 17:01, 29 August 2019 (UTC)

Hey @Teiron:,
Yes, it’s definitely a thing − see this SPARQL query:
SELECT ?item ?itemLabel ?soundtrack_release ?soundtrack_releaseLabel ?natureLabel WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?item wdt:P31 wd:Q7889.
  ?item wdt:P406 ?soundtrack_release.
  ?soundtrack_release wdt:P31 ?nature

Try it!

Although, not too sure what is the correct way of modeling them. MusicBrainz makes the difference between the soundtrack (eg MG5 soundtrack) and the soundtrack albums (eg MGS OST. Movies also seem to be a bit of a mess. I asked the question on the Wikidata Telegram group, let’s see if I can get more information :)
Jean-Fred (talk) 19:45, 29 August 2019 (UTC)

Thanks, data modeling, ratings, video gamesEdit

thank you for doing video games

Thank you.

I really appreciate you answering my question and I am impressed by the answer and option available for me. Blue Rasberry (talk) 20:02, 29 August 2019 (UTC)

Community Insights SurveyEdit

RMaung (WMF) 17:37, 10 September 2019 (UTC)

Reminder: Community Insights SurveyEdit

RMaung (WMF) 19:53, 20 September 2019 (UTC)


Merci pour le conseil technique pour obtenir un "statement" en français (en l'occurrence sur la fiche wikidata du wikimedien français chez wiki). Magnon86 (talk) 05:03, 4 October 2019 (UTC)magnon86

New page for cataloguesEdit

Hi, I created a new page where I started collecting sites that could be added to Mix'n'match and I plan to expand it with the ones that already have scrapers by category. Feel free to use, expand. Best, --Adam Harangozó (talk) 12:41, 19 October 2019 (UTC)


Bonjour Jean-Fred,

J'ai découvert ce merveilleux outil sur les captations de la wikidataCon \o/

Je travaille (quasiment seule) à la mise sur wikidata des textes de frwikisource... ce qui n'est pas rien ^^

J'ai quelques difficultés à paramétrer la bête...

D'abord, pourrais-tu mettre un lien vers sur la page du Bot de mise à jour, pour qu'on puisse facilement la trouver, j'ai un peu galéré...

Ensuite, en paramétrant User:Hsarrazin/test4 j'avais d'abord mis un groupement supérieur par Pays, et je me suis retrouvée avec un drapeau Canadien devant l'anglais et le français !!! - voir ici - je n'ai donc rien compris...

Par ailleurs, plutôt que de travailler sur toutes les version, edition, or translation (Q3331189), je voudrais les restreindre à celles qui ont un lien sur frwikisource... penses-tu que ce soit possible (et... oui... on a plusieurs langues sur frwikisource, puisqu'on a l'ancien français, le moyen français, l'occitan, le wallon, le français du québec, etc.)

Je voudrais aussi faire apparaître tous les éléments qui n'ont PAS ENCORE de langue... -> je pense que c'est "stats_for_no_group=true" ? et je voudrais aussi que toutes les langues s'affichent, peu importe le nombre d'éléments (>0)

Pour les éditions, d'autre part, on a des éditions avec P123 (les bouquins) et des éditions avec P1433 (les textes groupés dans un recueil, poèmes, nouvelles, etc.) - Est-il possible d'associer 2 propriétés et de calculer l'un OU l'autre (P123/P1433) ? -> du coup, les "sans critères" correspondraient à "ni P123 ni P1433"...

J'aimerais aussi faire un tableau de bord de tous les éléments liés à frwikisource, groupés par P31, mais là je ne sais même pas comment commencer... ni même si ça peut avoir un sens...

Peux-tu m'aider, stp ? --Hsarrazin (talk) 08:03, 30 October 2019 (UTC)

Bonjour @Hsarrazin: − avec plaisir!
Mettre un lien sur la page du Bot de mise à jour
Bonne idée,   Done (Special:Diff/1041625328)
groupement supérieur par Pays, et je me suis retrouvée avec un drapeau Canadien
Ah, oui, c’est logique: avec un higher-grouping=wdt:P17/wdt:P298, on va chercher sur l’élément English (Q1860) la valeur de la propriété country (P17) (et ensuite sur l’élément ainsi trouvé, la valeur de ISO 3166-1 alpha-3 code (P298). Sur English (Q1860), country (P17) a plein de valeurs donc la requête SPARQL en récupère seulement un, et c’est tombé sur le Canada.
restreindre à celles qui ont un lien sur frwikisource
Houlà, on va essayer ^_^'
Ça a l’air de marcher avec |selector_sparql=wdt:P31 wd:Q3331189. ?sitelink schema:about ?entity; schema:isPartOf <>
non, en fait, ça fait planter pour cause de timeout :( - je reviens à la version antérieure... --Hsarrazin (talk) 09:37, 4 November 2019 (UTC)
les éléments qui n'ont PAS ENCORE de langue.
Oui, c’est stats_for_no_group=true
que toutes les langues s'affichent, peu importe le nombre d'éléments
C’est grouping_threshold=0
Est-il possible d'associer 2 propriétés et de calculer l'un OU l'autre (P123/P1433) ?
Hmmmm, intéressant… Je n’y avais pas pensé à ça… J’ai saisi phab:T236937 pour en discuter.
un tableau de bord de tous les éléments liés à frwikisource, groupés par P31
C’est possible en théorie, en pratique il me faudra résoudre un autre problème − stay tuned :)
Jean-Fred (talk) 20:34, 30 October 2019 (UTC)
merci pour tout ce que tu m'as déjà débloqué... je vais avancer avec ça :) --Hsarrazin (talk) 20:38, 30 October 2019 (UTC)
Pour le tableau de bord de tous les éléments liés à frwikisource, groupés par P31, tu peux déjà en faire une version ultra-basique (just le nombre) avec Listeria: User:Jean-Frédéric/Sandbox2. Jean-Fred (talk) 21:38, 30 October 2019 (UTC)

Nouveau projetEdit

Bonjour Jean-Frédéric,

je pense qu'il pourrait être bien de présenter le projet que tu viens de créer sur le Project chat. Je l'ai découvert inopinément (via la page des propositions de propriété), comme beaucoup de projets fructueux que certaines utilisateurs qui pourraient être intéressés méconnaissent.

Je me permets de te suggérer de donner quelques exemples tirés aussi du monde de la radio, et d'élargir au concept d'émission ; qu'en penses-tu ?

Bien à toi, Nomen ad hoc (talk) 17:54, 3 November 2019 (UTC).


Où as-tu archivé les propositions? - Coagulans (talk) 18:30, 25 November 2019 (UTC)

Oh, what an idiot I am − I archived them nowhere >_> (for some reason I thought it was just archive through history). I’ll fix it first thing tomorrow morning unless someone beat me to it. Jean-Fred (talk) 21:35, 25 November 2019 (UTC)
Done - Coagulans (talk) 19:08, 26 November 2019 (UTC)
Thanks! Much appreciated :) Jean-Fred (talk) 18:21, 4 December 2019 (UTC)

Timeout sur Property dashboard : User:Léna/RATPEdit

Bonjour et bonne année !   J'ai un soucis avec un property dashboard qui fait un timeout (?), ou en tout cas un message d'erreur. La requête correspondante renvoie un peu de 6000 résultats et j'arrive pas en regardant les exemples des autres où j'ai pu me tromper, est-ce que tu vois le soucis ? Léna (talk) 14:22, 5 January 2020 (UTC)

@Léna: Bonne année :)
Special:Diff/1091937694 a fait l’affaire − le bouzin est un peu fragile on dirait, pas tip-top niveau user-experience :-/
Jean-Fred (talk) 20:14, 5 January 2020 (UTC)

Integraality on other wikisEdit

Hi Jean-Fred, I've been playing around with the Integraality dashboards and I think it would be really cool to be able to embed them in other wikis, not just Wikidata (just like Listeriabot works anywhere). Is it just about importing the templates, or will the bot only work on Wikidata? --Alicia Fagerving (WMSE) (talk) 13:08, 27 January 2020 (UTC)

Hi @Alicia Fagerving (WMSE):, I must say, I had not thought about that at all. I don’t see any reason not to support it. Copying the templates would be necessary, but not sufficient, there would be a few code changes to do. I filed phab:T243780 to analyse it and I think it would be fairly straightforward. Jean-Fred (talk) 16:08, 27 January 2020 (UTC)
Thank you! :D --Alicia Fagerving (WMSE) (talk) 07:07, 28 January 2020 (UTC)

external-id, or not… THE DIFFEdit


J'écris ici pour ne pas influencer. Et donc…

Non, parce qu'une grande partie des ID est comme les exemples que vous avez donnés : court. De plus, (je pense que vous parlez d'URL) un Data type URL ne se trouvera plus dans la partie des Identifiants. Je pense que tout est propre dans cette proposition, ÀMHA. Avec syntax clarification (P2916) sur les RegEx, le contributeur pourra être aiguillé vers le bon ID et Formatter URL reste le même. J'ai déjà vu des RegEx beaucoup plus long. Mais c'est le nombre d'entrées qui me pose souci. J'attends l'avis d'un autre contributeur pour voir… Cordially. —Eihel (talk) 21:14, 31 January 2020 (UTC)

et bonne année 2020 le dernier jour de janvier. —Eihel (talk) 21:21, 31 January 2020 (UTC)
(Pas la peine de se vouvoyer ^_^ [enfin, sauf si vous insistez pour qu’on se vouvoie :-) ])
Oui, c’est pas top que les URL ne soient pas avec les autres identifiants mais ce ne serait pas la première fois (pour le moment on a déjà URL (P7294), URL (P7705), PlayStation DataCenter URL (P7707), URL (P7890))
J’ai pas été vérifier mais je te fais confiance pour la regex :) Mais comme je n’avais initialement pas remarqué les examples type Robotron, je comprenais pas pourquoi elle était nécessaire.
Bref, merci d’être intervenu :) Par contre, je viens de remarquer que le formatter URL$1.html ne marche pas avec le format gamemain/cartsnr/robotron/ (le .html final) − on peut toujours rajouter un /index (et faire mais ça ressemble plus vraiment à un identifiant non plus… :-/
Qu’en penses-tu?
(et bonne année 2020 :-) Jean-Fred (talk) 08:06, 4 February 2020 (UTC)
  Done tout est remis en ordre. J'avais déjà suivi les autres propositions et je corrige aussi les nouvelles Propriétés. Aussi, par exemple, est obligé d'être URL, car un identifiant ne peut contenir qu'une donnée dans WD : $1. Typiquement, contient plusieurs changements de part et d'autre des TLD et SLD.
Par contre il faut privilégier les ID externes autant que possible et en dernier ressort, faire appel à un « redirecteur » externe ou au datatype String. Par exemple, pour un simple changement de genre (women-men dans le sport par ex), il n'est pas nécessaire de créer une Propriété avec le datatype URL. Le datatype String ne produit pas de lien vers le site, mais il peut servir d'identifant. J'ai encore amélioré le RegEx. A+ —Eihel (talk) 10:42, 4 February 2020 (UTC)

Modèle:Bases jeuEdit

Salut. C'est quand qu'on envisage l'utilisation de toutes ces propriétés que tu inities ici sur Wikipédia en français ? Modèle:Bases jeu n'attend probablement que ça. Thierry Caro (talk) 18:40, 3 February 2020 (UTC)

Salut. Hmm, je n’y avais pas plus pensé que ça à vrai dire ! Mon boulot sur les modèles de fr.wp s’est résumé à ajouter fr:Modèle:WikidataCheck sur les modèles existants.
Bon par contre, on a pas loin de 200 propriétés sur les jeux vidéo, ça fait potentiellement un peu beaucoup ^_^ Faudrait faire des choix j’imagine?
Jean-Fred (talk) 08:57, 4 February 2020 (UTC)
Oui, il y a désormais une procédure semi-officielle qui demande de valider par un vote des Wikipédiens les nouvelles bases intégrées aux modèles tels que Modèle:Bases jeu. Si déjà on pouvait avoir une vingtaine de propositions solides (couvrant pas mal de jeux), ce serait bien. Peux-tu y penser un de ces quatre ? Thierry Caro (talk) 19:20, 4 February 2020 (UTC)

Query simplificationEdit

Hi Jean-Frédéric,

At [3], "all items without the properties set" gives

SELECT DISTINCT ?entity ?entityLabel 
  ?entity wdt:P31 wd:Q41960 .  
  ?entity wdt:P551 wd:Q3115846 .  
  MINUS {    {?entity a wdno:P21 .} UNION   {?entity wdt:P21 ?prop .}  }  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }

Try it!

maybe it could be simplified to

SELECT DISTINCT ?entity ?entityLabel 
    ?entity wdt:P31 wd:Q41960 .  
    ?entity wdt:P551 wd:Q3115846 .  
    MINUS {  ?entity p:P21 [] }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

Try it!

BTW, this one keeps failing these days. --- Jura 22:38, 6 February 2020 (UTC)

Oh .. it ended up working . BTW InteGraality (Q84572489). --- Jura 22:09, 7 February 2020 (UTC)

Maybe two "display on map"-buttons could be interesting. It would just need:

OPTIONAL { ?entity wdt:P625 ?coor }

at the appropriate places and embed.html in the URL. Love the tool! --- Jura 19:20, 9 February 2020 (UTC)

Browser GamesEdit

I've refrained from creating items about browser games as there is a huge variety regarding modeling making the whole thing a giant mess. Many of the items use instance of (P31) video game (Q7889) while others use browser game (Q848991). Meanwhile some of the items use platform (P400) web browser (Q6368) when others use HTML5 (Q2053) or personal computer (Q16338).

I think it would help greatly if we could all agree on model item (P5869). --Trade (talk) 21:30, 8 February 2020 (UTC)

Dashboard: sorting of higher_grouping columnEdit

Hi Jean-Frédéric. The table includes <td data-sort-value="Q1234"> which leads sorting do be done by QID (data-sort-value) rather than the label. Is there a way to change this? --- Jura 01:07, 14 February 2020 (UTC)

Hmmm… Technically, the application does not know about any labels (actually, it does look up the grouping label for the grouping link, but that’s a special case. It could be done, might be slightly slower as I’d need to query the label of each grouping/higher-grouping − but that could be done in the SPARQL… I will think about this in phab:T245752. Jean-Fred (talk) 16:41, 20 February 2020 (UTC)
I think it would be sufficient to not include "data-sort-value", then js will sort by label. For the first grouping column, this isn't present and it works. --- Jura 16:56, 20 February 2020 (UTC)

Completeness flag(s)?Edit

For [4], it could be interesting to set a number or percentage of items for which the columns are complete.

Also, some columns can reach completeness, others are mainly there for monitoring. --- Jura 03:36, 18 February 2020 (UTC)

I split that list into several subpages. When doing that, I tried to define the "link=" parameter. On {{Wikidata list}} this helps "manual" update link to keep working. However, here it breaks the bot and I'm not sure if the queries in the cell take it into account. --- Jura 16:27, 20 February 2020 (UTC)

Skip throttleEdit

When reading for Template:Integraality_cell, I don't think there is much use of checking for lag. Can you skip that? --- Jura 13:42, 21 February 2020 (UTC)

This is the topic of phab:T244030. See phab:T245210 for my current thinking on this. Jean-Fred (talk) 13:52, 21 February 2020 (UTC)
Maybe you could just submit a bot request for User:InteGraalityBot and described how it will operate/handle it going forward. --- Jura 13:57, 21 February 2020 (UTC)
There seem to be three separate cases: (1) cell: which should be very quick read-only (2) manual update: read, several queries, an update (should be fairly quick, but not overload query server; instead of edit lag, query server load seems important), (3) the weekly update (which can be very slow, if it's a cron job, I'd place it in a low traffic window at night US time). --- Jura 14:03, 21 February 2020 (UTC)

You've got mailEdit

Hello, Jean-Frédéric. Please check your e-mail – you've got mail!
You can remove this notice at any time by removing the {{You've got mail}} or {{YGM}} template. ROMaster2 (talk) 21:24, 26 February 2020 (UTC)

Thank you for participating in the FindingGLAMs Challenge!Edit

  Thank you for participating in the FindingGLAMs Challenge!
By improving information about GLAM institutions on Wikidata, you made the Wikimedia projects better for everyone!

Alicia Fagerving (WMSE) (talk) 14:17, 16 March 2020 (UTC)

Gry Online company ID (P7997)Edit

Hi, In the property Gry Online company ID (P7997), the English label is given as 'Gry Online company ID'. But in the examples given there are peoples also. So do the property need a name change or not.? Regards.-❙❚❚❙❙ JinOy ❚❙❚❙❙ 10:45, 20 March 2020 (UTC)

Hi! Thank you for creating this property :)
It’s more bad design on the part of the database: their data model has two entity types − 'games' and 'companies', and assume that games are developed and published by companies. There is the odd game however which is developed by a single person. This is quite endemic to many games databases, other examples include OGDB company ID (P7570) or Gamekult company ID (P7911). That’s why the type constraint also accepts video game developer (Q58287519).
So I can see two solutions: following the database naming scheme and keeping company, or replacing with the more explicit “Gry Online developer/publisher ID”. So far, I just kept whichever name the database was using, but I’m happy to go either way. :-)
Jean-Fred (talk) 14:19, 20 March 2020 (UTC)
Thank you for the clarification. When I have checked both the properties OGDB company ID (P7570) and Gamekult company ID (P7911) have type contains violations. It has showed type contains violations for Terry Cavanagh (Q11709677) since only organization (Q43229) alone was added when i created the property. So that's why I changed it after that. Go ahead if you need any changes to it. Regards :) -❙❚❚❙❙ JinOy ❚❙❚❙❙ 14:54, 20 March 2020 (UTC)

X modelEdit

Salut JF,

video game console was very clean, almost all that used the VGC model were also subclass of VGC. Mobile phones was much more work, subclass missing etc.

25 in main space still use video game console model [5] - can you help removing them? MrProperLawAndOrder (talk) 15:50, 3 May 2020 (UTC)


Hey, i noticed that WD were missing a lot of content ratings and content descriptors and i want to help wit that. If you could make a Mix'n'Match catalogue for Mobygames game ratings, descriptors and consumer advice that would be a huge help! Kind regards Trade (talk) 01:26, 17 June 2020 (UTC)

@Trade: I could not find a page listing all potential attributes so I wrote a script to iterate all potential attributes and stored the result as 3646 − it’s a very mixed collection, but I hope that helps :) Thanks for your work on ratings and descriptors! Jean-Fred (talk) 12:49, 24 June 2020 (UTC)

Probably Incorrect Match on Mix & MatchEdit

Hey Jean-Fred, it's been a while! Looks like you've been busy here while I was gone; I take it the Mix & Match thing is your creation? It seems pretty cool! Unfortunately another user seems to have incorrectly matched Death Star Interceptor (Q65681214) with Death Star (Q97495898) via Mix-n-Match. I removed the incorrect MobyGames id from Death Star Interceptor (Q65681214), but I guess I should probably remove the mix and match it came from too? I did see a remove button there, but wasn't sure if I should press it =D Rampagingcarrot (talk) 06:57, 19 July 2020 (UTC)

@Rampagingcarrot: Long time no see :)
Yeah, I have been busy adding a bunch of catalogues to Mix’n’match (though I’m not the only one!).
Re: incorrect match: yes, please use “Remove” in Mix’n’match and then map it to the correct item − that ensures the error does not come back in future syncs between Wikidata and Mix’n’match. There are a bunch of mismatches listed at User:Magnus Manske/Mix'n'match report/791.
Jean-Fred (talk) 10:11, 21 July 2020 (UTC)
@Jean-Frédéric: Took me a bit to get to it, but I just updated the Mix'n'match, along with two other incorrect ones I found yesterday. I'll keep an eye out on the pages I work on --Rampagingcarrot (talk) 20:09, 25 July 2020 (UTC)

Dashboard selector_sparqlEdit

To solve the problem outlined at Wikidata:Request_a_query#Convulted_syntax_(property_dashboard), creating an additional field that would be used if present (e.g. "selector_with_sparql") that would allow the input of:

?entity wdt:P31 wd:Q1234.


{ SELECT DISTINCT ?entity { ?entity ^ wdt:P2860/wdt:P1433 wd:Q665807 } }

Both would be wrapped into:

SELECT ?entity { <insert here> }

contrary to "selector_sparql" that uses:

SELECT ?entity { ?entity <insert here> }

What do you think? Would they work with the other queries as well? --- Jura 07:33, 21 July 2020 (UTC)

This is a bit similar to phab:T224229. It’s probably doable, but I’m not sure of how much work it would be (as the selector sparql is used in several queries). Won’t have time to work on that any time soon ; but could you please file a Phabricator task describing the usecase? It will be very helpful down the line. Thanks! Jean-Fred (talk) 10:04, 21 July 2020 (UTC)

About WikiCite 2020Edit

Dear Mr.,

We are organizing a French-speaking session of WikiCite 2020 online on 27 October 2020 from 15:00 to 19:00 UTC. Further information on the preliminary program can be found at We are still finding a speaker that can introduce Wikidata and the bibliographic metadata it currently involves to the session audience. I ask if you can present Wikidata during the session.

Yours Sincerely,

--Csisc (talk) 11:14, 17 September 2020 (UTC)

User:Multichill/Monuments statisticsEdit

User:Multichill/Monuments statistics filled up. Did you do an update of the code? :-) Multichill (talk) 18:05, 21 September 2020 (UTC)

We sent you an e-mailEdit

Hello Jean-Frédéric,

Really sorry for the inconvenience. This is a gentle note to request that you check your email. We sent you a message titled "The Community Insights survey is coming!". If you have questions, email

You can see my explanation here.

MediaWiki message delivery (talk) 18:46, 25 September 2020 (UTC)


Back in May you added a VNDB ID to Baccano! (Q484579), but the VNDB record is for a Nintendo DS video game. The item is for the anime and light novel (which should be two separate items, but I digress), and the DS video game should be a separate item entirely. Just figured I'd mention that in case there might be other items like that :) Hope you're doing well! Nicereddy (talk) 05:23, 10 October 2020 (UTC)

How to create a catalog for IGDB games in Mix'n'matchEdit

I'd like to create a catalog similar to the Mobygames catalog on Mix'n'match but for IGDB database listings instead (which is already a type in wikidata. Despite reading the manual I'm still not sure how to import properly or confident enough that I will do it right. Any help guiding me in the right direction would be appreciated. Thanks, SuperUserCode (talk) 03:37, 17 November 2020 (UTC)

Deprecate PCGW v3 catalogEdit

@Jean-Frédéric: I've made a new v4 catalog in Mix'n'match for PCGamingWiki with new data and better descriptions based on a dump of the site that I created. I'm trying to uncheck the 'Active' box on v3 but it doesn't do anything. IIRC you were able to do it last time when I wasn't, would you mind doing that again and deactivating v3?

Thanks! Hope you're doing well :) -Nicereddy (talk) 01:16, 8 December 2020 (UTC)