Please note that some posts are written in Norwegian and some in English. I'm sorry for the inconvenience, but in some cases it's easier and more efficient to write in my native language.
Please use the blog channel English to view English posts only.

Codeplex recommendations

To make it somewhat easier to find active and interesting projects at Codeplex, I’ve put together a list of projects which I find useful and from sources I trust (at least so far :).

Solutions

Tools

  • SharePoint Manager 2007
    The SharePoint Manager 2007 is a SharePoint object model explorer. It enables you to browse every site on the local farm and view every property. It also enables you to change the properties (at your own risk). This is a very powerful tool for developers that like to know what the SharePoint holds of secrets.
  • SharePoint Management PowerShell Scripts
    A collection of PowerShell scripts for easier management of SharePoint.
  • SUSHI
    One of the best and most popular management tools for Sharepoint. SharePoint SUSHI is a powerful, user-friendly utility enabling you to accomplish common administrative tasks. You can think of SUSHI as a Swiss army knife for SharePoint.
    SUSHI = SharePoint Utility with a Smart, Helpful Interface 

Accellerators

See also the ordered list of best rated projects at Codeplex.

Sharepoint version number in Office 2003 docs

Since the automatic propagation of Sharepoint version number requires Office 2007 files (.docx), it’s often required to enable this functionallity manually.
 
I came over a blog entry which describes how to do this and implement it as a Sharepoint feature. See the following blog entry for details:
 
If you don’t have the possibility to deploy new solutions, you might use VBA as well. See the following article for information on how to do this:
 
However, since the macro and script security in Office often requires the persmission to run unsecured code, I recommend the feature approach.
 
If you only use Office 2007 document formats, simply add the "_Version" document property to your document and all is done.

SharePoint 2007/WSS3 Deployment Downloads

When deploying SharePoint it’s a lot of updates, additions and tools which should be downloaded and installed. To make it a bit more convenient, I’ve put together a list of recommended updates and additions.

All downloads are pointed to x86 platform releases. If the x64 platform is required, follow the links and choose the x64 download on the download page instead.

Supported platforms are any edition of Windows Server 2003 R2 with Service Pack 2 and Windows Server 2008. Requires Internet Information Server and ASP.NET installed and configured prior to deployment.

Please note that several security updates and other minor updates may be released and not available through this list. Please visit Microsoft Download sites for more information.

PREREQUISITES

SHAREPOINT CORE COMPONENTS

  • Windows SharePoint Services (WSS) 3.0 with SP2
    The SharePoint edition which is free with a Windows Server license including Service Pack 2. English version.
  • WSS 3.0 Service Pack 2
    The latest service pack for SharePoint Services 3.0 which is required for quite a few features. The patch is not required if WSS 3.0 is installed with SP2 (the link above). Must be installed even if MOSS is installed with the latest service pack.
  • WSS 3.0 Language Packs
    All the language packs available for WSS 3.0, including my native language (Norwegian).
  • WSS 3.0 Language Pack Service Pack 2
    The latest service pack for the language packs. Must be installed even if MOSS is installed.
  • Microsoft Office SharePoint Server (MOSS) 2007 Trial
    The 30 day trial of Microsoft Office SharePoint Server Enterprise Edition, which includes all enterprise features such as forms and Excel services. English version. A pre-installed virtual machine is also available for download at Microsoft’s download center.
  • Office Servers Service Pack 2
    The latest service pack for all Office Servers including SharePoint Server. Requires WSS SP2 before installation.
  • Office Servers Language Packs
    All the language packs available for all Office Servers, including SharePoint Server.
  • Office Servers Language Packs Service Pack 2
    The latest service pack for all language packs for all Office Servers. Requires MOSS SP2 installed prior to installation.

SQL SERVER COMPONENTS

DEVELOPMENT & CUSTOMIZATION

DOCUMENTATION

SAMPLES

RECOMMENDED SOLUTIONS

RECOMMENDED TOOLS

  • Sushi
    A free-prog binary tool for everyday SharePoint maintenance. Published under the MPL agreement.
  • SharePoint Manager
    A free-prog binary tool for exploring and managing SharePoint content. A must for SharePoint administrators.

RECOMMENDED RESOURCES

 

N’Joy"!

