David Overton's Blog : Windows Server 2003, SBSC, Windows SharePoint Services

More ways to engage with customers using the Microsoft advertising campaigns

David Overton — Tue, 04 Mar 2008 21:00:00 GMT

[updated 4th March]

Many people congratulated Microsoft after the Mr Busy campaigns allowed partners to drive their customers back to them using a MS campaign. Well, this is now being repeated for a number of campaigns. Today I found the click and go site to get them all (http://www.campaigns.arvato-services.com/). You can get 200 post cards or 1,000 e-mails for free and then a low price for additional cards/ e-mails if required. The campaigns covered include:

Business Productivity
Customer Acquisition and Retention
Security and Reliability
Small Business PC
Mr Busy

This method of engaging is not new to the Small Business team and others have covered this before (eg Susanne here), but it is worth re-highlighting this now as some of the campaigns have been renewed, so go back and visit the site!!

ttfn

David

Technorati Tags: Microsoft, Marketing, Campaigns, Business Productivity, Customer Acquisition and Retention, Security and Reliability, Small Business PC, Mr Busy, Partner, SME, Small Business Server 2008, Mid-Market

How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007

David Overton — Tue, 13 Mar 2007 00:01:00 GMT

[updated 9th August 2007 to add read/write document registry change]

A few people said this was a showstopper for them in recommneding Office 2007 to their customers so I figured it had to be fixed. I nixed a huge amount of work from the right stuff blog "Office 2007 File Icons for Windows SharePoint Services 2.0 and SharePoint Portal Server 2003" and the script work from http://blogs.msdn.com/karstenj/archive/2006/01/03/508888.aspx. The problems were: 1) no icons for files 2) file types not recognised by companyweb 3) downloads could not be opened as the file type was said to be a compressed file 4) could not edit from companyweb

OK, so here is the process.

1. Download the icons from here and put them into folder C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\TEMPLATE\IMAGES\ (read the item on the the right stuff to pick your files)

2. Update the C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\TEMPLATE\XML\docicon.xml file with the information below into the ByExtension section

<Mapping Key="docx" Value="docx.gif" EditText="Microsoft Office Word" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="docm" Value="docm.gif" EditText="Microsoft Office Word" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="dotx" Value="dotx.gif" EditText="Microsoft Office Word" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="dotm" Value="dotm.gif" EditText="Microsoft Office Word" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="xlsx" Value="xlsx.gif" EditText="Microsoft Office Excel" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="xlsm" Value="xlsm.gif" EditText="Microsoft Office Excel" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="xltx" Value="xltx.gif" EditText="Microsoft Office Excel" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="xltm" Value="xltm.gif" EditText="Microsoft Office Excel" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="xlsb" Value="xlsb.gif" EditText="Microsoft Office Excel" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="xlam" Value="xlam.gif" EditText="Microsoft Office Excel" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="pptx" Value="pptx.gif" EditText="Microsoft Office PowerPoint" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="pptm" Value="pptm.gif" EditText="Microsoft Office PowerPoint" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="potx" Value="potx.gif" EditText="Microsoft Office PowerPoint" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="potm" Value="potm.gif" EditText="Microsoft Office PowerPoint" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="ppam" Value="ppam.gif" EditText="Microsoft Office PowerPoint" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="ppsx" Value="ppsx.gif" EditText="Microsoft Office PowerPoint" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="ppsm" Value="ppsm.gif" EditText="Microsoft Office PowerPoint" OpenControl="SharePoint.OpenDocuments"/>

3. Update the metabase MIME types by running the following script (copy it to a text file called update_mime.vbs and then double click on it - ONCE):

'This script adds the necessary Office 2007 MIME types to an IIS Server.
'To use this script, just double-click or execute it from a command line.
'Running this script multiple times results in multiple entries in the IIS MimeMap.

Dim MimeMapObj, MimeMapArray, MimeTypesToAddArray, WshShell, oExec
Const ADS_PROPERTY_UPDATE = 2
'Set the MIME types to be added
' MimeTypesToAddArray = Array(".manifest", "application/manifest", _
' ".xaml", "application/xaml+xml", ".application", "application/x-ms-application", ".deploy", "application/octet-stream", _
' ".xbap", "application/x-ms-xbap")
MimeTypesToAddArray = Array( _
".docm","application/vnd.ms-word.document.macroEnabled.12" , _
".docx","application/vnd.openxmlformats-officedocument.wordprocessingml.document" , _
".dotm","application/vnd.ms-word.template.macroEnabled.12" , _
".dotx","application/vnd.openxmlformats-officedocument.wordprocessingml.template" , _
".potm","application/vnd.ms-powerpoint.template.macroEnabled.12" , _
".potx","application/vnd.openxmlformats-officedocument.presentationml.template" , _
".ppam","application/vnd.ms-powerpoint.addin.macroEnabled.12" , _
".ppsm","application/vnd.ms-powerpoint.slideshow.macroEnabled.12" , _
".ppsx","application/vnd.openxmlformats-officedocument.presentationml.slideshow" , _
".pptm","application/vnd.ms-powerpoint.presentation.macroEnabled.12" , _
".pptx","application/vnd.openxmlformats-officedocument.presentationml.presentation" , _
".xlam","application/vnd.ms-excel.addin.macroEnabled.12" , _
".xlsb","application/vnd.ms-excel.sheet.binary.macroEnabled.12" , _
".xlsm","application/vnd.ms-excel.sheet.macroEnabled.12" , _
".xlsx","application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" , _
".xltm","application/vnd.ms-excel.template.macroEnabled.12" , _
".xltx","application/vnd.openxmlformats-officedocument.spreadsheetml.template" _
)
'Get the mimemap object
Set MimeMapObj = GetObject("IIS://LocalHost/MimeMap")
'Call AddMimeType for every pair of extension/MIME type
For counter = 0 to UBound(MimeTypesToAddArray) Step 2
AddMimeType MimeTypesToAddArray(counter), MimeTypesToAddArray(counter+1)
Next
'Create a Shell object
Set WshShell = CreateObject("WScript.Shell")
'Stop and Start the IIS Service
Set oExec = WshShell.Exec("net stop w3svc")
Do While oExec.Status = 0
WScript.Sleep 100
Loop
Set oExec = WshShell.Exec("net start w3svc")
Do While oExec.Status = 0
WScript.Sleep 100
Loop
Set oExec = Nothing
'Report status to user
WScript.Echo "SharePoint Mime Types have been added."
'AddMimeType Sub
Sub AddMimeType (Ext, MType)
'Get the mappings from the MimeMap property.
MimeMapArray = MimeMapObj.GetEx("MimeMap")
' Add a new mapping.
i = UBound(MimeMapArray) + 1
Redim Preserve MimeMapArray(i)
Set MimeMapArray(i) = CreateObject("MimeMap")
MimeMapArray(i).Extension = Ext
MimeMapArray(i).MimeType = MType
MimeMapObj.PutEx ADS_PROPERTY_UPDATE, "MimeMap", MimeMapArray
MimeMapObj.SetInfo
End Sub

that did it for me :-)

