Henrik Andersson (SharePoint scrap book)

Error launching Report Builder from MOSS 2007

2011-11-09T11:16:00.001+01:00

SQL Server 2008 R2 with SP1 on Windows Server 2008
SharePoint 2007 (Dec 09 CU) on Windows Server 2003

"Edit in Report Builder" sends the the browser to

"/_layouts/ReportServer/RSAction.aspx?RSAction=ReportBuilderReportContext&list={E048CF36-3F8C-4333-A429-21907A15022D}&ID=1"

which redirects to

"/_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application?ReportPath=SITE/Report1.rdl"

Now the type "Microsoft.ReportingServices.SharePoint.Soap.RSProxyHttpHandler" takes over the request (see httpHandlers section in web.config for WSS virtual directory)
and should send the manifest to the browser from the SSRS server.

This didn´t happen in our environment.
So we reinstalled the SP2 on the SSRS and it solved this problem.

Things to remember:
* The files in "\ISPAI\ReportBuilder" are not the same on MOSS and SSRS.
* "/_vti_bin/ReportServer" have a custom httpHandler definied in web.config.
* Fiddler helps, but only to a certain point.
* Make sure to run the Add-in installation as a Farm administrator.

XML definition for ContentType

2011-06-17T10:58:00.002+02:00

If one don´t include the FieldRef for a column in the FieldRefs collection of the ContentType (for the schema.xml in the List Instance) then the field is not available in the SPContext.Current.Fields collection.

Decrypting error in multi-forest environment

2011-04-06T17:27:00.002+02:00

In the ULS for a SharePoint 2010 Server after a trust between two domains has been re-configured: Decryption failed with error 0:" (and the rest of the callstack) Solution: stsadm -o setapppassword -password "SomeString" (on all WFE:s) stsadm -o setproperty -pn peoplepicker-searchadforests -pv "ForestDomainUserString" No IISResets needed.

Update-SPProfilePhotoStore and Service Application permission

2011-02-22T07:15:00.002+01:00

Running Update-SPProfilePhotoStore -CreateThumbnailsForImportedPhotos 1 -MySiteHostLocation https:///my based on User Profiles – Picture Property in SharePoint 2010.

This command requires Full Control on the "User Profile Application" service application (Use the Permissions tab on the Manage Servcie Applications page).

Solving ‘Configuring certificate’ hang for User Profile Synchronization Service.

2011-01-09T20:00:00.002+01:00

The quick explanation:

1. If you re-provision the UPA service and encounter an error while creating the certificate, check this blog post by Paul Culmsee: More User Profile Sync issues in SP2010: Certificate Provisioning Fun.

2. If you delete the certificate in Trusted Root Certification Authorities and still are stuck on ‘Starting’ you also need to delete the certificate “higher up” in the certificate chain at Personal –> “ForefrontIdentityManager”.

A few good pointers:

Start to put the User Profile ULS category to Verbose, then read this blogpost by the SharePoint Escalation Team. Compare the ULS log entries you got with the blogpost, it´ll show where in the process the provisioning fails.

To unprovision the service run the powershell command: Stop-SPServiceInstance –Identity ‘'GUID’

Get the GUID by “Get-SPServiceInstance”, if you have more than one SP server in the farm you have two instances of the service name ‘User Profile Synchronization’, the one which is active has the status “Provisioning”. You might also need to delete the “UserProfileSyncronizationSetup” job before the unprovisioning can start.

In my case I could disregard these error messages in the ULS logs:

ILMPostSetupConfiguration: ILM Configuration: Validating installation of SQL Service. ILM Configuration: Error 'ERR_SERVICE_NOT_INSTALLED' ILMPostSetupConfiguration: ILM Configuration: Validating installation of SQL Service FAILED

Update: Another case required the removal of all subfolders in the MaData folder. I had alot of errrors regarding MS DTC before the removal

2010-12-09T07:38:00.002+01:00

Error message when adding a new column:

Culture ID 1164 (0x048C) is not a supported culture.
Parameter name: culture

The file "Microsoft.SharePoint.ApplicationPages.dll" has not been updated in the app_bin folders for each virtual server.

1. Stop the IIS service.
2. Copy the file from 12Hive\Config\Bin to all app_bin which have SP installed
3. The version of the file "Microsoft.SharePoint.ApplicationPages.dll" should be "12.0.6548.5000"
4. Start the IIS service again.

Downgrade of Enterprise to Standard editon for Sharepoint 2010

2010-12-03T11:21:00.003+01:00

Downgraded a SQL cluster from Enterprise to Standard edition. Removed the cluster nodes first, followed parts of this guide to downgrade the edition and then configured the cluster again (most time was needed for the cluster configuration).

If you don´t restore the master database, you need to run "GRANT VIEW SERVER STATE TO [MyDomain\FarmAccount]" to avoid flooding of "Event 5586" with error message "
The user does not have permission to perform this action."

One thing that is not to obvioulsy is that the "Property Store" and "Web Analytics Service Reporting" database uses Enterprise functionality and can not be attached to a Standard edition.
You need to recreate the Service Applications for the Search Service and Web Analytics. So plan for it beforehand.

The Search Service can not be deleted i the UI, check this how to use stsadm to delete it. You also need to delete the Search DBs in the same way or else the Event viewer will be filled with connection errors for the orphan databases.

Code example for EnabledScript element in Ribbon XML

2010-11-10T08:07:00.010+01:00

Andrew Connel explains how to enable and disable buttons in the Ribbon based on a condition.

I need to check a field value on the selected item and the item permission and then enable / disable multiple buttons. I assume that you have some knowledge about the Ribbon XML structure :).

//Should only be enabled when IssueStatus == Report

      <CommandUIHandler
       Command="Tab.CloseIssue"
       CommandAction="javascript:EditDeviation('{ListId}');"
       EnabledScript="javascript:SingleEnable('Report',SP.PermissionKind.editListItems);"/>

//Should always be enabled

      <CommandUIHandler
       Command="Tab.CurrentStatus"
       CommandAction="javascript:DisplayStatus('{ListId}');"
       EnabledScript="javascript:SingleEnable('All',,SP.PermissionKind.viewListItems);"/>

