Re: [R] Reading from Google Docs
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 fjb...@gmail.com wrote:
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 currently able to read
spreadsheets into R the way you used to?
library(RGoogleDocs)
ps -readline(prompt=get the password in )
sheets.con = getGoogleDocsConnection(getGoogleAuth(fjb...@gmail.com, ps,
service =wise))
ts2=getWorksheets(OnCall,sheets.con)
Error in getDocs(con) : problems connecting to get the list of documents
I used options(error = recover) to troubleshoot but alas I am none the
wiser (no pun intended). I am pasting the output here. Can you see where the
problem is coming from? [By the way, I changed my script temporarily to
service=writely and the getDocs command worked. If I remember correctly
RGoogleDocs had a problem about 6 months ago whereby one could list the
documents but not the spreadsheets and then you fixed it. ]
Enter a frame number, or 0 to exit
1: getWorksheets(OnCall, sheets.con)
2: getDocs(con)
Selection: 2
Called from: eval(expr, envir, enclos)
Browse[1] objects()
[1] as.data.frame auth curl folders h
statuswhat x
Browse[1] body()
{
if (what %in% names(GoogleURLs))
what = GoogleURLs[what]
else if (is(curl, GoogleSpreadsheetsConnection))
what = GoogleURLs[spreadsheets]
curlSetOpt(customrequest = GET, curl = curl)
h = basicTextGatherer()
if (folders)
what = paste(what, showfolders=true, sep = ?)
x = getURL(what, curl = curl, headerfunction = h$update,
followlocation = TRUE, ...)
status = parseHTTPHeader(h$value())
if (floor(as.numeric(status[[status]])/100) != 2)
stop(problems connecting to get the list of documents)
doc = xmlParse(x, asText = TRUE)
if (toupper(xmlName(xmlRoot(doc))) == HTML)
stop(Can't get document list. Is the connection still valid?
Perhaps initialize a new connection.)
convertDocList(doc, curl, as.data.frame)
}
Browse[1] status
WWW-Authenticate
Content-Type
GoogleLogin realm=\http://www.google.com/accounts/ClientLogin\;,
service=\writely\
text/html; charset=UTF-8
Date
Expires
Sat, 28 Nov 2009
19:04:22 GMT Sat,
28 Nov 2009 19:04:22 GMT
Cache-Control
X-Content-Type-Options
private, max-age=0
nosniff
X-XSS-Protection
X-Frame-Options
0
SAMEORIGIN
Server
Transfer-Encoding
GFE/2.0
chunked
status
statusMessage
401
Token invalid
Farrel Buchinsky
Google Voice Tel: (412) 567-7870
On Sat, Nov 28, 2009 at 12:45, Duncan Temple Lang dun...@wald.ucdavis.edu
wrote:
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
You are using a connection to the wise service (for worksheets)
to get the list of documents from the document service.
If you call getDocs() with an connection to writely, I
imagine it will succeed.
So you have a token, but it is for the wrong thing.
How do I troubleshoot?
The first thing is to learn about debugging in R.
For example,
options(error = recover)
getDocs(sheets.con)
The error occurs and you are presented with a menu prompt that allows you
to select the call frame of interest. There is only one - getDocs().
Enter 1 Return. Now you have an R prompt that allows you to explore
the call frame.
objects()
body()
Take a look at status
status
WWW-Authenticate
GoogleLogin realm=\http://www.google.com/accounts/ClientLogin\;,
service=\writely\
Content-Type
text/html;
charset=UTF-8
Date
Sat, 28 Nov 2009
17:36:16 GMT
Expires
Sat, 28 Nov 2009
17:36:16 GMT
Cache-Control
private, max-age=0
X-Content-Type-Options
nosniff
X-XSS-Protection
0
X-Frame-Options
SAMEORIGIN
Server
GFE/2.0
Transfer-Encoding
chunked
status
401
statusMessage
Token invalid
This is the parsed
Re: [R] Reading from Google Docs
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 Google Voice Tel: (412) 567-7870 On Wed, Nov 25, 2009 at 17:08, Farrel Buchinsky fjb...@gmail.com wrote: 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 used to work flawlesly. Now I get. Error in getDocs(con) : problems connecting to get the list of documents Yet I got it to work earlier while I had been toying with RGoogleData package in another session. Could RGoogleData have opened something for RGoogleDocs to use? Farrel Buchinsky Google Voice Tel: (412) 567-7870 Sent from Pittsburgh, Pennsylvania, United States On Wed, Nov 25, 2009 at 16:34, Farrel Buchinsky fjb...@gmail.com wrote: 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 now have Package: RGoogleDocs Version: 0.4-0 Title: Maintainer: Duncan Temple Lang dun...@wald.ucdavis.edu Packaged: 2009-10-27 22:10:22 UTC; duncan Built: R 2.10.0; ; 2009-11-25 20:59:03 UTC; windows I am providing the following link to a copy of my RGoogleDocs zipped directory. It is for people who run R in windows and do not want to go through the pain of setting things up so that they can install source. http://dl.dropbox.com/u/23200/RGoogleDocs/RGoogleDocs.zip I BELIEVE that if one downloads the zip and extracts it to an empty directory called RGoogleDocs in one's Library directory then everything will work. Please let me know. Farrel Buchinsky Google Voice Tel: (412) 567-7870 [[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.
Re: [R] Reading from Google Docs
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 You are using a connection to the wise service (for worksheets) to get the list of documents from the document service. If you call getDocs() with an connection to writely, I imagine it will succeed. So you have a token, but it is for the wrong thing. How do I troubleshoot? The first thing is to learn about debugging in R. For example, options(error = recover) getDocs(sheets.con) The error occurs and you are presented with a menu prompt that allows you to select the call frame of interest. There is only one - getDocs(). Enter 1 Return. Now you have an R prompt that allows you to explore the call frame. objects() body() Take a look at status status WWW-Authenticate GoogleLogin realm=\http://www.google.com/accounts/ClientLogin\;, service=\writely\ Content-Type text/html; charset=UTF-8 Date Sat, 28 Nov 2009 17:36:16 GMT Expires Sat, 28 Nov 2009 17:36:16 GMT Cache-Control private, max-age=0 X-Content-Type-Options nosniff X-XSS-Protection 0 X-Frame-Options SAMEORIGIN Server GFE/2.0 Transfer-Encoding chunked status 401 statusMessage Token invalid This is the parsed header of the reply from the GoogleDocs server. x contains the result of the query and it is an HTML document with the (same) error message. Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, Nov 25, 2009 at 17:08, Farrel Buchinsky fjb...@gmail.com wrote: 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 used to work flawlesly. Now I get. Error in getDocs(con) : problems connecting to get the list of documents Yet I got it to work earlier while I had been toying with RGoogleData package in another session. Could RGoogleData have opened something for RGoogleDocs to use? Farrel Buchinsky Google Voice Tel: (412) 567-7870 Sent from Pittsburgh, Pennsylvania, United States On Wed, Nov 25, 2009 at 16:34, Farrel Buchinsky fjb...@gmail.com wrote: 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 now have Package: RGoogleDocs Version: 0.4-0 Title: Maintainer: Duncan Temple Lang dun...@wald.ucdavis.edu Packaged: 2009-10-27 22:10:22 UTC; duncan Built: R 2.10.0; ; 2009-11-25 20:59:03 UTC; windows I am providing the following link to a copy of my RGoogleDocs zipped directory. It is for people who run R in windows and do not want to go through the pain of setting things up so that they can install source. http://dl.dropbox.com/u/23200/RGoogleDocs/RGoogleDocs.zip I BELIEVE that if one downloads the zip and extracts it to an empty directory called RGoogleDocs in one's Library
Re: [R] Reading from Google Docs
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 currently able to read
spreadsheets into R the way you used to?
library(RGoogleDocs)
ps -readline(prompt=get the password in )
sheets.con = getGoogleDocsConnection(getGoogleAuth(fjb...@gmail.com, ps,
service =wise))
ts2=getWorksheets(OnCall,sheets.con)
Error in getDocs(con) : problems connecting to get the list of documents
I used options(error = recover) to troubleshoot but alas I am none the wiser
(no pun intended). I am pasting the output here. Can you see where the
problem is coming from? [By the way, I changed my script temporarily to
service=writely and the getDocs command worked. If I remember correctly
RGoogleDocs had a problem about 6 months ago whereby one could list the
documents but not the spreadsheets and then you fixed it. ]
Enter a frame number, or 0 to exit
1: getWorksheets(OnCall, sheets.con)
2: getDocs(con)
Selection: 2
Called from: eval(expr, envir, enclos)
Browse[1] objects()
[1] as.data.frame auth curl folders h
statuswhat x
Browse[1] body()
{
if (what %in% names(GoogleURLs))
what = GoogleURLs[what]
else if (is(curl, GoogleSpreadsheetsConnection))
what = GoogleURLs[spreadsheets]
curlSetOpt(customrequest = GET, curl = curl)
h = basicTextGatherer()
if (folders)
what = paste(what, showfolders=true, sep = ?)
x = getURL(what, curl = curl, headerfunction = h$update,
followlocation = TRUE, ...)
status = parseHTTPHeader(h$value())
if (floor(as.numeric(status[[status]])/100) != 2)
stop(problems connecting to get the list of documents)
doc = xmlParse(x, asText = TRUE)
if (toupper(xmlName(xmlRoot(doc))) == HTML)
stop(Can't get document list. Is the connection still valid?
Perhaps initialize a new connection.)
convertDocList(doc, curl, as.data.frame)
}
Browse[1] status
WWW-Authenticate
Content-Type
GoogleLogin realm=\http://www.google.com/accounts/ClientLogin\;,
service=\writely\
text/html; charset=UTF-8
Date
Expires
Sat, 28 Nov 2009
19:04:22 GMT Sat,
28 Nov 2009 19:04:22 GMT
Cache-Control
X-Content-Type-Options
private,
max-age=0
nosniff
X-XSS-Protection
X-Frame-Options
0
SAMEORIGIN
Server
Transfer-Encoding
GFE/2.0
chunked
status
statusMessage
401
Token invalid
Farrel Buchinsky
Google Voice Tel: (412) 567-7870
On Sat, Nov 28, 2009 at 12:45, Duncan Temple Lang
dun...@wald.ucdavis.eduwrote:
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
You are using a connection to the wise service (for worksheets)
to get the list of documents from the document service.
If you call getDocs() with an connection to writely, I
imagine it will succeed.
So you have a token, but it is for the wrong thing.
How do I troubleshoot?
The first thing is to learn about debugging in R.
For example,
options(error = recover)
getDocs(sheets.con)
The error occurs and you are presented with a menu prompt that allows you
to select the call frame of interest. There is only one - getDocs().
Enter 1 Return. Now you have an R prompt that allows you to explore
the call frame.
objects()
body()
Take a look at status
status
WWW-Authenticate
GoogleLogin realm=\http://www.google.com/accounts/ClientLogin\;,
service=\writely\
Content-Type
text/html;
charset=UTF-8
Date
Sat, 28 Nov 2009
17:36:16 GMT
Expires
Sat, 28 Nov 2009
17:36:16 GMT
Cache-Control
private,
max-age=0
X-Content-Type-Options
nosniff
X-XSS-Protection
0
X-Frame-Options
SAMEORIGIN
Server
GFE/2.0
Transfer-Encoding
chunked
status
401
statusMessage
Token invalid
This is the parsed header of the reply from the GoogleDocs server.
x contains the result of the query and it is an HTML document with the
(same) error message.
Farrel Buchinsky
Google Voice Tel: (412) 567-7870
On Wed, Nov 25, 2009 at
Re: [R] Reading from Google Docs
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: package 'RGoogleDocs' was built under R version 2.9.1 and help will not work correctly Please re-install it But alas reinstalling it does not take away the error message. Farrel Buchinsky Google Voice Tel: (412) 567-7870 Sent from Pittsburgh, Pennsylvania, United States On Thu, Jul 9, 2009 at 08:15, Duncan Temple Lang dun...@wald.ucdavis.eduwrote: 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) D. Farrel Buchinsky wrote: 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.2-1.You then sent me link to 0.2-2 (in source code) which is what worked. Is it possible that that the windows binary version you put in omegahat was 0.2-1 and not 0.2-2? I did not know how to tell what version had been installed. Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, Jul 8, 2009 at 22:53, Duncan Temple Lang dun...@wald.ucdavis.edumailto: dun...@wald.ucdavis.edu wrote: 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 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? Etiquette is one thing and the license another. Both encourage you to help others and make the binary available to others. And indeed, I hope that Windows users do build binaries for others and remove the additional work from those who provide the software in the first place. Having seen this thread today, I did put a binary version of RGoogleDocs on the Omegahat repository so install.packages(RGoogleDocs, repos = http://www.omegahat.org/R;) should install it and, if I had had time earlier, saved you the hardship of building the binary. Sorry to do it so soon after. D. Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, Jul 8, 2009 at 12:59, Farrel Buchinsky fjb...@gmail.com mailto:fjb...@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 ggrothendi...@gmail.com mailto:ggrothendi...@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 Murdochmurd...@stats.uwo.ca mailto:murd...@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
Re: [R] Reading from Google Docs
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 the other functionality of RGoogleDocs, this isn't going to help I'm afraid. # David -- David M Smith da...@revolution-computing.com VP of Community, REvolution Computing http://blog.revolution-computing.com Tel: +1 (206) 577-4778 x3203 (Palo Alto, CA, USA) Download REvolution R free: www.revolution-computing.com/downloads/revolution-r.php On Wed, Nov 25, 2009 at 5:39 AM, Farrel Buchinsky fjb...@gmail.com 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(s) are masked from package:methods : getAccess Warning message: package 'RGoogleDocs' was built under R version 2.9.1 and help will not work correctly Please re-install it But alas reinstalling it does not take away the error message. Farrel Buchinsky Google Voice Tel: (412) 567-7870 [[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.
Re: [R] Reading from Google Docs
On Wed, Nov 25, 2009 at 5:39 AM, Farrel Buchinsky fjb...@gmail.com 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(s) are masked from package:methods : getAccess Warning message: package 'RGoogleDocs' was built under R version 2.9.1 and help will not work correctly Please re-install it But alas reinstalling it does not take away the error message. Farrel Buchinsky How did you try reinstalling it? It sounds like you are using a binary distribution that was built under 2.9.1-- you probably have to build and install from a source distribution of the package. -Charlie __ 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.
Re: [R] Reading from Google Docs
On Wed, Nov 25, 2009 at 12:02 PM, Farrel Buchinsky fjb...@gmail.com 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 explains the warning message. Who knows what crime I committed. Is that first or third degree murder. Well, it's just a warning-- so it shouldn't be a show-stopper. And from what I see the warning is only referring to the package help pages, which are available online. It looks like the functionality of the package should still work just fine if you don't want to bother with a reinstall. I saw however that there is a far more recent version of RGoogleDocs (Last Release: 0.4-0 (27 Oct 2009)). But it is in tar.gz. I assume that it is in source. Once before I spent about 27000 hours getting a source to become a binary. I don't know how I finally got it right and am reluctant to wander into that swamp again. Farrel Buchinsky This shouldn't be extraordinarily difficult-- unfortunately Murphy's Law does come into play sometimes. But it should just be a matter of: install.packages( RGoogleDocs, repos=http://www.omegahat.org/R;, type=source ) And that's it for Linux, Mac OS or other UNIX-based system. With Windows you will first have to install the toolset available at: http://www.murdoch-sutherland.com/Rtools/ Grab the Rtools210 installer as you are using R 2.10.x. Install using the Package Authoring option and make sure you check any options that ask about modifying your PATH. Good luck! -Charlie __ 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.
Re: [R] Reading from Google Docs
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 now have Package: RGoogleDocs Version: 0.4-0 Title: Maintainer: Duncan Temple Lang dun...@wald.ucdavis.edu Packaged: 2009-10-27 22:10:22 UTC; duncan Built: R 2.10.0; ; 2009-11-25 20:59:03 UTC; windows I am providing the following link to a copy of my RGoogleDocs zipped directory. It is for people who run R in windows and do not want to go through the pain of setting things up so that they can install source. http://dl.dropbox.com/u/23200/RGoogleDocs/RGoogleDocs.zip I BELIEVE that if one downloads the zip and extracts it to an empty directory called RGoogleDocs in one's Library directory then everything will work. Please let me know. Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, Nov 25, 2009 at 15:15, Charlie Sharpsteen ch...@sharpsteen.netwrote: On Wed, Nov 25, 2009 at 12:02 PM, Farrel Buchinsky fjb...@gmail.com 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 explains the warning message. Who knows what crime I committed. Is that first or third degree murder. Well, it's just a warning-- so it shouldn't be a show-stopper. And from what I see the warning is only referring to the package help pages, which are available online. It looks like the functionality of the package should still work just fine if you don't want to bother with a reinstall. I saw however that there is a far more recent version of RGoogleDocs (Last Release: 0.4-0 (27 Oct 2009)). But it is in tar.gz. I assume that it is in source. Once before I spent about 27000 hours getting a source to become a binary. I don't know how I finally got it right and am reluctant to wander into that swamp again. Farrel Buchinsky This shouldn't be extraordinarily difficult-- unfortunately Murphy's Law does come into play sometimes. But it should just be a matter of: install.packages( RGoogleDocs, repos=http://www.omegahat.org/R;, type=source ) And that's it for Linux, Mac OS or other UNIX-based system. With Windows you will first have to install the toolset available at: http://www.murdoch-sutherland.com/Rtools/ Grab the Rtools210 installer as you are using R 2.10.x. Install using the Package Authoring option and make sure you check any options that ask about modifying your PATH. Good luck! -Charlie [[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.
Re: [R] Reading from Google Docs
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 used to work flawlesly. Now I get. Error in getDocs(con) : problems connecting to get the list of documents Yet I got it to work earlier while I had been toying with RGoogleData package in another session. Could RGoogleData have opened something for RGoogleDocs to use? Farrel Buchinsky Google Voice Tel: (412) 567-7870 Sent from Pittsburgh, Pennsylvania, United States On Wed, Nov 25, 2009 at 16:34, Farrel Buchinsky fjb...@gmail.com wrote: 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 now have Package: RGoogleDocs Version: 0.4-0 Title: Maintainer: Duncan Temple Lang dun...@wald.ucdavis.edu Packaged: 2009-10-27 22:10:22 UTC; duncan Built: R 2.10.0; ; 2009-11-25 20:59:03 UTC; windows I am providing the following link to a copy of my RGoogleDocs zipped directory. It is for people who run R in windows and do not want to go through the pain of setting things up so that they can install source. http://dl.dropbox.com/u/23200/RGoogleDocs/RGoogleDocs.zip I BELIEVE that if one downloads the zip and extracts it to an empty directory called RGoogleDocs in one's Library directory then everything will work. Please let me know. Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, Nov 25, 2009 at 15:15, Charlie Sharpsteen ch...@sharpsteen.netwrote: On Wed, Nov 25, 2009 at 12:02 PM, Farrel Buchinsky fjb...@gmail.com 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 explains the warning message. Who knows what crime I committed. Is that first or third degree murder. Well, it's just a warning-- so it shouldn't be a show-stopper. And from what I see the warning is only referring to the package help pages, which are available online. It looks like the functionality of the package should still work just fine if you don't want to bother with a reinstall. I saw however that there is a far more recent version of RGoogleDocs (Last Release: 0.4-0 (27 Oct 2009)). But it is in tar.gz. I assume that it is in source. Once before I spent about 27000 hours getting a source to become a binary. I don't know how I finally got it right and am reluctant to wander into that swamp again. Farrel Buchinsky This shouldn't be extraordinarily difficult-- unfortunately Murphy's Law does come into play sometimes. But it should just be a matter of: install.packages( RGoogleDocs, repos=http://www.omegahat.org/R;, type=source ) And that's it for Linux, Mac OS or other UNIX-based system. With Windows you will first have to install the toolset available at: http://www.murdoch-sutherland.com/Rtools/ Grab the Rtools210 installer as you are using R 2.10.x. Install using the Package Authoring option and make sure you check any options that ask about modifying your PATH. Good luck! -Charlie [[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.
Re: [R] Reading from Google Docs
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) D. Farrel Buchinsky wrote: 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.2-1.You then sent me link to 0.2-2 (in source code) which is what worked. Is it possible that that the windows binary version you put in omegahat was 0.2-1 and not 0.2-2? I did not know how to tell what version had been installed. Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, Jul 8, 2009 at 22:53, Duncan Temple Lang dun...@wald.ucdavis.edu mailto:dun...@wald.ucdavis.edu wrote: 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 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? Etiquette is one thing and the license another. Both encourage you to help others and make the binary available to others. And indeed, I hope that Windows users do build binaries for others and remove the additional work from those who provide the software in the first place. Having seen this thread today, I did put a binary version of RGoogleDocs on the Omegahat repository so install.packages(RGoogleDocs, repos = http://www.omegahat.org/R;) should install it and, if I had had time earlier, saved you the hardship of building the binary. Sorry to do it so soon after. D. Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, Jul 8, 2009 at 12:59, Farrel Buchinsky fjb...@gmail.com mailto:fjb...@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 ggrothendi...@gmail.com mailto:ggrothendi...@gmail.comwrote: 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 Murdochmurd...@stats.uwo.ca mailto:murd...@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 murd...@stats.uwo.ca mailto:murd...@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.
Re: [R] Reading from Google Docs
Gabor Grothendieck ggrothendi...@gmail.com [Wed, Jul 08, 2009 at 10:31:30PM CEST]: [...] [[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. __ 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. __ 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. Do you think more people will pay attention when you repeat this over and over? -- Johannes Hüsing There is something fascinating about science. One gets such wholesale returns of conjecture mailto:johan...@huesing.name from such a trifling investment of fact. http://derwisch.wikidot.com (Mark Twain, Life on the Mississippi) __ 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.
Re: [R] Reading from Google Docs
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 Source Package Installation Files in the installer) and toolset (see The Windows toolsetfile:///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 lig...@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 ggrothendi...@gmail.comwrote: 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 Buchinskyfjb...@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 ggrothendi...@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.
Re: [R] Reading from Google Docs
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 toolsetfile:///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 lig...@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 ggrothendi...@gmail.comwrote: 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 Buchinskyfjb...@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 ggrothendi...@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. __ 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.
Re: [R] Reading from Google Docs
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 murd...@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 toolsetfile:///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 lig...@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 ggrothendi...@gmail.comwrote: 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 Buchinskyfjb...@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 ggrothendi...@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.
Re: [R] Reading from Google Docs
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 murd...@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 toolsetfile:///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 lig...@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 ggrothendi...@gmail.comwrote: 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 Buchinskyfjb...@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 ggrothendi...@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
Re: [R] Reading from Google Docs
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 Murdochmurd...@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 murd...@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 toolsetfile:///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 lig...@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 ggrothendi...@gmail.comwrote: 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 Buchinskyfjb...@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 ggrothendi...@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
Re: [R] Reading from Google Docs
-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 Google Docs Its safer just to temporarily add it to your path. I recommend that also. Here is the SETPATH.BAT file that I put into my Rtools directory that sets up PATH so it can be used for building R and R packages. I run it from within the cmd window I will use for building packages. Note that it totally replaces the current value of PATH with a new one; it does not append or prepend entries to the existing one. You will have to adjust the entries for you own machine. It is safe to add other entries (like e:\cygwin\bin) to the end of this PATH, but you might run into trouble putting entries at the front of PATH. (I have a similar script to run before building packages for S+, whose package building system uses the Microsoft compilers and ActiveState perl but no cygwin tools.) E:\type e:\Rtools\SETPATH.BAT set RTOOLS=E:\Rtools REM RHOME is for use in this script, R_HOME will be set by R itself. set RHOME=E:\R-svn\r-devel set PATH=C:\WINDOWS\system32;C:\WINDOWS set PATH=%RTOOLS%\bin;%RTOOLS%\perl\bin;%RTOOLS%\MinGW\bin;%PATH% set PATH=%RHOME%\bin;%PATH% set PATH=%PATH%;E:\Program Files\MiKTeX 2.7\miktex\bin set PATH=%PATH%;E:\Program Files\Inno Setup 5 set PATH=%PATH%;C:\Program Files\HTML Help Workshop set PATH=%PATH%;E:\Program Files\CollabNet Subversion Server Bill Dunlap TIBCO Software Inc - Spotfire Division wdunlap tibco.com 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 Murdochmurd...@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 murd...@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 toolsetfile:///C:/Program%20Files/R/R-2.9.1/doc/manual/R-admi n.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 lig...@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 ggrothendi...@gmail.comwrote: 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
Re: [R] Reading from Google Docs
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 working. That actually happened to me once and it took the longest time until I discovered that Rtools was the culprit. That's true, but there is a workaround: you can manually rename the find.exe in Rtools, and adjust the entry in one of the R makefiles (MkRules), and it will use the new name instead of find. The reason you might not want to do this is you might expect find to act the way it does on Unix: the Rtools basically try to make Windows look a little bit like Unix. Duncan Murdoch If you follow the advice I gave you normally won't have that problem. On Wed, Jul 8, 2009 at 11:21 AM, Duncan Murdochmurd...@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 murd...@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 toolsetfile:///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 lig...@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 ggrothendi...@gmail.comwrote: 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 Buchinskyfjb...@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 ggrothendi...@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,
Re: [R] Reading from Google Docs
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 ggrothendi...@gmail.comwrote: 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 Murdochmurd...@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 murd...@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 toolsetfile:///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 lig...@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 ggrothendi...@gmail.comwrote: 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 Buchinskyfjb...@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 ggrothendi...@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
Re: [R] Reading from Google Docs
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(fjb...@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 fjb...@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 ggrothendi...@gmail.comwrote: 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 Murdochmurd...@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 murd...@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 toolsetfile:///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 lig...@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
Re: [R] Reading from Google Docs
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 anything as far as the scripts are concerned. I explained to you how to rename it and keep them happy. Duncan Murdoch Why don't you just rename find.exe to find2.exe, say, in Rtools and adjust the other files accordingly. For the small number of people who ever look at the scripts it will be obvious that we are dealing with a find variant and the danger and need for kludges is eliminated. On Wed, Jul 8, 2009 at 12:55 PM, Duncan Murdochmurd...@stats.uwo.ca wrote: 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 working. That actually happened to me once and it took the longest time until I discovered that Rtools was the culprit. That's true, but there is a workaround: you can manually rename the find.exe in Rtools, and adjust the entry in one of the R makefiles (MkRules), and it will use the new name instead of find. The reason you might not want to do this is you might expect find to act the way it does on Unix: the Rtools basically try to make Windows look a little bit like Unix. Duncan Murdoch If you follow the advice I gave you normally won't have that problem. On Wed, Jul 8, 2009 at 11:21 AM, Duncan Murdochmurd...@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 murd...@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 toolsetfile:///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 lig...@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 ggrothendi...@gmail.comwrote: 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 Buchinskyfjb...@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
Re: [R] Reading from Google Docs
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 integrity of their system. On Wed, Jul 8, 2009 at 3:30 PM, Duncan Murdochmurd...@stats.uwo.ca wrote: 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 anything as far as the scripts are concerned. I explained to you how to rename it and keep them happy. Duncan Murdoch Why don't you just rename find.exe to find2.exe, say, in Rtools and adjust the other files accordingly. For the small number of people who ever look at the scripts it will be obvious that we are dealing with a find variant and the danger and need for kludges is eliminated. On Wed, Jul 8, 2009 at 12:55 PM, Duncan Murdochmurd...@stats.uwo.ca wrote: 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 working. That actually happened to me once and it took the longest time until I discovered that Rtools was the culprit. That's true, but there is a workaround: you can manually rename the find.exe in Rtools, and adjust the entry in one of the R makefiles (MkRules), and it will use the new name instead of find. The reason you might not want to do this is you might expect find to act the way it does on Unix: the Rtools basically try to make Windows look a little bit like Unix. Duncan Murdoch If you follow the advice I gave you normally won't have that problem. On Wed, Jul 8, 2009 at 11:21 AM, Duncan Murdochmurd...@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 murd...@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 toolsetfile:///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 lig...@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 ggrothendi...@gmail.comwrote: 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
Re: [R] Reading from Google Docs
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. For the small number of people who ever look at the scripts it will be obvious that we are dealing with a find variant and the danger and need for kludges is eliminated. On Wed, Jul 8, 2009 at 12:55 PM, Duncan Murdochmurd...@stats.uwo.ca wrote: 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 working. That actually happened to me once and it took the longest time until I discovered that Rtools was the culprit. That's true, but there is a workaround: you can manually rename the find.exe in Rtools, and adjust the entry in one of the R makefiles (MkRules), and it will use the new name instead of find. The reason you might not want to do this is you might expect find to act the way it does on Unix: the Rtools basically try to make Windows look a little bit like Unix. Duncan Murdoch If you follow the advice I gave you normally won't have that problem. On Wed, Jul 8, 2009 at 11:21 AM, Duncan Murdochmurd...@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 murd...@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 toolsetfile:///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 lig...@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 ggrothendi...@gmail.comwrote: 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 Buchinskyfjb...@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
Re: [R] Reading from Google Docs
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 about it to fix) in order to maintain the integrity of their system. As far as I know, you are the only person in the whole world who has been affected by this. But fixing it would inconvenience hundreds of people, who would have to install a new version of Rtools, if the make system suddenly started looking for find2 instead of find. So it's unfortunate that Microsoft chose to use the name of the wrong Unix utility when they wrote find, and it's unfortunate that the first version of Rtools didn't fix this, but there you are: name clashes happen, and sometimes you need to work around them. Duncan Murdoch On Wed, Jul 8, 2009 at 3:30 PM, Duncan Murdochmurd...@stats.uwo.ca wrote: 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 anything as far as the scripts are concerned. I explained to you how to rename it and keep them happy. Duncan Murdoch Why don't you just rename find.exe to find2.exe, say, in Rtools and adjust the other files accordingly. For the small number of people who ever look at the scripts it will be obvious that we are dealing with a find variant and the danger and need for kludges is eliminated. On Wed, Jul 8, 2009 at 12:55 PM, Duncan Murdochmurd...@stats.uwo.ca wrote: 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 working. That actually happened to me once and it took the longest time until I discovered that Rtools was the culprit. That's true, but there is a workaround: you can manually rename the find.exe in Rtools, and adjust the entry in one of the R makefiles (MkRules), and it will use the new name instead of find. The reason you might not want to do this is you might expect find to act the way it does on Unix: the Rtools basically try to make Windows look a little bit like Unix. Duncan Murdoch If you follow the advice I gave you normally won't have that problem. On Wed, Jul 8, 2009 at 11:21 AM, Duncan Murdochmurd...@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 murd...@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 toolsetfile:///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 lig...@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 ggrothendi...@gmail.comwrote: I
Re: [R] Reading from Google Docs
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 to find. Then fix the script to use the find variable instead of find. That would work with systems having find2 or having find so new versions of R would work with both new and old versions of Rtools. The only combination that would not work would be old versions of R with new versions of the Rtools but that is not a likely combination and even if it does occur it would give an error so the user would know something is wrong which is far better than the current situation where a silent hard-to-diagnose risk that is entered onto your system. On Wed, Jul 8, 2009 at 3:51 PM, Duncan Murdochmurd...@stats.uwo.ca wrote: 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 about it to fix) in order to maintain the integrity of their system. As far as I know, you are the only person in the whole world who has been affected by this. But fixing it would inconvenience hundreds of people, who would have to install a new version of Rtools, if the make system suddenly started looking for find2 instead of find. So it's unfortunate that Microsoft chose to use the name of the wrong Unix utility when they wrote find, and it's unfortunate that the first version of Rtools didn't fix this, but there you are: name clashes happen, and sometimes you need to work around them. Duncan Murdoch On Wed, Jul 8, 2009 at 3:30 PM, Duncan Murdochmurd...@stats.uwo.ca wrote: 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 anything as far as the scripts are concerned. I explained to you how to rename it and keep them happy. Duncan Murdoch Why don't you just rename find.exe to find2.exe, say, in Rtools and adjust the other files accordingly. For the small number of people who ever look at the scripts it will be obvious that we are dealing with a find variant and the danger and need for kludges is eliminated. On Wed, Jul 8, 2009 at 12:55 PM, Duncan Murdochmurd...@stats.uwo.ca wrote: 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 working. That actually happened to me once and it took the longest time until I discovered that Rtools was the culprit. That's true, but there is a workaround: you can manually rename the find.exe in Rtools, and adjust the entry in one of the R makefiles (MkRules), and it will use the new name instead of find. The reason you might not want to do this is you might expect find to act the way it does on Unix: the Rtools basically try to make Windows look a little bit like Unix. Duncan Murdoch If you follow the advice I gave you normally won't have that problem. On Wed, Jul 8, 2009 at 11:21 AM, Duncan Murdochmurd...@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 murd...@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 toolsetfile:///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
Re: [R] Reading from Google Docs
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 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? Etiquette is one thing and the license another. Both encourage you to help others and make the binary available to others. And indeed, I hope that Windows users do build binaries for others and remove the additional work from those who provide the software in the first place. Having seen this thread today, I did put a binary version of RGoogleDocs on the Omegahat repository so install.packages(RGoogleDocs, repos = http://www.omegahat.org/R;) should install it and, if I had had time earlier, saved you the hardship of building the binary. Sorry to do it so soon after. D. Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, Jul 8, 2009 at 12:59, Farrel Buchinsky fjb...@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 ggrothendi...@gmail.comwrote: 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 Murdochmurd...@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 murd...@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 toolsetfile:///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 lig...@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 ggrothendi...@gmail.comwrote: 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
Re: [R] Reading from Google Docs
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.2-1.You then sent me link to 0.2-2 (in source code) which is what worked. Is it possible that that the windows binary version you put in omegahat was 0.2-1 and not 0.2-2? I did not know how to tell what version had been installed. Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, Jul 8, 2009 at 22:53, Duncan Temple Lang dun...@wald.ucdavis.eduwrote: 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 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? Etiquette is one thing and the license another. Both encourage you to help others and make the binary available to others. And indeed, I hope that Windows users do build binaries for others and remove the additional work from those who provide the software in the first place. Having seen this thread today, I did put a binary version of RGoogleDocs on the Omegahat repository so install.packages(RGoogleDocs, repos = http://www.omegahat.org/R;) should install it and, if I had had time earlier, saved you the hardship of building the binary. Sorry to do it so soon after. D. Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Wed, Jul 8, 2009 at 12:59, Farrel Buchinsky fjb...@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 ggrothendi...@gmail.comwrote: 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 Murdochmurd...@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 murd...@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 toolsetfile:///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 lig...@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
Re: [R] Reading from Google Docs
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 ggrothendi...@gmail.comwrote: 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 Buchinskyfjb...@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 ggrothendi...@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.
Re: [R] Reading from Google Docs
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 ggrothendi...@gmail.comwrote: 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 Buchinskyfjb...@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 ggrothendi...@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. __ 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.
Re: [R] Reading from Google Docs
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 head against the wall When I run Rcmd build RGoogleDocs from the cmd prompt I get Error: cannot change to directory 'RGoogleDocs' What error have I perpetrated? I have changed my starting directory to almost every imaginable directory and I have put a copy of RGoogleDocs_0.2-2.tar.gz almost everywhere. I also once got * checking for file 'RGoogleDocs/DESCRIPTION' ... No and there it stopped Farrel Buchinsky Google Voice Tel: (412) 567-7870 On Mon, Mar 2, 2009 at 22:16, Gabor Grothendieck ggrothendi...@gmail.comwrote: 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 fjb...@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 servicehttp://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, rip...@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, UKFax: +44 1865 272595 [[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.
Re: [R] Reading from Google Docs
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 ggrothendi...@gmail.comwrote: 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.
Re: [R] Reading from Google Docs
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 Buchinskyfjb...@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 ggrothendi...@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. __ 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.
Re: [R] Reading from Google Docs
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 ggrothendi...@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 fjb...@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 servicehttp://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, rip...@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@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.
Re: [R] Reading from Google Docs
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 servicehttp://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, rip...@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, UKFax: +44 1865 272595 [[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.
Re: [R] Reading from Google Docs
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 fjb...@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 servicehttp://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, rip...@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@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.
[R] Reading from Google Docs
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 when I went to the website I saw that package is only available as http://www.omegahat.org/RGoogleDocs/RGoogleDocs_0.1-0.tar.gz To my knowledge tar.gz is only for Linux. Does this mean that I cannot run it on a windows machine. Please tell me that there is a way to run it on a Windows machine. Farrel Buchinsky GrandCentral Tel: (412) 567-7870 __ 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.
Re: [R] Reading from Google Docs
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 fjb...@gmail.com 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 Tinn-R or RGui's package install tool. Then when I went to the website I saw that package is only available as http://www.omegahat.org/RGoogleDocs/RGoogleDocs_0.1-0.tar.gz To my knowledge tar.gz is only for Linux. Does this mean that I cannot run it on a windows machine. Please tell me that there is a way to run it on a Windows machine. Farrel Buchinsky GrandCentral Tel: (412) 567-7870 __ 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.
Re: [R] Reading from Google Docs
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 Tinn-R or RGui's package install tool. Then when I went to the website I saw that package is only available as http://www.omegahat.org/RGoogleDocs/RGoogleDocs_0.1-0.tar.gz To my knowledge tar.gz is only for Linux. Does this mean that I cannot run it on a windows machine. Please tell me that there is a way to run it on a Windows machine. 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, rip...@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, UKFax: +44 1865 272595 __ 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.
Re: [R] Reading from Google Docs
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 worked until this point when I got Error in con$getDocs : $ operator not defined for this S4 class str(con) Formal class 'GoogleDocsConnection' [package ] with 0 slots list() I have just seen Prof Brian Ripley's correspondence. I had installed RCurl and XML from the Tinn-R R controlling:packages button. It appears to me that I need to check out R-admin manual. Is there a simple generic r script that I could run to determine if my RCurl and XML are running properly? C:\Program Files\R\R-2.7.2\library\RGoogleDocs\ inst DIR 12/15/2008 17:27:57 R DIR 12/15/2008 17:27:57 DESCRIPTION 777 9/24/2008 12:47:59 1 file(s), 2 folder(s) 777 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\inst\ doc DIR 12/15/2008 17:27:57 sampleDocsDIR 12/15/2008 17:44:07 0 file(s), 2 folder(s)0 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\inst\doc\ basics.html 5,867 9/24/2008 11:27:38 basics.pdf8,873 9/24/2008 11:30:51 basics.xml3,504 9/24/2008 11:27:34 GNUmakefile 39 9/24/2008 11:24:44 run.html 14,150 9/24/2008 12:46:41 run.pdf 13,643 9/24/2008 12:44:39 run.xml 9,257 9/24/2008 12:44:23 7 file(s), 0 folder(s) 55,333 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\inst\sampleDocs\ SampleDoc.doc22,016 9/24/2008 12:44:23 SampleSpreadsheet.xls17,408 9/24/2008 12:44:23 2 file(s), 0 folder(s) 39,424 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\R\ auth.R8,183 9/24/2008 12:44:23 1 file(s), 0 folder(s)8,183 bytes Farrel Buchinsky GrandCentral Tel: (412) 567-7870 On Mon, Dec 15, 2008 at 17:12, Gustavo Carvalho gustavo.bi...@gmail.com wrote: 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 fjb...@gmail.com 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 Tinn-R or RGui's package install tool. Then when I went to the website I saw that package is only available as http://www.omegahat.org/RGoogleDocs/RGoogleDocs_0.1-0.tar.gz To my knowledge tar.gz is only for Linux. Does this mean that I cannot run it on a windows machine.
Re: [R] Reading from Google Docs
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 = getConnection(auth) con$getDocs() all worked until this point when I got Error in con$getDocs : $ operator not defined for this S4 class str(con) Formal class 'GoogleDocsConnection' [package ] with 0 slots list() If you use getDocs(con) it should work, assuming auth and con are appropriate. Where did you see that con$getDocs() should work? In the documentation file run.xml, there is the line In the future, we might provide an interface that avoids this such as con$getDocs() ... So, as it says, it is in the future. D. I have just seen Prof Brian Ripley's correspondence. I had installed RCurl and XML from the Tinn-R R controlling:packages button. It appears to me that I need to check out R-admin manual. Is there a simple generic r script that I could run to determine if my RCurl and XML are running properly? C:\Program Files\R\R-2.7.2\library\RGoogleDocs\ inst DIR 12/15/2008 17:27:57 R DIR 12/15/2008 17:27:57 DESCRIPTION 777 9/24/2008 12:47:59 1 file(s), 2 folder(s) 777 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\inst\ doc DIR 12/15/2008 17:27:57 sampleDocsDIR 12/15/2008 17:44:07 0 file(s), 2 folder(s)0 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\inst\doc\ basics.html 5,867 9/24/2008 11:27:38 basics.pdf8,873 9/24/2008 11:30:51 basics.xml3,504 9/24/2008 11:27:34 GNUmakefile 39 9/24/2008 11:24:44 run.html 14,150 9/24/2008 12:46:41 run.pdf 13,643 9/24/2008 12:44:39 run.xml 9,257 9/24/2008 12:44:23 7 file(s), 0 folder(s) 55,333 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\inst\sampleDocs\ SampleDoc.doc22,016 9/24/2008 12:44:23 SampleSpreadsheet.xls17,408 9/24/2008 12:44:23 2 file(s), 0 folder(s) 39,424 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\R\ auth.R8,183 9/24/2008 12:44:23 1 file(s), 0 folder(s)8,183 bytes Farrel Buchinsky GrandCentral Tel: (412) 567-7870 On Mon, Dec 15, 2008 at 17:12, Gustavo Carvalho gustavo.bi...@gmail.com wrote: 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 fjb...@gmail.com 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
Re: [R] Reading from Google Docs
When I rungetDocs(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 attention I can see that I should not have tried it. Farrel Buchinsky GrandCentral Tel: (412) 567-7870 On Mon, Dec 15, 2008 at 19:28, Duncan Temple Lang dun...@wald.ucdavis.edu wrote: 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 = getConnection(auth) con$getDocs() all worked until this point when I got Error in con$getDocs : $ operator not defined for this S4 class str(con) Formal class 'GoogleDocsConnection' [package ] with 0 slots list() If you use getDocs(con) it should work, assuming auth and con are appropriate. Where did you see that con$getDocs() should work? In the documentation file run.xml, there is the line In the future, we might provide an interface that avoids this such as con$getDocs() ... So, as it says, it is in the future. D. I have just seen Prof Brian Ripley's correspondence. I had installed RCurl and XML from the Tinn-R R controlling:packages button. It appears to me that I need to check out R-admin manual. Is there a simple generic r script that I could run to determine if my RCurl and XML are running properly? C:\Program Files\R\R-2.7.2\library\RGoogleDocs\ inst DIR 12/15/2008 17:27:57 R DIR 12/15/2008 17:27:57 DESCRIPTION 777 9/24/2008 12:47:59 1 file(s), 2 folder(s) 777 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\inst\ doc DIR 12/15/2008 17:27:57 sampleDocsDIR 12/15/2008 17:44:07 0 file(s), 2 folder(s)0 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\inst\doc\ basics.html 5,867 9/24/2008 11:27:38 basics.pdf8,873 9/24/2008 11:30:51 basics.xml3,504 9/24/2008 11:27:34 GNUmakefile 39 9/24/2008 11:24:44 run.html 14,150 9/24/2008 12:46:41 run.pdf 13,643 9/24/2008 12:44:39 run.xml 9,257 9/24/2008 12:44:23 7 file(s), 0 folder(s) 55,333 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\inst\sampleDocs\ SampleDoc.doc22,016 9/24/2008 12:44:23 SampleSpreadsheet.xls17,408 9/24/2008 12:44:23 2 file(s), 0 folder(s) 39,424 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\R\ auth.R8,183 9/24/2008 12:44:23 1 file(s), 0 folder(s)
Re: [R] Reading from Google Docs
Farrel Buchinsky wrote: When I rungetDocs(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 bring the words In the future, we might to my attention I can see that I should not have tried it. Farrel Buchinsky GrandCentral Tel: (412) 567-7870 On Mon, Dec 15, 2008 at 19:28, Duncan Temple Lang dun...@wald.ucdavis.edu wrote: 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 = getConnection(auth) con$getDocs() all worked until this point when I got Error in con$getDocs : $ operator not defined for this S4 class str(con) Formal class 'GoogleDocsConnection' [package ] with 0 slots list() If you use getDocs(con) it should work, assuming auth and con are appropriate. Where did you see that con$getDocs() should work? In the documentation file run.xml, there is the line In the future, we might provide an interface that avoids this such as con$getDocs() ... So, as it says, it is in the future. D. I have just seen Prof Brian Ripley's correspondence. I had installed RCurl and XML from the Tinn-R R controlling:packages button. It appears to me that I need to check out R-admin manual. Is there a simple generic r script that I could run to determine if my RCurl and XML are running properly? C:\Program Files\R\R-2.7.2\library\RGoogleDocs\ inst DIR 12/15/2008 17:27:57 R DIR 12/15/2008 17:27:57 DESCRIPTION 777 9/24/2008 12:47:59 1 file(s), 2 folder(s) 777 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\inst\ doc DIR 12/15/2008 17:27:57 sampleDocsDIR 12/15/2008 17:44:07 0 file(s), 2 folder(s)0 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\inst\doc\ basics.html 5,867 9/24/2008 11:27:38 basics.pdf8,873 9/24/2008 11:30:51 basics.xml3,504 9/24/2008 11:27:34 GNUmakefile 39 9/24/2008 11:24:44 run.html 14,150 9/24/2008 12:46:41 run.pdf 13,643 9/24/2008 12:44:39 run.xml 9,257 9/24/2008 12:44:23 7 file(s), 0 folder(s) 55,333 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\inst\sampleDocs\ SampleDoc.doc22,016 9/24/2008 12:44:23 SampleSpreadsheet.xls17,408 9/24/2008 12:44:23 2 file(s), 0 folder(s) 39,424 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\R\ auth.R8,183 9/24/2008 12:44:23 1 file(s), 0 folder(s)8,183 bytes
Re: [R] Reading from Google Docs
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 matching 'xmlParse' using fuzzy matching: supportsExpat(XML) Determines which native XML parsers are being used. xmlEventHandler(XML)Default handlers for the SAX-style event XML parser xmlParent(XML) Get parent node of XMLInternalNode or ancestor nodes xmlStopParser(XML) Terminate an XML parser xmlTreeParse(XML) XML Parser Farrel Buchinsky GrandCentral Tel: (412) 567-7870 On Mon, Dec 15, 2008 at 19:56, Duncan Temple Lang dun...@wald.ucdavis.edu wrote: Farrel Buchinsky wrote: When I rungetDocs(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 bring the words In the future, we might to my attention I can see that I should not have tried it. Farrel Buchinsky GrandCentral Tel: (412) 567-7870 On Mon, Dec 15, 2008 at 19:28, Duncan Temple Lang dun...@wald.ucdavis.edu wrote: 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 = getConnection(auth) con$getDocs() all worked until this point when I got Error in con$getDocs : $ operator not defined for this S4 class str(con) Formal class 'GoogleDocsConnection' [package ] with 0 slots list() If you use getDocs(con) it should work, assuming auth and con are appropriate. Where did you see that con$getDocs() should work? In the documentation file run.xml, there is the line In the future, we might provide an interface that avoids this such as con$getDocs() ... So, as it says, it is in the future. D. I have just seen Prof Brian Ripley's correspondence. I had installed RCurl and XML from the Tinn-R R controlling:packages button. It appears to me that I need to check out R-admin manual. Is there a simple generic r script that I could run to determine if my RCurl and XML are running properly? C:\Program Files\R\R-2.7.2\library\RGoogleDocs\ inst DIR 12/15/2008 17:27:57 R DIR 12/15/2008 17:27:57 DESCRIPTION 777 9/24/2008 12:47:59 1 file(s), 2 folder(s) 777 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\inst\ doc DIR 12/15/2008 17:27:57 sampleDocsDIR 12/15/2008 17:44:07 0 file(s), 2 folder(s)0 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\inst\doc\ basics.html 5,867 9/24/2008 11:27:38 basics.pdf8,873 9/24/2008 11:30:51 basics.xml3,504 9/24/2008 11:27:34 GNUmakefile 39 9/24/2008 11:24:44 run.html 14,150 9/24/2008 12:46:41 run.pdf 13,643 9/24/2008 12:44:39 run.xml 9,257 9/24/2008 12:44:23 7 file(s), 0 folder(s) 55,333 bytes C:\Program
Re: [R] Reading from Google Docs
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 fjb...@gmail.com wrote: 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 matching 'xmlParse' using fuzzy matching: supportsExpat(XML) Determines which native XML parsers are being used. xmlEventHandler(XML)Default handlers for the SAX-style event XML parser xmlParent(XML) Get parent node of XMLInternalNode or ancestor nodes xmlStopParser(XML) Terminate an XML parser xmlTreeParse(XML) XML Parser Farrel Buchinsky GrandCentral Tel: (412) 567-7870 On Mon, Dec 15, 2008 at 19:56, Duncan Temple Lang dun...@wald.ucdavis.edu wrote: Farrel Buchinsky wrote: When I rungetDocs(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 bring the words In the future, we might to my attention I can see that I should not have tried it. Farrel Buchinsky GrandCentral Tel: (412) 567-7870 On Mon, Dec 15, 2008 at 19:28, Duncan Temple Lang dun...@wald.ucdavis.edu wrote: 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 = getConnection(auth) con$getDocs() all worked until this point when I got Error in con$getDocs : $ operator not defined for this S4 class str(con) Formal class 'GoogleDocsConnection' [package ] with 0 slots list() If you use getDocs(con) it should work, assuming auth and con are appropriate. Where did you see that con$getDocs() should work? In the documentation file run.xml, there is the line In the future, we might provide an interface that avoids this such as con$getDocs() ... So, as it says, it is in the future. D. I have just seen Prof Brian Ripley's correspondence. I had installed RCurl and XML from the Tinn-R R controlling:packages button. It appears to me that I need to check out R-admin manual. Is there a simple generic r script that I could run to determine if my RCurl and XML are running properly? C:\Program Files\R\R-2.7.2\library\RGoogleDocs\ inst DIR 12/15/2008 17:27:57 R DIR 12/15/2008 17:27:57 DESCRIPTION 777 9/24/2008 12:47:59 1 file(s), 2 folder(s) 777 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\inst\ doc DIR 12/15/2008 17:27:57 sampleDocsDIR 12/15/2008 17:44:07 0 file(s), 2 folder(s)0 bytes C:\Program Files\R\R-2.7.2\library\RGoogleDocs\inst\doc\ basics.html 5,867 9/24/2008 11:27:38 basics.pdf8,873 9/24/2008 11:30:51 basics.xml3,504 9/24/2008 11:27:34 GNUmakefile 39 9/24/2008 11:24:44 run.html 14,150 9/24/2008 12:46:41 run.pdf 13,643 9/24/2008 12:44:39 run.xml 9,257 9/24/2008 12:44:23
