Convert Xml to rss

[uttam.paul69]

I want to convert my sitemap.xml to a .rss feed. How can I do this? Is there any software or online tool to do it? Plz help I need it hardly.

[tn69]

I want to convert my sitemap.xml to a .rss feed. How can I do this? Is there any software or online tool to do it? Plz help I need it hardly.

your sitemap.xml is static or dynamic?
normally sitemaps have only urls. But for rss feed we need url,title,description sample format would be like this.

PHP Code:

<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">

<channel>
  <title>W3Schools Home Page</title>
  <link>http://www.w3schools.com</link>
  <description>Free web building tutorials</description>
  <item>
    <title>RSS Tutorial</title>
    <link>http://www.w3schools.com/rss</link>
    <description>New RSS tutorial on W3Schools</description>
  </item>
  <item>
    <title>XML Tutorial</title>
    <link>http://www.w3schools.com/xml</link>
    <description>New XML tutorial on W3Schools</description>
  </item>
</channel>

</rss> 


[uttam.paul69]

My sitemap is static

[tn69]

i assume you want rss for your blog site http://www.uttam-soft.tk/

here is your rss
http://feeds.feedburner.com/Uttam-soft

[uttam.paul69]

Hehe! I know that bro. Actually I need an rss feed for my other sites which are hosted on cpanel. I have a sitemap of 20,000 urls. So, I want to make a feed of that sitemap.

[tn69]

can you tell your sitemap url ?

[uttam.paul69]

Here it is: http://apkstore.gq/sitemap.xml

[tn69]

Here it is: http://apkstore.gq/sitemap.xml

i think your site uses mysql database.
so you can do like this. this is a dynamic rss feed.

PHP Code:

<?php

mysql_connect('localhost','username','password');
mysql_select_db('database');
$query=mysql_query('select title,url,description from file_table order by id desc');
while($row=mysql_fetch_object($query))
{
$items.='<item>
    <title>'.$row->title.'</title>
    <link>'.$row->url.'</link>
    <description>'.$row->description.'</description>
  </item>';
}

echo '<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">
<channel>'.$items.'
</channel>
</rss>';
?>

modify this according to your site database table structure that holds file information.

[uttam.paul69]

Ok thanks

[Akshay_M]

RSS is an XML-based format so you could potentially use XSL-T - that is the answer to your question. Following problems will however arise:

RSS is a Feed - a sequence of events distributed in time, does you XML semantically match that?
RSS is only one possible Feed format, may be Atom is more suitable for you
How would you like to consume your RSS feed, what are the use-cases.