function SingleEnable(EnableForStatus, PermissionKind) {

   var result = false;

   var selectedItems = SP.ListOperation.Selection.getSelectedItems();
   var ci2 = CountDictionary(selectedItems);
   if (ci2 == 1) {

       if (this.IssueRibbonItemId == null) {

           this.IssueRibbonItemId = selectedItems[0]['id'];
           var listGuid = SP.ListOperation.Selection.getSelectedList();
           getStatus(this.IssueRibbonItemId, listGuid);

       }
       else if (this.IssueRibbonItemId != selectedItems[0]['id']) {

           this.IssueRibbonItemId = selectedItems[0]['id'];
           var listGuid = SP.ListOperation.Selection.getSelectedList();
           getStatus(this.IssueRibbonItemId, listGuid);
       }
       else if(this.IssueRibbonStatus != null){

           if (this.IssueRibbonStatus == EnableForStatus || EnableForStatus == '') {
               if(this.IssueItem.get_effectiveBasePermissions().has(PermissionKind)){
                   result = true;
               }
           }
       }
   }

   return result;
}

function getStatus(ItemId, listGuid) {

       var clientContext = new SP.ClientContext();
       var web = clientContext.get_web();
       var lists = web.get_lists();
       var list = lists.getById(listGuid);
       this.IssueItem = list.getItemById(ItemId);

       clientContext.load(IssueItem, 'IssueStatus', 'EffectiveBasePermissions');
       clientContext.executeQueryAsync(Function.createDelegate(this, this.onStatusQuerySucceeded), Function.createDelegate(this, this.onQueryFailed));
}


function onStatusQuerySucceeded(sender, args) {
   this.IssueRibbonStatus = this.IssueItem.get_item("IssueStatus");
   RefreshCommandUI(); //Makes the EnabledScrip method to be enabled again.
}

function onQueryFailed(sender, args) {
   alert('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace());
}

Some TaxonomyField things and code

2010-11-01T16:53:00.002+01:00

Before a new term can be used for tagging in a web site it needs to be added to the hidden list "TaxonomyHiddenList".
Several suggestions how to add a new term with code has been posted and this is my conclusion:

Adding a new term to an item:

TaxonomyField tf = item.Fields["ColumnName"] as TaxonomyField;
tf.SetFieldValue(item,term);
item.Update();

This doesn´t work for new items:

int hiddenTermId = -1;
int[] wssIds = TaxonomyField.GetWssIdsOfTerm(site, TermStore.Id, TermSet.Id, Term.Id, false, 1);

if(wssIds.Length > 0)
hiddenTermId = wssIds[0];

TaxonomyFieldValue tfv = new TaxonomyFieldValue(termId + ";#" + term.Name + TaxonomyField.TaxonomyGuidLabelDelimiter + term.Id.ToString())

or this:

string termString = String.Concat("-1", SPFieldMultiColumnValue.Delimiter, term.GetDefaultLabel(1033));
TaxonomyFieldValue tfv = new TaxonomyFieldValue(termString);

Add a comment if you have any question.

MissingSetupFile for themes

2010-08-27T10:02:00.003+02:00

Running Test-SPContentDatabase for migration preparation. The report contained errors referring to missing themes files. The web didn´t use the theme as the active theme but had used the theme before.

Start SPD and open the site. Browse to the themes folder and delete the theme folder referenced in "MissingSetupFiles". Open the web in the browser and delete the folder from the Recycle Bin and then also from the site collection Recycle Bin.

Unexpected error creating debug information file

2010-07-06T10:26:00.002+02:00

In several of my SharePoint projects I'm using a WinForm application to test and trigger SP code.

Sometimes I have had big problems when recompiling the SP projects and generating the PDB file. This time I disabled the VSHOST option for my WinForm project and the problem was solved.

VS spawns a new winformexe.vshost.exe process each time I tried to kill it with Process Explorer, so it kept me from recompiling the other SP corrctly.

How to: Disable the Hosting Process

WSPBuilder and VB.Net

2010-05-10T20:24:00.003+02:00

Developing a solution for a client which want´s the sourcecode in VB.Net (It took some hours before I stopped using ";" and "{}" ;) ).

A known fix for getting all ASP.Net items available in a WSPBuilder project is to amend the .csproj file with a ProjectTypeGuids element. The same goes for VB.Net but the element that needs to be added is different:

{349c5851-65df-11da-9384-00065b846f21};{F184B08F-C81C-45F6-A57F-5ABD9991F28F}

WebTemplate

2010-04-28T10:09:00.001+02:00

Have noticed a long awaited feature in SP2010: WebTemplate! This means that you can add a template definition for one site collection only and not for the whole farm.

MCPD!

2010-04-26T15:37:00.002+02:00

Passed the last certification and got the rewarded the MCPD credential. Actually the first title since my MCSE for Windows Server 2000. Have only been taking subject specific certificats since then, mostly SharePoint ofcourse.

jQuery and the find selector

2010-04-21T12:07:00.003+02:00

When working with XML in jQuery a selector called $find can be used to find elements in the XML object that is loaded. I had a problem with IE7 and a webservice returning XML. The problem was that IE 7 didn´t recognize the returning XML as an [object] but rather as a string. Adding a dataType attribute to AJAX method solved the problem.

Solution reference: http://www.gammageek.com/2008/10/jquery-xml-in-ie.html

Enable debugging for _layouts files

2010-02-24T16:16:00.002+01:00

I wanted to see the ASP.net error for files in a subdirectory to _layouts folder. So I created a web.config in the subfolder with this content:

<configuration>
<sharepoint>
<safemode maxcontrols="200" callstack="true" directfiledependencies="10" totalfiledependencies="50" allowpageleveltrace="false">
<pageparserpaths>
</pageparserpaths>
</safemode>
</sharepoint>
<system.web>
<compilation batch="false" batchtimeout="600" maxbatchsize="10000" maxbatchgeneratedfilesize="10000">
<httphandlers>
<add type="System.Web.UI.PageHandlerFactory, System.Web, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" path="*.aspx" verb="*">
</httphandlers>
<customerrors mode="Off">
</SYSTEM.WEB>
</configuration>

Save the file and your ASP.Net error messages will appear.

Push changes from a content hub

2009-12-04T14:23:00.002+01:00

