[R] RGoogleDocs

[Duncan Temple Lang]

Robert Schneider wrote:
> Hi there,
> 
> I'm not certain if this is the correct list where to post this question, or if it ought to be on the R developper one... I am trying to use the RGoogleDocs package to import into R the spreadsheets on my Google docs account. I downloaded the latest package (0.2.0) and installed it. I can get a connection going, but it seems that I can only get a doc one... 
> 

This is the correct list. And it is best to email the author of the 
package first.


> Here is the code I am using:
> 
>> library(RGoogleDocs)
> 
>> auth = getGoogleAuth("loginName", "psswrd", service="wise")
> 
>> sheets.con = getGoogleDocsConnection(auth)
> 
>> a <- getDocs(sheets.con)   
> 
> I get the following error:
> 
> 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

This turns out to be a simple case of the feedLink/access information 
not always being present in the resulting  XML returned via the query.

A new version of the package is on the Omegahat repository that fixes
this.  Thanks for pointing it out.

  D.

> 
> 
> If i change the service to "writely", I get the full listing of the google docs and cannot import a spreadsheet due to the fact that the sheets.con is of the wrong class.
> 
> Any help would be appreciated ! I am running under Ubunto 8.10 if that can help...
> 
> Thanks.
> 
> Robert
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> _________________________________________________________________
> 
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.