Re: [R] Reading from Google Docs

2009-12-08 Thread Farrel Buchinsky
Is anyone using RGoogleDocs? If so have you used it in the last few weeks and is it working as it used to. Look at the problem I have run into. Farrel Buchinsky On Sat, Nov 28, 2009 at 14:25, Farrel Buchinsky wrote: > Thank you for the interest in my problem. > > > I have been using the same

Re: [R] Reading from Google Docs

2009-11-28 Thread Farrel Buchinsky
Thank you for the interest in my problem. I have been using the same script (see below) successfully for the past 5 months and now all of a sudden I have problems. Could R be functioning differently under 2.10? Could Google have changed their authentication procedures? In other words are you cur

Re: [R] Reading from Google Docs

2009-11-28 Thread Duncan Temple Lang
Farrel Buchinsky wrote: > Please oh please could someone help me or at least confirm that they are > having the same problem. > > Why am I getting the error message from RGoogleDocs > >> getDocs(sheets.con) > Error in getDocs(sheets.con) : > problems connecting to get the list of documents Y

Re: [R] Reading from Google Docs

2009-11-28 Thread Farrel Buchinsky
Please oh please could someone help me or at least confirm that they are having the same problem. Why am I getting the error message from RGoogleDocs > getDocs(sheets.con) Error in getDocs(sheets.con) : problems connecting to get the list of documents How do I troubleshoot? Farrel Buchinsky

Re: [R] Reading from Google Docs

2009-11-25 Thread Farrel Buchinsky
Oh OH! Could you please help with a problem that I never used to get. library(RGoogleDocs) ps <-readline(prompt="get the password in ") sheets.con = getGoogleDocsConnection(getGoogleAuth("fjb...@gmail.com", ps, service ="wise")) ts2=getWorksheets("OnCall",sheets.con) Those opening lines of script

Re: [R] Reading from Google Docs

2009-11-25 Thread Farrel Buchinsky
That was painless. I had already installed Rtools and had already put it on my path. Your line worked very well. [Thanks for telling me. However I did it last time was worse than sticking daggers in my eyes. ] install.packages( "RGoogleDocs", repos="http://www.omegahat.org/R";, type="source" ) I

Re: [R] Reading from Google Docs

2009-11-25 Thread Charlie Sharpsteen
On Wed, Nov 25, 2009 at 12:02 PM, Farrel Buchinsky wrote: > I reinstalled from a binary that Duncan Temple Lang placed in omegahat. I > see that omegahat has a subdirectory for each version of R. There is not a > directory for 2.10. I took the liberty of taking it from the 2.9 directory. That exp

Re: [R] Reading from Google Docs

2009-11-25 Thread Charlie Sharpsteen
On Wed, Nov 25, 2009 at 5:39 AM, Farrel Buchinsky wrote: > I recently installed R 2.10 > > Now I get > >> library(RGoogleDocs) > Loading required package: RCurl > Loading required package: bitops > Loading required package: XML > > Attaching package: 'RGoogleDocs' > > >        The following object

Re: [R] Reading from Google Docs

2009-11-25 Thread David M Smith
If your goal is solely to download data from a Google Spreadsheet into R, it is possible to configure the Google Docs access so that only read.csv is needed. The details are here: http://blog.revolution-computing.com/2009/09/how-to-use-a-google-spreadsheet-as-data-in-r.html But if you need any of

Re: [R] Reading from Google Docs

2009-11-25 Thread Farrel Buchinsky
I recently installed R 2.10 Now I get > library(RGoogleDocs) Loading required package: RCurl Loading required package: bitops Loading required package: XML Attaching package: 'RGoogleDocs' The following object(s) are masked from package:methods : getAccess Warning message: p

Re: [R] Reading from Google Docs

2009-07-09 Thread Johannes Huesing
Gabor Grothendieck [Wed, Jul 08, 2009 at 10:31:30PM CEST]: [...] > >>> > >>>    [[alternative HTML version deleted]] > > __ > R-help@r-project.org mailing list > https://stat.et

