Re: [Wikidata-l] Query generator spreadsheet

2015-03-18 Thread Navino Evans
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.douill...@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 nav...@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:

 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

 --
 ___

 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


Re: [Wikidata-l] Query generator spreadsheet

2015-03-16 Thread Thomas Douillard
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 nav...@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:

 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

 --
 ___

 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


Re: [Wikidata-l] Query generator spreadsheet

2015-03-10 Thread Magnus Manske
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.tomps...@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 nav...@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 mar...@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:

 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

 --
 ___

 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 

Re: [Wikidata-l] Query generator spreadsheet

2015-03-10 Thread Navino Evans
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 magnusman...@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.tomps...@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 nav...@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 mar...@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:

 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

 --
 ___

 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
 

Re: [Wikidata-l] Query generator spreadsheet

2015-03-10 Thread Navino Evans
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.kroetz...@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




-- 
___

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


Re: [Wikidata-l] Query generator spreadsheet

2015-03-10 Thread Markus Kroetzsch

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


Re: [Wikidata-l] Query generator spreadsheet

2015-03-10 Thread Fabian Tompsett
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 nav...@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 mar...@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:

 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

 --
 ___

 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
 

Re: [Wikidata-l] Query generator spreadsheet

2015-03-09 Thread Navino Evans
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 mar...@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:

 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-x7NGyHTAtEJBa5uF9ZYBhNj6BhhCJr
 tDaKCcJIFuE/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

 --
 ___

 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


Re: [Wikidata-l] Query generator spreadsheet

2015-03-09 Thread Markus Krötzsch
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:

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

--
___

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