Adventures with WSS and Workflow Foundation (Ctd.)

Here's a little appetiser about combining SharePoint and Windows Workflow Foundation.
workflow

Adventures with WSS and Workflow Foundation: Assembly does not allow partially trusted callers

I'm currently working on an article about combining Workflow Foundation and Windows SharePoint Services 2003. I'm using a document library event handler to call into a workflow created with Windows Workflow Foundation which I expose through a webservice. But at a certain point I got this error:

Event Type: Error
Event Source: Windows SharePoint Services 2.0
Event Category: Devices
Event ID: 1000
Date: 14/12/2005
Time: 16:31:36
User: N/A
Computer: SPS1
Description:
Unable to instantiate event handler (assembly "DocLibEventSink, Version=1.0.0.0, Culture=neutral, PublicKeyToken=a219993018140b5e", class "DocLibEventSink.EventSink"), or report event for "Shared Documents/camlquery.txt" in "Shared Documents". System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Security.SecurityException: That assembly does not allow partially trusted callers.
at System.Security.CodeAccessSecurityEngine.ThrowSecurityException(Assembly asm, PermissionSet granted, PermissionSet refused, RuntimeMethodHandle rmh, SecurityAction action, Object demand, IPermission permThatFailed)
at DolmenWorkflow.Workflow1_WebService..ctor()
at Service..ctor()
The action that failed was:
LinkDemand
The assembly or AppDomain that failed was:
DolmenWorkflow, Version=3.0.0.0, Culture=neutral, PublicKeyToken=null
The Zone of the assembly that failed was:
MyComputer
The Url of the assembly that failed was:
file:///C:/Inetpub/wwwroot2/dolmenwfservice/bin/DolmenWorkflow.DLL
--- End of inner exception stack trace ---


Luckily I found the answer through Google - Using Libraries from Partially Trusted Code. Since the SharePoint document library event handler needs to be deployed into the Global Assembly Cache (GAC), I also needed to deploy the DolmenWorkflow assembly into the GAC. Another workaround would have been to use the AllowPartiallyTrustedCallersAttribute

References:

Official Microsoft Windows Workflow Foundation website

Download Windows Workflow Foundation Beta 1.2 (for Office "12" Beta 1) - for Visual Studio 2005 RTM

sharepoint

SharePoint Tools Galore v5

Time for another update of the SharePoint and MCMS tools Galore list, version 5 here it comes.... I added some new sections and added some tools to existing sections as well.

SharePoint toolsuites

Coras workplace suiteSuite with
rollup webparts (for news,documents,tasks,...), navigation controls and full language localization (This is way cool...)

Syntergy Provide lots of modules such as
replication technologies for SharePoint, bulkloader, audit for SharePoint,...

Tools for SharePoint from SPSDev.com - contains Pocket Portal,
My Team OrgChart WebPart, Bulk upload

Search

Entopia K-Bus for SharePoint Portal Server: Adds extra information discovery capabilities, also allows
SharePoint to index Documentum, Opentext,...

WSS PowerSearch - The developers ofthis product also have
some other nice SharePoint tools, check out PowerRecycle and PowerNav

Behaviortracking from Mondosearch

Coveo SharePoint search

SharePoint Advanced Search Tools (Gotdotnet)

Ontolica - enhanced search interface for the SPS search engine

SharePoint word breaker update

MCMS (Microsoft Content Management Server)

MCMS Manager 3.0

Telerik RAD controls for MCMS

AchieveForms for CMS

CMS.Rapid

Metalogix migration manager

Smart language connector for CMS

Backup/Data Recovery/Antivirus

SharePoint document recovery tool : Free download from Stephane Cordonnier

McAfee Portal Shield Antivirus solution

AVG SharePoint Server Edition web site Antivirus solution

Sybari Antigen for SharePoint

TrendMicro PortalProtect Antivirus solution

Bitdefender for Sharepoint - Antivirus solutions

SharePoint Dynamic Site Collection backup (Webfox Inc.)

Workflow

NetPoint Solutions

Factiva:Search and workflow tools for Office 2003

Captaris Teamplate: This workflow toolset even adds a module for fax based workflow "RightFax Workflow wizard

Skelta workflow .Net

K2.Net

Nintex smartlibrary

Smart workflow from LMR Solutions

DataLan FlowBuilder

ActiveSPS Workflow Solutions

Biztalk adapter for SharePoint

Document, Records and Digital Assets Management

Meridio: .Net software which integrates seamlessly into SharePoint and provides records management
features needed to be compliant with standards such as Sarbanes-Oxley, US DOD 5015.2 records management standards,...

Towersoft

