SharePoint (and Project Server) Shenanigans

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

One question we have from many clients is, can we have the project timeline image on the project site. The answer is yes, but this will not update automatically in Project Server 2010. On a side note, it is possible to have the timeline view in Project Server 2013 PWA!

This blog post covers a workaround to this limitation in Project Server 2010 using VBA. At this point I will state that I am no VBA expert, my VBA knowledge is very limited to say the least. This is a simple macro but I’m sure it could be improved  

For this to work a custom DLL is required on the workstations as there is no option to save a clipboard image to a file in VBA (as far as I know!). The DLL can be downloaded here: http://www.vbforums.com/showthread.php?585616-clipboard-activex-for-vba-vbs-etc Use this at your own risk as I do not know the code behind this DLL!

For this example, I created a file share to store my images \\vm353\ProjectSiteTimeLineImages. All users will need read / write access to this share.

The VBA code can be seen below, add this to the Enterprise Global:

Private Sub App_ProjectBeforePublish(ByVal pj As Project, Cancel As Boolean)
Dim clip As Object
Dim proj As Project
Set proj = ActiveProject
Dim path As String
path = "\\vm353\ProjectSiteTimeLineImages\"
Dim file As String
file = ".bmp"
Dim fileName As String
fileName = path & proj & file

Application.ViewApply Name:="Timeline"
Application.TimelineExport SelectionOnly:=0, ExportWidth:=1000
Application.ViewApply Name:="Gantt Chart"
Set clip = CreateObject("clipbrd.clipboard")
SavePicture clip.GetData, fileName
Set clip = Nothing
End Sub

Before a project is published the timeline image will be saved as a file to the share. See the example / walkthrough below:

File share before publish:

Create a new project, save and publish:

File share after publish:

Image:

Now we have the timeline as an image, this needs to be added to the project site – I won’t go into the details as this is basic SharePoint end user config task. See the Project site below with the image:

Notice only 3 tasks are added to the timeline, lets add some additional tasks.

I have added task T5 and added this to the timeline:

After publishing this project, refresh the project site:

A nice simple solution to a dynamic timeline image on the Project Server 2010 Project Sites. After publishing more projects, more timeline images will appear in the shared folder:

As mentioned, the VBA could be improved with error handling etc. Use this and the custom DLL at your own risk and fully test on a test workstation and PWA instance first.

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

Quite often system administrators want a way to automate tasks, creating the Project Server Project Professional  accounts is usually one of these tasks. This blog post shows an example of creating a Project Professional 2010 account.

The script can be downloaded from the Script Center following the link below:

http://gallery.technet.microsoft.com/scriptcenter/Create-Server-2010-dfb0fbba

When creating an account, a registry key is created here:

HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\MS Project\Profiles\<Profile Name>

After running the script, a new registry key will appear:

Script:

Before running the script you will need to update two variables, $accountName and $pwaURL with the correct values.

New Key after executing the script:

As you can see, the script on creates three string values, the rest get created when you launch Project Professional 2010 and connect to the new account:

New account:

Additional string values:

A simple solution for creating Project Professional 2010 accounts.

I recommend that this script is tested thoroughly on a test workstation before using within a production environment.

This script is just an example, use this script at your own risk. Remember to always backup the Registry before making any changes.

This script is probably a better approach to the Registry key export detailed in a post I wrote a while back:

http://pwmather.wordpress.com/2011/07/29/customise-project-professional-2010-installation-projectserver-ps2010-msproject-office2010/

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

Just a quick post to highlight a product from CPS, Project Server Plus. This is a quick start preconfigured Project Server solution includes best practice fields and lookup tables, Views, RAG calculations and indicators, many great dashboards / reports and an enhanced Project Site template – all out of the box.

For details see:

http://www.cps.co.uk/What-We-Do/Pages/Project-Server-Plus.aspx