3,201
edits
ORBIT/Development: Difference between revisions
From OER in Education
no edit summary
SimonKnight (talk | contribs) No edit summary |
SimonKnight (talk | contribs) No edit summary |
||
| Line 10: | Line 10: | ||
# To allow for an automated check between our google docs spreadsheet, and data on the wiki, with a view to automating updates of the google spreadsheet. This was done using google's 'scraper' function. | # To allow for an automated check between our google docs spreadsheet, and data on the wiki, with a view to automating updates of the google spreadsheet. This was done using google's 'scraper' function. | ||
On the Wiki we setup a number of queries of the following form, specifying the category, and information from that category to appear in the columns | On the Wiki we setup a number of queries of the following form, specifying the category, and information from that category to appear in the columns | ||
:{{#ask: [[Category:ToolInfo]]| ?resourcenumber| ?final| format=table | limit=200 }} | <nowiki>:{{#ask: [[Category:ToolInfo]]| ?resourcenumber| ?final| format=table | limit=200 }}</nowiki> | ||
Within google, a small formula can retrieve these tables, for example | Within google, a small formula can retrieve these tables, for example | ||
:=importhtml("http://orbit.educ.cam.ac.uk/wiki/User:Bjoern/resourceoverview","table",3) | :=importhtml("http://orbit.educ.cam.ac.uk/wiki/User:Bjoern/resourceoverview","table",3) | ||
