[R] Reading from Google Docs

[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://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.
> >