Re: [R] Reading from Google Docs

2009-07-09 Thread Duncan Temple Lang
Thanks for pointing that out. Yes, the link on the package web site was for 0.2-1 and that was the one used to build the binary for Windows. Now updated in both places and the binary repository will give 0.2-2. How to find the version of an installed package? packageDescription("RGoogleDocs")

Re: [R] Reading from Google Docs

2009-07-08 Thread Farrel Buchinsky
Dear Duncan On my home computer I was able to use install.packages("RGoogleDocs", repos = "http://www.omegahat.org/R";) But, alas it would not read the data in the spreadsheet. It went back to its nasty ways Error in !includeEmpty : invalid argument type That is what I was getting with version 0

Re: [R] Reading from Google Docs

2009-07-08 Thread Duncan Temple Lang
Farrel Buchinsky wrote: > Boy oh boy that process of getting source to binary was super painful. Now that I have the package as binary I can share the whole folder with my coworker and she is able to use RGoogleDocs. I intend to use the same process for the other two windows machines

Re: [R] Reading from Google Docs

2009-07-08 Thread Gabor Grothendieck
No one really knows how many people are being affected. Also one can minimize the impact like this: 1. In Rtools, change find.exe to find2.exe. 2. In R, create a 'find' a variable in any script using find and at the top check for find2 and if found set the find variable to find2 otherwise set it

Re: [R] Reading from Google Docs

2009-07-08 Thread Duncan Murdoch
On 7/8/2009 3:39 PM, Gabor Grothendieck wrote: I understand what you wrote. Its just that I don't agree that that is a reasonable solution. What is wanted is something that works safely out of the box, not something with a built in danger that every single person that uses it must fix (and know

Re: [R] Reading from Google Docs

2009-07-08 Thread Gabor Grothendieck
I understand what you wrote. Its just that I don't agree that that is a reasonable solution. What is wanted is something that works safely out of the box, not something with a built in danger that every single person that uses it must fix (and know about it to fix) in order to maintain the integri

Re: [R] Reading from Google Docs

2009-07-08 Thread Duncan Murdoch
On 7/8/2009 3:18 PM, Gabor Grothendieck wrote: To my mind its pretty serious that Rtools can make other software not work and the importance of using the word find in the tools is close to zero. Most people never even look at the scripts. You didn't read what I wrote. It could be called anyth

Re: [R] Reading from Google Docs

2009-07-08 Thread Gabor Grothendieck
To my mind its pretty serious that Rtools can make other software not work and the importance of using the word find in the tools is close to zero. Most people never even look at the scripts. Why don't you just rename find.exe to find2.exe, say, in Rtools and adjust the other files accordingly. F

Re: [R] Reading from Google Docs

2009-07-08 Thread Farrel Buchinsky
Hooray! I got it to work. Here is what I think happened.My hold up was that the tar command was not working. If you recall, when I issued the command: tar xvfz RgoogleDocs_0.2.2-src.tar.gz cmd.exe told me it could not be found I reran Rtools29.exe which is the Rtools setup program which offered to

Re: [R] Reading from Google Docs

2009-07-08 Thread Farrel Buchinsky
Does changing the path in Windows work in real time or does one need to restart the computer for the changes to take effect. Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, Jul 8, 2009 at 12:04, Gabor Grothendieck wrote: > Its safer just to temporarily add it to your path. > > Unfortu

Re: [R] Reading from Google Docs

2009-07-08 Thread Duncan Murdoch
On 08/07/2009 12:04 PM, Gabor Grothendieck wrote: Its safer just to temporarily add it to your path. Unfortunately Rtools has a find command that conflicts with the find command in Windows so if you add the Rtools bin directory to your path permanently then you could find other programs stop wor

Re: [R] Reading from Google Docs

2009-07-08 Thread William Dunlap
> -Original Message- > From: r-help-boun...@r-project.org > [mailto:r-help-boun...@r-project.org] On Behalf Of Gabor Grothendieck > Sent: Wednesday, July 08, 2009 9:04 AM > To: Duncan Murdoch > Cc: R; Uwe Ligges; Farrel Buchinsky > Subject: Re: [R] Reading from Googl

