Topic on User talk:Wesalius

Jump to navigation Jump to search
Steak (talkcontribs)

Could you import with your bot the years when the titles (first e.g. the grandmaster title) were approved? A good source could be the german list "Liste der Schachgroßmeister" (linking does not work) where all title years have been added and checked by different sources. Not a good source is definitely the FIDE database. Many years are missing or wrong.

Wesalius (talkcontribs)

Yes, it is possible. The dates at are meant to be date qualifiers for the title values at the player items? Or what property do you think should be used?

The easiest for me would be if you would give me a list of player items with the date values so I can pass it into quickstatements.

Wesalius (talkcontribs)

Or I can actually make quickstatements figure out the items from the de.wiki articles, so no need to get the list. Just figure out what should be the appropriate structure to store it (date qualifier for title values at the player items, or something else?)

Steak (talkcontribs)

I was thinking of adding Property:P580 as a qualifier to the grandmaster statement, like here: One could also use Property:P585, but I think P580 is more appropriate because from there on the player is grandmaster (and there is the potential that the title gets revoked, so we would need Property:P582 additionally.

Wesalius (talkcontribs)

Ok. Would you please help me finish preparatory list at Benutzer:Wesalius/List?

Steak (talkcontribs)

How shall this list look like? The names as written there and the form "<Given Name> <Family Name>,<Year>", or the english transkriptions (which would be quite a workload). I think for a large part of the names the german wikidata label could be used to link the names to the Items.

Wesalius (talkcontribs)

Most of them are already done. They should like like "name of de.wiki article","year" pairs.

Wesalius (talkcontribs)

Will you work more on the list or not?

Steak (talkcontribs)

What needs to be done? The links are all correctly formatted I think. There are some years not matched to a link, what about them?

Wesalius (talkcontribs)

Those abandoned years just need the appropriate player. If you dont match them (can be found when checking the player above or below) then I will just skip them no problem.

Steak (talkcontribs)

Maybe I have time to work on the list during the weekend. You can start importing on monday. :)

Wesalius (talkcontribs)

Ok, its your request, so when you say we ready then we ready ;-)

Steak (talkcontribs)

Could you briefly sketch how you plan to match the list entries with the wikidata items? I just want to be sure that your bot will work fine.

There are at the moment 1682 items with the title grandmaster, but the correct number would be 1678, so this year import provides also the possibility to correct the statements (effectively, four are wrong, but from experience, I think there are more than four added wrongly and somewhere else the statement is missing). Your bot will hence have a residual list where he could not add any year. I would need this list also to clear up the rest.

Wesalius (talkcontribs)

For players that have their article written, I dont have to match anything, its pretty error proof. Go to http://tools.wmflabs.org/wikidata-todo/quick_statements.php and try yourself. Put dewiki and then follow this example for any player that has article on dewiki:

"Jacob Aagaard,2007" -> "Jacob Aagaard    P2962    Q105269    P580    +2007-01-01T00:00:00Z/09    S143    Q48183"

Steak (talkcontribs)
Wesalius (talkcontribs)

Has to work, just put the "Jacob Aagaard    P2962    Q105269    P580    +2007-01-01T00:00:00Z/09    S143    Q48183" in Calc/Excel columns like

Jacob Aagaard P2962 Q105269 P580 +2007-01-01T00:00:00Z/09 S143 Q48183

then copypaste from there to quickstatements. Dont forget to put dewiki into the little window above

Steak (talkcontribs)

Ok, worked, the tabstops were the problem.

Wesalius (talkcontribs)
Steak (talkcontribs)

What about looking for the date of birth? This would narrow it down to maybe three possible items for each list entry, and the correct one could then choosen by hand.

Wesalius (talkcontribs)

Probably the easiest is to create a query that looks up item that:

  • matches the label
  • matches the birthday
  • has P2962:Q105269

and then to recycle such a query with different labels.

Steak (talkcontribs)

Would it be possible if I run the quickstatements first for the articles that exist, and then you run the query which compares the birthdays for the rest?

Wesalius (talkcontribs)

How about you do both (since you know how)? Or you want to do just the no-work part?

Steak (talkcontribs)

I dont know how to run this query and then match the list entries to the results. I am already cleaning up the statements for the future year adding, this is also work :)

Wesalius (talkcontribs)

It is work that you came up with ;-) Go ahead with the quickstatements ;-) I will look into the queries later...

Steak (talkcontribs)

Why is it in you example above "2007-01-01"? We only know the year, so stating it at day precision would be wrong.

Wesalius (talkcontribs)
Steak (talkcontribs)

Yes, the precision is year, but internally, it is saved 2007-01-01. I think it would be more appropriate to add the data as "2007-00-00", to avoid any possible confusion.

Wesalius (talkcontribs)

You are the one who is going to add the data, so do it that way if you think it is better.

Steak (talkcontribs)

The quickstatements-list has run through. Now you can go on with the query. If you want me to help, please ask. :)