Posts

HOW TO REMOVE THE TFS ASSOCIATION FROM MPP FILE.

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

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 day...

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

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

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

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

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 --

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 crea...

Create new Organization -- Privileges required

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.

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.

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

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)   AS                 BEGIN                  DECLARE @counter TINYINT                  DECLARE @nextChar CHAR(1)                  DECLARE @randomString VARCHAR(50)                    SET @sLength=10                  SET @counter = 1                  SET @randomString = ''              ...

Convert fetchXML to SQL Query in MSCRM 4.0

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

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

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 ----...

Check for subject in OUTLOOK

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...

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

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

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...

ERROR after configuring from HTTP to HTTPS

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.ProcessReceiv...

History -- MS Dynamics CRM

• 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-tenanc...

MS Dynamics CRM 2011

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