[Rd] reading and writing to Google spreadsheets
Have you ever collaborated? Google Spreadsheets is fantastic to collaborate with. Rather than sending excel spreadsheets backwards and forwards, I would rather use shared Google Spreadsheets. I do not want the intermediate step of exporting a Google Spreadsheet as an xls file. I do not know how to make use of the Google Spreadsheet API (http://code.google.com/apis/spreadsheets/overview.html) but from the little knowledge that I have I can see that this would be the way to enable R to talk to Google. How much work would it be for this to be incorporated into RODBC? Google Spreadsheets has some phenomenal functionality that uses Google Search engine to populate the columns in a spreadsheet with data. Can you imagine the power of using the Spreadsheet to get the data and R to merge it with ones own research data and then analyze the merged data. Check this http://googlesystem.blogspot.com/2007/11/connecting-data-using-google.html -- Farrel Buchinsky __ R-devel@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-devel
[Rd] R-Google interface: Google summer of code
I use R for data management and ongoing data analysis for amongst other things, a multi-center medical research project. I have found Google spreadsheets to be a fantastic way for all collaborators to be on the same page. Furthermore, Google Forms allows one to capture data from respondents and effortlessly write it to a google spreadsheet. Currently, one has to manually download the spreadsheet as a csv file and then read that into R. Since data changes frequently and is almost never final it would be far preferable for R to read a google spreadsheet directly. RODBC package does something similar for Microsoft Access and Microsoft Excel. I am a surgeon-scientist whose programing experience is extremely limited. Is there a willing mentor who would want to take such a project and propose it for the Google summer of code project? The mentor could chose his or her scope. For instance at it's most basic the project's goal could be to simply read a spreadsheet from google spreadsheet into a R dataframe. The scope could widen to allow R to also write to Google spreadsheet. If one wanted something even more challenging then one could create code that allows one to post R script to a R server allowing the server to read Google Spreadsheets, processes the data and present the output to a web client. Farrel Buchinsky [[alternative HTML version deleted]] __ R-devel@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-devel
[Rd] RGoogleDocs so close but errors with spreadsheet reading
I got RGoogleDocs to work. It works on documents but not on spreadsheets. I get the following error. getDocs(con, what ="http://docs.google.com/feeds/documents/private/full/-/spreadsheet";) assignment of an object of class "NULL" is not valid for slot "access" in an object of class "GoogleSpreadsheet"; is(value, "character") is not TRUE How can I troubleshoot this? Farrel Buchinsky Google Voice Tel: (412) 567-7870 Sent from Pittsburgh, Pennsylvania, United States __ R-devel@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-devel
Re: [Rd] RGoogleDocs so close but errors with spreadsheet reading
Does it have anything to do with the following message when I load RGoogleDocs? The following object(s) are masked from package:methods : getAccess Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, Apr 1, 2009 at 18:36, Farrel Buchinsky wrote: > I got RGoogleDocs to work. It works on documents but not on spreadsheets. > I get the following error. > > getDocs(con, what > ="http://docs.google.com/feeds/documents/private/full/-/spreadsheet";) > > assignment of an object of class "NULL" is not valid for slot "access" > in an object of class "GoogleSpreadsheet"; is(value, "character") is > not TRUE > > How can I troubleshoot this? > > Farrel Buchinsky > Google Voice Tel: (412) 567-7870 > > Sent from Pittsburgh, Pennsylvania, United States > __ R-devel@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-devel
Re: [Rd] RGoogleDocs so close but errors with spreadsheet reading
I went through the installation process using what you had in the prerelease. Unofortunately I am still getting Error in checkSlotAssignment(object, name, value) : assignment of an object of class "NULL" is not valid for slot "access" in an object of class "GoogleSpreadsheet"; is(value, "character") is not TRUE Could you please run a script that gets you in and post it and its output here. I would like to see verbatim how you are getting it to work. Obviously x out your password. Is their anything I could do that would provide insight into what is going wrong? Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, Apr 1, 2009 at 21:15, Duncan Temple Lang wrote: > > You might try my development version which I put at > > http://www.omegahat.org/Prerelease/RGoogleDocs_0.2-0.tar.gz > > I am not certain if there are any substantive differences with the > one in the Omegahat repository, but it works for me with a document > and a spreadsheet in an Google Docs account. > > D. > > Farrel Buchinsky wrote: > >> I got RGoogleDocs to work. It works on documents but not on spreadsheets. >> I get the following error. >> >> getDocs(con, what >> ="http://docs.google.com/feeds/documents/private/full/-/spreadsheet";) >> >> assignment of an object of class "NULL" is not valid for slot "access" >> in an object of class "GoogleSpreadsheet"; is(value, "character") is >> not TRUE >> >> How can I troubleshoot this? >> >> Farrel Buchinsky >> Google Voice Tel: (412) 567-7870 >> >> Sent from Pittsburgh, Pennsylvania, United States >> >> __ >> R-devel@r-project.org mailing list >> https://stat.ethz.ch/mailman/listinfo/r-devel >> > [[alternative HTML version deleted]] __ R-devel@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-devel