[R] RGoogleDocs ability to write to spreadsheets broken as of yesterday

David Scott d.scott at auckland.ac.nz
Wed Jul 21 23:09:06 CEST 2010


Henrique Dallazuanna wrote:
> On Wed, Jul 21, 2010 at 11:24 AM, Ben Bolker <bbolker at gmail.com> wrote:
> 
>> Harlan Harris <harlan <at> harris.name> writes:
>>
>>> Hi,
>>>
>>> I'm using RGoogleDocs/RCurl to update a Google Spreadsheet. Everything
>>> worked OK until this morning, when my ability to write into spreadsheet
>>> cells went away. I get the following weird error:
>>>
>>> Error in els[[type + 1]] : subscript out of bounds
>>>
>>> Looking at the Google Docs API changelog, I see the following:
>>>
>>> http://code.google.com/apis/spreadsheets/changelog.html
>>> Release 2010-01 (July 14, 2010)
>>>
>>> This is an advanced notice about an upcoming change.
>>>
>>>    - Starting July 19, 2010, all links returned by all Spreadsheets API
>>>    feeds will use HTTPS. This is being done in the interests of increased
>>>    security. If you require the use of HTTP, we recommend that you remove
>> the
>>>    replace https with http in these links. Another announcement will be
>> made
>>>    on July 19, 2010, when this change goes to production.
>>>
>>> I suspect this is the problem. Fixing it is above my head, I'm afraid.
>> Could
>>> anyone help? This is urgent. Thank you,
>>
>>    This is an Omegahat package (took me a little while to find it). Perhaps
>> you should write to the package maintainer?
>>
>> library(RGoogleDocs)
>> help(package="RGoogleDocs")
>>
>> or, more obscurely:
>>
>> help(package=RGoogleDocs)$info[[1]][9]
>>
>>  (there may be a better way to deal with objects of type "packageInfo"
>> but I can't figure it out right at the moment).
>>
> 
> Maybe:
> packageDescription('RGoogleDocs', fields = 'Author')
> 

 From the News file for 2.11.0:

  o	maintainer() has been added, to give convenient access to the
	name of the maintainer of a package


> 
>>  It looks as though one might be able to fix this by hacking the
>> hard-coded URLs in the code, but as you suggest that might be above
>> your head.
>>
>>  good luck ...
>>     Ben Bolker
>>
>> ______________________________________________
>> 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.
>>
> 
> 
> 


-- 
_________________________________________________________________
David Scott	Department of Statistics
		The University of Auckland, PB 92019
		Auckland 1142,    NEW ZEALAND
Phone: +64 9 923 5055, or +64 9 373 7599 ext 85055
Email:	d.scott at auckland.ac.nz,  Fax: +64 9 373 7018

Director of Consulting, Department of Statistics



More information about the R-help mailing list