1. Change or add a content type in a content hub site.
2. Click on "Manage Publishing for this content type" in the content type administration page.
3.Click on "Publish" if it´s a new content type or "Republish" if it´s a content type update.
4. Fire up "SharePoint 2010 Management Shell" on the SharePoint server.
5. Run these commands to trigger the timer jobs for content hub sync:

Start-SPTimerJob MetadataHubTimerJob
Start-SPTimerJob MetadataSubscriberTimerJob

6. Check your "Job History" (Monitoring --> Check job status --> Job History) page in CA for the status of the timer jobs

Updatelistitems and 0x8007000

2009-11-29T16:25:00.001+01:00

Using the UpdateListItems webservice from jQuery creating an item in a custom list returned the error: "0x80070005 The operation failed because an unexpected error occurred. (Result Code: 0x80070005)".

The webservice call worked correctly for site collection admin and site admins but not for ordinary users. The list was configurd with "Add item" and "View pages" permissons for ordinary users which should provide correct access for the UpdateListItem method.

The problem with the list was that is was configured with a "None" value for the property "Edit access" (General settings --> Advanced settings). After changing it to "Only their own" the method call succeeded. So the "Edit items" property was messing up a "New item" method call.

Updatelistitems and 0x8007000

2009-11-29T16:25:00.000+01:00

The webservice call worked correctly for site collection admin and site admins but not for ordinary users. The list was configurd with "Add item" and "View pages" permissons for ordinary users which should provide correct access for the UpdateListItem method.

The problem with the list was that is was configured with a "None" value for the property "Edit access" (General settings --> Advanced settings). After changing it to "Only their own" the method call succeeded. So the "Edit items" property was messing up a "New item" method call.

OT: Copy contacts between C905 and Satio

2009-11-26T07:44:00.002+01:00

Switched telephone to a Satio yesterday :). But had some trouble to get my PIM information to come along. I´m running the Office 2010 beta so PC Suite from SEMC didn´t recognize it, the otherwise excellent MyPhoneExplorer could only move SMS and bookmarks between the phones. The solution was to use the Synchronization service from SEMC (still in beta). It worked perfect and now I also have the possibility to schedule an online backup directly from my phone.

Move My Site web application in MOSS 2007

2009-11-20T08:01:00.002+01:00

We had a situation where a brand new web application needed a new host header and be moved from a high port to port 80.

Use this guide to add a host header.

Make sure you use the Default zone (or else you can not browse to 'Advanced Permissions' or add web parts).

Update "My Site" settings in the SSP

Recrawl the content source which index the user profile database, or else you will not be able to search for users.

Fix Hyper-V VHD for Virtual Box 3.0.10

2009-11-20T07:53:00.002+01:00

I downloaded the Windows 2008 x64 VHD from Microsoft with the purpose to mount it in Virtual Box. When the virtual machine started the following error message was displayed: "Fatal no bootable medium found system halted".

The solution was to download VPC 2007 and run the Disk Wizard and compact the VHD (as stated here).

This Page has been modified since you opened it. You must open the page again

2009-11-12T13:57:00.001+01:00

A lot of suggestions how to solve this:
- Add a "PublishingPageLayout" to the elements.xml file.
-Inherit from TemplateRedirectionPage instead of PublishingLayoutPage in the page layout file.
- MSO_PageHashCode is not cleared for detached pages.

None of the above had anything to do with my problem.

In my case it was two problems that throw the same error. I had one event receiver attached to a Pages library that did a call to "RunWithElevatedPrivileges" and did a SPListItem.Update() which caused the page to display the error message. I updated the event receiver according to this article, using the SPUserToken instead.

The other problem was that I had created a page with SharePoint Designer by right-clicking a Page Layout in masterpage and then choosing "New from Existing Page". This created the page but associated it with the wrong content type. Use SharePoint Manager 2007 and you will see that it attached the "Page" content type. Instead I used the web interface to create a new page and checked the content type which now was using "Welcome Page".

This leads me to the conclusion that the articles stating that you need to add a property "PublishingPageLayout" to your elements.xml files when provising (ex: create and upload files during feature activation) files are correct. But in my case I created a new page the wrong way (using SPD and not the web interface).

Failed to create feature receiver object from assembly

2009-10-23T14:16:00.000+02:00

Remember that the class that inherits from SPFeatureReceiver need to be "Public"

User Profile Import stuck on "Enumerating"

2009-10-08T13:22:00.003+02:00

I keep an eye on some of our clients SharePoint farms and today I came across an error in the profile import for one of the SSPs. “The user profile database connection cannot be made, because of error 0x80004005” is displayed on the “User Profiles and Properties” page and the “Profile import status” was only displaying “Enumerating”.

The import cannot be stopped, if the server is restarted then the error doesn´t disappear according to several posts in newsgroups.

So what to do? I checked and double-checked the SSP database and the values in the Profile_Stats, MIPObjects and MIPScheduleJob tables which all had values related to the Profile Import. But nothing that I did could solve the problem.

But then I remembered that the crawler application is based on the good old Indexing Service which means that the registry is also used to store settings. So after some digging I found the solution by changing a value in the registry for the crawler.

Open the registry editor. Browse to “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\Search\Applications”. Here you will find a key for each SSP in the farm. Drill down to "\Gather\ProfileImport\ContentSources\0" (which is the Full Import) and check the key “CrawlNumberInProgress”. If it´s not “0xffffffff” then the number displayed corresponds to a key under the branch “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\Search\Applications\\Gather\ProfileImport\Crawls”.

I changed the number in the key “CrawlNumberInProgress” to “0xffffffff” and then restarted the “Office SharePoint Server Search” service for the settings to be applied.

The error message disappeared from “User Profiles and Properties” and I could start a new full import to the “User Profile Import”

Disclaimer: remember to backup your registry before making any changes. I am not responsible for your system damages because of any registry errors

Video from MS regarding the SharePoint opportunity

2009-10-05T09:53:00.002+02:00

Sharepoint 2010 demo a few minutes in the video

Building Solutions on SharePoint

Lifecycle problem with WSPBuilder and EditorPart

2009-09-26T11:11:00.000+02:00

I had a problem with the ApplyChanges method in an EditorPart class that was used in a WSPBuilder WebPart class (the default web part that WSPBuilder creates). The CreateChildControls in the WebPart class was triggered before the ApplyChanges method in the EditorPart class. Therefore the web part content was not updated and the page had to be reloaded to show any update to the web part.

