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.
