ekoncis blog

Set up permission level to run JQUERY from webpart

2014-02-05T17:19:00.001+02:00

If you plan to use webpart with Jquery u have to use Contribute permissions. If less privileged permissions are used, no information will be displayed.

I discovered that there is no need for whole Contribute permissions level. There is one permission responsible for this - Update Personal Web Parts - Update Web Parts to display personalized information.

So we can create new permission level (make a copy of Read level) and add this permission.

Query CRM 2011 data with JSON synchronously

2013-03-25T15:05:00.001+02:00

After we installed CRM update rollup 12 (KB 2795627), we encountered very big problems with our customizations relating to SOAP queries that were across multiple entities. CRM rollup 12 (finally) introduces us with additional browser compatibility for Firefox, Chrome, and Safari.

After rollup our customizations that were using SOAP requests didn't work anymore on Chrome, Firefox and Internet Explorer 10. We discovered that SOAP requests uses ActiveXobject and this is not supported!!!

To rebuild our customizations we used synchronous JSON queries, that solved our problems and even made our crm customizations better and whole scripting technique lighter.

This excellent article Read records synchronously using JSON in CRM 2011 helped us to build our JSON queries like this:

Example function for retrieving current user full name

function getUserFullName() {

var userid = Xrm.Page.context.getUserId();

var retrieveRecordsReq = new XMLHttpRequest();
var ODataPath = "/xrmservices/2011/OrganizationData.svc/SystemUserSet?$select=FullName&$filter=SystemUserId eq guid'" + userid + "'";
retrieveRecordsReq.open('GET', ODataPath, false);
retrieveRecordsReq.setRequestHeader("Accept", "application/json");
retrieveRecordsReq.setRequestHeader("Content-Type", "application/json; charset=utf-8");
retrieveRecordsReq.send(null);

var records = JSON.parse(retrieveRecordsReq.responseText).d;
var FullName = records.results[0].FullName;
return FullName;

}

An internal database error occurred in the Business Data Connectivity Shared service (BDC)

2012-12-03T13:08:00.000+02:00

Firstly i want to say that i run across on this error not quite (as i thought) relating to BDC.. but:

My initial goal was simple - create some custom list in SP2010 with Lookup (information already on this site) fields. When i tried to do that i got following message:

So.. BDC service is related with creating Lookup type fields in SharePoint. Time ago we moved our SharePoint databases to new SQL server, but we didn't move our BDC db.. so i started to realize where is the problem. I have to create new BDC service application with new db in our new sql server + delete old BDC application (relationships), point my web application to new BDC service application.

I looked in SP Central Adminstration page for Service Applications (Application management -> Manage Service Applications).

1. Deleted old BDC application.
2. Created new BDC.
3. Point web application to new BDC (Application management -> Service Applications -> Service Application Associations)
4. IISRESET

But unfortuneatlly when i tried to create Lookup field i got new error saying:
Entity (External Content Type) cannot be found with Namespace = '', Name = 'New external content Type'

Solution:

Previously i had some (With old BDC application) External Lists with custom external content types in them, so when we are creating Lookup fields, SharePoitn is looking for those content types and they didn't exist any more, so i DELETED THOSE OLD EXTERNAL LISTS.

This item is no longer available. It may have been deleted by another user

2012-10-12T16:05:00.001+03:00

There are many articles about this SharePoint error message: "This item is no longer available. It may have been deleted by another user"

Mike Smith's Tech Training Notes and
http://girishm.blog.com/2010/07/11/this-item-is-no-longer-available-it-may-have-been-deleted-by-another-user-click-ok-to-refresh-the-page/

These solutions didn't work for me!
IN MY CASE I SIMPLY DELETE INTERNET TEMPORARY FILES & COOKIES!!!

SCSM Creating Manual Activity for Incident in C#

2012-08-30T11:06:00.001+03:00

Some time ago I had to develope application that could connect two systems: Microsoft Dynamics CRM & SCSM (Microsoft System Center Service Manager). The main purpose of this application is to synchronize data between two applications.

In this article i will show you only some little part (but maybe one of the toughest for me...) of my application code.
I will continue to post some other usefull parts from this project.

The code consists of 3 main steps:

1. Create relationship between incident & manual activity
2. Create manual activity
3. Assign created activity to incident

There is good post about creating incident in SCSM which really helped me out: http://blogs.technet.com/b/servicemanager/archive/2009/08/09/the-system-center-platform-in-service-manager-part-3-the-data-access-service-try-it.aspx

//Create relationship between incident & manual acticvity
ManagementPackRelationship workItemContainsActivityRelationship =
mg.EntityTypes.GetRelationshipClass(new Guid("2DA498BE-0485-B2B2-D520-6EBD1698E61B"));

CreatableEnterpriseManagementRelationshipObject AssignedToIncident =
new CreatableEnterpriseManagementRelationshipObject(mg, workItemContainsActivityRelationship);