Wisdom

Mobius

Equilibrium MediaRich for SharePoint- digital asset management (DAM) solution to Microsoft Office Systems 2003.

Workshare Professional -Secure document compliance

Gigatrust

Hyper.Net (Coextant)- Cross-media content automation server

RSS Feeds & SharePoint

RSS Feed for SharePoint Lists (U2U)

PortalBuilder RSS Extensions for SharePoint- RSS XML feeds (and lists) are the building blocks for building live interfaces for SharePoint data using AJAX technologies. Deployed in the _layouts virtualized application, these feeds are available from server and client side code and can be used as an AJAX XML data source.

Syndication Generator for WSS (Bluedog Limited)

SharePoint Syndication Generator (Sig Weber)

RSS Feed Viewer webpart (Sig Weber) -RSS Viewer Web Part based on the built-in SharePoint XML Web Part and a custom XSLT transformation

SharePoint Syndication (DevHawk) -Extension for SharePoint (WSS and SPS) that exposes site information via standard XML syndication formats (RSS, OPML, etc)

Utilities & developer tools

SharePoint Explorer : another free tool which you can use to explore the SharePoint object model

Admin report kit for SPS 2003: configuration and usage reporting tool for SPS 2003

SharePoint site permission manager (Gotdotnet)

SharePoint explorer for VS.Net

BlueDogLimited Webpart Tool Kit

CAML Query Builder (U2U)

SharePoint Configuration analyzer

CAMLViewer 1.0 (Stramit)

James Milne's SharePoint CSS Skinner

Office Web Components

SPS Portal 2003 Search Web Service Tester

Windows SharePoint Services: Usage Blob Parser

ViewPoint - SharePoint navigation and modeling tool

SharePoint Utility Suite Release 2 and SPSiteManager 1.1

SMove for SharePoint

SharePoint analyzer - Gathers information about a SharePoint configuration - Created by Mike McIntyre, an Escalation Engineer in PSS, and is used extensively by PSS in troubleshooting customer issues

SharePoint Explorer (IE Addin)

Admin Report Kit for SharePoint (ARKSP) -Configuration and usage reporting tool for SharePoint Portal Server 2003 and Windows SharePoint Services. ARKSP presents information across virtual servers, portal sites, site collection and lists in SharePoint in simple report formats.

SharePoint Portal Area explorer

Portalbuilder application blocks

Cross-forest people picker-This picker requires and leverages the profiles in SPS for adding users to Windows SharePoint Services sites as a replacement to the Outlook address book button.

Reghost.Net- Reghost your unghosted SharePoint pages

SharePoint Database split (WSSSplit) -This tool automates splitting large Windows Sharepoint Services Databases into several smaller Databases. Based on an input, the process locks, backups, deletes and restores a SiteCollection.

Universal SharePoint Manager (IDevFactory)

Recycle bin solutions

Deleted Items Document Library Custom List Template

SharePoint Recycle BIN (Gotdotnet project)

InfoPath

CaveDigital XML Form WebPreviewer Web Part- allows users without InfoPath to view the contents of forms on their web browser.

AchieveForms

InfoView

NetXPert InfoScope

InfoJet EditPart for SharePointEdit your InfoPath forms from within your browser

WebParts

Acar Learning Technologies - Poll webpart for SharePoint, Quiz webpart for SharePoint

CSEG Rollup webpart

FluidNature image webpart

Calendar webpart

My ChangePasswordControl Webpart for Sharepoint

Office Live meeting webparts

Cave Digtal XML Form webprevriewer webpart

SharePoint FAV 1.1

The Dot Net Factory - Active Directory WebManager Enterprise Edition

Easy tabs webpart

Windows Folder webpart- The Windows Folder web part allows users to store files within a standard Windows (NTFS) folder in a shared network location and display a list of those files in a SharePoint page via a consistent ‘document library’-style interface.

TraceInfo WebPart

High availability & replication

Neverfail for SharePoint- Replication, switchover, failover and switchback for SharePoint

DoubleTake

Echo for SharePoint

Business Intelligence & Reporting

DSP Portal Edition : Adds webparts which can display information from OLAP cubes

Omnisys Power Gauge - displays measurements based on various types of data sources, using dynamic and configurable gauges.

Crystal Reports SPS integration kit

BI Portal

SQL Server 2000 report pack for SPS

Proclarity for SharePoint Portal Server

SharePoint Reports (Gotdotnet)

Miscellaneous

Brightwork: adds MSF (Microsoft Solution Framework) on top of SharePoint

Ratings & expert module for SharePoint

K-Wise - Migration tools

