Jan8

Searching Dynamics CRM from SharePoint using the BDC

 Categories:

Now you can easily search Microsoft Dynamics CRM for Office SharePoint Server.

The Enterprise Search Accelerator includes:

  • Documentation - Documents covering all aspects of the accelerator are included to help walk you through the process of getting started with Enterprise Search.
  • BDC XML Definition – Pre-configured Microsoft SharePoint Business Data Catalog (BDC) definition for many of the standard Microsoft Dynamics CRM entities.
  • BDC Tailor Utility – Utility to pull metadata from Microsoft Dynamics CRM and update a BDC XML definition file including modification using the localized language settings.

Video demo: http://mschnlnine.vo.llnwd.net/d1/ch9/0/5/1/2/4/4/CRMAcceleratorPart2_ch9.wmv

Download: http://www.codeplex.com/crmaccelerators/Release/ProjectReleases.aspx?ReleaseId=21449

 

 
 
Jan8

Having trouble documenting your SharePoint Content Types?

 Categories:

Try the beta of this great new tool from MetaVis Technologies http://www.metavistech.com/sharepoint

MetaVis Designer models SharePoint metadata and hierarchy in a graphical two-dimensional way providing an intuitive interface to design and maintain metadata structures. Users will be able to create, modify, document and share these models through extensive use of a rich graphical interface. MetaVis Designer is integrated with SharePoint allowing users to load, synchronize and provision metadata models into the application.

Here is a screen shot of one of my Content Type inheritance models...

 
 
Jan6

Dynamic MindManager Map Generated from SharePoint List Data

 Categories:

Using the Data View web part and the concept of an XML Data Island, I was able to get the Mindjet HTML Viewer control to render data directly from a SharePoint list.

See the demo here http://www.wssdemo.com/Pages/MindManager2.aspx (this will download the active viewer automatically).

The tricky part was grouping the list data to create the sub-topics. The XML format is very order specific and not well documented. I only have the evaluation copy of MindManager which doesn't have all the features.

 
 
Jan5

Thankfully I’m not a SharePoint Project Manager

 Categories:

But I often wish I had more influence on the way some projects are run.

Most organizations know there is lots of room for improvement in the way they manage and execute projects. Lots of emphasis is placed on Enterprise Project Management (EPM implies global resource and cost management plus reporting) but not much on how all the people involved in a project execute on the plan and deliver a good result.

Executing the plan is more than just updating task statuses and recording time. Most projects require people to share, track and collaborate on more than just a Gantt chart.

Handing around a project plan printout (schedule) during a project meeting just results in everyone commenting on how inaccurate it is and insisting that their updates to the plan be recorded by the PM.

Note: This project template is based on "A Guide to the Project Management Body of Knowledge" (PMBOK), Third Edition. Numbers in parenthesis (3.1.1.n) refer to the specific process numbering convention used by PMBOK. Additional details about the process can be found in the referenced section of the PMBOK Guide. This schedule shows activities in a standard start-to-finish dependency relationship. In reality, the processes overlap and the dependencies may need to change to reflect that. This template is intended to show the general flow of work in the PM Life Cycle.

One of the things I like to see in a project is visibility of the work streams. You can create a Visio WBS directly from MS Project by using this add-in http://www.microsoft.com/downloads/details.aspx?FamilyID=34c28a49-e14c-4a7d-8d49-90061fe08ab4&DisplayLang=en

 

You can then render the Visio WBS in a web part for all team members to see using this approach http://www.wssdemo.com/Pages/visio.aspx. If the project has a SharePoint site, each stream may have its own sub site with information rolled up to the parent site.

You can use OOTB SharePoint features to facilitate project management or use one of the server admin templates from Microsoft that includes some project features:

There are also a number of 3rd party solutions that provide custom SharePoint templates to help with project management. E.g.

http://www.brightwork.com/

http://www.corasworks.com/Products/rApplications/rPrograms.asp

http://www.epmlive.com/features_Templates.aspx

 
 
Jan3

Reporting on the performance of your SharePoint SQL Server

 Categories:

Or any other SQL server for that matter...