Re: [R] Reading from Google Docs

2009-07-08 Thread Gabor Grothendieck
Its safer just to temporarily add it to your path. Unfortunately Rtools has a find command that conflicts with the find command in Windows so if you add the Rtools bin directory to your path permanently then you could find other programs stop working. That actually happened to me once and it took

Re: [R] Reading from Google Docs

2009-07-08 Thread Duncan Murdoch
On 08/07/2009 10:13 AM, Farrel Buchinsky wrote: Forgive my naivte, but how do I make windows find tar. In other words from where do I issue the command and what is the command. You need to install the toolset, and let the installer set your path. Duncan Murdoch Farrel Buchinsky Google Voice

Re: [R] Reading from Google Docs

2009-07-08 Thread Farrel Buchinsky
Forgive my naivte, but how do I make windows find tar. In other words from where do I issue the command and what is the command. Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, Jul 8, 2009 at 10:09, Duncan Murdoch wrote: > On 08/07/2009 10:02 AM, Farrel Buchinsky wrote: > >> I have

Re: [R] Reading from Google Docs

2009-07-08 Thread Duncan Murdoch
On 08/07/2009 10:02 AM, Farrel Buchinsky wrote: I have previously read "R Installation and Administration". I read it again. It does not help me The relevant paragraph is below. But I need lower level instructions. Where can I find them. Follow the link. If Windows can't find tar, your toolse

Re: [R] Reading from Google Docs

