Archive for November, 2012

SharePoint 2010 FeatureDependencyId are not registered

November 23, 2012


When you run powershell on your server you get the following error:

The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.


Make sure the logged in user has rights to the SharePoint_Configuration database

    • SharePoint_Shell_Access
    • DB_owner (try reducing the privileges after you get it working in order to support “least privileges”

Create web site from Custom Template in SharePoint 2010 with powershell and STSADM commands

November 19, 2012

There are many questions about creating SharePoint 2010 Web from a custom  site template saved from UI – “Save site as template”. In previous SharePoint  versions, site was saved as STP file, installed with stsadm addtemplate  cmd, then we could find its ID with stsadm enumtemplates cmd,  and create the web once again with stsadm creatweb using the template  with that ID. But in SharePoint 2010 some of this command are  deprecated, like enumtemplates. Also site templates are not stored as STP files.  Instead we save the site template as Solution, WSP.

I tried to overcome this issue, but it is now possible only trough  PowerShell. Here are the steps:

  1. Open some site collection. Create sub Web. Add some test  Document   Library. Go in Site Settings and click “SubWebTemplate”. Give   site template a name (a propose to give “File Name” and “Template Name”   without special characters and blank spaces,  you can always give more   appropriate Description). Lets say we name it SubWebTemplate.   Now you can go to Solution Gallery and view the solution/template as Activated
  2. Test your SubWebTemplate, and create another sub Web   trough user interface in order to verify that created template is OK. If so,
  3. Execute SharePoint 2010 Management shell on the Server
  4. Now we have to enumerate site templates in order to find our custom   template ID. In my case, I created web template from a sub web   sub1 in the site collection   http://sps2010/sites/webtemplate. I named (saved) my template   as SubWebTemplate
    execute this script in PowerShell   to find its ID
    $url = “http://sps2010/sites/webtemplate”   $site= new-Object Microsoft.SharePoint.SPSite($url ) $loc=   [System.Int32]::Parse(1033) $templates= $site.GetWebTemplates($loc)   foreach ($child in $templates){    write-host $child.Name   ”  ” $child.Title} $site.Dispose()
    so at the end of   this script you can see custom template ID which differs from default ones   because it starts with GUID identifying solution ID (Web Templates in 2010 are   saved as WSP – Solutions) In my case it was   {E6BD7EFF-8336-4975-BA22-2256970781E2}#SubWebTemplate  
  5. Once again, you must use PowerShell to create Web, but you can not apply   this template on creation, because it is not one of the default farm   templates. I created sub web with url sub3 and do not applied template at this   moment $web = New-SPWeb http://sps2010/sites/webtemplate/sub3  
  6. Our web is created and we have it in PowerShell variable $web. Now we will   apply our custom template to the web   $web.ApplyWebTemplate(“{E6BD7EFF-8336-4975-BA22-2256970781E2}#SubWebTemplate”)

Now we can open our create web http://sps2010/sites/webtemplate/sub3 and  verify that it is created from the site template with the test Document  Library.

Also, once we know the site template ID we can use stsadm createweb cmd to create sub web from the  template: stsadm -o createweb -url  http://sps2010/sites/webtemplate/sub4 -sitetemplate  “{E6BD7EFF-8336-4975-BA22-2256970781E2}#SubWebTemplate”

Source: MK SharePoint UG

Microsoft RichCopy 4.0.217

November 11, 2012

One of the Microsoft tools that was being used by Microsoft programmers to copy or move files in faster speed. This tool was developed in 1996 but it was being used internally by Microsoft and was not made available for public usages. However, at a later stage they made it available for free public download and now you can also experience faster file copying and moving with this small Windows utility, called RichCopy. RichCopy can copy multiple files.
At a time with up to 8 times faster speed than the normal file copy and moving process. Surprisingly it copies and moves files even faster than RoboCopy tool and XCOPY command. Since the tool was being used by the developers, they made it pretty effective and stable .
download Microsoft Rich copy 4.0

Key Features of RichCopy
1. More powerful, faster and stable than than any other file copying tool. 2. Create several profiles to assign special settings with a specific profile. 3. Copy files from multiple and different locations and save in a single destination. 4. Filter the files based on the date, time and choose to either copy or opt those files. 5. Being on GUI, supports command lines. 6. Suspend and resume file copy at any time.

Reference :Technet Magazine

Universal Search for Microsoft Dynamics CRM 2011 (free)

November 9, 2012

By default, Microsoft Dynamics CRM users can search one record type at a time. If you’re looking for “Jones”, you would need to search within Accounts, then navigate to Contacts, search again, navigate to Leads, search again, etc. It works, but it’s painful!

To help solve this problem, Sonoma Partners offers our Universal Search app that offers many time-saving benefits, including:

– Users can search across multiple record types with one search
– Users can quickly access Universal Search anytime in the Microsoft Dynamics CRM application ribbon
– Sys admins can configure which records types to include in the search results (supports both system and custom entities)

Perhaps the best part about our Universal Search solution is that it’s completely FREE to use. If you’ve been looking for a good global search option, look no further!


Maps for CRM 2011

November 7, 2012

Maps for CRM 2011 provides Bing Maps integration with CRM Entities and GeoCoding. This integration service allows users to add address information currently to any Cases within their CRM solution, and display those on a Silverlight Bing Map via the CRM Dashboard. All integration via the Bing API is provided, however, users will be required to obtain their own API Key via the Bing website, free of cost.

Utilizing Silverlight and the CRM Dashboard Interface, users can visualize their Case load through a familiar user interface. Additionally, Cases are automatically color coded to match the case Priority.

Features List:

  • Silverlight Bing Map
  • Automatic Address GeoCoding
  • Color Coded Case Priorities
  • Map Item Click-Through

Download xRM Application

Project Management for CRM 2011

November 5, 2012

This application has been designed to allow end-users the ability to integrate Project Management with their existing CRM 2011 customizations. Track projects against your existing customer base without the overhead of a full-on project management server or EPM solution. Project Management for CRM 2011 is a low-footprint add-in to your CRM solution, and will provide immediate functionality to your CRM implementations.

Features of Project Management for Dynamics CRM 2011 include:

  • Track Projects against Accounts
  • Associate Projects with Responsible Contacts
  • Track Start Date vs. Completion Date
  • Customizable Project Type picklist
  • Auto-Calculation of Percent Complete (via custom CRM Plugins)
  • Associate Notes to xRM Projects
  • Track Resources via custom Connection Roles
  • 100% customizable solution (no managed interface / items)
  • Custom Project Dashboard to track Project details and progress

Download xRM Application

Membership Management for CRM 2011

November 3, 2012

Planet Technologies is releasing Membership Management for CRM 2011 as a free download to show off the capabilities of CRM for Association / Non-Profit Membership Management. This application is intended to be used by customers and partners to showcase the CRM product and provide a quick and easy to use approach to Membership Management. Key features include:

  • Candidate Management
  • Member and Company Management
  • Member Profiles (including Photos)
  • Membership Levels
  • Family Members

Download xRM Application

MS Dynamics CRM 2011 how to increasing the performance of Excel dynamic worksheets

November 1, 2012

Exporting Microsoft Dynamics CRM data to Excel can be a great way to enable quick and flexible reporting. Users can export data to Excel in a static and dynamic form to export either the data or the query to the data. When exporting Microsoft Dynamics CRM data to a dynamic worksheet, the worksheet contains a query that utilizes the FilteredViews in the CRM database. Running queries on the FilteredViews in an organization with a high volume of users will dramatically impact the performance of the FilteredViews. This degradation in performance is a result of the fact that FilteredViews use a SQL scalar function (fn_FindUserGuid) that retrieves users’ ID based on username.

The query used by the function is:

select @userGuid = s.SystemUserId

from SystemUserBase s
where s.DomainName = SUSER_SNAME()

A quick and easy way to enhance query performance is to add indexes to the CRM database. Index maintenance is the preferred way in CRM to performance tune the CRM database. To increase the performance of the scalar function that is used by the Excel dynamic worksheets exported from CRM, create an index on the ‘DomainName’ column using the following statement (be sure to replace ‘YourOrgName’ with the unique name of your CRM organization):


[YourOrgName_MSCRM].[dbo].[SystemUserBase] ( [DomainName] ) ;