Factiva Modules to integrate news sources into your WSS/SPS (Factiva is a Dow Jones & Reuters company)

Advis site navigator Navigation and UI enhancements

Omnisys Probability Impact Matrix webpart - based on WSS risk list from Project Server 2003

CAHSAL ecKnowledge

KnowledgeLake Connect

Offline/Mobile Portal capabilities

Digilink revelation Lets mobile users synchronise offline information with SPS and WSS

IORA Another solution for offline SharePoint usage

Groove - software firm that Microsoft acquired a couple of months ago, they sell amongst other Mobile workspace for SharePoint

BerryPoint - Adapts SharePoint for display on Blackberry

Colligo for SharePoint

Identity management and single sign on

Version3 - Simple Signon

Web Single sign on for SharePoint - Single sign on between Office and SharePoint in extranet scenario's

Migration tools

Casahl ecKnowledge

Tzunami deployer

SharePoint Import Export tools (Gotdotnet)

sharepoint

Belgian geek dinner with Scoble

Yesterday's Geek dinner, definitely was different from the previous one I attended and not only because I met Robert Scoble.... Quite a different audience, most of them joked around about the evil empire Microsoft - but the conversation was quite interesting:

It seemed that I missed a big blog conference in Paris called Les Blogs 2.0 - with a interesting story about Mena Trott, president of Six Apart, and Ben Metcalfe - Read more about it here - Handbags at Les Blogs 2.0

Interesting comment from Smetty (yes she did kiss Scoble)about podcasts - "They are only mp3s which you put on your blog..." - I can't agree about it more...

You can actually get a degree in "Interactive marketing",... ask this guy.

Scoble agreed with the fact that most companies still seem to be quite reluctant towards using blogs as a communication medium...

Jelle and Scoble had a funny conversation talking about Rory Blyth -Neopoleon- ... I' m not going to give any more details, maybe Jelle will.

There seems to be a pretty big community of Belgian bloggers - here's a list of some which I met yesterday:

[blog.forret.com]
Blogologie (10) [Maarten]
Coolz0r - Marketing Thoughts
Doppler : Redefining podcasting
druppels
LVB.net
net | log
Smetty's Soapbox [Cindy De Smet]

blogsblog
weblog

Avalance - new software distribution solution

Somasegar talking about Avalance:

The frequent Community Technology Previews (CTPs), Betas and other kinds of information across the different products often end up causing a virtual ‘avalanche’ of information flow for our customers. These information 'avalanches’ pose problems related to congested servers, network traffic and download speeds.

To address these issues, Microsoft Research (MSR) is working on innovative technologies with the codename "Avalanche". Avalanche provides a PC-based, fast, internet-scale software distribution solution. The Avalanche model addresses internet software-distribution problems using network coding which ensures that any piece uploaded by a given peer can be of use to any other peer. This research paper and these slides provide more information on network coding and Avalanche.

The Developer Division has a pilot project under way using Avalanche to download CTP bits for our Most Valuable Professionals.

Sounds very interesting, I definitely want to try this out once the pilot project is up and running...

SmartPart - load ASP.Net 2.0 usercontrols in SharePoint 2003

Jan just released a new tool - "Son of the smartpart":

Here’s some good news for everybody that has been waiting for it: I’ve just uploaded the brand new Son of SmartPart to the GotDotNet site! First of all, what is the Son of SmartPart? This version of the SmartPart will allow you to run ASP.NET 2.0 Web User Controls and ASP.NET 2.0 Web Parts in SharePoint sites. Since WSS SP2 you can run your SharePoint sites on the .NET Framework version 2.0, and from now on you can use the power of the new platform to extend SharePoint.

Download the latest release from the GotDotNet site here

Watch the screencast demonstrating the deployment

I just installed it and everything works just great....Nice job, Jan

Updated 26/11: Jan created a SharePoint site behind www.smartpart.info to demonstrate some webparts.... you can still download the SmartPart by going directly to the Smartpart Gotdotnet workspace.
sharepoint

Geek dinner with Robert Scoble

From David:

Robert Scoble is visiting Belgium on on December 8th. So if you want to talk about corporate blogging & its effects, discuss how to deal with blogs, why blogs are hot - or talk about any other geek topic you are invited to join us on December 8th 2005 for the Brussels Geek Dinner. So, if you live in the area, or know other geeks in the area, you might tell them we'll be having this geek dinner! Please find the details below:

What: Brussels Geek Dinner
Date: December 8th 2005
Time: 6:30pm
Where: Serenata, Zaventem
Who is welcome?: Everyone! ... but please let me know!

Send an email to David or leave a comment on his posting when you are going. I know I am....

