SharePoint

SharePoint and Database Maintenance

In this post I would like to point to “an issue” with the Database Maintenance for Microsoft® SharePoint® Products and Technologies. It shows a stored procedure, which will defragment the index of a database. How to defragment Windows SharePoint Services 3.0 databases and SharePoint Server 2007 databases The problem is that it is mentioned nowhere, that the stored procedure requires the Enterprise version of the SQL Server 2005!

Issues in WSS V2

Responses to items in an Issue list (SPListIssue) are new version in WSS V3. WSS V2 lacks the ability to use versions for lists. So what did Microsoft do that an Issue list behaves like it is using versions? In WSS V2 items in a single “thread” all have different ItemIDs. To group them together, all have the same IssueID. This is the ItemID from the original item. A single issue in WSS V2 could look like this:

Apply a LDAP Filter for User Profile Import

With MOSS (Microsoft Office SharePoint Server 2007) you can import user profiles from an Active Directory or LDAP. By default, it will import user profiles from the current domain. The import will include all user objects, since the default LDAP filter is: (&(objectCategory=Person)(objectClass=User)) Deactivated and deleted accounts will appear in the SharePoint user database. The filter value can be adjusted, to only import active user objects. (&(objectCategory=person)(objectClass=user)(!(userAccountControl:1.2.840.113556.1.4.803:=2))(!(IsDeleted=TRUE))) With a LDAP browser, you can compare the results of the two filters if you don’t trust the query 🙂

New Server in the farm – Trial?

Imagine you have a working SharePoint Server Farm with a valid license. The great thing about SharePoint is that you can extend an existing farm with new servers, to split roles or increase performance/redundancy. Now you add a new Server to the farm. So you install SharePoint, make sure it has the same patches installed as the rest of the farm, and add it to the farm by connecting it to the existing configuration database.

SharePoint UserGroup in OWL?

Vor einiger Zeit hat Michael Greth einen Aufruf gestartet. Wer Interesse an einer regionalen UserGroup hat, sollte sich bei ihm melden. Bisher sind schon einige regionale UserGroups gegründet worden. Eine Übersicht findet sich auf der SharePointCommunity. Auf den o.g. Aufruf habe ich damals schon geantwortet. Jedoch hatten sich zu wenig Interessenten aus OWL (Raum Bielefeld, Paderborn, Gütersloh…) gemeldet. Zum Glück gab es die Abendveranstaltung der SharePointKonferenz 2009 in München. Dort habe ich mich u.

Custom Field – Upload Files and Images

If you know my WikiWebpart or DiscussionListUploader, you know that there are some occasions where you want to upload a file, and place a link to it to another field. The above solutions are only for the certain list type. My new custom field can be used on every list or library! Just add the field to one of your lists/libraries: It will automatically try to find local libraries for documents and images to store the uploaded files and images.

How to use the SharePoint Web Controls – Update

My post How to use the SharePoint Web Controls has been updated. It now shows how to use a generic control for each SPField, instead of picking the corresponding SharePoint Web Control. 1: BaseFieldControl webControl = field.FieldRenderingControl; <span class=lnum> 2: </span>webControl.ListId = list.ID; 3: webControl.ItemId = item.ID; <span class=lnum> 4: </span>webControl.FieldName = field.Title; 5: webControl.ID = GetControlID(field); <span class=lnum> 6: </span>webControl.ControlMode = mode; Thanks for all the great comments and ideas!

The file manifest.xml does not exist in the solution package

Creating a SharePoint solution file (which is a cab file renamed to wsp), can cause problems if the size of the file would exceed the space on an 1.44MB disk. 1.44MB? What the…? The default values for makecab, which is used for generating the cab file, will prevent the creation of a valid cab file 🙁 Thanks to Eugene Rosenfeld for finding this one.

SharePoint Konferenz

Dieser Post ist noch ein Nachtrag zur SharePoint Konferenz in München. Mein Fazit zur Veranstaltung: Eine Gelungene Veranstaltung mit hochkarätigen Vorträgen! Deshalb geht mein Dank an den Veranstalter mit seinem Team, die verschiedenen Sprecher und natürlich an die Teilnehmer der Konferenz. Ein Gedankenaustausch durch zahlreiche Gespräche zwischen den Beteiligten war jederzeit möglich. Allein diese Tatsache ist auf Konferenzen ein Grund zur Teilnahme. Wo sonst kann man sich mir so vielen Personen zum Thema SharePoint austauschen?