Sharepoint RSS Feeds and Server-side Scripts

[Remy]

How can you connect to Sharepoint RSS feeds using SPD 2007? I've
tried on many different installations/PC's/Servers, WSS 3.0 & MSSX
2008, and have never been successful. Does anyone know what I need to
do in order for this to work? I have followed the instructions @ this
link to allow the connections:

http://office.microsoft.com/en-us/sharepointdesigner/HA101194721033.aspx#3

OOTB, MSSX has this in the web.config, however WSS 3.0, I had to add
it. Still no luck. I've even tried it on the free 30 day download
provided by MSFT. I'm a farm admin in every scenario, so I know perms
is not an issue. Does anyone have any advice?

Thanks,
Matt

[spconsultant]

Try these intructions for using an XML datasource instead.
http://office.microsoft.com/en-us/sharepointdesigner/HA101154021033.aspx?pid=CH100667631033#3

On Aug 5, 8:41 am, Remy <remym...@gmail.com> wrote:
> How can you connect to Sharepoint RSS feeds using SPD 2007?  I've
> tried on many different installations/PC's/Servers, WSS 3.0 & MSSX
> 2008, and have never been successful.  Does anyone know what I need to
> do in order for this to work?  I have followed the instructions @ this
> link to allow the connections:
>

> http://office.microsoft.com/en-us/sharepointdesigner/HA101194721033.a...

[Remy]

I tried your method but it didn't work either. I'm still getting the
same message that I was getting when I was trying to use Server-side
Scripts:

"The server returned a non-specific error when trying to get data from
the data source. Check the format and content of your query and try
again. If the problem persists, contact the server admin."

Well, I AM the server admin... LOL Any more ideas out there?

Thanks,
Matt

On Aug 5, 9:15 am, spconsultant <gfpilot2...@yahoo.com> wrote:
> Try these intructions for using an XML datasource instead.http://office.microsoft.com/en-us/sharepointdesigner/HA101154021033.a...

>
> On Aug 5, 8:41 am, Remy <remym...@gmail.com> wrote:
>
>
>
> > How can you connect to Sharepoint RSS feeds using SPD 2007?  I've
> > tried on many different installations/PC's/Servers, WSS 3.0 & MSSX
> > 2008, and have never been successful.  Does anyone know what I need to
> > do in order for this to work?  I have followed the instructions @ this
> > link to allow the connections:
>
> >http://office.microsoft.com/en-us/sharepointdesigner/HA101194721033.a...
>
> > OOTB, MSSX has this in the web.config, however WSS 3.0, I had to add
> > it.  Still no luck.  I've even tried it on the free 30 day download
> > provided by MSFT.  I'm a farm admin in every scenario, so I know perms
> > is not an issue.  Does anyone have any advice?
>
> > Thanks,

> > Matt- Hide quoted text -
>
> - Show quoted text -

[rajkamal]

Hi,

It is very simple to get data from RSS feeds using SP Designer.
I will show with a simple example.
Please follow the steps given below - (Explained with example)

1)Open the SP Designer, and open the site and the page where you want
to show the RSS Feed data.
2)I am taking the RSS Feed Url of my blog (http://
rajkamal29.blogspot.com/atom.xml).
3)In the right side of the SP Designer you will find the "Data Source
Library" Toolbar,Go to "Server-side Scripts" Options and click
"Connect to script or RSS Feed".
3)Now you will get an "Data Source Properties" window, thenn select
"HTTP Get" method in the drop down and data command "Select", finally
provide the RSS Feed Url of my blog as show above (http://
rajkamal29.blogspot.com/atom.xml) in the "Url to a Server-side
script" Section and click Ok.
4)Then select "Show Data" which is located when you click on the right
arrow of the RSS feed connection.
5) Then it will go to the "Data Source Details" toolbar, where you
will find all the Fields.
6) Select the "Fields" you want to display and click on the "Insert
Selected Fields as.." button located on the top of the fields and
click "Single Item View" tab.
7)You will find the data in the page(Sharepoint Designer) as "Data
form" webpart,then customize data form web part according your
requirement.

Hopes this helps you a lot, any question please ask me.
I added the steps in my blog also along with small snap shots.

Thanks,
Rajkamal.V

[praveen]

Thanks Raj.
This will work. It's nice explanation with steps. Good effort.
But, i think what you explained is in MOSS, but the guy is looking for
WSS 3.0. Did you test it in WSS?

http://praveenbattula.blogspot.com

[john meyers]

Is it possible your system is behind a firewall or requires a proxy I have run into that issue where the system is located behind a proxy based solution and a exception had to be made or proxy settings added to web.config

