Problem with RSS INPUT

[pentergark]

Hi !

I have a problem with this RSS:

http://www.fotocasa.es/Press/Rss/Rss2_0.aspx

When I put this in the "RSS input" module, this make a error all the time...

If i do the same with others RSS directions:

http://www.pentaho.com/feeds/press/
http://ep00.epimg.net/rss/elpais/portada.xml

all ok!

but with this... i dont know what is the problem

snif, snif...

I need help!

Penter

[pentergark]

My version is the 4.3 and the error is the next:

2012/07/18 04:13:31 - fotocasa.0 - Reading of URL http://hogar.fotocasa.es/hogar/RSS/Rss2_0.aspx failed.
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unexpected Exception : it.sauronsoftware.feed4j.FeedXMLParseException: org.dom4j.DocumentException: Connection reset Nested exception: Connection reset
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : it.sauronsoftware.feed4j.FeedXMLParseException: org.dom4j.DocumentException: Connection reset Nested exception: Connection reset
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at it.sauronsoftware.feed4j.FeedParser.parse(FeedParser.java:53)
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.rssinput.RssInput.readNextUrl(RssInput.java:178)
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.rssinput.RssInput.getOneRow(RssInput.java:210)
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.rssinput.RssInput.processRow(RssInput.java:334)
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at java.lang.Thread.run(Unknown Source)
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Caused by: org.dom4j.DocumentException: Connection reset Nested exception: Connection reset
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.dom4j.io.SAXReader.read(SAXReader.java:484)
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.dom4j.io.SAXReader.read(SAXReader.java:291)
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at it.sauronsoftware.feed4j.FeedParser.parse(FeedParser.java:37)
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : ... 5 more
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Error desconocido
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : org.pentaho.di.core.exception.KettleException:
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : it.sauronsoftware.feed4j.FeedXMLParseException: org.dom4j.DocumentException: Connection reset Nested exception: Connection reset
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : org.dom4j.DocumentException: Connection reset Nested exception: Connection reset
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.rssinput.RssInput.processRow(RssInput.java:389)
2012/07/18 04:13:31 - fotocasa.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
20

[marabu]

Well, it's not only RSS Input that complains:

http://validator.w3.org/appc/check.c...%2FRss2_0.aspx

[pentergark]

could be some solution to use this RSS?

[cboyden]

Maybe use an XML step (not sure if they support URLs, I think they do) or fetch with an HTTP step and process it. You can always create a transformation to fix the format if you really want to use the RSS Input step.

[marabu]

That spanish server is very picky about who is asking.
Could be some headers are missing to succeed.

PS: User-Agent is required!

PPS: The next problem is a BOM sent by the server.

PPS: Beauty is in the eye of the beholder...

[pentergark]

I am trying to pass information from http://noticias.fotocasa.es/news/RSS/Rss2_0.aspx


to a excel file, I can not fix by passing to the RSS or XML using Http module...

this is crazy.

[marabu]

Just replace the Text Output step by Excel Writer, add some fields and you are done.

[pentergark]

Thank you!! you are a great man!!