Archive for March, 2011

Recently Received a query from user, at times users open plan from server without noticing that plan is already checked out, hence ending up opening plan in read only mode (though the open dialog box itself displays the project check in state and whom it is checked out to, but doesn’t displays any warning in form of pop up or message box ), hence they make all the changes without realizing untill they try to save the plan 😦

So here is a quick n easy solution by which you can explicitly notify users, in case they open plan in read only mode,
place the macro given below in global file, which would fire on Project Open event and would notify users just in case plan has been opened up in read only mode, thereby saving hours of planning effort 🙂

Sub TestProjectReadOnlyState()
    If ActiveProject.ReadOnly = True Then
        MsgBox (“Project has been opened in Readonly mode, changes made will not be saved”)
    End If
End Sub

Read Full Post »

All is well, except one small exception, documented known issue with editing some of the grids in Project Server 2007 and Project Server 2010. When the entire contents of an editable cell are deleted, that cell becomes un-editable until the page is refreshed. Therefore, when modifying the content of a cell, you must ensure that all the content of the cell is not completely removed. To completely replace the contents of the cell, select the whole text and replace that with the new string.

For more information refer : http://blogs.technet.com/b/projectadministration/archive/2011/03/15/microsoft-project-server-2007-2010-internet-explorer-9-support.aspx?goback=%2Egde_867507_member_47065389

Read Full Post »

Many a times we need to enforce users for certain compliances like DONOT use Local Resource, it affects demand management data 😉 so to warn every project manager when they save their plan fire the below mentioned macro just to warn them that they are using local resource in their plan 

Sub CheckLocalResources()
   Dim res As Resources
    Set res = ActiveProject.Resources
    Dim r As Resource

    For Each r In res

        If r.EnterpriseUniqueID = -1 Then ‘ -1 means it’s a local resource
            MsgBox (r.Name)
        End If
    Next r
End Sub

Read Full Post »

Much like PS 2003 had an Admin guide, for PS 2010 MS now officially launches the PS 2010 Admin Guide, Download and enjoy

Download Here : http://go.microsoft.com/fwlink/?LinkId=212383
















Read Full Post »




Thanks all for your support 🙂 Which helped me getting this award
Special thanks to all who recommended

Read Full Post »

At times i have seen requests coming for extending the PWA instance for Extranet / Internet Environment i.e. having different protocol / authentication mechanism , wherein in intranet you could use it with Windows Auth. & HTTP whereas on internet it should be on HTTPS & Claims / Forms / other Auth. mechanism involved here are the steps for doing the same 🙂

Note : i have hidden / blurred some piece of information for practical purpose, hope you don’t mind

Navigate to CA >> manage Web Application

Select the Web App you want to Extend ( i.e. You existing PWA)

On the Ribbon >> Click Extend >> You will get a new dialog box Selct a new Port for extending it onto >> Select Protocol as SSL

Once Extend is Done You would see the URL listed in Web Application List, Next navigate to CA >> Application Management >>
Configure Alternate Access Mapping

Though this URL should have been automatically added into the AAM, but still i want to give it a name of my choice >>
Select the web app >> Edit Public URL

Select Web App

Give it a name , as you could see i have given it a name in custom field, you may opt to choose Internet / External

So now you are done with the sharepoint configuration, still you won’t be able to browse the site, since you have extended the new
web app as SSL but you haven’t attached a certificate to the web app, for this environment i am going to create a self signed certificate and
attach it to site

Now Navigate to IIS Manager (on the command prompt type >> Inetmgr) >> Select the Web Server >> Click on Server Certificate

On the right Action pane >> Click Create Self Signed Certificate

Make sure you give the certificate name same as your URL name, else a name mismatch would happen 🙂
In IIS 7 its bit difficult to rename the certificate, alternatively you can still use IIS 6.0 resource kit to generate certificate of your choice
with different option and once created you can import in IIS7

Now Bind the certificate to the extended new URL >> Select the extended web app >> on the right action pane >> click edit binding
>> edit the Site >> Select the newly created or imported certificate

And Bingo You are done ( you may need to restart the IIS), the below image has my regular Intranet PWA

and in the next image you could see the extended Web App on HTTPS 🙂

Notice the URL and certificate 🙂

Read Full Post »