Microsoft Dynamics CRM 4.0

Async Operation failed

2011-12-22T14:02:00.000+02:00

Hi,

Async Operation failed and I want to get the reason.

Run this SQL and read the message

USE ORG_MSCRM

SELECT createdon,message,PrimaryEntityType,Name,Depth FROM AsyncoperationBase

WHERE statecode = 3 AND statuscode = 31 AND Deletionstatecode = 0

ORDER BY createdon DESC

VIEW THE ERROR IN message.

THANKS,

Rami Heleg

Invalid argument for field "incomingemaildeliverymethod" in systemuser

2011-06-02T23:01:00.000+03:00

Hi,

Valid values for Picklist in CRM 3,4,2011 start from 1, 2. Values empty or 0 are not valid.

Example for picklist values:

Value Name

0 Israel

1 USA

2 Holland

I have found a pick list with empty value.

Problem appears in Systemuser field incomingemaildeliverymethod.

The field incomingemaildeliverymethod values start from 2 and the first value is empty.

If I try to create new systemuser and set value for this field in pre create event values 0 or empty error message “Invalid argument “

The solution is to create a new field Picklist and set the value like that:

Microsoft.Crm.Sdk.Picklist incoming = new Microsoft.Crm.Sdk.Picklist();

incoming.name = "ללא";

// Set values for this field in pre create

ContextUtils.SetProperty(context, "incomingemaildeliverymethod", incoming, typeof(PicklistProperty));

Now the set values works correctly

Thanks,

Rami Heleg

Clean AsyncOperationBase table

2011-02-14T17:31:00.000+02:00

Hi,
Highly recommend to clean table AsyncOperationBase for performance issue.
http://support.microsoft.com/kb/968520

this script clean the table and improve Async operations.
thanks,
Rami Heleg.

Failed to view Report server and get error message "The page cannot be found"

2010-11-12T18:39:00.001+02:00

Hi,\
i tried to create a new organization and i faild because report server is down
when view the reportserver url get error message:

To Fix the problem needs to open Reporting Services Configuration manager and press Start.

\

vwalla report server works.. and now i can create a new organization

Thanks,
Rami Heleg

Redeployment CRM failed after success to import users and failed to import report

2010-11-07T18:32:00.000+02:00

Redeployment success to import a few reports but failed to import all reports.

In this case need o delete report server Encryption:

thanks,
Rami Heleg

Failed to redeployment CRM organization

2010-11-07T17:53:00.000+02:00

Failed to redeployment CRM organization and get the error message:

13:02:20
Error
Import Organization (Name=LeumiCim, Id=782be048-dde4-df11-968c-00145ebd47b6) failed with Exception:

System.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.

at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)

at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)

at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command)

at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate)

at Microsoft.Crm.CrmDbConnection.SetTransactionIsolationLevel(IsolationLevel il)

at Microsoft.Crm.CrmDbConnection.Dispose(Boolean disposing)

at Microsoft.Crm.SqlExecutionContext.Dispose(Boolean disposing)

at Microsoft.Crm.SqlExecutionContext.Dispose()

