[Rd] reading and writing to Google spreadsheets

2007-11-29 Thread Farrel Buchinsky
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

2009-02-27 Thread Farrel Buchinsky
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

2009-04-01 Thread Farrel Buchinsky
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

2009-04-01 Thread Farrel Buchinsky
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

2009-04-03 Thread Farrel Buchinsky
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