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/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 > > -- ___________________________ 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