MSCRM

HOW TO REMOVE THE TFS ASSOCIATION FROM MPP FILE.

2016-04-24T06:33:00.002-07:00

HOW TO REMOVE THE TFS ASSOCIATION FROM MPP FILE.
Close Microsoft Project
Right click on the mpp file and choose Properties.
Choose the Custom tab in the Properties window.
Choose any Property listed there named "VS Team System Data Do Not Edit" and click Remove.
Click Apply or Ok.
Open the mpp file, and you will get a message saying its not associated with any TFS server. Click Ok and Save it.
You will not get the error message every time you open the mpp file as long as you save it once after the message is received.

DOGL - Day ONE GO LIVE

2016-04-24T06:25:00.003-07:00

DAY 1 GO LIVE-------------------------
Challenges at Hand:
•Many IT projects fail due to challenges uncovered in the later phases of the project like SIT, UAT and deploy. There by, the organizations lose billions of dollars.
•The business process change more rapidly than ever, making the IT projects more challenging. When the project comes into UAT phase, at least 20% of the requirements are changed.
•The existing methodologies like waterfall, agile have failed to minimize the failure of projects. It clearly indicates that there is a need for a new methodology.

Solution:DOGL, day one GO LIVE is a new methodology which aims for a technical go live on day1 of the project. This aims to minimize the failure of projects or minimize the losses by identifying the challenges/issues early in the game. As early as day 1. DOGL methodology aims to build process to address the challenges faced in waterfall methodology and others. DOGL aims to yield the business earned value from day1. DOGL gives the client the flexibility to build as needed by business accommodating the changes to the business process.
•The smallest unit of project execution, which can be built and tested is an use case. DOGL works at use case level. Each use case goes through design, build, test, deploy phases in sequence. The use cases will be sequenced based on the business priority. DOGL discourages the use of stubs based development., rather sequence the use cases to minimize the use of stubs. Each use case goes LIVE in sequence. The business GO LIVE can happen based on business cycles and requirements.

Benefits---------------------•Day 1, the GO LIVE issues are uncovered.•Day 1, the integration issues are uncovered.•Day1, the usual UAT issues like requirement gaps are uncovered.•Day 1, starts giving business earned value•Day 1, client can view the progress of the application•Day 1, client gets what he pays for.

Text file to record the date time automatically with .log statement

2015-06-06T08:58:00.001-07:00

Open a new text file
Add the text ".LOG" as the first line.
save and close the file
From now on, if you open the file, it will show the date and time every time it is opened. Nice trick.

Calucalates the exact AGE in years, months and days

2015-06-06T08:51:00.003-07:00

please follow the below steps to create an excel document which gives the exact age in years, months and days.

1. Create a new excel work book.
2. Copy the below excel fomulae and place it any cell.
3. In the formulae, replace D5 with the cell number in which you will have the date of birth.
4. It will show the age in years, months and days.

="Age is "&DATEDIF(D5,TODAY(),"y")&" Years, "&DATEDIF(D5,TODAY(),"ym")&" Months and "&DATEDIF(D5,TODAY(),"md")&" Days"

how to make pen drive as RAM

2015-06-06T08:43:00.001-07:00

we can convert the pen drive as RAM if you follow below procedure.

Plug in your Pen drive.
Format it.
Right click on the pen drive icon.
Select ‘properties’.
Select ‘Ready boost’.
Click “use this device”.
Now select the maximum space that RAM can give to the computer.
Click ‘ok’ and ‘apply’

HP - Probook - Adjust the LCD brightness using the function keys

2015-06-06T08:40:00.001-07:00

HP - Probook - Adjust the LCD brightness using the function keys

From the Windows desktop, hold the fn key and press the f10 key to increase

or the f9 key to decrease the brightness of the display.

If using the function keys does not resolve the problem and you have a Lid Actuator on your particular model, check the movement of theLid Actuator switch to determine that it moves freely and is not stuck.

The famous Vanilla story --

2015-06-06T08:37:00.003-07:00