at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.Import(Guid organizationId, String organizationUniqueName, String organizationFriendlyName, String sqlServerName, String databaseName, Uri reportServerUrl, String privilegedUserGroupName, String sqlAccessGroupName, String userGroupName, String reportingGroupName, String privilegedReportingGroupName, ICollection`1 users, MultipleTenancy multipleTenancy)

After check this error I got that the problem is missing temporary database for reporting service.

Reporting services contain 2 databases:

1. ReportServer

2. ReportServerTempDB

By mistake the database ReportServerTempDB.

To return the temporary database open "Report server Configuration"

.select "database setup" and press "New"

This option creates the temp database after this process try to run again the redeployment tools.

Thanks,

Rami Heleg

View CRM log files for instance redeployment file:

2010-10-24T17:48:00.002+02:00

View CRM log files for instance redeployment file:

Go to start run write %APPDATA%

Select folder Microsoft\MSCRM\Logs

Many files appear, in this case select the latest modified file.

Thanks,

Rami Heleg.

Redeployment success but get in error message in log file because update version id

2010-10-24T17:47:00.000+02:00

Hi,
Redeployment success but get in error message in log file because update version id :

14:54:56
Info
Applying database updates to the organization...

14:55:12
Info
Updating BuildVersion.Revision for all Organization Databases

14:55:12
Warning
Attempting to cancel a long running process: ProgressWizard. This might leave the data in an invalid state and the application might not function correctly.

14:55:12
Info
Organization (XXX) imported.

16:35:51
Warning
Attempting to cancel a long running process: FinishWizard. This might leave the data in an invalid state and the application might not function correctly.

16:35:51
Info
Deployment Manager Exit

The solution for that: install rollup 13 ( never mind if exist ) . Redeployment failed to update version in DB.

Thanks,
Rami Heleg

Time out When Email router run SQL queries

2010-10-12T10:09:00.000+02:00

Hi,
CRM/Email router return time out when retrieve email queries.
The reason is to query to retrieve Activities/Email.

To solve the issue must add parameter to register.

1. Under the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM\registry subkey on the Microsoft Dynamics CRM server, add the following REG_DWORD registry entry: SmartMatchingForceOrder

2. Set the value of the registry entry that you just added to 1

BTW Rollup 13 must be installed

Thanks,
Rami Heleg

Use Thread to improve performance.

2010-10-11T19:20:00.000+02:00

Option to improve performance for callouts or just server side is to use thread

Here Is an example of using thread:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace thread {

class Program {
static void Main(string[] args) {
System.Threading.ThreadPool.QueueUserWorkItem(f => {xxx();});
}

static void xxx(){
int a = 8;
}
}
}

Enjoy,

Rami Heleg

How to create a new organization/ import organization and prevent from insert report service URL…?

2010-10-10T23:22:00.001+02:00

Everyone know to create/import organization must insert report URL.

We can prevent insert the report URL and of course success to create organization …

How to do that….?

Add the IgnoreChecks registry key to the computer that is running Microsoft Dynamics CRM 4.
click Run, type regedit, and then click OK.
In the registry, locate the following subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
Right-click MSCRM, point to New, click DWORD Value, and then type IgnoreChecks. + set Value 1.
Sceen shots:

Thanks,
Rami Heleg

Failed to open CRM. get error message License Expired.

2010-10-09T11:49:00.001+02:00

Hi,
Open CRM and get error message in CRM+ in event viewer “license expired”.
Error message appears in two modes.

1. The first case when the license expired.
2. When service MS Async Service is down.

Go to services windows, select Async service and run again.
Thanks,
Rami heleg

Find CRM entity name by ObjectID

2010-10-09T11:27:00.000+02:00

Everybody knows this strange error message from CRM trace logs: Error Message: SecLib::AccessCheckEx failed. Returned hr = -2147187962, ObjectID: 48355f9a-96c5-df11-90dc-00145ebd47b6, OwningUser: 6d04898c-db79-df11-83b4-00145ebd47b6 and CallingUser: 9cfc1a56-da79-df11-83b4-00145ebd47b6.
CRM failed to perform some action on an entity with ObjectID = 48355f9a-96c5-df11-90dc-00145ebd47b6
The error does not contain the problematic entity name I prefer to know.
So I wrote the SQL script that helps me to find an entity name by ObjectID

DECLARE @objectId uniqueidentifier

SET @objectId = '41DC59A0-96C5-DF11-90DC-00145EBD47B6' – Set your ObjectID here
DECLARE @entityName nvarchar(255), @baseEntityName nvarchar(255), @primaryKeyColumnName nvarchar(255), @sql nvarchar(max), @isActivity bit
DECLARE cur CURSOR FOR SELECT Name, BaseTableName, IsActivity from Entity with (nolock) where IsValidForAdvancedFind = 1
OPEN cur
FETCH NEXT FROM cur INTO @entityName, @baseEntityName, @isActivity
WHILE @@FETCH_STATUS = 0
BEGIN
if(@isActivity = 1 OR @entityName = 'ActivityPointer')
SET @primaryKeyColumnName = 'activityid'
else
SET @primaryKeyColumnName = @entityName + 'id'
SET @sql = 'IF EXISTS(SELECT ' + @primaryKeyColumnName + ' FROM ' + @baseEntityName + ' WHERE ' + @primaryKeyColumnName + '=''' + CONVERT(nvarchar(36), @objectId) + ''') SELECT ''' + @entityName + ''''
exec(@sql)
IF @@ROWCOUNT > 0 BREAK;
FETCH NEXT FROM cur INTO @entityName, @baseEntityName, @isActivity
END
DEALLOCATE cur

Thanks,
Max s

Define opening CRM as a application

2010-09-23T14:39:00.000+02:00

Go to system setting

Select tab: Personal Settings

Select the check box like the image linked

Close the explorer and open the CRM again.

Thanks,

Rami Heleg

Failed to install CRM 4.0

2010-09-15T16:36:00.003+02:00

Failed to install CRM 4.0.

Failed to install CRM 4.0 and get error message
"the account specified to run the microsoft dynamics crm asynchronous processing service does not have performance counter permissions..."

in Microsoft Dynamics CRM Setup windows.

The reasons can be:
installer must be local admin.
define CRM to run CRM in a user which is not local admin. ( enable to view this data after install in iis - application pool)

Thanks,
Rami Heleg

Get CrmService for specific organization.

2010-08-16T15:47:00.000+03:00

I have many organizations and I need the entities for specific organization

The solution

Create crm service where URL contain
?uniquename=org_name

for instance:
http://servername/MSCRMService/2007/Crmservice.asmx/?uniquename=org_name
enjoy,
Rami Heleg

Working with GAC

2010-08-09T20:09:00.000+03:00

I CRM 4.0 usual is to work with GAC (Global assembly cache)
Replace file, delete file, copy file.
If failed to delete or copy file from GAC
Make the next instructions:
How to view windows/assembly folder
1. Open Regedit, browse to HKLM\Software\Microsoft\Fusion.
2. Add a REG_DWORD value named 'DisableCacheViewer'; set it to 1
3. open an Explorer window and type in C:\WINDOWS\assembly\GAC_MSIL\

Open GAC ( c:\windows\assembly\msil and copy the relevant file and remove
After finish change 'DisableCacheViewer' to 0
Thanks
Rami Heleg.

Hide field in client side

2010-07-19T17:21:00.001+03:00

Hi,
Here is fnunction to hide field in client Side, Javascript:

function HideField(fieldName, visible) {
var label = document.getElementById(fieldName + '_c');
var value = document.getElementById(fieldName + '_d');
if (label)
label.style.display = visible ? 'inline' : 'none';
if (value)
value.style.display = visible ? 'inline' : 'none';
}

thanks,
Rami Heleg

How to find which Rollup CRM installed?

2010-07-18T16:26:00.004+03:00

I installed some rollups.

i want to know if i installed specific version

1. open control panel/ installed updated and check which version like next picture

2. if you see only KBXXX go to crm download rollup center and check the rollup id like this pictures

thanks,
Rami Heleg.

Using RemoteCommand in CRM 4.0

2010-07-12T21:56:00.002+03:00

What is it RemoteCommand ?
RemoteCommand is Microsoft XmlHttp interface.

Microsoft blocked the option to use RemoteCommand in CRM 4.0
How to use RemoteCommand in CRM 4.0?
1. Copies file RemoteCommand.JS from CRMWEB\_static\_controls\RemoteCommands to user local folder with JS and rename the file for instance customRemote.js
2. Rename function: RemoteCommand to CustomCommand and add another parameters for instance:
function CustomCommand (sObject, sCommand, sUrlBase, sNamespace)
3. Change the row:
var sCommandNamespace =_sWebServicesNamespace; to
var sCommandNamespace = sNamespace ? sNamespace : _sWebServicesNamespace;

finish to change the file.

Call to function from Javascript:

var cmd = new CustomCommand('webServiceName', 'functionName', '/MySite/', 'http://NameSpace');
cmd.SetParameter('incidentID', objectid);
cmd.SetParameter('targetID', instanceID);
var rslt = cmd.Execute();
if (!rslt || !rslt.ReturnValue){
//work good
return;

}
if (rslt.ReturnValue.errorDescription) {
//Failed
alert(rslt.ReturnValue.errorDescription);
return;
}

Define name space in c# code:

[WebService(Namespace="http://NameSpace")]
public class webServiceName: System.Web.Services.WebService {

thanks,
Rami Heleg,

Set in client Side values into disabled field

2010-07-12T20:56:00.002+03:00

To set value into disabled field must set values like that:

crmForm.all.new_myfield.ForceSubmit = true;
crmForm.all.new_myfield.defaultValue = crmForm.all.new_myfield.DataValue = value;

by default crm doesn't send disbaled values from client to server in save entity.

thanks,
Rami Heleg

Audit - who opened CRM pages

2010-07-12T06:21:00.003+03:00

I want to write in audit log who opened crm pages ( view contact, account etc...) what should i do?

with PlugIn registration register to message retrieve for the relevant evtities.

retrieve event appear only if open the edit.aspx page with record.
open edit.aspx in new form, crmForm.FormType = 1 will not exevute the event.

thanks,
Rami Heleg

Create CrmService with Caller Id

2010-07-05T23:14:00.003+03:00

Here is the example to create CrmService:

CrmAuthenticationToken token = new CrmAuthenticationToken();
token.OrganizationName = "org1";
token.AuthenticationType = 0; //Active directory
token.CallerId = userGuid; // impersonate to this user
CrmService pService = new CrmService();
pService.Url = _strServerUrl + "/MSCRMServices/2007/crmservice.asmx";
pService.CrmAuthenticationTokenValue = token;
pService.Credentials = DefaultCredential();

i can create crmService from two type

1. CrmService as web service from mscrmservices\2007
2. Microsoft.Crm.SDK.

to change the callerid i failed to do it if i used Crmservice from webservice.

i test the issue and changing the caller works only if Crmservice from type Microsoft.Crm.Sdk.

thanks,
Rami Heleg,
NetusUp Inc.

Pass parameter to Plug in

2010-06-22T21:21:00.004+03:00

How can i pass parameters to Plugin?

1. open plugin registration
2. CRUD step.
3. Right side contains two rich text: unsecure configuration, secure configuration ( see picture)
4. Add your parameters
5. Current status every executes this step the parameters passed to plugin.

How to get the parameters in PlugIn?
Create two constructors like this example:
//without parameters
public AuditEntities() { }
//with parameters
public AuditEntities(string unsec, string sec) { }

the parameters passed to unsec or sec. save the parameters and good luck

Thanks,
Rami Heleg

Replace PlugIn File field becuase file in use

2010-06-22T21:12:00.002+03:00

Question:
I tried to replace plugin dll in and always get message “File in used”….

I did iisreset but still the same problem.

What can I do…?

Answer:
The reason is async service.

You need to stop Microsoft CRM Async service replace the file and restart again

( one of your step is async step)

thanks,
Rami Heleg

IIS: how to get the IUSER password for IIS

2010-05-08T19:32:00.003+03:00

Hi ,
i try to run web site in IIS folder with ammoniums creational but by mistake I deleted the IUSER password. I can I get the password?

Solution:
Open command dialog and select folder " C:\Inetpub\AdminScripts"
Write the command:
C:\Inetpub\AdminScripts>cscript adsutil.vbs get w3svc/anonymoususerpass

Now take the answer and use the password for IIs

Thanks
Rami Heleg

Error message when open Deployment Manager

2010-05-08T18:45:00.003+03:00

Hi,
i try to open Deployment Manager many time and get sometimes error message.
after press the message the Deployment Manager still work.

to solve this error need to add key to register..

reasons for the error:Active Directory contains many domain controllers.
You have insufficient permissions to query all domain controllers.

solution:

Go to the following registry :
HKLM\Software\Microsoft\MSCRM
Add a new String value that is named PreferredDc.
Specify the domain controller that you want. Typically, this is the closest domain controller.
Restart the CRM server.

thanks,
Rami Heleg

IFD: failed to view in IFRAME CRM pages...( cannot be found)

2010-05-08T18:33:00.003+03:00

Hi,
i view in IFRMAES pages for instance from UserDefined folder.

set the file like that to the frame.src :"\UserDefined\area.aspx?id=23232"
using the relative path.

if i try to work with windows Auth all file but if i try to open the same page from out side ( IFD - Form Auth) the page field to view.

the reason is :

CRM failed to add the full extenstion path if it's form auth...in windows auth all works fine.. .

solution:
i check in my code if the server.location from IFD or windows auth..

if IFD i gave to frame.src the full path for instance:
http:\\mymachiume.crm\UserDefined\area.aspx?id=23232"
now works fine.

thanks
Rami Heleg

Remove Outlook button in Microsoft dynamics CRM

2010-04-18T23:05:00.002+03:00

Hi,
after installed rollup 7 to CRM new button appear " Outlook"

to remove this button:

1. On the Microsoft Dynamics CRM Application Server click Start, click Run, type Regedit, and then click OK.

2. Locate the following registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM.

3. Right-click MSCRM, click New, and then click DWORD (32-bit) Value.
Name the new key DisableOutlookSetupLink.

4. Right-click DisableOutlookSetupLink, click Modify, and then type 1 to disable the CRM for Outlook button for all users.

thanks
Rami heleg

Register Plug-In options

2010-04-04T18:06:00.004+03:00

Hi,
install plug-in dll can be in 3 install options

1. disk
in this case the file must be under server\bin\assembly folder

2. database
CRM upload the file to database. this plug-in option is the faster from all the three options
3. GAC
file must be under c:\windows\assembly

if the DLL have references to GAC in this case install the dll only if the GAC contain the relevant files ( depend on CRM installation ( Full server or in 2 servers platform and application))

replace-update dll:
if replace for new version failed by getting error message " The file is in used"... in this case stop the service:
Microsoft Dynamics CRM 4.0 Async service
and start again... if still failed to replace the file in this case stop the IIS.
can get this error if file register to Disk or GAC.

to register the dll use Plug-in registarion.. from SDK download.

images:
using images help to get all fields from pre and post or get selected fields.

pre and post images relenat for all messages except Create.. Contain only post images.

thanks
Rami Heleg.

Failed to publish workflow for Email entity

2010-03-26T13:44:00.008+03:00

I got error message after publish Workflow for email entity steps .

"An error occurred when the workflow was being created. Try to save workflow again"
after i try to publish workflow with email steps.

the reason can be installed rollup 2

the solution can be adding next rows to CRM 4.0 web config

<authorizedType Assembly="mscorlib, Version=2.0.0.0, Culture=neutral,

PublicKeyToken=b77a5c561934e089" Namespace="System" TypeName="Void"

Authorized="True"/>

<authorizedType Assembly="mscorlib, Version=2.0.0.0, Culture=neutral,

PublicKeyToken=b77a5c561934e089" Namespace="System.Reflection"

TypeName="AssemblyFileVersionAttribute" Authorized="True"/>

<authorizedType Assembly="mscorlib, Version=2.0.0.0, Culture=neutral,

PublicKeyToken=b77a5c561934e089" Namespace="System.Reflection"

TypeName="AssemblyVersionAttribute" Authorized="True"/>

<authorizedType Assembly="mscorlib, Version=2.0.0.0, Culture=neutral,

PublicKeyToken=b77a5c561934e089" Namespace="System.Globalization"

TypeName="CultureInfo" Authorized="True"/>

thanks
Rami Heleg.

Add annotation Comments + files via modal dialog

2010-03-08T15:17:00.002+02:00

Hi,
i would like to show modal dialog to add comments + file to CRM 4.0 entity:

answer:

here are two examples to add comments+ files

show comments (annotation) page to add comment + attached file ( for contact entity)
http://localhost:5555/org_name/notes/edit.aspx&pId={3423423-234324-434d-4324323w&pType=2

show comments (annotation) page to add attached file ( for contact entity)
href="http://localhost:5555/org_name/notes/edit.aspx?hideDesc=1&pId={3423423-234324-434d-4324323w}&pType=2"

Enjoy,
Rami Heleg

Using CRM 3/4 with Internet Explorer 6

2010-03-08T13:34:00.003+02:00

Hi,
adding JS + AJAX CRM 3,4 using Internet explorer 6 may cause edit.aspx to freeze when loading.

Reason:
When page is loading explorer 6 behavior is a different from explorer 7,8.

If you add some code ( JS + ajax) when page is loading .. before client finish with all methods the lookup fields on the screen start to throw error (on focus event). but in explorer 7 only after all code is finished then lookup start with focus.

You can change the htc, JS files in many places but this is not a good solution.

solution:

upgrading to Internet explorer 7,8 solve this issue.

thanks Rami,

Export Dynamics or Pivotable freeze CRM.

2010-03-06T22:01:00.005+02:00

Hi,
CRM 3/4 can be freeze if using Export Dynamic or Pivotable to excel.

in this case the selected records locked on the db and until close the excel file.

the options to export dynamic or pivotable is good only for POC or Demo but not in live

solution:
1. change hard coded the file from prevent the options to export.
2. Create your own excel files with sql queries , create links and call to thus files from client side

for CRM 3.0 change file: print_dlg.aspx
for crm 4.0 change file: export_dlg.aspx

thanks,
Rami Heleg,

CRM performance is very slow

2010-02-08T22:33:00.004+02:00

I work with CRM ¾ and all the system works very slowly

Loading pages is very slow, and all the system looks busy.

One of the options is Antivirus.

When you work with CRM and open some pages for instance Edit.aspx not only the edit.aspx is downloaded from server many JavaScript + CSS + other linked pages is downloaded too

If antivirus is working check if Antivirus is scanning all the scripts and pages when you request page from CRM.

if yes... change the Antivirus to prevent of scanning all CRM pages and the performance back to be perfect

I got this problem with Antivirus MCAfee.

workaround
http://support.microsoft.com/kb/924341

https://kc.mcafee.com/corporate/index?page=content&id=KB65382&actp=search&viewlocale=en_US&searchid=1278011200919

Thanks,
Rami Heleg.

Get Organization Connection string

2010-01-30T17:44:00.001+02:00

Hi,
Here is the example to get Organization connection string.

//get connection to mscrm_config DB
string connectionString = "Data Source="ServerName;Initial Catalog=MSCRM_CONFIG;Integrated Security=SSPI";
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
//Select DB details for specific organization
string sqlString = string.Format("select databasename,* from organization with (nolock) where uniquename = '{0}'", organizationName);
SqlCommand command = new SqlCommand(sqlString, conn);
SqlDataReader reader = command.ExecuteReader();
if (reader == null)
return null;
if (!reader.Read())
return null;
object rslt = reader.GetValue(0);
//return organization connection string
return rslt;

Enjoy,

Rami heleg

Fetch or Retrieve?

2010-01-29T21:07:00.000+02:00

Fetch or Retrieve?

The million dollars question what is better using fetch or RetrieveMultiple...

RetrieveMultiple faster than the Fetch method Retrieve doesn’t have to parse the query.

My tip:

Work direcly with CRM DB for Queries and update.

Important:
Use “nolock” for select command.
in this case database doesn’t lock the table
Use “rowlock” to update table lock only the specific record.

Example for select command:

Select firstname, lastname from contact with (nolock)

Example for update command:

Update incidentextensionbase WITH(rowlock) set new_firstname = ‘aaa’ where incidentid = ‘{fdkjdf98438e9w8euew987}

Enjoy,
Rami Heleg

Create custom page with CRM style

2010-01-02T10:05:00.001+02:00

Hi,
here is an rxample to create your cutsom page like crm page.

The final page:

how to do it?
1. create new css file name: crmcs.css

paste start:

formButton
{
background-color: #6699cc;
padding: 2px 4px 3px 4px;
color: #000000;
font-size: 8pt;
font-family: tahoma;
height: 17px;
filter: progid:DXImageTransform.Microsoft.Gradient(GradientType=0, StartColorStr=#B4C5DF, EndColorStr=#91A9D0);
border-width: 0px;
}

TEXTAREA
{
font-size: 8pt;
font-family: tahoma;
width: 100%;
height: 100%;
border: 1px solid #6699CC;
}

.inputfields
{
font-size: 8pt;
font-family: tahoma;
width: 100%;
height: 19px;
border: 1px solid #6699CC;
}

INPUT.rad
{
width: 15px;
border: 0px;
cursor: hand;
}

DIV.tab
{
overflow-y: auto;
padding: 10px;
}

TD.sec
{
width: 100%;
color: #000000;
font-weight: bold;
padding-left: 0px;
padding-bottom: 2px;
text-overflow: ellipsis;
overflow: hidden;
}

TD
{
font-size: 11pt;
font-family: tahoma;
}

TD.bar
{
border-bottom: 1px solid #96B3DD;
}

SPAN.req
{
font-weight: bold;
color: #FF0000;
overflow: hidden;
text-overflow: ellipsis;
padding-top: 5px;
}

TD.statusBar
{
background-color: #80ABD4;
color: #000000;
background-image: url(images/statusbar_back.gif);
background-repeat: repeat-x;
padding-left: 5px;
height: 24px;
border-bottom: 1px solid #485673;
font-weight: bold;
}

LABEL
{
cursor: hand;
}

TD.radioLabel
{
padding-left: 2px;
padding-right: 10px;
}

TABLE.layout
{
table-layout: fixed;
width: 100%;
height: 100%;
}

div.tab
{
width: 100%;
height: 100%;
border: 1px solid #898C95;
background-color: #EAF3FF;
display: none;
}

body
{
font-size: 11px;
margin: 0px;
border: 0px;
background-image: url(images/form_back.gif);
background-repeat: repeat-x;
background-color: #acc0e9;
cursor: default;
}

td
{
font-size: 11px;
}

table
{
cursor: default;
}

a
{
color: #0000ff;
font-weight: bold;
}

.menubar
{
height: 44px;
}

.formtitle
{
padding-left: 10px;
}

TD.entitytype
{
font-weight: bold;
font-size: 11px;
padding-top: 2px;
}

TD.navtitle
{
font-weight: bold;
font-size: 18px;
padding-top: 1px;
color: #6699CC;
}
span.menu
{
height: 100%;
padding: 2px;
padding-left: 5px;
padding-right: 5px;
border: 1px solid #7288AC;
}

table.mnuBar
{
color: #000000;
height: 44px;
width: 100%;
background-image: url(images/form_toolbar_back.gif);
background-repeat: repeat-x;
}
paste end

Create new page ExamplePage.htm

paste start:

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; CHARSET=UTF-8" />
<link rel="stylesheet" type="text/css" href="crmcs.css">
<title>Rami example</title>
</head>
<body>
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr class="menubar">
<td>
<table class="mnuBar" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td />
</tr>
</tbody>
</table>
<table class="formtitle" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td class="entitytype" nowrap="nowrap">
Contact: Rami Heleg
</td>
</tr>
<tr>
<td class="navtitle">
Update contact
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td style="padding: 10px;">
<table cellspacing="0" cellpadding="0" width="100%" height="100%">
<tbody>
<tr>
<td>
<div style="display: inline" class="tab">
<table style="table-layout: fixed" cellspacing="0" cellpadding="3" width="100%" height="100%">
<colgroup>
<col width="90">
<col>
<col width="10">
<col width="90">
<col>
</colgroup>
<tbody>
<tr>
<td>
Full Name
<span class="req">*</span>
</td>
<td colspan="2">
<input id="fullname" class="inputfields" tabindex="1" maxlength="200" name="fullname"
req="1">
</td>
</tr>
<tr>
<td class="sec bar" colspan="5">
Section 1
</td>
</tr>
<tr height="5">
<td>
</td>
</tr>
<tr>
<td>
First Name
</td>
<td>
<input id="firstname" class="inputfields" tabindex="8" maxlength="250" name="category">
</td>
<td>
</td>
<td>
Last Name
</td>
<td>
<input id="lastnane" class="inputfields" tabindex="9" maxlength="250" name="subcategory">
</td>
</tr>

<tr>
<td class="sec bar" colspan="5">
Section 2
</td>
</tr>
<tr height="5">
<td colspan="5">
</td>
</tr>
<tr>
<td>
Sex
</td>
<td colspan="4">
<table cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td>
<input id="crmFormdonotemail0" class="rad" tabindex="200" value="0" type="radio"
name="crmFormdonotemail">
</td>
<td class="radioLabel">
<label for="crmFormdonotemail0">
Male</label>
</td>
<td>
<input id="crmFormdonotemail1" class="rad" tabindex="201" value="1" type="radio"
name="crmFormdonotemail">
</td>
<td class="radioLabel">
<label for="crmFormdonotemail1">
Female
</label>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td>
Country
</td>
<td>
<select style="width: 100%; font-family: tahoma,
Arial; font-size: 11px" class="selectBox">
<option selected>Isreal</option>
<option>USA</option>
</select>
</td>
<td>
</td>
<td>
Status
</td>
<td>
<select style="width: 100%; font-family: tahoma,
Arial; font-size: 11px" class="selectBox">
<option selected>Married</option>
<option>Single</option>
<option>Divorced</option>
</select>
</td>
</tr>
<tr>
<td>
Description
</td>
<td height="100%" colspan="4">
<textarea id="description" tabindex="2" name="description" maxlength="2000"></textarea>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr height="23">
<td class="statusbar" colspan="2">
<b>Status:</b> Vip Contact
</td>
</tr>
</tbody>
</table>
</body>
</html>

paste End:

Enjoy,
Rami Heleg

How to change connection string for organization in CRM 4.0

2010-01-01T20:23:00.000+02:00

Hi,
I want to change the connection string, What should i do?

The solution is very simple...

1. Open database MSCRM_CONFIG, table Organization.
2. This table contains information for all organization.
3. change in column ConnectionString to the new organization connection string.
4. reset CRM .

example:

BTW changing the register ( regedit) doesn't change the connection string.
it was relevant only for CRM 3.0

Enjoy,
Rami Heleg.

Update Method using Java Script

2009-12-29T22:21:00.000+02:00

Hi,
Here is an example to update entoty request only in Client Side

// Prepare variables for updating a contact.
var contactId = "56914948-991C-DD11-AD3A-0003FF9EE217";
var newAddressLine1 = "34 Market St.";
var authenticationHeader = GenerateAuthenticationHeader();

// Prepare the 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>"+
"<Update xmlns='http://schemas.microsoft.com/crm/2007/WebServices'>"+
"<entity xsi:type='contact'>"+
"<address1_line1>"+newAddressLine1+"</address1_line1>"+
"<contactid>"+contactId+"</contactid>"+
"</entity>"+
"</Update>"+
"</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/Update");
xHReq.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xHReq.setRequestHeader("Content-Length", xml.length);
xHReq.send(xml);
// Capture the result
var resultXml = xHReq.responseXML;

// Check for errors.
var errorCount = resultXml.selectNodes('//error').length;
if (errorCount != 0)
{
var msg = resultXml.selectSingleNode('//description').nodeTypedValue;
alert(msg);
}
// Display a confirmation message and open the updated contact.
else
{
alert("Contact with id = "+contactId+" successfully updated.");
window.open("/sfa/conts/edit.aspx?id={"+contactId+"}");
}

Enjoy,
Rami Heleg

RetrieveMultiple Method Using Java Script

2009-12-29T22:19:00.000+02:00

Hi,
Here is an example to RetrieveMultiple only in Client Side

// Prepare variables to retrieve the contacts.
var searchCity = "Sammamish";
var authenticationHeader = GenerateAuthenticationHeader();

// Prepare the 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>"+
"<RetrieveMultiple xmlns='http://schemas.microsoft.com/crm/2007/WebServices'>"+
"<query xmlns:q1='http://schemas.microsoft.com/crm/2006/Query'"+
" xsi:type='q1:QueryExpression'>"+
"<q1:EntityName>contact</q1:EntityName>"+
"<q1:ColumnSet xsi:type='q1:ColumnSet'>"+
"<q1:Attributes>"+
"<q1:Attribute>fullname</q1:Attribute>"+
"<q1:Attribute>contactid</q1:Attribute>"+
"</q1:Attributes>"+
"</q1:ColumnSet>"+
"<q1:Distinct>false</q1:Distinct>"+
"<q1:Criteria>"+
"<q1:FilterOperator>And</q1:FilterOperator>"+
"<q1:Conditions>"+
"<q1:Condition>"+
"<q1:AttributeName>address1_city</q1:AttributeName>"+
"<q1:Operator>Like</q1:Operator>"+
"<q1:Values>"+
"<q1:Value xsi:type='xsd:string'>"+searchCity+"</q1:Value>"+
"</q1:Values>"+
"</q1:Condition>"+
"</q1:Conditions>"+
"</q1:Criteria>"+
"</query>"+
"</RetrieveMultiple>"+
"</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/RetrieveMultiple");
xHReq.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xHReq.setRequestHeader("Content-Length", xml.length);
xHReq.send(xml);
// Capture the result.
var resultXml = xHReq.responseXML;

// Check for errors.
var errorCount = resultXml.selectNodes('//error').length;
if (errorCount != 0)
{
var msg = resultXml.selectSingleNode('//description').nodeTypedValue;
alert(msg);
}
Enjoy,
Rami Heleg

Retrieve Method Using JScript

2009-12-29T22:17:00.000+02:00

Hi,
Here is an example to retrieve data only in Client Side

// Prepare variables for a contact to retrieve.
var contactid = "4696f8cb-9a1c-dd11-ad3a-0003ff9ee217";
var authenticationHeader = GenerateAuthenticationHeader();

// Prepare the 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>"+
"<Retrieve xmlns='http://schemas.microsoft.com/crm/2007/WebServices'>"+
"<entityName>contact</entityName>"+
"<id>"+contactid+"</id>"+
"<columnSet xmlns:q1='http://schemas.microsoft.com/crm/2006/Query' xsi:type='q1:ColumnSet'>"+
"<q1:Attributes>"+
"<q1:Attribute>fullname</q1:Attribute>"+
"</q1:Attributes>"+
"</columnSet>"+
"</Retrieve>"+
"</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/Retrieve");
xHReq.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xHReq.setRequestHeader("Content-Length", xml.length);
xHReq.send(xml);
// Capture the result.
var resultXml = xHReq.responseXML;

// Check for errors.
var errorCount = resultXml.selectNodes('//error').length;
if (errorCount != 0)
{
var msg = resultXml.selectSingleNode('//description').nodeTypedValue;
alert(msg);
}
// Display the retrieved value.
else
{
alert(resultXml.selectSingleNode("//q1:fullname").nodeTypedValue);
}
The following is an example of a successful response:

<?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">
<soap:Body>
<RetrieveResponse xmlns="http://schemas.microsoft.com/crm/2007/WebServices">
<RetrieveResult xmlns:q1="http://schemas.microsoft.com/crm/2007/WebServices" xsi:type="q1:contact">
<q1:fullname>Jesper Aaberg</q1:fullname>
<q1:contactid>{4696F8CB-9A1C-DD11-AD3A-0003FF9EE217}</q1:contactid>
<q1:owningbusinessunit>{0EA35030-3EC9-DC11-A8D2-0003FF9EE217}</q1:owningbusinessunit>
</RetrieveResult>
</RetrieveResponse>
</soap:Body>
</soap:Envelope>

Enjoy,
Rami Heleg

Run Fetch Method using java script

2009-12-29T22:15:00.000+02:00

Hi,
Here is an example to execute fetch only in Client Side

// Prepare variables to fetch accounts.
var fetchMapping = "logical";
var entityName = "account";
var firstColumn = "accountid";
var secondColumn = "name";
var linkEntity = "systemuser";
var linkEntityTo ="owninguser";
var filterType = "and";
var conditionAttribute = "lastname";
var operator = "ne";
var value = "Cannon";
var authenticationHeader = GenerateAuthenticationHeader();

// Prepare the 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><fetch mapping='"+fetchMapping+"'>"+
"<entity name='"+entityName+"'>"+
"<attribute name='"+firstColumn+"'/>"+
"<attribute name='"+secondColumn+"'/>"+
"<link-entity name='"+linkEntity+"' to='"+linkEntityTo+"'>"+
"<filter type='"+filterType+"'>"+
"<condition attribute='"+conditionAttribute+"'"+
" operator='"+operator+"' value='"+value+"'/>"+
"</filter>"+
"</link-entity>"+
"</entity>"+
"</fetch></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);
// Capture the result.
var resultXml = xHReq.responseXML;

// Check for errors.
var errorCount = resultXml.selectNodes('//error').length;
if (errorCount != 0)
{
var msg = resultXml.selectSingleNode('//description').nodeTypedValue;
alert(msg);
}

Enjoy,
Rami Heleg

Execute Method using Java Script

2009-12-29T22:12:00.000+02:00

Hi,
Here is an example to execute request only in Client Side

// Prepare variables to add a new product to a campaign.
var CampaignId = "771ed82b-6b27-dd11-b452-0003ff9ee217";
var EntityId = "3F26C82A-A2E1-DC11-A277-001AA0B84538";
var EntityName = "product";
var authenticationHeader = GenerateAuthenticationHeader();

// Prepare the 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>"+
"<Execute xmlns='http://schemas.microsoft.com/crm/2007/WebServices'>"+
"<Request xsi:type='AddItemCampaignRequest'>"+
"<CampaignId>"+CampaignId+"</CampaignId>"+
"<EntityId>"+EntityId+"</EntityId>"+
"<EntityName>"+EntityName+"</EntityName>"+
"</Request>"+
"</Execute>"+
"</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/Execute");
xHReq.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xHReq.setRequestHeader("Content-Length", xml.length);
xHReq.send(xml);
// Capture the result.
var resultXml = xHReq.responseXML;

// Check for errors.
var errorCount = resultXml.selectNodes('//error').length;
if (errorCount != 0)
{
var msg = resultXml.selectSingleNode('//description').nodeTypedValue;
alert(msg);
}
// Display a confirmation message and open the campaign record.
else
{
alert("Product with id = "+EntityId+" successfully added to Campaign with id = "+CampaignId+".");
window.open("/ma/camps/edit.aspx?id={"+CampaignId+"}");
}

Enjoy,
Rami Heleg

Delete Entity in Client Side ( Java Script only)

2009-12-29T22:01:00.000+02:00

Hi,
here is an example to delete entity only in client side:

// Identify the contact to delete.
var contactid = "57a4e111-7027-dd11-b452-0003ff9ee217";
var authenticationHeader = GenerateAuthenticationHeader();

// Prepare the 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>"+
"<Delete xmlns='http://schemas.microsoft.com/crm/2007/WebServices'>"+
"<entityName>contact</entityName>"+
"<id>"+contactid+"</id>"+
"</Delete>"+
"</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/Delete");
xHReq.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xHReq.setRequestHeader("Content-Length", xml.length);
xHReq.send(xml);
// Capture the result,
var resultXml = xHReq.responseXML;

// Check for errors,
var errorCount = resultXml.selectNodes('//error').length;
if (errorCount != 0)
{
var msg = resultXml.selectSingleNode('//description').nodeTypedValue;
alert(msg);
}
// Display confirmation message.
else
{
alert("Contact with id = "+contactid+" successfully deleted");
}

Enjoy,
Rami Heleg

Create Entity in client side ( Java Script only)

2009-12-29T21:57:00.000+02:00

Hi,
here is an example of create entity only in client side:

// Prepare values for the new contact.

var firstname = "Jesper";
var lastname = "Aaberg";
var donotbulkemail = "true";
var address1_stateorprovince = "MT";
var address1_postalcode = "99999";
var address1_line1 = "23 Market St.";
var address1_city = "Sammamish";
var authenticationHeader = GenerateAuthenticationHeader();

// Prepare the 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>"+
"<Create xmlns='http://schemas.microsoft.com/crm/2007/WebServices'>"+
"<entity xsi:type='contact'>"+
"<address1_city>"+address1_city+"</address1_city>"+
"<address1_line1>"+address1_line1+"</address1_line1>"+
"<address1_postalcode>"+address1_postalcode+"</address1_postalcode>"+
"<address1_stateorprovince>"+address1_stateorprovince+"</address1_stateorprovince>"+
"<donotbulkemail>"+donotbulkemail+"</donotbulkemail>"+
"<firstname>"+firstname+"</firstname>"+
"<lastname>"+lastname+"</lastname>"+
"</entity>"+
"</Create>"+
"</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/Create");
xHReq.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xHReq.setRequestHeader("Content-Length", xml.length);
xHReq.send(xml);
// Capture the result
var resultXml = xHReq.responseXML;

// Check for errors.
var errorCount = resultXml.selectNodes('//error').length;
if (errorCount != 0)
{
var msg = resultXml.selectSingleNode('//description').nodeTypedValue;
alert(msg);
}
// Open new contact record if no errors.
else
{
var contactid = resultXml.selectSingleNode("//CreateResult");
window.open("/sfa/conts/edit.aspx?id={"+contactid.nodeTypedValue+"}");
}

Enjoy,
Rami Heleg

How to add supported JavaScript to pages.

2009-12-22T21:52:00.000+02:00

Example how to add to pages JS supported by Microsoft:

1.
Create Folder under ISV

2.
add JavaScript code to page:

3.
add the next code into contact page:
var request = new ActiveXObject("Msxml2.XMLHTTP");
request.open("GET", "/isv/MyScripts/contact.js", false);
request.send(null);
eval(request.responseText);

For instance:

4.
open contact page and get the message.

Enjoy,
Rami Heleg

How to init Value on Server side

2009-12-22T21:37:00.000+02:00

This example contain how to init all CRM Values:
CrmDateTime lDateTime = new CrmDateTime("2009/8/27T17:00:00");

CrmBoolean lBoolean = new CrmBoolean(true);

Picklist lList = new Picklist(1);

CrmDecimal lDec = new CrmDecimal(10.1);

CrmFloat lfloat = new CrmFloat(10.2);

CrmNumber lNumber = new CrmNumber(10);

Lookup oSys = new Lookup("systemuser", userId);

Owner owner = new Owner("systemuser", systemUserId);

Status lStatus = new Status(1);

EntityNameReference oReference = new EntityNameReference("systemuser");

Key key = new Key(userId);

CrmMoney lMoney = new CrmMoney(10.00);

Enjoy,
Rami Heleg

Crm 4.0 Microsoft CRM Asynchronous failed and require restart

2009-12-03T15:04:00.000+02:00

Hi
Error Message:

Exception type: CrmException
Exception message: The key specified to compute a hash value is expired, only active keys are valid. Expired Key : CrmKey(Id:c1bef2e2-efc5-de11-b538-005056a75caa, ScaleGroupId:00000000-0000-0000-0000-000000000000,
KeyType:CrmWRPCTokenKey, Expired:True, ValidOn:10/31/2009 07:34:57, ExpiresOn:12/03/2009 07:34:57, CreatedOn:10/31/2009 07:34:57, CreatedBy:NT AUTHORITY\NETWORK SERVICE.

This problem occurs because Microsoft Dynamics CRM 4.0 uses the name of the SQL server that is in the organization table of the mscrm_config database when Microsoft Dynamics CRM 4.0 tries to connect to the SQL server. If the name is lowercase, the Async service cannot correctly process the jobs in the ScaleGroupOrganizationMaintenanceJobs table. The SqlServerName name must be the same as the value that is returned by the @@servername global variable.

Because of that the solution is to install Rollup 7.0

Microsoft Articles:

<a href="http://support.microsoft.com/kb/949844"></a>
<a href="http://support.microsoft.com/kb/949256/"></a>

Thanks and enjoy,
Rami Heleg

How to change due date filter default value for activities page:

2009-12-03T14:49:00.000+02:00

Sometimes you need to define your default filter values for the home activities page.

Here is an example how to change due date filter default value:

Add this code to "\CRMWeb\Workplace\home_activities.aspx" page:

<script runat="server">
protected override void OnPreRender(EventArgs e) {
base.OnPreRender(e);
this.crmDateSelector.Selected = "Today";
this.crmGrid.Parameters.Add("scheduledend", "Today");
}
</script>

You can set these values to the crmDateSelector control:
Overdue
Today
Tomorrow
NextXDays;7
NextXDays;30
NextXDays;90
NextXMonths;6
NextXMonths;12
All

thanks,
Max Shafranski,
Team blog member.

List of events for each entity.

2009-12-02T14:15:00.000+02:00

List of events for each entity.

Message Primary Entity
AddItem Campaign
AddItem CampaignActivity
AddMember List
AddMembers Team
AddProductToKit NULL
Assign Account
Assign Annotation
Assign Appointment
Assign Campaign
Assign CampaignActivity
Assign CampaignResponse
Assign Contact
Assign Contract
Assign CustomerOpportunityRole
Assign CustomerRelationship
Assign Email
Assign Fax
Assign Incident
Assign IncidentResolution
Assign Invoice
Assign Lead
Assign Letter
Assign List
Assign Opportunity
Assign OpportunityClose
Assign OrderClose
Assign PhoneCall
Assign Quote
Assign QuoteClose
Assign SalesOrder
Assign ServiceAppointment
Assign Task
Assign Template
Assign UserQuery
BackgroundSend Email
Book Appointment
Book ServiceAppointment
Cancel Contract
Cancel SalesOrder
CheckIncoming Email
CheckPromote Email
Clone Contract
Close Incident
Close Quote
Create Account
Create ActivityMimeAttachment
Create Annotation
Create Appointment
Create BusinessUnit
Create BusinessUnitNewsArticle
Create Calendar
Create Campaign
Create CampaignActivity
Create CampaignResponse
Create Competitor
Create Contact
Create Contract
Create ContractDetail
Create ContractTemplate
Create custom entity
Create CustomerAddress
Create CustomerOpportunityRole
Create CustomerRelationship
Create Discount
Create DiscountType
Create Email
Create Equipment
Create Fax
Create Incident
Create IncidentResolution
Create Invoice
Create InvoiceDetail
Create KbArticle
Create KbArticleComment
Create KbArticleTemplate
Create Lead
Create Letter
Create List
Create Opportunity
Create OpportunityClose
Create OpportunityProduct
Create OrderClose
Create PhoneCall
Create PriceLevel
Create Product
Create ProductPriceLevel
Create Queue
Create Quote
Create QuoteClose
Create QuoteDetail
Create Role
Create SalesLiterature
Create SalesLiteratureItem
Create SalesOrder
Create SalesOrderDetail
Create Service
Create ServiceAppointment
Create Site
Create Subject
Create SystemUser
Create Task
Create Team
Create Template
Create Territory
Create TransactionCurrency
Create UoM
Create UoMSchedule
CreateUoMSchedule UoMSchedule
Delete Account
Delete ActivityMimeAttachment
Delete Annotation
Delete Appointment
Delete BusinessUnitNewsArticle
Delete Calendar
Delete Campaign
Delete CampaignActivity
Delete CampaignResponse
Delete Competitor
Delete Contact
Delete Contract
Delete ContractDetail
Delete ContractTemplate
Delete custom entity
Delete CustomerAddress
Delete CustomerOpportunityRole
Delete CustomerRelationship
Delete Discount
Delete DiscountType
Delete Email
Delete Equipment
Delete Fax
Delete Incident
Delete IncidentResolution
Delete Invoice
Delete InvoiceDetail
Delete KbArticle
Delete KbArticleComment
Delete KbArticleTemplate
Delete Lead
Delete Letter
Delete List
Delete Opportunity
Delete OpportunityClose
Delete OpportunityProduct
Delete OrderClose
Delete PhoneCall
Delete PriceLevel
Delete Product
Delete ProductPriceLevel
Delete Queue
Delete Quote
Delete QuoteClose
Delete QuoteDetail
Delete Role
Delete SalesLiterature
Delete SalesLiteratureItem
Delete SalesOrder
Delete SalesOrderDetail
Delete Service
Delete ServiceAppointment
Delete Site
Delete Subject
Delete Task
Delete Template
Delete Territory
Delete TransactionCurrency
Delete UoM
Delete UoMSchedule
Delete UserQuery
DeliverIncoming Email
DeliverPromote Email
DetachFromQueue Email
Execute NULL
ExecuteById SavedQuery
ExecuteById UserQuery
Export NULL
ExportAll NULL
ExportCompressed NULL
ExportCompressedAll NULL
GrantAccess Account
GrantAccess Annotation
GrantAccess Appointment
GrantAccess Campaign
GrantAccess CampaignActivity
GrantAccess CampaignResponse
GrantAccess Contact
GrantAccess Contract
GrantAccess CustomerOpportunityRole
GrantAccess CustomerRelationship
GrantAccess Email
GrantAccess Fax
GrantAccess Incident
GrantAccess IncidentResolution
GrantAccess Invoice
GrantAccess Lead
GrantAccess Letter
GrantAccess List
GrantAccess Opportunity
GrantAccess OpportunityClose
GrantAccess OrderClose
GrantAccess PhoneCall
GrantAccess Quote
GrantAccess QuoteClose
GrantAccess SalesOrder
GrantAccess ServiceAppointment
GrantAccess Task
GrantAccess Template
GrantAccess UserQuery
Handle Appointment
Handle CampaignActivity
Handle CampaignResponse
Handle Email
Handle Fax
Handle Incident
Handle Letter
Handle PhoneCall
Handle ServiceAppointment
Handle Task
Import NULL
ImportAll NULL
ImportCompressedAll NULL
ImportCompressedWithProgress NULL
ImportWithProgress NULL
LockInvoicePricing NULL
LockSalesOrderPricing NULL
Lose Opportunity
Merge Account
Merge Contact
Merge Lead
ModifyAccess Account
ModifyAccess Annotation
ModifyAccess Appointment
ModifyAccess Campaign
ModifyAccess CampaignActivity
ModifyAccess CampaignResponse
ModifyAccess Contact
ModifyAccess Contract
ModifyAccess CustomerOpportunityRole
ModifyAccess CustomerRelationship
ModifyAccess Email
ModifyAccess Fax
ModifyAccess Incident
ModifyAccess IncidentResolution
ModifyAccess Invoice
ModifyAccess Lead
ModifyAccess Letter
ModifyAccess List
ModifyAccess Opportunity
ModifyAccess OpportunityClose
ModifyAccess OrderClose
ModifyAccess PhoneCall
ModifyAccess Quote
ModifyAccess QuoteClose
ModifyAccess SalesOrder
ModifyAccess ServiceAppointment
ModifyAccess Task
ModifyAccess Template
ModifyAccess UserQuery
Publish NULL
PublishAll NULL
RemoveBinaryData ActivityMimeAttachment
RemoveBinaryData Annotation
RemoveBinaryData SalesLiteratureItem
RemoveItem Campaign
RemoveItem CampaignActivity
RemoveMember List
RemoveMembers Team
RemoveProductFromKit NULL
RemoveRelated Invoice
RemoveRelated Lead
RemoveRelated Lead
RemoveRelated Opportunity
RemoveRelated Opportunity
RemoveRelated Opportunity
RemoveRelated Product
RemoveRelated Product
RemoveRelated Quote
RemoveRelated SalesLiterature
RemoveRelated SalesLiterature
RemoveRelated SalesOrder
Reschedule Appointment
Reschedule ServiceAppointment
Retrieve Account
Retrieve ActivityMimeAttachment
Retrieve ActivityPointer
Retrieve Annotation
Retrieve Appointment
Retrieve BusinessUnitNewsArticle
Retrieve Calendar
Retrieve Campaign
Retrieve CampaignActivity
Retrieve CampaignResponse
Retrieve Competitor
Retrieve Contact
Retrieve Contract
Retrieve ContractDetail
Retrieve ContractTemplate
Retrieve custom entity
Retrieve CustomerAddress
Retrieve CustomerOpportunityRole
Retrieve CustomerRelationship
Retrieve Discount
Retrieve DiscountType
Retrieve Email
Retrieve Equipment
Retrieve Fax
Retrieve Incident
Retrieve IncidentResolution
Retrieve Invoice
Retrieve InvoiceDetail
Retrieve KbArticle
Retrieve KbArticleComment
Retrieve KbArticleTemplate
Retrieve Lead
Retrieve Letter
Retrieve List
Retrieve Opportunity
Retrieve OpportunityClose
Retrieve OpportunityProduct
Retrieve OrderClose
Retrieve PhoneCall
Retrieve PriceLevel
Retrieve Product
Retrieve ProductPriceLevel
Retrieve Queue
Retrieve Quote
Retrieve QuoteClose
Retrieve QuoteDetail
Retrieve SalesLiterature
Retrieve SalesLiteratureItem
Retrieve SalesOrder
Retrieve SalesOrderDetail
Retrieve SavedQuery
Retrieve Service
Retrieve ServiceAppointment
Retrieve Site
Retrieve Subject
Retrieve Task
Retrieve Team
Retrieve Template
Retrieve Territory
Retrieve UoM
Retrieve UoMSchedule
Retrieve UserQuery
RetrieveExchangeRate NULL
RetrieveMultiple Account
RetrieveMultiple ActivityMimeAttachment
RetrieveMultiple ActivityPointer
RetrieveMultiple Annotation
RetrieveMultiple Appointment
RetrieveMultiple BusinessUnitNewsArticle
RetrieveMultiple Calendar
RetrieveMultiple Campaign
RetrieveMultiple CampaignActivity
RetrieveMultiple CampaignResponse
RetrieveMultiple Competitor
RetrieveMultiple Contact
RetrieveMultiple Contract
RetrieveMultiple ContractDetail
RetrieveMultiple ContractTemplate
RetrieveMultiple custom entity
RetrieveMultiple CustomerAddress
RetrieveMultiple CustomerOpportunityRole
RetrieveMultiple CustomerRelationship
RetrieveMultiple Discount
RetrieveMultiple DiscountType
RetrieveMultiple Email
RetrieveMultiple Equipment
RetrieveMultiple Fax
RetrieveMultiple Incident
RetrieveMultiple IncidentResolution
RetrieveMultiple Invoice
RetrieveMultiple InvoiceDetail
RetrieveMultiple KbArticle
RetrieveMultiple KbArticleComment
RetrieveMultiple KbArticleTemplate
RetrieveMultiple Lead
RetrieveMultiple Letter
RetrieveMultiple List
RetrieveMultiple Opportunity
RetrieveMultiple OpportunityClose
RetrieveMultiple OpportunityProduct
RetrieveMultiple OrderClose
RetrieveMultiple PhoneCall
RetrieveMultiple PriceLevel
RetrieveMultiple Product
RetrieveMultiple ProductPriceLevel
RetrieveMultiple Queue
RetrieveMultiple Quote
RetrieveMultiple QuoteClose
RetrieveMultiple QuoteDetail
RetrieveMultiple SalesLiterature
RetrieveMultiple SalesLiteratureItem
RetrieveMultiple SalesOrder
RetrieveMultiple SalesOrderDetail
RetrieveMultiple SavedQuery
RetrieveMultiple Service
RetrieveMultiple ServiceAppointment
RetrieveMultiple Site
RetrieveMultiple Subject
RetrieveMultiple Task
RetrieveMultiple Team
RetrieveMultiple Template
RetrieveMultiple Territory
RetrieveMultiple UoM
RetrieveMultiple UoMSchedule
RetrieveMultiple UserQuery
RetrievePrincipalAccess Account
RetrievePrincipalAccess Annotation
RetrievePrincipalAccess Appointment
RetrievePrincipalAccess Campaign
RetrievePrincipalAccess CampaignActivity
RetrievePrincipalAccess CampaignResponse
RetrievePrincipalAccess Contact
RetrievePrincipalAccess Contract
RetrievePrincipalAccess CustomerOpportunityRole
RetrievePrincipalAccess CustomerRelationship
RetrievePrincipalAccess Email
RetrievePrincipalAccess Fax
RetrievePrincipalAccess Incident
RetrievePrincipalAccess IncidentResolution
RetrievePrincipalAccess Invoice
RetrievePrincipalAccess Lead
RetrievePrincipalAccess Letter
RetrievePrincipalAccess List
RetrievePrincipalAccess Opportunity
RetrievePrincipalAccess OpportunityClose
RetrievePrincipalAccess OrderClose
RetrievePrincipalAccess PhoneCall
RetrievePrincipalAccess Quote
RetrievePrincipalAccess QuoteClose
RetrievePrincipalAccess SalesOrder
RetrievePrincipalAccess ServiceAppointment
RetrievePrincipalAccess Task
RetrievePrincipalAccess Template
RetrievePrincipalAccess UserQuery
RetrieveSharedPrincipalsAndAccess Account
RetrieveSharedPrincipalsAndAccess Annotation
RetrieveSharedPrincipalsAndAccess Appointment
RetrieveSharedPrincipalsAndAccess Campaign
RetrieveSharedPrincipalsAndAccess CampaignActivity
RetrieveSharedPrincipalsAndAccess CampaignResponse
RetrieveSharedPrincipalsAndAccess Contact
RetrieveSharedPrincipalsAndAccess Contract
RetrieveSharedPrincipalsAndAccess CustomerOpportunityRole
RetrieveSharedPrincipalsAndAccess CustomerRelationship
RetrieveSharedPrincipalsAndAccess Email
RetrieveSharedPrincipalsAndAccess Fax
RetrieveSharedPrincipalsAndAccess Incident
RetrieveSharedPrincipalsAndAccess IncidentResolution
RetrieveSharedPrincipalsAndAccess Invoice
RetrieveSharedPrincipalsAndAccess Lead
RetrieveSharedPrincipalsAndAccess Letter
RetrieveSharedPrincipalsAndAccess List
RetrieveSharedPrincipalsAndAccess Opportunity
RetrieveSharedPrincipalsAndAccess OpportunityClose
RetrieveSharedPrincipalsAndAccess OrderClose
RetrieveSharedPrincipalsAndAccess PhoneCall
RetrieveSharedPrincipalsAndAccess Quote
RetrieveSharedPrincipalsAndAccess QuoteClose
RetrieveSharedPrincipalsAndAccess SalesOrder
RetrieveSharedPrincipalsAndAccess ServiceAppointment
RetrieveSharedPrincipalsAndAccess Task
RetrieveSharedPrincipalsAndAccess Template
RetrieveSharedPrincipalsAndAccess UserQuery
RevokeAccess Account
RevokeAccess Annotation
RevokeAccess Appointment
RevokeAccess Campaign
RevokeAccess CampaignActivity
RevokeAccess CampaignResponse
RevokeAccess Contact
RevokeAccess Contract
RevokeAccess CustomerOpportunityRole
RevokeAccess CustomerRelationship
RevokeAccess Email
RevokeAccess Fax
RevokeAccess Incident
RevokeAccess IncidentResolution
RevokeAccess Invoice
RevokeAccess Lead
RevokeAccess Letter
RevokeAccess List
RevokeAccess Opportunity
RevokeAccess OpportunityClose
RevokeAccess OrderClose
RevokeAccess PhoneCall
RevokeAccess Quote
RevokeAccess QuoteClose
RevokeAccess SalesOrder
RevokeAccess ServiceAppointment
RevokeAccess Task
RevokeAccess Template
RevokeAccess UserQuery
Route Appointment
Route CampaignActivity
Route CampaignResponse
Route Email
Route Fax
Route Incident
Route Letter
Route PhoneCall
Route ServiceAppointment
Route Task
Send Email
Send Fax
Send Template
SendFromTemplate Email
SetRelated Invoice
SetRelated Lead
SetRelated Lead
SetRelated Opportunity
SetRelated Opportunity
SetRelated Opportunity
SetRelated Product
SetRelated Product
SetRelated Quote
SetRelated SalesLiterature
SetRelated SalesLiterature
SetRelated SalesOrder
SetState Account
SetState Appointment
SetState BusinessUnit
SetState Campaign
SetState CampaignActivity
SetState CampaignResponse
SetState Contact
SetState Contract
SetState ContractDetail
SetState custom entity
SetState DiscountType
SetState Email
SetState Fax
SetState Incident
SetState IncidentResolution
SetState Invoice
SetState KbArticle
SetState Lead
SetState Letter
SetState List
SetState Opportunity
SetState OpportunityClose
SetState OrderClose
SetState PhoneCall
SetState PriceLevel
SetState Product
SetState Quote
SetState QuoteClose
SetState SalesOrder
SetState ServiceAppointment
SetState Task
SetState TransactionCurrency
SetState UserQuery
SetStateDynamicEntity Account
SetStateDynamicEntity Appointment
SetStateDynamicEntity BusinessUnit
SetStateDynamicEntity Campaign
SetStateDynamicEntity CampaignActivity
SetStateDynamicEntity CampaignResponse
SetStateDynamicEntity Contact
SetStateDynamicEntity Contract
SetStateDynamicEntity ContractDetail
SetStateDynamicEntity custom entity
SetStateDynamicEntity DiscountType
SetStateDynamicEntity Email
SetStateDynamicEntity Fax
SetStateDynamicEntity Incident
SetStateDynamicEntity IncidentResolution
SetStateDynamicEntity Invoice
SetStateDynamicEntity KbArticle
SetStateDynamicEntity Lead
SetStateDynamicEntity Letter
SetStateDynamicEntity List
SetStateDynamicEntity Opportunity
SetStateDynamicEntity OpportunityClose
SetStateDynamicEntity OrderClose
SetStateDynamicEntity PhoneCall
SetStateDynamicEntity PriceLevel
SetStateDynamicEntity Product
SetStateDynamicEntity Quote
SetStateDynamicEntity QuoteClose
SetStateDynamicEntity SalesOrder
SetStateDynamicEntity ServiceAppointment
SetStateDynamicEntity Task
SetStateDynamicEntity TransactionCurrency
SetStateDynamicEntity UserQuery
UnlockInvoicePricing NULL
UnlockSalesOrderPricing NULL
Update Account
Update ActivityMimeAttachment
Update Annotation
Update Appointment
Update BusinessUnit
Update BusinessUnitNewsArticle
Update Calendar
Update Campaign
Update CampaignActivity
Update CampaignResponse
Update Competitor
Update Contact
Update Contract
Update ContractDetail
Update ContractTemplate
Update CustomerAddress
Update CustomerOpportunityRole
Update CustomerRelationship
Update Discount
Update DiscountType
Update Email
Update Equipment
Update Fax
Update Incident
Update IncidentResolution
Update Invoice
Update InvoiceDetail
Update KbArticle
Update KbArticleComment
Update KbArticleTemplate
Update Lead
Update Letter
Update List
Update Opportunity
Update OpportunityClose
Update OpportunityProduct
Update OrderClose
Update Organization
Update PhoneCall
Update PriceLevel
Update Product
Update ProductPriceLevel
Update Queue
Update Quote
Update QuoteClose
Update QuoteDetail
Update Role
Update SalesLiterature
Update SalesLiteratureItem
Update SalesOrder
Update SalesOrderDetail
Update Service
Update ServiceAppointment
Update Site
Update Subject
Update SystemUser
Update Task
Update Team
Update Template
Update Territory
Update TransactionCurrency
Update UoM
Update UoMSchedule
Update UserQuery
UploadFromBase64Data ActivityMimeAttachment
UploadFromBase64Data Annotation
UploadFromBase64Data SalesLiteratureItem
Win Opportunity
Win Quote

Enjoy,
Rami Heleg

How to get entity instance id in CRM 4.0 plugin for each message type

2009-12-02T14:05:00.000+02:00

This example help to get instance id for each type of event:

Massage name “Create”:

Guid instanceID = new Guid(context.OutputParameters.Properties["id"].ToString());

Massage name “Update”:

Guid instanceID = (Guid)((Microsoft.Crm.Sdk.Key)((Microsoft.Crm.Sdk.DynamicEntity)context.InputParameters.Properties["Target"]).Properties[context.PrimaryEntityName + "id"]).Value;

Massage name “SetState”:

Guid instanceID = new Guid(context.OutputParameters.Properties["id"].ToString());

Massage name “Assign”:

Guid instanceID = vInstanceID = (Guid)((Microsoft.Crm.Sdk.Moniker)context.InputParameters.Properties["Target"]).Id;

Massage name “Delete”:

instanceID = ((Microsoft.Crm.Sdk.Moniker)context.InputParameters.Properties["Target"]).Id;

Massage name “Close”:

Guid instanceID = ((Microsoft.Crm.Sdk.Lookup)((Microsoft.Crm.Sdk.DynamicEntity)context.InputParameters.Properties["IncidentResolution"]).Properties[context.PrimaryEntityName + "id"]).Value;

Massage name “Route”:

Guid instanceID = ((Microsoft.Crm.Sdk.Moniker)context.InputParameters.Properties["Target"]).Id;

Massage name “SetStateDynamicEntity”:

Guid instanceID = ((Microsoft.Crm.Sdk.Moniker)context.InputParameters.Properties["EntityMoniker"]).Id;

Enjoy,
Rami Heleg

Allow to CRM 4.0 to pass( add) parameters to query string.

2009-11-29T21:06:00.000+02:00

Hi,
CRM 4.0 disabled option to add parameters in query string.

to change this option need to change register.
goto Start - Run write -> regedit ( register)

Edit the registry in:
HKEY_Local_Machine\Software\Microsoft\MSCRM
Add a new DWORD
"DisableParameterFilter"
set value to 1.‬

this changes will help to add parameters in query string.

Enjoy,
Rami Heleg

Create Annotation with File

2009-11-17T22:46:00.000+02:00

Here is an example to create Annotation:

annotation n = new annotation();

n.objectid = new Lookup();
//define to which entity
n.objectid.Value = new Guid(EntityId);
attach to specific entity
n.objecttypecode = new EntityNameReference();
n.objecttypecode.Value = EntityType;

//Create
Guid noteID = pService.Create(n);

//open and read file
FileInfo file = new FileInfo(fileP);
FileStream fs = file.OpenRead();
byte[] byteData = new byte[fs.Length];
fs.Read(byteData, 0, byteData.Length);
fs.Close();

string encodedData = System.Convert.ToBase64String(byteData);

//Create the Request Object
UploadFromBase64DataAnnotationRequest upload = new
UploadFromBase64DataAnnotationRequest();

//Set the Request Object's Properties
upload.AnnotationId = noteID;
upload.FileName = file.Name;
upload.MimeType = "text/plain";
upload.Base64Data = encodedData;

//Execute the Request
UploadFromBase64DataAnnotationResponse uploaded =
(UploadFromBase64DataAnnotationResponse)pService.Execute(upload);

Entity contain annotation + file.

enjoy,
Rami Heleg

Use setInterval, clearInterval in CRM 3/4

2009-11-12T17:04:00.000+02:00

Using setInterval if very helpful and powerfull when develop javascript in CRM 3/4.

Special target is to load forms very fast and make other code after user start to work.

This example contain two functions.
loadMyPage() and afterLoading()

function loadMyPage() call to function afterLoading() with interval of one second.

After second function afterLoading() is working..

Don’t forget to make the clearInterval.. clear calling.

function afterLoading() {
window.clearInterval(common_init_interval);
}

function loadMyPage(){
common_init_interval = setInterval('try { afterLoading (); } catch (e) { }', 1000);
}

Enjoy,
Rami Heleg

Handle Grid in IFRAME

2009-11-12T16:51:00.000+02:00

Here is an example how to handle grid (like area grid) in IFRAME.

Add these 2 rows where form is loaded to get handle of the iframe

var iframe = document.getElementById('IFRAME_test');
iframe.onreadystatechange = FrameStateChanged;

function to handle iframe state changed like initalize, complete

function FrameStateChanged()
{
var iframe = document.getElementById('IFRAME_test');
if(iframe.readyState == "complete"){
// get grid from iframe
caseGrid = iframe.contentWindow.document.getElementById('crmGrid');
if (caseGrid != null)
caseGrid.attachEvent("onselectionchange",HandleGridSelectionChange);
}
}

// get guid from selected row.. can get all values.
function HandleGridSelectionChange()
{
//select row
var selectedRow = caseGrid.InnerGrid.SelectedRecords;
// get selected guid
if (selectedRow.length > 0)
var guid =selectedRow[0][0];

}

Enjoy,
Rami Heleg

Replace tags to support legal JS page

2009-11-07T16:24:00.000+02:00

The options to change string to be XML legal value:

Thanks,
Rami Heleg

Call from Javascript to Server via WCF/XML

2009-11-04T22:29:00.000+02:00

Here is a simple example of calling to server from javascript side based WCF,XML

This example contain 3 options:
· Return string from server
· Return object from server
· Send object to server

1. create a new project name = ‘wcf2’

2. add new aspx page name Default.aspx.

3. paste code to javascript:

4. create new wcf service name 'Service.svc'

5. paste code the interface fileusing System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.Text;
using System.ServiceModel.Web;

// NOTE: If you change the interface name "IService" here, you must also update the reference to "IService" in Web.config.
[ServiceContract]
public interface IService
{
[OperationContract]
string GetsProperty1();
[OperationContract]
[WebInvoke(Method = "POST", RequestFormat = WebMessageFormat.Xml,
ResponseFormat = WebMessageFormat.Xml,
BodyStyle = WebMessageBodyStyle.Wrapped,
UriTemplate = "/Person")]
Person GetDTO();

///

/// This is not working a real post. it still goes to the quesry string
///

[OperationContract]
[WebInvoke(Method = "POST", RequestFormat = WebMessageFormat.Xml,
ResponseFormat = WebMessageFormat.Xml,
BodyStyle = WebMessageBodyStyle.Wrapped,
UriTemplate = "Person2?Property1={sProperty1}&Property2={nProperty2}&Property3={bProperty3}")]
Person GetDTO2(string sProperty1, int nProperty2, bool bProperty3);

[OperationContract]
[WebInvoke(Method = "POST", RequestFormat = WebMessageFormat.Xml,
ResponseFormat = WebMessageFormat.Xml,
BodyStyle = WebMessageBodyStyle.Wrapped,
UriTemplate = "Person4?Property1={sProperty1}&Property2={nProperty2}&Property3={bProperty3}")]
Person GetDTO4(string sProperty1, int nProperty2, bool bProperty3);
}

// Use a data contract as illustrated in the sample below to add composite types to service operations.
[DataContract]
public class Person
{
[DataMember]
public string sProperty1 = "123";

[DataMember]
public int nProperty2 = 123;

[DataMember]
public bool bProperty3 = true;

}

6. paste code to service fileusing System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.Text;
using System.Text;
using System.IO;

// NOTE: If you change the class name "Service" here, you must also update the reference to "Service" in Web.config and in the associated .svc file.
public class Service : IService
{
private Person oPerson = new Person();

public string GetsProperty1()
{
return oPerson.sProperty1;
}
public Person GetDTO()
{
return this.oPerson;
}

public Person GetDTO2(string sProperty1, int nProperty2, bool bProperty3)
{
return this.oPerson;
}

public Person GetDTO4(string sProperty1, int nProperty2, bool bProperty3)
{
return this.oPerson;
}

public int GetDTO3(string sProperty1, int nProperty2, bool bProperty3)
{
return 590;
}
}
7. run project when default.aspx file is the startup page....
good luck,
Rami Heleg

Allow to Work with all CRM DB tables

2009-11-03T13:00:00.000+02:00

Hi

I try to ask tables in CRM which I am not Authorized to ask.. what can I do?

You need to wrap the Query, Insert etc with this example

WindowsImpersonationContext impersonation = WindowsIdentity.Impersonate(IntPtr.Zero);
try {
// my code
} finally {
impersonation.Undo();
}

This solution will help you to work with all Database, CRM tables.

Enjoy,
Rami Heleg

How to get systemuser details in Plugin

2009-11-03T12:42:00.000+02:00

Hi,
Here is an example how to get data in plugin code from server.
the example used to get info from systemuser table, but can be for every type of entity.

public static string GetUserFullName(IPluginExecutionContext context) {
try {
ICrmService service = context.CreateCrmService(false);
ColumnSetBase columns = new AllColumns();
systemuser oSystemUser = (systemuser)service.Retrieve("systemuser", context.UserId, columns);
return oSystemUser.fullname;
} catch (Exception ex) {
return ex.Message;
}

Enjoy,
Rami Heleg

Property ForceSubmit

2009-11-03T12:27:00.000+02:00

CRM Send parameters from client to server only if IsDirty = true, it means fields has been changed.

this issue good for performance.
to send field value any way to server need to change field property like this example:
crmForm.all.firstname.ForceSubmit = true;

like that if field is disabled or contain the same value the value sent any way to server.

thanks,
Rami Heleg.

Fetch Query

2009-10-31T12:04:00.000+02:00

Fetch is an option to ask CRM information's.

To get information from CRM we can
1. Ask directly from DB
2. SDK for BE
3. Fetch.

To build fetch the best option is to build the fetch from Advanced find, see attached picture to get the fetch:
Write: javascript:alert(advFind.FetchXml)

Here are two examples to for query:

How to pass information from steps 10 (pre) and post(50) in CRM Plug In

2009-10-11T22:13:00.000+02:00

Here is an example how to pass information between pre and post ( 10- 50).

Object context contain SharedVariables.

Set values in 10 like this example code:
context.SharedVariables["myvalue"] = “rami Heleg”;

Read value in 50 ( post) like this example code:
string name = context.SharedVariables["status"].ToString();

Can be used for status win or Lose... or for closing incident and needs "IncidentResolution".

Thanks,
Rami Heleg

How to create CRM Plug In in CRM 4.0

2009-10-11T22:07:00.000+02:00

1. Create a new project from type “class Library”

2. Create a new class with name : “MyExample”

3. Paste this code in new class.

using System;
using Microsoft.Crm.Sdk;
using Microsoft.Crm.SdkTypeProxy;

namespace MyExample{

public class AuditPlugin: IPlugin
{
public void Execute(IPluginExecutionContext context)
{
//start my code.
}
}
}

4. Compile and now the dll is ready to install with register tool.

Thanks,
Rami Heleg

Example of using XElement to create xml.

2009-10-07T14:06:00.000+02:00

Hi,

Here is an example of using XElement to create xml.

The example is building xml, root, nodes and attributes.

The example is very very simple to make it in 2-3 rows

Requirement: Framework 3.5

using System.Xml.Linq;

example:

XElement element = new XElement("root");
element.Add(new XElement("MyNode",
new XAttribute("attr1", "value1"),
new XAttribute("attr2", "value2")));

element.Add(new XElement("MyNode2",
new XAttribute("attr1", "value3"),
new XAttribute("attr2", "value4")));
//xml is ready
element.ToString()

thanks
Rami Heleg,

How to prevent SQL Timeout expired in Microsoft Dynamics CRM:

2009-10-04T22:26:00.000+02:00

One of the problems when working with CRM and SQL is when making a complex Select/Query CRM get SQL time out.

The solution is define timeout in register.

1. Open regedit ( start - > write ( regedit) ) and press ok

2. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM

3. Add DWORD name OLEDBTimeout with value 86400 ( 24 hours) select decimal

4. Add DWORD name ExtendedTimeout with value 1000000. The maximum value can be 2,147,483,647 and the default value is 30 seconds

This changes in register should fix the SQL timeout.

Thanks,
Rami Heleg.

What is the property deletionstatecode ?

2009-10-01T21:34:00.000+02:00

How can I remove from crm database record and not with delete command?

Each entity in CRM 4.0 includes two tables, base and extension.
In base table the columns are the same. statecode,guid,createdon...

One of the columns is deletationstatecode.

Deletionstatecode define if record is live in CRM or should be deleted.

Deletionstatecode = 0 record exist and live in CRM
Deletionstatecode = 2 record should e removed.

One of the services responsoble to remove all the record where deletionstatecode =2.
The if I need to remove many records in crm direct from database change the deletionstatecode to 2 and record will be removed after job finished.

Thanks,
Rami Heleg

Create log - first option in Event Viewer

2009-09-30T23:01:00.001+02:00

Hi,

There are several options for writing logs

1. Create log in event viewer
2. Create log in file
3. Create log in entity log

Here is an example of writing log in event viewer

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Diagnostics;

namespace WriteToEventLog {
class Program {
static void Main(string[] args) {
string eventViewerName = "EventViewerName";
string sourceName = "Project name";
string message = "My Message";

if (!EventLog.SourceExists(sourceName))
EventLog.CreateEventSource(sourceName, eventViewerName);

EventLog.WriteEntry(sourceName, message);
EventLog.WriteEntry(sourceName, message, EventLogEntryType.Warning, 1100);
EventLog.WriteEntry(sourceName, message, EventLogEntryType.Error,45454);
}
}
}

Thanks
Rami Heleg.

2009-09-25T15:13:00.000+03:00

Problem:
Running server-side code developments under CRM Server folder get Error 401 – Unauthorized.

This is a problem I've seen several times.
if you try to run the same code not under CRM folder and it works fine here is the Solution:

To solve this error need to make change in Microsoft CRM 4.0 web config:

What to add:

Thanks,
Rami Heleg

CRM Screens freeze- Stuck

2009-09-25T15:03:00.000+03:00

Try to open CRM Form usually edit.aspx page with a few iframes.

in some cases screen Stuck.

The reason for that is internet explorer Settings.
The default connection for internet explorer is two. It means the main form request data + one of the iframes then other iframes wait.. this problem Causes CRM to be freeze.

Solution:
Change the default values:
Open register page:
1. Go to start - > run and Type regedit:
2. Define MaxConnectionsPer1_0Server and MaxConnectionsPerServer like the following example

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings] MaxConnectionsPer1_0Server = dword: 0000000a
MaxConnectionsPerServer = dword: 0000000a

Thanks,

Rami Heleg

Update entity Based Micorost CRM SDK

2009-09-22T08:48:00.000+03:00

Hi,
This example used to update record in crm 3.0 and crm 4.0 based SDK

//Create crm service
CrmService pService = new CrmService(); // optional to set url

// define entity + fields. mandatory field is key
incident oInc = new incident();
oInc.incidentid = new Key();
oInc.incidentid.Value = new Guid("guid");
oInc.title="my title"

pService.Update(oInc);

update Can get specific entity for instance contact, incident or dynamic entity.
all type of BusinessEntity.

thanks,
Rami Heleg

Create Entity Based Microsoft CRM SDK

2009-09-21T21:52:00.000+03:00

Hi,
this example used to create a new record in crm 4,3 based CRM SDK.

//Create CRM Service
CrmService pService = new CrmService(); // optional to set url BusinessEntity

//Define entity and add values..
contact oContact = new contact();
oContact.firstname = "Rami";
oContact.lastname = "Heleg";

//Run method to create the entity.
Guid guid = pService.Create(entity);
//guid of the new record.

Thanks,
Rami Heleg

Using SDK to delete entity record via Dynamic entity

2009-09-21T13:46:00.000+03:00

This Example help to delete record using SDK function.

DeleteRequest request = new DeleteRequest();
TargetDeleteDynamic target = new TargetDeleteDynamic();
target.EntityName = entityTypeName;
target.EntityId = instanceID;
request.Target = target;
pservice.Execute(request);

Enjoy,
Rami Heleg

RetrieveMultipleResponse - Query example.

2009-09-21T08:34:00.000+03:00

Example of query on server side.

//Create Condition.. can be many conditions + type of operator
ConditionExpression[] conditions = new ConditionExpression[1];
ConditionExpression condition = new ConditionExpression();
condition.AttributeName = fullname;
condition.Operator = ConditionOperator.Equal;
condition.Values = new object[] { "Rami Heleg" };
conditions[i] = condition;
FilterExpression filter = new FilterExpression();
filter.FilterOperator = LogicalOperator.And;
filter.Conditions = conditions;
QueryExpression query = new QueryExpression();

//Entity name
query.EntityName = "contact";

//allow to define specific columns
query.ColumnSet = new AllColumns();
query.Criteria = filter;
RetrieveMultipleRequest request = new RetrieveMultipleRequest();
request.ReturnDynamicEntities = false;
request.Query= query ;
//run Query
RetrieveMultipleResponse response = (RetrieveMultipleResponse)pService.Execute(service, request);
//Result
response.BusinessEntityCollection.BusinessEntities;

Thanks,
Rami Heleg

View Schema via internet explorer

2009-09-15T21:03:00.000+03:00

Hi,

Here is an example how to view schema information via internet explorer

http://servername:port/org_name/sdk/list.aspx

enable to view entities, attributes and relationships.

Thanks,
Rami Heleg

function to return on server side information regarding current system user.

2009-09-15T20:56:00.000+03:00

Example of WhoAmI for Microsoft Dynamic CRM 4.0

CrmAuthenticationToken token = new CrmAuthenticationToken();
token.AuthenticationType = 0;
token.OrganizationName = "OrganizationName";

CrmService pService = new CrmService(); // optional to set url parameter
pService.CrmAuthenticationTokenValue = token;
pService.Credentials = CredentialCache.DefaultCredentials;

WhoAmIRequest request = new WhoAmIRequest();

WhoAmIResponse oSystem= (WhoAmIResponse)pService.Execute(request);
//oSystem.UserId;
//oSystem.OrganizationId ;//

Thanks,
Rami Heleg.

Example function to Set State for Dynamic entity

2009-09-14T22:13:00.000+03:00

You can use Set State function for each entity for instance:
SetBusinessSystemUserRequest
SetAccountUserRequest
SetContactUserRequest and more.
Better is to create general function and use dynamic request
Example:
SetStateDynamicEntityRequest request = new SetStateDynamicEntityRequest();
request.Entity = new Moniker();
request.Entity.Name = entityTypeName;
request.Entity.Id = new Guid ( guid);
request.State = relevantStateCodeForSpecificEntity;
request.Status = relevantStatusForSpecificEntity;
service.Execute(request);

Enjoy,
Rami Heleg

Change Maximum tabs

2009-09-12T18:54:00.000+03:00

Hi,

CRM limit the number of tabs to 8.

To change the number:

C:\Program Files\Microsoft CRM Server\CRMWeb\Tools\FormEditor\formeditor.aspx

Need to change the parameter _iMaxTabs to required number.

Enjoy,
Rami Heleg

Shrink Javascript file

2009-09-12T18:47:00.000+03:00

to improve performance one of the options is to shrink Javascript file.
link to site that help you to shrink the file and save 30 % from file size
http://www.creativyst.com/Prod/3/.

Recommended to do it before moving to production

Thanks,
Rami Heleg

Call from Javascript to Server via WCF/Json

2009-09-12T18:32:00.000+03:00

Here is a simple example of calling to server from javascript side

1. create a new project name = 'WCFJson'
2. add new html page call HTMLPage.htm.
3. paste code to javascript:

var xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
var url = "http://localhost/WCFJson/Service.svc/rami/isExist";
var body = '{"name":"'+ "ramigggg" + '"}';
xmlHttp.open("POST", url, true);
xmlHttp.setRequestHeader("Content-type", "application/json");
xmlHttp.send(body);
xmlHttp.onreadystatechange=function(){
if(xmlHttp.readyState == 4){
alert( xmlHttp.responseText);
}
}

4. create new wcf service name 'Service.svc'
5. paste code the interface file

[ServiceContract]
public interface IService{
[OperationContract]
[WebInvoke(Method = "POST", RequestFormat = WebMessageFormat.Json,
ResponseFormat = WebMessageFormat.Json,
BodyStyle = WebMessageBodyStyle.Wrapped,
UriTemplate = "/isExist")]
bool isExist(string name);
}

6. paste code to service file

public class Service : IService
{
#region IService Members
public bool isExist(string name) {
return true;
}
#endregion
}

7. runproject when html file the the startup page....

good luck,
Rami Heleg

Attach event CRM Field

2009-09-12T10:35:00.001+03:00

Here is an example to attach event to CRM Field

Function:

Function attachEvent (elementID, eventName, handler){
var obj =document.getElementById(elementID);
if (!element)
return;
element.attachEvent(eventName, handler);
}

Call Example:
attachEvent ('firstname’, 'onchange', handleFirstNameChanged);

Enjoy,
Rami Heleg

Set mandatory to CRM fields

2009-09-12T10:23:00.000+03:00

Hi,
Here is the function to set mandatory to CRM field in Javascript

crmForm.SetFieldReqLevel(fieldName, value);

SetFieldReqLevel get 2 parameters

1. field name like firstname,createdon etc...
2. second parameter true,false.

Enjoy,
Rami Heleg

Hot to get page name in crm,js

2009-09-10T22:47:00.000+03:00

Hi,
Here is an example how to get page name.

function GetPageName() {
var sPath = window.location.pathname;
var sPage = sPath.substring(sPath.lastIndexOf('/') + 1);
return sPage;
}

Rami Heleg,

Lookup Field properties

2009-09-10T22:37:00.000+03:00

Hi,
here is the properties for lookup field in JS side

var parentIncident= new Array;
parentIncident = null;

parentIncident = crmForm.all.parentincident.DataValue;

if (parentIncident[0] != null)
{
//description
var desc = parentIncident[0].name;

//Guid
var incidentId = parentIncident[0].id;

// Object Type
var type = parentIncident[0].typename;

}

Enjoy,
Rami Heleg

crmForm, Field properties

2009-09-10T22:27:00.000+03:00

Some words regarding field ( javascript side in crm)

to get field from crm page can by via two options:

1.
var firstName = crmForm.all.firstname;
2.
var firstName= document.getElementById('firstname'); //faster

properties + events:

1. firstName.SetFocus();
set focus on field.

2. firstName.IsDirty
true/false if field changed.

3. firstName.RequiredLevel
0 == normal
1 == recommended
2 == required

4. firstName.DataValue
set/get value from field.

5. firstName.ForceSubmit
send field value to server on save any way

Enjoy,
Rami Heleg.

crmForm Property

2009-09-10T22:23:00.000+03:00

Here some words regarding crmForm properties

1. crmForm.IsDirty
if user change field in page IsDirty = true
2. crmForm.ObjectTypeName
return object name account,contact etc...
3. crmForm.ObjectTypeCode
return object key 1,2,112 etc.

Rami Heleg

crmForm FormType options

2009-09-10T22:19:00.000+03:00

Hi,
this comment for form type - mode for edit page.

crmForm.FormType return form type/mode
1 = Create
2 = Update
3 = Read Only
4 = Disabled
5 = Quick Create
6 = Bulk edit ( After select multi records and choose from menu to create...

Rami Heleg,

Reading from webconfig/app config

2009-09-10T15:59:00.000+03:00

Example how to read from web config

1. add using to page
using System.Configuration;Enjoy,
2. read from config file
string value= ConfigurationSettings.AppSettings["key"];

Enjoy,
Rami Heleg

Create Crm Service example based systemuser and organization

2009-09-10T15:56:00.000+03:00

Here function to create Crm Service example for specific systemuser and organization name

public static CrmService GetCrmService(Guid callerID,string organizationName) {
CrmService rslt = new CrmService();
rslt.Url = "http://localhost:5555/MSCRMServices/2007/CrmService.asmx";
CrmServiceSdk.CrmAuthenticationToken token = new CrmServiceSdk.CrmAuthenticationToken();
token.AuthenticationType = 0;
token.OrganizationName = organizationName;
token.CallerId = callerID;
rslt.CrmAuthenticationTokenValue = token;
rslt.Credentials =CredentialCache.DefaultCredentials;
return rslt;
}

Enjoy,
Rami Heleg

Create Metadata Service example

2009-09-10T15:46:00.001+03:00

here function to create crmService based organization Name.

public static MetadataService GetMetadataService(string organizationName) {
MetadataService metadata = new MetadataService();
metadata.Url = "http://localhost:5555/MSCRMServices/2007/CrmService.asmx";
MetadataServiceSdk.CrmAuthenticationToken token = new MetadataServiceSdk.CrmAuthenticationToken();
token.AuthenticationType = 0;
token.OrganizationName = organizationName;
metadata.CrmAuthenticationTokenValue = token;
metadata.Credentials =CredentialCache.DefaultCredentials;
return metadata;
}

Enjoy,
Rami heleg

Create CrmService example

2009-09-10T15:42:00.000+03:00

here function to create crmService based organization Name.

public static CrmService GetCrmService(string organizationName) {
CrmService rslt = new CrmService();
rslt.Url = "http://localhost:5555/MSCRMServices/2007/CrmService.asmx";
CrmServiceSdk.CrmAuthenticationToken token = new CrmServiceSdk.CrmAuthenticationToken();
token.AuthenticationType = 0;
token.OrganizationName = organizationName;
rslt.CrmAuthenticationTokenValue = token;
rslt.Credentials =CredentialCache.DefaultCredentials;
return rslt;
}

Enjoy,
Rami heleg

Set Value to Dynamic entity

2009-09-10T15:32:00.000+03:00

Microsoft.Crm.Sdk.DynamicEntity entity

//Set value to CrmNumber
Microsoft.Crm.Sdk.CrmNumber number = new Microsoft.Crm.Sdk.CrmNumber();
number.Value = ToInt(propertyValue);
entity.Properties[propertyName] = number;

//Set Value to String
entity.Properties[propertyName] = propertyValue.ToString();

Enjoy,
Rami Heleg

SetMandatory

2009-09-07T10:39:00.001+03:00

Hi,
Function to set mandtory true/false in CRM 4.0

this.setMandatory = function(fieldName, value) {
crmForm.SetFieldReqLevel(fieldName, value);
}

Enjoy,
Rami heleg

Function to get value from dyanamic entity field

2009-08-07T13:26:00.000+03:00

public static Guid GetKeyValue(Microsoft.Crm.Sdk.DynamicEntity de, string val)
{
foreach (KeyProperty ent in de.Properties)
{
if (ent.Name == val)
return ent.Value.Value;
}
return Guid.Empty;

}

Enjoy,
Rami Heleg

Function to get value from dyanmic entity

2009-08-07T13:24:00.001+03:00

public static string GetValueFromProperty(object property)
{
switch (property.GetType().Name)
{
case "String":
return ((String)property);
case "Lookup":
return ((Microsoft.Crm.Sdk.Lookup)property).IsNull == true ? "" : ((Microsoft.Crm.Sdk.Lookup)property).Value.ToString();
case "Picklist":
return ((Microsoft.Crm.Sdk.Picklist)property).IsNull == true ? "" : ((Microsoft.Crm.Sdk.Picklist)property).name.ToString();
case "Customer":
return ((Microsoft.Crm.Sdk.Customer)property).IsNull == true ? "" : ((Microsoft.Crm.Sdk.Customer)property).name.ToString();
case "CrmNumber":
return ((Microsoft.Crm.Sdk.CrmNumber)property).IsNull == true ? "" : ((Microsoft.Crm.Sdk.CrmNumber)property).Value.ToString();
case "CrmFloat":
return ((Microsoft.Crm.Sdk.CrmFloat)property).IsNull == true ? "" : ((Microsoft.Crm.Sdk.CrmFloat)property).Value.ToString();
case "CrmMoney":
return ((Microsoft.Crm.Sdk.CrmMoney)property).IsNull == true ? "" : ((Microsoft.Crm.Sdk.CrmMoney)property).Value.ToString();
case "CrmBoolean":
return ((Microsoft.Crm.Sdk.CrmBoolean)property).IsNull == true ? "" : ((Microsoft.Crm.Sdk.CrmBoolean)property).Value ? "1" : "0";
case "CrmDateTime":
return ((Microsoft.Crm.Sdk.CrmDateTime)property).IsNull == true ? "" : ((Microsoft.Crm.Sdk.CrmDateTime)property).Value;
case "Status":
return ((Microsoft.Crm.Sdk.Status)property).IsNull == true ? "" : ((Microsoft.Crm.Sdk.Status)property).Value.ToString();
case "State":
return "0";
case "Key":
return ((Microsoft.Crm.Sdk.Key)property).Value.ToString();
case "Owner":
return ((Microsoft.Crm.Sdk.Owner)property).IsNull == true ? "" : ((Microsoft.Crm.Sdk.Owner)property).name.ToString();
}
return "";
}

Enjoy,
Rami Heleg

Function to create CrmCustomer

2009-08-07T13:22:00.001+03:00

public static Customer GetCrmCustomer(string entityTypeName, Guid value) {
Customer rslt = new Customer();
if (value == Guid.Empty)
rslt.IsNull = rslt.IsNullSpecified = true;
else {
rslt.type = entityTypeName;
rslt.Value = value;
}
return rslt;
}
Enjoy,
Rami Heleg

Function to create CrmPickList

2009-08-07T13:21:00.000+03:00

public static Picklist GetCrmPicklist(int value) {
Picklist rslt = new Picklist();
if (value == 0)
rslt.IsNull = rslt.IsNullSpecified = true;
else
rslt.Value = value;
return rslt;
}
Enjoy,
Rami Heleg

Function to create CrmOwner

2009-08-07T13:20:00.000+03:00

public static Owner GetCrmOwner(Guid ownerID) {
Owner rslt = new Owner();
if (ownerID == Guid.Empty)
rslt.IsNull = rslt.IsNullSpecified = true;
else {
rslt.Value = ownerID;
rslt.type = "systemuser";
}
return rslt;
}
Enjoy,
Rami Heleg

Function to create CrmStatus

2009-08-07T13:17:00.002+03:00

public static Status GetCrmStatus(int value) {
Status rslt = new Status();
rslt.Value = value;
return rslt;
}

Enjoy,
Rami Heleg.

Function to create CrmMoney

2009-08-07T13:17:00.001+03:00

public static CrmMoney GetCrmMoney(decimal value) {
CrmMoney rslt = new CrmMoney();
rslt.Value = value;
return rslt;
}
Enjoy,
Rami Heleg