Posts Tagged ‘SharePoint Designer’

Hyperlink/Picture Column does not display image

October 24, 2011

I came across a very interesting issue. I had a simple custom SharePoint List library. One of the columns was a “headshot” formatted as a Picture to allow users to paste in a URL of their pictures.

In a SharePoint list view, the picture came out wonderfully. However, I wanted to be a little creative in SharePoint Designer.

So I created my data view and dragged my columns onto the page.

 

The Headshot value turned out to be something like this on the page. “http://intranet-porta/headshots/uzma1.jpg,”

When formatting the “@Headshot” value as a picture link was broken. All images in the list turned out to have an extra “,” at the end of the URL.

The work around is to create a XSL attribute, in my example, I created:

<img>

<xsl:attribute name=”src”>

<xsl:value-of select=”substring-before(@Headshot,’,’)” />

</xsl:attribute>

</img>

And it works like magic!

Creating Virtual Earth Map using SharePoint Designer

March 23, 2009

If you have a massive ERP or CRM system with hundreds of customers or client addresses, wouldn’t it be nice to see a lovely map of where they are located… anywhere in the world using Microsoft Virtual Earth?

SharePoint Designer is an incredible tool to use!

If you want to display a map underneath a display list which contains contact information, follow the step by step instructions given on this blog: http://blogs.msdn.com/sharepointdesigner/archive/2007/06/15/how-to-integrate-virtual-earth-maps-with-a-sharepoint-list.aspx

Multiple addresses are plotted using LON and LAT co-ordinates, so that involves quite a bit if work. You can re-use the list as given in the link below, create a lon and lat column and generate the co-ordinates using

Of course this is a long winded way to plot multiple data, you can simply change the parameters around to use address, zip code etc. instead.

Follow this blog to get detailed instructions on the “how to”. I found it easier to create a simple aspx page with  no master page first. Then create a page view to link up from a “sharepoint” page to the unbranded page. I found that with custom design pages javascript may make the map in a strange funky format.

Batchgencode was a great help. http://www.batchgeocode.com/

Please note, there are codeplex webparts available for virtual earth.. but this is the nice, handcoded version if you want to know the nitty gritty. Link to Codeplex.