At this point, I'm giving up on this issue. The stage of our project requiring daily use of Google Docs ended, thankfully, about a week before this problem arose. I was able to just export the spreadsheet for further analysis, rather than relying on the Google Spreadsheet. If this problem had arisen a week earlier, it would have been a catastrophe, however. Now, though, I don't really have time to keep trying to track this down.
I'm disappointed that we couldn't find a solution. It was very useful when it worked. (Tal, yes, I just tried it on another machine with a fresh R and packages install. No joy.) -Harlan On Mon, Nov 22, 2010 at 2:38 PM, Harlan Harris <har...@harris.name> wrote: > No joy for me. :( > > I'd had version 0.4-1 installed previously, and re-pulling that URL and > reinstalling, plus setting RCurlOptions as specified, do not help for me. > Exactly the same behavior. It doesn't matter whether I call getGoogleAuth > directly or let getGoogleDocsConnection do it for me. > > -Harlan > > On Fri, Nov 19, 2010 at 10:27 PM, Farrel Buchinsky <fjb...@gmail.com> > wrote: > > > Harlan and Tal have had problems. I had lots too. I spent hours getting > it > > to work. Terrible process to go through but RGoogleDocs is so useful that > > the time was worth it - I think! > > > > My problems were overcome when > > > > 1. I used the latest zip file by Duncan Temple Lang see below > > 2. I inserted an options line that loosened the ssl security - do not > > know if that was a good thing or not but it got it to work > > > > Duncan said: > > "I have put an updated version of the source of the package with > > these changes. It is available from > > http://www.omegahat.org/RGoogleDocs/RGoogleDocs_0.4-1.tar.gz > > There is a binary for Windows in > > http://www.omegahat.org/RGoogleDocs/RGoogleDocs_0.4-1.zip > > > > Here is my script that works. Does yours look like this? > > > > library(RGoogleDocs) > > packageDescription(" > RGoogleDocs") > > ps <-readline(prompt="get the password in ") > > options(RCurlOptions = list(capath = system.file("CurlSSL", "cacert.pem", > > package = "RCurl"), ssl.verifypeer = FALSE)) > > sheets.con = getGoogleDocsConnection(getGoogleAuth("fjb...@gmail.com", > ps, > > service ="wise")) > > ts2=getWorksheets("OnCall",sheets.con) #OnCall is just the name of a > > spreadsheet > > names(ts2) > > y2005<-sheetAsMatrix(ts2$y2005,header=TRUE, as.data.frame=TRUE, > trim=TRUE) > > > > Finally, I am willing to offer you a TeamViewer session where we can take > > control of one another's computers and see if the problem is code or the > > installation. I warn you that I am neither a programmer nor a developer, > > just a very enthusiastic RGoogleDocs user who probably perseveres more > than > > is good for him. > > > > Farrel Buchinsky > > > > > > > On Fri, Nov 19, 2010 at 1:35 PM, Tal Galili <tal.gal...@gmail.com> wrote: > >> I second Harlan's call. >> >> >> ----------------Contact >> Details:------------------------------------------------------- >> Contact me: tal.gal...@gmail.com | 972-52-7275845 >> Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) | >> www.r-statistics.com (English) >> >> ---------------------------------------------------------------------------------------------- >> >> >> >> >> On Fri, Nov 19, 2010 at 5:00 PM, Harlan Harris <har...@harris.name>wrote: >> >>> Any new thoughts on this? I really want to get this working again! Is >>> there >>> someone else that can help or somewhere else I should be asking? >>> >>> Thanks! >>> >>> -Harlan >>> >>> >>> On Wed, Nov 17, 2010 at 10:16 AM, Harlan Harris <har...@harris.name> >>> wrote: >>> >>> > Following up again. I found on the forums for the Google Apps API this >>> > thread that seems to be about a similar issue: >>> > >>> http://www.google.com/support/forum/p/apps-apis/thread?tid=1c22cb44eb5cbba6&hl=en&search_impression_id=ab161b010ecf8803%3A12c5a65ce83&search_source=related_question >>> > >>> > It's using Java and is rather over my head, but it seems to suggest >>> that >>> > something related to the content type might be wrong? Does this offer >>> any >>> > suggestions on how to fix my use of RGoogleDocs? >>> > >>> > Thanks, >>> > >>> > -Harlan >>> > >>> > >>> > On Mon, Nov 15, 2010 at 12:16 PM, Harlan Harris <har...@harris.name >>> >wrote: >>> > >>> >> Thanks, Duncan. Finally getting a chance to follow up on this... >>> >> >>> >> I tried again, changing and resetting my password, and trying to >>> specify >>> >> my login and password manually in the getGoogleDocsConnection argument >>> list. >>> >> I also tried removing either or both of the service and error options. >>> No >>> >> luck in any case. I also tried a different Google account, also with >>> no >>> >> luck. >>> >> >>> >> I've also tried tweaking the URL being generated by the code, and in >>> all >>> >> cases, I get a 403: Forbidden error with content >>> "Error=BadAuthentication". >>> >> >>> >> I don't really know enough about how authentication is supposed to >>> work to >>> >> get much farther. Can you help? Should I try the Google API forum >>> instead? >>> >> >>> >> -Harlan >>> >> >>> >> >>> >> >>> >>> From: Duncan Temple Lang <dun...@wald.ucdavis.edu> >>> >>> To: r-help@r-project.org >>> >>> Date: Wed, 10 Nov 2010 10:33:47 -0800 >>> >>> Subject: Re: [R] RGoogleDocs stopped working >>> >>> >>> >>> Hi Harlan >>> >>> >>> >>> I just tried to connect to Google Docs and I had ostensibly the same >>> >>> problem. >>> >>> However, the password was actually different from what I had >>> specified. >>> >>> After resetting it with GoogleDocs, the getGoogleDocsConnection() >>> worked >>> >>> fine. So I don't doubt that the login and password are correct, but >>> >>> you might just try it again to ensure there are no typos. >>> >>> The other thing to look at is the values for Email and Passwd >>> >>> sent in the URL, i.e. the string in url in your debugging >>> >>> below. (Thanks for that by the way). If either has special >>> characters, >>> >>> e.g. &, it is imperative that they are escaped correctly, i.e. >>> converted >>> >>> to %24. This should happen and nothing should have changed, but it >>> is >>> >>> worth verifying. >>> >>> >>> >>> So things still seem to work for me. It is a data point, but not one >>> >>> that gives you much of a clue as to what is wrong on your machine. >>> >>> >>> >>> D. >>> >>> >>> >> >>> >> On Wed, Nov 10, 2010 at 10:36 AM, Harlan Harris <har...@harris.name >>> >wrote: >>> >> >>> >>> Hello, >>> >>> >>> >>> Some code using RGoogleDocs, which had been working smoothly since >>> the >>> >>> summer, just stopped working. I know that it worked on November 3rd, >>> but it >>> >>> doesn't work today. I've confirmed that the login and password still >>> work >>> >>> when I log in manually. I've confirmed that the URL gives the same >>> error >>> >>> when I paste it into Firefox. I don't know enough about this web >>> service to >>> >>> figure out the problem myself, alas... >>> >>> >>> >>> Here's the error and other info (login/password omitted): >>> >>> >>> >>> > ss.con <- getGoogleDocsConnection(login=gd.login, >>> password=gd.password, >>> >>> service='wise', error=FALSE) >>> >>> Error: Forbidden >>> >>> >>> >>> Enter a frame number, or 0 to exit >>> >>> >>> >>> 1: getGoogleDocsConnection(login = gd.login, password = gd.password, >>> >>> service = "wise", error = FALSE) >>> >>> 2: getGoogleAuth(..., error = error) >>> >>> 3: getForm("https://www.google.com/accounts/ClientLogin", >>> accountType = >>> >>> "HOSTED_OR_GOOGLE", Email = login, Passw >>> >>> 4: getURLContent(uri, .opts = .opts, .encoding = .encoding, binary = >>> >>> binary, curl = curl) >>> >>> 5: stop.if.HTTP.error(http.header) >>> >>> >>> >>> Selection: 4 >>> >>> Called from: eval(expr, envir, enclos) >>> >>> Browse[1]> http.header >>> >>> Content-Type >>> >>> Cache-control Pragma >>> >>> "text/plain" "no-cache, >>> >>> no-store" "no-cache" >>> >>> Expires Date >>> >>> X-Content-Type-Options >>> >>> "Mon, 01-Jan-1990 00:00:00 GMT" "Wed, 10 Nov 2010 15:24:39 >>> >>> GMT" "nosniff" >>> >>> X-XSS-Protection >>> >>> Content-Length Server >>> >>> "1; mode=block" >>> >>> "24" "GSE" >>> >>> status statusMessage >>> >>> "403" "Forbidden\r\n" >>> >>> Browse[1]> url >>> >>> [1] " >>> >>> >>> https://www.google.com/accounts/ClientLogin?accountType=HOSTED%5FOR%5FGOOGLE&Email=***&Passwd=***&service=wise&source=R%2DGoogleDocs%2D0%2E1 >>> >>> " >>> >>> Browse[1]> .opts >>> >>> $ssl.verifypeer >>> >>> [1] FALSE >>> >>> >>> >>> >>> >>> > R.Version() >>> >>> $platform >>> >>> [1] "i386-apple-darwin9.8.0" >>> >>> >>> >>> $arch >>> >>> [1] "i386" >>> >>> >>> >>> $os >>> >>> [1] "darwin9.8.0" >>> >>> >>> >>> $system >>> >>> [1] "i386, darwin9.8.0" >>> >>> >>> >>> $status >>> >>> [1] "" >>> >>> >>> >>> $major >>> >>> [1] "2" >>> >>> >>> >>> $minor >>> >>> [1] "10.1" >>> >>> >>> >>> $year >>> >>> [1] "2009" >>> >>> >>> >>> $month >>> >>> [1] "12" >>> >>> >>> >>> $day >>> >>> [1] "14" >>> >>> >>> >>> $`svn rev` >>> >>> [1] "50720" >>> >>> >>> >>> $language >>> >>> [1] "R" >>> >>> >>> >>> $version.string >>> >>> [1] "R version 2.10.1 (2009-12-14)" >>> >>> >>> >>> >>> >>> > installed.packages()[c('RCurl', 'RGoogleDocs'), ] >>> >>> Package >>> >>> LibPath Version Priority >>> Bundle >>> >>> Contains >>> >>> RCurl "RCurl" >>> >>> "/Users/hharris/Library/R/2.10/library" "1.4-3" NA >>> NA >>> >>> NA >>> >>> RGoogleDocs "RGoogleDocs" >>> >>> "/Library/Frameworks/R.framework/Resources/library" "0.4-1" NA >>> NA >>> >>> NA >>> >>> Depends Imports LinkingTo >>> >>> Suggests Enhances OS_type License Built >>> >>> RCurl "R (>= 2.7.0), methods, bitops" NA NA >>> >>> "Rcompression" NA NA "BSD" "2.10.1" >>> >>> RGoogleDocs "RCurl, XML, methods" NA NA >>> >>> NA NA NA "BSD" "2.10.1" >>> >>> >>> >>> >>> >>> Any ideas? Thank you! >>> >>> >>> >>> -Harlan >>> >>> >>> >>> >>> >> >>> > >>> >>> [[alternative HTML version deleted]] >>> >>> ______________________________________________ >>> R-help@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. >>> >> >> > [[alternative HTML version deleted]] ______________________________________________ R-help@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.