In the WebPart class that is created from WSPBuilder the CreateChildControls is triggered from the OnInit method. This has the consequence that the ApplyChanges method in the EditorPart class will be triggered after the CreateChildControls in the WebPart class. My solution was to remove the method call in OnInit and then the ApplyChanges method was firing correctly.

The project location is not trusted and a zip file

2009-08-29T07:50:00.002+02:00

When opening an unzipped Visual Studio project I got prompted with "The project location is not trusted". The problem was that the zip file was downloaded from an untrusted location and I needed to unblock it first. Right-click on the zip file --> Properties and the click on "Unblock"

SPListItemVersion and Dates

2009-07-02T22:57:00.002+02:00

It seems SPListItemVersion objects are not displaying dates in the correct timezone. I had to convert the date to a DateTime object and the use the ToLocalTime method to get the correct date out.

Outlook 2007 and HTML email

2009-06-29T14:04:00.002+02:00

Well, this can seem to be a little of topic :)

I was generating HTML e-mails that are sent via SharePoint (SendEmail method). But the e-mail wouldn´t render correctly in Outlook 2007. The e-mail was just cut off in Outlook 2007. I ran the HTML that was generated in validators and making sure that all tags was closed but nothing seemed to make me come closer to the solution.

Finnaly I stumbled across the solution! The problem was that I created a long string without linebreaks (\r\n)!

So my guess is that Outlook 2007 reads the HTML into a pre-definied string buffer and the parses it for output and in this case the HTML I sent was to long for this buffer.

Unable to break role inheritance

2009-06-25T12:44:00.000+02:00

A customer had a problem to break the inheritance from the parent web. The error message on the first page was "500 Internal server error" and when breaking the inheritance from Site Settings was:

“Cannot complete this action.
Please try again. at Microsoft.SharePoint.Library.SPRequestInternalClass.ResetSecurityScope(String bstrUrl, UInt32 dwObjectType, String bstrObjUrl, Guid guidDoc, Boolean bUnique, Boolean bCopyRoleAssignments, Guid& pguidScopeId, Int32& piError)
at Microsoft.SharePoint.Library.SPRequest.ResetSecurityScope(String bstrUrl, UInt32 dwObjectType, String bstrObjUrl, Guid guidDoc, Boolean bUnique, Boolean bCopyRoleAssignments, Guid& pguidScopeId, Int32& piError) “

Inspired by this solution I just broke the inheritance of the permission levels and inherited it again to fix the issue of not being able to break the role inheritance.

Fast recap:
Browse to http:////_layouts/role.asxp
Break the inheritance
Enable the inheritance again

// Henrik

Another surprise in SharePoint

2009-06-09T23:26:00.003+02:00

I have a list with versioning enabled and a "Multiple line of text" field that can not be updated via the UI. The field is also configured to append text to the current text.

When updating the field and using SPItem.SystemUpdate(false) (in code) the field don´t get a new entry (as it does when editing a field of this type via the UI). Nope, it simply overwrites the current text and updates the field.

One solution to this is to concatenate the old value with the new, with the drawback that the datestamp will always stay the same until a new version of the item is created.
I removed the append option and did the appending of the field myself instead.

// Henrik

"Copy to GAC" problem with WSPBuilder

2009-06-03T13:27:00.002+02:00

See this thread for a solution to the problem. It seems that all application pools needs to be running for it to work.

// Henrik

"The given key was not present in the dictionary"

2009-05-28T10:56:00.002+02:00

Error message when activating a feature with field definition included. Could not display any site columns via the site either. Fired up SPM and browsing the Fields collection and got an error message about a field type not correctly installed.

It turned out I had misspelled "Number" to lowercase "number" in my field definition file. Amend the line and upgraded the solution and the problem was resolved

WSPBuilder: Unicode characters

2009-05-28T10:30:00.003+02:00

Got this error message from WSPBuilder when building a new WSP file:
"The filename of the CAB file must not contain Unicode characters!"

I had some some swedish characters in my projectfolder name. I removed it and updated the SLN file with the new path. Problem solved.

// Henrik

File attachment and Infopath 2003 SP1

2009-04-06T14:03:00.006+02:00

We have been working on a small project using Infopath 2003 and MOSS to create a faster way to input information in a list. Among the challenges (which was quite a few despite it was software from MS on both "sides") faced was how to enable uploading a file while submitting information to a list.

Infopath 2003 provides a File Attachment Control which enables the end-user to select and attach a file to the form. Infopath automatically encodes the file in Base64 and adds a dynamic header in the front of the file. So we wanted to use the "AddAttachment" web service available to post the file, one of the parameters is a Base64 encoded string. Great! Well, the header added by Infopath is also included in the encoding. We only have Jscript or VBScript to use in Infopath 2003 if we don´t want to start to deploy extra code on the clients (which I try to prefer to stay away from) and the support for decoding/encoding files in those languages are not to great.

So our solution is to extract the filename from the header (code below) and the attach a list item event receiver for "ItemAttachmentAdded" which decode the file, removes the header and saves the file again serverside.

Here is the code for extracting the filename from an Infopath Base64 encoded attachment:

dim node

Set node = XDocument.DOM.documentElement.selectSingleNode("/my:myFields/my:FileAttchmentControl")

If(node.text <> "") Then

'typecast the node to base64 as Infopath doesn't do this in node definition

node.DataType = "bin.base64"

'convert base64 node value to binary and store in nodeValue byte array

nodeValue = node.nodeTypedValue

dim convertByteArrayToHexString

convertByteArrayToHexString = ""

For intCounter = 1 to LenB(nodeValue)

convertByteArrayToHexString = convertByteArrayToHexString & Right("0" & Hex(AscB(MidB(nodeValue, intCounter, 1))), 2)

If(intCounter = 100) Then 'Assuming that the header is no longer that 100 bytes
exit for
end if

Next

dim filenameBuffer
dim filename
filename = ""
filenameBuffer = 0

'The length of the filenamebuffer is stored on pos 20-24 (byte), which means 41.47 in Hex and 1 as startpos for Arrays

filenameBuffer = getFilenameBuffer(convertByteArrayToHexString,41,47)

