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.Galili@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 <fjbuch@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("fjbuch@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]]

