Hi Matthew You mentioned in mail direclty to me that this code worked earlier in your morning. So that suggests that it is not the code. But you should look carefully at the 2 lines you ran (i.e. the ones below) and painstakingly check that the user name and password are the same. It is easy to overlook a one character difference.
But assuming that the code really is the same and is still not working, let's try to figure out ways of checking what is wrong. One thing to do is to log into GoogleDocs via your browser. Then take a look at some of the spreadsheets you have there. Then return to R and try the commands again. Clearly if there is a problem with accessing GoogleDocs and the spreadsheets in your browser, then that is the problem. One some services (e.g. Flickr and the Rflickr pacage) you must use the browser once or periodically to grant programmatic access. I can't remember if that is an issue with GoogleDocs. Another thing to do is options(error = recover) getWorksheets("formname", sheets.con) and when the error occurs (in getDocs()), you will be in the error handling and have the stack of function calls available. Select the largest number to have an R prompt that is in the getDocs() call frame. Then type status to show the value of the R variable named status. Also type x which contains the body of the HTTP response. If you send these to me, we might have a lead on what is wrong. D. Blackett, Matthew wrote:
Hi I have been using RGoogleDocs successfully for some time now but something seems to have happened which is preventing me from accessing my data in google spreadsheets. I get the message: "problems connecting to get the list of documents" when I use getDocs, despite being logged in e.g. sheets.con = getGoogleDocsConnection(getGoogleAuth("username", "password", service = "wise")) ts = getWorksheets("formname", sheets.con) รจ Error in getDocs(con) : problems connecting to get the list of documents Does anyone know what might be causing this? Is it maybe a problem at the google end? Matthew Blackett Researcher King's College London http://geography.kcl.ac.uk/micromet/MBlackett/ [[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.