User talk:Magnus Manske

From Wikidata
Jump to: navigation, search

all talk archives and subpages user pages · m:special:CentralAuth · JIRA

Logo of Wikidata

Welcome to Wikidata, Magnus Manske!

Wikidata is a free knowledge base that you can edit! It can be read and edited by humans and machines alike and you can go to any item page now and add to this ever-growing database!

Need some help getting started? Here are some pages you can familiarize yourself with:

  • Introduction – An introduction to the project.
  • Wikidata tours – Interactive tutorials to show you how Wikidata works.
  • Community portal – The portal for community members.
  • Contents – The main help page for editing and using the site.
  • Project chat – Discussions about the project.
  • Tools – A collection of user-developed JavaScript tools to allow for easier completion of some tasks.

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.

Best regards! --Guerillero | Talk 21:59, 2 January 2013 (UTC)

Lexikon deutschsprachiger Epik und Dramatik von Autorinnen 1700–1900[edit]

Hallo Magnus, kannst du mal einen Blick auf Anna Maria Schwendendörffer (Q18916655) werfen? Lt. deiner Quelle wurde die geistliche Dichterin 1673 geboren. GND 104122129 nennt 1673 als Sterbejahr, und um die Verwirrung perfekt zu machen, kennt der Gesamtkatalog deutschsprachiger Leichenpredigten (GESA) auch noch eine Anna Maria Schwendendörffer (gest. 1637). --Kolja21 (talk) 21:19, 19 May 2015 (UTC)

TAB and monolingual text[edit]

Hi Magnus. I'm a frequent user of TAB .. most helpful tool.

If there is one thing I think it might be worth adding, it's the display monolingual texts. Something like "en:string" would do. As I rarely use the tool for editing, display-only would be sufficient. --- Jura 08:50, 23 May 2015 (UTC)

QuickStatements: novalue[edit]

Is there a way to set Q4294967295? I'd like to set it on items such as Master of the Barbe de Preux (Q1918332). --- Jura 16:08, 24 May 2015 (UTC)

Not at this time. Also, Q4294967295 is a WDQ hack; there is an actual "unknown" and a "no value" state on Wikidata proper. --Magnus Manske (talk) 07:25, 25 May 2015 (UTC)
I see. It is the actual novalue that I was trying to set. --- Jura 07:33, 25 May 2015 (UTC)


Hello Magnus! Can I ask you a few questions so I don't mess up my next batch with QuickStatements.

  1. First, is there a way to get AutoList to just give you the Q numbers of items? I want all the Wikidata items that relate to namespace 0 pages from dewikisource, Category "Paulys Realencyclopädie der classischen Altertumswissenschaft", depth 4.
  2. Second, iI noticed that queuing up various qualifiers lead to unwanted results. Do I have to queue up qualifiers one by one, or is there a way to add multiple qualifiers in one session?

Best, Jonathan Groß (talk) 12:11, 28 May 2015 (UTC)

Hi Jonathan, the first one is probably better suited to QuickIntersection (link pre-fills parameters, set your output format and click on "Do it!"). For the second one, you should be able to add P-TAB-Q (or any type) qualifiers in one line. If in doubt, maybe give me an example of a QuickStatements line, and what you want it to do. (gerne auch Deutsch!) --Magnus Manske (talk) 12:33, 28 May 2015 (UTC)
Okay, danke für den Tip. Quick Intersection werde ich mal ausprobieren. Kannte ich bisher noch nicht.
Für 2: Ich hab mich entschieden, die beiden Qualifikatoren nacheinander einzufügen.
Liebe Grüße und vielen Dank, Jonathan Groß (talk) 13:15, 28 May 2015 (UTC)

QuickStatements: add to Property[edit]

I want to add to EAGLE id (P1900) more examples. They go like this:

  • Wikidata property example: Rostrum: EAGLE id: objtyp/lod/1961

When I try to add this with QuickStatements

P1900   P1855   Q681337 P1900   "objtyp/lod/333"
P1900   P1855   Q335239 P1900   "material/lod/43"
P1900   P1855   Q3567529        P1900   "writing/lod/9"
P1900   P1855   Q484692 P1900   "typeins/lod/65"
P1900   P1855   Q158091 P1900   "decor/lod/15"

it complains "ERROR: P1900 is not a Wikidata item (Qxxx)". Well yes, it's a property, and properties can have data too.

