An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20090302/53ee0a62/attachment-0002.pl>
Reading from Google Docs
3 messages · Farrel Buchinsky, 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 try this from the Windows console: path Finally enter into the Windows console: cd the.directory.containing.RGoogleDocs Rcmd build RGoogleDocs Rcmd INSTALL RGoogleDocs_1.0.0.tar.gz except replace RGoogleDocs_1.0.0.tar.gz with the filename created by the build. It should now be installed.
On Mon, Mar 2, 2009 at 8:59 PM, Farrel Buchinsky <fjbuch at gmail.com> wrote:
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 step through the process and got nowhere in about 45 minutes. Then I tried using the "automated package building service<http://win-builder.r-project.org/>you could try." and got nowhere because I did not know what "R CMD build" is. Can I find someone to do it for me or can I find someone who will give me a couple of basic steps at a time? I am desperate to say goodbye to individual static Microsoft Access or Microsoft Excel spreadsheets being the repository for my data. Farrel Buchinsky Sent from: Pittsburgh Pennsylvania United States.
Yes, you can install source packages on Windows: the R-admin manual gives you a detailed guide to the tools that you will need to do so. ?It even tells you about an automated package building service you could try. RGoogleDocs depends on RCurl and XML, both of which I provide Windows binaries for (and are much trickier to install because of their external software requirements). ?Farrel Buchinsky
GrandCentral Tel: (412) 567-7870
-- Brian D. Ripley, ? ? ? ? ? ? ? ? ?ripley at stats.ox.ac.uk Professor of Applied Statistics, ?http://www.stats.ox.ac.uk/~ripley/ University of Oxford, ? ? ? ? ? ? Tel: ?+44 1865 272861 (self) 1 South Parks Road, ? ? ? ? ? ? ? ? ? ? +44 1865 272866 (PA) Oxford OX1 3TG, UK ? ? ? ? ? ? ? ?Fax: ?+44 1865 272595
? ? ? ?[[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.
28 days later
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://docs.google.com/feeds/documents/private/full/-/spreadsheet") assignment of an object of class "NULL" is not valid for slot "access" in an object of class "GoogleSpreadsheet"; is(value, "character") is not TRUE Tried google searching and got nowhere. Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Mon, Mar 2, 2009 at 22:16, Gabor Grothendieck
<ggrothendieck at gmail.com> wrote:
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 try this from the Windows console: path Finally enter into the Windows console: cd the.directory.containing.RGoogleDocs Rcmd build RGoogleDocs Rcmd INSTALL RGoogleDocs_1.0.0.tar.gz except replace RGoogleDocs_1.0.0.tar.gz with the filename created by the build. It should now be installed. On Mon, Mar 2, 2009 at 8:59 PM, Farrel Buchinsky <fjbuch at gmail.com> wrote:
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 step through the process and got nowhere in about 45 minutes. Then I tried using the "automated package building service<http://win-builder.r-project.org/>you could try." and got nowhere because I did not know what "R CMD build" is. Can I find someone to do it for me or can I find someone who will give me a couple of basic steps at a time? I am desperate to say goodbye to individual static Microsoft Access or Microsoft Excel spreadsheets being the repository for my data. Farrel Buchinsky Sent from: Pittsburgh Pennsylvania United States.
Yes, you can install source packages on Windows: the R-admin manual gives you a detailed guide to the tools that you will need to do so. ?It even tells you about an automated package building service you could try. RGoogleDocs depends on RCurl and XML, both of which I provide Windows binaries for (and are much trickier to install because of their external software requirements). ?Farrel Buchinsky
GrandCentral Tel: (412) 567-7870
-- Brian D. Ripley, ? ? ? ? ? ? ? ? ?ripley at stats.ox.ac.uk Professor of Applied Statistics, ?http://www.stats.ox.ac.uk/~ripley/ University of Oxford, ? ? ? ? ? ? Tel: ?+44 1865 272861 (self) 1 South Parks Road, ? ? ? ? ? ? ? ? ? ? +44 1865 272866 (PA) Oxford OX1 3TG, UK ? ? ? ? ? ? ? ?Fax: ?+44 1865 272595
? ? ? ?[[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.