Want to capture the last logon time for the #ProjectOnline PWA users? #PPM #JavaScript #Office365 #SharePoint

September 30, 2016 at 2:19 pm | Posted in Add-on, Administration, Configuration, Customisation, Functionality, Information, Reporting | 2 Comments
Tags: , , , ,

This is a supporting blog post for a new JavaScript file I have published to the Microsoft Gallery, it can be downloaded here:


Microsoft recently removed the Last Logon details from the Manage Users page in PWA settings for Project Online – Microsoft’s PPM tool. This simple script is an alternative solution that will capture the last logon for the Project Web App users. It wont capture the last logon from Project Professional or if a user accesses the API’s etc., it will only capture the last logon from the page the script is added to. In this example I have added the script to the homepage, so if a user has the Project Center saved as a favourite link and bypasses the PWA homepage then their logon would not be captured. You could add the script to multiple PWA pages if required.

When a user accesses the PWA homepage for the first time that day, an item is created on the SharePoint list in the PWA site, it only captures the logon once per day. See an example on my demo instance:


It captures the user name, the logon data and the browser that was used. This list will need to be created manually with the following details:

List Name: PWAUsageList



The LogonDate column setting defaults to Today:


Once the list is set up, upload the JavaScript file to a library on the PWA site then the script can be added to the PWA homepage using a content editor web part:


Reference the location of the PWAUsage.js file – in this example I added the JavaScript file to the Shared Document library in the PWA site, also notice the Chrome Type is set to None so nothing is visible on the PWA homepage.

That is it, it will now capture the users who access the PWA homepage. Once you have the data on the list you can then create a report for that data. I will publish a blog post in the next week or so that details this but for now here is an example report screen shot in Power BI:


Fully test this on a non-production PWA instance before rolling out to Production, the script is provided As Is with no warranties etc. Try it out and let me know what you think.

#Office365 Project Time Reporter mobile app for #iOS released #ProjectOnline #PPM #Timetracking

September 21, 2016 at 10:49 am | Posted in Add-on, Administration, App, Functionality, Information, Mobile | Comments Off on #Office365 Project Time Reporter mobile app for #iOS released #ProjectOnline #PPM #Timetracking
Tags: , , , , ,

Yesterday saw the release of the Office 365 Project Time Reporter mobile app for Apple’s iOS, see the announcement here: https://blogs.office.com/2016/09/20/announcing-the-availability-of-office-365-project-time-reporter/

This post gives a walkthrough on getting started and using the app on your iOS device. Firstly download the app for your iOS device from the Apple store:


Once completed locate the Project Time Reporter app:

app icon

On first launch you will be required to enter the Project Online PWA URL:


You will then see the login screen:


Enter your Office 365 credentials and click Sign In and you will see the loading screen briefly whilst the data is loaded:


Once completed you will see the Timesheet for this period:


From here you can enter the actuals as needed. Using the green control menu at the bottom of the app you can scroll between timesheet periods using the previous and next buttons, add a row, save the timesheet, send the timesheet or filter the projects. Using the ellipsis in the top right hand corner you can access other timesheet options such as refresh, go to current period, summary, send progress for all tasks or manage timesheets. The app menu in the top left corner enables you to access the app settings, here you can switch to the tasks view or see the app settings. Below you will see screen shots of some of these features.

Firstly the app menu screen, here you can view Timesheet, Tasks or Settings:

app menu

On Settings you can view the PWA URL and username and turn on two options:

app settings

I turned on the planned time in my app:

timesheet with planned work

To enter time just click in the box for the day you want to add time to:

timesheet actuals

You can use the Save button on the green menu at the bottom of the app to save the timesheet or send the timesheet using the send button. If you have many projects on the current timesheet you can using the filter option:

filter projects

If you want to send progress, click the ellipsis in the top right corner:

timesheet options

Here you will also see other options such as Summary:

timesheet summary

Manage Timesheets:

manage timesheets

On the timesheet view you can add rows using the Add button on the green menu:

add row in TS

We have focused on the Timesheet view here but there is also a Tasks view that is accessible from the app menu > Tasks:


You can change the view by clicking the Current Tasks heading:

task views

You can access the task options to filter and sort the tasks using the ellipsis in the top right hand corner:

task options

Selecting a task will take you to the task details screen:


To edit a task click Edit in the top right hand corner:


Make any changes as needed and click Save or Send.

Download it today and see what you think – it will make the timesheet / task update process so easy when you are on the move!

#ProjectServer and #SharePoint 2013 / 2016 September 2016 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject

September 14, 2016 at 8:36 am | Posted in Administration, CU, Fixes, Functionality, Information | Comments Off on #ProjectServer and #SharePoint 2013 / 2016 September 2016 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject
Tags: , , , , ,

The Office 2016 September 2016 updates and cumulative updates are now available, please see the links below:


Project 2016 September 2016 update:

SharePoint Server 2016 September 2016 update – Project Server 2016 fixes:
https://support.microsoft.com/en-gb/kb/3118289 & https://support.microsoft.com/en-gb/kb/3118295

The Office 2013 September 2016 updates and cumulative updates are now available, please see the links below:


Project Server 2013 September 2016 CU Server Roll up package:

Project Server 2013 September 2016 update:

Project 2013 September 2016 update:

Also worth noting, if you haven’t done so already, install Service Pack 1 http://support2.microsoft.com/kb/2880556 first if installing the September 2016 CU.

The Office 2010 September 2016 updates and cumulative updates are now available, please see the links below:


Project 2010 September 2016 update:

As always, fully test these updates on a replica test environment before deploying to production.

Error creating Project Sites from custom site template in #ProjectOnline / #SharePoint Online #PPM #Office365

September 1, 2016 at 4:30 pm | Posted in Administration, Configuration, Customisation, Fixes, Functionality, Information, Issue, Workarounds | Comments Off on Error creating Project Sites from custom site template in #ProjectOnline / #SharePoint Online #PPM #Office365
Tags: , , , , ,

A quick post, if you are finding that all of a sudden your project sites are failing to create with the error below:

CreateWssSiteContent: Creating project site failed! Project Uid= <site details> Microsoft.SharePoint.SPException: The site template requires that the Feature {e995e28b-9ba8-4668-9933-cf5c146d7a9f} be activated in the site collection. at Microsoft.SharePoint.Utilities.SPUtility.ThrowSPExceptionWithTraceTag

Chances are you using a custom site template and this stopped working within the last week or so. The feature ID SharePoint is complaining about is a “MobileExcelWebAccess” feature. This can’t just be enabled.

The fix is straightforward, locate the site which you used to create the site template and save that site as a template again with a different name / version then link this to the Enterprise Project Type/s. Repeat this for all custom site templates.

Blog at WordPress.com.
Entries and comments feeds.