Another task I managed to complete within a day was to get SSRS installed on WSSDemo.com's SQL server (still running 2005, upgrading to 2008 will wait for another day).

There are a number of reports you can get from the SQL Server 2005 Performance Dashboard which is a free download from http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

After installing this package, additional reports are added to SQL Management Studio. You can also import these into Reporting Services. After importing them you have to reset the Data Source for each report before running the performance_dashboard_main report from which you can launch all the other more details reports.

Historical IO Report

         

Report Time: 1/2/2009 8:24:28 PM

             
                                 
                                         

The following table shows the number of IOs performed for each database since it was brought online (normally server startup) and how this compares to the total IO across all online databases.

       

Database Name

% Reads

Reads

Read Wait Time (ms)

Avg Read Wait (ms)

% Writes

Writes

Write Wait Time (ms)

Avg Write Wait (ms)

% Total IO

AdventureWorks

0.03%

26

270

10.4

0.00%

6

12

2.0

0.00%

AdventureWorksDW

0.03%

22

125

5.7

0.00%

6

12

2.0

0.00%

Ian

0.05%

35

273

7.8

0.00%

6

12

2.0

0.00%

master

0.12%

87

672

7.7

0.00%

105

256

2.4

0.01%

model

0.12%

88

735

8.4

0.00%

18

51

2.8

0.00%

MOSS_New_Content

0.07%

52

315

6.1

0.00%

6

11

1.8

0.00%

MOSS_Templates

7.25%

5394

53978

10.0

0.24%

6200

4494

0.7

0.44%

MOSS_Training

2.21%

1647

8525

5.2

0.11%

2912

1127

0.4

0.17%

mossdemo_Content

0.49%

365

1508

4.1

0.08%

2042

657

0.3

0.09%

msdb

0.25%

186

1718

9.2

7.93%

204445

130085

0.6

7.71%

MySite_Content

0.57%

427

2753

6.4

0.16%

4048

1131

0.3

0.17%

MySiteAccountManagerRole

0.10%

76

285

3.8

0.00%

6

3

0.5

0.00%

MySiteFinancialAnalystRole

0.09%

69

248

3.6

0.00%

6

3

0.5

0.00%

MySiteHRManagerRole

0.08%

56

210

3.8

0.00%

6

10

1.7

0.00%

ReportServer

0.04%

32

13

0.4

0.10%

2696

2584

1.0

0.10%

ReportServerTempDB

0.06%

44

25

0.6

0.03%

745

989

1.3

0.03%

SharePoint_AdminContent_a0e0098f-f4e2-43fb-9608-0f462fc357cf

1.10%

819

4351

5.3

0.00%

20

8

0.4

0.03%

SharePoint_Config

0.30%

225

2644

11.8

53.48%

1379153

709271

0.5

51.98%

 

File Name

% Reads

Reads

Read Wait Time (ms)

Avg Read Wait (ms)

% Writes

Writes

Write Wait Time (ms)

Avg Write Wait (ms)

% Total IO

 

SharePoint_Config

69.33%

156

2048

13.13

0.20%

2784

1651

0.593031609

0.21%

 

SharePoint_Config_log

30.67%

69

596

8.64

99.80%

1376369

707620

0.51412085

99.79%

SharePointTrainingKit

0.33%

248

1170

4.7

0.01%

339

231

0.7

0.02%

SSO

0.05%

35

139

4.0

0.00%

25

11

0.4

0.00%

SSP1_Content

0.37%

278

1587

5.7

0.07%

1910

496

0.3

0.08%

SSP1_DB

3.70%

2754

72989

26.5

16.04%

413664

517477

1.3

15.69%

SSP1_Search_DB

7.16%

5332

92981

17.4

15.86%

408991

6293620

15.4

15.61%

tempdb

56.72%

42216

56133

1.3

3.14%

80918

333505

4.1

4.64%

WSS_Search_MOSSAPP

1.06%

792

10732

13.6

2.42%

62502

46053

0.7

2.39%

WSSDemo_Content

17.63%

13120

155213

11.8

0.32%

8271

36427

4.4

0.81%

   

Grand Total

100%

74425