'Read the filename from position (49 to filenamebuffer * unicode - "\n") as end char

filename = getFileName(convertByteArrayToHexString,49,filenameBuffer*4 + 49 - 2)

Function getFilenameBuffer(data,startLoop,stopLoop)
dim k

dim filenameBuffer

for k = startLoop to stopLoop step 2

dim y1
dim y2
dim y3

y1 = Mid(data,k,2)
y2 = CLng("&h" & y1)
y3 = y3 + Int(y2)

filenameBuffer = y3

next

getFilenameBuffer = filenameBuffer

End Function

Function getFileName(data,startLoop, stopLoop)
dim k

dim filename

for k = startLoop to stopLoop step 4

dim h1
dim h2
dim h3

h1 = Mid(data,k,2)
h2 = CLng("&h" & h1)
h3 = Chr(h2)

if(h3 <> "") then
filename = filename & Cstr(h3)
end if

next

getFileName = filename
End Function

SharePoint Designer - now for free

2009-04-03T08:32:00.001+02:00

Microsoft offers SharePoint Designer for free. See the SharePoint Team blog post for more information.

Additional user information import with BDC

2009-03-17T11:06:00.003+01:00

Been working on an secondary connection to a SQL Server database that will be used to add more information to the user profile properties. Solution includes the BDC application but foremost setting the correct access permission for the account accessing the BDC application.

I use "RevertToSelf" in the ADF which makes the access to the BDC run with the account for the service "Office SharePoint Search Server".

So the account needs "Execute" permissions for the BDC application and all entities, DBDataReader to the SQL Server (or any other read permission) and finally "Manager User Profiles" under "Personalization Permissions". When troupbleshooting this the ULS is yor friend.

Make sure that no other accounts gets permission to the application in BDC, you want to avoid to expose the BDC application to the built-in web parts.

Moving to WSPBuilder

2009-03-12T11:42:00.003+01:00

Attended the first Sweden SharePoint User Group Malmö meeting (phew, that was long) yesterday. Karsten was there and talked about his tools WSPBuilder and SPM2007.

We have been using STSDev for sometime now, but it feels like the development have stalled and other participants also noted that you need to fix bugs in the tool to make it work in different situations. So we have decided to switch to WSPBuilder instead for coming projects. Hopefully it cuts down the time developers needs to write code in the OM.

Response to "JQuery for Everyone: Total Calculated Columns"

2009-01-30T11:15:00.007+01:00

Finally there is somekind of light-weight workaround for Calculated Columns and Totals using jQuery and the beloved CEWP. Find the original post here: http://www.endusersharepoint.com/?p=1106 (great work by the way :) ).

I have made an extension to this, so instead of just calculating the last column one can add any column for a total sum.
I use the sortable element ID to find the cellIndex for all rows that needs to be calculated (diidSortMean = a calculated column with the namne "Mean"). I use IE Dev Toolbar for that purpose.

The script currently calculates a total for three columns, but can easily modified in the CalcGroup function. My list is also expanded as default, will do more testing in the weekend.

If you find bugs, please leave a comment.


<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.min.js" type="text/javascript"></script> 
<script type="text/javascript">

function addCommas(nStr) {//formats number
 nStr += '';
 x = nStr.split('.');
 x1 = x[0];
 x2 = x.length > 1 ? '.' + x[1] : '';
 var rgx = /(\d+)(\d{3})/;
 while (rgx.test(x1)) {
  x1 = x1.replace(rgx, '$1' + ',' + '$2');
 }
 return x1 + x2;
}

function getCellIndex(elId)
{
  var myColumn = $(elId);
  var myParent = myColumn.parents('th');
  var result = myParent.attr("cellIndex");
  return result;
}

function getArrayList(varIndex, groupName)
{

 return $("#tbod"+groupName+"> tr").find(">td:eq(" + varIndex+ ")").get(); //array for groups based on cellIndex
}

function getArrayForOutput(varIndex, groupName)
{
 return $("#aggr"+groupName+"> tr:first> td:eq(" + varIndex + ")");
}

function CalcGroupPerColumn(groupName,varIndex)
{
 var x = 0;
 var m = "";
 var p1 = "";
 var p2 = "";
 if (groupName == '') {
  $("table.ms-listviewtable:first> tbody:eq(2)").attr("id","tbod");
 }
     
 var arrayList = getArrayList(varIndex,groupName);

 $.each(arrayList, function(i,e){
  x += Number($(e).text().replace(/\$|,|\)/g, "").replace(/\(/g,"-"));
  if ($(e).text().indexOf("$") >= 0) { m = "$" };

  
 });
 if (x < 0) {//format for negative numbers
  p1 = "(";
  p2 = ")";
  x = Math.abs(x);
 }
 
 var aggEl = getArrayForOutput(varIndex,groupName);

 if (arrayList.length > 0) {
  aggEl
   .css("text-align","right")
   .html("<b>Total = "+p1+m+addCommas(x.toFixed(2))+p2+"</b>");
 }
}


function CalcSqrtPerColumn(groupName, varIndex, sourceValue)
{
 var aggEl = getArrayForOutput(varIndex,groupName);
 var sqrtVal = Math.sqrt(sourceValue);

 if( sqrtVal > 0 )
 {
  if (aggEl.length > 0) {
   aggEl
    .css("text-align","right")
    .html("<b>Sqrt = "+ addCommas(sqrtVal.toFixed(2)) + " </b>");
  }
 }
 
}


function CalcGroup(groupName) {//sums money in specific list column

 var meanCellIndex = getCellIndex("#diidSortMean");
 
 var stdDevCellIndex = getCellIndex("#diidSortStd_x002e_dev");
 
 var varianceCellIndex = getCellIndex("#diidSortVariance");
  
 CalcGroupPerColumn(groupName,meanCellIndex);
 CalcGroupPerColumn(groupName,varianceCellIndex);
 CalcGroupPerColumn(groupName,stdDevCellIndex);
 
}
//rewrite of WSS function
function ExpGroupRenderData(htmlToRender, groupName, isLoaded)
{
 var tbody=document.getElementById("tbod"+groupName+"_");
 var wrapDiv=document.createElement("DIV");
 wrapDiv.innerHTML="<TABLE><TBODY id=\"tbod"+groupName+"_\" isLoaded=\""+isLoaded+"\">"+htmlToRender+"</TBODY></TABLE>";
 tbody.parentNode.replaceChild(wrapDiv.firstChild.firstChild,tbody);
 if (CalcGroup) {
  CalcGroup(groupName+"_");
 }
}
$(function() {
 CalcGroup('');
});
</script>