Diamond 2 – The real iPhone killer

I’ve used the HTC Touch Diamond for quite some time, but there has been some issues, such as poor performance and stability. A couple of days ago I got a hold on the new HTC Touch Diamond 2, and now I’m in heaven!

The new Diamond phone has a bigger display, far more user friendly with new applications and a better FLO 3D release, a lot more responsive (quicker) and so far a lot more stabile. In addition, the new Diamond has a micro SD slot as well (finally!).

The critics has commented on the quality of the 5 megapixel camera, but since I primarily use the phone as a phone and PDA and not a camera, I don’t find this to be essential. Besides, the photos is more than adequate for me 🙂

My best recommendations!

Desired SharePoint Solutions

April 21, 2009 1 comment

In many cases there’s a need for a set of default web parts and solutions for SharePoint to give the user a better experience, and designers tools to create nice web solutions. I’ve been working with SharePoint for quite a few years, and during this time my experience is that the following basic web parts and solutions often are required.

If anyone have solutions for these needs or would like to develop them as Open Source projects, please let me know. In addition to the solutions specified below, I think the following solutions might be just as relevant, but will generate quite a lot of work:

  • Organization chart based on user profiles
  • Basic graphical charts, typically as included in .NET FrameWork 3.5, similar to the ChartPart for SharePoint or the Charting for SharePoint projects at Codeplex
  • Phone Book/List view of the profile database (not  just people search)
  • LDAP directory lookup and search
  • Customized list forms with a forms designer
  • File explorer with delegated permissions
  • PowerPoint mini-viewer web part to display a PPT in a small web part (Silverlight)
  • Rolling info screen presentation based on SharePoint content (Silverlight)
  • User self service with AD property modification, password resets and more
  • Server side Power Shell script execution
  • Corporate CV database based on the user profiles shared service

In general all solutions should be flexible in terms of deployment scope, languages, WSS/MOSS and highly configurable.

Content Tagging with Tag Clouds

This solution is more or less the same as any standard tagging feature, but for some reason it’s not included in SharePoint. The solution should cover as many of the following requirements as possible:

  • Tagging of any content type in any site within a site collection
  • Dynamically storing all used tags in a configurable tags list
  • Auto complete lookup towards the configured tags list (Ajax)
  • Highly customizable rendering

The SPTags project at Codeplex is a possible solution to cover this need.

Cross Site List Aggregator and Rollup

This solutions should be able to aggregate information from a specified list type in different sites and display the aggregated result. The solution should be able to use all Sharepoint view features, such as the default list view, calendar, Gantt charts and more.

A possible solution for this is the Portal Solutions SharePoint Toolbox project at Codeplex.

Advanced Lookup Field

The standard lookup field in Sharepoint is very limited. It’s not possible to use this field cross site or towards any other data source other than a Sharepoint list. In addition, it’s not very user friendly, especially with a large number of entries returned to the user.

Some of the basic features of this solutions should be:

  • If the input field is free text, it should be possible to enable auto complete as the user types. Typically implemented as Ajax.
  • It should be possible to use more or less any data source as a lookup source.
  • The lookup should be able to filter and sort the returned results based on configurable options.
  • It should be possible to enable dynamically connected lookup fields which filters the selection list based on a value in another field.
  • Both multi select and single select must be configurable
  • The rendering of the selection alternatives must be configurable

The SharePoint Filtered Lookup Field project at Codeplex covers the need for filters in a lookup field, but it’s not possible to combine this feature with other solutions such as dynamic/connected and auto complete lookup fields.

The SharePoint Connected Lookup project at Codeplex covers basic needs for dynamically connected lookup fields, but again it’s not possible to combine this feature with other solutions.

Multi RSS Feed Reader

The MOSS RSS feed reader does not support WSS and multiple feeds, and in many cases it’s desirable to have multiple feeds combined as one. It’s also important to have a good RSS reader for WSS.

The best solution I’ve found so far is the Smiling Goat RSS Reader, but there are several issues with this solution. Among other things, the solution has problems with non-English characters and the formatting is poor. For commercial use it’s not preferable to have author branding as the web part icon.

Content Rating