2009-07-08 Thread Farrel Buchinsky
I have previously read "R Installation and Administration". I read it again. It does not help me The relevant paragraph is below. But I need lower level instructions. Where can I find them. R CMD INSTALL works in Windows to install source packages if you have the source-code package files (option

Re: [R] Reading from Google Docs

2009-06-19 Thread Uwe Ligges
See the manual "R Installation and Administration" for information on how to install source packages on Windows. Uwe Ligges Farrel Buchinsky wrote: After issuing tar xvfz RgoogleDocs_0.2.2-src.tar.gzI am getting an error message 'tar' is not recongnized as an internal or external command, oper

Re: [R] Reading from Google Docs

2009-06-19 Thread Farrel Buchinsky
After issuing tar xvfz RgoogleDocs_0.2.2-src.tar.gzI am getting an error message 'tar' is not recongnized as an internal or external command, operable program or batch file. Should I use my 7-zip to open up the archive? Where should I be doing this? For instance can I do it all in my download dire

Re: [R] Reading from Google Docs

2009-06-18 Thread Gabor Grothendieck
I have haven't neen following this thread but: 1. if RGoogleDocs_0.2-2.tar.gz is a source distribution (as opposed to built source) then the first line renames it so that its not the same name as the built file about to be created. The second line detars it into the RGoogleDocs directory. The thi

Re: [R] Reading from Google Docs

2009-06-18 Thread Farrel Buchinsky
What do you mean by "cd the.directory.containing.RGoogleDocs" Do you mean the directory where I downloaded the RGoogleDocs_0.2-2.tar.gz to? Or do you mean that I must create a directory called RGoogleDocs under Library and then change to that directory? Farrel Buchinsky Google Voice Tel: (412) 567-

Re: [R] Reading from Google Docs

2009-06-18 Thread Farrel Buchinsky
The first time I did it I had no idea how I did it. Yesterday I struggled and tried every combination to get it to work and eventually it worked. Once again I do not know what I did to get it to work. Now today I am trying to install a version that I downloaded today. And once again I am banging my

Re: [R] Reading from Google Docs

2009-03-31 Thread Farrel Buchinsky
It worked. Thank you Gabor Grothendieck. I have very little idea of what I did but I did it and it works. It is working well when I limit getDocs to documents only. However if I include everything in my request or just limit it to spreadsheets I get the following error. getDocs(con, what = "http

Re: [R] Reading from Google Docs

2009-03-02 Thread Gabor Grothendieck
Download and install each of R, Rtools and MiKTeX. Each of these have automated installers so its just a matter of pressing Enter repeatedly. You don't have to change your path if you place Rcmd.bat from http://batchfiles.googlecode.com anywhere on your path (so it can be found). To see your path

Re: [R] Reading from Google Docs

2009-03-02 Thread Farrel Buchinsky
I was able to extract RGoogleDocs with 7-zip. That was when I began to appreciate the gravity of what Prof Ripley was saying. I am on a windows xp machine and the RGoogleDocs download does not have a windows binary version. Instead it has only a source package. I started using the R-admin manual to

Re: [R] Reading from Google Docs

2008-12-15 Thread Farrel Buchinsky
I took the liberty of replacing all the xmlParse in auth.R with xmlTreeParse. Alas still no joy. getDocs(con) Error in UseMethod("xpathApply") : no applicable method for "xpathApply" Farrel Buchinsky GrandCentral Tel: (412) 567-7870 On Mon, Dec 15, 2008 at 20:00, Farrel Buchinsky wrote: > I ha

Re: [R] Reading from Google Docs

2008-12-15 Thread Farrel Buchinsky
I have loaded the XML package. Should the function not be xmlTreeParse? Look at this > library(XML) > help(xmlParse) No documentation for 'xmlParse' in specified packages and libraries: you could try 'help.search("xmlParse")' > help.search("xmlParse") Help files with alias or concept or title ma

Re: [R] Reading from Google Docs

2008-12-15 Thread Duncan Temple Lang
Farrel Buchinsky wrote: When I run>getDocs(con) I get this error: Error in getDocs(con) : could not find function "xmlParse" Where should xmlParse be coming from? From the XML package. You had asked where I got the idea to enter "con$getDocs()". I got it from run.html. But now that you

Re: [R] Reading from Google Docs

2008-12-15 Thread Farrel Buchinsky
When I run>getDocs(con) I get this error: Error in getDocs(con) : could not find function "xmlParse" Where should xmlParse be coming from? You had asked where I got the idea to enter "con$getDocs()". I got it from run.html. But now that you bring the words "In the future, we might" to my attenti

Re: [R] Reading from Google Docs

2008-12-15 Thread Duncan Temple Lang
Farrel Buchinsky wrote: Great. I have previously installed 7zip. It worked well. I installed the files. See below (way below). When I entered >library(RGoogleDocs) it did not run. So I just ran auth.R Then I was able to run auth <-getGoogleAuth("fjb...@gmail.com","mypassword") con = getConnec

Re: [R] Reading from Google Docs

2008-12-15 Thread Farrel Buchinsky
Great. I have previously installed 7zip. It worked well. I installed the files. See below (way below). When I entered >library(RGoogleDocs) it did not run. So I just ran auth.R Then I was able to run auth <-getGoogleAuth("fjb...@gmail.com","mypassword") con = getConnection(auth) con$getDocs() all

Re: [R] Reading from Google Docs

2008-12-15 Thread Prof Brian Ripley
On Mon, 15 Dec 2008, Farrel Buchinsky wrote: I saw a thread from September 24 in which Duncan Temple Lang told us: - The package currently has no Rd files, but there is a brief "user's guide". The package is available from http://www.omegahat.org/RGoogleDocs I could not find it by using

Re: [R] Reading from Google Docs

2008-12-15 Thread Gustavo Carvalho
Hello, You can probably extract a .tar.gz using 7zip on Windows. Regards, Gustavo. On Mon, Dec 15, 2008 at 8:07 PM, Farrel Buchinsky wrote: > I saw a thread from September 24 in which Duncan Temple Lang told us: > - The package currently has no Rd files, but there is a brief "user's > guide".

[R] Reading from Google Docs

2008-12-15 Thread Farrel Buchinsky
I saw a thread from September 24 in which Duncan Temple Lang told us: - The package currently has no Rd files, but there is a brief "user's guide". The package is available from http://www.omegahat.org/RGoogleDocs I could not find it by using Tinn-R or RGui's package install tool. Then wh