Links (5/31/2009)

1. New release for SPExLib with SharePoint Linq extensions
2. Taming the Elusive “Calculated Column” – Date and Time – Part 2
3. SharePoint Developer Productivity Tip #2 – Easy Site Column Features
4. Step by step tutorial : using the Content Query Web Part /Enhanced Query Web Part (MOSS 2007)
5. SharePoint Content Type, Document Template and Default Metadata Choice in Custom DIP
6. Free SharePoint Master Pages
7. Transitioning From SharePoint Designer to Expression Web
8. Enabling an Information Policy for expiring content
9. Put a windows form on a SharePoint web site
10. Activating Content Type Feature at Web Application Scope
11. Google Wave & SharePoint
12. Sticky posts in SharePoint Discussion boards

Links (5/28/2009)

1. Check that a user has a SharePoint MySite
2. Create MySites using C# and the SharePoint 2007 object model
3. How to redirect on new Page at Item Deleting in SharePoint ECB Menu?
4. Render the all the column of links list through BaseFieldControl
5. Clean up SharePoint’s UI with jQuery
6. Data View Web Part, The Basics – Keep it Clean
7. Data View Web Part, The Basics – Multiple Edit Forms
8. SharePoint can have Wildcard searching…
9. Using jQuery to Display Image Thumbnails in a Document Library
10. Be Careful Using PublishingWeb.GetPagesListName()
11. Creating Lists using SharePoint Object Model
12. SPWebConfigModification Works Fine
13. Control the Content Types in the New menu via code
14. How to set the Outcome/Workflow Status column to Approved or Rejected while using the SpWorkflowTask.AlterTask API to alter the tasks programmatically?
15. Custom Field Controls in Data Form webpart does not save data in Database
16. Synchronize with SharePoint under the hood
17. TunnelPoint and ProduShare
18. Top Blogger Web Part – No code required
19. You Can Pry SharePoint Designer From My Cold, Dead Hands
20. Silverlight Video: MOSS and OpenText Deployment Overview
21. Secondary Workflow Example in SharePoint Designer
22. An Alternative for the Modal Popup in SharePoint 2007
23. Populating the BDC Field of a SPListItem from client application
24. Custom Bound Fields in FieldGroup
25. HOW TO : Customize the Enterprise Search in MOSS 2007
26. Results from the SharePoint Implementation Approach Survey

Error during Search Crawl (Post SP2)

Last week I ran into an interesting issue while preparing for my presentation at COSPUG Show & Tell. The application I demo uses Search results for displaying documents. Typically, I turn off full and incremental crawls in my VM to save a few cycles. Since my demo relies I search, I set the search schedules and waited; unfortunately after the incremental crawl ran a few times, none of my search results were returning anything. I then manually kicked off a full crawl – again no results. Dang, maybe my search index is hosed? Reset the index and full crawl – no results. 

I checked out the Event Viewer and had tons of these messages (every time a full or incremental crawl ran):

Event Type: Warning
Event Source: Windows SharePoint Services 3 Search
Event Category: Gatherer
Event ID: 2436
Date:  05/20/2009
Time:  12:30:41 pm
User:  N/A
Computer: SERVERNAME
Description:
The start address <http://servername:20000/sites/sitename> cannot be crawled.

Context: Application ‘SharedServices1’, Catalog ‘Portal_Content’

Details: The object was not found.   (0x80041201)

OK, not a helpful error message. Searched Google and lots of resolutions related to AAM and other things which didn’t seem to fit my scenario. I then checked out the Search Logs in the SSP and found the following errors:

The object was not found. (The item was deleted because it was either not found or the crawler was denied access to it.)

The object in my case was http://servername:20000/. Which is interesting because I don’t have a site at the root. Hmm. Let’s add a blank team site at the root and try again. Yeah! Success! Search works!

Summary:

1. SP2 (or a update between SP1 and SP2) made having a site at the root to search a requirement. I have talked to a few SharePoint administrators and they all said I should have had a site at the root anyway (Sean McDonough had a blog post from 2007 on the subject); however, search was working fine prior to installing SP2 without the root site.
2. Lesson learned. If you have a separate VM for demoing, leave well enough alone and avoid rocking the boat by upgrading (or at least ensure you have enough time to dry-run your demo) unless you absolutely need to. Would have looked like a real sap if I didn’t find the search issue prior to delivering my presentation.
3. SharePoint has many locations to find errors. Just a matter of looking in the right location.

Links (5/25/2009)