This solution should be able to rate any content on a SharePoint site or site collection regardless of content type (libraries, lists and pages). The rating should be configurable as both strings and numbers as well as the presentation such as images, strings or other visual effects.

The SharePoint Tool Basket project at Codeplex contains a solution which might cover this need, but I’ve not been able to try this out yet.

Mini Calendar View

On most intranets and public internet sites, where a schedule is an important part of the business, it’s often requested to have a tiny calendar on the front page which highlights the dates in a month with content and displays the entries when a user hovers over the date. Each date in the mini calendar view should be linked to a calendar and the appropriate date.

I know that Bamboo Solutions have some commercial alternatives, but I haven’t been able to test them yet.

Calculated Icon Field Type

Lists in SharePoint is often used as an alternative to Excel spreadsheets, but there’s one important feature missing which is conditional formatting, especially icons to visualize status of the rows.

I’ve seen some solutions at Codeplex, but these solutions are limited in use. Among other things, it’s not possible to configure which images to use and the criteria/rules are limited to specific values or ranges. It should be possible to define SharePoint formulas as the criteria and custom images based on the result of the formula.

Based on a tip from one of my associates, I’ve manage to accomplish this by altering the fldtypes.xml file on the server, but I don’t think hacks are the way to go in a commercial production environment.

In addition it would have been nice to have conditional formatting in any list similar to conditional formatting in Excel 2007.

User Poll

This solutions is a quite straight forward User Poll, but it should be possible to use the Poll both as an authenticated user and as an anonymous user. It should be configurable if the user may respond several times or not, and if the user may see the results of the poll.

Some projects at Codeplex covers some of the needs, but anonymous poll is not supported and the configurability and styling is very poor.

What’s New and What’s Hot

This is actually two different solutions which is closely related. The What’s New web part should display the newest items on a site or site collection with the ability to filter on specific lists. It should be customizable how the result is displayed and how many items to return.

The What’s Hot web part should display the top x items on a site or site collection. The solutions should be able to exclude some pages/entries, such as the home page of the site, and the information returned or displayed should be customizable.

Web Capture Web Part

In SharePoint Portal Server 2003 (SPS) Microsoft shipped a web part called "Web Capture" which grabbed parts of any web page and displayed the result in a web part. With Office Systems 2007 the feature disappeared, including the client side ActiveX control required to browse and select elements for the targeted web page.

Since it’s lots of web sites and web applications which doesn’t support any kind of data aggregation or integration, this solutions was great. However, it’s gone.

I deployed the SPS web part on WSS/MOSS and the web part it self works fine, but it’s required to use Office 2003 to have the ability to browse and select which element to grab. In addition, the old web part only supports table tags, and the div tags are more commonly used and the W3C recommended tag for layout purposes.

Ticker Web Part

The Ticker should be able to display content from lists, web services and RSS feeds as a scrolling text, both vertically and horizontally, similar to the stock ticker you might find on any financial web page. The web part should be able to use both JavaScript and Silverlight or flash as client side presentation.

Hold’em Tournament Rounds

January 1, 2009 Leave a comment

For sosiale Hold’em turneringer har jeg funnet ut at følgende rundetabell fungerer svært bra. Oppsettet er basert på en start-stack på 12.500,- og varighet på ca. 2,5 timer med inntil 8 spillere, og nærmere 3 timer med inntil 10 spillere.

Runde Varighet Small blind Big blind Ante Tid
1 20 min. 100 200 0 00:20
2 20 min. 200 400 0 00:40
3 20 min. 300 600 100 01:00
4 20 min. 400 800 100 01:20
5 20 min. 600 1200 100 01:40
6 20 min. 800 1600 200 02:00
7 15 min. 1000 2000 200 02:15
8 15 min. 1500 3000 400 02:30
9 15 min. 2000 4000 400 02:45
10 15 min. 2500 5000 700 03:00
11 15 min. 4000 8000 1000 03:15
 
Når vi har brukt dette oppsettet så har de fleste turneringene på 6-8 spillere tatt ca. 2,5 timer og det har sjeldent vært noen som har gått ut før etter 1,5 time. Det vil si at det sjeldent ventes mer enn en times tid før ny turnering begynner.
 
N’Joy!

Mah-Jong poengberegning

December 26, 2008 Leave a comment