New employeer

2009-01-23T12:05:00.002+01:00

Hi all,

Back after a nice christmas vacation and with a new job. I have started to work as a SharePoint consultant for MMP AB in Malmö, where I´ll lead a new focus area regarding SharePoint.

// Henrik

off-topic: My grandmother Hilda celebrates her 100:th birthday

2009-01-02T20:31:00.001+01:00

Link to the local magazine in Varberg

// Henrik

ChiliRec

2008-11-18T13:34:00.002+01:00

This is the far coolest I have seen for quite some time. A digital recorder for online radio stations. http://www.chilirec.com. Check it out!

Playlists, top lists, browse per country...

The next thing I need to solve is to have this thing run on SqueezeCenter / SqueezeBox or Popcorn Hour. Might there be a SDK somewhere?

SJ - Internet ombord

2008-11-17T18:49:00.001+01:00

For the next trip, http://www.ombord.info/SJ/v5/default.asp, trying to use X1 as a browser.

SPD Workflows

2008-10-09T13:39:00.001+02:00

Error message in SharePoint Designer:
This website does not support workflows created by SharePoint Designer

My solution:
Only site collection administrators was able to create the workflows. Add the user as a site collection administrator.

Getting picky in CAML - Good

2008-09-26T10:58:00.003+02:00

I have code in Excel that uses XMLHTTP to call SharePoints web services. The code contains a CAML query where I had a field reference to a Choice field , , this column has been converted to a Text (Single line of text) column and the query didn´t return any items anymore when running against MOSS 2007 instead of Wss 2.0. Then I updated the field reference to and the query returned items again.

Sad

2008-09-05T13:54:00.004+02:00

Patrick Tisseghem has suddenly passed away and left a big hole in the Sharepoint community. He was one of the first bloggers I found before the release of MOSS 2007 and I was fortune to once meet him during a training session. My thoughts goes out to his family.

// Henrik

STSADM and SharePoint Designer operations failed

2008-08-23T12:41:00.003+02:00

I was getting error messages (cannot delete folder "WEBNAME") for deleteweb operation for stsadm and when opening the web in SharePoint Designer (SD) I got "There is no web "/XXX/YYY". Couldn´t delete documents but the web was browsable in SD (error code 16388). I finally tried to attach to the database in Visual Studio and got an error message about full transaction logs on the database server. In this case we configured "simple mode" instead and all operations completed sucessfully.

So know your DBA and have them close :)

// Henrik

Multiple methods in BDC

2008-06-26T20:26:00.004+02:00

ok, I have been looking for an answer to this question:
How can one entity contain several methods in BDC?

The answer is to define a MethodInstance with a type of GenericInvoker, this enables you to define a method on your entity which can be accessed via code but that is not exposed for the OOB BDC webparts. See http://agiledirect.wordpress.com/2007/08/09/bdc-writing-to-bdc-using-genericinvoker/ for an example.

You can also use the type ViewAccessor to return a different set of data which can be used in the OOB BDC webparts. See http://znetsys.spaces.live.com/blog/cns!ED65D09C41E55E06!115.entry for an example.

Crawling BDC applications

2008-05-18T09:46:00.002+02:00

Errors during crawling BDC apps? bdc2:// and (access denied by BDC) errors? Check this article, still problem? Search the log file in 12HIVE/Logs for "Access denied" to see which account that is casuing the problem. Still problem? Export the ADF and uncheck "Permissions", delete the Application and import the ADF again (still finally solved my problem)

Why BDC columns doesn´t work in Office / Doc Mgmt

2008-05-14T14:30:00.005+02:00

Using BDC columns in document libraries feels as a great option, but when trying to use it for any serious document management (using mostly OOB functions) it fails for the following reasons:

1. A BDC column can not be used as a field reference in Word. If you want to display information in header or footer the field reference can not be used.

2. The BDC column can not be configured as a site column (MacroView is workaround, but it can not be edited from the DIP). Major drawback to any usage of content types.

4. If you click the refresh button in the document library all your documents will be checked out again.

We are developing a workaround based on "Choice" columns and eventhandlers instead.

BDC on the other hand is great if you want to display information in web parts :)

Off topic: Memories

2008-04-07T21:44:00.003+02:00

I was watching a trailer for the swedish program Vetenskapsprogrammet and beside the presenter they had something running on a screen that really looked like the old Spaceballs demo State of the Art, a great demo 1992 for Amiga, it was one thing that made me want new hardware :). I still was using my good old C64, but great demos was also released 1992, just check this list:

Prometheus Unbound by Flash Inc
Red Storm by Triad
Crest Avantgarde by Crest
Wonderland IX by Censor Design
The Last Traktor III by Horizon
Legoland 2 by Fairlight

Get your C64 emulator from Team Vice and start downloading from The C-64 Scene Database.

- Dealer Quality Software -

Off topic: New hardware arrived

2008-03-19T23:45:00.002+01:00

The quest to get rid of the media plastic (CD/DVD) continues. Today a Popcorn Hour (PCH) got installed and hooked up to the TV. The PCH will read video files from the MCE, show pictures and sometimes play music. But it also comes packed with web services and other features. So now we can enjoy all lunatics on YouTube and Google Video, use the built-in Torrent client, and use the PCH as NAS if needed, read RSS feeds in the living room and so on. And whenever we decide to get a HD TV the PCH can playback HD movies directly.

So a quick summary: one MCE with touch screen in the kitchen which holds all media and for kitchen TV and sound, one SqueezeBox 3 for music playback and Internet Radio and now a PCH for movie playback and other online goodies.

The nice thing with all the hardware is that the vendors provide a possibility to add software and extend the OOB experience.

Which I´m most impressed with? The SqueezeBox was a really nice experience, mature product, easy to install, works OOB and can be enhanced with modules from the SqueezeBox community.

Swedish SharePoint bloggers

2008-02-29T08:05:00.001+01:00

http://www.dewe.net/sharepoint/2008/02/svenska-sharepoint-bloggare.html