//Create Manual Activity
CreatableEnterpriseManagementObject activityItemObject =
new CreatableEnterpriseManagementObject(mg, classManualActivity);
Guid newActivityGuid = Guid.NewGuid();

activityItemObject[classManualActivity, "Id"].Value = newActivityGuid.ToString();
activityItemObject[classManualActivity, "Title"].Value = "<Title>";
activityItemObject[classManualActivity, "Description"].Value = "<Description>";

EnterpriseManagementObjectGenericCriteria genericCr =
new EnterpriseManagementObjectGenericCriteria("Id == '" + <SCSM Incident Id>.ToString() + "'");
IObjectReader<EnterpriseManagementObject> reader = mg.EntityObjects.GetObjectReader<EnterpriseManagementObject>(genericCr, ObjectQueryOptions.Default);

if (reader != null && reader.Count > 0) {

foreach (EnterpriseManagementObject obj in reader) {

AssignedToIncident.SetSource(obj);

AssignedToIncident.SetTarget(activityItemObject);

IncrementalDiscoveryData dd = new IncrementalDiscoveryData();

dd.Add(activityItemObject);

dd.Add(AssignedToIncident);

dd.Overwrite(mg);

//Assign Manual Activity to Incident

AssignedToIncident.Commit();

}

How to get all SharePoint Users with web services in c#

2012-08-23T16:29:00.001+03:00

SPservice.UserGroup usergroup = new SPservice.UserGroup();
usergroup.Credentials = System.Net.CredentialCache.DefaultCredentials;

XmlNode allusers = usergroup.GetAllUserCollectionFromWeb();

foreach (XmlNode child in allusers.ChildNodes) {
foreach (XmlNode item in child) {
foreach (XmlAttribute atr in item.Attributes) {
if (atr.Name.ToString() == "LoginName") {
MessageBox.Show(atr.OuterXml);
}
}
}
}

SPservice - name of web reference in your visual studio project with URL:
http://<your server name>/_vti_bin/usergroup.asmx

CRM 4 how to retrieve custom attribute value in C#

2012-07-27T10:09:00.016+03:00

DynamicEntity someEntity;

TargetRetrieveDynamic retrieveTarget = new TargetRetrieveDynamic();

retrieveTarget.EntityId = <id of entity>;

retrieveTarget.EntityName = EntityName.<entity name>.ToString();

RetrieveRequest retrieveRequest = new RetrieveRequest();

retrieveRequest.ColumnSet = new ColumnSet(new string[] { "your_custom_attribute" });

retrieveRequest.ReturnDynamicEntities = true;

retrieveRequest.Target = retrieveTarget;

RetrieveResponse retrieveResponse = (RetrieveResponse)service.Execute(retrieveRequest);

someEntity = retrieveResponse.BusinessEntity as DynamicEntity;

String result = (String)someEntity["your_custom_attribute"];

String value = result.Value.ToString();

CRM 4 Workflow error message details

2012-07-27T09:25:00.002+03:00

In CRM 4 to get more info from workflow error than "An error has occurred" run this command against CRM database:

select Message from AsyncOperationBase
order by CreatedOn desc

CRM 2011 Create a new Case (incident) using C#

2012-01-05T14:08:00.000+02:00

using System;
using System.ServiceModel;
using System.ServiceModel.Description;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Client;
using Microsoft.Xrm.Sdk.Query;
using Microsoft.Xrm.Sdk.Discovery;
using System.Runtime.Serialization;
namespace CreateIncident
{
    class Program
    {
        static void Main (string[] args)
        {
            try
            {

ClientCredentials credentials = new ClientCredentials();
credentials.Windows.ClientCredential = new System.Net.NetworkCredential

("username", "passw", "domain");

Uri organizationUri = new Uri("http://crmservername:port/orgname/XRMServices/2011/Organization.svc");

Uri homeRealmUri = null;

OrganizationServiceProxy orgService = new OrganizationServiceProxy(organizationUri, homeRealmUri, credentials, null);

IOrganizationService _service = (IOrganizationService)orgService;

Entity incident = new Entity();

incident.LogicalName = "incident";

incident["title"] = "Case subject..";

// Set customerid with some existing contact guid

Guid customerid = new Guid("{xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}");

// Set customerid as contact to field "customerid"

EntityReference CustomerId = new EntityReference("contact", customerid);

incident["customerid"] = CustomerId;

// Set contactid with some existing contact guid

Guid contactid = new Guid("{xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}");

// Set contactid as contact to field "casecontactid"

EntityReference primaryContactId = new EntityReference("contact", contactid);

incident["casecontactid"] = primaryContactId;

_service.Create(incident);

            }
            catch (Exception e)
            {
                Console.Write(e.ToString());
            }
        }
    }
}

CRM 2011 Custom Email with Pdf report attachment

2012-01-02T13:17:00.000+02:00

After migration from CRM 4 to CRM 2011 my plugin written for custom email with PDF report won't work anymore so i rebuild my previous solution from CRM 4 with necessary changes for new CRM 2011:

using System;
using System.Activities;
using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Workflow;
using Microsoft.Xrm.Sdk.Messages;
using Microsoft.Crm.Sdk.Messages;
using SendReport.ReportService;
using Microsoft.Crm.Sdk;
using Microsoft.Xrm.Sdk.Query;

namespace SendReport
{
    public class SendReport : CodeActivity
    {

        protected override void Execute(CodeActivityContext executionContext)
        {
            try
            {

                IWorkflowContext context = executionContext.GetExtension<IWorkflowContext>();
                IOrganizationServiceFactory serviceFactory = executionContext.GetExtension<IOrganizationServiceFactory>();
                IOrganizationService service = serviceFactory.CreateOrganizationService(context.UserId);

                Guid incidentId = context.PrimaryEntityId;

                byte[] result = null;

                ReportService.ReportExecutionService rs = new ReportExecutionService();
                rs.Credentials = new System.Net.NetworkCredential("username", "password", "domain");
                rs.Url = "http://crmserver/ReportServer/ReportExecution2005.asmx";

                string reportPath = "/Reports/reportname";
                string format = "PDF";
                string historyID = null;
                string devInfo = @"<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";

                ParameterValue[] parameters = new ParameterValue[1];
                parameters[0] = new ParameterValue();
                parameters[0].Name = "incidentid";
                parameters[0].Value = incidentId.ToString();

                DataSourceCredentials[] credentials = null;
                string showHideToggle = null;
                string encoding;
                string mimeType;
                string extension;
                Warning[] warnings = null;
                ParameterValue[] reportHistoryParameters = null;
                string[] streamIDs = null;

                ExecutionInfo execInfo = new ExecutionInfo();
                ExecutionHeader execHeader = new ExecutionHeader();
                rs.ExecutionHeaderValue = execHeader;
                execInfo = rs.LoadReport(reportPath, historyID);
                rs.SetExecutionParameters(parameters, "en-us");
                String SessionId = rs.ExecutionHeaderValue.ExecutionID;

                try
                {
                result = rs.Render(format, devInfo, out extension, out encoding, out mimeType, out warnings, out
                streamIDs);
                }

                catch (Exception err)
                {
                    throw new Exception(err.Message.ToString());
                }

                Entity email = new Entity();
                email.LogicalName = "email";

                EntityReference regardingObject = new EntityReference("incident", incidentId);
                email.Attributes.Add("regardingobjectid", regardingObject);

                Guid senderUserId = Sender.Get<EntityReference>(executionContext).Id;
                Guid recieverUserId = Recipient.Get<EntityReference>(executionContext).Id;
                Guid recieverCCUserId = RecipientCC.Get<EntityReference>(executionContext).Id;

                EntityReference from = new EntityReference("systemuser", senderUserId);
                EntityReference to = new EntityReference("contact", recieverUserId);
                EntityReference cc = new EntityReference("contact", recieverCCUserId);

                Entity fromParty = new Entity("activityparty");
                fromParty.Attributes.Add("partyid", from);

                Entity toParty = new Entity("activityparty");
                toParty.Attributes.Add("partyid", to);

                Entity ccParty = new Entity("activityparty");
                ccParty.Attributes.Add("partyid", cc);

                EntityCollection collFromParty = new EntityCollection();
                collFromParty.EntityName = "systemuser";
                collFromParty.Entities.Add(fromParty);

                EntityCollection collToParty = new EntityCollection();
                collToParty.EntityName = "systemuser";
                collToParty.Entities.Add(toParty);

                EntityCollection collccParty = new EntityCollection();
                collccParty.EntityName = "systemuser";
                collccParty.Entities.Add(ccParty);

                var entity = service.Retrieve("incident", incidentId, new ColumnSet(new[] { "ticketnumber", "customerid", "title"}));
                var ticket = entity.GetAttributeValue<string>("ticketnumber");
                var customer = entity.GetAttributeValue<EntityReference>("customerid");
                var customername = customer.Name;
                var title = entity.GetAttributeValue<string>("title");

                email.Attributes.Add("from", collFromParty);
                email.Attributes.Add("to", collToParty);
                email.Attributes.Add("cc", collccParty);

                email.Attributes.Add("subject", "Here goes subject message.. : " + ticket);

                email.Attributes.Add("description", "Here goes description text..");

                Guid emailID = service.Create(email);

                // Attaching Pdf report
                CrmNumber crmNextActorID = new CrmNumber();

                RetrieveEntityRequest request = new RetrieveEntityRequest();
                request.LogicalName = "email";

                RetrieveEntityResponse response = (RetrieveEntityResponse)service.Execute(request);
                int objecttypecode = response.EntityMetadata.ObjectTypeCode.Value;

                Entity attachment = new Entity("activitymimeattachment");

                attachment.Attributes.Add("subject", "Report");
                attachment.Attributes.Add("filename", "Report.pdf");
                attachment.Attributes.Add("body", Convert.ToBase64String(result));
                attachment.Attributes.Add("filesize", new CrmNumber(Convert.ToInt32(result.Length.ToString())));
                attachment.Attributes.Add("mimetype", "text/plain");
                attachment.Attributes.Add("attachmentnumber", crmNextActorID.Value);

                attachment.Attributes.Add("objectid", new EntityReference("email", new Guid(email.Id.ToString())));
                attachment.Attributes.Add("objecttypecode", objecttypecode);

                service.Create(attachment);

                SendEmailRequest reqSendEmail = new SendEmailRequest();
                reqSendEmail.EmailId = emailID;
                reqSendEmail.TrackingToken = "";
                reqSendEmail.IssueSend = true;

                SendEmailResponse res = (SendEmailResponse)service.Execute(reqSendEmail);

            }

            catch (Exception err)
            {
                throw new Exception(err.ToString());
            }

        }

        [RequiredArgument]
        [Input("Sender input")]
        [ReferenceTarget("systemuser")]
        public InArgument<EntityReference> Sender { get; set; }

        [RequiredArgument]
        [Input("Recipient input")]
        [ReferenceTarget("contact")]
        public InArgument<EntityReference> Recipient { get; set; }

        [RequiredArgument]
        [Input("RecipientCC input")]
        [ReferenceTarget("contact")]
        public InArgument<EntityReference> RecipientCC { get; set; }

    }
}

CRM 4.0 migration to CRM 2011

2011-10-19T12:06:00.000+03:00

Backup CRM 4.0 SQL Server database

1. Open SQL Studio Manager
2. Connect to CRM 4.0 database
3. Expand Databases
4. Right-click on xxxxxx_MSCRM database, Tasks -> Back Up
5. Back Up to Disk (dbname.bak)

Restore CRM 4.0 database in CRM 2011 SQL Server

1. Open SQL Studio Manager
2. Connect to CRM 2011 database
3. Right-click on Databases, Restore Database
4. To Database - type in new crm database name, From Disk - select backup you created (dbname.bak) from CRM 4.0 SQL Server

Import new database with CRM 2011 Deployment Manager

1. Run CRM 2011 Deployment Manager (Start->All Programs->Microsoft Dynamics CRM->Deployment Manager)
2. Organizations -> Import Organization
3. Select database you restored in CRM 2011 SQL Server
4. Type in Display name and Unique Database Name (of your choice)
5. Type in CRM 2011 Report Server URL
6. Select "Automatically Map Users" (if you are in the same domain)
7. If some user doesn't exist in new CRM 2011 you can create them in Active Directory and then map them or just ignore this and go further.
8. System checks all prerequisites for Import.
9. *.If there are no errors you can click Import (Import can take up to some hours, depending on your db size and customizations etc).

*. If you see warning "Fragmented indexes were detected in the Microsoft Dynamics CRM database", you can ignore this message and go further but i would suggest you to do following as it greatly can impact the overall import process time: This error message says that there are fragmented indexes. To rebuild these indexes you can use this link:

http://crrm.ru/articles/2011/05/index-optimization-before-in-place-upgrade-to-crm-2011 (In Russian)

1. Download all 3 files from this link above (IndexOptimize.sql, CommandExecute.sql, DatabaseSelect.sql)
2. Open them via SQL Studio Manager and execute them: At very begining of each script add these two lines to select your CRM 4.0 database for creating these stored procedures -

   USE <xxxxx_MSCRM>
   GO

3. And finally run this script to rebuild indexes:

   EXECUTE dbo.IndexOptimize @Databases = 'orgname_MSCRM',
    @FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
    @FragmentationMedium = 'INDEX_REORGANIZE',
    @FragmentationLow = NULL

4. And then proceed with Import.

Sharepoint 2010 Server install Step By Step

2011-07-25T16:24:00.000+03:00

In my previous post Sharepoint 2010 Foundation Install Step By Step we went through the steps to install SharePoint 2010 Foundation, so this time we will go through SharePoint Server 2010 installation process.

there is practically no difference between SPF 2010 & SPS2010 installation, except of some new error messages :)

So here we go

1. Run setup

2. Install prerequisites

Again the same error about Hotfix KB976462 and the same solution from SPF 2010 install

3. After installing hotfix run again "Install prerequisites"

4. Install SharePoint Server

5. Enter Product Key

6. Choose Server Farm -> Complete

7. Run Configuration Wizard

8. Create New Server Farm

9. Enter credentials for domain user who will access sharepoint db and sqlservername\instance

10. Next we have to enter "passphrase"

11. Specify port number & authentification

12. And at this point we have new error message saying "Create database permission denied in database 'master'"

Solution:

User who is running sharepoint setup must have 'db_creator' permissions set on sharepoint db

13. After adding correct permissions run again Configuration Wizard and go through all steps from step 7.

14. That's all, done.

P.S When I tried to create new web appication from SharePoint Administration page, "New" button and other buttons were greyed out.  

Solution:

Run Internet Explorer as Administrator ;) 

CRM email with pdf report attachment

2011-07-07T12:25:00.002+03:00

1.step: In Visual Studio creating new WORKFLOW ACTIVITY LIBRARY

2.step: Add references Microsoft.Crm.Sdk, Microsoft.Crm.SdkTypeProxy;

3.step: Add web reference http://<reportservername>/ReportServer/ReportExecution2005.asmx

4.step: Debug this code

5.step: Run Plugin Registration Tool and register new assembly (that will be dll created from this source in path where this project will be created in bin folder)

6.step: Create new Workflow in crm with this custom workflow activity as new step

And here goes full code:

using System;

using System.Collections.Generic;

using System.Text;

using Microsoft.Crm.Workflow;

using System.Workflow.Activities;

using System.Workflow.ComponentModel;

using Microsoft.Crm.Sdk;

using Microsoft.Crm.SdkTypeProxy;

using Microsoft.Crm.SdkTypeProxy.Metadata;

using Microsoft.Crm.Sdk.Metadata;

using SendingReport;

using System.IO;

using System.Web.Services.Protocols;

using Microsoft.Crm.Sdk.Query;

using CustomEmail.ReportService;

namespace SendingReport

{

    [CrmWorkflowActivity("Send PDF Report")] // Name of custom workflow activity

    public class SendReport : SequenceActivity

    {

        protected override ActivityExecutionStatus Execute(ActivityExecutionContext executionContext)

        {

            IContextService contextService = (IContextService)executionContext.GetService(typeof(IContextService));

            IWorkflowContext context = contextService.Context;

            ICrmService service = context.CreateCrmService();

            Guid incidentId = context.PrimaryEntityId; // Get Id of current entity on which workflow will run

            byte[] result = null;

            // API Reporting Service

            CustomEmail.ReportService.ReportExecutionService rs = new ReportExecutionService();

            //rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

            rs.Credentials = new System.Net.NetworkCredential("username", "password", "domain");

            rs.Url = "http://crmservername/ReportServer/ReportExecution2005.asmx";

            // Setting Report Parameters

            // 1. Report path from report server

            // 2. Output format

            // 3. Device Info

            string reportPath = "/path/reportname"; //example (/myreports/jobreport)

            string format = "PDF";

            string historyID = null;

            string devInfo = @"<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";

            // Passing parameters to report

            ParameterValue[] parameters = new ParameterValue[1]; // Define parameters

            parameters[0] = new ParameterValue();

            parameters[0].Name = "incidentid"; // incident GUID

            parameters[0].Value = incidentId.ToString();

            // Security settings

            DataSourceCredentials[] credentials = null;

            string showHideToggle = null;

            string encoding;

            string mimeType;

            string extension;

            Warning[] warnings = null;

            ParameterValue[] reportHistoryParameters = null;

            string[] streamIDs = null;

            ExecutionInfo execInfo = new ExecutionInfo();

            ExecutionHeader execHeader = new ExecutionHeader();

            rs.ExecutionHeaderValue = execHeader;

            execInfo = rs.LoadReport(reportPath, historyID);

            rs.SetExecutionParameters(parameters, "en-us");

            String SessionId = rs.ExecutionHeaderValue.ExecutionID;

            try

            {

                // Generating report

                result = rs.Render(format, devInfo, out extension, out encoding, out mimeType, out warnings, out 

            streamIDs);

            }

            catch (SoapException err)

            {

                throw new Exception(err.Detail.OuterXml);

            }

            //Creating email

            email mail = new email();

            activityparty mailfrom = new activityparty();

            mailfrom.partyid = new Lookup();

            mailfrom.partyid.type = EntityName.systemuser.ToString();

            mailfrom.partyid.Value = Sender.Value;

            mail.from = new activityparty[] { mailfrom };

            activityparty mailto = new activityparty();

            mailto.partyid = new Lookup();

            mailto.partyid.type = EntityName.contact.ToString();

            mailto.partyid.Value = MailRecipient.Value;

            mail.to = new activityparty[] { mailto };

            activityparty mailcc = new activityparty();

            mailcc.partyid = new Lookup();

            mailcc.partyid.type = EntityName.contact.ToString();

            mailcc.partyid.Value = MailRecipientCC.Value;

            mail.cc = new activityparty[] { mailcc };

            //Get attributes from current entity

            incident ret = (incident)service.Retrieve(EntityName.incident.ToString(), incidentId, new AllColumns());

            mail.subject = "Job report";

            mail.sender = "example@someone.com";

            mail.description = "Here goes mail body description for: " + ret.ticketnumber.ToString();            

            mail.ownerid = new Owner();

            mail.ownerid.type = EntityName.systemuser.ToString();

            mail.ownerid.Value = context.UserId;

            Guid createdEmailGuid = service.Create(mail);

            // Attaching Pdf report

            activitymimeattachment setupEmailAttachment = new activitymimeattachment();

            setupEmailAttachment.subject = "Attachment subject";

            setupEmailAttachment.filename = "Reportname.pdf";

            setupEmailAttachment.body = Convert.ToBase64String(result);

            setupEmailAttachment.filesize = new CrmNumber(Convert.ToInt32(result.Length.ToString()));

            setupEmailAttachment.mimetype = "text/plain";

            setupEmailAttachment.attachmentnumber = new CrmNumber();

            setupEmailAttachment.attachmentnumber.Value = 1;

            setupEmailAttachment.activityid = new Lookup();

            setupEmailAttachment.activityid.type = EntityName.email.ToString();

            setupEmailAttachment.activityid.Value = createdEmailGuid;

            service.Create(setupEmailAttachment);

        // Sending email with attachment

            SendEmailRequest sendrequest = new SendEmailRequest();

            sendrequest.EmailId = createdEmailGuid;

            sendrequest.TrackingToken = "";

            sendrequest.IssueSend = true;

            service.Execute(sendrequest);

            return ActivityExecutionStatus.Closed;

        }

    // Define lookup fields [from, to, cc], these you will use when setting parameters in CRM for this workflow    

        public static DependencyProperty SenderProperty = DependencyProperty.Register("Sender", typeof

(Lookup), typeof(SendReport));

        [CrmInput("Sender")]

        [CrmReferenceTarget("systemuser")]

        public Lookup Sender

        {

            get

            {

                return (Lookup)base.GetValue(SenderProperty);

            }

            set

            {

                base.SetValue(SenderProperty, value);

            }

        }

        public static DependencyProperty MailRecipientProperty = DependencyProperty.Register("MailRecipient", typeof

(Lookup), typeof(SendReport));

        [CrmInput("MailRecipient")]

        [CrmReferenceTarget("contact")]

        public Lookup MailRecipient

        {

            get

            {

                return (Lookup)base.GetValue(MailRecipientProperty);

            }

            set

            {

                base.SetValue(MailRecipientProperty, value);

            }

        }

        public static DependencyProperty MailRecipientCCProperty = DependencyProperty.Register("MailRecipientCC", typeof

(Lookup), typeof(SendReport));

        [CrmInput("MailRecipientCC")]

        [CrmReferenceTarget("contact")]

        public Lookup MailRecipientCC

        {

            get

            {

                return (Lookup)base.GetValue(MailRecipientCCProperty);

            }

            set

            {

                base.SetValue(MailRecipientCCProperty, value);

            }

        }

    }

}

CRM in FireFox

2011-05-25T13:45:00.004+03:00

If your preferred browser is not IE.. :) then there is great solution to work with Microsoft Dynamics CRM in Mozilla FireFox - "IE TAB" Add-on.

To use this add-on:

1. download add-on

2. restart FireFox

3. Tools -> IE Tab 2 options

4. Add your CRM site url to "Sites Filter" section

That's it, CRM in FireFox 

CRM FetchXml with Javascript

2011-05-18T11:04:00.002+03:00

FetchXML method using javascript in CRM, allows me to use linked entities, so I can query attributes from different tables and linke them together with some primary attribute. 

Here's example: 

// Prepare variables 

var fetchMapping = "logical";

var entityName = "entitiyname"; //first attribute to fetch from this entity [CHANGE THIS]

var FirstColumn = "attributename1"; //first attribute to fetch from this entity [CHANGE THIS]

var SecondColumn = "attributename2"; //second attribute to fetch from this entity [CHANGE THIS]

var ThirdColumn = "attributename3"; //third attribute to fetch from this entity [CHANGE THIS]

var ForthColumn = "linkedattributename1"; //first attribute to fetch from linked entity [CHANGE THIS]

var FifthColumn = "linkedattributename2"; //second attribute to fetch from linked entity [CHANGE THIS]

var linkEntity = "linkentityname"; //linked entity name [CHANGE THIS]

// These both attributenames should have same value to link entities [CHANGE THIS]

var linkEntityFrom = "linkentity_attributename";

var linkEntityTo ="currententity_attributename";

var filterType = "and"; //filter type

var conditionAttribute = "attributename"; //condition attribute from linked entity [CHANGE THIS]

var operator = "eq"; //operator

var value = "value"; //value for filtering [CHANGE THIS]

var authenticationHeader = GenerateAuthenticationHeader();

//SOAP message

var xml = "<?xml version='1.0' encoding='utf-8'?>"+ 

"<soap:Envelope xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'"+

" xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'"+

" xmlns:xsd='http://www.w3.org/2001/XMLSchema'>"+ 

authenticationHeader+ 

"<soap:Body>"+ 

"<Fetch xmlns='http://schemas.microsoft.com/crm/2007/WebServices'>"+ 

"<fetchXml>&lt;fetch mapping='"+fetchMapping+"'&gt;"+ 

"&lt;entity name='"+entityName+"'&gt;"+ 

"&lt;attribute name='"+FirstColumn+"'/&gt;"+

"&lt;attribute name='"+SecondColumn+"'/&gt;"+

"&lt;attribute name='"+ThirdColumn+"'/&gt;"+

"&lt;link-entity name='"+linkEntity+"' to='"+linkEntityTo+"'&gt;"+

"&lt;attribute name='"+ForthColumn+"'/&gt;"+

"&lt;attribute name='"+FifthColumn+"'/&gt;"+

"&lt;filter type='"+filterType+"'&gt;"+ 

"&lt;condition attribute='"+conditionAttribute+"'"+

" operator='"+operator+"' value='"+value+"'/&gt;"+  

"&lt;/filter&gt;"+ 

"&lt;/link-entity&gt;"+ 

"&lt;/entity&gt;"+

"&lt;/fetch&gt;</fetchXml>"+ 

"</Fetch>"+ 

"</soap:Body>"+ 

"</soap:Envelope>";

// Prepare the xmlHttpObject and send the request.

var xHReq = new ActiveXObject("Msxml2.XMLHTTP");

xHReq.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);

xHReq.setRequestHeader("SOAPAction","http://schemas.microsoft.com/crm/2007/WebServices/Fetch");

xHReq.setRequestHeader("Content-Type", "text/xml; charset=utf-8");

xHReq.setRequestHeader("Content-Length", xml.length);

xHReq.send(xml);

var resultXml = xHReq.responseXML;

var errorCount = resultXml.selectNodes('//error').length;

if (errorCount != 0)

{

var msg =   resultXml.selectSingleNode('//description').nodeTypedValue;

alert(msg);

}

else

{

var resultSet = new String();

resultSet = resultXml.text;

resultSet.replace('&lt;','<');

resultSet.replace('&gt;','>');

var oXmlDoc = new ActiveXObject("Microsoft.XMLDOM");

oXmlDoc.async = false; 

oXmlDoc.loadXML(resultSet);

var results = oXmlDoc.getElementsByTagName('result');

var msg = "Result\r";

    for (i=0;i < results.length;i++)

    {

     var attribute1 = results[i].selectSingleNode('./attributename1').nodeTypedValue; //[CHANGE THIS]

     var attribute2 = results[i].selectSingleNode('./attributename2').nodeTypedValue; //[CHANGE THIS]

     var attribute3 = results[i].selectSingleNode('./attributename3').nodeTypedValue; //[CHANGE THIS]

     var linkedattribute1 = results[i].selectSingleNode('./currententity_attributename.linkedattributename1').nodeTypedValue; //[CHANGE THIS]

     var linkedattribute2 = results[i].selectSingleNode('./currententity_attributename.linkedattributename2').nodeTypedValue; //[CHANGE THIS]

     msg += attribute1 + "\t" + attribute2 + "\t" + attribute3 + "\t" + linkedattribute1 + "\t" + linkedattribute2 + "\r";

}

    alert(msg); //alert the fetch result

}

Sharepoint Query with SPAPI

2011-05-17T13:54:00.002+03:00

1. To use SPAPI query download it from HERE!!!.
2. On SharePoint server under "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS" create folder "SPAPI".
3. Place extracted js files from download to this folder.
4. Put your query within these code lines:

<script type="text/javascript" src="/_layouts/SPAPI/SPAPI_Core.js"></script>
<script type="text/javascript" src="/_layouts/SPAPI/SPAPI_Lists.js"></script>
<script type="text/javascript">

<your spapi query>

</script>

//SPAPI query example:

var lists = new SPAPI_Lists('http://url')// SharePoint site URL
var items = lists.getListItems(
'ListName',// SharePoint list name
'', // SharePoint list view name (for default leave blank)
'<Query><Where><Eq><FieldRef Name="FieldName"/><Value Type="Text">'+Value+'</Value></Eq></Where></Query>', // query
'<ViewFields><FieldRef Name="FieldName"/></ViewFields>', // which field/s to view
1, // RowLimit
'' // QueryOptions
);

if (items.status == 200)
{
var rows = items.responseXML.getElementsByTagName('z:row');

for(x=0; x < rows.length; x++) {
var listValue = rows[x].getAttribute('ows_FieldName'); // query field + ows prefix
}
}
else
{
alert('There was an error: ' + items.statusText); // else alert error message
}

Things you should know:
If you use field names with blank spaces you should use field names formatted properly otherwise query will not work. From my experience I use SharePoint Designer to get field names with unsupported characters or blank spaces like this:

1. Connect to your SharePoint site via SharePoint Designer
2. Navigate to "Data Source Library" in upper right section
3. Expand SharePoint lists and find your list from which you want to query fields
4. Right click on the list name and select "Show Data"
5. There you will see all field names with data from current list.
6. Look for your field name (it will be with some different characters like _x0020_).
7. Use this field name in your query.

SharePoint Workflow does not start automatically (kb947284)

2011-04-11T20:41:00.001+03:00

I was able to start my workflow automatically which I created through SharePoint Designer.

Firstly I checked out instructions from this article kb947284. In my case regarding to kb947284 I was logged in with "System Account". So I took some other user from sharepoint member group and logged back in, but with no luck...