QuickStatements currently works only on items, not properties. Properties couldn't have data when it was written, and there's less than 2K properties... --Magnus Manske (talk) 08:47, 29 May 2015 (UTC)

Listeria sorting[edit]

Hi Magnus :) I was playing with Listeria over at de:Benutzer:Nikki/Listeria (to make something resembling de:Liste der Kulturgüter von Malta) and I can't seem to figure out how sorting on properties is supposed to work. I'm trying to sort based on Maltese Islands National Inventory of Cultural Property identifier (P1799) and I've tried using 1799, p1799, P1799 and even the name I assigned to the column, but none of them seem to work. Have I found a bug, or am I doing something wrong? - Nikki (talk) 11:50, 29 May 2015 (UTC)

String sort wasn't implemented yet. Fixed now. --Magnus Manske (talk) 12:05, 29 May 2015 (UTC)
Perfect, thanks! - Nikki (talk) 14:00, 29 May 2015 (UTC)

Reinheitsgebot invented death dates[edit]

Hi Magnus. I'm working on items that are categorized as living people on but have a date of death (P570) statement on Wikidata. I have found a fair number of instances in which Reinheitsgebot in July of last year added death dates on Wikidata that it seems to have conjured out of nothing. I can't exactly spot a pattern that would explain the problem but here are a few instances.

Best, Pichpich (talk) 02:04, 1 June 2015 (UTC)

Huh. I operate Reinheitsgebot on manually compiled lists, but I can't remember where I would have gotten a "death list". I'll try to find the batch from back then, but due to the manual "feeding" of lists, it's unlikely to repeat itself. I hope. --Magnus Manske (talk) 07:19, 1 June 2015 (UTC)
@Pichpich: That's easy, that's from persondata. Most articles still seem to contain the (incorrect?) persondata. Should be fixed if you don't want other bots to re-import that in the future. Multichill (talk) 20:31, 1 June 2015 (UTC)
Ah, that makes sense. Thanks for figuring it out! Pichpich (talk) 22:04, 1 June 2015 (UTC)

Match labels, aliases using WikidataQuery[edit]

Is there any way to use the WikidataQuery API to also search for matches for labels, aliases, and descriptions, like how the fourth bar on Autolist 2 works? --Yair rand (talk) 12:17, 3 June 2015 (UTC)

No. I tried that back in the day, and the amount of RAM required to hold all of that data is just too ginormous. And since SPARQL services are almost upon us, I won't invest much time in upgrading now. --Magnus Manske (talk) 12:50, 3 June 2015 (UTC)


Hi Magnus. Thanks for this tool. Most helpful. I had been waiting for this for quite some time, but I even missed it when you first announced it. Must have skipped the post when reading then name.

For "recent deaths", would it be possible to do the selection 1 month to date (or 6 months/1 year). Deaths in 2015 is too large already. Ideally the list would be sorted in descending order.

BTW, I like autodescription (even overriding the manual one), but I couldn't get it to work.

I updated Template:Wikidata list trying to described how it currently works. --- Jura 09:38, 4 June 2015 (UTC)

To get just a month (e.g. January), use BETWEEN[570,2015-01-00,2015-01-32] ;-)
| autolist=fallback should use the automatic description if there is no manual one.
FWIW, I usually update the English template; I should probably do that here. --Magnus Manske (talk) 09:47, 4 June 2015 (UTC)
A variable to do the trailing one-month list would be nice. This way we could try to promote the lists on various wikis without having to change it every couple of weeks.
For the descriptions at User:Jura1/Dupont remains empty even with autolist=fallback set, maybe it checks all languages for existing descriptions. --- Jura 10:00, 4 June 2015 (UTC)
Fixed auto description. --Magnus Manske (talk) 10:12, 4 June 2015 (UTC)
Thanks. I gave it a shot: Recent deaths (also in en/fr/de/nl). --- Jura 11:57, 4 June 2015 (UTC)
On this I tried to display the qualifier series ordinal (P1545), but it doesn't seem to display. --- Jura 12:14, 4 June 2015 (UTC)
Fixed. --Magnus Manske (talk) 13:01, 4 June 2015 (UTC)
Thanks again. The behavior is now not completely consistent with P580 and P582, but it's hard to say what would be the ideal solution for people with multiple terms. --- Jura 15:11, 4 June 2015 (UTC)

URL in QuickStatements[edit]

Hi Magnus, none of the following statements are working for the reference. Could you tell me the right syntax please?

Q2853810        P569    +00000001765-03-23T00:00:00Z/11 S854    ""
Q2853810        P569    +00000001765-03-23T00:00:00Z/11 S854

Thanks. — Ayack (talk) 17:06, 5 June 2015 (UTC)

It should be quoted, but I think it's not working because of the way references are handled with the date type (I've been using it fine for items).
Magnus: I dug around in the code and it seems that at [1] it compares the original date and the date returned from Wikidata, but the original date is zero-padded whereas the data returned from Wikidata is not (when inspecting the values at the point it compares them, the former is +00000001765-03-23T00:00:00Z and the latter is +1765-03-23T00:00:00Z), so I'm guessing that because the comparison fails, it returns and never gets to the bit where it would add the reference. There might be a nicer way to do it, but I imagine using something like v.mainsnak.datavalue.value.time !=^([+-])0*([1-9].*)/, "$1$2") instead would probably work. - Nikki (talk) 05:43, 7 June 2015 (UTC)
Thanks for your answer Nikki.
Magnus: do you plan to change (fix?) it, or should I find another way to add these statements? Thanks. — Ayack (talk) 13:43, 8 June 2015 (UTC)
Fixed now. --Magnus Manske (talk) 14:22, 8 June 2015 (UTC)
Great, thanks a lot! — Ayack (talk) 14:45, 8 June 2015 (UTC)
Magnus: I tested this again now that the labs server is back and it looks like it's not working again - perhaps your fix was lost when the data was restored? - Nikki (talk) 17:46, 19 June 2015 (UTC)
Yup. Try again please! --Magnus Manske (talk) 21:44, 21 June 2015 (UTC)
Yep, it's working again. Thanks! - Nikki (talk) 09:32, 24 June 2015 (UTC)

Listeria update[edit]

Hi Magnus, at Governors of Vermont‎, the daily update blanked the list. It also happened at another list yesterday. Maybe the automatic update shouldn't blank lists if it gets no data. --- Jura 09:39, 6 June 2015 (UTC)

Good idea, implemented now. --Magnus Manske (talk) 09:45, 6 June 2015 (UTC)
Thanks. --- Jura 10:14, 6 June 2015 (UTC)
It might be bad luck, but all but 1 page didn't update in the daily run. --- Jura 08:31, 7 June 2015 (UTC)
Maybe this. Fixed some bugs, added a warning for long lists. Re-running. --Magnus Manske (talk) 10:55, 7 June 2015 (UTC)
Ok. Thanks. Is the long list "warning", why I can't update this any more? What's the maximum size? I didn't mind the previous solution where it generated the list once, but just didn't update it anymore. --- Jura 11:37, 7 June 2015 (UTC)

Is there a way to pass just the Qid to a template? I'm trying to do this to get around the page size issue at User:Jura1/Deaths in 2015. --- Jura 10:14, 6 June 2015 (UTC)

Not sure I understand the question. If you want the template to display a manual list of items, you can use wdq=item[123,456,...], as per docs. --Magnus Manske (talk) 12:53, 6 June 2015 (UTC)
I tried to use the template to do the property lookup with {{#property:P569|from={{{qid}}}}}. --- Jura 12:57, 6 June 2015 (UTC)
Sorry, you have lost me. You put that into {{Wikidata list}} somewhere? What exactly is it you wish to achieve? --Magnus Manske (talk) 13:53, 6 June 2015 (UTC)
Something like this, but it seems to hit some LUA limits. In any case, I think it could be helpful to have the bare QID available without the formatting added with "column=item". --- Jura 14:07, 6 June 2015 (UTC)
It now uses qid for the "pure" Q number. The Lua error remains, however. --Magnus Manske (talk) 14:45, 6 June 2015 (UTC)
Thanks for adding that. I got it to work, kind of. Maybe a template for the table header is needed as well. --- Jura 15:35, 6 June 2015 (UTC)


Hi Magnus, for the above, links for "noclaim" would be helpful in addition to the current "subgroup: items" ones. --- Jura 12:36, 6 June 2015 (UTC)


Hi Magnus,

I use a lot FIST for adding images, especially to people (Q5). Often, there is only 1 picture, which is already used as Signature or Grave image.

Would it be possible to sort out items where the only picture is already used by another property than P18 ? it would clean the lists of all items where the grave pic has already been added, long ago :)

Thank you so much for the wonderful tools you build to help us edit and complete items on wikidata :) --Hsarrazin (talk) 18:19, 7 June 2015 (UTC)

