Pat's .Net and Sharepoint Blog

XSLT Code to output a hyperlink column in Sharepoint Designer

<Patrick/> — Thu, 11 Dec 2008 18:31:49 +0000

              /_layouts/FormServer.aspx?
              XmlLocation=

              &
              OpenIn=Client�

Using a Replace Web Service in a Sharepoint Web Based InfoPath form

<Patrick/> — Wed, 10 Dec 2008 21:24:23 +0000

Due to the lack of an easy way to do a find and replace in InfoPath, I developed a simple web service with a web method called replace that uses managed code to call the replace method of the string data type. Here’s how I call the web method in a browser-based Sharepoint InfoPath form.

First create a form like so..

With fields txtFind, txtReplace and txtText

The idea in this sample form is to replace mother with sister in the text “Don’t forget to call your mother today!”
The next thing you must to is create a new data connection.

You should first see if your Sharepoint server already has a data connection to the Replace web method

Enter the URL of the site like in the above image and then expand the data connections.

Select the Replace.udcx data connection. If you do not see this data connection you must create a new data connection to receive data and then select the web service

Once you have created the web service data connection you must convert it to a data connection file that you must store in a data connection library in your Sharepoint site.

Now you will be presented with the data connection wizard

The web method requires three parameters:

Text: the text you want to do the search and replace on
stringToFind: the text you want to replace ie mother
stringToReplace: the text you want to replace it to ie daughter
escapeSpaces: If you are having difficulty with spaces in your strings and need to use %20 then set this to true otherwise default it to false

For now don’t set default values and click on next, next deselect Automatically retrieve data when form is opened and then click on finish
Your data connection has now been created

So the next thing we need to do is create some rules for our button

The rule will have the following actions - set each of the parameters of the data connection , then query the data connection and then set the txtText value to the result of the data connection query

For the first rule we set the text parameter of the Replace datasource to the value of the txtText field. (make sure to select the Replace data source and not the main data source)

Then create the following actions so that it looks something like this:

Now test out your rule by previewing the form

Click on the Replace button and the text shoudl read Don’t forget to call your daughter today!

Here’s the code for my web method:

_
Public Function Replace(ByVal text As String, ByVal stringToFind As String, ByVal stringToReplace As String, ByVal escapeSpaces As String) As String

If escapeSpaces.ToUpper = “TRUE” ThenstringToFind = stringToFind.Replace(” “, “%20″)

End If

Return text.Replace(stringToFind, stringToReplace)

End Function

Replace XSLT Template for Sharepoint Designer

<Patrick/> — Wed, 03 Dec 2008 20:00:48 +0000

If you need to do a find and replace when outputting a column in a data view you can use the following:
�












�
Call the template code:
Say you have a column named ColumnName and you want to replace all occurrences of True and set them to False…..

�

Line feeds / Line breaks Sharepoint Dataviews

<Patrick/> — Tue, 02 Dec 2008 20:24:37 +0000

After having published an Infopath form with a rich textbox field to a document library, I created a dataview of the list.

The column that came from the rich textbox control (Comments) lost it’s linebreaks. In order to fix the problem I used the following code:

�

Infopath Forms Services Form opens in browser but as XML

<Patrick/> — Sun, 26 Oct 2008 19:13:58 +0000

When opening an infopath form the XML code appears in the browser.
Open Infopath go into Tools / Options
Check – Check whether Microsoft Office is the default program for opening and editing .xml files

�

Updating Sharepoint 2003 Infopath Forms to 2007

<Patrick/> — Fri, 26 Sep 2008 19:36:31 +0000

When you migrate a form library from Sharepoint 2003 to Sharepoint 2007 references to the Form template will still point to the 2003 form library.
If you need to update the reference Sharepoint has a relink documents feature to individually re-link the xml forms to the appropriate template.
Unfortunately this process can be rather cumbersome especially if the form library contains sub folders. To alleviate this painful process
I developed a tool that with go through an entire directory structure recursively and do a find and replace on the template (.XSN) file.
What you will need to do is go into the explorer view of the form library, copy all files and folders to a location on your local hard drive.
Then open up the “UpdateInfopathTemplate” utility and update all the xml forms. Then copy all the forms back to the destination form library in 2007.

