{"id":368,"date":"2010-06-12T06:39:25","date_gmt":"2010-06-12T10:39:25","guid":{"rendered":"http:\/\/www.sofastatistics.com\/blog\/?p=368"},"modified":"2010-06-12T06:58:18","modified_gmt":"2010-06-12T10:58:18","slug":"0-9-11-imports-on-line-google-spreadsheets","status":"publish","type":"post","link":"http:\/\/www.sofastatistics.com\/blog\/0-9-11-imports-on-line-google-spreadsheets\/","title":{"rendered":"0.9.11 imports on-line Google Docs Spreadsheets"},"content":{"rendered":"<p>The latest version, 0.9.11, can import data from your on-line Google Docs Spreadsheets.  I will supply more details later, but it is easy to conduct on-line surveys with Google Spreadsheets underneath.  And now you can analyse those results using SOFA Statistics.<\/p>\n<p>To connect to your Google account, there is a new button on the standard Import dialog.<\/p>\n<div id=\"attachment_369\" style=\"width: 440px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.sofastatistics.com\/blog\/wp-content\/uploads\/2010\/06\/import_gdata_option.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-369\" src=\"http:\/\/www.sofastatistics.com\/blog\/wp-content\/uploads\/2010\/06\/import_gdata_option.jpg\" alt=\"New Google Spreadsheet button\" title=\"New Google Spreadsheet button\" width=\"430\" height=\"342\" class=\"size-full wp-image-369\" srcset=\"http:\/\/www.sofastatistics.com\/blog\/wp-content\/uploads\/2010\/06\/import_gdata_option.jpg 430w, http:\/\/www.sofastatistics.com\/blog\/wp-content\/uploads\/2010\/06\/import_gdata_option-300x238.jpg 300w\" sizes=\"auto, (max-width: 430px) 100vw, 430px\" \/><\/a><p id=\"caption-attachment-369\" class=\"wp-caption-text\">New Google Spreadsheet button<\/p><\/div>\n<p>This opens a simple dialog letting you sign into your Google account.  The existing spreadsheets are listed and then you can select a worksheet.  Once this is downloaded, it can be imported in the standard SOFA manner.<\/p>\n<div id=\"attachment_370\" style=\"width: 440px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.sofastatistics.com\/blog\/wp-content\/uploads\/2010\/06\/download_google_spreadsheet.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-370\" src=\"http:\/\/www.sofastatistics.com\/blog\/wp-content\/uploads\/2010\/06\/download_google_spreadsheet.jpg\" alt=\"Download Google Spreadsheet\" title=\"Download Google Spreadsheet\" width=\"430\" height=\"420\" class=\"size-full wp-image-370\" srcset=\"http:\/\/www.sofastatistics.com\/blog\/wp-content\/uploads\/2010\/06\/download_google_spreadsheet.jpg 430w, http:\/\/www.sofastatistics.com\/blog\/wp-content\/uploads\/2010\/06\/download_google_spreadsheet-300x293.jpg 300w\" sizes=\"auto, (max-width: 430px) 100vw, 430px\" \/><\/a><p id=\"caption-attachment-370\" class=\"wp-caption-text\">Download Google Spreadsheet<\/p><\/div>\n<p>Version 0.9.11 also makes it easier to work with read-only columns in data tables.<\/p>\n<div id=\"attachment_372\" style=\"width: 438px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.sofastatistics.com\/blog\/wp-content\/uploads\/2010\/06\/read-only_columns.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-372\" src=\"http:\/\/www.sofastatistics.com\/blog\/wp-content\/uploads\/2010\/06\/read-only_columns.jpg\" alt=\"Read-only Columns\" title=\"Read-only Columns\" width=\"428\" height=\"187\" class=\"size-full wp-image-372\" srcset=\"http:\/\/www.sofastatistics.com\/blog\/wp-content\/uploads\/2010\/06\/read-only_columns.jpg 428w, http:\/\/www.sofastatistics.com\/blog\/wp-content\/uploads\/2010\/06\/read-only_columns-300x131.jpg 300w\" sizes=\"auto, (max-width: 428px) 100vw, 428px\" \/><\/a><p id=\"caption-attachment-372\" class=\"wp-caption-text\">Read-only Columns<\/p><\/div>\n<p>The final improvement relates to filtering.  If you have trouble with the flexible data filtering option, more helpful examples of correct syntax are supplied.<\/p>\n<p>The main bug fix is that SQLite and MySQL now handle fields containing double quotes.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The latest version, 0.9.11, can import data from your on-line Google Docs Spreadsheets. I will supply more details later, but it is easy to conduct on-line surveys with Google Spreadsheets underneath. And now you can analyse those results using SOFA Statistics. To connect to your Google account, there is a new button on the standard [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-368","post","type-post","status-publish","format-standard","hentry","category-general"],"_links":{"self":[{"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/posts\/368","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/comments?post=368"}],"version-history":[{"count":3,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/posts\/368\/revisions"}],"predecessor-version":[{"id":374,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/posts\/368\/revisions\/374"}],"wp:attachment":[{"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/media?parent=368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/categories?post=368"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/tags?post=368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}