Exformatics ESDH klar til SharePoint 2010

Office 2007 and MOSS - custom document properties

When adding Office 2003 documents to MOSS custom document properties in Office 2003 are added as SharePoint properties in a content class. Setting custom documents properties in Office 2003 is easy and well known.

When uploading Office 2007 documents to MOSS with custom documents properties set in the same manner as in Office 2003 documents, MOSS properties are not set.

I found this blog which points out a solution and it works fine if you're working with Office 2007 templates. However, if your template is a Office 2003 DOT-file and saves the document as an Office 2007 it doesn't work anyway.

Update: I found the following msdn blog which is worth reading.

Professionshøjskolen Metropol får ESDH fra Exformatics

Professionshøjskolen Metropol får nu ESDH fra Exformatics. Uddannelsesinstitutionen skal fremover bruge Exformatics ESDH til sagsstyring i administrationen, der sørger for den daglige drift af uddannelser på flere forskellige adresser i København.

Læs mere på Version2 eller Exformatics.

Identify Publish a Major Version

For some strange reason SharePoint doesn't raise an ItemCheckingIn or ItemCheckedIn event when documents are published in new major versions, unless you do a Checkin and select major version in the same operation.

How can you identify a "Publish a Major Version" with other events? I did some googling and experiments and found out that using BeforeProperties and AfterProperties in the ItemUpdating handler might do the job. Similar posts can be found here, but I didn't get the same result.

int iBefore, iAfter;
iBefore = int.Parse(properties.BeforePropeties["vti_level"]);
iAfter = int.Parse(properties.AfterPropeties["vti_level"]);

Using the value of iBefore and iAfter I was able to identify the following events:

Event	iBefore	iAfter
CheckIn Minor Version	255	255
CheckIn Major Version	255	1
Publish a Major Version	2	2

So if (iBefore == iAfter) you a facing a "Publish a Major Version" event.

Images in a dropdown list - SELECT

Rumours says that Microsoft will announce support for jQuery in SharePoint 2010, so better get started. We have used AJAX and more recently jQuery for the last 3 years in combination with SharePoint and it has proved very useful. And even if Microsoft don't support jQuery I believe it will be a major development platform for advanced end-user interfaces in the future - also for SharePoint.

Check out this example for how to enhance your existing drop down lists to include images - yes, it looks so much nicer - and navigation is like a dream.

Panel for dokumentoplysninger kunne ikke indlæses

When opening an Excel dokument based on a standard Excel XLT template stored in SharePoint I get the error outlined below. Ideas appreciated.

An English example can be found in this blog. The error Outlined is:

The form contains schema validation errors.

Content for element '{http://schemas.microsoft.com/office/2006/metadata/propertiesRoot}properties' is incomplete according to the DTD/Schema.

Expecting: {http://schemas.microsoft.com/office/2006/metadata/properties}properties.

How can this happen?

The schema is outlined at MSDN.

Errors have been reported by many here and here.

SharePoint 2010 wiki's

Using Wiki's in SharePoint 2007 can be done, but it is a first version type of product. Luckily Microsoft has announced better wiki support in SharePoint 2010 with Managed Keywords which can be used to create tag clouds and home pages can be edites as wiki's - a huge step forward for WYSIWIG editing. I found this blog interesting.

Få forretningen til at håndtere arbejdsprocesserne

En af de centrale udfordringen at sætte strøm til arbejdsprocesser er at få forretningsbrugerne til at formulere processen og efterfølgende få denne designet og implementeret af IT folk. Der tales forskellige sprog og der er langt fra tanke til handling.

Tænk hvis det var muligt at forretningsbrugeren på en og samme tid udtrykker arbejdsgangene og dermed samtidig designer og implementerer processen i et IT system. Dermed vill man sikre at forretningsbrugeren kunne tage ansvaret for arbejdsgangene da de ikke som udgangspunkt skal have IT folk involveret i processen.

Exformatics taler på ITU seminar mandag den 7. december 2009 om udfordringerne ved at realisere en sådan tankegang.

Grønlandsk ESDH-system pensionerer fax og postfly

Read about Exformatics ESDH on MOSS 2007 deployed at Tele Greenland - in Danish.

Linking iPhone with SharePoint

Exformatics now links SharePoint with Apple iPhone in order to facilitate mobile connectivity to corporate knowledge bases. Read more here.

Here too or here.

Eller her.

Scan-Jour lukkes og Exformatics overtager.

Creating a Web Part Page programmatically

Using Microsoft.SharePoint API is often not the most easy thing in the world. As an example adding a web part page programmatically is not an easy job - unless you're lucky and hit the right page on MSDN.

I have been trying to add a pages using the SPFolder.Files.Add(, SPTemplateFileType.StandardPage) - but the page was not added as a WebPartPage so I couldn't add web parts to the page in a proper manner.

It was not until I came across the NewWebPage method on MSDN that I managed to get the job done.

Explore SharePoint from F#

Check out this blog on how to explore SharePoint's object model from F#.

jQuery library for SharePoint services

Using AJAX and jQuery to retrieve data from SharePoint and present it to end-users in advanced end-user interfaces is certainly the way forward.Check out this library for more information. Looks quite promising and have done some tests.

Create a Wiki page programmatically

If you have ever tried to figure out how to create a web part page or  wiki page programmatically you'll find it very hard to find any information.

Microsoft MSDN doesn't have a lot of information.

Recently I came across this blog. So some information is out there - not much though.

Exformatics new logo

Working with beforeproperties and afterproperties

Great overview found in this blog.

Updating document field value in SPItemEventReceiver.ItemCheckingIn() event handler

I need to update a property on ItemCheckingIn and came across this blog. Lucky me.

I have tried method 6
     properties.AfterProperties.ChangedProperties["Field Internal Name"] = "New Value";

but I couldn't get it working.

"Field Internal Name" should be "vti_Field Internal Name". Microsoft purchased SharePoint from a company called something with VTI. Unfortunately this didn't work either.

This blog is also worth reading as it explains the sequence of events.

Exformatics og Post Danmark Datascanning er partnere

Læs mere her.

Writing to SharePoint Unified Log

Writing to Windows EventLog sometimes causes issues in SharePoint, especially if using NTLM security. In this situation you might have to allow anonymous write access to the Event log by adding information to a specific registry key (Google if you wish more info on the matter).

As an alternative you can write to SharePoint own log, Unified Log, as described here on msdn.

Btw - I wonder why people in other blogs copy the content from MSDN and place it on their own blogs. What's the idea? It doesn't add any value - it only created confusion as I tend to ask myself. What is the difference?

ItemCheckingIn and version number - MOSS SP2 behavior

Came across this blog when studying version numbering in MOSS. It's great not to be alone out here.

And in the blog it gets even better.