Need help turning an XML (rss) feed into Notes documents

Hi

I have an RSS news feed that I need to pull off the web (through our password protected company proxy) and turn each news summary item into a single Notes document. This is to be done via an agent that will run every 30 mins. The URL for the xml feed that is provided by the 3rd party info provider also needs a username and password.

I guess the best way to achieve this is via a Java agent, but I presume that someone out there has done something similar to this before? My experience of Java is somewhat limited, and I believe this can’t be done in LotusScript unless all servers are win32 (and not through a proxy).

If any one would be kind enough to share any Java agent code or advice it would be greatly appreciated. The stucture of the feed is as follows;

<?xml version="1.0" encoding="ISO-8859-1" ?>
  • BBC News | News Front Page | UK Edition http://news.bbc.co.uk/go/click/rss/0.91/-/1/hi/default.stm

    Updated every minute of every day

    en-gb

    Fri, 08 Jul 05 07:08:00 GMT

    Copyright: (C) British Broadcasting Corporation

    http://news5.thdo.bbc.co.uk/feeds/rss/index.htm

  • BBC News

    http://news.bbc.co.uk/nol/shared/img/bbc_news_120x60.gif

    http://news.bbc.co.uk
  • News item 1.....

    News item 1 summary, blah, blah…

    http://news.bbc.co.uk/go/click/rss/0.91/-/1/hi/uk/4662395.stm
  • News item 2.....

    News item 1 summary, blah, blah…

    http://news.bbc.co.uk/go/click/rss/0.91/-/1/hi/uk/4662395.stm
  • News item 3.....

    News item 1 summary, blah, blah…

    http://news.bbc.co.uk/go/click/rss/0.91/-/1/hi/uk/4662395.stm
  • etc etc…

    etc

    etc

Many thanks in advance

Subject: Need help turning an XML (rss) feed into Notes documents

Seems to me there’s an aggregator on OpenNTF.org for R6. I’d like to say for sure and give a link, but the site seems to have gone down sometime in the last few hours. If you’re in a mixed environment, all you need is one R6 server to do the actual aggregating, the others can get the data by replication.

Subject: RE: Need help turning an XML (rss) feed into Notes documents

This is one: OpenNTF.org - The Open Source Community for Collaboration Solutions

Subject: Need help turning an XML (rss) feed into Notes documents

I am not sure how you would login with username and password… but

one technique (not for novices) i have seen is

  1. use java.net.URL to get and save the rss url as an xml attachment.

  2. use org.w3c.dom.Document to parse out the xml attachment to get the data and build notes documents…