Excellent idea! I've added this as a parameter (off by default, to preserve consistency in existing URLs). Note that will exclude any images used in any Wikidata item; property-specific search would take too long with the existing infrastructure. --Magnus Manske (talk) 20:28, 7 June 2015 (UTC)
Also, have you noticed the new "yellow button" with each WD-FIST item? If all that is suggested are files that will never be relevant (e.g. paintings by a painter), you can prevent them from showing up again for that item, by clicking the yellow button. --Magnus Manske (talk) 22:13, 7 June 2015 (UTC)
oh yes, I've noticed it, and tried it immediately ;) — I'm now cleaning up country citizens lists that I had already completed, but where I had previously no way to mark... no pic… that's really very useful, and I will try to make good use of it.
one other thing would be very useful - I saw someone else asked about it, but don't know how it could be handled (in coordination with commons, probably) : it's the case of the "group photos", like on Joe Pearce (Q16013499) - it would be cool to be able to mark those pics as to be cropped and tagged for every person on it… many sportsperson are only on those. I don't remove them, for now. --Hsarrazin (talk) 15:56, 8 June 2015 (UTC)

Listeria and arbitrary access[edit]

Listeria sounds pretty awesome, but sometimes we may want somewhat complex formatting of the item (say for an artwork "ink and watercolor on pencil" based on material used (P186)). With arbitrary access, we have a simple solution: just provide the list of items and let Lua format it on Wiki. Would it be feasible to have the bot just update the list of items in, say, WD:Frick Collection ? --Zolo (talk) 12:30, 10 June 2015 (UTC)

You can do this, but LUA limits tend to kick in earlier than those of Listeria. We lack a mediawiki function to get the label efficiently. --- Jura 12:56, 10 June 2015 (UTC)
I added "generic" template use, which requires |wdq=...|items=...}} in the page somewhere. This is an edit the bot made. It can be invoked like this. No automatic, daily updates yet; ideally, I'd need a single template or category name to identify "generic update" pages for that. --Magnus Manske (talk) 13:16, 10 June 2015 (UTC)
Great ! I switched to a generic Template:Formatted list. --Zolo (talk) 15:46, 10 June 2015 (UTC)
One more thing: in the old template, some wdq links were not provided through a parameter, but autogenerated by the template. For such cases, is there any way to retrieve the query from a tag in the html render rather than from a parameter in the page code ? --Zolo (talk) 19:56, 10 June 2015 (UTC)
Possible, but difficult enough to try to avoid it as much as possible... --Magnus Manske (talk) 07:47, 11 June 2015 (UTC)

Added {{Formatted list}} to the bot, these will be updated daily now. --Magnus Manske (talk) 08:17, 11 June 2015 (UTC)

Error by Rheinheitsgebot[edit]

Not quite sure what happened here, but I've fixed it now. Gabbe (talk) 14:12, 10 June 2015 (UTC)

Bad {{Persondata}}. --Magnus Manske (talk) 14:20, 10 June 2015 (UTC)[edit]

is broken.--GZWDer (talk) 02:12, 11 June 2015 (UTC)

[2] --Magnus Manske (talk) 07:45, 11 June 2015 (UTC)

Widar edits occasionally removing data when adding statements[edit]

Something weird seems to be happening with some Widar edits where it will remove some data while adding a new statement. I've seen a few like this today while looking at User:Pasleim/Items_for_deletion/Almost_empty. Couple of examples:

  • [3] from the 3rd of June where your bot account User:Reinheitsgebot removed the labels and description it had just added while adding a statement.
  • [4] from February where the description and a bunch of statements which had just been added got removed while adding a statement.

Neither of those look intentional and since the Reinheitsgebot one was barely a week ago, it doesn't seem like an old problem either. Any idea what's going on? - Nikki (talk) 08:50, 11 June 2015 (UTC)

There is a known bug with edits happening at the same second. Upstream, SEP. --Magnus Manske (talk) 09:34, 11 June 2015 (UTC)

Proposed improved/alternative version of Sourcery[edit]


