Answered by:
Load RSS feeds INTO a sharepoint list

Question
-
Hello,
Currently we have dozens of people getting RSS feeds in their inbox. The goal is to have all of these RSS feeds load into a SharePoint list, where each person can then go check the list instead of having their inbox clogged daily.
All of the information I've been able to find relates to sending RSS feeds FROM SharePoint. Now seeing as the SharePoint list will treat the information in the RSS feed as just any other data, I don't think the fact that it's an RSS feed source should matter too much. But what's the best way to automatically import this data into a list?
I've thought about the possibility of using a fake user account to receive the RSS feeds, then somehow dumping it into a dropoff library or something related. Not sure that that is a great approach or even a good one.
Any ideas? There has to be something on this out there, but I haven't found it.
Thanks!
Wednesday, November 16, 2011 7:29 PM
Answers
-
besides doing this with a custom timer job, you can make use of SSIS:
http://blogs.msdn.com/b/mattm/archive/2009/02/19/read-an-rss-feed-from-ssis.aspx
http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652
- Marked as answer by GuYuming Monday, November 28, 2011 8:40 AM
Tuesday, November 22, 2011 8:11 AM
All replies
-
Hi,
You can make use of OOB SharePoint 2010 RSS viewer web part to solve your problem.
You get the RSS Viewer webpart as part of the SharePoint Server Standard license. You need to ensure that the "SharePoint Server Standard Site Collection features" feature is enabled for your site collection.
Have a look at http://workerthread.wordpress.com/2010/12/10/sharepoint-2010-rss-viewer-web-part-tip-and-question/ for how to connect/Show RSS feeds in SharePoint.
Hope this will help you.
Thanks.... ________________ Baba (MCTS, MCPD)Thursday, November 17, 2011 9:17 AM -
Babsaheb,
You are correct, that shows more information about the webpart. What I was looking for is a way to capture the information from the RSS feed and store it permanently in a SharePoint List. However, it looks like that requirement may be dropped. I have not found any way to perform this function and it is not that important to the users.
Thanks
Thursday, November 17, 2011 3:37 PM -
besides doing this with a custom timer job, you can make use of SSIS:
http://blogs.msdn.com/b/mattm/archive/2009/02/19/read-an-rss-feed-from-ssis.aspx
http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652
- Marked as answer by GuYuming Monday, November 28, 2011 8:40 AM
Tuesday, November 22, 2011 8:11 AM