November 2007 - Posts

Microsoft Popfly and SharePoint 2007

Some of you might remember Eben's introduction here at dotnet.org.za of Microsoft Popfly http://dotnet.org.za/eben/archive/2007/10/31/popfly-beta-for-everyone.aspx

It has become so popular that even a term Popflying (http://www.popfly.com/) has been coined :)

So no justice would be done if Popfly did not meet SharePoint 2007.

To see how it's done check out this post (http://blogs.msdn.com/sharepoint/archive/2007/05/25/sharepoint-and-popfly-integration-yes-really.aspx)   from Michael Gannotti (http://sharepoint.microsoft.com/blogs/mikeg) on the SharePoint MSDN blog site.

In his own words:

"With the ability to create rich mashups of information for display in a web page, Popfly presents a great opportunity for SharePoint users to create new exciting data presentations within SharePoint. When looking at possible synergies and points of integration between the two there are two primary areas of focus. These are; Popfly consumption and display of SharePoint driven content, as well as SharePoint consumption and display of Popfly delivered content. In this write-up I will walk you through both of these approaches with the hope that it will prepare you to begin creating your own dynamic renderings of Popfly coupled with SharePoint on the Internet."

Posted by Zlatan | with no comments

LINQ and SharePoint 2007 and Visual Studio 2008

 

This was one of the questions I got from couple of people and it concerns the matter of using LINQ to query objects in SharePoint 2007 such as Lists and Documents/Entries within.

Short answer is yes, that in fact is possible and you can find it here http://www.codeplex.com/LINQtoSharePoint

You can access the SP object model as well as the SP web services, but before you get excited, it doesn't replace CAML (Collaborative Application Markup Language) it actually uses it to talk to SharePoint.

Really cool thing is that it features Visual Studio 2008 integration for entity creation (a.k.a. SPML).

And today they've had an official v0.2.4.0 alpha release for .NET Framework 3.5 and Visual Studio 2008 RTM (release bulletin) so, if you're love you LINQ and you happen to be a SharePoint developer go check it out.

I will make a point of demonstrating this in one of my future presentations for SADeveloper.

P.S. Developing with SharePoint 2007 using Visual Studio 2008 is almost like a dream, now that RTM is out, you have no other excuse but to start living it.

Accessibility Kit for SharePoint - AKS

It seems like I haven't been blogging for ages, needless to say that I've been busy as hell for the past week, and need to make up some hours of sleep.

I've also been busy answering your emails (from some of you that read this blog) regarding SharePoint and some of those concepts/answers I'll be posting on this blog soon

Then yesterday I found out that long awaited Accessibility Kit for SharePoint has been released!!!

Now this is really awesome news as this should significantly speed up creation of quality ECM solutions with MOSS 2007, and for some of you that don't know what I'm talking about I'll quote the text from www.codeplex.com/aks (btw, this is where you can find it)

"The Accessibility Kit for SharePoint (AKS) provides templates, master pages, controls, and web parts along with technical documentation that enable designers and developers to advance the accessibility of Microsoft Office SharePoint Server (MOSS) 2007 and Windows SharePoint Services (WSS) 3.0 based web sites and applications for people with disabilities, especially those who are vision impaired.

Microsoft has hired HiSoftware to develop the AKS. The decision was made primarily based on HiSoftware's in-depth expertise and broad industry experience in providing tools and services for improving software accessibility to the point of compliance with key industry and goverment standards and beyond. The contractual Statement of Work calls for HiSoftware to deliver a kit that can significantly reduce the time, knowledge, and effort required to implement a SharePoint-based web site that conforms to the World Wide Web Consortium's (W3C) Web Content Accessibility Guidelines 1.0 Priority 1 and 2 checkpoints, which are collectively known as WCAG 1.0 AA. The AKS can also be used to address the exceptions that have been identified in the U.S. government's Section 508 of the Rehabilitation Act's Voluntary Product Accessibility Template or VPAT documents for MOSS 2007. While most of our customers find the improvements in accessibility (more info at Office Online) over previous versions of SharePoint to be adequate for their needs, a growing number has asked us to provide even more. The AKS is our near term response. Longer term, we plan to make significantly further improvements in accessibility in the next version of SharePoint, but we don't have any details to disclose at this time.

The AKS 1.0 is now available as a free download at http://aks.hisoftware.com/."

Posted by Zlatan | with no comments

SharePoint for Intranet

This is the second of my lectures which I held at the UCS conference with which, I must admit, I've had tons of fun (well I usually have a lot of fun doing lectures anyway).

I've touched on all concepts of Enterprise Content Management as they pertain to building intranet solutions with SharePoint Server 2007.

The core of it all being the Taxonomy, Standardisation, Enterprise Search Strategy, Provisioning, extensive concepts of Collaboration and Social Networking, and let's not forget the founding principles of Document and Records Management and the importance of it.

Here's the link to my presentation deck for this lecture:

(http://dotnet.org.za/blogs/zlatan/ECM304%20-%20Dzinic.zip)

Here's also links to the resources I mentioned:

Key Governance Considerations in a SharePoint Deployment (http://blogs.msdn.com/joelo/archive/2006/08/23/key-governance-considerations-in-a-sharepoint-deployment.aspx)

How to Create Intranet Chaos (http://blogs.msdn.com/joelo/archive/2006/12/30/how-to-create-intranet-chaos.aspx)

The Provisioning Demo from my presentation was done using the product described in this blog post: (http://dotnet.org.za/zlatan/archive/2007/11/10/provisioning-engines-for-sharepoint-2007.aspx)

Enabling and managing social networks (for business use) with Microsoft Office SharePoint Server 2007 (http://blogs.msdn.com/sharepoint/archive/2007/10/24/enabling-and-managing-social-networks-for-business-use-with-microsoft-office-sharepoint-server-2007.aspx)

Search in Microsoft Office SharePoint Server 2007: Customizing and Extending

This is a follow up on my first lecture from the Unified Communications and SharePoint Conference that happened last week in Johannesburg. As I promised to those of you that attended, you will find here the uploaded deck + source code from the demos.

Presentation deck:

http://dotnet.org.za/blogs/zlatan/SRC303%20Search%20in%20SharePoint%20-%20Dzinic.zip

Demo snippets:

http://dotnet.org.za/blogs/zlatan/OCS%20Conference%20Snippets.zip

Demo source code:

http://dotnet.org.za/blogs/zlatan/SearchWebPartExample.zip

http://dotnet.org.za/blogs/zlatan/SearchWebServiceWindowsApplicationExample.zip

Once again I stress that we're dealing with a very powerful offering from Microsoft, as opposed to the search component of its predecessor SPS2003, and there is no need for any third party, non Microsoft, solutions.

Enterprise search in MOSS 2007 requires proper planning and implementation.  Most important part is to structure your content to facilitate search:

  • Monitor usage of MOSS over time to ensure that users find what they are looking for quickly, with the minimal number of steps and "clicks", also to ensure that you have created an intuitive structure.
  • Assign appropriate coordinator(s) to maintain lists of values for global Site Columns and Content Types to ensure search consistency.
  • Ensure that users can find what they are looking for in their own terms. Leverage the thesaurus capability in MOSS to create substitution terms for commonly used word and phrase alternatives. For example, ensure that the thesaurus includes common abbreviations that are unique to your organization and substitution terms such as business process renewal = business process reengineering. Assign responsibility for maintaining thesaurus information for the MOSS search infrastructure.

Form taxonomy teams in your organisation (unless you already have them) if you're a large enterprise or assign that role to a smaller group of people if you're an SME, and customise your search to utilise it. Utilise Best Bets functionality to match relevant taxonomy terms to the relevant search results.

Links (as promised):

Evaluating and Customizing Search Relevance in SharePoint Server 2007 (http://msdn2.microsoft.com/en-us/library/bb499682.aspx)

TechNet Virtual Lab: Search Administration and Customization in Microsoft Office SharePoint Server 2007 (http://go.microsoft.com/?linkid=7098681) - (this Virtual demonstrates most of the concepts from the first demo)

Customizing the Enterprise Search User Interface (http://msdn2.microsoft.com/en-us/library/ms546434.aspx)

Example of XSL Transformation for MOSS 2007 Search with sample XSLT (https://blogs.pointbridge.com/Blogs/ayyapusetty_raja/Lists/Posts/Post.aspx?ID=5)

Hint: If you're bandwidth challenged (like the most of us in South Africa - thank you Telkom), upon registering, you can just download the lab manual and then work on your own vanilla search centre environment.

 Walkthrough: Creating a Custom Enterprise Search Web Part (http://msdn2.microsoft.com/en-us/library/ms551453.aspx)

Sample: Custom Enterprise Search Web Part Code (http://msdn2.microsoft.com/en-us/library/ms493601.aspx)

Enterprise Search Query Web Service Overview (http://msdn2.microsoft.com/en-us/library/ms543175.aspx)

How to: Create a Web Service Proxy Class for the Enterprise Search Query Web Service in Visual Studio 2005 (http://msdn2.microsoft.com/en-us/library/ms492099.aspx)

How to: Submit a Keyword Query to Enterprise Search from a Client Application (http://msdn2.microsoft.com/en-us/library/ms497054.aspx) (this entry on MSDN was incomplete and it would be quite confusing to the first time user, I've added a correction which you can find at the bottom of this MSDN article - under my nick on MSDN -> Machak)

Unified Communications & SharePoint Conference 2007

Once again I'm privileged to deliver two sessions at the upcoming:

Microsoft Unified Communications & SharePoint Conference 2007

(http://www.microsoft.com/southafrica/ucs/2007/default.mspx)

Which begins tomorrow......

My sessions will happen on Wednesday (Johannesburg, 14 November at Vodaworld) "The SharePoint day".

Looking forward to seeing any of you who are going to be there, my sessions are the following:

SRC303: Search in Microsoft Office SharePoint Server 2007: Customizing and Extending

Time: 11h50 - 12h50

ECM304: SharePoint for Intranet

Time: 13h40 - 14h40

Virtual TechEd 2007

 

You have got to check this dude out at Virtual TechEd (http://www.virtualteched.com/). Talking about"Developing OBA/SharePoint 2007 Solutions in South Africa" at the video section (http://www.virtualteched.com/pages/videos.aspx). He's classic!!

Also, if he was entertaining enough for you, you can even rate him.

Here's more info:

Click to Play
Developing OBA/SharePoint 2007 Solutions in South Africa
What role does SharePoint 2007 play in Office Business Applications and in organizations in general? Zlatan Dzinic, Principal Consultant at Business Connexion, explains to Lillian Serobatse, Product Marketing and   Audience Manager, how SharePoint 2007 forms part of the whole OBA concept and how to use SharePoint 2007 as a platform.

Watch Now

Silverlight

↓ Downloads:

Zune Download ZuneWMV Download WMVWMV Download WMV (High)
To save, right click and choose 'save target as…'.

Posted by Zlatan | with no comments

Very useful SharePoint 2007 (and WSS 3.0) Utilities from SharePoint Solutions Software

In my previous post I mentioned SharePoint Solutions Software (http://software.sharepointsolutions.com/). Really a great bunch, lead by Tony Bierman, MVP Windows SharePoint Services.

Here you can also find some really great free utilities that you might find useful:

Cross-Site Lookup Field

The Cross-Site Lookup Column provides users with a simple means for adding Cross-Site Lookup fields to any List within the same WSS v3 Site Collection.

Platforms: WSS v3.0, MOSS 2007

Product Download

More info

Link to Central Admin Feature

Link to central admin from Site Actions Menu.

Platforms: WSS v3.0, MOSS 2007

Product Download

More info

SPSolutions PowerShell Commands for SharePoint

Easily and automatically provision Sql Server forms-based authentication (FBA) sites in SharePoint

Platforms: WSS v3.0, MOSS 2007

Product Download

More Info

 

Posted by Zlatan | 1 comment(s)

Provisioning engines for SharePoint 2007

Since I've dealt with the implementation of my first ever Enterprise Content Management there has been a need for provisioning engines. In dealing with complex ECM systems with elaborate and complicated taxonomies with much room for error, people usually look to automate these processes where common logic and patterns can be found.

Initial deployment of an ECM solution is usually basic, and it either affects a small unit in a big way (answers all ECM needs of that organisational unit) or big unit in a small way (answers one small part of the entire organisation).

Automation/Provisioning ensures that the organic growth of your ECM solution does not lead into chaos. It improves accuracy, ensures adherence to standards, fast deployment and continuation of business. Above all it enforces standardisation in your organisation which is a key success factor whose importance exponentially grows.

Only one warning from my side when creating such provisioning engines -> They easily tend to go beyond reality in planning stages. So be careful to clamp down on what makes sense first, and do not make ANY assumptions during the process.

Right now I'm involved with a fairly complex implementation of SharePoint 2007 for a large corporate client (private sector), and one of the requirements is to allow non-technical users to create/extend the ECM solution consistent with the elaborate taxonomy pre-defined by the client's taxonomy team (that's right, they have a whole team of employees whose job is to define and enforce the taxonomy for the entire organisation, much like the components of our Government's Registry), also based on the some pre-defined setting that will determine the logic of workflows, design of webparts, lists etc.

Our custom provisioning solution is already under way, but if you need any help to get started you can look at this excellent solution from SharePoint Solutions Software (http://software.sharepointsolutions.com/).

The solution + trial license you can find here: (http://software.sharepointsolutions.com/products/Pages/SiteProvisioningAssistantforSharePoint2007.aspx)

Even better, check out these MSDN technical articles:

Creating a Custom User Site Provisioning Solution with SharePoint Server 2007 (Part 1 of 2)

(http://msdn2.microsoft.com/en-us/library/bb687711.aspx)

Creating a Custom User Site Provisioning Solution with SharePoint Server 2007 (Part 2 of 2)

(http://msdn2.microsoft.com/en-us/library/bb687710.aspx)

Upcoming Microsoft Training Events Nov/Dec 2007

If your company is a Microsoft Partner you can take advantage now by attending one of the following training events (100% subsidised by Microsoft):

Enterprise Search Training

(http://dotnet.org.za/blogs/zlatan/trainingnov2007/Enterprise%20Search%20Training%20%2020%20Nov%20JHB.zip)

Dates & Locations:

Bytes People Solutions:

Johannesburg 20 - 21 November 2007

Registration: 08:00 -08:30 Training: 08:30 -16:00

Format: Technical Workshop

Level: 300 - 400 Days: 3 Day

Target Audience: Technical Staff

------------------------------------------------------------------------

SharePoint 2007 Technical

(http://dotnet.org.za/blogs/zlatan/trainingnov2007/SharePoint%202007%20Technical%20-%20JHB%20,%20DBN,%20CPT.zip)

Dates & Locations:

28 - 30 November 2007 Durban, Bytes People Solutions

3 -5 December 2007 Cape Town, Bytes People Solutions

5 -7 December 2007 Johannesburg, Bytes People Solutions

Time: 08h30 - 09h00 Registration 09h00 - 17h30 Training

Target Audience: IT Professionals, Developers & Architects

------------------------------------------------------------------------

Unified Communications Technical Training

(http://dotnet.org.za/blogs/zlatan/trainingnov2007/UC%20technical%20training.zip)

Dates & Locations: Johannesburg, Bytes People Solution

26 - 30 November 2007

Registration: 08:30 -09:00

Training: 09h00 -17h00

Format: Hand On Lab

Days: 5 Days

Target Audience: IT Pro, Architects

------------------------------------------------------------------------

I'm personally not missing out on the SharePoint 2007 Technical in Cape Town

Posted by Zlatan | with no comments

Important SharePoint 2007 security updates (Microsoft Security Bulletin MS07-059)

These somehow went below my radar, most likely as they came up around TechEd 2007 in Sun City.

Here's the link (http://www.microsoft.com/technet/security/bulletin/ms07-059.mspx) + the rundown:

"This security update resolves a publicly reported vulnerability in Microsoft Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007. The vulnerability could allow an attacker to run arbitrary script that could result in elevation of privilege within the SharePoint site, as opposed to elevation of privilege within the workstation or server environment. The vulnerability could also allow an attacker to run arbitrary script to modify a user's cache, resulting in information disclosure at the workstation.

The security update is rated important for Microsoft SharePoint Services 3.0 in supported editions of Microsoft Windows Server 2003 and for supported editions of Microsoft Office SharePoint Server 2007.

The security update addresses the vulnerability by modifying the way that Microsoft Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007 validate URL-encoded requests."

If you're new to updates here's a really cool blog post from Shane Young that will explain step by step how to apply these updates (http://msmvps.com/blogs/shane/archive/2007/10/18/please-install-the-sharepoint-updates-on-your-server.aspx)

Before you start though bear in mind not the make the same mistake as Andrew Connell (http://www.andrewconnell.com/blog/archive/2007/10/20/Update-your-SharePoint-servers-with-KB934525-WSS-v3-and-KB937832.aspx).

There ya go.... Update Away!!

Posted by Zlatan | 1 comment(s)

Microsoft Office Client Deployment – Document Migration Tools

This is yet another lecture I did at TechEd 2007 and it addresses one of the most important aspects of deploying Office System 2007 and MOSS 2007 solutions in a large enterprise, and that is migration of all the earlier office version documents on your computer, file shares, network etc.

These are the tools that will make implementation of Office System 2007 (and SharePoint 2007) in your enterprise, above all a lot more possible to be used from day 1, also ideal, and effortless.

You want your whole enterprise to use Office System and SharePoint 2007, not just something that is being used by a few isolated departments, and where upon the upgrade your helpdesk won’t be swamped with calls such as “I can’t use my macros and my embedded components in my office files anymore, what did you do??”

It has a proper reporting component and issues analysis supported by Access 2007 (DB used is SQL 2005), yeah I know when you mention Access to most of the developer, including myself, it’s much like swearing at their mother, but this one is very useful, no really! Actually the whole new Access offering (2007) in general is actually pretty cool.

In order not to repeat myself, check out the presentation that you can download here: ( OFC307 MS Office Client Deployment Document Migration Tools.zip )

Since there’s no source code I’ve uploaded the videos of how to use these tools on freedrive.com and you can download and view them here (in the following sequence):

First

Second

Third

Fourth

Fifth

Sixth

It would be really great if we had a site with podcasting like abilities, I’ll work on it.