Mah-Jong, et gammelt kinesisk spill, har i nyere tid blitt mer populært også i den vestlige verden. Det er imidlertid ofte spørsmål om regler og poengberegning, og for å gjøre det lettere for de som ikke er kjent med poengberegningen, har jeg laget en kortfattet oversikt over poengene, doblingene og spesialkombinasjonene som også gir Mah-Jong.

Ettersom Mah-Jong spilles på svært mange forskjellige måter har jeg ikke skrevet noe om regler. Som oftest følger det med et hefte som beskriver spillet og de vanligste reglene. Poengene er på sin side ofte de samme og er det jeg har fokusert på her.

Kombinasjonene

Følenge kombinasjoner benyttes for å gjøre en Mah-Jong:

Tjao 3 brikker etter hverandre i serie (tekken, bambus eller ringer)
Par 2 like brikker
Pong 3 like brikker
Kong 4 like brikker

Poengene

Tjao 0 poeng
Pong på bordet i 2-ere til 8-ere 2 poeng
Pong på bordet i honører, 1-ere og 9-ere 4 poeng
Pong på hånden i 2-ere til 8-ere 4 poeng
Pong på hånden i honører, 1-ere og 9-ere 8 poeng
Kong på bordet i 2-ere til 8-ere 8 poeng
Kong på bordet i honører, 1-ere og 9-ere 16 poeng
Kong på hånden i 2-ere til 8-ere 16 poeng
Kong på hånden i honører, 1-ere og 9-ere 32 poeng
Blomster og årstider 4 poeng per stykk

 

I tillegg får den vinnende hånden (den som gjør Mah-Jong) poeng på følgende:

  • 2 poeng for par i drager, egen vind eller rundens vind.
  • 2 poeng om den siste brikken ble trukket fra muren.
  • 10 poeng om den siste brikken ble trukket fra ruinen.
  • 10 poeng for verdiløs hånd (4 tjao + et par uten verdi).
  • 20 poeng for selve Mah-Jong’en.

Doblinger

Følgende doblinger gjelder for alle hender, uansett om det er vinnerhånden eller ikke.

  • Pong eller Kong i drager
  • Pong eller Kong i egen vind
  • Pong eller Kong i rundens vind
  • Alle 4 årstidene gir 3 doblinger
  • Alle 4 blomstene gir 3 doblinger

I tillegg får vinnerhånden (den som gjør Mah-Jong) doblinger for følgende:

  • Mah-Jong gjøres på den siste mulige brikken
  • Kun Pong og Kong samt et par (ingen Tjao)
  • Kun honører (drager, vinder, 1-ere og 9-ere)
  • Kun én serie (tekken, bambus eller ringer) samt vinder og/eller drager
  • 3 doblinger for utelukkende én serie (tekken, bambus eller ringer)
  • 3 doblinger for Pong, Kong eller par i alle 4 vindene
  • 3 doblinger for Pong, Kong eller par i alle 3 dragene

Maksimumspoeng

Det finnes flere måter å regne poengene på, og hva som skal være maksimumspoeng. På grunn av at det finnes flere spesialkombinasjoner som gir maksimumspoeng må det settes en verdi som skal være maks, og det mest vanlige er å beregne maksimumspoeng på 500.

Det vil si at en hånd med en poengverdi på 54 og 4 doblinger, som normalt sett ville blitt 54 x 2 x 2 x 2 x 2 = 864, bare gir 500 poeng. Hvis en spiller får Mah-Jong med en spesialkombinasjon, slik beskrevet i avsnittet under, får spilleren automatisk maksimumspoeng uavhengig av håndens egentlige verdi.

Spesialkombinasjoner

