I had a working script (Windows 32 bit) that sucessfully read a txt file from a password protected web site onwith read.csv. Below is a snippet of the very simple code:
fname <- "http://www.frontierweather.com/degreedays/StatePopulationWeightedWeatherData_Since2010.txt"
dd2 <- read.csv(fname, sep=",", header=T)
Then I got a new computer (Windows 64 bit) and the read.csv is no loger seems able to get beyond the websites authentication. Instead of reading in the data it reads in a garbled dataframe that seems to be related to the web sites authentication:
> head(dd2)
X..DOCTYPE.html.PUBLIC....W3C..DTD.XHTML.1.0.Transitional..EN
1 http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd>
2 <html xmlns=http://www.w3.org/1999/xhtml>
3 <head>
4 <title>Please login</title>
5 <link rel=stylesheet type=text/css
6 href=http://www.frontierweather.com/amember/templates/css/reset.css />
Uncessfully, I've tried several things to try to get it to work:
- Transfered cookies over from old machine
- opened website and when prompted allowed windows to save user name and password
- prefixed URL (in fname) with "user:password@"
- In interent explorer set website where data is stored as a "trusted site".
- Checked that all ackages are the same on the new computer and old computer
- Verified that both the old and new machine are running the same version (version 9) of Internet Explorer
Any assistance or direction would be greatly appreciated.