This is a weird but true story ... A complaint was received by the Pontiac Division of General Motors:

This is the second time I have written you, and I don't blame you for not answering me, because I kind of sounded crazy, but it is a fact that we have a tradition in our family of ice cream for dessert after dinner each night. But the kind of ice cream varies so, every night, after we've eaten, the whole family votes on which kind of ice cream we should have and I drive down to the store to get it.

It's also a fact that I recently purchased a new Pontiac and since then my trips to the store have created a problem. You see, every time I buy

vanilla ice cream, when I start back from the store my car won't start. If I get any other kind of ice cream, the car starts just fine.

I want you to know I'm serious about this question, no matter how silly it sounds: 'What is there about a Pontiac that makes it not start when I get vanilla ice cream, and easy to start whenever I get any other kind?'"

The Pontiac President was understandably skeptical about the letter, but sent an engineer to check it out anyway. The latter was surprised to be greeted by a successful, obviously well educated man in a fine neighborhood. He had arranged to meet the man just after dinner time, so the two hopped into the car and drove to the ice cream store. It was vanilla ice cream that night and, sure enough, after they came back to the car, it wouldn't start.

The engineer returned for three more nights. The first night, the man got chocolate. The car started. The second night, he got strawberry. The car started. The third night he ordered vanilla. The car failed to start.

Now the engineer, being a logical man, refused to believe that this man's car was allergic to vanilla ice cream. He arranged, therefore, to continue his visits for as long as it took to solve the problem. And toward this end he began to take notes: he jotted down all sorts of data, time of day, type of gas used, time to drive back and forth, etc. In a short time, he had a clue: The man took less time to buy vanilla than any other flavor. Why? The answer was in the layout of the store.

Vanilla, being the most popular flavor, was in a separate case at the front of the store for quick pickup. All the other flavors were kept in the back of the store at a different counter where it took considerably longer to find the flavor and get checked out. Now the question for the engineer was why the car wouldn't start when it took less time.

Once time became the problem — not the vanilla ice cream — the engineer quickly came up with the answer: vapor lock. It was happening every night, but the extra time taken to get the other flavors allowed the engine to cool down sufficiently to start. When the man got vanilla, the engine was still too hot for the vapor lock to dissipate.

Moral of the story: even insane-looking problems are sometimes real.

Create new Organization -- Privileges required

2013-09-05T06:24:00.000-07:00

Open Active Directory Users and Computers. To do this, click Start, click Run, type dsa.msc, and then click OK.

On the View menu, make sure that Advanced Features is enabled.

Right-click the organizational unit (OU) that contains the CRM security groups, click Properties.

On the Security tab, add the user account, and then grant the Full Control permission to the added user account.

Repeat the same step for the following CRM security groups that can be located under the OU:

PrivUserGroup

SQLAccessGroup

ReportingGroup

PrivReportingGroup

Now you should be able to create an organization successfully.

Close the laptop and view the display from external monitor.

2013-09-05T06:22:00.002-07:00

It is possible to close the monitor and view the display the in an external monitor. Please perform the below steps for the same on Win7 OS.

Go to control panel and click on Power options
In the left hand navigation, Click on "Choose what closing the lid does".
Select "DO Nothing" for all the options you see in that window.
Now, to divert the display to the external monitor, click on "Windows key + P"
Click on projector only.

Now you should be able to see the close the laptop and work on the external monitor.

HTTP ERROR 500.22 – Internal Server Error. An ASP.NET setting has been detected that does not apply in Integrated Managed Pipeline mode.

2012-11-26T11:06:00.000-08:00

Issue

---------------------

HTTP ERROR 500.22 – Internal Server Error.”

“An ASP.NET setting has been detected that does not apply in Integrated Managed Pipeline mode.”

Solution

------------------

Ensure the application pool configured for the MS Dynamics CRM application is correct and has the correct privileges.

Data scrubbing using SQL functions for SQL Server

2011-06-27T10:34:00.000-07:00

