R help - Mar 2018 - Your browser do not suport oracle bi presentation services

Hi dear R users: 


I'm trying the following code to download an information from the web. 

url1 <-
"http://obieebr.banrep.gov.co/analytics/saw.dll?Go&Path=%2fshared%2fSeries%20Estad%C3%ADsticas_T%2f1.%20Tasa%20de%20Cambio%20Peso%20Colombiano%2f1.1%20TRM%20-%20Disponible%20desde%20el%2027%20de%20noviembre%20de%201991%2f1.1.1.TCM_Serie%20hist%C3%B3rica%20o%20por%20a%C3%B1o&Options=rdf&lang=es&NQUser=publico&NQPassword=publico"

con <- url(url1, "r") 
x <- readLines(con) 
close(con) 

I obtain the folowing message: 

"Su explorador no es soportado por Oracle BI Presentation Services." 

Your browser do not support Oracle BI Presentation Sevices. 


How can I deal with this problem? 

Thank you very much for your help. 

Kenneth 



	[[alternative HTML version deleted]]

On Sun, Mar 11, 2018 at 09:12:56AM -0500, KENNETH ROY CABRERA TORRES
wrote:
> Hi dear R users: 
> 
> I'm trying the following code to download an information from the web. 
> 
> url1 <-
"http://obieebr.banrep.gov.co/analytics/saw.dll?Go&Path=%2fshared%2fSeries%20Estad%C3%ADsticas_T%2f1.%20Tasa%20de%20Cambio%20Peso%20Colombiano%2f1.1%20TRM%20-%20Disponible%20desde%20el%2027%20de%20noviembre%20de%201991%2f1.1.1.TCM_Serie%20hist%C3%B3rica%20o%20por%20a%C3%B1o&Options=rdf&lang=es&NQUser=publico&NQPassword=publico"
> 
> con <- url(url1, "r") 
> x <- readLines(con) 
> close(con) 
> 
> I obtain the folowing message: 
> 
> "Su explorador no es soportado por Oracle BI Presentation
Services."
> 
> Your browser do not support Oracle BI Presentation Sevices. 
I tried opening that URL with my browser and it worked (or at least I 
think it worked, it took me to a page where I could see a very long 
table titled "Tasa de cambio representativa del mercado (TRM)".

I tried obtaining the page using wget and I got the error you mentioned. 
When I forge wget to identify itself as Firefox, I get returned a 
different code (one that I suppose will redirect me to the page you are 
trying to scrape).

The problem could be solved by telling R to use a different user-agent, 
like Firefox or Chrome. Check 
https://stackoverflow.com/questions/4536835/changing-user-agent-string-in-a-http-request-in-r

However, I think the system that provides the HTML content you want 
relies heavily on JavaScript. You might need to end up using something 
like Selenium (https://www.r-bloggers.com/scraping-with-selenium/).

Cheers,

-- 
Jos? Mar?a (Chema) Mateos
https://rinzewind.org/blog-es || https://rinzewind.org/blog-en

Thank you Jos? Mar?a:

You are very kind.

I will study and use your advice.

The first step, takes more information,
but not what I want. (I want the whole data set of "TRM").

I'm going to try with Selenium (RSelenium).

Thank you very much for your help.

Kenneth

----- Mensaje original -----
De: "Jos? Mar?a Mateos" <chema at rinzewind.org>
Para: "r-help at r-project.org r-help at r-project.org" <r-help at
r-project.org>
Enviados: Domingo, 11 de Marzo 2018 9:25:51
Asunto: Re: [R] Your browser do not suport oracle bi presentation services

On Sun, Mar 11, 2018 at 09:12:56AM -0500, KENNETH ROY CABRERA TORRES
wrote:
> Hi dear R users: 
> 
> I'm trying the following code to download an information from the web. 
> 
> url1 <-
"http://obieebr.banrep.gov.co/analytics/saw.dll?Go&Path=%2fshared%2fSeries%20Estad%C3%ADsticas_T%2f1.%20Tasa%20de%20Cambio%20Peso%20Colombiano%2f1.1%20TRM%20-%20Disponible%20desde%20el%2027%20de%20noviembre%20de%201991%2f1.1.1.TCM_Serie%20hist%C3%B3rica%20o%20por%20a%C3%B1o&Options=rdf&lang=es&NQUser=publico&NQPassword=publico"
> 
> con <- url(url1, "r") 
> x <- readLines(con) 
> close(con) 
> 
> I obtain the folowing message: 
> 
> "Su explorador no es soportado por Oracle BI Presentation
Services."
> 
> Your browser do not support Oracle BI Presentation Sevices. 
I tried opening that URL with my browser and it worked (or at least I 
think it worked, it took me to a page where I could see a very long 
table titled "Tasa de cambio representativa del mercado (TRM)".

I tried obtaining the page using wget and I got the error you mentioned. 
When I forge wget to identify itself as Firefox, I get returned a 
different code (one that I suppose will redirect me to the page you are 
trying to scrape).

The problem could be solved by telling R to use a different user-agent, 
like Firefox or Chrome. Check 
https://stackoverflow.com/questions/4536835/changing-user-agent-string-in-a-http-request-in-r

However, I think the system that provides the HTML content you want 
relies heavily on JavaScript. You might need to end up using something 
like Selenium (https://www.r-bloggers.com/scraping-with-selenium/).

Cheers,

-- 
Jos? Mar?a (Chema) Mateos
https://rinzewind.org/blog-es || https://rinzewind.org/blog-en

______________________________________________
R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
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.