DataONE:Notebook/Piwowar Notes/2010/08/02

From OpenWetWare

< DataONE:Notebook | Piwowar Notes | 2010 | 08(Difference between revisions)
Jump to: navigation, search
(Autocreate 2010/08/02 Entry for DataONE:Notebook/Piwowar_Notes)
Current revision (13:09, 3 August 2010) (view source)
(add note about dynamic nature of todo list)
 
(8 intermediate revisions not shown.)
Line 7: Line 7:
<!-- ##### DO NOT edit above this line unless you know what you are doing. ##### -->
<!-- ##### DO NOT edit above this line unless you know what you are doing. ##### -->
[[Category:DataONE]]
[[Category:DataONE]]
 +
 +
 +
==Plans and accomplishments==
 +
(Note that as things left undone are assigned new dates, they disappear from this list)
 +
<html>
 +
<div style="padding:0;margin:0;text-align:left"><iframe src="http://spreadsheets.google.com/tq?tqx=out:html&tq=select%20B,C,D,E%20where%20B%20contains%20'2010-08-02'&key=t_LXM5f_pFxk9p0dFwXp0cA#gid=0" style="width:100%;border:none;"></iframe><hr style="border:1px solid #E0E0E0;margin:0px 0px 5px 0px;padding:0;width:450px;"/></div>
 +
</html>
 +
Raw spreadsheet:  http://spreadsheets.google.com/ccc?key=0AjO_Nq8pNHiOdF9MWE01Zl9wRnhrOXAwZEZ3WHAwY0E&hl=en
 +
 +
==Notes==
 +
 +
===Embedding query subsets of google spreadsheets in OWW===
 +
* Spreadsheet itself:  http://spreadsheets.google.com/ccc?key=0AjO_Nq8pNHiOdF9MWE01Zl9wRnhrOXAwZEZ3WHAwY0E&hl=en
 +
* URL to get the subset shown above:  http://spreadsheets.google.com/tq?tqx=out:html&tq=select%20B,C,D,E%20where%20B%20contains%20'2010-08-02'&key=t_LXM5f_pFxk9p0dFwXp0cA#gid=0
 +
* the where clause can contain:
 +
** contains, matches, <, >, =, !
 +
** Select by name (case sensitive); 'matches' must match exactly, 'contains' is a free text search
 +
* Useful post:  http://blog.ouseful.info/2009/05/18/?orderby=ID&order=ASC
 +
* Query builder: http://ouseful.open.ac.uk/datastore/gspreadsheetdb2.php
 +
* To filter on dates, use this format:  ''where A contains '2010-08-02'''
 +
 +
==Relevant background life==
 +
* BC Day today, so UBC and most of Vancouver is closed.  Working from coffee shops

Current revision

Heather Piwowar's notes Main project page
Previous entry      Next entry


Plans and accomplishments

(Note that as things left undone are assigned new dates, they disappear from this list)

Raw spreadsheet: http://spreadsheets.google.com/ccc?key=0AjO_Nq8pNHiOdF9MWE01Zl9wRnhrOXAwZEZ3WHAwY0E&hl=en

Notes

Embedding query subsets of google spreadsheets in OWW

Relevant background life

  • BC Day today, so UBC and most of Vancouver is closed. Working from coffee shops



Retrieved from "http://www.openwetware.org/wiki/DataONE:Notebook/Piwowar_Notes/2010/08/02"
Personal tools