Connect.Collaborate.SharePoint
Jul
28

I have just been to an ECM best practice session at TechReady and it is nice to know that I have followed the best practice. Although most people think about using content types for document libraries, they work just as well for lists.

On this site I have a resource list. There are many types of resources I wanted to track but each type had slightly different metadata requirements although they all had some metadata in common.

I created a base Resource content type that had all the columns that were in common. Some of these fields would also be mandatory.

Base resource content type fields

Then I created each of the resource content types that inherited the base Resource content type, adding the extra fields required.

Content types derived from base resource content type

It can be very hard to get the split between what should be a content type and what should just be a metadata column.  For example, I had created a content type for Web Casts but then I also found there were several other types of training material that I wanted to classify. I ended up going with only a Training content type which contained a column for the Course Type which has the values HOL, Web Cast, Instructor led, event recording, etc.

When it came to creating the columns for the content types, you have the option of creating the columns in the site catalogue or just in the list. I use a lookup list called Technology in my base Resource content type but I also use this lookup in a web part page document library so it made sense to make this a custom site column (even though it is just a lookup list) so that I have consistent values  selected for this field. This approach can also be leveraged by search and the content query web part if you have a MOSS server and want to roll up content from sub sites. Other columns would only ever be used in the resources list so that is where I created them and then added them to the appropriate content types assigned to the list.
 
Naming conventions are also important so that things don't get confusing. As you can see, I didn't do such a good job in this example.
Categories:SharePoint

 
Jul
27

Sorry for the long delay in posting, I’ve been learning new benefits and applications for SharePoint faster than I can share them.

I’m in Seattle this week for the Microsoft field employee TechReady conference. It has been good putting more faces to names and meeting some of the people responsible for the new features in the next version.

There are a lot of things I can’t demo on my site at the moment because my client/server versions are out of sync so I’ll have to save them until the beta 2 technical refresh is available.

One thing I have been using a lot is Microsoft Access 2007 to migrate data from my old sites many lists into the new resources list on this site. 

A new use for Access that I only just noticed is that when you create a list view there is an option to create an Access View. This allows you to create to create forms and reports that are based on this list.

Here are the Access view templates available in the UI

Access View

I guess the dilemma for many IT departments will be that they may have removed Access from the standard desktop build or, worse, only deploying Office Standard within their enterprise.

Access can now be treated as a valuable information tool for dealing with SharePoint data in a more application like way than just mirroring the list in Excel.

Categories:SharePoint

 
Jul
3
Continuing on with my “why would you want a Team Site on a MOSS 2007 server rather than just having a WSSv3 server” (can anyone tell I’m incented on selling MOSS?),  look at the difference in Site Collection administration options:
  1. WSS
    WSS Site Collection Admin
  2. MOSS 2007
    MOSS 2007 Site Collection Admin

From this you can see there are many more search and auditing/policy options. There is a problem with the current beta that prevents the MOSS 2007 search results page from being viewed by anonymous users. As soon as I can get around this I'll show how the optional site scopes and key words can be used.

Categories:SharePoint