The scenario:

One of our current projects required that we had to create a SharePoint list item (task) when specific condition occurs in CRM - "Responsible person" is selected on opportunity level.

The solution:

1. Create web service on SharePoint Server

Often, you will have you SharePoint infrastructure reside on different server than CRM. Then, you cannot access the object model directly so you need to create a web serivice. Decide also on service authentication.

In our case - the web service creates an list item (task) in SharePoint, and fills it with the necessary properties.

2. Create custom workflow activity

2.1. Create sharepoint workflow activity library. Add CRM assemblies (from CRM SDK). Annotate class with appropriate attributes.

          [CrmWorkflowActivity("Crm
Workflow Activity", "SharePoint
Activity")] public partial class SharePointActivity:
SequenceActivity {    public SharePointActivity()
   {       InitializeComponent();    }
}
        

2.2. Register dependency properties, which will then be fed from CRM

          
            public
            static DependencyProperty
responsiblePersonProperty =
   DependencyProperty.Register("responsiblePerson", typeof(string), typeof(SharePointActivity));
[CrmInput("responsiblePerson")]
[CrmDefault(@"")] publicstring responsiblePerson
{    get    {       return (string)base.GetValue(responsiblePersonProperty);
   }    set    {       base.SetValue(responsiblePersonProperty,
value);    }

}
        

2.3. Call the SharePoint web service. For simplicity - no error handling & no security calling the service.

          
            protected
            override ActivityExecutionStatus
Execute(ActivityExecutionContext executionContext) {    SamsService
sams =new SamsService();
   sams.CreateTask(responsiblePerson);    return ActivityExecutionStatus.Closed;
}
        

3. Register the custom workflow activity in CRM and enable debugging

Registration is pretty straighforward with tools in CRM SDK (plugin registration). CRM workflows are run "assyncronously" by CRM Assyncronours Service - this means that in order to debug your custom workflow activites, you need to attach to this service, not to w3wp. Also,  your code is run with service's credentials  (network service by default), so you might experience security issues.

Remember also iisreset & restart assync service on every change

4. Create CRM workflow that uses the custom activity

The workflow is started automatically when opportunity is created. The workflow waits untill "Reponsible person" is not blank. Then the workllow executes our custom workflow activity for SharePoint integration, passing all the required properties.

You can pass data from opportunity level, or any related entites such as Primary Contact or Account to every custom activity's dependency property that has been marked with the CrmInput attribute.

Sincerely,
Rossen

This year Krasimir and I have delivered two presentations about SQL Server, here I provide some information and download links of the presentations. Krasimir Parushev is a fellow ex-colleague of mine, expert in SQL Server and Business Intelligence and a good friend.

1.Distributed and long running transactions (Jan 19, 2008)

Rossen and Krasimir will guide you through the advanced concepts of transactions – distributed transactions, 2 phase-commit protocol, transaction coordinators and resource managers, the concepts of long running transactions and WS-* specifications, and implementation in WCF, WF and support of distributed transactions via System.Transaction namespace in .NET 2.0.

Download the presentation:
http://www.abilitics.com/downloads/Abilitics_NASD_Distibututed_Transactions_Rossen_Krasi_2008.01.16.ppt

Event:
http://www.devbg.org/seminars/seminar-database-transactions-19-January-2008/

NASD (National Academy of Software Developers) is non-commercial organization which supports Bulgarian software community with educational initiatives, courses and seminars.

2. SQL Server Integration Services – Best Practices (Apr 17, 2008)

Rossen and Krasimir will share some best practices in working with Integration Services – Data cleaning, Data Transformation, Data profiling, Deployment  and configuration practices, Logging, Security, Custom code and high availability.

Download the presentation:
http://www.abilitics.com/downloads/Abilitics_BGSQLGROUP_SQLServerIntegrationServices_Rossen_Krasi_2008.04.17.pptx

Event:
http://www.bgsqlgroup.com
Bulgarian SQL & BI User group is the Bulgarian community of SQL Server experts who share their experience and best practices in working with SQL Server.

Sincerely,
Rossen Zhivkov

Recently, Teddy and I started an internal training preparation for MCTs (Microsoft Certified Trainers) at Abilitics. So far, the guys are doing great! Here is a quick list of some of the tips:

1. Feel Positive
You can’t fake it. You can’t pretend to be positive. It is much easier to actually feel positive and to actually like your audience. Then you will react positively at everything that happens in the course. The more your react positively, the more the students react positively and the better the course goes.

2. Deal with Anxiety & Nervousness!
Remember that the training is not about you. It is not about you showing how much you know, it not about your performance or your presentation skills.
It is about the audience. It is about how you can help them. What they will have learned at the end of the course. Keep in your mind that they deserve best training possible.
On another note – every trainer feels anxiety, even the most experienced ones. But only masters enjoy it and use it as their advantage (as transforming it in enthusiasm)!

3. Credibility
Know your stuff. If you are good, it will show out. If you are not, it will show.
Do use examples from projects that you have completed. Do give them real-life experience. That is how you will prove your credibility.
Don’t cite your certificates, experience, and your company profile, how great you are and how you know everything.

4. Have enthusiasm
Be enthusiastic about the technology or the subject matter that you are teaching. After all, if you, the expert, don’t seem to like the technology, why they should care about learning it? They shall feel that there is something wonderful that you going to teach them.

5. Make them your friends
Just act friendly. Smile! Laugh! Relax the atmosphere. Don't serve as authority. And don’t take the course too seriously.

Stay tuned for more tips soon.

Sincerely,
Rossen

We have recently completed a SharePoint Services 3.0 project for task management and business processes automation. It is a good habit to keep track of what issues appeared in the project, so that you can make better architecture decisions in the future.

Here is the quick “lessons learned” list:

1. Forms authentication
Create first a SharePoint web application with windows authentication, then extent the web application with forms authentication. Develop or purchase additional component for users’ registration with features like resetting passwords and emailing forgotten password.

Articles:
http://msdn.microsoft.com/en-us/library/bb975136.aspx
http://www.simple-talk.com/dotnet/windows-forms/configuring-forms-authentication-in-sharepoint-2007/
Free tool to manage users:
http://www.codeplex.com/fba/Wiki/View.aspx?title=basic%20FBA%20user%20and%20role%20management&referringTitle=Home

2. Office integration with SharePoint with Forms authentication
Not working by default as you might have guessed. These are the steps (in brief) how to configure it:

• Enable “client integration” In Central administration -> Application Management -> Authentication Providers for the selected zone
• When users sign in, they must check “remember me”. In that way, the authentication cookie is persisted and the rich clients can authenticate to SharePoint.
• SharePoint site must be in trusted sites, or in other internet explorer zone, which has Internet explorer Protected mode turned off. Protected mode being off enables other applications (such as Word, SharePoint designer), to use the authentication cookie
• The user must have appropriate access permissions to use rich client with SharePoint (check permission levels)

Article:
http://msdn.microsoft.com/en-us/library/bb977430.aspx

3. Alternate mappings for publishing SharePoint Services to Internet
Check your alternate access mappings or use load-balanced URL when extending the SharePoint site. Incorrect alternate access mappings cause login form to appear, but after logon, a 404 error is given. General rule of thumb - if functionality are working in intranet, but you have issues in internet, do check the alternate access mappings. Also, check windows firewall if you use custom ports. You need to open incoming requests on these ports.

Article:
http://blogs.msdn.com/sharepoint/archive/2007/03/06/what-every-sharepoint-administrator-needs-to-know-about-alternate-access-mappings-part-1.aspx (read part 1, 2 and 3)

4. Customizing Edit Pages
Customized edit pages enables you to rearrange fields, set some fields as read only, adding additional user controls on the web page, and more.
Abilitics free Edit Page redirector will be available soon. Edit page redirector “redirects” users to appropriate edit page, based on their group membership or based on field values. Stay tuned.

5. SharePoint designer workflows & Custom actions
Custom workflow activities enable you to add additional functionality to workflows that you develop with SharePoint designer.
Download free SharePoint designer activities: http://www.codeplex.com/SPDActivities. Giving permissions to users with forms authentication does not work. You have to modify the code of this tool.

Some SharePoint designer workflow issues & solutions:

Issue: Cannot select multiple users when selecting users (as in granting permissions activity)
Solution: The reason is because SharePoint designer user picker designer type does not allow you to select multiple users. The workaround is to save the multiple users in a dynamic string, and then feed the dynamic string to the activity.

Issue: After you edit workflow with SharePoint designer, SharePoint still runs the old workflow
Solution: it appears to be a bug of some kind. Our workaround is to copy the workflow and associate it with another library, delete it from the original location, and then return it back. A friend of mine with the same problem suggested to save the workflow locally, delete it from SharePoint (the action deletes all previous versions), and then upload it again.

Issue: SharePoint designer does not show latest version of a custom developed activity
Solution: Delete SharePoint cache from this location C:\Users\rossen.ABILITICS\AppData\Local\Microsoft\WebsiteCache (on Vista)

Issue: Access denied when custom SharePoint activity is run
Solution: By default, the workflow runs with the security account of the user who initiated the workflow. You need to run with elevated privileges with SPSecurity.RunWithElevatedPrivileges. Do remember to recreate new SPSite & SPWeb.

6. Modifying item when you have only read-only access
Imagine a vacation request business process. Once approved, you will have read-only access, because you should not be able to modify it. But you must be able to cancel your vacation request.
The solution: Create custom web part with single button (Cancel Vacation Request), put it on the DispForm. The web part will use elevation of privilege (SPSecurity.RunWithElevatedPrivilege) to modify the current item. DispForm is accessible when you have read-only access, but edit form is not.

7. Script Everything
If you repeat some action twice – script it!

• Script web part deployment, SharePoint designer custom activity deployment, features activation and deactivation
• Script application pool recycling and web site warming up (http://blogs.msdn.com/joelo/archive/2006/08/13/697044.aspx)
• Script backup and restore operations(and run backup as scheduled task, or backup the DB regularily)

Script user configuration:
Incorrectly set user accounts and group membership can ruin a perfectly fine SharePoint implementation. User configuration shall be automated and validated for errors. 

• The client provides user accounts, temporary password, emails, user profiles, group membership in excel file
• Custom application creates the users in the SQL Server AspNetSqlMembership provider database
• Custom application fills in and validates user profiles in SharePoint (missing properties, missing managers, incorrect email addresses)
• Stsadm script adds the users to the required security groups in SharePoint

Sincerely,
Rossen

Dear friend,

Welcome to my blog. I am the one in the right corner, couple of years younger … and probably wiser :). Brave visionary, determined to go on a hard, but fulfilling journey for creating success.
Here is a little information where I came from, where I am now and where I want to go!

The past
I have spent 3-4 years in one of the leading IT services company in Bulgaria, working on various projects for .NET, SharePoint and SQL Server. It has been a wild journey between project work, presales activities, consulting, trainings, presentations, team building events and everything.

Despite the fact that I enjoyed my work there and the strong friendships I built, I decided that it is time to move on. It is time for new beginning, it is time to make things the way I want them to be and the way I believe they should be.

The present
I found Abilitics, with lots of passion and belief that it will grow as one beautiful and healthy company.  So far things are going better than expected. Our clients believe and trust us, we respond with a quality work, dedication and great results.

The team is great, motivated and happy.  We have lots of fun and laugher, which is the way how we will make our way through the difficulties.  

I am happy that I managed to find the right people for all of the key roles necessary to deliver our services – we have the PM  & Business analysis girl, the developer guys, the infrastructure consultant and the QA.  Soon some of them will be blogging too. The dev guys are great professionals, though I am little jealous that they are getting better development experts than me. However, that is something that I expected and ready to give up for the sake of the company success.

The future
Unknown! Fortunately.

Stay with us, I am sure it will be a wild and very interesting ride.

I will share you our experience about various topics around architecture and development from our SharePoint and .NET projects, as well as Business Intelligence solutions and Data Mining.

I will give you some insights of our successful practices and the mistakes we made in Abilitics business, sales and the management.
Abilitics is launching lots of SharePoint-related products right now, some of them commercial, but some of them are free.  Stay tuned to see how we can make your life easier with delivering sharepoint projects. 

The end
Wish you all lots of good luck, interesting projects and a quality leisure time. Enjoy!

Sincerely,
Rossen Zhivkov
Founder and Solution Architect,
Abilitics Ltd.