Many a times, it is required to scrub the data before it is used in development environments as the data may be sensitive and cannot be shared with the vendors. The below SQL functions can be used to scrub the data.

--Creating the User defined function

CREATE FUNCTION getRandomText(@sLength TINYINT)

RETURNS VARCHAR(10)

BEGIN

DECLARE @counter TINYINT

DECLARE @nextChar CHAR(1)

DECLARE @randomString VARCHAR(50)

SET @sLength=10

SET @counter = 1

SET @randomString = ''

WHILE @counter <= @sLength

BEGIN

SELECT @nextChar = CHAR(ROUND((SELECT r FROM getRand) * 93 + 33, 0))

IF ( (ASCII(@nextChar) between 65 and 90) or (ASCII(@nextChar) between 97 and 122) )

BEGIN

SELECT @randomString = @randomString + @nextChar

SET @counter = @counter + 1

END

return @randomString

END

-- Creating the User defined function

CREATE FUNCTION getRandomNumber()

RETURNS INT

BEGIN

RETURN ROUND((SELECT r FROM getRand) * 10000, 0)

END

Convert fetchXML to SQL Query in MSCRM 4.0

2011-06-27T10:21:00.000-07:00

If for some sane reasons if fetchxml needs to be converted to a SQL Query in MSCRM 4.0, it is possible.

It actually requires the below DLL's which are avilable in the folder Server\setup
Microsoft.Crm.dll, Microsoft.Crm.Platform.Server.dll and Microsoft.Crm.Reporting.dll

The code looks as below :

Microsoft.Crm.BusinessEntities.ExecutionContext myContext = new Microsoft.Crm.BusinessEntities. ExecutionContext (OrganizationId from the context);
myContext.OnBeginRequest(UserId, false);

Microsoft.Crm.Reporting.ReportQueryBuilder myreportQueryBuilderObj = new ReportQueryBuilder();
string Query = myreportQueryBuilderObj.BuildReportQuery(fetchXml, myContext);

The query will be returned as string. The Query is not readable but it works, -:)

An ASP.NET setting has been detected that does not apply in Integrated managed pipeline

2011-06-27T10:12:00.000-07:00

In web.config file, system.webServer tag, for the validation element set the value of the attribute validateIntegratedModeConfiguration to false.

This infact helped in my case.

MS Excel 2010 shortcut keys

2011-05-26T10:41:00.000-07:00

Shortcut Keys Description
F2 ------Edit the selected cell.
F5-------Go to a specific cell.
F7-------Spell check selected text and/or document.
F11----------Create chart.
Ctrl + Shift + ; ----- Enter the current time.
Ctrl + ; ------------- Enter the current date.
Alt + Shift + F1 ----------------Insert New Worksheet.
Shift + F3 ---------- Open the Excel formula window.
Shift + F5--------------------Bring up search box.
Ctrl + A ------------- Select all contents of the worksheet.
Ctrl + B ------------ Bold highlighted selection.
Ctrl + I --------------Italic highlighted selection.
Ctrl + K ------------- Insert link.
Ctrl + U ---------------- Underline highlighted selection.
Ctrl + 5 ------------- Strikethrough highlighted selection.
Ctrl + P ------------ Bring up the print dialog box to begin printing.
Ctrl + Z------------ Undo last action.
Ctrl + F9-------------- Minimize current window.
Ctrl + F10 ------------ Maximize currently selected window.
Ctrl + F6 ------------- Switch between open workbooks / windows.
Ctrl + Page up --------- Move between Excel work sheets in the same Excel document.
Ctrl + Page down ------------Move between Excel work sheets in the same Excel document.
Ctrl + Tab ----------------- Move between Two or more open Excel files.
Alt + = ------------------- Create a formula to sum all of the above cells
Ctrl + ‘ --------------- Insert the value of the above cell into cell currently selected.
Ctrl + Shift + ! ------------- Format number in comma format.
Ctrl + Shift + $ ------------ Format number in currency format.
Ctrl + Shift + # ---------- Format number in date format.
Ctrl + Shift + % ---------- Format number in percentage format.
Ctrl + Shift + ^ ------------- Format number in scientific format.
Ctrl + Shift + @ ------------ Format number in time format.
Ctrl + Arrow key ---------- Move to next section of text.
Ctrl + Space ------------ Select entire column.
Shift + Space ------------- Select entire Row.

