Tuesday, September 29, 2009

PlanetWilson SharePoint Blog: Getting email functionality with MOSS without Exchange

I’ve blogged about using mailenable for email on my SharePOint dev environments in the past, but this post showed how to setup inbound email to SharePoint using a combination of MailEnable and the Microsoft SMTP service. It was exactly what I needed and worked like a charm.

PlanetWilson SharePoint Blog: Getting email functionality with MOSS without Exchange

Friday, September 25, 2009

Exposing Excel contents to make reporting easy in SharePoint | Agile Sharepoint development by 21apps and Andrew Woodward MVP

Nice article on extracting data from Excel for display in SharePoint.

This article will show how simple it can be to use the out of the box features of SharePoint and Office documents to provide powerful reporting on you documents. This example will look at the common scenario where a SharePoint (this will work with standard WSS) document library is used to store invoices.

Exposing Excel contents to make reporting easy in SharePoint | Agile Sharepoint development by 21apps and Andrew Woodward MVP

Mark Iwaszko's technical blog: Binding Excel 2007 values using (DIP) Server Document Properties to Sharepoint- Not Simple or Intuitive

There is an issue with binding the named ranges in a spreadsheet with the metadata on the server. Adding some VBA script can overcome this.

Sub SetServerProperties()
Dim WB As Workbook
Set WB = ThisWorkbook
For Each Prop In WB.ContentTypeProperties
If Prop.Name = "Project Lead Finance" Then
Prop.Value = Range("A1").Value
End If
Next Prop
End Sub

Mark Iwaszko's technical blog: Binding Excel 2007 values using (DIP) Server Document Properties to Sharepoint- Not Simple or Intuitive

SharePoint 2007 – LDAP User Filters for Limiting User Profile Import « SharePoint Sherpa

This is very useful

If you’ve ever tried to setup SharePoint 2007 to import user profiles via LDAP you’ll like this post.  The setup of the SSP to import profiles is a fairly simple task, but what is not that easy is applying the right LDAP user filter to import only the accounts that you desire from Active Directory.  I’d like to share with you my experience with applying user filters and some of the excellent user filter examples I have found.

SharePoint 2007 – LDAP User Filters for Limiting User Profile Import « SharePoint Sherpa

Friday, September 11, 2009

SharePoint config store - Home

I was looking for a nice way to be able to externally store configuration information for things like timer jobs. I found out about this project on codeplex from Chris O’Brien which provides for an optimised and consistent approach.

SharePoint config store - Home