Click here to download the utility

Toronto Stock Exchange (TSE) Stock Quote Sharepoint Web Part

<Patrick/> — Tue, 26 Aug 2008 20:00:38 +0000

The Stock Quote Web Part is a custom web part that displays stock information from Yahoo Finance. It allows users to lookup stocks on either the TSE or NYSE

Click here to dowload the Web Part

�

Minimal Sharepoint Application Page Code

<Patrick/> — Sat, 26 Jul 2008 20:05:20 +0000

Below is some code to get you started on creating your own Sharepoint Application Page so that it looks just like the built in ones!

<%@ Assembly Name=”Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c”%>
<%@ Assembly Name=”CheckInAll, Version=1.0.0.0, Culture=neutral, PublicKeyToken=70b886b56e89f448″ %>
<%@ Page Language=”VB” MasterPageFile=”~/_layouts/application.master” Inherits=”VSeWSS.CheckInAll.CheckIn” %>

Check-In: All Documents

contentplaceholderid=”PlaceHolderPageTitleInTitleArea” >
Check-In: All Documents

�



�






�

   �

   �

Check-In Document

      �
                   Add comments to all the documents you are checking in
�

   align=”left” >

       �
  �











    �

Comments:

      �

Using the Sharepoint SPSiteMapProvider to Populate a TreeView Control

<Patrick/> — Wed, 25 Jun 2008 17:58:48 +0000

Here’s a very simple way to populate a TreeView Control using the SPSiteMapProvider.

Just copy the code below, create an aspx page, name it what you want and then copy it to

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS

Code for the application page:

<%@ Assembly Name=”Microsoft.SharePoint.ApplicationPages, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c”%>
<%@ Page language=”C#” MasterPageFile=”~/_layouts/application.master” %>
<%@ Import Namespace=”Microsoft.SharePoint.ApplicationPages” %>
<%@ Register Tagprefix=”SharePoint” Namespace=”Microsoft.SharePoint.WebControls” Assembly=”Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c” %>
<%@ Register Tagprefix=”Utilities” Namespace=”Microsoft.SharePoint.Utilities” Assembly=”Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c” %>
<%@ Register Tagprefix=”WebPartPages” Namespace=”Microsoft.SharePoint.WebPartPages” Assembly=”Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c” %>
<%@ Register Tagprefix=”wssawc” Namespace=”Microsoft.SharePoint.WebControls” Assembly=”Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c” %>
<%@ Register Tagprefix=”SharePoint” Namespace=”Microsoft.SharePoint.WebControls” Assembly=”Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c” %>
<%@ Register TagPrefix=”wssuc” TagName=”ButtonSection” src=”~/_controltemplates/ButtonSection.ascx” mce_src=”~/_controltemplates/ButtonSection.ascx” %>
<%@ Import Namespace=”Microsoft.SharePoint” %>
<%@ Import Namespace=”Microsoft.SharePoint.Navigation” %>
<%@ Import Namespace=”System.Net” %>

�

              �

” runat=”server”/>

  �

      �

          �

                                                    ID=”TreeView1″
                            ExpandDepth=”3″
                            Font-Names= “Arial”
                            Font-Size=”10pt”
                            ForeColor=”Blue”
                            NodeWrap=”true”
                            runat=”server”
                            >

�

Ohh baby I found some goodies today!

<Patrick/> — Tue, 10 Jun 2008 22:58:19 +0000

Check out all these cool features you can install on your dev VPC’s….

http://www.codeplex.com/features

I’ve installed the Debugger feature and it’s already saving me some time!

I must admit going into the Debug menu selecting the three or four worker processes and then clicking on the Attach button was getting pretty tedious.