Thursday

Enable anonymous access in SharePoint

For no curious reason, I wanted to turn on anonymous access to my test site. So I got this handy link which was published by Microsoft.

Enable anonymous access
Applies to Microsoft Office SharePoint Server 2007 / Windows SharePoint Services 3.0

Enjoy your day

Friday

SharePoint List Filter/Search Using OOTB Web Parts

Today I am going to describe a simple way to search/filter a list using a Text Filter Web Part.

I have this scenario, Client wants to search a list without having to use SharePoint Search or leaving the web page.

Solution:

Note: To do this for the first time, create a test web part page to add the web parts.

  1. Create a new Web Part page. Save it as List Search.aspx
  2. Add Text Filter WebPart to the new aspx page
  3. Add the List (to be searched) to the page above using SPD
  4. Create a Parameter for the List column you want to search
  5. Filter the Data View Using the Parameter
  6. Connect Parameter on Data View to Text Filter

Create a new Web Part Page


Add the Text Filter to the Web Part page



Add List to be searched using SPD. Drag and drop the List as a DatasheetView Web Part


Edit the Columns and add the columns you would prefer to see on the List View.
Then click the List "Common Data View Tasks" and select "Filter".



Then select the column you would like to filter as the "Field Name", contains as the "Comparison" and CREATE NEW PARAMETER as the value.


In the resulting window, type in a name for the new parameter "NameSearch" and select Form and add a name for the Form Field.

Because you have applied a parameter, the List should not show any data.
Then save the ASPX page and return to the site in IE.

You now need to do a Web Part connection so that the Text Filter will send values to the List View.
Go to Edit View of the page in IE. 
Click the Web Part properties to select connection > Get Parameters From > Filter : [Text Filter Name Title] (in my case Filter: Column Search)


In the Configure Connection dialog window select '[Parameter Name]' (in my case Column Search) from the pull down menu and click the Finish Button.  

Now the Column Search/filter is now ready to use. You can test you see if you get any results using data from the column you have selected.













Tuesday

FIX: "New user account does not have a valid SID history"

Now, this was an issue I tackled recently.
I had a client who wanted to do a name change in SharePoint which should be a normal easy thing to do using the STSADM command MigrateUser. See my post on that here Name Changes for SharePoint User.

But on following the steps in my post I encountered an Error "New user account does not have a valid SID history" ...uhmmm strange!

So I thought, what would I do to resolve this. I know! google it. But the google results I got didn't really resolve my issue. I then looked into the SQL database to find the user info.




My query returned a strange result tp_token was NULL and the newlogin was not found.

So I decided to perform a force "-ignoresidhistory"

Then I ran into a brickwall. uhmm worse.
Ok, lets make things simple.
1. Add the new user login to the Site Collection
   - Site Actions > Site Settings > People and Groups
   - Add new user > Type the new user login details > Click Ok

2. View the new user profile
   - Move mouse over new user account in SharePoint
   - Copy the new user account ID
   - Go to http://servername/_layouts/userdisp.aspx?Force=True&ID=[ID Copied from above]
3. Delete new user account from Site Collection
4. Ask user to visit the site collection again.
5. A new user account ID is created. Problem fixed. User details updated.

Monday

Where's the Web Part Gallery

Well, this is a simple one.
1. Browse to the Site collection root site
2. Click Site Actions > Site Settings (you must be site collection administrator to do this)
3. You should see Site Collection Administration (if you don't, then you don't have the permissions to)
4. Then Under Galleries you'll see Web Parts

You can then upload new web parts for use within the Site Collection