We get news content from news provider in xml fotmat.
1 news = 1 xml file.
So, everyday we receive 250-300 xml files.
Each xml file has category information. There are overlapping categories too.
Then we need to create RSS feed for each category.
The feeds should be updated automatically with cron job.
Each feed should contain latest 100 stories.
I should be able to view the feed from a URL. Feed must be in valid RSS format.
I need RSS FEED that will display all stories under each category as in www.ians.in.
The feed data should be stored in a MYSQL database of your choice.
My end goal is to get the RSS stories to wordpress using the WP-O-Matic plugin.
RSS Feed categories needed
* Commonwealth Games 2010
* Environment/ Wildlife
* Human Interest/Society
* Opinion/ Commentary
Example news under Arts and Culture
[url removed, login to view];topicname=Art/Culture/Books
We will have full publication rights. So, in our case the RSS feed should display the full story.
keep the RSS feed like [url removed, login to view]
The [url removed, login to view] (or any other suitable url) must ONLY contain the latest 100 stories. Older stories should be removed and only stored in MYSQL DATABASE.
NOTE: My present coder has already developed a code to convert xml file to rss on individual basis. You can use the code if you like.