---------- Forwarded message ----------
From: john meyers <scott...@gmail.com>
Date: Thu, Aug 6, 2009 at 11:41 AM
Subject: Re: [SharePoint Designer Discussions 441 Re: Sharepoint RSS Feeds and Server-side Scripts
To: sharepoin...@googlegroups.com

[Remy]

I'm able to get RSS Feed data from outside sources... However, that's
not exactly what I'm looking for. I'm looking to use the built-in RSS
Feeds of Sharepoint itself. I'd like to mashup a few things but
cannot due to the error I described above. I'm actually able to pull
your feed into SP Designer, your's and several others actually (MANY
OTHERS). These outside sources work perfectly. My server is
connected to the internet and is verified by the other feeds working.
I'm not behind a proxy either b/c I would've been the guy who would
have to build that. There is only one firewall on this network and I
control that too. To get to the SP RSS Feeds, I really wouldn't be
going through a firewall any way... I've even turned off the built-in
firewall on Win2k8, just to test. NO GO... It's interesting to see
the URL's like:

http://rajkamal29.blogspot.com/atom.xml
http://weather.yahooapis.com/forecastrss?p=USOH0591&u=f
http://news.google.com/news?pz=1&ned=us&hl=en&topic=h&num=3&output=rss

ALL WORK, but a SP RSS Feed for example:

http://intranet/_layouts/listfeed.aspx?List=9e2cecd6%2Db6df%2D43d1%2Da71e%2D6e5604122f48

DOESN'T

Does SP Designer and MSSX/WSS 3.0 work well with each other in regards
to RSS? What other limitations are there with MSSX that I should be
aware of?

Thanks,
Matt

[Remy]

Could you elaborate as to what exceptions you had to put in? I have
followed this link and triple checked it's settings...

http://office.microsoft.com/en-us/sharepointdesigner/HA101194721033.aspx#3

Is there something that I'm missing? I'm not behind a proxy BTW or
going through a firewall...

Thanks,
Matt

On Aug 6, 11:44 am, john meyers <scotteb...@gmail.com> wrote:
> Is it possible your system is behind a firewall or requires a proxy I have
> run into that issue where the system is located behind a proxy based
> solution and a exception had to be made or proxy settings added to
> web.config
>
>
>
> ---------- Forwarded message ----------
> From: john meyers <scotteb...@gmail.com>
> Date: Thu, Aug 6, 2009 at 11:41 AM
> Subject: Re: [SharePoint Designer Discussions 441 Re: Sharepoint RSS Feeds
>
> and Server-side Scripts
> To: sharepoin...@googlegroups.com
>

> > Rajkamal.V- Hide quoted text -

[Remy]

Sorry but I have to bump this one... Does anyone else have any
information on how to fix this or any other suggestions to try?

Thanks,
Matt

On Aug 7, 1:43 pm, Remy <remym...@gmail.com> wrote:
> I'm able to get RSS Feed data from outside sources...  However, that's
> not exactly what I'm looking for.  I'm looking to use the built-in RSS
> Feeds of Sharepoint itself.  I'd like to mashup a few things but
> cannot due to the error I described above.  I'm actually able to pull
> your feed into SP Designer, your's and several others actually (MANY
> OTHERS).  These outside sources work perfectly.  My server is
> connected to the internet and is verified by the other feeds working.
> I'm not behind a proxy either b/c I would've been the guy who would
> have to build that.  There is only one firewall on this network and I
> control that too.  To get to the SP RSS Feeds, I really wouldn't be
> going through a firewall any way... I've even turned off the built-in
> firewall on Win2k8, just to test.  NO GO...  It's interesting to see
> the URL's like:
>

> http://rajkamal29.blogspot.com/atom.xmlhttp://weather.yahooapis.com/forecastrss?p=USOH0591&u=fhttp://news.google.com/news?pz=1&ned=us&hl=en&topic=h&num=3&output=rss

>
> ALL WORK, but a SP RSS Feed for example:
>

> http://intranet/_layouts/listfeed.aspx?List=9e2cecd6%2Db6df%2D43d1%2D...

[praveen]

I didn't get you completely. Can you please tell me what you are
trying to do here?
I mean, you want to get your SharePoint feed and show it up on another
page. is this what you are trying to do?
Outside RSS feeds you are able to get through SP designer as data
source and sharePoint feeds you are not able to?
Is it what you are trying to do?


http://praveenbattula.blogspot.com

On Aug 11, 12:16 am, Remy <remym...@gmail.com> wrote:
> Sorry but I have to bump this one... Does anyone else have any
> information on how to fix this or any other suggestions to try?
>
> Thanks,
> Matt
>
> On Aug 7, 1:43 pm, Remy <remym...@gmail.com> wrote:
>
>
>
> > I'm able to get RSS Feed data from outside sources...  However, that's
> > not exactly what I'm looking for.  I'm looking to use the built-in RSS
> > Feeds of Sharepoint itself.  I'd like to mashup a few things but
> > cannot due to the error I described above.  I'm actually able to pull
> > your feed into SP Designer, your's and several others actually (MANY
> > OTHERS).  These outside sources work perfectly.  My server is
> > connected to the internet and is verified by the other feeds working.
> > I'm not behind a proxy either b/c I would've been the guy who would
> > have to build that.  There is only one firewall on this network and I
> > control that too.  To get to the SP RSS Feeds, I really wouldn't be
> > going through a firewall any way... I've even turned off the built-in
> > firewall on Win2k8, just to test.  NO GO...  It's interesting to see
> > the URL's like:
>