Check for subject in OUTLOOK

2011-05-26T10:28:00.000-07:00

Steps:
1.Open your outlook
2.Press Alt+F11. This opens the Visual Basic editor
3.On the Left Pane, one can see " Microsoft Outlook Objects", expand this. Now one can see the "ThisOutLookSession".
4.Click on "ThisOutLookSession".
5.Copy and Paste the following code in the right pane. (Code Pane)

Code:


Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) 
  Dim strSubject As String 
  strSubject = Item.Subject 
  If Len(strSubject) = 0 Then 
      Prompt$ = "Subject is Empty. Are you sure you want to send the Mail?" 
      If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, "Check for Subject") = vbNo  Then 
              Cancel = True 
      End If 
  End If 
End Sub

6.Save this and Now close the VB Code editor.
7.In Outlook Go to Tools > Macros > Security > In the Security Level Tab > Select the option MEDIUM > OK
8.Now Restart the Outlook, a dialog box pops up to Disable / Enable the macros; select as Enable Macros (this option will pops up when ever you restart outlook.
9.From now on , this macro will make sure you do not make the mistake of sending a mail without subject

Advanced Find page does not show the custom entities in the look for dropdown

2011-05-12T08:04:00.000-07:00

If the URL for adavnced find page misses Organization name in the URL .i.e, if the URL is without the organization name, then the Look For dropdown which lists all entities does not list the custom entities with in that organization. It will only list the OOB entities which are common to all the organizations. Of course, this makes sense.

If URL is included, then the lookfor dropdown shows all the entities inlcuding the custom entities in that organization.

This bugged me for a while today.

Convert DateTime to CrmDateTime in MSCRM 4.0

2010-12-27T17:29:00.000-08:00

Use the below method to convert dateTime to CrmDateTime in MSCRM 4.0.

public static CrmDate ConvertToCRMDateTime(DateTime dateTime
{
          CrmDateTime crmDateTime = new CrmDateTime();
          crmDateTime.date = dateTime.ToShortDateString();
          crmDateTime.time = dateTime.ToShortTimeString();
         TimeSpan offset = TimeZone.CurrentTimeZone.GetUtcOffset(dateTime);
         string sOffset = string.Empty;
        if (offset.Hours < 0)
             {
                        sOffset = "-" + (offset.Hours * -1).ToString().PadLeft(2, '0');
            }
     else
         {
                      sOffset = "+" + offset.Hours.ToString().PadLeft(2, '0');
          }
      sOffset += ":" + offset.Minutes.ToString().PadLeft(2, '0');
     crmDateTime.Value = dateTime.ToString(string.Format("yyyy-MM-ddTHH:mm:ss{0}", sOffset));
     return crmDateTime;
}

ERROR after configuring from HTTP to HTTPS

2010-09-29T22:42:00.000-07:00

When I configure MSCRM from http to https ,I met some strange issues.

I received the error information as below :

System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid according to the validation procedure. at System.Net.Security.SslState.StartSendAuthResetSignal(ProtocolToken message, AsyncProtocolRequest asyncRequest, Exception exception) at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte[] buffer, AsyncProtocolRequest asyncRequest) at System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult) at System.Threading.ExecutionContext.runTryCode(Object userData) at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Net.TlsStream.ProcessAuthentication(LazyAsyncResult result) at System.Net.TlsStream.Write(Byte[] buffer, Int32 offset, Int32 size) at System.Net.PooledStream.Write(Byte[] buffer, Int32 offset, Int32 size) at System.Net.ConnectStream.WriteHeaders(Boolean async) --- End of inner exception stack trace --- at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request) at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

Solutoin

--------------

In the application config file make this setting.

<system.net>
<settings>
<servicePointManager checkCertificateName="false" />
settings>
system.net>

