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:

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/Histropedia>ok
<https://www.facebook.com/Histropedia> Google +
<https://plus.google.com/u/0/b/104484373317792180682/104484373317792180682/posts>
L <http://www.linkedin.com/company/histropedia-ltd>inke
<http://www.linkedin.com/company/histropedia-ltd>dIn
<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     Facebook     Google +     LinkedIn

_______________________________________________
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