> >http://rajkamal29.blogspot.com/atom.xmlhttp://weather.yahooapis.com/f...

[Chris Shields]

I ran into a similar problem and from what I understood it was related to the "double-hop" problem, (http://support.microsoft.com/default.aspx?scid=kb;en-us;329986).  We are working on switching to Kerberos authentication, currently NTLM, so I hope that will help solve my issue.  I was unable to work around it, I am not a developer just a power user, but maybe that will help in understanding the issue?  Maybe someone can figure out another solution?

 

Chris 

[john meyers]

Is it possible you are having a issue caused by loopbackcheck similar to this http://www.information-worker.nl/2009/06/23/disableloopbackcheck-on-windows-server-2008/ I just found I had this issue on my servers. It would fit the build you are hitting the server from itself on port 80.

On Mon, Aug 10, 2009 at 3:16 PM, Remy <remy...@gmail.com> wrote:

[john meyers]

I did just try one last thing is it possible your site doesn't have anonymous access in place. I tested between my two sites one anonymous access is allowed and the other not. I found that I was able to recreate the issue against the site where login was required, but not with the anonymous site(it worked as expected). The resolution was to open the properties of the Data Source you created and click the tab "login" and enter credentials in the "save this username and password for this connection box" I used the domain\username convention. It kind of makes sense what good would list security of each item be if you could get a RSS feed and bypass it.

 

On Fri, Aug 14, 2009 at 9:11 AM, Remy <remy...@gmail.com> wrote:

I have this regedit already in place because I was running into the same "Access Denied" when I was trying to crawl Sharepoint.  I've downloaded the VPC from MS and tried the same technique for Sharepoint RSS feeds but I get the same error as well.  Now, I just don't know what to think... I may have to call Microsoft :*(

 

Thanks for your reply!

[Remy]

BIG UPS to John Meyers for not letting this topic go. He tested a few
scenarios on some different environments and came up with a solution.
When using the Server-side Script, I need to authenticate. I remember
trying windows auth, but never typing in a default user name and
password. I tried this and BOOM, my RSS feed pulls right up. Many
thanks to all those who have helped but what fixed the issue was
John's advice and I'd like to thank him and his determination... The
email correspondence is as follows:

First Reply:

Is it possible you are having a issue caused by loopbackcheck similar
to this http://www.information-worker.nl/2009/06/23/disableloopbackcheck-on-windows-server-2008/
I just found I had this issue on my servers. It would fit the build
you are hitting the server from itself on port 80.

Second Reply:

I did just try one last thing is it possible your site doesn't have
anonymous access in place. I tested between my two sites one anonymous
access is allowed and the other not. I found that I was able to
recreate the issue against the site where login was required, but not
with the anonymous site(it worked as expected). The resolution was to
open the properties of the Data Source you created and click the tab
"login" and enter credentials in the "save this username and password
for this connection box" I used the domain\username convention. It
kind of makes sense what good would list security of each item be if
you could get a RSS feed and bypass it.

Cheers,
Matt

On Aug 10, 3:16 pm, Remy <remym...@gmail.com> wrote:
> Sorry but I have to bump this one... Does anyone else have any
> information on how to fix this or any other suggestions to try?
>
> Thanks,
> Matt
>
> On Aug 7, 1:43 pm, Remy <remym...@gmail.com> wrote:
>
>
>
> > I'm able to get RSS Feed data from outside sources...  However, that's
> > not exactly what I'm looking for.  I'm looking to use the built-in RSS
> > Feeds of Sharepoint itself.  I'd like to mashup a few things but
> > cannot due to the error I described above.  I'm actually able to pull
> > your feed into SP Designer, your's and several others actually (MANY
> > OTHERS).  These outside sources work perfectly.  My server is
> > connected to the internet and is verified by the other feeds working.
> > I'm not behind a proxy either b/c I would've been the guy who would
> > have to build that.  There is only one firewall on this network and I
> > control that too.  To get to the SP RSS Feeds, I really wouldn't be
> > going through a firewall any way... I've even turned off the built-in
> > firewall on Win2k8, just to test.  NO GO...  It's interesting to see
> > the URL's like:
>

> >http://rajkamal29.blogspot.com/atom.xmlhttp://weather.yahooapis.com/f...

> > - Show quoted text -- Hide quoted text -