Hi all,
We've been using WDQ queries a lot recently to update timelines in the Histropedia directory and, while trying to speed up the process, I ended up creating a very crude query generator tool over the weekend. After getting a bit carried away with it, it seemed worth sharing as it could actually be a handy tool for Wikidata editors, or anyone else interested in experimenting with queries.
I have no real coding experience, so it's just made in a humble spreadsheet! You can choose the input values for a query and the links to Histropedia, AutoList and WDQ will update automatically.The idea is obviously that this sort of tool should be written in Javascript by someone who actually knows what they're doing ;) but they do work and can easily be customised by adding more Wikidata items to the available options.
I've made 3 different types of query generator so far, which I'll publish shortly as free templates on Google Sheets:
1) Date range query generator https://docs.google.com/spreadsheets/d/1A8wyqVc5USJ_T8ncFfYIsmJzfy8LIdmH2QLgeyegRAM/edit?usp=sharing
2) People finder query generator https://docs.google.com/spreadsheets/d/16-x7NGyHTAtEJBa5uF9ZYBhNj6BhhCJrtDaKCcJIFuE/edit?usp=sharing
3) Family tree query generator https://docs.google.com/spreadsheets/d/1dNTBoi-QbI0t-t0Ba4Ex5-sx7Q03qRecE27bapQGpAw/edit?usp=sharing
They are publicly editable spreadsheets so feel free to make a copy if someone is using the one you land on. And certainly don't hold back if anyone wishes to make any improvements.
I hope someone finds it useful/fun to mess around with these, but I thought it was a nice story to share in itself - that a non-coder can sit down and create something genuinely useful by tapping into the power of Wikidata, and of course Magnus' amazing tools! :)
Cheers,
Navino
Awesome work :-). I love your use of Google Docs as a UI prototyping tool. We could really use a few more special-purpose querying tools.
Markus
On 09.03.2015 22:03, Navino Evans wrote:
Hi all,
We've been using WDQ queries a lot recently to update timelines in the Histropedia directory and, while trying to speed up the process, I ended up creating a very crude query generator tool over the weekend. After getting a bit carried away with it, it seemed worth sharing as it could actually be a handy tool for Wikidata editors, or anyone else interested in experimenting with queries.
I have no real coding experience, so it's just made in a humble spreadsheet! You can choose the input values for a query and the links to Histropedia, AutoList and WDQ will update automatically.The idea is obviously that this sort of tool should be written in Javascript by someone who actually knows what they're doing ;) but they do work and can easily be customised by adding more Wikidata items to the available options.
I've made 3 different types of query generator so far, which I'll publish shortly as free templates on Google Sheets:
- Date range query generator
https://docs.google.com/spreadsheets/d/1A8wyqVc5USJ_T8ncFfYIsmJzfy8LIdmH2QLgeyegRAM/edit?usp=sharing
- People finder query generator
https://docs.google.com/spreadsheets/d/16-x7NGyHTAtEJBa5uF9ZYBhNj6BhhCJrtDaKCcJIFuE/edit?usp=sharing
- Family tree query generator
https://docs.google.com/spreadsheets/d/1dNTBoi-QbI0t-t0Ba4Ex5-sx7Q03qRecE27bapQGpAw/edit?usp=sharing
They are publicly editable spreadsheets so feel free to make a copy if someone is using the one you land on. And certainly don't hold back if anyone wishes to make any improvements.
I hope someone finds it useful/fun to mess around with these, but I thought it was a nice story to share in itself - that a non-coder can sit down and create something genuinely useful by tapping into the power of Wikidata, and of course Magnus' amazing tools! :)
Cheers,
Navino
-- ___________________________
Histropedia
The Timeline for all of History www.histropedia.com http://www.histropedia.com/
Follow us on: Twitter https://twitter.com/Histropedia Facebo https://www.facebook.com/Histropediaok https://www.facebook.com/Histropedia Google + https://plus.google.com/u/0/b/104484373317792180682/104484373317792180682/posts L http://www.linkedin.com/company/histropedia-ltdinke http://www.linkedin.com/company/histropedia-ltddIn http://www.linkedin.com/company/histropedia-ltd
Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Many thanks Markus :-)
The plan for us now is to get our developer to start making some of these 'query modules', and publish them as open source. They would be use-able as a stand-alone tool, but more importantly be embeddable and easily customisable in layout etc so that third parties could use them easily. The hope going forward would be that we could eventually create an open source, searchable library of such query modules, each one specialised enough that they can be very easily understood by a human putting in the data.
Navino
On 9 March 2015 at 21:32, Markus Krötzsch markus@semantic-mediawiki.org wrote:
Awesome work :-). I love your use of Google Docs as a UI prototyping tool. We could really use a few more special-purpose querying tools.
Markus
On 09.03.2015 22:03, Navino Evans wrote:
Hi all,
We've been using WDQ queries a lot recently to update timelines in the Histropedia directory and, while trying to speed up the process, I ended up creating a very crude query generator tool over the weekend. After getting a bit carried away with it, it seemed worth sharing as it could actually be a handy tool for Wikidata editors, or anyone else interested in experimenting with queries.
I have no real coding experience, so it's just made in a humble spreadsheet! You can choose the input values for a query and the links to Histropedia, AutoList and WDQ will update automatically.The idea is obviously that this sort of tool should be written in Javascript by someone who actually knows what they're doing ;) but they do work and can easily be customised by adding more Wikidata items to the available options.
I've made 3 different types of query generator so far, which I'll publish shortly as free templates on Google Sheets:
- Date range query generator
- People finder query generator
- Family tree query generator
They are publicly editable spreadsheets so feel free to make a copy if someone is using the one you land on. And certainly don't hold back if anyone wishes to make any improvements.
I hope someone finds it useful/fun to mess around with these, but I thought it was a nice story to share in itself - that a non-coder can sit down and create something genuinely useful by tapping into the power of Wikidata, and of course Magnus' amazing tools! :)
Cheers,
Navino
-- ___________________________
Histropedia
The Timeline for all of History www.histropedia.com http://www.histropedia.com/
Follow us on: Twitter https://twitter.com/Histropedia Facebo https://www.facebook.com/Histropediaok https://www.facebook.com/Histropedia Google + https://plus.google.com/u/0/b/104484373317792180682/ 104484373317792180682/posts L http://www.linkedin.com/company/histropedia-ltdinke http://www.linkedin.com/company/histropedia-ltddIn http://www.linkedin.com/company/histropedia-ltd
Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Great work, Navino!
I agree, using google docs for the prototype is a really good way of getting something started
all the best
Fabian Tompsett, Volunteer Support Organiser, Wikimedia UK, Address: 56-64 Leonard St, Shoreditch, London EC2A 4LT Phone:020 7065 0990 *Mobile: *07840 455 746
Wikimedia UK is a Company Limited by Guarantee registered in England and Wales, Registered No. 6741827. Registered Charity No.1144513. Registered Office 4th Floor, Development House, 56-64 Leonard Street, London EC2A 4LT. United Kingdom. Wikimedia UK is the UK chapter of a global Wikimedia movement. The Wikimedia projects are run by the Wikimedia Foundation (who operate Wikipedia, amongst other projects).
Visit http://www.wikimedia.org.uk/ and @wikimediauk
On 9 March 2015 at 21:42, Navino Evans navino@histropedia.com wrote:
Many thanks Markus :-)
The plan for us now is to get our developer to start making some of these 'query modules', and publish them as open source. They would be use-able as a stand-alone tool, but more importantly be embeddable and easily customisable in layout etc so that third parties could use them easily. The hope going forward would be that we could eventually create an open source, searchable library of such query modules, each one specialised enough that they can be very easily understood by a human putting in the data.
Navino
On 9 March 2015 at 21:32, Markus Krötzsch markus@semantic-mediawiki.org wrote:
Awesome work :-). I love your use of Google Docs as a UI prototyping tool. We could really use a few more special-purpose querying tools.
Markus
On 09.03.2015 22:03, Navino Evans wrote:
Hi all,
We've been using WDQ queries a lot recently to update timelines in the Histropedia directory and, while trying to speed up the process, I ended up creating a very crude query generator tool over the weekend. After getting a bit carried away with it, it seemed worth sharing as it could actually be a handy tool for Wikidata editors, or anyone else interested in experimenting with queries.
I have no real coding experience, so it's just made in a humble spreadsheet! You can choose the input values for a query and the links to Histropedia, AutoList and WDQ will update automatically.The idea is obviously that this sort of tool should be written in Javascript by someone who actually knows what they're doing ;) but they do work and can easily be customised by adding more Wikidata items to the available options.
I've made 3 different types of query generator so far, which I'll publish shortly as free templates on Google Sheets:
- Date range query generator
- People finder query generator
- Family tree query generator
They are publicly editable spreadsheets so feel free to make a copy if someone is using the one you land on. And certainly don't hold back if anyone wishes to make any improvements.
I hope someone finds it useful/fun to mess around with these, but I thought it was a nice story to share in itself - that a non-coder can sit down and create something genuinely useful by tapping into the power of Wikidata, and of course Magnus' amazing tools! :)
Cheers,
Navino
-- ___________________________
Histropedia
The Timeline for all of History www.histropedia.com http://www.histropedia.com/
Follow us on: Twitter https://twitter.com/Histropedia Facebo https://www.facebook.com/Histropediaok https://www.facebook.com/Histropedia Google + https://plus.google.com/u/0/b/104484373317792180682/ 104484373317792180682/posts L http://www.linkedin.com/company/histropedia-ltdinke http://www.linkedin.com/company/histropedia-ltddIn http://www.linkedin.com/company/histropedia-ltd
Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
-- ___________________________
Histropedia
The Timeline for all of History www.histropedia.com
Follow us on: Twitter https://twitter.com/Histropedia Facebo https://www.facebook.com/Histropediaok https://www.facebook.com/Histropedia Google + https://plus.google.com/u/0/b/104484373317792180682/104484373317792180682/posts L http://www.linkedin.com/company/histropedia-ltdinke http://www.linkedin.com/company/histropedia-ltddIn http://www.linkedin.com/company/histropedia-ltd
Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Nice! One could even display the results in the spreadsheet, using this: http://blog.fastfedora.com/projects/import-json (haven't tried, though)
Note that there is a "proper" Wikidata graph database being developed by WMF. Once that reaches production, WDQ will likely become a wrapper around that database (for backwards compatibility). SPARQL (shudder) seems to be the future...
On Tue, Mar 10, 2015 at 9:14 AM Fabian Tompsett < fabian.tompsett@wikimedia.org.uk> wrote:
Great work, Navino!
I agree, using google docs for the prototype is a really good way of getting something started
all the best
Fabian Tompsett, Volunteer Support Organiser, Wikimedia UK, Address: 56-64 Leonard St, Shoreditch, London EC2A 4LT Phone:020 7065 0990 *Mobile: *07840 455 746
Wikimedia UK is a Company Limited by Guarantee registered in England and Wales, Registered No. 6741827. Registered Charity No.1144513. Registered Office 4th Floor, Development House, 56-64 Leonard Street, London EC2A 4LT. United Kingdom. Wikimedia UK is the UK chapter of a global Wikimedia movement. The Wikimedia projects are run by the Wikimedia Foundation (who operate Wikipedia, amongst other projects).
Visit http://www.wikimedia.org.uk/ and @wikimediauk
On 9 March 2015 at 21:42, Navino Evans navino@histropedia.com wrote:
Many thanks Markus :-)
The plan for us now is to get our developer to start making some of these 'query modules', and publish them as open source. They would be use-able as a stand-alone tool, but more importantly be embeddable and easily customisable in layout etc so that third parties could use them easily. The hope going forward would be that we could eventually create an open source, searchable library of such query modules, each one specialised enough that they can be very easily understood by a human putting in the data.
Navino
On 9 March 2015 at 21:32, Markus Krötzsch markus@semantic-mediawiki.org wrote:
Awesome work :-). I love your use of Google Docs as a UI prototyping tool. We could really use a few more special-purpose querying tools.
Markus
On 09.03.2015 22:03, Navino Evans wrote:
Hi all,
We've been using WDQ queries a lot recently to update timelines in the Histropedia directory and, while trying to speed up the process, I ended up creating a very crude query generator tool over the weekend. After getting a bit carried away with it, it seemed worth sharing as it could actually be a handy tool for Wikidata editors, or anyone else interested in experimenting with queries.
I have no real coding experience, so it's just made in a humble spreadsheet! You can choose the input values for a query and the links to Histropedia, AutoList and WDQ will update automatically.The idea is obviously that this sort of tool should be written in Javascript by someone who actually knows what they're doing ;) but they do work and can easily be customised by adding more Wikidata items to the available options.
I've made 3 different types of query generator so far, which I'll publish shortly as free templates on Google Sheets:
- Date range query generator
- People finder query generator
- Family tree query generator
They are publicly editable spreadsheets so feel free to make a copy if someone is using the one you land on. And certainly don't hold back if anyone wishes to make any improvements.
I hope someone finds it useful/fun to mess around with these, but I thought it was a nice story to share in itself - that a non-coder can sit down and create something genuinely useful by tapping into the power of Wikidata, and of course Magnus' amazing tools! :)
Cheers,
Navino
-- ___________________________
Histropedia
The Timeline for all of History www.histropedia.com http://www.histropedia.com/
Follow us on: Twitter https://twitter.com/Histropedia Facebo https://www.facebook.com/Histropediaok https://www.facebook.com/Histropedia Google + https://plus.google.com/u/0/b/104484373317792180682/ 104484373317792180682/posts L http://www.linkedin.com/company/histropedia-ltdinke http://www.linkedin.com/company/histropedia-ltddIn http://www.linkedin.com/company/histropedia-ltd
Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
-- ___________________________
Histropedia
The Timeline for all of History www.histropedia.com
Follow us on: Twitter https://twitter.com/Histropedia Facebo https://www.facebook.com/Histropediaok https://www.facebook.com/Histropedia Google + https://plus.google.com/u/0/b/104484373317792180682/104484373317792180682/posts L http://www.linkedin.com/company/histropedia-ltdinke http://www.linkedin.com/company/histropedia-ltddIn http://www.linkedin.com/company/histropedia-ltd
Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Cheers Fabian, Magnus!
Just had a quick look at the import-json function - looks pretty awesome :-) I probably won't be able to resist using it to make a mark-II mock up at some point.
Thanks for the heads up about the upcoming Wikidata graph database, I was aware that was in the pipeline. We'll probably crack on with trying to make a couple of these query builders properly anyway, and make modifications as required in the future (after learning some SPARQL by the sounds of it!).
On 10 March 2015 at 09:39, Magnus Manske magnusmanske@googlemail.com wrote:
Nice! One could even display the results in the spreadsheet, using this: http://blog.fastfedora.com/projects/import-json (haven't tried, though)
Note that there is a "proper" Wikidata graph database being developed by WMF. Once that reaches production, WDQ will likely become a wrapper around that database (for backwards compatibility). SPARQL (shudder) seems to be the future...
On Tue, Mar 10, 2015 at 9:14 AM Fabian Tompsett < fabian.tompsett@wikimedia.org.uk> wrote:
Great work, Navino!
I agree, using google docs for the prototype is a really good way of getting something started
all the best
Fabian Tompsett, Volunteer Support Organiser, Wikimedia UK, Address: 56-64 Leonard St, Shoreditch, London EC2A 4LT Phone:020 7065 0990 *Mobile: *07840 455 746
Wikimedia UK is a Company Limited by Guarantee registered in England and Wales, Registered No. 6741827. Registered Charity No.1144513. Registered Office 4th Floor, Development House, 56-64 Leonard Street, London EC2A 4LT. United Kingdom. Wikimedia UK is the UK chapter of a global Wikimedia movement. The Wikimedia projects are run by the Wikimedia Foundation (who operate Wikipedia, amongst other projects).
Visit http://www.wikimedia.org.uk/ and @wikimediauk
On 9 March 2015 at 21:42, Navino Evans navino@histropedia.com wrote:
Many thanks Markus :-)
The plan for us now is to get our developer to start making some of these 'query modules', and publish them as open source. They would be use-able as a stand-alone tool, but more importantly be embeddable and easily customisable in layout etc so that third parties could use them easily. The hope going forward would be that we could eventually create an open source, searchable library of such query modules, each one specialised enough that they can be very easily understood by a human putting in the data.
Navino
On 9 March 2015 at 21:32, Markus Krötzsch <markus@semantic-mediawiki.org
wrote:
Awesome work :-). I love your use of Google Docs as a UI prototyping tool. We could really use a few more special-purpose querying tools.
Markus
On 09.03.2015 22:03, Navino Evans wrote:
Hi all,
We've been using WDQ queries a lot recently to update timelines in the Histropedia directory and, while trying to speed up the process, I ended up creating a very crude query generator tool over the weekend. After getting a bit carried away with it, it seemed worth sharing as it could actually be a handy tool for Wikidata editors, or anyone else interested in experimenting with queries.
I have no real coding experience, so it's just made in a humble spreadsheet! You can choose the input values for a query and the links to Histropedia, AutoList and WDQ will update automatically.The idea is obviously that this sort of tool should be written in Javascript by someone who actually knows what they're doing ;) but they do work and can easily be customised by adding more Wikidata items to the available options.
I've made 3 different types of query generator so far, which I'll publish shortly as free templates on Google Sheets:
- Date range query generator
- People finder query generator
- Family tree query generator
They are publicly editable spreadsheets so feel free to make a copy if someone is using the one you land on. And certainly don't hold back if anyone wishes to make any improvements.
I hope someone finds it useful/fun to mess around with these, but I thought it was a nice story to share in itself - that a non-coder can sit down and create something genuinely useful by tapping into the power of Wikidata, and of course Magnus' amazing tools! :)
Cheers,
Navino
-- ___________________________
Histropedia
The Timeline for all of History www.histropedia.com http://www.histropedia.com/
Follow us on: Twitter https://twitter.com/Histropedia Facebo https://www.facebook.com/Histropediaok https://www.facebook.com/Histropedia Google + https://plus.google.com/u/0/b/104484373317792180682/ 104484373317792180682/posts L http://www.linkedin.com/company/histropedia-ltdinke http://www.linkedin.com/company/histropedia-ltddIn http://www.linkedin.com/company/histropedia-ltd
Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
-- ___________________________
Histropedia
The Timeline for all of History www.histropedia.com
Follow us on: Twitter https://twitter.com/Histropedia Facebo https://www.facebook.com/Histropediaok https://www.facebook.com/Histropedia Google + https://plus.google.com/u/0/b/104484373317792180682/104484373317792180682/posts L http://www.linkedin.com/company/histropedia-ltdinke http://www.linkedin.com/company/histropedia-ltddIn http://www.linkedin.com/company/histropedia-ltd
Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
On 10.03.2015 14:15, Navino Evans wrote:
Cheers Fabian, Magnus!
Just had a quick look at the import-json function - looks pretty awesome :-) I probably won't be able to resist using it to make a mark-II mock up at some point.
Thanks for the heads up about the upcoming Wikidata graph database, I was aware that was in the pipeline. We'll probably crack on with trying to make a couple of these query builders properly anyway, and make modifications as required in the future (after learning some SPARQL by the sounds of it!).
This should be a minor issue. SPARQL is complex, but you can create queries as in your UIs just like you do for WDQ, only using different text templates for expressing the various conditions. But once you have these, it is quite easy to use as well.
We hope that we can set up a test server very soon for people to try out SPARQL on Wikidata even before the official WMF service goes online.
Cheers,
Markus
That's good to know. Looking forward to playing around with it when there's a test server up and running.
Best,
Navino
On 10 March 2015 at 13:28, Markus Kroetzsch markus.kroetzsch@tu-dresden.de wrote:
On 10.03.2015 14:15, Navino Evans wrote:
Cheers Fabian, Magnus!
Just had a quick look at the import-json function - looks pretty awesome :-) I probably won't be able to resist using it to make a mark-II mock up at some point.
Thanks for the heads up about the upcoming Wikidata graph database, I was aware that was in the pipeline. We'll probably crack on with trying to make a couple of these query builders properly anyway, and make modifications as required in the future (after learning some SPARQL by the sounds of it!).
This should be a minor issue. SPARQL is complex, but you can create queries as in your UIs just like you do for WDQ, only using different text templates for expressing the various conditions. But once you have these, it is quite easy to use as well.
We hope that we can set up a test server very soon for people to try out SPARQL on Wikidata even before the official WMF service goes online.
Cheers,
Markus
-- Markus Kroetzsch Faculty of Computer Science Technische Universität Dresden +49 351 463 38486 http://korrekt.org/
Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Looks cool, see also wrote the beginning of a query generator in mediawiki templates : https://www.wikidata.org/wiki/Template:WDQ
2015-03-09 22:03 GMT+01:00 Navino Evans navino@histropedia.com:
Hi all,
We've been using WDQ queries a lot recently to update timelines in the Histropedia directory and, while trying to speed up the process, I ended up creating a very crude query generator tool over the weekend. After getting a bit carried away with it, it seemed worth sharing as it could actually be a handy tool for Wikidata editors, or anyone else interested in experimenting with queries.
I have no real coding experience, so it's just made in a humble spreadsheet! You can choose the input values for a query and the links to Histropedia, AutoList and WDQ will update automatically.The idea is obviously that this sort of tool should be written in Javascript by someone who actually knows what they're doing ;) but they do work and can easily be customised by adding more Wikidata items to the available options.
I've made 3 different types of query generator so far, which I'll publish shortly as free templates on Google Sheets:
- Date range query generator
https://docs.google.com/spreadsheets/d/1A8wyqVc5USJ_T8ncFfYIsmJzfy8LIdmH2QLgeyegRAM/edit?usp=sharing
- People finder query generator
https://docs.google.com/spreadsheets/d/16-x7NGyHTAtEJBa5uF9ZYBhNj6BhhCJrtDaKCcJIFuE/edit?usp=sharing
- Family tree query generator
https://docs.google.com/spreadsheets/d/1dNTBoi-QbI0t-t0Ba4Ex5-sx7Q03qRecE27bapQGpAw/edit?usp=sharing
They are publicly editable spreadsheets so feel free to make a copy if someone is using the one you land on. And certainly don't hold back if anyone wishes to make any improvements.
I hope someone finds it useful/fun to mess around with these, but I thought it was a nice story to share in itself - that a non-coder can sit down and create something genuinely useful by tapping into the power of Wikidata, and of course Magnus' amazing tools! :)
Cheers,
Navino
-- ___________________________
Histropedia
The Timeline for all of History www.histropedia.com
Follow us on: Twitter https://twitter.com/Histropedia Facebo https://www.facebook.com/Histropediaok https://www.facebook.com/Histropedia Google + https://plus.google.com/u/0/b/104484373317792180682/104484373317792180682/posts L http://www.linkedin.com/company/histropedia-ltdinke http://www.linkedin.com/company/histropedia-ltddIn http://www.linkedin.com/company/histropedia-ltd
Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Thanks Thomas, that looks really handy. I definitely think we need more template based solutions like this.
Best,
Navino On 16 Mar 2015 20:34, "Thomas Douillard" thomas.douillard@gmail.com wrote:
Looks cool, see also wrote the beginning of a query generator in mediawiki templates : https://www.wikidata.org/wiki/Template:WDQ
2015-03-09 22:03 GMT+01:00 Navino Evans navino@histropedia.com:
Hi all,
We've been using WDQ queries a lot recently to update timelines in the Histropedia directory and, while trying to speed up the process, I ended up creating a very crude query generator tool over the weekend. After getting a bit carried away with it, it seemed worth sharing as it could actually be a handy tool for Wikidata editors, or anyone else interested in experimenting with queries.
I have no real coding experience, so it's just made in a humble spreadsheet! You can choose the input values for a query and the links to Histropedia, AutoList and WDQ will update automatically.The idea is obviously that this sort of tool should be written in Javascript by someone who actually knows what they're doing ;) but they do work and can easily be customised by adding more Wikidata items to the available options.
I've made 3 different types of query generator so far, which I'll publish shortly as free templates on Google Sheets:
- Date range query generator
https://docs.google.com/spreadsheets/d/1A8wyqVc5USJ_T8ncFfYIsmJzfy8LIdmH2QLgeyegRAM/edit?usp=sharing
- People finder query generator
https://docs.google.com/spreadsheets/d/16-x7NGyHTAtEJBa5uF9ZYBhNj6BhhCJrtDaKCcJIFuE/edit?usp=sharing
- Family tree query generator
https://docs.google.com/spreadsheets/d/1dNTBoi-QbI0t-t0Ba4Ex5-sx7Q03qRecE27bapQGpAw/edit?usp=sharing
They are publicly editable spreadsheets so feel free to make a copy if someone is using the one you land on. And certainly don't hold back if anyone wishes to make any improvements.
I hope someone finds it useful/fun to mess around with these, but I thought it was a nice story to share in itself - that a non-coder can sit down and create something genuinely useful by tapping into the power of Wikidata, and of course Magnus' amazing tools! :)
Cheers,
Navino
-- ___________________________
Histropedia
The Timeline for all of History www.histropedia.com
Follow us on: Twitter https://twitter.com/Histropedia Facebo https://www.facebook.com/Histropediaok https://www.facebook.com/Histropedia Google + https://plus.google.com/u/0/b/104484373317792180682/104484373317792180682/posts L http://www.linkedin.com/company/histropedia-ltdinke http://www.linkedin.com/company/histropedia-ltddIn http://www.linkedin.com/company/histropedia-ltd
Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l
Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-l