How to split RSS feed into multiple RSS feeds?

RSS, feed, split

[hellekim]

Hi all,

I have tried to search the web, but so far without any results... Is there a way to split RSS by categories into separate feeds?

I got one RSS feed (SNIP) which have categories inside like Talous, Ulkomaat, Kotimaa etc.

Now I would like to split that on into rss_talous.xml, rss_ulkomaat.xml etc.

Is there a way to do that or perhaps even a script that might help me do this?

Thanks in advance,
hellekim.

[edited by: engine at 7:55 am (utc) on June 6, 2006]
[edit reason] See TOS [webmasterworld.com] [/edit]

[monkeythumpa]

You will need to select only that category from your database. Open your rss file and look at the query that is generating it. Then find the category ID and add to the end of your query "WHERE CatID = ##" You will have to find the exact name of the field that controlls CatID but it will look similar.

That will only select posts from that category. If you don't know how to modify SQL queries, then I am not sure how to help you.

[hellekim]

It seems I missed a big point in this... I don't actually have that feed it is someone else's feed, which makes it harder.

[monkeythumpa]

OK So how you do it is parse the feed items into a database. Now when someone requests your feed (a subset of the original feed) you need to search the text and either filter-in or filter-out all the words you expect to see or not see in that feed. It is not perfect but if you continue to tweak the filter words you should approach a good tool.