History -- MS Dynamics CRM

2010-09-23T06:12:00.000-07:00

• Microsoft CRM 1.0

Microsoft CRM 1.0 launched in January 2003.

• Microsoft CRM 1.2

Microsoft CRM 1.2 was released on December 8th 2003[3]. Microsoft CRM 1.2 was not widely adopted by industry.

• Microsoft Dynamics CRM 3.0

The second version was rebranded as Microsoft Dynamics 3.0 (version 2.0 was skipped entirely) to signify its inclusion within the Dynamics product family and was released on December 5th, 2005 [4]. Notable updates over version 1.2 are the ease of creating customizations to CRM, the switch from using Crystal Reports to Microsoft SQL Reporting Services, the ability to run on Windows Vista and Outlook 2007, and support for Exchange 2007.

Significant additions released later by Microsoft also allowed Dynamics CRM 3.0 to be accessed by various mobile devices and integration with Siebel.

This was the first version that saw reasonable take up by customers.

• Microsoft Dynamics CRM 4.0

Dynamics CRM 4.0 introduced in December 2007 . It features multi-tenancy, improved reporting security, data importing, direct mail merging and support for newer technologies such as Windows 2008 and SQL 2008 (Update Rollup 4).

Dynamics CRM 4.0 also implements CRM Online, a hosted solution that is offered directly from Microsoft. The multi-tenancy option also allows ISVs to offer hosted solutions to end customers as well.

Dynamics CRM 4.0 is the first version of the product which has seen significant takeup in the market and passed the 1 million user mark in July 2009 .

MS Dynamics CRM 2011

2010-07-24T10:50:00.000-07:00

Microsoft gives a new name "Dynamics CRM 2011" which was earlier code named as CRM 5.

Lookup page displayed on click of addexisting throws error.

2010-06-16T17:23:00.000-07:00

Look up - web page dialog error message appears when you Add an existing entity to a another entity. This error is due to more than 18 columns being displayed in the lookup view. To fix this error the number of columns in the lookup view needs to be reduced to 18.

All Lookup pages in MS CRM throw error

2010-06-16T17:16:00.000-07:00

All the look up pages shows the generic error message and does not show up the look pages. This is because the users do not have access to the folder "\Microsoft CRM\Server". This folder requires Read/Execute/List permission to be given for the users. After thse permissions are given, all the lookup pages worked fine.

Mail sent from MS CRM is not visible in the sent items folder in OUTLOOK of the user

2010-06-16T16:51:00.000-07:00

If the mails sent from MSCRM needs to be visible in the sent items folder in the OUTLOOK, then outgoing email access type should be set to "Microsoft dynamics crm for Outlook". Only in this case the sent emails from MSCRM will be visible in the sentitems folder in the Outlook.

GUID value is displayed instead of the report name when client activity report is exported to excel .

2010-06-16T16:40:00.000-07:00

In CRM 3.0, when a report is exported to excel it shows the name of the report as the reports are uniquely identified using name of the report. In CRM 4.0, when a report is exported to excel, it shows the guid of the report as a report is uniquely identified by a guid. So this is a change of behaviour in MS CRM 4.0.

Grid Refresh Failed.

2010-06-16T15:40:00.000-07:00

When user clicks on the columns which are of type "picklist" in an assocaited view, an error message will be thrown "Grid Refresh failed". The reason for this issues is the data corruption. All the values in picklist should have corresponding values in the stringmap table. If there are records with picklist values for which there is no corresponding values in the string map table, then the generic error will be shown. The grid will show "Grid Refresh failed.". In our case we have cleaned up the data to correct this problem. The way to find out all these records is,,,
1. Go to Advanced find.
2. Select the entity for which this error occurs. (For Ex: Account).
3. Select the column which is of type "picklist".
4. Select the operator as "Does not Equal".
5. In the pop up for selecting the picklist values choose all the values.
6. Click on Find.

This query gives all the records which does not have valid picklist values in them. Update these records and the error will be gone.