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/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 <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
>
_______________________________________________
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l

Reply via email to