HOWTO: Use Virtual PC's Differencing Disks to your Advantage

This is a definite must read for everyone using Virtual PC, HOWTO: Use Virtual PC's Differencing Disks to your Advantage . Nice job, Andrew

Dolmen Jobevent

Interested in working at Dolmen - check out the Dolmen Jobevent




PS All of you SharePoint & ASP.Net developers, definitely come and take a look...

Cannot create an SPS Area after installing WSS SP 2

Patrick blogged it first ... but here it goes again:

When you attempt to create a new area in SharePoint Portal Server 2003 after applying Windows SharePoint Services Service Pack 2 you receive the following error message:
An error has occurred in the portal site. Contact the portal site administrator for assistance.

Cause:
The file timestamps on the SharePoint SQL script files is incorrect. These files are located in :\Program Files\Common Files\Microsoft Shared\web server extensions\60\TEMPLATE\SQL.
Because the timestamps are incorrect WSS SP 2 did not update these files and subsequently the stored procedures for the content databases were not updated.


Resolution/Workaround:
1. Remove the *.SQL files in location :\Program Files\Common Files\Microsoft Shared\web server extensions\60\TEMPLATE\SQL.
2. Go to Add/Remove Programs, Windows SharePoint Services, Repair/Reinstall.
3. Select 'Detect and Repair errors in Microsoft Windows Sharepoint Services 2.0 installation'.
4. After repair completes you will need to force an upgrade so the stored procedures on the content databases are updated.

To complete this step, use the Stsadm.exe command-line tool to force an upgrade of the content databases.

To do this, follow these steps:
1. Click Start, click Run, type cmd in the Open box, and then click OK.
2. At the command prompt, type the following lines, and then press ENTER after each line:
cd /d %commonprogramfiles%\Microsoft Shared\Web Server Extensions\60\Bin
stsadm -o upgrade -forceupgrade
3. Type exit to quit Command Prompt.
sharepoint

Feature Pack for SQL 2005 - Microsoft .NET Data Provider for mySAP Business Suite

I just stumbled on this download - Feature Pack for SQL 2005 . The Feature Pack is a collection of standalone install packages for SQL Server 2005. It includes:

Latest versions of redistributable components for SQL Server 2005

Latest versions of add-on providers for SQL Server 2005

Latest versions of backward compatibility components for SQL Server 2005

One of the interesting providers in this feature pack is the Microsoft .NET Data Provider for mySAP Business Suite. This provider lets you create an Integration Services package that can connect to a mySAP Business Suite solution and then execute commands to access SAP data via supported interfaces. You can also create Reporting Services reports against a SAP server.

Microsoft Dynamics CRM 3.0 released on MSDN

Microsoft CRM 3.0 is available on MSDN Subscriber Downloads so certified partners and customers with MSDN Universal can download the RTM ISO images. More info about MS CRM is available on the Microsoft Business Solutions site

Installed Google Analytics on my blog

This evening Google announced Google Analytics, a free page tag-based measurement service. The goal of Google Analytics is to help online businesses gather the data they need to improve their site, marketing and product merchandising. After agreeing to the terms of use, you get a little javascript snippet that you can insert into the head tags of your html pages and then you have to wait ...

Waiting for data: jopx.blogspot.com
Analytics has been successfully installed and data is being gathered now. Your first reports will be ready within twelve hours. blog

PDC05 - All session recordings online

All the sessions from this year's Professional Developers Conference are hosted online - go to http://microsoft.sitestream.com/PDC05/

Team-Based Development of WSS and SPS Applications - My 2 cents

On MSDN there is an article about how to deal with SharePoint development environments, Team-Based Development of WSS and SPS Applications.

Some more suggestions for doing team based development:

Create a Virtual PC template with SharePoint, VS.Net and everything you need installed

Make copies of this Virtual PC template and rename the Windows 2003 Server hosted in your Virtual PC for every individual developer

Setup the Virtual PC to use a shared network connection and deploy your Visual SourceSafe database within your LAN

Use Visual Sourcesafe for everything you can imagine : webparts, site definitions, web services, setup projects, etc...

Use scripts and setup files to keep your development, test and production environment in sync

sharepoint

My blog is a spam blog - what the ...

Since Google upgraded Blogger on Saturday, I don't seem to be able to post anymore directly from w.bloggar. Why?

"Blogger's spam-prevention robots have detected that your blog has characteristics of a spam blog (or in short splog). (What's a spam blog?) ".

I guess I should take my blogging frequency down to avoid mistakes ;-).... More info about this here: Why are all my posts being set to drafts.