GUID changes

2008-02-22T16:53:00.004+01:00

Hi,

Been a while...

Currently involved in a large migration of WSS v2 to MOSS. Found a thing that can be good to know. If you use the export and import actions in stsadm (WSS V3/MOSS) your lists will get new GUIDs when imported. This has consequences for dataviews (use this trick to remove the web part from the page) or custom web parts that binds to the GUID.

TAT in the news again!

2007-12-17T12:13:00.001+01:00

Per from TAT is interviewed regarding Android:
http://www.idg.se/2.1085/1.135610

Excel - converting text to numbers

2007-12-06T08:21:00.001+01:00

Many times I have wondered how to convert texts displayed as numbers to a true number in Excel, check this tip for a cool solution.

Passed certification 70-630

2007-11-21T10:16:00.000+01:00

Alot of Excel Web Services, Site directory and Search.

Multilanguage whitepaper for MOSS

2007-11-16T08:28:00.000+01:00

Building Multilingual Solutions by Using SharePoint Products and Technologies

* Learn how to create web parts to use the variation feature
* Get more info how the index and search web parts can be configured to support multilanguage sites
* Understand the variation feature with constraints and rules to remember

Passed certification 70-631

2007-11-14T10:02:00.000+01:00

Passed the test today, easier than I thought :) Make sure you know your NLB and IRM configurations.

http://www.microsoft.com/learning/exams/70-631.mspx

// Henrik

Stsadm command of the day

2007-11-12T20:30:00.000+01:00

Before moving MOSS content databases you should use "preparetomove". For the complete list
of commands and don´t forget the (developer) extensions from Andrew Connell.

Back from CMF2007 in Århus

2007-11-07T21:27:00.000+01:00

Just back from CMF2007 and two good days. The first day I attended two great tutorials, one with James Hubart talking about advanced UI portal strategies and Designing innovative intranets with James Robertson (link to cards used in tutorial). I really liked the time frame that the speakes got, four hours for diving into the subject instead of a rushed 50 minutes "product showcase".

The second day I attended the MOSS 2007 track with showcases of http://www.nhs.uk/ and LM Glasfiber intranet, not too many news for an old Sharepointer, but nice to see the concept and listening to the project setup and goverence structure.

The conference goes on with a third day, but I´m back in Sweden for other workshops during the week.

Warm Up script for SharePoint

2007-10-23T09:18:00.002+02:00

http://blogs.msdn.com/joelo/archive/2006/08/13/697044.aspx

Another variant, thanks for the link to Andrew Kennel

5 shattering mistakes for MOSS 2007 newbies

2007-10-22T16:27:00.001+02:00

http://www.techticles.com/5-shattering-mistakes-for-moss-2007-newbie-developers-and-team-leads.page

SharePoint Comparison Sheet

2007-10-17T16:24:00.000+02:00

An Excel sheet comparing features (new and old) regarding older and new SharePoint version.

http://download.microsoft.com/download/1/d/c/1dc632e8-71e1-466f-8a2f-c940f1438e0a/SharePointProductsComparison.xls

Seminar wih Fredrik Wackå

2007-10-17T09:16:00.000+02:00

Today I have attended a short seminar about Enterprise 2.0 with Fredrik Wackå. If you have the chance to listen to him, don´t miss the opportunity.

