Monday, August 27, 2007

Using SSRS/SSIS to Report on SharePoint Data

Good information...we are often asked for reports o our portal.

"To effectively report on SharePoint data using SQL Server Reporting Services (SSRS) you must copy the data into SQL Server using SSIS. Unfortunately, SharePoint out of the box does not have a solution for reporting on its own data other than configuring list views or building data views. Building a reporting database gives developers a powerful toolkit for building high-performance reports while off-loading the burden of report processing from SharePoint. "

Monday, August 20, 2007

Searching SharePoint Sites from the IE7 Search Bar

Another great article by Tony Zink...this is a great idea for corporate intranets using IE7 and SPSS 2007.
Article excerpt:
Searching SharePoint Sites from the IE7 Search Bar

For those of you who have made the upgrade to Internet Explorer 7 (IE7), you probably have some likes and dislikes regarding the tabbed browsing feature, new security features, and the menus / toolbars / buttons layout. One of the interesting new features, however, is the search bar, which allows you to use a number of search engines, such as Google, Yahoo, and Windows Live Search… without the need to navigate directly to their sites.

But what about your corporate intranet… more specifically, what about your SharePoint environment? IE7 not only allows you to select from a list of major search engines, but it also allows you to add your own search provider. Since SharePoint has an internal search engine, why not add that to our list of IE7 search providers, making it easier for us to search for organizational artifacts… right from our IE7 search bar?

Here's how…Searching SharePoint Sites from the IE7 Search Bar

How to Create a MOSS 2007 VPC Image: The Whole 9 Yards

This is a well-written, very detailed article by Tony Zink on building a VPC MOSS 2007 image. Tony does what Microsoft has not in outlining the steps to build a great development MOSS 2007 image. He even includes screenshots on every step...nice job Tony.

Thursday, August 16, 2007

Development Tools and Techniques for Working with Code in Windows SharePoint Services 3.0 - 2 Part Series

MSDN Article by Patrick Tisseghem

Summary: Learn the skills you need to develop for Windows SharePoint Services 3.0, about the differences from traditional ASP.NET development, about the required development environment, and the steps to build a Windows SharePoint Services solution with Visual Studio 2005 Extensions for Windows SharePoint Services 3.0. This article is part 1 of 2. (33 printed pages)

Here's the link for Part 1:

Here's the link for Part 2:

How to filter a SharePoint list or library by workflow (approval) status

Interesting article on workflow approval status filtering.

Recently I had a client who wanted to show only "Approved" documents (i.e. documents that had been through the built-in Approval workflow) on a site's home page. When I tried to set up the filter, setting the [Workflow Status] field to Approved, the filter returned no results. As it turns out, workflow status is stored as a numeric value.

The values are as follows:
In Progress - 2

Complete - 5

Canceled - 15

Approved - 16

Rejected - 17

The view filter needs to look like this:

Wednesday, August 15, 2007

Blogger, Robots.txt and Google SiteMaps

Finally ran across a snippet of info that helped me put a sitemap in Google Webmaster Tools for my blog...go check it out.

SQL Server 2005: Importing from Excel error

I found this blog post the other day during another search...interesting thing is I ran into this exact issue 6 months ago and was not able to figure out the problem - too bad i did not see this sooner.

Friday, August 10, 2007

Help: Backfilling data into a Sharepoint List

One of my current requirements is to load data from a legacy system into a SharePoint list. There is not too much on the web for doing this...any link/resources would be much appreciated.

Sync Your Database to SharePoint Using SSIS

Great article...we ahve been struggling with this for some time.