[updated]

Well, it almost did, in fact, when you tried to open a file by clicking on it, you only got a read only version. Reading the KB article http://support.microsoft.com/kb/870853 I discovered this was deliberate and I changed it a bit for Office 2007 and now the following command run from an ELEVATED command prompt on the client will work. You can also set Group Policy on the server to set this key too (just remember to change the 11 to a 12 if reading the KB article).

reg add HKCU\Software\Microsoft\Office\12.0\Common\Internet /v OpenDocumentsReadWriteWhileBrowsing /t REG_DWORD /d 01

ttfn

David

Technorati tags: WSS v2, Office 2007, SharePoint, Office 2007 Deployment blocker fixed

Using Windows Vista and Outlook 2007 in a Windows Small Business Server 2003 Network

David Overton — Wed, 28 Feb 2007 07:47:00 GMT

[updated 28th Feb 2007 - 07:47 with correct link for Outlook 2007 and Windows XP]

Use this document to join computers that are running Windows Vista to your Windows Small Business Server 2003 network using the "Update for Windows Small Business Server 2003: Windows Vista and Outlook 2007 compatibility (KB 926505).

http://www.microsoft.com/downloads/details.aspx?FamilyID=46E95C56-1A4C-45BD-8D69-5F41FF8F1F22&displaylang=en

File Name:
SBSVista_Conceptual.doc

Date Published:
2/8/2007

Download Size:
265 KB

The “Update for Windows Small Business Server 2003: Vista and Outlook 2007 compatibility (KB 926505)” adds support for the Client Deployment tools in Windows Small Business Server (Windows SBS), and it resolves compatibility issues for running Windows Vista and Microsoft Office 2007 in a Windows SBS network. Use this document to join computers running Windows Vista and Outlook 2007 in your Windows SBS network.

You might also want to look at:

· Vista and Office 2007 FAQs

· Related Knowledge Base Articles

KB 926505 – Update for Windows Small Business Server 2003: Windows Vista and Outlook 2007 compatibility

· KB 911829 – Outlook Web Access (OWA) update

· KB 929556 – Firewall Client for ISA Server

· KB 930414 – ISA Server 2004 update package for Vista 64-bit editions

· KB 930955 – Vista User Profile WMI Provider

KB 931905 – Regarding Outlook users; note: this is a catch all KB for someone who has XP with Outlook 2007 – a separate update is not required, it is the same update as mentioned in KB 926505

Technorati tags: Vista, Windows Vista, Small Business, SBSC, SBS 2003, Small Business Server 2003

I'm sorry - I am not perfect and nor is Microsoft. Sometimes it is our fault

David Overton — Mon, 19 Feb 2007 23:26:51 GMT

I can be abrasive sometimes and whether it "is my fault" or not, I don't always understand others' point of views. To this I would like to say "It is my fault".

Now, if you have got up off the floor, let me give you a few examples.

I say "contact our customer support" and you say "I don't have time". Before I rant - OK, I understand this, if you could share the bug at some time, we will try to fix it. We haven't been able to identify it yet, so need your help
I say "There is no OEM media, get over it" and you say "I need OEM media to do my installs". OK, I can't fix this one. I do understand where you are coming from. If I were to share the fact that in the UK, which is a low piracy country, our tests so far have shown between 10-15% of all copies of Windows are pirated and many come from Action Packs and other OEM keys, does that help understand why this is such an issue? I do wish I could give you back OEM media, but I've been told it is just not possible. While Microsoft did publish the changes coming, I now get the impression that many did not realise that this was linked to the change in qualifying an upgrade, making the process different to Windows XP

The list goes on, however why did I even start this? Well a man I respect lots is Joel. I started reading his latest filing:

"Now I was fuming. Squiggly lines were coming up out of my head. I was a half hour late to work and had to go to the locksmith for a third time. I was tempted just to give up on him. But I decided to give this loser one more chance."

"Seven steps to remarkable customer service
http://www.joelonsoftware.com/articles/customerservice.html

It then carries on:

I stomped into the store, ready to unleash my fury.
“It still doesn’t work?” he asked. “Let me see.”
He looked at it.
I was sputtering, trying to figure out how best to express my rage at being forced to spend the morning going back and forth.
“Ah. It’s my fault,” he said.
And suddenly, I wasn’t mad at all.
Mysteriously, the words “it’s my fault” completely defused me. That was all it took.

Potentially wise words from the sage. I mean what I say

have a great day

David