Chandan's CRM Blog

Hide/Show the CRM modules based on roles

2011-08-09T22:45:00.000-07:00

We have sale, marketing and service modules in the CRM. We want to show the sale module only to the sales user, marketing module only to marketing users, service module to service users.

Create a custom Entity named “link”.

Edit the sitemap.
In sales for all the SubArea add the Privilege only to “create” on the custom entity “link”.
<Privilege Entity="new_link" Privilege="Create" />
In Marketing for all the SubArea add the Privilege only to “Read” for the custom entity “link”.
<Privilege Entity="new_link" Privilege="Read" />
In Settings for all the SubArea add the Privilege only to “Write” for the custom entity “link”.
<Privilege Entity="new_link" Privilege="Write" />

Save and import the soluntion.

In security roles give the Create Privilege on “link” to all sales roles, Read Privilege on “link” to all marketing roles, Write Privilege on “link” to all service roles.

Deploying Wizard Report to Different Server

2010-10-06T06:41:00.000-07:00

When we create a wizard report in CRM, it’s really difficult to move the same report to production. Once you download the wizard report, we get an RDL file.

When we upload this RDL file to production, we get a report but wizard is lost. User can’t update the report (like column, group etc).

I searched into the database and found a solution (its unsupported) to enable the wizard of the wizard report after uploading the RDL.

Steps to upload a wizard report to production:

Create a wizard report in CRM in Dev environment.
Download the wizard report, it will give an RDL file.
Upload the same RDL file to the Production as “Existing file”.
Login to ORG_MSCRM DB, update the Report table entry, set IsCustomReport = 1 for the corresponding report.

CRM update web service call in Java Script

2010-06-28T02:42:00.000-07:00

// Record Owner
var Owner = new Array;
Owner = crmForm.all.ownerid.DataValue;
var oppOwner = Owner[0].name;

// updating Opportunity
/* setting opportunuty owner name to a text field in the same record using crm update web service call in JScript */
try
{
var xml1 = "<?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'>"+
GenerateAuthenticationHeader()+
"<soap:Body>"+
"<Update xmlns='http://schemas.microsoft.com/crm/2007/WebServices'>"+
"<entity xsi:type='opportunity'>" +
"<new_text>"+ xmlencode(oppOwner) +"</new_text>" +
"<opportunityid>" + crmForm.ObjectId + "</opportunityid>" +
"</entity>"+
"</Update>"+
"</soap:Body>"+
"</soap:Envelope>";

var xHReq1 = new ActiveXObject("Msxml2.XMLHTTP");
xHReq1.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);
xHReq1.setRequestHeader("SOAPAction","http://schemas.microsoft.com/crm/2007/WebServices/Update");
xHReq1.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xHReq1.setRequestHeader("Content-Length", xml1.length);
xHReq1.send(xml1);
// Capture the result
var resultXml1 = xHReq1.responseXML;

var errorCount1 = resultXml1.selectNodes('//error').length;
}
catch (e)
{ }