I tillegg finnes det flere spesialkombinasjoner som også kvalifiserer til Mah-Jong selv om det ikke er en tradisjonell kombinasjon med 4 stk. Pong eller Kong samt et par. Disse spesialkombinasjonene gir alle maksimumspoeng (500) og er i korthet beskrevet som følger:

  • Himmelsk velsignelse
    Dersom Øst umiddelbart kan gjøre Mah-Jong med de utdelte 14 brikkene.
  • Jordisk velsignelse
    Dersom noen av spillerne kan gjøre Mah-Jong med den første kastede brikken av Øst.
  • De tre store mesterne
    En hånd som består av 4 Pong + 1 par og alt er plukket fra muren (holdt på hånden) og holdt skjult. Ingen Kong får forekomme.
  • De fire velsignelsene
    En hånd bestående av Pong eller Kong av alle 4 vindene og et valgfritt par.
  • Stor honørhånd
    En hånd bestående av utelukkende drager og vinder, inklusivet paret.
  • Hode og hale
    En hånd bestående av Pong eller Kong i bare 1-ere og 9-ere pluss et par i enten 1-ere eller 9-ere.
  • De tretten undre
    En hånd bestående av en av hver honørbrikke (alle 1-ere, 9-ere, drager og vinder) samt et par i en av disse.

Føring av poeng

Generelt skal alle spillerne gi og få poeng fra samtlige øvrige spillere med unntak av den som gjør Mah-Jong. Den som gjør Mah-Jong slipper i gi poeng til de andre spillerne. I tillegg skal Øst alltid både få og gi doble poeng.

For å gjøre det enklere å føre poengene har jeg laget et Excel regneark som beregner poengene i forhold til hvor vindene er, hvilken runde det er og hvem som gjør Mah-Jong. Selve regnearket bør være forholdsvis intuitivt å bruke og kan lastes ned for eget bruk.

Last ned skjema for poengberegningen.

God Jul og Godt nytt år!

December 24, 2008 Leave a comment

Året 2008 har vært et hektisk år med mye forandringer og tilsvarende mange utfordringer. I de aller fleste tilfellene er dette til det bedre og noe man lærer en god del av å komme seg igjennom. Høsten har vært, som for de aller fleste, preget av finanskrise og usikkerheter, men skal vi tro media og politikkerne så er dette midlertidig og forbipasserende utover 2009. Har man en trygg jobb så bør ikke finanskrisen by på de aller største problemene.

Personlig holder jeg  hodet hevet og går inn i et nytt år med forhåpninger og tro på en ny oppgang med nye utfordringer og muligheter for forbedring!

Jeg ønsker derfor alle lesere en riktig god jul og et fantastisk godt nytt år!

Lasse

Amazing photos

December 12, 2008 Leave a comment
Today one of my colleagues sent me this link and recommended that I took the time to view the page, and what can I say. Amazed!
I suggest you take a look yourself at some quite incredible photos.
http://www.smashingapps.com/2008/12/07/23-awesome-photos-that-look-like-theyre-photoshopped-but-are-not.html
 
N’Joy!

Komersiell bruk av web 2.0

December 12, 2008 Leave a comment

Det har i lengre tid vært snakk om web 2.0, uten at noen helt har klart å definere hva som ligger i det, men har vært lite snakk om bruk av dette i kommersiell sammenheng. Med utgangspunkt i at web 2.0 i hovedsak utstrakt bruk av interaktive tjenester, flate hierarkier med metadata, sosiale nettverk med tilhørende nettverksbygging og ikke minst dynamikken med integrerte tjenester, har jeg forsøkt å sette web 2.0 i et kommersielt perspektiv.

Noen av de teknologiske verktøyene som brukes i web 2.0 er blant annet personlige profiler, blogger, wiki, lynmeldinger og ikke minst fasetterte søk og integrasjon mellom tjenester. Personlig tror jeg at dette er helt ideelt å bruke innenfor kommersiell virksomhet, og spesielt i kompetansebedrifter. Ettersom norske selskaper i stor grad lever av humankapital er det svært viktig å både dele og ivareta den kompetanse som hver enkelt medarbeider sitter med. For å illustrere dette har jeg beskrevet et scenario basert på et fiktivt selskap kalt Lace.

Lace er en kompetansebedrift der store deler av de ansatte arbeider som konsulenter ute hos kunder og derfor har liten kontakt med de øvrige ansatte. Samtidig er den essensielt at alle deler sin erfaring og kan spille på andres erfaringer i forbindelse med prosjekter og problemstillinger. For enkelhetsskyld bruker Lace Sharepoint 2007 som basis for det eksisterende intranettet, som utelukkende benyttes til å publisere interninformasjon, altså ingen samhandling eller personlige profiler.

%d bloggers like this: