http://www.endusersharepoint.com/STP/ Paul Grenier, Lead Moderator en Mon, 13 Apr 2009 21:02:40 +0000 http://www.endusersharepoint.com/STP/topic/setting-the-base-url-for-one-web-part#post-5814 Mon, 13 Apr 2009 15:59:26 +0000 AutoSponge 5814@http://www.endusersharepoint.com/STP/ <p>I made a note to myself to look into this... finding the time is the hard part. </p> http://www.endusersharepoint.com/STP/topic/setting-the-base-url-for-one-web-part#post-5797 Mon, 13 Apr 2009 03:39:12 +0000 Christophe 5797@http://www.endusersharepoint.com/STP/ <p>As you're already using Yahoo, have you considered Yahoo Pipes? It would allow you to tweak your XML before sending it to SharePoint. </p> http://www.endusersharepoint.com/STP/topic/setting-the-base-url-for-one-web-part#post-5777 Thu, 09 Apr 2009 07:47:45 +0000 bensch 5777@http://www.endusersharepoint.com/STP/ <p>Hi all,</p> <p>I've just stumbled across YQL as a means of screen scraping HTML content from one site and displaying it in an XML web part on a SharePoint page. </p> <p><strong><em>...It is Awesome!</em></strong></p> <p>Try whacking the following URL in an XML web part to get an idea of what can be done:</p> <p><a href="http://query.yahooapis.com/v1/public/yql?q=SELECT%20" rel="nofollow">http://query.yahooapis.com/v1/public/yql?q=SELECT%20</a>*%20FROM%20html%20WHERE%20url%3D%22http%3A%2F%2Fpublic.ukcrn.org.uk%2FSearch%2FPortfolio.aspx%3Flevel1%3D2%22%20AND%20xpath%3D%22%2F%2Ftable%5B%40id%3D'ctl00_contentMain_gvStatsLevel2'%5D%22&#38;format=xml</p> <p>[You'll need to copy the entire URL there]</p> <p>Now this table displays just fine, but the links in the source html page are all relative and are therefore broken in the context of the SP site.</p> <p>If I knew XSL even a bit I am sure I could amend this XML output to prepend the URL of the source site. </p> <p>BUT I am thinking this could also be an interesting use of JQUERY too? </p> <p>Any ideas on a clever workaround here?</p> <p>Cheers<br /> Ben </p>