/* xml encoding to convert "&" and single quote (') symbol*/
function xmlencode(string) {
return string.replace(/\&/g,'&'+'amp;').replace(/</g,'&'+'lt;').replace(/>/g,'&'+'gt;').replace(/\'/g,'&'+'apos;').replace(/\"/g,'&'+'quot;');
}

Set the account lookup when new contact is created from the Contact lookup new button in Account form

2010-06-25T04:13:00.001-07:00

Remove Add Existing Button From CRM Iframe

2010-06-25T03:44:00.000-07:00

/* _MBtoplocAssocOneToMany2contactcustomeraccounts is the Id of the AddExisting button appearing in CRM grid. this id can be find out using IE developer tool bar */

function RemoveAddExistingFromIframe()
{
var iFrame1 = null;
iFrame1 = crmForm.all.IFRAME_Test;
var iDoc1 = iFrame1.contentWindow.document;
iFrame1.attachEvent( "onreadystatechange" , Ready1);
RemoveWhiteSpace(iFrame1);
}

function Ready1()
{

var iFrame1 = crmForm.all.IFRAME_Test;
var iDoc1 = iFrame1.contentWindow.document;
if(iDoc1.getElementById("_MBtoplocAssocOneToMany2contactcustomeraccounts") != null)
iDoc1.getElementById("_MBtoplocAssocOneToMany2contactcustomeraccounts").style.display = "none";
}

function RemoveWhiteSpace(iframe)
{
try
{
var IFRAME_test = iframe;
IFRAME_test.onreadystatechange = function ()
{
if( IFRAME_test.readyState != 'complete' )
return;
IFRAME_test.style.border = "0px";
var IframeWindo = IFRAME_test.contentWindow;
IframeWindo.document.body.scroll = "no";
IframeWindo.document.body.childNodes[0].rows[0].cells[0].style.padding = "0px";
}
}catch (e)
{alert('Error : '+e);}
}

Hide CRM form Button/menu/sort cuts/isv buttons

2010-06-25T03:01:00.000-07:00

Advanced find view in an IFRAME in CRM from

2010-06-25T02:38:00.000-07:00

// Fetch xml for the data we want to show in a CRM grid

fetchXml = "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true'>"+
"<entity name='opportunity'>"+
"<attribute name='name'/>"+
"<attribute name='createdon'/>"+
"<attribute name='ownerid'/>"+
"<attribute name='new_finalstage'/>"+
"<attribute name='opportunityid'/>"+
"<order attribute='name' descending='false'/>"+
"<filter type='and'><condition attribute='statecode' operator='eq' value='0'/></filter>"+
"</entity></fetch>";

/* Layout of the adv find Grid
In object - is the objecttypecode of the result entity
jump - is the name of the primary column in the result view */

var layoutXml = ""+
"<grid name='resultset' object='3' jump='name' select='1' icon='1' preview='1'>"+
"<row name='result' id='opportunity'>"+
"<cell name='name' width='230' />"+
"<cell name='createdon' width='80' />"+
"<cell name='ownerid' width='120' />"+
"<cell name='new_finalstage' width='160' />"+
"</row>"+
"</grid>";

/* the main method to retrieve and bind the data to the CRM Grid according to the fetch XML and Layout XML
IFRAME_TEST- an IFRAME to show the advance find view
opportunity – is the main entity name
fetchXml – the fetchXml query we want to retrieve from CRM
layoutXml – the layout to show the retrieved data
name – sorting of records in CRM advanced find grid
false – sort order Descending
{350D0AA8-3EF5-496B-A714-15B2DE896D20} – advance find view id for the same entity (opportunity) */

EmbedAdvancedFindView("IFRAME_TEST", "opportunity", fetchXml, layoutXml, "name", "false", "{350D0AA8-3EF5-496B-A714-15B2DE896D20}");

// to remove the toolbar items from the advance find grid
var iFrame1 = null;
iFrame1 = crmForm.all.IFRAME_TEST;
var iDoc1 = iFrame1.contentWindow.document;
iFrame1.attachEvent( "onreadystatechange" , Ready1);
RemoveWhiteSpace(iFrame1);

function Ready1(){
try{
var iFrame = crmForm.all.IFRAME_TEST;
var iDoc1 = iFrame.contentWindow.document;
if(iDoc1.getElementById("gridMenuBar") != null)
iDoc1.getElementById("gridMenuBar").style.display = "none";
}catch (e)
{}
}

function EmbedAdvancedFindView(iFrameId, entityName, fetchXml, layoutXml, sortCol, sortDescend, defaultAdvFindViewId) {
try {

var iFrame = document.getElementById(iFrameId);
var httpObj = new ActiveXObject("Msxml2.XMLHTTP");
var url = "/" + ORG_UNIQUE_NAME + "/advancedFind/fetchData.aspx";

var params = "FetchXML=" + fetchXml
+ "&LayoutXML=" + layoutXml
+ "&EntityName=" + entityName
+ "&DefaultAdvFindViewId=" + defaultAdvFindViewId
+ "&ViewType=1039" // According to Michael Hohne over at Stunnware
+ "&SortCol=" + sortCol
+ "&SortDescend=" + sortDescend;

httpObj.Open("POST", url, true);

httpObj.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
httpObj.setRequestHeader("Content-length", params.length);

httpObj.onreadystatechange = function() {
if (httpObj.readyState == 4 && httpObj.status == 200) {
var doc = iFrame.contentWindow.document;
iFrame.src = null;
doc.open();
doc.write(httpObj.responseText);
doc.close();

doc.body.style.padding = "0px";
doc.body.style.backgroundColor = "#eaf3ff";
}
}
httpObj.send(params);
}
catch (e) {
}
}

// to expand the adv find grid to full width
function RemoveWhiteSpace(iframe)
{
var IFRAME_test = iframe;
IFRAME_test.onreadystatechange = function ()
{
if( IFRAME_test.readyState != 'complete' )
return;
IFRAME_test.style.border = "0px";
var IframeWindo = IFRAME_test.contentWindow;
if(IframeWindo.document.body.childNodes[0]!=null){
if(IframeWindo.document.body.childNodes[0].rows!=null){
IframeWindo.document.body.scroll = "no";
IframeWindo.document.body.childNodes[0].rows[0].cells[0].style.padding = "0px";
}
}
}
}

Xmlencode the text in fetchXML in Jscript

2010-06-24T23:02:00.000-07:00

While passing text as a parameter in fetchXml in CRM OnLoad/OnSave/OnChange event Jscript, it required to xmlencode the text before use the same as parameter.
This is because the fetchXml contains “&” or single quote(‘) is not executed in Jscript CRM service call.

function xmlencode(string) {
return string.replace(/\&/g,'&'+'amp;').replace(//g,'&'+'gt;').replace(/\'/g,'&'+'apos;').replace(/\"/g,'&'+'quot;');
}

Refresh a CRM grid on the CRM Form

2010-06-24T22:37:00.000-07:00

try
{
var _locAssocObj = locAssocObj;
locAssocObj = this.locAssocObj;

//fucntion definition for overloading the N:N Grid association
this.locAssocObj = function(iType, sSubType, sAssociationName, iRoleOrdinal) {
_locAssocObj(iType, sSubType, sAssociationName, iRoleOrdinal);
switch (sAssociationName) {
case "new_new_opportunity_systemuser":
crmForm.all.IFRAME_OpportunityUser.contentWindow.document.all.crmGrid.Refresh();
break;
}
}

} catch (e)
{ }

“sAssociationName” is the relationship name (we can find this in entity customization).
Here there is an N:N relationship in between Opportunity and SystemUser named “new_new_opportunity_systemuser”.
And the system user grid is there on the CRM. On addition/removal of any entry in the user list will refresh the corresponding grid.

Set Focus to a field in CRM form

2010-06-24T22:24:00.000-07:00

function SetFocustoaField()
{
var oField = crmForm.all.roche_name;
oField.onblur = function() {
oField.SetFocus();
oField.onblur = null;
}
oField.SetFocus();
}

Call External JS file in CRM from OnLoad/OnSave/OnChange event

2010-06-24T22:12:00.000-07:00

Take an example. I have a JS file named “Entity_OnLoad.js” in “ISV/Org_Name/JavaScript” folder. There is a method named “CommonAction” in “Entity_OnLoad.js” file.

With the help of following Jscript we can call the “CommonAction” method from “Entity_OnLoad.js” in the OnLoad/OnSave/OnChange event of the CRM form.

var netRequest = new ActiveXObject("Msxml2.XMLHTTP");
netRequest.open("GET", "/ISV/Org_Name/JavaScript/Entity_OnLoad.js", false);
netRequest.send(null);
eval(netRequest.responseText);

CommonAction();

Trigger N:N Association event and Dassiciation event in CRM Plugin

2010-03-14T21:53:00.001-07:00

-- ===================================================================================================
-- Enable Associate and Disassociate Plug-in Events
-- execute the following query to CRM database, it will add two entries in SdkMessageFilterBase
-- 'DisassociateEntities' and 'AssociateEntities' from SdkMessageBase which is not listed
-- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
USE CrmDev_MSCRM
GO

-- Find the deployments SDK Filter ID for the
-- Associate and Disassociate Entity SDK Messages
DECLARE @DisassociateEntitiesFilterId uniqueidentifier
DECLARE @AssociateEntitiesFilterId uniqueidentifier
SET @DisassociateEntitiesFilterId = (SELECT SdkMessageId FROM SdkMessageBase WHERE [Name] = 'DisassociateEntities')
SET @AssociateEntitiesFilterId = (SELECT SdkMessageId FROM SdkMessageBase WHERE [Name] = 'AssociateEntities')

-- Enable the Associate and Disassociate Filters to be valid for custom processing
-- Custom Processing means "you register plug-ins against it"
-- Note: We only do this for the "generic" (OTC == 0) case, just to be safer
UPDATE SdkMessageFilterBase SET IsCustomProcessingStepAllowed = 1 WHERE SdkMessageId = @DisassociateEntitiesFilterId AND PrimaryObjectTypeCode = 0
UPDATE SdkMessageFilterBase SET IsCustomProcessingStepAllowed = 1 WHERE SdkMessageId = @AssociateEntitiesFilterId AND PrimaryObjectTypeCode = 0
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
The above query will enable the 'DisassociateEntities' and 'AssociateEntities' message in the plugin registration tool. While registering the plugin select the entity name as ‘none’

While executing the plugin you will be getting four parameter as input parameters from the plugin context along with the other properties :

1. Related Entity1 guid and entity name
2. Related Entity2 guid and entity name
3. Relation hsip name (nothing but intersect hidden N:N entity name)
4. Optional parameter.

Using these value you can implement you logic.

Sample Code for N:N relationship with a custom entity and Sytem User:

public void Execute(IPluginExecutionContext context)
{
try
{
crmservice = context.CreateCrmService(true);

if (context.MessageName == "AssociateEntities")
{

if (context.InputParameters.Properties["RelationshipName"].ToString() == "new_new_customentity_systemuser")
{
string oId = string.Empty;
string SharedUserId = string.Empty;

oId = (context.InputParameters.Properties["Moniker1"] as Moniker).Id.ToString();

SharedUserId = (context.InputParameters.Properties["Moniker2"] as Moniker).Id.ToString();

// write you logic here

}
}

}
catch (System.Web.Services.Protocols.SoapException ex)
{
LogWriter.LogInfo(ex.ToString());
}

catch (Exception ex)
{
LogWriter.LogInfo(ex.ToString());
}
}

Note : As we have defined 'none' as the entity name while registering the plugin, so this plugin will get triggered when ever user will do add existing or romove existing, for any entity. So while writing the logic relationship name is required to identify from where plugin has been triggered.

Referance : http://consulting.ascentium.com/blog/crm/Post533.aspx

Disable CRM form

2010-03-12T07:57:00.000-08:00

Here is the JScript to Disable all the fields/attributes of the CRM From.

function DisableForm() {
var iLen = crmForm.all.length;
for (i = 0; i < iLen; i++) {
crmForm.all[i].Disabled = true;
}
}

HIde Left Nav Bar of CRM from

2010-03-12T07:56:00.000-08:00

Here is the JScript to hide the left navigation area (completly) of any CRM form.

document.all.crmNavBar.parentElement.style.display = "none";
document.all.tdAreas.colSpan = 2;

Maximize the CRM form

2010-03-12T07:54:00.001-08:00

Here is the JScript to maximise the CRM form.

window.moveTo(0, 0);
window.resizeTo(screen.availWidth, screen.availHeight);

Button on CRM form

2010-03-12T07:45:00.000-08:00

There is a workaround of creating a button on the CRM form.
The logic behind is , just place a text box attribute on the CRM form, hide the label/textbox of the corresponding attribute and make the textbox/label (other half) of the same attribute to a button.

Here we have an attribute name new_button (textbox). The first half(label) has been made hidden always and second half of the attribute (textbox) has been converted to a button. And the event has been added to the button.

Example:
crmForm.all.new_ button_c.style.display = 'none'
crmForm.all.new_button_d.innerHTML = "<button class='ms-crm-Button' onclick='ButtonClick();'>Click Here</button>";

ButtonClick = function() {
// write your logic here..

}

More Than 8 Tabs on a CRM Form

2010-02-14T23:04:00.000-08:00

Friends,

We can have more than 8 tabs on a CRM Form if required. (It is unsupported but very easy to implement).

Procedure :
In: C:\Program Files\Microsoft CRM Server\CRMWeb\Tools\FormEditor find your formeditor.aspx and select edit. Find the JavaScript variable _iMaxTabs and notice that it is set to 8. Change the value to your desired limitation, save and close, reset IIS and you should then be able to create the additional tabs needed from within the forms customization area.

Note : This change will be refelected in all the CRM form.

Changing the entity’s default print preview

2010-02-03T06:41:00.000-08:00

http://adrian-alexan.blogspot.com/2009/12/customizing-entities-print-preview-form.html

Custom Entities are not available for Mail Merge

2010-02-01T23:19:00.000-08:00

As we all know in CRM 4.0 most of the entities(including the custom entities) are available for the Mail Merge. But often we see that few custom entities are not available while Mail Merge.

This happen only when we import CRM 3.0 customization to the CRM 4.0 CRM. Actually in CRM 3.0 Mail Merge future was not available for custom entity and custom attribute added to the system entity.
So when we import 3.0 customization to 4.0 still Mail Merge future has not been added to the custom entity. Even we don’t have anything in CRM so that we can enable (Or disable) the mail merge future for an entity from UI.

But there is a work around to enable the Mail Merge future for the custom entity.

Export the entity customization, open the customization.xml in Visual Studio. In bottom of the xml file you will see the xml nodes named like <IsoutlookEnabled>, <IsDuplicateDetectionEnabled> .
Likewise we need to add one more node as <IsMailMergeEnabled> and set the value as "yes".

Save and close the customization.xml and import the same to the CRM. Wait for 2-3 minutes lets synchronized the customization with the outlook. Close and launch the outlook again and start the Mail Merge for the corresponding entity.

Note – These steps we need to follow for every custom entity. Be very care full while making changes in Customization.xml.

Disabled Fields in Bulk Edit

2010-02-01T05:10:00.000-08:00

When we do Bulk Edit in MSCRM, we see few fields has been disabled or in read only format. We can’t provide any input to those fields.

This is because if we have enabled the OnChange event for the fields, those fields appear as disabled on the Bulk Edit form. This is because for multiple records CRM won’t be able to trigger the OnChange event and take the defined action in OnChange Jscript.

Note - Even though we don’t have any Jscript in OnChange event of the field but if we have enabled the OnChange event, the corresponding field will appear as read only.

Auto Numbers in Microsoft Dynamics CRM

2009-10-29T23:51:00.000-07:00

I was looking for the simple, supported and mostly acceptable way of auto numbering and got in some blog to use a custom entity in CRM called AutoNumber that tracks the max used autonumber by entity type.

Use a post create callout to populate corresponding entity type’s max value + 1 to the newly-created record, and also to write that new max value to the entry in the AutoNumber record for the entity type.

That way the process fires when offline clients sync their new records to the central database and you end up with no duplicate record contention, since that part of the post callout is (I believe) transaction bound to ensure we don’t get dupes.

There is another simple, supported and mostly acceptable way of auto numbering suggested by “Ayaz Ahmad”.

Read the autonumber attribute Max value and then add 1 to get next auto number. For example you have a custom entity named Project and you want to auto number Project_Ref_Number attribute. But do not retrieve all records. Just retrieve the record with maximum number value by using following two properties of PageInfo Class in SDK and set descending order.

PageInfo.Count = 1;
PageInfo.PageNumber = 1;

Code:-

ColumnSet cols = new ColumnSet();
cols.AddColumns(new string[] { "leadid", "new_autonumber" });

PagingInfo pages = new PagingInfo();
pages.PageNumber = 1;
pages.Count = 1;

QueryExpression query = new QueryExpression();
query.EntityName = EntityName.lead.ToString();
query.ColumnSet = cols;
query.AddOrder("new_autonumber", OrderType.Descending);
query.PageInfo = pages;

RetrieveMultipleRequest request = new RetrieveMultipleRequest();
request.ReturnDynamicEntities = true;
request.Query = query;

RetrieveMultipleResponse retrieved = (RetrieveMultipleResponse)service.Execute(request);

if (retrieved.BusinessEntityCollection.BusinessEntities.Count > 0)
{
DynamicEntity results = (DynamicEntity)retrieved.BusinessEntityCollection.BusinessEntities[0];
if (results.Properties.Contains("new_autonumber"))
{
nextNumber = Convert.ToInt32(results.Properties["new_autonumber"].ToString()) + 1;
//add nextNumber as the entity property for the coresponding entity
}
}

One more consideration should be taken in account to register your auto number plugin to at PreCreate rather at PostCreate.

Limitation:
In multi-user environment, this approach can come up with duplicate numbers in Project_Ref_Number when more than one user is creating project records.

Datetime format in SSRS report while running in CRM/Web App

2009-10-28T23:00:00.000-07:00

When we run our report in CRM/ Web App automatically date format get change from MM/DD/YYYY to DD/MM/YYYY or vice versa in report parameters.

Actually this is the limitation of the reporting service. By default the “language property of the report” is US English. But when we run the report in Client browser the date time format get decided by the Language settings of client browser not by the language property of the report.

The format of date time parameter is always decided by the Language settings of client browser regardless of the Language property of our report (or in CRM).

Examples:-
If we have the Client browser language settings in English (AU), the date format in parameter bar will be as (regardless of the Language property of our report (or in CRM)):-

But when we run the same in the Client browser where language settings is in French (Canada) the date format in parameter bar will be as (regardless of the Language property of our report (or in CRM)):-

We can change the date time format in the report data using
1. CultureInfo (by adding the vb script in code section of the report) in Web App
2. CRM_CalendarTypeCode from the user settings in CRM.

OnLoad, Onsave and OnChange code sharing/reuse

2009-10-19T01:37:00.000-07:00

There are three events in CRM form, OnLoad, OnSave, OnChange. OnLoad and OnSave are in the form level and OnChange is in field level. Sometimes it’s needed to write the same code/method in OnLoad, or Onsave or OnChange or all three events.

Actually these events trigger in a sequence, first OnLoad then OnChange (if any) and finally OnSave. So whatever methods we have written in the OnLoad of the form it will be available in OnChange and OnSave of the form.

If there are any method/methods in OnLoad event we can reuse those methods in OnChange event of any field and OnSave of the form just by calling the method (no need to redefine the method definition again).

And also sometimes it’s required to write the same code what we have in OnChange of any field in OnLoad/OnSave. We can achieve the same just by calling the OnChange code of the field using “<field_Schema>_onchange0();” method.

UserId of the Calling User

2009-10-13T23:44:00.000-07:00

function GetCurrentUserInfo() {
var xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
xmlhttp.open("POST", "/mscrmservices/2007/crmservice.asmx", false);
xmlhttp.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xmlhttp.setRequestHeader("SOAPAction", "http://schemas.microsoft.com/crm/2007/WebServices/Execute");
var soapBody = "<soap:Body>" +
"<Execute xmlns='http://schemas.microsoft.com/crm/2007/WebServices'>" +
"<Request xsi:type='WhoAmIRequest' />" +
"</Execute></soap:Body>";
var soapXml = "<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'>";
soapXml += GenerateAuthenticationHeader();
soapXml += soapBody;
soapXml += "</soap:Envelope>";
xmlhttp.send(soapXml);
xmlDoc = new ActiveXObject("Microsoft.XMLDOM");
xmlDoc.async = false;
xmlDoc.loadXML(xmlhttp.responseXML.xml);
var userid = xmlDoc.getElementsByTagName("UserId")[0].childNodes[0].nodeValue;

return userid;
}

How to edit the list of entities displayed in the Look for picklist in Lookup window

2009-10-13T23:19:00.000-07:00

The regarding lookup windows generally display a list of all entities that can be associated with an activity. Quite often this feature becomes quite an issue with the users always having to select the appropriate entity from the list before applying the search. The longer the list of entities the more time consuming it is to search using the lookup window.It would be a boon to have only selected entities in the list. Well this is not available for customization through the CRM customization area. But it could be done by adding the Jscript to onload of the form.

There are few properties of the Lookup control being set when we open a form and those are “Lookup Types”, “Lookup Type names” ,”Lookup Type Icons” and “default type”.

We need to over load the default settings by writing our own logic in onload of the form to load specific list of entities to show up in the Look for section.

/*Give the entity type code that you want in below script we want to show account, contact, Lead and Opportunity in order in the list */
crmForm.all.regardingobjectid.lookuptypes = "1,2,3,4";

/*Make sure you set the path of the entity images correctly for the list specified above */
crmForm.all.regardingobjectid.lookuptypeIcons = "/_imgs/ico_16_1.gif:/_imgs/ico_16_2.gif:/_imgs/ico_16_3.gif:/_imgs/ico_16_4.gif:";

/*The below script is to set default entity in the multiple entity lookup. Here we set the default entity to be Opportunity */
crmForm.all.regardingobjectid.defaulttype = "3";

Above example will show Account, Contact, Opportunity and Lead in the Look For entity list and default entity is Opportunity.

Appropriate W3P.exe instance while debugging the CRM App

2009-09-30T01:44:00.000-07:00

There are more than one W3P.exe instances running in a CRM system (CRM app pool, reporting service etc). While debugging the MSCRM Application sometimes we get more than one W3P.exe instances. And usually we attach all those instances which slowdowns the processing of the system.

It’s unnecessary overload on system processing. We can avoid this by attaching the appropriate W3P.exe instance.

To find out which instance to attach in debugger just run the IISAPP.VBS in command prompt, it will list out all the W3P.exe instances with their port no. Now just match the port no of the CRM App Pool/ Default App Pool with the available processes list, attach the appropriate W3P.exe and start debugging.

CRM Report error in case of Custom DB Object

2009-09-29T03:54:00.000-07:00

While doing the reports for CRM, sometimes its required to create our own custom objects (like function, procedure or table) and use them in reports or to include some CRM tables(Entity, Attribute) in our Query.

When we use a custom object or CRM table in our Query it work perfectly for the admin user but it doesn’t work for the non-admin user.

In this case we need to add the permission “NT Authority\Network Services” for that particular object in DB.

Lookup: Retrieve Column values from Lookup window

2009-09-28T23:26:00.000-07:00

if(crmForm.all.<lookupId>.DataValue != null)
{

var entityId = document.getElementById( "<lookupId>");
var lookupItems = entityId.items[0].values;

alert(lookupItems[0].value); // First column value of Lookup
alert(lookupItems[1].value); // Second column value of Lookup
alert(lookupItems[2].value); // Third column value of Lookup
alert(lookupItems[3].value); // Fourth column value of Lookup
alert(lookupItems[4].value); // Fifht column value of Lookup
alert(lookupItems[5].value); // Sixth column value of Lookup
}

Note: You should disable the Automatic Resolution, so that users cannot add values automatically. This script will work only if the Lookup View is loaded.

Change the text and display of the navigation item

2009-09-28T22:27:00.000-07:00

Change the text and display of the navigation item:-

var iOpps = 0;
if(document.getElementById('navOpps') != null)
{
document.getElementById('navOpps').getElementsByTagName('NOBR')[0].innerText =
document.getElementById('navOpps').getElementsByTagName('NOBR')[0].innerText + " (" + iOpps + ")";
document.getElementById('navOpps').getElementsByTagName('NOBR')[0].style.color = "#FF0000";
document.getElementById('navOpps').getElementsByTagName('NOBR')[0].style.fontWeight = "700";
}

Change the color of the service appointment / appointment in service calendar

2009-09-10T01:50:00.000-07:00

In Service Management, there are Time Blocks displayed in the appointment book. The color of the time blocks varies according to the status of the appointment. The section named “ServiceManagement” of isv.config.xml allows for customization of these colors by providing a mapping to the .css file that defines them. These .css files are located at \SM\Gantt\style\GanttControl.css.aspx.

Export and open the “isv.config”, search for the . Under the , for every Status(1 – Requested, 2 – Tentative, 3 – Pending, 4 – Reserved, 6 - In Progress, 7 – Arrived, 8 – Completed, 9 – Canceled ,10 - No Show) CssClass has been defined.

Open the GanttControl.css.aspx file using VS and search the CssClass name (like ganttBlockServiceActivityStatus1, ganttBlockServiceActivityStatus2) and change the color acording to your requirement.

Script for hide 'Add existing button'

2009-09-09T05:17:00.000-07:00

Sometimes it required to hide the “add existing” button from the grid. Here is the Jscript to achieve the same. There is a Test entity (custom entity) in Contact entity where I am hiding the “add existing” button.

//Script for hide 'Add existing button'

HideAddExistingButton('new_contact_test', ['Add existing Test to this record']);

function HideAddExistingButton(relationshipName, buttonToolTip)
{
var navElement = document.getElementById('nav_' + relationshipName);
if (navElement != null)
{
navElement.onclick = function LoadAreaOverride()
{
loadArea(relationshipName);
HideButton(document.getElementById(relationshipName + 'Frame'), buttonToolTip);
}
}
}

function HideButton(Iframe, buttonToolTip)
{
Iframe.onreadystatechange = function HideTitledButtons()
{
if (Iframe.readyState == 'complete')
{
var iFrame = frames[window.event.srcElement.id];
var liElements = iFrame.document.getElementsByTagName('li');

for (var j = 0; j < buttonToolTip.length; j++)
{
for (var i = 0; i < liElements.length; i++)
{
if (liElements[i].getAttribute('title') == buttonToolTip[j])
{
liElements[i].style.display = 'none';
break;
}
}
}
}
}
}

“relationshipName” you can get it from the entity customization, it’s basically the relationship name in between the entities. “buttonToolTip” is the tool tip defined for the add exixting button.

How to change the record title?

2009-09-03T00:06:00.000-07:00

Sometimes we get requirement like change the opportunity title or account title , it should be in red color based on some condition or title should be combination of few fields there in the form.

Here is the Jscript to achieve the same.

//Change the Main Title
var cells = document.getElementsByTagName("span");
for (var i = 0; i < cells.length; i++)
{
if (cells[i].className == "ms-crm-Form-Title")
{
cells[i].style.color = "#FF0000";
cells[i].style.fontWeight = "700";
break;
}
}

Bulk 'save as completed/Cancel' of the CRM activities

2009-09-01T22:29:00.000-07:00

There is no direct way to do the same in CRM. But there are workarounds you can achieve the same.
1. Create an ISV button on the grid tool bar. On click of this button you will the GUID of all the selected records (in the grid). Once you will get the GUID of all the activity, you can call web service using Jscript (AJAX call) and update these records as completed.

getSelected('crmGrid') will return you an array of the GUIDs of the selected records.

Limitation –

· getSelected('crmGrid') method has a limitation , it will return you the GUID of max 50 records.

· After updating the activity using AJAX call, records will still appear in the grid, unless n until you will refresh the grid.

2. Create an ISV button on the grid tool bar. On click of this button you will the GUID of all the selected records (in the grid). Once you will get the GUID of all the activity, you call you own custom page, which will update those records as completed, and it will show you a user friendly message. On close of this custom page refresh the grid.

To Refresh the grid - crmGrid.Refresh();

limitation of creating the custom attributes in CRM

2009-09-01T22:24:00.000-07:00

There is no limitation of creating the custom attributes in CRM. You can create n no of attributes within an entity. Bt as you know we have tables corresponding to each n every entity in the CRM DB and there is a limitation in database level. SQL Server allows up to 1024 columns per table and the amount of data stored in any row cannot exceed 8060 bytes. If so, while creating or updating CRM page will through SQL server error or sometimes it won’t allow you to perform any operation on this entity/records.

You can determine the number of bytes available for entities by running the following query in _METABASE database.

select e.Name, Bytes_Remaining = 8060 - (sum(a.length))from entity e
join attribute a on e.entityid = a.entityidwhere a.iscustomfield = 1
and a.islogical = 0group by e.Name

You can determine the number of bytes used for entities by running the following query in _METABASE database.

select e.Name, Physical_Size = sum(a.length)from entity e
join attribute a on e.entityid = a.entityidwhere a.iscustomfield = 1
and a.islogical = 0group by e.Name

More than 10,000 records not returned by CRM service

2009-09-01T02:31:00.000-07:00

There is a limitation in CRM service, when we retrieve data using
RetrieveMultiple or fetch xml; actually it returns max 10,000 records.

There is an unsupported way to increase the no of records returned by CRM service. You need to update the CRM DB.

There is a table named “OrganizationBase”, in this you have a column named “MaxRecordsForExportToExcel”, which defines the no of records returned by CRM service.

By default this column has been set to 10,000, which we can change according to our requirement.

Or we can use direct SQL query for the same.

CRM Pre-Filtering:

2009-08-31T21:50:00.000-07:00

CRM Pre-Filtering:

To enable the pre filtering in the report just we need to add an alias for the filtered views which starts with “CRMAF_”. A query such as “Select name from FilteredAccount” can simply be changed to “Select name from FilteredAccount as CRMAF_Account”. Aliasing the Filtered View with a prefix of CRMAF_ will allow CRM to recognize that you would like to enable this entity for pre-filtering.

When you enable the CRM Pre-filtering functionality using the CRMAF_ method, CRM will take a query such as the following and modify it when it is uploaded into CRM:
This is the sample query:-

SELECT name, accountnumber
FROM FilteredAccount as CRMAF_Account

Becomes:
SELECT name, accountnumber
FROM (@P1) as CRMAF_Account

Then CRM will pass a query to the P1 parameter depending on how the report is being filtered. For example: when we run the report from the Reports area, the Pre-filtering functionality show all Accounts that are Active, and the resulting query would be something like:

SELECT name, accountnumber
FROM (select FilteredAccount.* from FilteredAccount where statecode = 0) as CRMAF_Account

If we are running the same report within a specific Account, the resulting query would be something like:

SELECT name, accountnumber
FROM (select FilteredAccount.* from FilteredAccount where AccountId = ‘’) as CRMAF_Account

If we are running the same report for a list of Accounts (suppose 3 accounts are selected from a view), the resulting query would be something like:

SELECT name, accountnumber
FROM (select FilteredAccount.* from FilteredAccount where AccountId in (’<1staccountid>’, ‘<2ndaccountid>’, ‘<3rdaccountid>’) as CRMAF_Account

AJAX Calls using JavaScript to retrieve data for N:N relationship

2009-08-31T01:09:00.001-07:00

//**************************************************
//AJAX Call to get the Competitors for an Oportunity
//**************************************************

var sOppID = crmForm.ObjectId;

var returnXML="";

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\">" +
GenerateAuthenticationHeader() +
" <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>competitor</q1:EntityName>" +
" <q1:ColumnSet xsi:type=\"q1:AllColumns\" />" +
" <q1:Distinct>false</q1:Distinct>" +
" <q1:LinkEntities>" +
" <q1:LinkEntity>" +
" <q1:LinkFromAttributeName>competitorid</q1:LinkFromAttributeName>" +
" <q1:LinkFromEntityName>competitor</q1:LinkFromEntityName>" +
" <q1:LinkToEntityName>opportunitycompetitors</q1:LinkToEntityName>" +
" <q1:LinkToAttributeName>competitorid</q1:LinkToAttributeName>" +
" <q1:JoinOperator>Inner</q1:JoinOperator>" +
" <q1:LinkEntities>" +
" <q1:LinkEntity>" +
" <q1:LinkFromAttributeName>opportunityid</q1:LinkFromAttributeName>" +
" <q1:LinkFromEntityName>opportunitycompetitors</q1:LinkFromEntityName>" +
" <q1:LinkToEntityName>opportunity</q1:LinkToEntityName>" +
" <q1:LinkToAttributeName>opportunityid</q1:LinkToAttributeName>" +
" <q1:JoinOperator>Inner</q1:JoinOperator>" +
" <q1:LinkCriteria>" +
" <q1:FilterOperator>And</q1:FilterOperator>" +
" <q1:Conditions>" +
" <q1:Condition>" +
" <q1:AttributeName>opportunityid</q1:AttributeName>" +
" <q1:Operator>Equal</q1:Operator>" +
" <q1:Values>" +
" <q1:Value xsi:type=\"xsd:string\">" + sOppID + "</q1:Value>" +
" </q1:Values>" +
" </q1:Condition>" +
" </q1:Conditions>" +
" </q1:LinkCriteria>" +
" </q1:LinkEntity>" +
" </q1:LinkEntities>" +
" </q1:LinkEntity>" +
" </q1:LinkEntities>" +
" </query>" +
" </RetrieveMultiple>" +
" </soap:Body>" +
"</soap:Envelope>" +
"";

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

xmlHttpRequest.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);
xmlHttpRequest.setRequestHeader("SOAPAction","http://schemas.microsoft.com/crm/2007/WebServices/RetrieveMultiple");
xmlHttpRequest.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xmlHttpRequest.setRequestHeader("Content-Length", xml.length);
xmlHttpRequest.send(xml);

var returnXML = xmlHttpRequest.responseXML;

if(returnXML != null)
{
var returnNodes = returnXML.selectNodes("//BusinessEntity/q1:competitorid");
if(returnNodes.length > 0)
{

// DEFINE YOUR LOGIC HERE

}
}

Generic method for Ajax calls using javascript to retrieve data

2009-08-30T22:26:00.000-07:00

//limitation – This is the generic method supported only for 1:N or N:1 relationship

// This is a generic method for Ajax calls using javascript to retrieve data
//****************************************************************************
SoapRequestDynamic = function(entityName, searchColumn, searchValue, returnColumn)
{
var returnPacket = "";
for (var i = 0; i < returnColumn.length; i++)
{
returnPacket += " <q1:Attribute>" + returnColumn[i] + "</q1:Attribute>"
}

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\">" +
GenerateAuthenticationHeader() +
" <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>" + entityName + "</q1:EntityName>" +
" <q1:ColumnSet xsi:type=\"q1:ColumnSet\">" +
" <q1:Attributes>" +
returnPacket +
" </q1:Attributes>" +
" </q1:ColumnSet>" +
" <q1:Distinct>false</q1:Distinct>" +
" <q1:Criteria>" +
" <q1:FilterOperator>And</q1:FilterOperator>" +
" <q1:Conditions>" +
" <q1:Condition>" +
" <q1:AttributeName>" + searchColumn + "</q1:AttributeName>" +
" <q1:Operator>Equal</q1:Operator>" +
" <q1:Values>" +
" <q1:Value xsi:type=\"xsd:string\">" + searchValue + "</q1:Value>" +
" </q1:Values>" +
" </q1:Condition>" +
" </q1:Conditions>" +
" </q1:Criteria>" +
" </query>" +
" </RetrieveMultiple>" +
" </soap:Body>" +
"</soap:Envelope>" +
"";

return xml;
}
// End of SoapRequestDynamic Function

// Start of HttpPostRequest
HttpPostRequest = function(xml)
{
var xmlHttpRequest = new ActiveXObject("Msxml2.XMLHTTP");
xmlHttpRequest.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);
xmlHttpRequest.setRequestHeader("SOAPAction","http://schemas.microsoft.com/crm/2007/WebServices/RetrieveMultiple");
xmlHttpRequest.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xmlHttpRequest.setRequestHeader("Content-Length", xml.length);
xmlHttpRequest.send(xml);

//alert(xmlHttpRequest.responseXML.xml);
var resultXml = xmlHttpRequest.responseXML.selectSingleNode("//BusinessEntity");

return resultXml;
}
// End of HttpPostRequest

var sObjectID = crmForm.ObjectId;

//Actual Call for Relationships
/// finding out opportunity relationships
//var buXml = HttpPostRequest(SoapRequestDynamic(entityName, searchColumn, searchValue, returnColumn));

var buXml = HttpPostRequest(SoapRequestDynamic("customeropportunityrole", "opportunityid", sObjectID, ["customeropportunityroleid"]));

if(buXml != null )
{
var buNodes = buXml.selectNodes("//BusinessEntity/q1:customeropportunityroleid");
if(buNodes.length > 0)
{
// DEFINE YOUR LOGIC HERE
}
}

// for your referance
//http://social.microsoft.com/Forums/en-US/crmdevelopment/thread/3ec3cfcd-62ea-49b5-9239-14aee58bd7b9

Hide navigation items of an entity in CRM

2009-08-19T23:03:00.000-07:00

//define the entity names you want to hide

NavMenuHide("Service Lines","Target Achievements","Account Plan");

function NavMenuHide()
{
if (arguments == null arguments.length == 0) return;
var navBar = document.getElementById("crmNavBar");
if (!navBar) return;
var optionItems = navBar.getElementsByTagName("nobr");
var exitCount = 0;
for (opt=0; opt < optionItems.length ;opt++ )
{
for (a=0; a {
if (optionItems[opt].innerText == arguments[a])
{
// --- hide the menu item
optionItems[opt].parentNode.style.display = "none";
// --- have all of the args been processed?
exitCount ++;
if (exitCount == arguments.length) return;
}
}
}
}

Dynamic Picklist in CRM 4.0

2009-08-19T23:01:00.001-07:00

var PAccountType = crmForm.all.new_picklist;
PAccountType.originalPicklistOptions = PAccountType.Options;
var PStartIndex =2;
var PEndIndex =3;
if (PStartIndex > -1 && PEndIndex > -1)
{
// Create a new array, which will hold the new picklist options
var PTempArray = new Array();

// Initialize the index for the temp array
var PIndex = 0;

// Now loop through the original Sub-Industry options, pull out the
// requested options a copy them into the temporary array.
for (var i = PStartIndex; i <= PEndIndex; i++)
{

PTempArray[PIndex] = PAccountType.originalPicklistOptions[i];
PIndex++;
}

PAccountType.Options = PTempArray;

Show the related records of an entity in a tab of the parent form

2009-08-19T22:38:00.000-07:00

Show the related records of an entity in a tab of the parent form.

“tabSet” you can find in the customization, it’s basically the relationship name.
Or else you can run the Fiddler and get the complete URL of the related entity IFRAME (which appears in the parent form) and from the URL you can copy the “tabSet” name.

crmForm.all.new_iframe_name.src =
GetFrameSource(new_contact_new_qualification);

function GetFrameSource(tabSet)
{
if (crmForm.ObjectId != null)
{
var oId = crmForm.ObjectId;
var oType = crmForm.ObjectTypeCode;
var security = crmFormSubmit.crmFormSubmitSecurity.value;
return "areas.aspx?oId=" + oId + "&oType=" + oType + "&security=" +
security + "&tabSet=" + tabSet;
}
else
{
return "about:blank";
}
}

Currency symbol in reports in case of Multi currency in MSCRM

2009-08-18T03:07:00.000-07:00

When we develop a custom report for the MSCRM always it’s a question to show the corresponding currency symbol. Take an example we have a report in which we are showing all the opportunity of value more than 1M (in all currencies).

If you will change the currency format to any of the out of box format it will show just the dollar ($) symbol.

To show the corresponding currency symbol of the opportunity, we need to select one more field in the SQL Query named “crm_moneyformatstring” from the corresponding filtered view. This field (crm_moneyformatstring) is there in every CRM entity if there is at test one currency field in the corresponding entity.

And define the format of the money field by selecting “crm_moneyformatstring” field from the dataset. (right click on the box in the table/matrix, click on the properties, select format , in the format select crm_moneyformatstring from the dataset)

Microsoft Dynamics CRM Pre-Filtering

2009-08-18T03:01:00.000-07:00

Just need to alias the filtered views with a name that starts with “CRMAF_”. A query such as “Select name from FilteredAccount” can simply be changed to “Select name from FilteredAccount as CRMAF_Account”. Aliasing the Filtered View with a prefix of CRMAF_ will allow CRM to recognize that you would like to enable this entity for pre-filtering.

When you enable the CRM Pre-filtering functionality using the CRMAF_ method, CRM will take a query such as the following and modify it when it is uploaded into CRM:

SELECT name, accountnumber FROM FilteredAccount as CRMAF_Account

Becomes:

SELECT name, accountnumber FROM (@P1) as CRMAF_Account

Then CRM will pass a query to the P1 parameter depending on how the report is being filtered. For example: If you are running the report from the Reports area and use the Pre-filtering functionality to filter to only show Accounts that are Active, the resulting query would be something like:

SELECT name, accountnumber FROM (select FilteredAccount.* from FilteredAccount where statecode = 0) as CRMAF_Account

If you are within a specific Account and run the report, the resulting query would be something like:

SELECT name, accountnumber FROM (select FilteredAccount.* from FilteredAccount where AccountId = ‘’) as CRMAF_Account

When you are looking at a list of Accounts with 3 selected and choose the option to run the report against the selected records, the resulting query would be something like:

SELECT name, accountnumber FROM (select FilteredAccount.* from FilteredAccount where AccountId in (’<1staccountid>’, ‘<2ndaccountid>’, ‘<3rdaccountid>’) as CRMAF_Account

Custom Tooltips for every field on a MSCRM form

2009-08-18T02:09:00.000-07:00

Tooltips are available on every field on a MS CRM form. The current tooltips show the text of the label but we can change the contents of the current tooltips.
The restrictions to the tooltips are:-
1. Its unformatted text
2. And should not be more than 512 characters.

The onLoad code:
crmForm.all.new_attribute_c.title = “contents of the tooltip”

Capturing Previous Value OnChange of MSCRM Field

2009-08-18T01:52:00.000-07:00

When you change the "Account Number" value, you want to populate a field called "Prior Account Number" with the previous value. The issue is that OnChange events happen AFTER the value has changed, so you can't copy the former value to the Prior Account Number field.

One solution is to use another field to store the previous value. Let's call this field accounttemp. (We will need to include this field on the form so we can access it via javascript, but we can hide it by either putting it on a hidden tab or using javascript to hide the field.)

Once we have our accounttemp and Prior Account Number field added to the Account form, we can add javascript to the OnChange event for the Account Number field. To make this happen we will need to make sure that the following steps happen in order:

1. Value of account temp field is copied to Prior Account Number field
2. Value of Account Number field is copied to the accounttemp field

Here's how that would look in Jscript:
crmForm.all.new_prioraccountnumber.DataValue=crmForm.all.new_accounttemp.DataValue;
crmForm.all.new_accounttemp.DataValue = crmForm.all.accountnumber.DataValue ;

The result is that the first time a value is entered into the Account Number field, the Prior Account Number field will remain blank, but the new value will be copied to the accounttemp field. The next time that the value of the Account number changes, the previous value will be copied to the Prior Account Number field.

Note—this will only work if the values are entered via the form. If you import this data from Scribe or the CRM import utility, the value will not be in the accounttemp field, so the process won't work for the initial change. The workaround is that when you import your account information, import the account number to the account number field AND the accounttemp field.

OnClick Load the CRM Page Tab - JS

2009-08-17T05:17:00.000-07:00

Reorder Navigation Items in MSCRM 4.0

2009-08-17T05:11:00.000-07:00

if(document.getElementById('crmNavBar'))
{
//arrabge the navigation Item in order you want to display
var oTempArray = new Array('navInfo','nav_new_account_new_accountplan','nav_new_account_new_accountserviceline','navContacts','navAddresses','navActivities', 'navActivityHistory', 'navSubAct','navRelationships','navOpps','navQuotes','navOrders','navInvoices','navService','navContracts','navListsInSFA','navCampaignsInSFA');
var i; var iStartIndex = 0;
// total no of navigation items defined in the oTempArray variable
var iEndIndex = 10;
var iEndObject = document.getElementById(oTempArray[iEndIndex]);
for(iStartIndex; iStartIndex <= iEndIndex; iStartIndex++ )
{
if(document.getElementById(oTempArray[iStartIndex]))
{
i = document.getElementById(oTempArray[iStartIndex]);
i.parentNode.parentNode.insertBefore(i.parentNode, iEndObject.parentNode );
}
}
}