Elaine Jones
2009-Mar-30 23:33 UTC
[R] Can I read a file into my workspace from Rprofile.site?
I am running R version 2.8.1 on Windows XP OS. When I launch R, I would like to automatically read a file containing my database connections, user ids, and passwords into my workspace. I tried including this in my Rprofile.site file: ... local({ old <- getOption("defaultPackages") options(defaultPackages = c(old, "Rcmdr","RODBC", "utils")) }) .First <- function() { library(utils) setwd("C:/Documents and Settings/Administrator/My Documents/R") connections <- read.csv("connections.csv", header=TRUE) cat("\n Welcome to R Elaine!\n\n") } ... When I launch R, it does not give me any error. The working directory appears to be set by the Rprofile.site file, but the connections object is not in my workspace: Welcome to R Elaine! Loading required package: tcltk Loading Tcl/Tk interface ... done Loading required package: car Rcmdr Version 1.4-7> ls()character(0) Any suggestions for how to resolve are appreciated! **************** Elaine McGovern Jones ************************ ISC Tape and DASD Storage Products Characterization and Failure Analysis Engineering Phone: 408 284 4853 Internal: 3-4853 jones2@us.ibm.com [[alternative HTML version deleted]]
Duncan Murdoch
2009-Mar-30 23:41 UTC
[R] Can I read a file into my workspace from Rprofile.site?
Elaine Jones wrote:> I am running R version 2.8.1 on Windows XP OS. > > When I launch R, I would like to automatically read a file containing my > database connections, user ids, and passwords into my workspace. > > I tried including this in my Rprofile.site file: > > ... > local({ > old <- getOption("defaultPackages") > options(defaultPackages = c(old, "Rcmdr","RODBC", "utils")) > }) > > .First <- function() { > library(utils) > setwd("C:/Documents and Settings/Administrator/My Documents/R") > connections <- read.csv("connections.csv", header=TRUE) > cat("\n Welcome to R Elaine!\n\n") > } > >The connections variable will be local to .First, and will disappear after that function is done. To save the variable into the global environment, use connections <<- read.csv("connections.csv", header=TRUE) instead. Duncan Murdoch> ... > > When I launch R, it does not give me any error. The working directory > appears to be set by the Rprofile.site file, but the connections object is > not in my workspace: > > > Welcome to R Elaine! > > Loading required package: tcltk > Loading Tcl/Tk interface ... done > Loading required package: car > > Rcmdr Version 1.4-7 > > >> ls() >> > character(0) > > > Any suggestions for how to resolve are appreciated! > > **************** Elaine McGovern Jones ************************ > > ISC Tape and DASD Storage Products > Characterization and Failure Analysis Engineering > Phone: 408 284 4853 Internal: 3-4853 > jones2 at us.ibm.com > > > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >