Mike Smith's Tech Training Notes SharePoint, PowerShell and .Net!

12/29/2009

SharePoint: Add a “You are leaving this site” message to a links list.

This article is a variation of “http://techtrainingnotes.blogspot.com/2009/07/sharepoint-adding-popups-to-link-lists.html” and makes just one small change:

Replace:

links[i].target="_blank“

With:

links[i].onclick=function () {alert('you are now leaving this site')}

The links list web part is a quick and easy to add a list of links to vendors, other SharePoint sites or the most popular documents in a library. The problem is that the links list web part does warn users that they are about to leave your site (and you may have a legal reason to tell them so).

A typical links list:

To change a links list to display an exit message:

Add a Content Editor Web Part (CEWP) just below the links list web part
Modify the CEWP and set a title then click Source Editor
Copy and paste the HTML and JavaScript below
Edit the JavaScript to change the word “Links” to the name of your links list web part (title of the web part, not the title of the actual list, although they may be the same)
if (x(i).summary=="Links") to
if (x(i).summary=="Your Links List Title")
(If you are not sure, display your page, select Source from the View menu and search for “.summary”)
Also… in the Advanced section of the CEWP’s properties change Chrome to “None” to hide the CEWP
Exit the edit mode and see if it works

<script>
// CEWP trick from techtrainingnotes.blogspot.com!
// Find the link list  (change "Links" to your web part's name)
var x = document.getElementsByTagName("TABLE") // find all of the Tables 
  var LinkList
  var i=0;
  for (i=0;i<x.length;i++) 
  {
    if (x[i].summary=="Links")
    {
      //
      LinkList = x[i];
      break;
     } 
  }

// add a target to the <A> tags
var links = LinkList.getElementsByTagName("A") // find all of the 
  for (i=0;i<links.length;i++) 
  {
    links[i].onclick=function () {alert('you are now leaving this site')}
  }
</script>

12/23/2009

SharePoint: Wiki Search and Replace

Note: The following works in both SharePoint 2007 and 2010. Just be aware that the 2010 “Site Pages” library is also a wiki library!

Recently I was asked about how to do a search and replace on text in all of the articles in a wiki. As there is no built-in way to do this I wrote a simple web page to do this.

Note that the example below is trivial and:

Is presented as a learning exercise
Does not include a master page
Must be deployed to the Layouts folder of the web servers
Is case sensitive
Is over all not too flexible… but it is presented to get you started on your own nice looking page…

Background:

A wiki is a library (and a library is just a fancy list)
The content displayed in a wiki is stored in a column of the library named “WikiField” (creative huh!)
Accessing a list and updating data via the SharePoint API is pretty easy

What you could do to make this better:

Just about anything… ;-)
Add support for “Ignore Case”
Add a checkbox list of what was found and let the user decide to replace or not
Add the application master page and make this look like SharePoint
Write it as a little Windows application that calls the SharePoint web services so nothing has to be deployed to the web servers

Here’s what the page looks like:

To create this you will need to create a web page (ASPX) and a code behind file and copy them to the LAYOUTS folder on the web front end servers. You will then access the page by going to the site with the wiki(s) and navigating to the new page:
http://yourserver/sites/yoursite/_layouts/WikiSearchReplace.aspx

What’s the <SharePoint:FormDigest runat="server" /> about? See here.

The ASPX page: (WikiSearchReplace.aspx)

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="WikiSearchReplace.aspx.cs"
  Inherits="WikiSearchReplace" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ Register TagPrefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls"
  Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
  <title>Untitled Page</title>
</head>
<body>
  <form id="form1" runat="server">
    <SharePoint:FormDigest runat="server" />
    <div>
      Wiki Libraries:
      <asp:DropDownList ID="ddlWikis" runat="server">
      </asp:DropDownList><br />
      <br />
      <table>
        <tr>
          <td>
            Find what:</td>
          <td>
            <asp:TextBox ID="txtFind" runat="server" /></td>
        </tr>
        <tr>
          <td>
            Replace with:</td>
          <td>
            <asp:TextBox ID="txtReplace" runat="server" /></td>
        </tr>
      </table>
      <asp:Button ID="btnReplace" runat="server" Text="Replace" OnClick="btnReplace_Click" />
      <br />
      <asp:Label ID="lblResults" runat="server" />
    </div>
  </form>
</body>
</html>

and here’s the code behind: (WikiSearchReplace.aspx.cs)

using System;
using System.Web;
using Microsoft.SharePoint;

public partial class WikiSearchReplace : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        // Get a list of all WIKIs in the site and add to the dropdown
        // WIKI = SPListTemplateType.WebPageLibrary
        if (!IsPostBack)
        {
            SPWeb web = SPContext.Current.Web;
            foreach (SPList lst in web.Lists)
            {
                if (lst.BaseTemplate == SPListTemplateType.WebPageLibrary)
                {
                    ddlWikis.Items.Add(lst.Title);
                }
            }
        }
    }

    protected void btnReplace_Click(object sender, EventArgs e)
    {
        // Get the current site
        using (SPWeb web = SPContext.Current.Web)
        {
            SPList list = web.Lists[ddlWikis.SelectedItem.ToString()];

            int articleCount = 0;
            int occurrenceCount = 0;
            string wikiText = "";

            foreach (SPListItem wikiItem in list.Items)
            {
                wikiText = wikiItem["WikiField"].ToString();
                if (wikiText.Contains(txtFind.Text))
                {
                    articleCount++;

                    // a trick to get the word cound
                    int count = (wikiText.Length - wikiText.Replace(txtFind.Text, "").Length) / txtFind.Text.Length;
                    occurrenceCount += count;

                    wikiItem["WikiField"] = wikiText.Replace(txtFind.Text, txtReplace.Text);
                    wikiItem.Update();
                }
            }
            lblResults.Text = articleCount.ToString() + " articles updated, " + occurrenceCount.ToString() + " occurrences updated";
        }
    }
}

SharePoint: The security validation for this page is invalid

Note: The following applies to both SharePoint 2007 and 2010.

When creating an ASPX page in the LAYOUTS folder that updates SharePoint content via the API (mylistitem.upate) you may get the following message when posting back to the page:

2007:

2010:

Many articles on the web suggest using AllowUnsafeUpdates:

SPWeb web = SPContext.Current.Web;
web.AllowUnsafeUpdates = true;

While this works, it does open the page up to cross-site scripting vulnerabilities. (See here: MSDN)

A better practice is to add a FormDigest control to your page. (See details here: MSDN) If you are not using a master page or a complete “SharePoint page” then you will also need to add a Register line to reference Microsoft.SharePoint.WebControls.

The reference:

<%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

The control:

<SharePoint:FormDigest runat=server/>

A sample page:

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>


<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<SharePoint:FormDigest runat=server/> 
<div>
    <asp:TextBox ID="txtSomeText" runat="server" />
<asp:Button ID="btnReplace" runat="server" Text="Replace" OnClick="btnDoSomeWork_Click"  />
</div>
</form>
</body>
</html>

12/21/2009

SharePoint: Worst SharePoint Error Message?

(MOSS 2007)

“WSS_Search_servername on servername contains user-defined schema. Databases must be empty before they can be used. Delete all of the tables, stored procedures and other objects or use a different database.”

Just got this on one of my virtual machines:

I just love this part: “Delete all of the tables, stored procedures and other objects or use a different database.” That’s kind of like responding to “I can’t connect to the internet” with “format drive C: and start over”.

Either the developer was having a bad day or has a real attitude!

Is this important? Not really! WSS Search is only used in MOSS to index the SharePoint help files, and this only needs to be done once (at least until the next service pack potentially updates the search content). And, have you ever found this help content to be very helpful?

So for now… help works, but is just not searchable. You can still navigation the table of contents. (But I do have a fix at the end of this article…)

No results:	But should look like this:

How I got the error:

This message was displayed in Central Administration when I tried to start the search services. I’m not sure why they were stopped. I may have stopped them to improve performance on the VPC or they may have just stopped.

A similar error was logged in the Windows Event log:

The fix?

Go to Central Administration to the services on server list and click start for the WSS Search. Enter a new database name! I just appended a “B” to the end of the existing name. (You can now go to your SQL admin tools and delete the old database if you like.) I also had to do an IISRESET, but could have probably waited and it would have reindexed.

And… after you get it working and the content has been index, stop it! Or at least set the schedule so it only indexes once a night. The Help content NEVER CHANGES!

12/07/2009

SharePoint 2010: Change the passphrase

When you install SharePoint using an option other than Stand-Alone you will be asked for a “Passphrase” that can be used later on for things like adding a new server to the farm. This is especially needed if you let SharePoint 2010 manage your service account passwords where SharePoint will automatically change the passwords to strong, but unknown passwords.

I don’t think there is anyway to retrieve the passphrase if you forget it. If you need to change the passphrase after the install you can use PowerShell. (Don’t know PowerShell yet? You will…)

From your Start menu select “SharePoint 2010 Management Shell” or Start, “Microsoft SharePoint 2010 Products”, “SharePoint 2010 Management Shell”
Then enter:

C:\PS> $passphrase = ConvertTo-SecureString -asPlainText -Force
C:\PS> Set-SPPassPhrase -PassPhrase $passphrase -Confirm

The first line will prompt you for a password and store the secure version in the $passphrase variable.
The second line will prompt you to confirm the passphrase and then ask you if you are REALLY sure you want to do this.

I have not seen anything in TechNet on this command yet. For help on this command from PowerShell type:

help passphrase

help passphrase -examples

12/06/2009

Silverlight: Useful links

Below are some of the resources I refer to in my Silverlight classes.

These include:

Official Sites
Tutorial Sites
Best places to ask questions (forums)
What’s new in Silverlight 3
What’s new in Silverlight 4
Downloads
Other useful links

Official Sites:

They both claim to be “the official site”!

The Official Site of Silverlight
http://www.microsoft.com/SILVERLIGHT/
The Official Microsoft Silverlight Site
http://silverlight.net/

Sites for Expression Blend:

Expression Community site
http://expression.microsoft.com/en-us/default.aspx

MSDN Library for Silverlight

Home page for both 3 and 4
“http://msdn.microsoft.com/en-us/library/ee656762(VS.95).aspx
XAML “concepts”
http://msdn.microsoft.com/en-us/library/cc189054(VS.96).aspx
XAML object (tags) documentation (hidden in the JavaScript API section!)
Ver 3: http://msdn.microsoft.com/en-us/library/bb980170(VS.95).aspx
Ver 4: http://msdn.microsoft.com/en-us/library/bb980170(VS.96).aspx

Tutorial Sites:

Some really great video walkthroughs here:
http://silverlight.net/learn/videos/silverlight-videos/
Very good Blend videos here:
http://expression.microsoft.com/en-us/cc136522.aspx

A few samples:

Creating a Calculator
http://expression.microsoft.com/en-us/dd334537.aspx
Creating a Control Template in Expression Blend (Video)
http://expression.microsoft.com/en-us/cc263912.aspx
Customizing Silverlight Video Players using Expression Blend
http://expression.microsoft.com/en-us/dd565843.aspx
Optimizing Video for Silverlight Playback using Expression Encoder
http://expression.microsoft.com/en-us/dd565844.aspx
Using Runtime Storyboarding in Expression Blend
http://expression.microsoft.com/en-us/dd334536.aspx

Best places to ask questions:

MSDN forums:

Silverlight (formerly WPF/E) General Discussion
http://social.msdn.microsoft.com/Forums/en-US/silverlightgeneral/threads
Silverlight (formerly WPF/E) Designer Issues
http://social.msdn.microsoft.com/Forums/en-US/silverlightdesigner/threads

Silverlight.net Forums:
(As of 12/5/09: 178,572 threads and 222,975 posts, contributed by 67,146 members from around the world!)

http://forums.silverlight.net/default.aspx

Installation and Setup
Getting Started
Hosting and Streaming
New Features in Silverlight 3
Silverlight 4 Beta
Designing with Silverlight
Video and Media
Expression Studio
Programming with JavaScript
Programming with .NET – General
Silverlight Controls and Silverlight Toolkit
Visual Studio & Silverlight Development Tools
Report a Silverlight Bug
Accessing Web Services with Silverlight
Game Development
WCF RIA Services

What’s new in Silverlight 3:

What's New in Silverlight 3
http://silverlight.net/getstarted/silverlight3/
What's New in Silverlight 3
http://msdn.microsoft.com/en-us/library/dd772166(VS.95).aspx
New Features in Expression Blend 3
http://silverlight.net/getstarted/silverlight3/
What's New in Silverlight 3
http://www.silverlightshow.net/items/What-s-New-in-Silverlight-3.aspx
Video from MIX09
http://videos.visitmix.com/MIX09/T14F

What’s new in Silverlight 4:

What's New in Silverlight 4 Beta Documentation
http://msdn.microsoft.com/en-us/library/dd772166(VS.96).aspx
Ensuring That Your Silverlight 3 Applications Work with Silverlight 4 Bet
http://msdn.microsoft.com/en-us/library/cc645049(VS.96).aspx
Silverlight 4 - Breaking Changes since Silverlight 3 (things that break your Silverlight 3 app)
http://msdn.microsoft.com/en-us/library/cc645049(VS.96).aspx

Downloads:

CodePlex – 834 projects as of today!
http://www.codeplex.com/site/search?ProjectSearchText=silverlight
An “everything you need” list:
http://silverlight.net/getstarted/
Silverlight 2 SDK
http://www.microsoft.com/downloads/details.aspx?familyid=8D933343-038F-499C-986C-C3C7E87A60B3&displaylang=en
Silverlight 3 SDK
http://www.microsoft.com/downloads/details.aspx?FamilyID=1ea49236-0de7-41b1-81c8-a126ff39975b&displaylang=en
Silverlight 4 SDK??? See the beta info for now:
http://silverlight.net/getstarted/silverlight-4-beta/
http://msdn.microsoft.com/en-us/library/cc838158(VS.96).aspx

12/03/2009

SharePoint 2010: Office Web Apps – The “in browser” Office

One of the cool features demo’ed with SharePoint 2010 are the “in browser” Office Web Apps. These are browser based versions of Word, Excel, PowerPoint and OneNote. But… you won’t find these when you download and install Beta 2. They are a separate download and install.

Cool stuff:

Create, View and Edit Excel, Word and PowerPoint documents (BUT only Office 2007 and 2010 documents – docx, pptx, xlsx)
View and edit Word documents
Co-author Excel files (really! two people editing the same file at the same time and see each other’s changes as they are made!)
View PowerPoints, with transitions, fades, etc! In the browser or as a full screen slide show.

Things to download and notes:

The instructions: Deploy Office Web Apps
The license key is in the above document!
The install file: WcServer_?????.exe (you can download one of seven language versions) (WcServer_en-us.exe for English)
Run the install
If you installed SharePoint as a “Standalone install” (Basic install) then do not follow the instructions in the above word document to enable the services, they were already running. All I needed to do was to go to the site collection and enable the “Office Word Apps” feature. All done… that’s all…

Other notes:

So far I have not seen how to create a new document using these features. The New button in the library still launches the desk top application.

Excel Web App in View mode:

In Edit mode:

Mike Smith's Tech Training Notes
SharePoint, PowerShell and .Net!

Pages