I like the intention sourcery tool, since adding reference statements on WD is very tedious to do by hand, and very difficult to automate. However, when trying to source from Wikipedia articles references, the signal to noise ratio is very low. IMHO, there is a much better source to work from : authority controls

Think of it as a mashup between Mix'n Match and the existing Sourcery : same principle as current tool, but presenting the page on the AC website according to the relevant property on the item, and sourcing to that AC.

Not all AC would be adapted for that, but some are very good. For instance, the BNF can have gender, nationality, profession, date/location of birth & death. It takes me a few mn to add by hand on a complete item, to be replaced by a few clicks.

What do you think? Feasible?

(and thanks again for all the tools)

--LBE (talk) 18:29, 11 June 2015 (UTC)

Sounds good. For items that have e.g. BNF ID but no source for gender, sources could even be added by a bot if matching Wikidata. Traveling now, will have a look later. --Magnus Manske (talk) 10:26, 12 June 2015 (UTC)
Symbol strong support vote.svg Strong support - BNF is a very good source for gender, work language, nationality, date/location of birth and death, and also, pseudonyms/birth names. Sometimes, also for family members and profession. :) --Hsarrazin (talk) 20:26, 29 June 2015 (UTC)

Sort by ID?[edit]


On updates, Listeria sorts items as specified. If there is no difference between two items, their order of listing can vary between updates, making diff impossible to read. Could the list be sorted by item ID (ideally numerically) as 2nd criterion? BTW, an option to sort DESC would nice to have. --- Jura 08:45, 12 June 2015 (UTC)

Listeria feature request: option to add a column containing links to Wikimedia projects[edit]

Hi Magnus, thanks for implementing Listeria, it is extremely useful. It occurred to me that Listeria-generated lists would also be extremely handy for article checklists at edit-a-thons, courses, writing challenges, etc. Would it be possible to add an extra feature: the option to include a column with all (existing) links to Wikimedia projects for the item in that row? E.g. for Belgenmonument (Q2560709) that would be fr, nl, commons. Thank you, Spinster (talk) 13:17, 12 June 2015 (UTC)