469592

6.3

100%

2579046

8078536

3.1

100%

 
 
Jan2

Conflicting Characteristics of Content Requirements in SharePoint

 Categories:

Most products that store content are designed to meet the requirements of a particular discipline; collaboration, document management or record management. The challenge with designing a SharePoint solution is that you might need to meet the requirements of more than one discipline.

This is a slide from the Tech Ready session on Information Architecture I was going to present in February (that session is now the victim of the current economic situation which means I won't be able to attend :-(

The idea for this originally came from a table I saw comparing document and record management requirements that was published back in the 90's but do you think I can find it again?

Because this was a PPT I kept the number of characteristics down to 5 but there are plenty more. Feel free to share your thoughts about this with a comment.

 
 
Jan1

Silverlight Slideshow of a SharePoint Picture Library

 Categories:

I decided that I should start and finish something for the first day of 2009. Fitting that it should be SharePoint project consisting of a Web Part that uses the Data View and Silverlight to turn the pictures in a picture library into a slide show.

http://www.wssdemo.com/SlideShow/show.aspx

99% of this is thanks to Frederik Hendriklaan and his SilverlightSlideShow project on CodePlex http://www.codeplex.com/silverlightslideshow which gets the list of images from an XML file. I used the Data View to format the picture library list data into an xml island in the format required by the existing Silverlight project.

I'll help the first person who comments on this post that wants to get it working on their own site. You just have to give me your picture library list GUID and I'll give you a .webpart file to import onto a page (no server code deployment required).

Happy New Year J

 
 
Dec27

Dealing with network shares and a SharePoint deployment

 Categories:

An important part of any introduction of SharePoint for better document collaboration/management as compared to a network share is to decide what documents to migrate.

The first question I always ask is "are you going to add any value to the documents by placing them into SharePoint?".

Bearing in mind that SharePoint storage is more expensive than a network share there has to be benefits for doing it. Just saying "we will be able to find it more easily by using SharePoint search" is not a valid reason because SharePoint can search the files in the network share.

So the documents that don't benefit from migration into SharePoint may still have to be kept on a network share. A simple strategy might be to mark the network share "Read Only" but there are often files that still need to be maintained in this location along with future files that are not suitable or supported in SharePoint such as MS Access databases or extremely large files such as CAD, TIFF images or video files. So what tools can be used to improve or extend the basic network share?

Most Architects and Administrators are unaware of the new features in Windows Server 2003 R2 and 2008. Most IT people seem to have learned the basics of Server 200 and assume that each version since then has just fixed bugs or changed the UI. One such feature is the File Server Resource Manager (FSRM) which ships with W2K3 R2 and W2K8.

Figure 1: File Server Resource Manager Administration snap-in

FSRM enables administrators to restrict the use and propagation of files on network shares. File screening rules apply to all users in a folder tree or volume. Exceptions limiting inheritance of screening policies can be configured.

  • Create file screens to control the types of files that users can save and to send notifications when users attempt to save blocked files.
  • Define file screening templates that can be easily applied to new volumes or folders and that can be used across an organization.
  • Create file screening exceptions that extend the flexibility of the file screening rules.

This is something the IT department would have to configure on the Network servers. http://technet.microsoft.com/en-us/library/cc772675.aspx

I can see File Screens also being useful for creating a Media Share which would restrict users to only be able to add valid audio/video media file types. Links to these files along with associated metadata can be added to a SharePoint list or publishing solution (such as

FSRM also provides a simple way to quickly identify, monitor, and fix inefficiencies in storage resource management. Administrators can configure specialized reports or request reports in predefined outputs, including by:

  • File size
  • Least recently used
  • Owner
  • Duplicates

These reports could be useful in the information audit process before migrating anything into SharePoint.

 
 
Dec27

Increase in SharePoint Certified Technology Specialists

 Categories:

Updated from 6 months ago http://www.wssdemo.com/Blog/archive/2008/06/12/there-are-not-enough-microsoft-sharepoint-certified-technology-specialists.aspx .

Qualification

Qty 12/06/08

Qty 26/12/08

MCP (all)

2,268,992

2,354,663