Re: [R] RGoogleDocs stopped working
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.namewrote: 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=1c22cb44eb5cbba6hl=ensearch_impression_id=ab161b010ecf8803%3A12c5a65ce83search_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
Re: [R] RGoogleDocs stopped working
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=1c22cb44eb5cbba6hl=ensearch_impression_id=ab161b010ecf8803%3A12c5a65ce83search_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
Re: [R] RGoogleDocs stopped working
Dear Farrel, Now, using the most updated version of the packages, I was able to make your example work for me - thank you very much for your help! Best, Tal 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 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 [[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.
Re: [R] RGoogleDocs stopped working
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=1c22cb44eb5cbba6hl=ensearch_impression_id=ab161b010ecf8803%3A12c5a65ce83search_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.namewrote: 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.namewrote: 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/plainno-cache, no-store no-cache ExpiresDate 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%5FGOOGLEEmail=***Passwd=***service=wisesource=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
Re: [R] RGoogleDocs stopped working
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=1c22cb44eb5cbba6hl=ensearch_impression_id=ab161b010ecf8803%3A12c5a65ce83search_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/plainno-cache, no-store no-cache ExpiresDate 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
[R] RGoogleDocs stopped working
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 [[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.
Re: [R] RGoogleDocs stopped working
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=1c22cb44eb5cbba6hl=ensearch_impression_id=ab161b010ecf8803%3A12c5a65ce83search_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.namewrote: 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/plainno-cache, no-store no-cache ExpiresDate 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%5FGOOGLEEmail=***Passwd=***service=wisesource=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
Re: [R] RGoogleDocs stopped working
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/plainno-cache, no-store no-cache ExpiresDate 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%5FGOOGLEEmail=***Passwd=***service=wisesource=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
[R] RGoogleDocs stopped working
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/plainno-cache, no-store no-cache ExpiresDate 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%5FGOOGLEEmail=***Passwd=***service=wisesource=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 NARcompression NA NA BSD 2.10.1 RGoogleDocs RCurl, XML, methods NA NANA 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.
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 11/10/10 7:36 AM, Harlan Harris 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/plainno-cache, no-store no-cache ExpiresDate 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%5FGOOGLEEmail=***Passwd=***service=wisesource=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 NARcompression NA NA BSD 2.10.1 RGoogleDocs RCurl, XML, methods NA NANA 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. __ 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.