How about: {{#property:nlwiki|from=Q2560709}}. --- Jura 14:15, 12 June 2015 (UTC)
Hi Jura, I'm not sure I understand what you mean. That inclusion syntax does not function for me, and if it would: how can I integrate it in a Listeria list? To (hopefully) make my request a bit clearer with an example: one Listeria list I maintain is this one (recent deaths in Belgium and the Netherlands). I would like to be able to include a column where, for every item in the list, you see in which Wikimedia projects there is an article or a page. Magnus has included these in Autolist1 results, see an example here (the Wikipedia(s) column next to search results). That's very useful to have. Thanks! Spinster (talk) 07:44, 13 June 2015 (UTC)

Removing claims with QuickStatements?[edit]

Hi, I have externally generated a list of about 3.000 items with unwanted GND Numbers in GND identifier (P227) (formally valid and existing, but of type "undifferentiated": the kind records your gadget authority_control.js filters out in advance). However I don't know (and am too lazy to find out) whether the one with the unwanted number is the only value of P227 in the respective items. Example:

< Suzanne Zélie Pauline Veil (Q18335909) (View with Reasonator) > GND identifier (P227) miga < "183159233" >

should be removed.

So with AutoList2 I could provide a huge list of specific removal instruction

 -P227 <TAB> "183159233"

to operate on the result (quite ineffectively 9.000.000 removal attempts yielding 3.000 actual removes) and with QuickStatements I could only create additional claims for the items or amend specific claims with some qualifier or reference (here I'm thinking in the lines of tagging the claims with a temporary "removeme" token with QuickStatements in order to enable another tool to perform the actual removal).

Now I can think of several possibilities but none of them seems to be implemented:

  1. The AutoList2 "action" syntax does not allow to specify "act on the Property instance with a placeholder value under a certain constraint"
  2. The AutoList2 "action" syntax does not have a "meta" pseudovalue to say "act on the property instance(s) responsible for the item included in the list" (this may be not appropriate in many cases when the list was constructed without WDQ component or the WDQ contained an "or" or is based on properties unrelated to the one which should be acted upon)
  3. QuickStatements does not offer a syntax for changing (implying a claim is never created) or removing (exactly specified) statements.

Removal of exactly known claims is probably one of the more trivial operations with the mw:Wikibase/API but for using that for bulk removal of claims I am probably obliged to register a bot of my own (or dump a pointer to my list at the BotRequest page so that an existing bot could pick it up). So, is there a tool in the WiDaR ecosystem to achieve what I want? -- Gymel (talk) 12:38, 14 June 2015 (UTC)

Right now, the only way I know is to use autolist2, add the items into the manual list, and then use "-P227" as action. That will remove all (I think) P227s from the items. It would also remove valid GNDs, though. Maybe remove them all, then re-add the "good" ones? --Magnus Manske (talk) 13:07, 14 June 2015 (UTC)
Not sure what -P227 will do in that case, (my guess is to remove the first one in the item). So I'll probably weed my list first by comparing it to the constraint report (or is there a counterpart to the Duplicate detection tool which can give a "live" list of items where the given property has more than one value?), letting autolist2 remove only these where a single value is guaranteed, and process the remainder by hand... -- Gymel (talk) 15:06, 14 June 2015 (UTC)

Tools down[edit]

After things getting slow yesterday, it seems that most are down now. --- Jura 07:07, 18 June 2015 (UTC)

There is a Labs outage atm. Sjoerd de Bruin (talk) 08:32, 18 June 2015 (UTC)

Listeria ideas[edit]

Hi Magnus, Listeria is great fun. I'm (ab)using to create reports similar to the constraint violation reports. Some suggested features I would love to have:

  • Option to accept empty lists (for when I'm done cleaning up)
  • Option to limit the number of output items (SQL LIMIT)
  • Option to sort descending (SQL ORDER BY <> DESC)

Multichill (talk) 18:53, 19 June 2015 (UTC)


Hi Magnus,

"Birth name" with (OBSOLETE) birth name (use P1477) (P513) is being used by Reasonator. It's now being replaced by birth name (P1477). Would you kindly include that as well?

BTW, maybe you want to extend the layout for P31:Q5 to fictional human (Q15632617). --- Jura 17:59, 20 June 2015 (UTC)

Asked for that like a half year ago. Seems like the data type requires a lot of work. Sjoerd de Bruin (talk) 21:16, 20 June 2015 (UTC)
In this specific case, it could be included as the current string value. --- Jura 21:56, 21 June 2015 (UTC)

Had some RL issues, winding down now. Will look into both issues soon-ish. --Magnus Manske (talk) 12:29, 23 June 2015 (UTC)

Would be great! I've added some others to BitBucket. Sjoerd de Bruin (talk) 09:51, 24 June 2015 (UTC)
Did some work. --Magnus Manske (talk) 19:04, 24 June 2015 (UTC)
Nice. Thanks.
How can we make Google+ and reddit to link as well?
There is a problem with youtube: some addresses are<name> others are<name> or even just . I added the url as "reference URL". --- Jura 07:50, 29 June 2015 (UTC)
The social networks are different, as they are used as qualifiers and do not seem to have a URL schema. I'll have to add them manually to the code right now. --Magnus Manske (talk) 08:28, 29 June 2015 (UTC)
Do you think it would make sense to have separate properties (at least for the more common ones)? It would let us add constraints and URL patterns and would make them easier to enter (since you would only need to search for one property, not two properties and an item) and they're all separate sites with separate APIs so it doesn't really make sense to me to treat them as a single thing anyway. (@Hoo man: You mentioned wanting to split these on IRC, IIRC) - Nikki (talk) 09:09, 29 June 2015 (UTC)
I didn't yet find the time (and probably wont anytime soon), to start that large discussion… but I definitely think that we should split P553 rather sooner than later. Working with that is just awful. - Hoo man (talk) 01:32, 30 June 2015 (UTC)
Just adding the URLs directly as qualifier would probably be easier, but do we really want to encourage this type of content? --- Jura 09:54, 30 June 2015 (UTC)
I don't see why we would want to discourage it. It's factual data, sources can be found which say that it's the item's account. It's relevant data, millions of people use social networks. It's useful to other Wikimedia projects, e.g. to support templates like Template:Twitter (Q6741634) and Template:Facebook (Q5624646). It's useful to other users of the data, most of these sites have APIs.
I don't think adding the URLs themselves is a good solution. As I've said, these sites usually have APIs. Just like Magnus had to manually add URL formatting because we don't currently provide it, storing the URLs produces the opposite problem, people who need just the ID or username to query an API will have to manually extract it from the URL each time. It's best to store the data in a structured form. It also makes it much easier to maintain when sites change their URLs. - Nikki (talk) 11:40, 30 June 2015 (UTC)
I don't see how that solves the current youtube issue. Not sure if the current approach works for linkedin either. --- Jura 11:57, 30 June 2015 (UTC)
If the current situation doesn't work for some sites, isn't that just another reason to split this property? :) - Nikki (talk) 12:48, 30 June 2015 (UTC)

How to import lists into mix'n'match?[edit]

Hi Magnus, recently the property Encyclopaedia Metallum band id (P1952) has been created and I would like to prepare a list for mix'n'match. How can I import it into the tool? I read the manual but it doesn't say how to import new data. Do I have to send you an csv file or an excel table? --Micru (talk) 11:13, 23 June 2015 (UTC)

@Micru: I can't help with Mix'n'match, but on a related note, MusicBrainz has 1841 artists with a Wikidata link and a link to a band page. I can make a list of ID pairs if it would be of any use to you (I've been considering making a bot to import various identifiers like that, but haven't got round to it yet...). - Nikki (talk) 12:00, 23 June 2015 (UTC)
Hi Micru, yes, a simple file (ideally, tab-delimited, with ID, name, description, URL) would be good. Or just a pointer to a list online, if there is one; I have code to scrape and parse index pages. --Magnus Manske (talk) 12:27, 23 June 2015 (UTC)

List updates[edit]

Hi Magnus,

Would you re-activate the daily updates? It avoids having to trigger them. --- Jura 05:30, 25 June 2015 (UTC)

Ah, they should have been reactivated automatically after the Labs crash. Trying to kick it manually. --Magnus Manske (talk) 08:22, 25 June 2015 (UTC)
Thanks. I had read that too, but they might have figured that it might not be that great an idea. --- Jura 08:49, 25 June 2015 (UTC)


I agree with Multichill, above. Love this bot. I also have two extra things I would like to be able to do with the lists:

  • Possibility to number the rows of the list.
  • Possibility tot sort names in a column to last name instead of first name

See for example this list, where I would like to have a list sorted by last name and numbered, so that I can see the number of Filipino senators in the blink of an eye, instead of having tot count the numbers of rows myself. Hope you can help out. Magalhães (talk) 06:00, 28 June 2015 (UTC)

QuickStatements : quantity[edit]

Hi Magnus,

I tried to add quantities with the following formats:

Adele Arakawa   P1971   +1,     S143    Q328
Anna Kinberg Batra      P1971   1       S143    Q328

Both work fine except that the "S143 Q328" part gets skipped. --- Jura 07:50, 28 June 2015 (UTC)

This was also reported by someone on Bitbucket [5]. It looks like a similar problem to the one in #URL in QuickStatements above, except here it seems to be because that part of the code doesn't know how to compare quantities. - Nikki (talk) 15:48, 28 June 2015 (UTC)

P1959 for mix-n-match[edit]

Could Dutch Senate person ID (P1959) be added to mix-n-match? The persons are listed here, 50 per page. Thanks! Sjoerd de Bruin (talk) 09:04, 28 June 2015 (UTC)

On it, but it stops at 500 entries (last page I get). --Magnus Manske (talk) 11:18, 28 June 2015 (UTC)
Yikes. Adding a letter in the search box seems to help. Am I asking you too much to do that 26± times? :) Sjoerd de Bruin (talk) 12:10, 28 June 2015 (UTC)
I got 1126 entries. How many should there be? --Magnus Manske (talk) 13:18, 28 June 2015 (UTC)
Some easy calculating based on en:Historic composition of the Senate of the Netherlands gives me 2175 seats had been occupied until now. Some people seated more than one period, so I think we've got most of the people. Sjoerd de Bruin (talk) 13:26, 28 June 2015 (UTC)
They don't auto-match very well, but there you go... --Magnus Manske (talk) 13:33, 28 June 2015 (UTC)


Probably it's time to request an approval for this bot.--GZWDer (talk) 16:55, 30 June 2015 (UTC)

WDQ lag[edit]

Anything you could do to combat the 6 hour lag in WDQ? Sjoerd de Bruin (talk) 17:25, 30 June 2015 (UTC)

Restarted, slowly catching up. --Magnus Manske (talk) 15:06, 1 July 2015 (UTC)