|
|
| Line 3: |
Line 3: |
|
| |
|
| =[[Google Docs]]= | | =[[Google Docs]]= |
| With very little on the Wiki initially, our main objective was to track incoming resources without 'swamping' the wiki with incomplete (or wireframed) pages. As a result, at this stage we used Google Spreadsheets to keep track of resources, their status, provenance, and other information which appears in the Resource Info table which appears on every resource's page.
| |
| ==Table Scraping==
| |
| As the project progressed, the wiki became more complete, and the 'status' levels of resources more complex - with some resources requiring longer to gain permissions, others considered strong enough to go up on the wiki but - if time - would benefit from some editing, and others considered finalised (in so far as that's ever true on a Wiki!). At this later stage a decision was made to try and embed as much of the data from google docs into the wiki tables as possible. This was for a few reasons including
| |
| # To maintain a clear - and public - record of provenance, reasoning behind meta-data assigning, and resource progression
| |
| # To make it clearer to anyone navigating the wiki - particularly editors - what stage resources were at, and what would be needed to 'finalise' resources
| |
| # 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
| |
| <nowiki>:{{#ask: [[Category:ToolInfo]]| ?resourcenumber| ?final| format=table | limit=200 }}</nowiki>
| |
| Within google, a small formula can retrieve these tables, for example
| |
| :=importhtml("http://orbit.educ.cam.ac.uk/wiki/User:Bjoern/resourceoverview","table",3)
| |
| imports the 3rd table from the page http://orbit.educ.cam.ac.uk/wiki/User:Bjoern/resourceoverview to the sheet it is inserted on in google spreadsheet. From this, we could cross-reference results and manipulate our data more freely.
| |
|
| |
|
| ==Report Writing== | | ==Report Writing== |
