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.
