[HackerHelpDesk]

Thanks kizer it work great now, Copied you code and everything started working. Thanks again to everyone for this feature and all your help.

[nicoli_k]

Thanks for the info kizer. I now have it working on my xbox after making sure I had webserver enabled and the port set to 80 like in the files.

I'm not sure exactly why I wasn't able to do it before, but I think it had something to do with how I was saving it.

I initially tried with Editpad Lite and there were conversion errors. I tried again using PSPad as my text editor and when I uploaded the file, it worked.

If you experience just the title of the asp file scrolling, try another text editor or make sure you're saving it as a utf-8. The files posted work perfectly for the xbox as long as your port is set to 80.

[bittihuduga]

sorry, I am running xbmc on my winxp laptop.
i tried creating rss file and .asp file
but i cant see any rss feed in xbmc
can someone help me to set this up?

[craigey1]

Not sure how to run sqlite3Explorer on the xbox.

I know you got this sorted now, but just for future reference sqlite3explorer is run on the PC. You just need to copy your "\UserData\Database\MyVideos34.db" file from xbmc to your pc & point sqlite3explorer at that & you can run the SQL commands.

sorry, I am running xbmc on my winxp laptop.
i tried creating rss file and .asp file
but i cant see any rss feed in xbmc
can someone help me to set this up?

I'm a little confused as to why you've created both an rss & an .asp file.
Copy the code into a new text document. Go to "File" -> "Save As". Select "All files" in the Save as type dropdown & enter the filename as rss.asp
transfer that file to the web folder in xbmc.

You then need to edit the RSSFeeds.xml file in the UserData folder & add the line:
<feed updateinterval="30">http://xbox/rss.asp</feed>
This has to go between the <set id="1"> & </set> tags.
Save the file & restart xbmc.

Fingers X'd

[stoli]

You then need to edit the RSSFeeds.xml file in the UserData folder & add the line:
<feed updateinterval="30">http://xbox/rss.asp</feed>
This has to go between the <set id="1"> & </set> tags.
Save the file & restart xbmc.

Fingers X'd

Just a small correction - it should be http://localhost/rss.asp not http://xbox...

[kizer]

Glad it helped you guys. Took me a while to figure out what everything was going on too. So I decided why not just share like everybody else does.

[stoli]

I've posted the three files for download. These assume you have the web server in xbmc set to port 80.

Mediafire download

[slyk2203]

great idea ! thx
Is it possible to get rss with e.g. google news ? or cinema news or something like that?
that would be great too.

[stoli]

You can add any rss feed you want to it...

http://www.xbmc.org/wiki/?title=RssFeeds.xml

[jabba_29]

I am having some weird issues with this.
If I set up the file and access from my PC, I get a valid RSS file:
I can read it in a RSS reader or Firefox browser.

With XBMC, it doesn't appear.. I am using Apple TV are my hardware.

I have used the code above (well modified a bit, but started with the original) and this is the output through a web browser:

Code:

<rss version="2.0">
<channel>
<title>Recently Added TV Shows</title>
<link>http://localhost:8080/rss.asp</link>
<description>Newly added shows</description>
<language>en-us</language>

<item>
<title>something</title>
</item><item>
<title>something else</title>
</item><item>
<title>something </title>
</item><item>
<title>something else again</title>
</item><item>
<title>Even more something</title>
</item><item>
<title>Can there be anymore something?</title>
</item>
</channel>
</rss>

I have even tried to open the file with php on my home server and force content type - but this makes no difference.

Any ideas?

Thanks in advance..

J

[MDPauley]

Any ideas?

Thanks in advance..

J

Can we see your RssFeeds.xml file?

[jabba_29]

Code:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<rssfeeds>
  <!--RSS feeds. To have multiple feeds, just add a feed to the set. You can also have multiple sets.-->
  <!--To use different sets in your skin, each must be called from skin with a unique id.-->
  <set id="1">
    <feed updateinterval="5">http://localhost:8080/rss.asp</feed>
<!-- <feed updateinterval="5">http://192.168.xxx.x/atv/atv.php</feed> -->
    <feed updateinterval="30">http://192.168.xxx.x/atv/rss.php</feed>
  </set>
</rssfeeds>

Thanks for the interest. I have tried several methods. localhost is on the XBMC, definitely 8080. Even tried the direct IP - same result.

The commented out feed is a php script that opens the rss.asp with curl.
Again, these work on my PC, but not on my XBMC.
I am using MiniMeedia skin for what it's worth.

[craigey1]

I have used the code above (well modified a bit, but started with the original)

Can you post your modified code? I had problems on my xbox after modifying the code too much.

[jabba_29]

Code:

<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
<channel>
<title>Recently Added TV Shows</title>
<link>http://localhost:8080/rss.asp/</link>
<description>Newly added shows</description>
<language>en-us</language>

<%
var Response;
var setHeader;
var resetHeader;

setHeader = xbmcAPI("setresponseformat(webheader;false;webfooter;false;opentag;<tag>;closetag;</tag>;openRecord;<item>;closeRecord;</item>;openField;\n;closeField;\n;closefinaltag;false)");
Response  = xbmcAPI("QueryVideoDatabase(SELECT '\n<title>',strTitle,': ', C00,'</title>\n' FROM episodeview ORDER BY idEpisode DESC Limit 6)");
write(Response);
resetHeader = xbmcAPI("SetResponseFormat()");


%>
</channel>
</rss>

Obviously, changing the link makes no difference -
and I have taken out <description>
but this displays in readers on my PC no problems.

[craigey1]

I had the same issue when I removed the description. I found the description slowed down the script, so removed it & found that although I could still see the feed in IE. The xbox didn't display anything after the Newly added shows.

All I can suggest is adding the description back in & see if that works again. Perhaps you could just add a string such as "a" in the description tags, rather then grabing the data in the DB.