After hours of endless searching i came across to something like this: "If I browse my sharepoint web page with IP address instead of hostname automatic workflows wouldn't start!!!"

Sharepoint 2010 Foundation install Step By Step

2011-04-01T15:47:00.007+03:00

My goal was to install Sharepoint Foundation 2010 (SPF2010) so that web application is on one server and the database is on seperate server. 

So these were my steps:

1. Download SharePoint Foundation 2010 from Microsoft Download Center

2. Before installing check System & Hardware requirements

3. Run setup

4. Install software prerequisites:

And there was my first error message saying: "The tool was unable to install Hotfix for Microsoft Windows KB976462"

Solution: 

Download and install this Hotfix manually and after that run again "Install software prerequisites".

Instructions (from this link):

Create a Folder under C:\ as KB976462 
Download hotfix KB976462
Open Command Prompt (run as administrator) and then execute the following statement.

   1.expand -f:* "C:\KB976462\Windows6.1-KB976462-v2-x64.msu" %TEMP% and the second

   2.pkgmgr.exe /n:%TEMP%\Windows6.1-KB976462-v2-x64.xml 
Run again "Install software prerequisites".
5. Install SharePoint Foundation

Choose "Server Farm" -> "Complete". (This allowed me to install SharePoint database on seperate server.
Run Configuration Wizard.
Choose "Create new Farm" and type in sql server instance and account. And there was my second error message saying: "SQL server at 'server\instance name' has an unsupported version 9.0.4035.0." In my case I had a "SQL 2005 SP3", so I was missing Cumulative update package 3 for SQL Server 2005 Service Pack 3
Download & Install Cumulative update on your SQL server. Server Restart required!!!
So after this Hotfix continue setup and specify pass phrase.
Choose Administration page port.
Set authentification to NTLM.
Done!

Latest earthquakes in the World

2011-03-29T13:03:00.001+03:00

Very usefull online information tool to get info for latest earthquakes and volcanos in the world

Realtimetools  

How long does it take to drive through Riga city ?

2011-03-28T23:20:00.008+03:00

I must say that this is not a story about THIS. My approach was more realistic and much safer :)I took my car to drive through city Riga from one city border to another simply to check how much time do i need to get through this city within legal limits.

Get current SharePoint User with JavaScript

2011-03-24T21:48:00.006+02:00

During the SharePoint form customization in many cases it is important to know the current user. So with JavaScript and SharePoint Designer this is how it's done:

var loginElement = document.getElementById("zz7_Menu").innerHTML;
var end = loginElement.indexOf("<");
var nameOnly = loginElement.substring(8, end);

note: I use this script in MOSS2007, but if you use this in WSS3 change "zz7_Menu" to "zz6_Menu".

My whole point using this script was to get the current username (in my case organization username format is: username14, username57 etc.) And based on that I need to get only numbers from this username. So there is my complete solution:

var loginElement = document.getElementById("zz7_Menu").innerHTML;
var end = loginElement.indexOf("<");
var nameOnly = loginElement.substring(8, end);
var number = nameOnly.replace (/[^\d]/g, "");
var k;

if (number != "") {
var elements = document.getElementsByTagName('select');
for (var i = 0; i < elements.length; i++) {
if (elements[i].title == 'YOUR DROPDOWN TITLE'){
var sel = elements[i].options.selectedIndex = number;
for (k=elements[i].options.length-1;k>=0;k--) {
if (k != sel) {
elements[i].remove(k);
   }
   }
   }
  }

}

How to get CRM grid View Id

2011-03-22T23:18:00.000+02:00

If we add this piece of code to ISV.config we get the current View Id currently displayed in the CRM grid:

if (top.stage.crmGrid != null)
{
var ViewID = top.stage.crmGrid.GetParameter('viewid');
alert(ViewID);
}

Train Tracking with GPS

2011-03-22T16:49:00.004+02:00

Last Saturday I took a trip on a train from Riga to Saulkrasti (45km). Weather was pretty cloudy but I thought maybe I could get interesting info from this trip with my gps. This is my gps data report

Latvian Railway

Train model: ER2T

CRM Save Events - you can do more

2011-03-18T13:39:00.006+02:00

When user saves the form we can check which save event was executed and regarding to that event make some actions. Two most popular save events are Save and SaveAndClose.

Javascript functions to call from your script:
crmForm.Save();
crmForm.SaveAndClose();

To check which event was executed we use "event.Mode"
Output for Save event = 1;
Output for SaveAndClose event = 2;

example:
if (event.Mode == 1) {
alert("You click Save button");
} else if (event.Mode == 2) {
alert("You click SaveAndClose button");
}

JavaScript in CRM ISV.config

2011-03-17T15:14:00.002+02:00

Writing JavaScript code in ISV.config can be painful. There is one important thing you need to know when you write JS code in ISV - Some JavaScript characters here are not supported and that's why you need to encode them:

Symbol    Encoded value
   < <
   > >
   " "
   & &