R help - Aug 2009 - RGoogleDocs: getDocs() - "problems connecting to get the list of documents"

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]]

It is working for me. Are you using the latest version as in Version: 0.2-2?

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 at 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.
> 
> 
-- 
View this message in context:
http://www.nabble.com/RGoogleDocs%3A-getDocs%28%29---%22problems-connecting-to-get-the-list-of-documents%22-tp24969136p24970787.html
Sent from the R help mailing list archive at Nabble.com.

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 at 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.