During the presentation he talked about how the intranet has evolved according to different publishing models, low hanging fruits (tagging!) to get started, trust in an enterprise (how can we ISO certificate a Wiki or blog posts?), crowd knowledge (
http://en.wikipedia.org/wiki/Wisdom_of_crowds), cross functional information sharing, relevance and resources, strategy for Enterprise 2.0 and the importance of measuring the behaviour (referring to IBM, which claims that it can´t be measured. Are we up to the challenge?)

Sites mentioned:
www.flickr.com
www.facebook.com
www.linkedin.com
www.digg.com
www.twitter.com
del.icio.us
www.jaiku.com

More info here:
http://www.wpr.se/

End to End Performance - Digging into your SharePoint Server and WSS Network Perf Issues

2007-10-15T15:25:00.000+02:00

http://blogs.msdn.com/joelo/archive/2006/08/17/703198.aspx

Managing enterprise metadata with content types and search.

2007-10-15T14:14:00.000+02:00

http://blogs.msdn.com/sharepoint/archive/2007/10/12/managing-enterprise-metadata-with-content-types-and-search.aspx

Sizing of dbs, sites, list and more objects in Sharepoint

2007-10-10T18:05:00.000+02:00

File Name, Length, Size and Invalid Character Restrictions and Recommendations
http://blogs.msdn.com/joelo/archive/2007/06/27/file-name-length-size-and-invalid-character-restrictions-and-recommendations.aspx

Plan for software boundaries
http://technet2.microsoft.com/Office/en-us/library/6a13cd9f-4b44-40d6-85aa-c70a8e5c34fe1033.mspx

Plan enterprise content storage
http://technet2.microsoft.com/Office/en-us/library/9994b57f-fef8-44e7-9bf9-ca620ce207341033.mspx

Dataview and unghosted pages

2007-09-27T12:09:00.000+02:00

The XSLT DataView can be used for many things when you want to customize the layout of web parts in your site. The problem when using the Data view on pages are that the pages gets unghosted. Follow this instruction to maintain your pages ghosted and even get a decent test and dev page.

1. Create a web part page
2. Add the list web part to the web part page
3. Open the page in FP 2003
4. Convert the web part to a XSLT Data View
5. Do your changes (the web part is actually converted to a XSLT document, check the Code window in FP 2003)
6. Save the page
7. Open the web part page in your browser and export the web part
8. Open the page you want to display the web part on (i.e Home)
9. Import the web part to the page (check the web part properties, the XSLT is available for direct editing)
10. Delete the web part page if you don´t need it anymore

Done

Querystrings for web part pages

2007-09-24T14:52:00.000+02:00

http://blogs.msdn.com/danielmcpherson/archive/2004/10/11/240863.aspx

Differences between WSS 3.0 and MOSS 2007

2007-09-19T15:21:00.001+02:00

Which SharePoint technology is right for you?

http://office.microsoft.com/en-us/sharepointtechnology/FX101758691033.aspx

Read list September

2007-09-07T07:59:00.001+02:00

http://www.steptwo.com.au/papers/kmc_effectiveim/index.html

Adding functionality without server installation

2007-06-28T00:01:00.000+02:00

While I'm enjoying my paternity leave I will write a few blog posts about extending Sharepoint sites without requiring developing and installing server side web parts. These posts will demonstrate a simple but effective approach for content aggregation and manipulating input forms on sites.

What you need to follow my examples are:

1. Two Invaluable Windows SharePoint Services (WSS) Shortcuts
2. Knowledge about JavaScript, DOM and XMLHTTP objects
3. A clear understanding of the security settings of your sites
4. The downsides to use this approach (will be discussed while moving along)

In the next blog post I will set up the infrastructure code.

Crawled properties for HTML documents

2007-05-08T15:02:00.000+02:00

We are currently running an intresting project including the index engine in cooperation with Tamino XML server. One action in the project is to index HTML documents from the Tamino XML server and use the MOSS Query Web Service to present search results.

The HTML contains the classic meta tag ">meta name="Keywords" content=""<" which still provides information to some crawlers. Here we encounter a problem. After the content source had been setup and the HTML documents had been crawled the "Keywords" properties didn´t show up in the crawled properties view, but other "meta" tags was, i.e ">meta name="Region" content="Sweden"<". For some reason the "Keywords" meta tag is skipped.

The solution to this case was to add another meta tag, "KeywordsCust" and add the same information as in "Keywords" from the source. After a full crawl the meta tag apperad in crawled properties, then just map it to "Keywords" in managed properties and you are ready to go.

Two test tools for the Query Web Service in MOSS / SPPS
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=89b3cda7-aad9-4919-8faf-34ef9b28c57b
http://www.mosssearch.com/searchwebservice.html

Heads up: Lookup column and multiple values

2007-04-24T21:06:00.000+02:00

There is a new setting when using a lookup column, "Allow multiple values". This means that you can choose several values from the lookup column. Great! But you can use the column in views for sorting or grouping, but it can be used for filter. A drawback ofcourse. Uncheck "Allow mulitple values" and it can be used for sorting and grouping again. The same behaviour goes for column "Choice" when using "Checkboxes"

Introduction to 'SharePoint Enterprise Search'

2007-04-24T09:54:00.000+02:00

A good introduction to the index engine, ifilters and the query interface. I have always considered the search engine the one component that is really worth the license cost of SPPS 2003 and with the improvments made in MOSS (change log crawling, continouse propagation) it will enable more accurate search results and better administration.

http://www.microsoft.com/technet/technetmag/issues/2007/01/Search/

If you are using Windows Desktop Search, then check out this tip to enable integration to the Search Center: http://markharrison.co.uk/blog/2006/10/sharepoint-search-directly-from.htm

Troubleshooting Explorer View

2007-04-13T12:39:00.000+02:00

When a user can not use the "Explorer View" (Cannot find 'file://\\server\site\doclib. Make sure the path or Internet address is correct.) in a document library in Sharepoint the first thing to check is the "WebClient" service. It needs to be started to be able to use the "Explorer View".

Microsoft has also released a whitepaper for troublehooting the Explorer View

Debug Feature in WSS

2007-04-13T09:17:00.000+02:00

http://blogs.msdn.com/sharepoint/archive/2007/04/10/debugger-feature-for-sharepoint.aspx

SharePoint Screen Casts and Demos

2007-04-10T16:48:00.001+02:00

http://blogs.msdn.com/joelo/archive/2007/04/10/sharepoint-screen-casts-and-demos.aspx

Read list:

2007-04-10T16:47:00.000+02:00

http://blogs.msdn.com/sharepoint/archive/2007/04/09/investing-in-logical-architecture-design-samples.aspx

Job security - the powerpoint way

2007-04-05T13:35:00.000+02:00

Dilbert

SharePoint Solution Installer from MondoSoft

2007-03-27T11:18:00.001+02:00

http://blog.mondosoft.com/ontolica/archive/2007/03/14/Generic-SharePoint-2007-Solution-Installer.aspx

Best Practices Analyzer for MOSS and SPS V3

2007-03-21T12:58:00.000+01:00

http://www.microsoft.com/downloads/details.aspx?familyid=cb944b27-9d6b-4a1f-b3e1-778efda07df8&displaylang=en

Extended search interface for MOSS

2007-03-21T12:25:00.000+01:00

Currently I´m evaluating the beta version of Ontolica search solution for MOSS. The web parts enables us to have quick search shortcuts and do additional filtering based on file extensions and content type. Currently in beta, but scheduled to be released in June.

Other search UI extended web parts will also be reviewed in this process. Watch this blog for more info.

Read list:

2007-03-20T16:25:00.001+01:00

Find It All with SharePoint Enterprise Search
http://www.microsoft.com/technet/technetmag/issues/2007/01/Search/

Heads up for RSS web parts in MOSS

2007-03-20T08:39:00.000+01:00

I noticed a design change in MOSS 2007 from the beta releases. The RSS web part can only consume feeds from anonymous lists or when using Kerberos (instead of NTLM).

http://technet2.microsoft.com/Office/en-us/library/e8493b73-ad1a-4642-8141-05405f0026781033.mspx?mfr=true. Search for "RSS Web Part"

I suppose this opens for third party RSS web parts (again)

// Henrik

How to add a User Information lookup field with code

2007-03-20T08:03:00.000+01:00

One of our developers asked me a question about adding a lookup field to the "User information" list with code. The "Add" method of SPFieldCollection wants a Guid for the destination list, but the "User information" list is not a SharePoint list. The solution is to use the "AddFieldAsXML" and submit a field XML instead.

SPWeb web = GetContextWeb(Current) 'Or whatever method used to acquire this object

SPList list = web.Lists[<listname>];

list.Fields.AddFieldAsXml("<Field Type="User" List="UserInfo" ShowField="Title" DisplayName="<FIELDNAME>" Name="<FIELDNAME>" />");

Verified for: WSS v2, SPPS 2003

Welcome!

2007-03-16T20:35:00.000+01:00

My first post! Well, this blog will be my daily scrapbook and an adventure into 2.0 (finally). This blog will mostly contain job related postings, so no more mass-mail to my colleagues ;).

For a more personal touch go to my familys blog.
// Henrik