Update:
Your blog has been reviewed, verified, and whitelisted so that it will no longer appear as potential spam. If you sign out of Blogger and sign back in again, you should be able to post as normal. Thanks for your patience, and we apologize for any inconvenience this has caused.

blog

MCMS 2002 SP2a - It is there already

From Stefan Gossner: MCMS 2002 Service Pack 2 is now ready for download!

This is really nice - I just blogged about it on Saturday and it is there already - JOPX on SharePoint, MCMS, Office 2003 and SOA: Waiting for MCMS SP2.
Related articles:

906142 - How to obtain the latest Microsoft Content Management Server 2002 service pack

906145 - Content Management Server 2002 Service Pack 2 installation information

894691 - A list of the bugs that are fixed in Content Management Server 2002 Service Pack 2

Glitches with MCMS 2002 Service Pack 2

mscms

Blogger- How do I change the default order of my archive links?

Answer to the question above: http://help.blogger.com/default/bin/answer.py?answer=882&topic=41
blog

Clean install for Visual Studio 2005 RTM

From Chris Sells - Scraping old versions of VS05 off your system :

If you read the ReadMe.htm from the Visual Studio 2005 setup, you'll see a detailed list of up to 23 things to uninstall in the right order (plus 2 notes if you have trouble).

To solve this problem, Dan Fernandez posts about a VS05 uninstall tool that worked wonderfully for me.

Another round of SharePoint links

Using the WSS OM and Memory...

Deployment and Customization Best Practices for Windows SharePoint Services

Authenticating users with the Electronic ID (e-Id) in SharePoint

Conduct Team-Based Development of Windows SharePoint Services and SharePoint Portal Server Applications

Windows SharePoint Services: IntelliSense XML File

SharePoint Portal Server 2003: IntelliSense XML Files

Document Library Event Handler and WSS SP2: Cannot complete this action.

WebPart Components for VS 2005 RTM

Deleted items doclib (Todd Bleeker)

You receive an error message when you try to create a new document workspace in a SharePoint Portal Server 2003 area

Microsoft Office Web Parts and Components 2003 (Update:10/17/2005)

Visio IFilter

Programatically remove Manager information from Portal Profiles
sharepoint

Windows Workflow Foundation Beta 1.2 - VS.Net 2005 RTM compliant...

It seems that Microsoft released a new built of Windows Workflow Foundation ( abbreviated WF) - WF 1.2. Two important things mentionned on the download page:

This release is primarily a prerequisite for certain parts of Office 12 beta

WF Beta 1.2 uses .Net framework 2.0 RTM, ... (just what I was waiting for ...)

office12

Waiting for MCMS SP2.

Today I installed Visual Studio.Net 2005 RTM on my portable (It installed like a charm...). But because I also have MCMS 2002 (SP1a) installed on my machine I was wondering what would happen with my MCMS sites. Good news, so far everything seems to be working...

But I'm still waiting for MCMS SP2 so that I can finally use .Net 2.0 code in my MCMS pages and use SQL 2005 as well. For more about MCMS SP2 check out MCMS Service Pack 2 on MCMSFaq and also take a look at Stefan's blog
mcmsmscms

Mendocino - Link Office to SAP

I saw a very cool webcast last week about Mendocino (Recorded webcast available as well as the slide deck) . "Mendocino" is a code name for a joint development by Microsoft and SAP. Mendocino will link SAP functionality directly to Microsoft® Office applications. If you want to know more take a look at http://www.microsoft-sap.com/. A preview release will available by the end of the year and beta1 is planned for March 2006.

P.S. The slide deck also showed something called "SharePoint Report Center", I wonder what that is.

BIWUG - 3d Meeting 9th november

For those of you into Information Worker stuff and living in Belgium or the Netherlands - I can definitely recommend the monthly BIWUG meetings. In the first I talked about IW stuff at PDC (Presentation available here). In the second meeting we had demos of Groove and K2.Net. On the 9th of november we have another exciting meeting coming up:

Here is the agenda:

18.00 - 18.35 Registration + Meet the President
18:35 - 19:15 Presentation VSTO - BJ Holtgrewe – Senior Product Manager (Microsoft Corp.)
19.15 - 20.00 Presentation “Son of SmartPart” (aka SmartPart vNext) - Jan Tielens/Patrick Tisseghem
20.00 - 21:00 Round the Table
21.00 - ... Drink

More info
vstosharepoint

How much is your blog worth?

Business Opportunities weblog just created an applet which shows the worth of your blog based on Tristan's Louis research. Funny...

My blog is worth $22,017.06.
How much is your blog worth?

Bill created a summary for SharePoint blogs worth
sharepoint