1. “The security validation for this page is invalid” when calling the SharePoint Web Services
2. STSADM Technical Reference Chart
3. Using SharePoint Object Model to add entries to web.config
4. jQuery – Content Management Web Part
5. Retrieving an Item from the RootWeb and Subwebs using its UniqueId
6. How to allow Full Control permission to a user in a SharePoint List
7. Get SPList from List URL
8. SharePoint: SPList.Clear() extension method
9. Customizing the Site Actions menu
10. CompleteSharepoint.NET v2.0 – Content Management System Built on Top of WSS 3.0 – Documentation
11. SPDevExplorer – edit SharePoint content from within Visual studio (1)
12. SPDevExplorer – edit SharePoint content from within Visual studio (2)
13. SPDevExplorer 2.1 – edit SharePoint content from within Visual studio (3)
14. SPDevExplorer 2.3 – Edit SharePoint content from within Visual Studio (4)
15. Consume Reusable Content outside of Page Content field Controls
16. WSRPConsumerWebPart does not have unique ID for userContextKey
17. Timer Job Status Page
18. Accessing columns in the User Information List
19. Content Query Web Part example
20. Manage WebParts of Page Layouts through a feature: Resolving the “AllUsersWebPart”-pain – Part 1
21. Manage WebParts of Page Layouts through a feature: Resolving the “AllUsersWebPart”-pain – Part 2
22. Modify a date-time value field in Event Handlers – Through AfterProperties
23. Reusing SPSchedulePicker Control
24. The marvellous SPList.RenderAsHtml

Post-SP2, Check your License

Sean McDonough sent out an email to the Cardinal team today letting us know there have been reports that after installing MOSS SP2, the license reverts back to Trial. To check, go into Central Admin > Operations > Convert License Type and see what your license is. If you are back to Trial, re-enter your license and you should be good to go. It appears to affect both Project Server 2007 and MOSS 2007. I had reverted back to Trial when I checked my license.

Links (5/21/2009)

SharePoint

1. Excel Services Getting Started – Pt4 Web Service APIs
2. Introducing SharePoint Extensions Lib – Great idea. I have a few extensions I could pass along as well.
3. Determine the URL of SharePoint Web Services using jQuery/Javascript
4. How to programmatically complete Approval workflow task
5. Developing SharePoint WebParts using User Controls and Web Applications
6. Tip: The untold story of Audit Logs in SharePoint
7. Applications Can’t Use SharePoint Master Pages
8. MOSS: Using the List Web Service to Rename a File
9. Making SharePoint Title a Calculated Column
10. Getting SharePoint Site/Web Context in a Console Application
11. Common Problem MySite and MyLinks don’t show up
12. Running a WCF service in the context of a particular SharePoint 2007 web (or subweb)
13. Customizing the AssetUrlSelector
14. Multi-Value Columns in SharePoint Designer – Solution #1
15. 22 Minute Screencast: SharePoint Designer Workflow – Part 3
16. Guest Blog by FiveSix Consulting’s Tamara Austerlade – 6 Tips for a Successful SharePoint Demo
17. Simplified People and Groups pages in SharePoint
18. Use jQuery to populate and hide fields in an EditForm.aspx
19. Show Site, List or Item information on Pages
20. Rich Text Fields in SharePoint Document and Picture Libraries
21. SharePoint on the iPhone?
22. Exposing Enterprise Search in SharePoint Server 2007 by using Internet Explorer 7 and the Office Research Pane
23. Customize SharePoint RSS Feeds
24. Usenet Newsgroup Browser in SharePoint
25. SharePoint Interview Questions and Answers
26. How to configure the SharePoint people picker to search for users in other domains
27. TDD with SharePoint – the best movie ever
28. SPWebConfigModification adds the entry in web.config, but does not remove it
29. Optimizing SharePoint SQL Databases and Top Performance Killers
30. Multi-Source Search in SharePoint
31. SharePoint Groups vs. Active Directory Groups
32. New version of our “Assembly free” Timesheet Application

Office

1. Top tips for using Office 2007 on your netbook

Unit Testing with SharePoint and ASP.NET – TypeMock Isolator

Unit Testing ASP.NET? ASP.NET unit testing has never been this easy.

Typemock is launching a new product for ASP.NET developers – the ASP.NET Bundle – and for the launch will be giving out FREE licenses to bloggers and their readers.

The ASP.NET Bundle is the ultimate ASP.NET unit testing solution, and offers both Typemock Isolator, a unit test tool and Ivonna, the Isolator add-on for ASP.NET unit testing, for a bargain price.

