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
change my path. However it still did not work. I went to lunch and took the
opportunity to reboot my computer.

When I retried after lunch the tar command worked and everything thereafter
worked. I think that the file C:\Program Files\R\Rtools\bin\tar.exe could
not be found earlier. I just looked back at my path and I see
that C:\Program Files\R\Rtools\bin is on the path.

RgoogleDocs 0.2-2 is amazing. I can now read data straight into a dataframe.
The fact that I am always reading from realtime data is astounding.

sheets.con = getGoogleDocsConnection(getGoogleAuth("fjbuch@gmail.com",
"password here", service = "wise"))
ts2=getWorksheets("Consents Received",sheets.con)# put the name of the
spreadsheet in the inverted commas
names(ts2)
sheetAsMatrix(ts2$Sheet1,header=TRUE, as.data.frame=TRUE, trim=TRUE)

MAGIC

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 that I use. I really do not want
to go through the same installation and path hassles all over again.

Should I post my directory containing the binary files somewhere so that
others do not have to experience pain. Does etiquette dictate that I should
post the directory to help other or does etiquette dictate that it is Duncan
Temple Lang's code and thus it his prerogative to distribute his work as he
wishes?

Farrel Buchinsky
Google Voice Tel: (412) 567-7870



On Wed, Jul 8, 2009 at 12:59, Farrel Buchinsky <fjbuch@gmail.com> wrote:

> 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 <ggrothendieck@gmail.com>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 working.  That actually happened
>> to me once and it took the longest time until I discovered
>> that Rtools was the culprit.
>>
>> If you follow the advice I gave you normally won't have
>> that problem.
>>
>> On Wed, Jul 8, 2009 at 11:21 AM, Duncan Murdoch<murdoch@stats.uwo.ca>
>> wrote:
>> > 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 Tel: (412) 567-7870
>> >>
>> >>
>> >>
>> >> On Wed, Jul 8, 2009 at 10:09, Duncan Murdoch <murdoch@stats.uwo.ca>
>> wrote:
>> >>
>> >>> 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 toolset is installed
>> >>> incorrectly.
>> >>>
>> >>> Duncan Murdoch
>> >>>
>> >>>
>> >>>> R CMD INSTALL works in Windows to install source packages if you have
>> >>>> the
>> >>>> source-code package files (option “Source Package Installation Files”
>> in
>> >>>> the
>> >>>> installer) and toolset (see The Windows
>> >>>>
>> >>>>
>> >>>>
>> toolset<file:///C:/Program%20Files/R/R-2.9.1/doc/manual/R-admin.html#The-Windows-toolset>)
>> >>>>
>> >>>> installed. Installation of binary packages must be done by
>> >>>> install.packages
>> >>>> . R CMD INSTALL --help will tell you the current options under
>> Windows
>> >>>> (which differ from those on a Unix-alike): in particular there is a
>> >>>> choice
>> >>>> of the types of documentation to be installed.
>> >>>> Farrel Buchinsky
>> >>>> Google Voice Tel: (412) 567-7870
>> >>>>
>> >>>>
>> >>>>
>> >>>> 2009/6/19 Uwe Ligges <ligges@statistik.tu-dortmund.de>
>> >>>>
>> >>>>  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,
>> 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 directory or should I do it in C:\Program
>> >>>>>> Files\R\R-2.9.0\library or should I manually create C:\Program
>> >>>>>> Files\R\R-2.9.0\library\RGoogleDocs and do it all there or will the
>> >>>>>> Rcmd
>> >>>>>> INSTALL RGoogleDocs_0.2-2.tar.gz command do that for me.
>> >>>>>>
>> >>>>>> Yes, you assumed correctly. I am using Windows XP.
>> >>>>>> Farrel Buchinsky
>> >>>>>> Google Voice Tel: (412) 567-7870
>> >>>>>>
>> >>>>>>
>> >>>>>>
>> >>>>>> On Thu, Jun 18, 2009 at 20:17, Gabor Grothendieck
>> >>>>>> <ggrothendieck@gmail.com>wrote:
>> >>>>>>
>> >>>>>>  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
>> third
>> >>>>>>> builds
>> >>>>>>> the built source file, RGoogleDocs_0.2-2.tar.gz.  The fourth
>> >>>>>>> installs the built source file into R.  I've assumed Windows.
>> >>>>>>> If you are on Linux replace rename with mv.
>> >>>>>>>
>> >>>>>>> rename RGoogleDocs_0.2-2.tar.gz RgoogleDocs_0.2.2-src.tar.gz
>> >>>>>>> tar xvfz RgoogleDocs_0.2.2-src.tar.gz
>> >>>>>>> Rcmd build RGoogleDocs
>> >>>>>>> Rcmd INSTALL RGoogleDocs_0.2-2.tar.gz
>> >>>>>>>
>> >>>>>>> or
>> >>>>>>>
>> >>>>>>> 2. if RGoogleDocs_0.2-2.tar.gz is already a built source file then
>> >>>>>>> you
>> >>>>>>> can just issue the last of the above lines and don't need
>> >>>>>>> the others.
>> >>>>>>>
>> >>>>>>> On Thu, Jun 18, 2009 at 7:52 PM, Farrel Buchinsky<
>> fjbuch@gmail.com>
>> >>>>>>> wrote:
>> >>>>>>>
>> >>>>>>>  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-7870
>> >>>>>>>>
>> >>>>>>>>
>> >>>>>>>>
>> >>>>>>>> On Mon, Mar 2, 2009 at 22:16, Gabor Grothendieck <
>> >>>>>>>>
>> >>>>>>>>  ggrothendieck@gmail.com>
>> >>>>>>>
>> >>>>>>>  wrote:
>> >>>>>>>>
>> >>>>>>>>  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.
>> >>>>>>>>>
>> >>>>>>>>>       [[alternative HTML version deleted]]
>> >>>>>>
>> >>>>>> ______________________________________________
>> >>>>>> R-help@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.
>> >>>>>>
>> >>>>>>
>> >>>>       [[alternative HTML version deleted]]
>> >>>>
>> >>>>
>> >>>>
>> >>>>
>> ------------------------------------------------------------------------
>> >>>>
>> >>>> ______________________________________________
>> >>>> R-help@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.
>> >>>>
>> >>>
>> >>
>> >>        [[alternative HTML version deleted]]
>> >>
>> >>
>> >>
>> >>
>> ------------------------------------------------------------------------
>> >>
>> >> ______________________________________________
>> >> R-help@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.
>> >
>> > ______________________________________________
>> > R-help@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.
>> >
>>
>
>

	[[alternative HTML version deleted]]


