Open main menu

User talk:Jean-Frédéric


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 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)

Return to the user page of "Jean-Frédéric".