Typemock Isolator is a leading .NET unit testing tool (C# and VB.NET) for many ‘hard to test’ technologies such as SharePoint, ASP.NET, MVC, WCF, WPF, Silverlight and more. Note that for unit testing Silverlight there is an open source Isolator add-on called SilverUnit.

The first 60 bloggers who will blog this text in their blog and tell us about it, will get a Free Isolator ASP.NET Bundle license (Typemock Isolator + Ivonna). If you post this in an ASP.NET dedicated blog, you’ll get a license automatically (even if more than 60 submit) during the first week of this announcement.

Also 8 bloggers will get an additional 2 licenses (each) to give away to their readers / friends.

Go ahead, click the following link for more information on how to get your free license.

Speaking at COSPUG Show-N-Tell

I’ll be speaking at the COSPUG Show & Tell event on May 22nd. My topic is as follows:

Business Track: Legal & Regulatory Compliance through Advanced Document Management

SharePoint is a great tool for sharing, securing, and centralizing the management of documents and content. Managing these assets through SharePoint provides administrators with a number of capabilities to help satisfy legal and regulatory compliance initiatives (basic auditing, versioning, reporting and document policies). In this session we will examine how organizations can extend SharePoint functionality to automate document disposition and retention and provide legal holds throughout their SharePoint environment and in accordance with their regulatory needs and processes.

The COSPUG SharePoint Show & Tell is an educational, informative & lively day filled with sessions from users within the SharePoint community. During each session, presenters will show real life examples of the different uses of SharePoint within their organization. SharePoint Show & Tell is FREE, open to the public and is your local chance to learn firsthand what others are doing with SharePoint! The event details are as follows: Friday, May 22, 2009 8:00 AM – 4:30 PM @ the Microsoft Polaris office. Click here to register! Space is limited, so register early!

Link

Links (5/17/2009)

1. The Summary Toolbar in a ListView Web Part
2. Specifying relative URLs to Silverlight WCF EndPoints
3. Developing Application Pages for SharePoint
4. How-To: Overcome missing Exists() function on SharePoint objects like SiteGroups, RoleDefinitions, Lists etc.
5. SharePoint Generic Wrapper for Silverlight with initParams
6. Rounded Corners in SharePoint
7. Passing Multiple Query String Variables Using SPD – Follow Up on Creating Parent / Child List Relationships
8. April Cumulative Update Packages Ready for Download
9. Doing Agile in a Team of One
10. What are SharePoint Content Types?
11. Working with Structured Data in Microsoft Office SharePoint Server 2007 (Part 4): SharePoint Designer
12. How-To: Create a SharePoint list programmatically
13. Ever wanted to remove non business hours from SharePoint Calendars?
14. How To Change the Default EditForm, NewForm and DispForm
15. SharePoint Designer Gotcha: Where’s the “action” in my Form Action button?
16. Working with Structured Data in Microsoft Office SharePoint Server 2007 (Part 4): SharePoint Designer

Links (5/14/2009)

SharePoint

1. Pointing the ListViewWebPart at a particular view
2. Sort SPFolder in SharePoint
3. SharePoint: SPList.HasView() extension method
4. SPQuery Value Type Lookup Fails on Indexed Columns
5. SharePoint Search Results: Adding a link to the view properties page of a document
6. Steps to get the Reporting Services SharePoint Add-on Installed
7. Custom Timer Job in SharePoint
8. Workarounds for ItemAdding/ItemAdded Event Handlers
9. The impact of browser speed on your SharePoint app
10. SharePoint Saturday Chicago – June 13th
11. MOSS 2007 – create your own customized usage report solution step by step
12. SharePoint Development MVP Panel Discussion Review
13. Figuring out a alternative to Cross-Site Lookups
14. SharePoint guidance v2 – drop 9
15. How to Disable Property Promotion In WSS
16. Update on SharePoint forms based authentication(FBA) and Office client
17. How to Configure SharePoint Treasure (Synonym) In MOSS 2007
18. SharePoint is not a Database!
19. SharePoint and Silverlight – Displaying Silverlight in a Page
20. Enumerate Role Assignments to retrieve Groups and Users Permissions – Generating a complete report
21. Add Alerts to All Sites
22. Using Word QuickParts to Enter Metadata for SharePoint
23. JQuery for Everyone: Accordion Left-nav with Cookies Speed Test
24. Code Console Web Part
25. Pointing ListViewWebParts at lists
26. April Cumulative Update Packages Ready for Download
27. SharePoint Cumulative Update Packages (April 09)
28. Data View Web Part (DVWP) Series
29. SharePoint for Developers Tour Part II
30. Application Pages like a Site’s Pages
31. UpdateListItems vs ProcessBatchData to create Folders

Office

1. InfoPath 2007 to PDF Conversion: So Groovy!
2. Part 1. VSTO Bug Tracker : The Data
3. Part 2. VSTO Bug Tracker : The Web Service
4. Part 3. VSTO Bug Tracker : A UDF
5. Part 4. VSTO Bug Tracker : Getting the data into Excel
6. Part 5. VSTO Bug Tracker : Using Cached Data
7. Part 6. VSTO Bug Tracker: Word Report Generation
8. Part 7. VSTO Bug Tracker : Using Document-Level Features in Add-Ins
9. Part 8. VSTO Bug Tracker : Using a Ribbon

Links (5/10/2009)

1. Programmatically creating a SPFieldCalculated
2. Web Browser support for SharePoint 2007 with SP2
3. MOSS2007 – Incoming Email (Multi SMTP Domain Configuration)
4. ChartPart for SharePoint 2.0 video demonstration
5. SharePoint 2007 – Inline CSS Styles to Customize Pages
6. Customizing the ContentQueryWebPart: Custom XSL Files, Subclassing, Passing Parameters and more…
7. UpdateListItems Web Service fails when using item level permissions
8. zevenseas FeatureBlocker updated
9. Form Web Part
10. Release version of our “Assembly free” Team status Template
11. Bringing TunnelPoint to the “Assembly Free” solution party
12. How to install MOSS 2007 SP2 on Windows 7 RC (build 7100)

Links (5/7/2009)

SharePoint

1. Using jQuery in SharePoint to Display Notifications for Open Tasks
2. Querying SharePoint List Items using jQuery
3. Excel Services Getting Started – Pt3 EWA
4. Creating a Line of Business Application with SharePoint and Word 2007 – Part 1: Creating the Ribbon and Actions Pane Control
5. SharePoint of the Day #27
6. How to customize the Item Form pages for the SharePoint Lists such as NewForm.aspx, DispForm.aspx and EditForm.aspx
7. Teeny-Tiny Rich Text Boxes
8. Customizing the ContentQuery WebPart: How to create Header/Footer, UL/LI and other “impossible” things
9. MCTS 70-631: WSS3.0 Configuration Certificate
10. Event Receivers on Content Types
11. SharePoint in Web 2.0 FireStarter…
12. Automaticity approving comments from internal members on your Blog
13. Comprehensive list of development tools for SharePoint Server 2007
14. SharePoint Tip/Trick: Specifying a Relative Portal Site Connection Link
15. SharePoint Saturday DC – Calendaring in SharePoint, How did it go?
16. zevenseas Tools Recap
17. FAST search engine for SharePoint PART 3 (Content Sources and Connectors)
18. Event Handlers cannot be triggered by an anonymous user
19. SPSource v1.0.0.0 Released!
20. Running SharePoint on Windows 7
21. Installing WSS 3.0 SP2 / MOSS SP2 on Windows 7 RC
22. Contextual Search Results Page Redirection via HTTPModule
23. showing items saved to My links on sharepoint site filtered by group

Office

1. Got the presentation blahs? Use Office images to add some spice to your PowerPoint presentations

Quick Way to Add Web Parts to Page

As most SharePoint consultants, I would quite a bit with end users. Invariably I get asked the following question. “Can you talk with Microsoft and see if they can add a feature to allow me to specify how many Web parts to add to a page at a given time?”. Unfortunately I don’t have a Bat phone into Redmond, but I have an option.

If I want to add three Content Editor Web Parts (CEWP) to a page, do the following:

1. Select Site Actions > Edit Page
2. Click the “Add web parts” link in the Web Part Zone you want to add the CEWP.
3. In the “Add Web Parts” dialog, check the CEWP option and click the Add button.
4. To add the second CEWP, click the F5 button.
5. Bam! A new CEWP has been added.
6. Click F5 again to add the third CEWP.

You can add as many as you want by repeatingly clicking the F5 button. If you want the CEWP to another Web Part Zone, click F5 to add it and drap and drop it to the new Web Part Zone.

Links (5/3/2009)

SharePoint

1. Join SharePoint Lists with LINQ
2. Creating and Working with SharePoint Timer Job Definitions
3. Where is My Timer Job?
4. Building Excel 2007 and Excel Services Dashboards by Consuming Two-Dimensional Data from Web Services
5. Getting XML Data From a SharePoint List – The Easy Way
6. Inconvenient opening sites – SPSite.OpenWeb()
7. Developing for Office and SharePoint Server 2010 (Christin Boyd)
8. Building a MOSS Workflow with Visual Studio 2008 and InfoPath
9. SharePoint SDK 1.5 (April 2009) Released!
10. Why SharePoint Projects Fail
11. Extracting a WSP file from a SharePoint farm
12. Service Pack 2 for SharePoint Products and Technologies (white papers)
13. Set SharePoint navigation tree to only expand to the current node
14. Background jobs will not always work against Forms Based Authentication configured servers
15. MOSS2007 – Using the Search API (Part 1)
16. New in SP2 PreUpgradeCheck
17. XSLT converted Web Part (list view) breaks Item level permission as per the UI
18. Howto disable autocomplete for an entire SharePoint farm
19. Red is Green, Up is Down and the Unsupported suddenly becomes Supported!
20. Error Importing Sites with Calculated Columns

Office

1. Using the Contact Selector Control in InfoPath Forms
2. More details on OneNote 2007 SP2 – Full change list