Dear Wikidata Community,
Following user feedback [0], I have made working with Wikidata data from within a Google Sheets context a lot easier by creating a special #WikidataBirthday release of the Wikipedia and Wikidata Tools for Google Spreadsheets add-on [1]. See a concrete example in [2].
Happy birthday, Wikidata 🎉! Humbled by all the work the Wikidata team are doing; thank you all!
Cheers, Tom
-- [0] https://github.com/tomayac/wikipedia-tools-for-google-spreadsheets/issues/12 [1] https://chrome.google.com/webstore/detail/wikipedia-and-wikidata-to/aiilcelh... [2] https://docs.google.com/spreadsheets/d/1QuUVFl6x3c1Yj3J7jd_OTHYD2haVFVtebIw2...
Thank you Thomas, this is such a cool feature!
On 29 October 2016 at 16:01, Thomas Steiner tomac@google.com wrote:
Dear Wikidata Community,
Following user feedback [0], I have made working with Wikidata data from within a Google Sheets context a lot easier by creating a special #WikidataBirthday release of the Wikipedia and Wikidata Tools for Google Spreadsheets add-on [1]. See a concrete example in [2].
Happy birthday, Wikidata 🎉! Humbled by all the work the Wikidata team are doing; thank you all!
Cheers, Tom
-- [0] https://github.com/tomayac/wikipedia-tools-for-google- spreadsheets/issues/12 [1] https://chrome.google.com/webstore/detail/wikipedia-and-wikidata-to/ aiilcelhmpllcgkhhpifagfehbddkdfp [2] https://docs.google.com/spreadsheets/d/1QuUVFl6x3c1Yj3J7jd_ OTHYD2haVFVtebIw2It4KNoA/edit?usp=sharing
-- Dr. Thomas Steiner, Employee (http://blog.tomayac.com, https://twitter.com/tomayac)
Google Germany GmbH, ABC-Str. 19, 20354 Hamburg, Germany Managing Directors: Matthew Scott Sucherman, Paul Terence Manicle Registration office and registration number: Hamburg, HRB 86891
-----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.29 (GNU/Linux)
iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DChara CTersAttH3b0ttom hTtPs://xKcd.cOm/1181/ -----END PGP SIGNATURE-----
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Very excited to try this for large scale authority research on artists (retrieving dates of birth & death, ULAN IDs, etc. from Wikidata)! Thanks in advance!
*David Lowe | The New York Public Library**Specialist II, Photography Collection*
*Photographers' Identities Catalog http://pic.nypl.org*
On Sat, Oct 29, 2016 at 10:12 AM, Léa Lacroix lea.lacroix@wikimedia.de wrote:
Thank you Thomas, this is such a cool feature!
On 29 October 2016 at 16:01, Thomas Steiner tomac@google.com wrote:
Dear Wikidata Community,
Following user feedback [0], I have made working with Wikidata data from within a Google Sheets context a lot easier by creating a special #WikidataBirthday release of the Wikipedia and Wikidata Tools for Google Spreadsheets add-on [1]. See a concrete example in [2].
Happy birthday, Wikidata 🎉! Humbled by all the work the Wikidata team are doing; thank you all!
Cheers, Tom
-- [0] https://github.com/tomayac/wikipedia-tools-for-google-spread sheets/issues/12 [1] https://chrome.google.com/webstore/detail/wikipedia-and-wiki data-to/aiilcelhmpllcgkhhpifagfehbddkdfp [2] https://docs.google.com/spreadsheets/d/1QuUVFl6x3c1Yj3J7jd_O THYD2haVFVtebIw2It4KNoA/edit?usp=sharing
-- Dr. Thomas Steiner, Employee (http://blog.tomayac.com, https://twitter.com/tomayac)
Google Germany GmbH, ABC-Str. 19, 20354 Hamburg, Germany Managing Directors: Matthew Scott Sucherman, Paul Terence Manicle Registration office and registration number: Hamburg, HRB 86891
-----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.29 (GNU/Linux)
iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DChara CTersAttH3b0ttom hTtPs://xKcd.cOm/1181/ -----END PGP SIGNATURE-----
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
-- Léa Lacroix Community Communication Manager for Wikidata
Wikimedia Deutschland e.V. Tempelhofer Ufer 23-24 10963 Berlin www.wikimedia.de
Wikimedia Deutschland - Gesellschaft zur Förderung Freien Wissens e. V.
Eingetragen im Vereinsregister des Amtsgerichts Berlin-Charlottenburg unter der Nummer 23855 Nz. Als gemeinnützig anerkannt durch das Finanzamt für Körperschaften I Berlin, Steuernummer 27/029/42207.
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
I'm really liking these tools. I'm using the WIKIDATAQID search & finding lots. However, spot-checking some names found no hits, I find that they do indeed have exact matches in Wikidata. Nothing I can do to trigger a match (an example: Josep Serra i Abella). Any thoughts?
*David Lowe | The New York Public Library**Specialist II, Photography Collection*
*Photographers' Identities Catalog http://pic.nypl.org*
On Sat, Oct 29, 2016 at 11:42 AM, David Lowe davidlowe@nypl.org wrote:
Very excited to try this for large scale authority research on artists (retrieving dates of birth & death, ULAN IDs, etc. from Wikidata)! Thanks in advance!
*David Lowe | The New York Public Library**Specialist II, Photography Collection*
*Photographers' Identities Catalog http://pic.nypl.org*
On Sat, Oct 29, 2016 at 10:12 AM, Léa Lacroix lea.lacroix@wikimedia.de wrote:
Thank you Thomas, this is such a cool feature!
On 29 October 2016 at 16:01, Thomas Steiner tomac@google.com wrote:
Dear Wikidata Community,
Following user feedback [0], I have made working with Wikidata data from within a Google Sheets context a lot easier by creating a special #WikidataBirthday release of the Wikipedia and Wikidata Tools for Google Spreadsheets add-on [1]. See a concrete example in [2].
Happy birthday, Wikidata 🎉! Humbled by all the work the Wikidata team are doing; thank you all!
Cheers, Tom
-- [0] https://github.com/tomayac/wikipedia-tools-for-google-spread sheets/issues/12 [1] https://chrome.google.com/webstore/detail/wikipedia-and-wiki data-to/aiilcelhmpllcgkhhpifagfehbddkdfp [2] https://docs.google.com/spreadsheets/d/1QuUVFl6x3c1Yj3J7jd_O THYD2haVFVtebIw2It4KNoA/edit?usp=sharing
-- Dr. Thomas Steiner, Employee (http://blog.tomayac.com, https://twitter.com/tomayac)
Google Germany GmbH, ABC-Str. 19, 20354 Hamburg, Germany Managing Directors: Matthew Scott Sucherman, Paul Terence Manicle Registration office and registration number: Hamburg, HRB 86891
-----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.29 (GNU/Linux)
iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DChara CTersAttH3b0ttom hTtPs://xKcd.cOm/1181/ -----END PGP SIGNATURE-----
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
-- Léa Lacroix Community Communication Manager for Wikidata
Wikimedia Deutschland e.V. Tempelhofer Ufer 23-24 10963 Berlin www.wikimedia.de
Wikimedia Deutschland - Gesellschaft zur Förderung Freien Wissens e. V.
Eingetragen im Vereinsregister des Amtsgerichts Berlin-Charlottenburg unter der Nummer 23855 Nz. Als gemeinnützig anerkannt durch das Finanzamt für Körperschaften I Berlin, Steuernummer 27/029/42207.
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Hi David,
Mind sharing (privately if necessary) your spreadsheet? My recommended workflow would be to pair free-form terms (like your names) with the WIKISEARCH function and only then feed its output into WIKIDATAQID (or rather directly WIKIDATAFACTS, as it accepts qids or article titles directly). If this doesn't help, again the offer to share your spreadsheet so I can have a direct look.
Cheers, Tom
Tom, thanks! Just shared. You may want to unhide columns. I'm trying to make it user friendly for non-tech savvy library volunteers who will be looking at folders of ephemera (exhibition announcements, magazine clippings, etc.) & determining whether it's the same person as the wiki data record. D
On Monday, October 31, 2016, Thomas Steiner tomac@google.com wrote:
Hi David,
Mind sharing (privately if necessary) your spreadsheet? My recommended workflow would be to pair free-form terms (like your names) with the WIKISEARCH function and only then feed its output into WIKIDATAQID (or rather directly WIKIDATAFACTS, as it accepts qids or article titles directly). If this doesn't help, again the offer to share your spreadsheet so I can have a direct look.
Cheers, Tom
-- Dr. Thomas Steiner, Employee (http://blog.tomayac.com, https://twitter.com/tomayac)
Google Germany GmbH, ABC-Str. 19, 20354 Hamburg, Germany Managing Directors: Matthew Scott Sucherman, Paul Terence Manicle Registration office and registration number: Hamburg, HRB 86891
-----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.29 (GNU/Linux)
iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DChara CTersAttH3b0ttom hTtPs://xKcd.cOm/1181/ -----END PGP SIGNATURE-----
Also, from wikidatafacts is it possible to bring back en:description or Wikipedia links? I made only very cursory attempts at this.
On Monday, October 31, 2016, David Lowe davidlowe@nypl.org wrote:
Tom, thanks! Just shared. You may want to unhide columns. I'm trying to make it user friendly for non-tech savvy library volunteers who will be looking at folders of ephemera (exhibition announcements, magazine clippings, etc.) & determining whether it's the same person as the wiki data record. D
On Monday, October 31, 2016, Thomas Steiner <tomac@google.com javascript:_e(%7B%7D,'cvml','tomac@google.com');> wrote:
Hi David,
Mind sharing (privately if necessary) your spreadsheet? My recommended workflow would be to pair free-form terms (like your names) with the WIKISEARCH function and only then feed its output into WIKIDATAQID (or rather directly WIKIDATAFACTS, as it accepts qids or article titles directly). If this doesn't help, again the offer to share your spreadsheet so I can have a direct look.
Cheers, Tom
-- Dr. Thomas Steiner, Employee (http://blog.tomayac.com, https://twitter.com/tomayac)
Google Germany GmbH, ABC-Str. 19, 20354 Hamburg, Germany Managing Directors: Matthew Scott Sucherman, Paul Terence Manicle Registration office and registration number: Hamburg, HRB 86891
-----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.29 (GNU/Linux)
iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DChara CTersAttH3b0ttom hTtPs://xKcd.cOm/1181/ -----END PGP SIGNATURE-----
--
*David Lowe | The New York Public Library**Specialist II, Photography Collection*
*Photographers' Identities Catalog http://pic.nypl.org*
Hi David,
I made some additions to your document (red column headers). This shows the workflow to first search, then lookup the qid, and then the WIkidata fact "instance of". I will add the descriptions to a new function WIKIDATADESCRIPTIONS, let me work on that. It is easily possible via the API (https://www.wikidata.org/w/api.php?action=wbgetentities&ids=Q42&form...). Hope this helps!
Cheers, Tom
Thanks again, Tom. I find the WIKISEARCH a bit overly permissive for general use, but it did find some useful matches. These tools are very helpful!
d
*David Lowe | The New York Public Library**Specialist II, Photography Collection*
*Photographers' Identities Catalog http://pic.nypl.org*
On Tue, Nov 1, 2016 at 5:00 AM, Thomas Steiner tomac@google.com wrote:
Hi David,
I made some additions to your document (red column headers). This shows the workflow to first search, then lookup the qid, and then the WIkidata fact "instance of". I will add the descriptions to a new function WIKIDATADESCRIPTIONS, let me work on that. It is easily possible via the API (https://www.wikidata.org/w/api.php?action=wbgetentities& ids=Q42&format=json&props=descriptions). Hope this helps!
Cheers, Tom
-- Dr. Thomas Steiner, Employee (http://blog.tomayac.com, https://twitter.com/tomayac)
Google Germany GmbH, ABC-Str. 19, 20354 Hamburg, Germany Managing Directors: Matthew Scott Sucherman, Paul Terence Manicle Registration office and registration number: Hamburg, HRB 86891
-----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.29 (GNU/Linux)
iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DChara CTersAttH3b0ttom hTtPs://xKcd.cOm/1181/ -----END PGP SIGNATURE-----
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Hi again,
I find the WIKISEARCH a bit overly permissive for general use, but it did find some useful matches.
The underlying Wikipedia API request is to the best of my understanding essentially the same as a regular on-Wikipedia search. You might get better results by setting the optional second parameter "opt_didYouMean" to true like so: =WIKISEARCH("search term", TRUE). In some cases it then shows the most probable alternative result that you might have wanted to actually search for instead. Give it a spin. Also, together with the pipeline I have set up for you in the sheet, you can filter on type, so when you know you are looking for "instance of: human", you can exclude anything non-human. Hope this helps!
Cheers, Tom
Yes, I'll keep playing with it, it's already saved me dozens of hours of work, thanks. Now, just 25 letters of the alphabet to go!
*David Lowe | The New York Public Library**Specialist II, Photography Collection*
*Photographers' Identities Catalog http://pic.nypl.org*
On Tue, Nov 1, 2016 at 11:40 AM, Thomas Steiner tomac@google.com wrote:
Hi again,
I find the WIKISEARCH a bit overly permissive for general use, but it did find some useful matches.
The underlying Wikipedia API request is to the best of my understanding essentially the same as a regular on-Wikipedia search. You might get better results by setting the optional second parameter "opt_didYouMean" to true like so: =WIKISEARCH("search term", TRUE). In some cases it then shows the most probable alternative result that you might have wanted to actually search for instead. Give it a spin. Also, together with the pipeline I have set up for you in the sheet, you can filter on type, so when you know you are looking for "instance of: human", you can exclude anything non-human. Hope this helps!
Cheers, Tom
-- Dr. Thomas Steiner, Employee (http://blog.tomayac.com, https://twitter.com/tomayac)
Google Germany GmbH, ABC-Str. 19, 20354 Hamburg, Germany Managing Directors: Matthew Scott Sucherman, Paul Terence Manicle Registration office and registration number: Hamburg, HRB 86891
-----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.29 (GNU/Linux)
iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DChara CTersAttH3b0ttom hTtPs://xKcd.cOm/1181/ -----END PGP SIGNATURE-----
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata