Archive
#Project-on-a-page for #Microsoft #ProjectOnline #PS2013 #JavaScript #jQuery #Office365 #SharePoint
|
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) |
This script will display project information including project level data, milestones, issues and risks on one page on the associated Project Site in Project Online. The script can be downloaded from the script gallery below:
To get the script to work you will need to download the following jQuery library: jquery-2.1.1.min.js – jQuery download Another version of this library may work but this was the one I used / tested with. Upload this library to your PWA site collection then update the script file with the correct location. I uploaded this file to the site collection document library as you can see in the code below:
Also notice the reference to the two references to the Data tables CSS and JS files. I just referenced the hosted files but you could download these and host them yourself – if hosting the data table files yourself you will need more than just the two files reference here.
Worth noting, the script will also work for Project Server On-prem but the milestone query will need to be updated to use JSOM REST (/api/ProjectServer/) as the ProjectData ODATA feed has a bug with filtering for boolean fields. The query will need to be updated to use the REST fields – these are named different to the ODATA equivalents.
In this example i had the jQuery library and the “Projectonapage on project site.js” file uploaded the site collection documents library but in reality you would probably load both of these somewhere else in the PWA site collection but the choice is yours. I then created a page on my Project Site just in the Shared Documents library but again, create the page where you like within your Project Site. On the page I add a content editor web part and reference my “Projectonapage on project site” JavaScript file. I also added a link on the Project Site quick launch to my new page. The output can be seen below.
When the page loads the dialog box below will display until all the data has been loaded:
Once loaded, the page will contain the project data:
This only uses intrinsic fields so should work for any Project Online environment but do test it thoroughly first. You might want to improve the error handling etc. before deploying to a production environment.
#ProjectOnline performance and scale improvements #Office365 #MSProject #PS2013
|
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) |
Project Online is continuing to go from strength to strength with improvement changes and features being introduced frequently. An example of this is detailed in the link below:
This is the type of benefit you get when using a service hosted and maintained by Microsoft!
#Microsoft #ProjectOnline Reporting Pack v2 #MSProject #SharePointOnline #Office365 #PPM #Excel #BI #Data
|
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) |
Following on from my recently released Project Online Reporting Pack, I have since added a new report to the pack – a milestone variance chart. This report is detailed in this post. For screenshots of the other reports and deployment steps, see:
The v2 Project Online Reporting pack with the 6 reports can be downloaded here:
Milestone Variance Report:
This report will show all of the marked milestones for the projects in the portfolio, you can filter by the Enterprise Project Type:
Look out for more reports / updates in the future.
#ProjectServer and #SharePoint 2010 / 2013 October 2014 Cumulative Update #PS2010 #SP2010 #PS2013 #SP2013 #MSProject
|
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) |
The Office 2013 October 2014 Cumulative Updates are now available, please see the links below:
Project Server 2013 October 2014 Server Roll up package:
**** No Project Server 2013 server roll up packages for October 2014, see http://bit.ly/1yGzpuQ ***
Project Server 2013 October 2014 CU:
http://bit.ly/1u8qATw
Project 2013 October 2014 CU:
http://bit.ly/1yGzqyL
Also worth noting, if you haven’t done so already, install the March 2013 Public update: http://bit.ly/1lR8IgK if installing the October 2014 CU.
The Office 2010 October 2014 Cumulative Updates are now available, please see the links below:
Project Server 2010 October 2014 Server Roll up package:
**** No Project Server 2010 packages for October 2014, see http://bit.ly/1yGzqyM ***
Project Server 2010 October 2014 CU:
http://bit.ly/1u8qA65 & http://bit.ly/1yGzsqg
Project 2010 October 2014 CU:
http://bit.ly/1yGzsqh
Remember SP1 or SP2 is a pre-requisite for the Office 2010 October 2014 CUs.
As always, test these updates on a replica test environment before deploying to production.
New Milestone Gantt #App for #ProjectOnline & #ProjectServer #PS2013 #Office365 #Project #PMO #BI
|
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) |
CPS’ 4th SharePoint hosted app has been released into the App store. The app is called the “Milestone Gantt” app. The app can be downloaded here:
This app displays project milestones on a Gantt style chart, see the screen shots below:
The app has configuration options to enable the Project Web App administrators to configure the settings to meet the organisations requirements.
For more details see the user guide here.
For more CPS apps see the link below:
Excel Calculation Services and RBS
On a recent project I came across a strange problem with Excel Calculation Services.
On a SharePoint 2013 farm with multiple web applications, Excel services was working perfectly on a couple of the web applications but not on others. The trusted locations and process identity settings were set and checked but were not at fault, digging through the ULS logs was showing this.
10/01/2014 15:37:57.58 w3wp.exe (0x7130) 0x4220 Excel Services Application Excel Calculation Services ech0 Medium ExcelService.PostProcessRequest: web method: OpenWorkbook, got exception Id=GenericFileOpenError; Microsoft.Office.Excel.Server.CalculationServer.FileOpenException: The workbook cannot be opened. —> Microsoft.Office.Excel.Server.Host.HostFileException —> Microsoft.SharePoint.SPException: Cannot complete this action. Please try again. —> System.Runtime.InteropServices.COMException: Cannot complete this action. Please try again.
at Microsoft.SharePoint.Library.SPRequestInternalClass.GetFileAsStream(String bstrUrl, String bstrWebRelativeUrl, Boolean bHonorLevel, Byte iLevel, OpenBinaryFlags grfob, String bstrEtagNotMatch, Object punkSPFileMgr, Boolean bHonorCustomIrm, IrmProtectionParams fileIrmSettings, UInt32& pdwVirusCheckStatus, String& pVirusCheckMessage, String& pEtagNew, String& pContentTagNew, SPFileInfo& pFileProps)
at Microsoft.SharePoint.Library.SPRequest.GetFileAsStream(String bstrUrl, String bstrWebRelativeUrl, Boolean bHonorLevel, Byte iLevel, OpenBinaryFlags grfob, String bstrEtagNotMatch, Object punkSPFileMgr, Boolean bHonorCustomIrm, IrmProtectionParams fileIrmSettings, UInt32& pdwVirusCheckStatus, String& pVirusCheckMessage, String& pEtagNew, String& pContentTagNew, SPFileInfo& pFileProps) — End of inner exception stack trace —
at Microsoft.SharePoint.SPGlobal.HandleComException(COMException comEx)
at Microsoft.SharePoint.Library.SPRequest.GetFileAsStream(String bstrUrl, String bstrWebRelativeUrl, Boolean bHonorLevel, Byte iLevel, OpenBinaryFlags grfob, String bstrEtagNotMatch, Object punkSPFileMgr, Boolean bHonorCustomIrm, IrmProtectionParams fileIrmSettings, UInt32& pdwVirusCheckStatus, String& pVirusCheckMessage, String& pEtagNew, String& pContentTagNew, SPFileInfo& pFileProps)
at Microsoft.SharePoint.SPFile.GetFileStream(SPWeb web, String fileUrl, Boolean honorLevel, SPFileLevel level, OpenBinaryFlags openOptions, String etagNotMatch, SPFileStreamManager spMgr, SPFileRightsManagementSettings rightsManagementSettings, Boolean throwOnVirusFound, SPVirusCheckStatus& virusCheckStatus, String& virusCheckMessage, String& etagNew, String& contentTagNew, SPFileInfo& fileprops)
at Microsoft.SharePoint.SPFile.GetFileStream(OpenBinaryFlags openOptions, String etagNotMatch, String& etagNew, String& contentTagNew)
at Microsoft.SharePoint.SPFile.OpenBinaryStream(SPOpenBinaryOptions openOptions, String etagNotMatch, String& etagNew)
at Microsoft.SharePoint.SPFile.OpenBinaryStream(SPOpenBinaryOptions openOptions)
at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.FetchStreamInternal() — End of inner exception stack trace —
at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.FetchStreamInternal()
at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.FetchStream(IIdentity currentIdentity)
at Microsoft.Office.Excel.Server.CalculationServer.SharePointFileLoader.FetchStream() — End of inner exception stack trace —
at Microsoft.Office.Excel.Server.CalculationServer.SharePointFileLoader.FetchStream()
at Microsoft.Office.Excel.Server.CalculationServer.BaseWorkbookManager.CacheStream(CachedFile cachedFile, FileLoader loader)
at Microsoft.Office.Excel.Server.CalculationServer.BaseWorkbook.Microsoft.Office.Excel.Server.CalculationServer.ICachedFileProvider.SaveFile(CachedFile cachedFile)
at Microsoft.Office.Excel.Server.CalculationServer.CachedFile.SaveFile(ICachedFileProvider fileProvider)
at Microsoft.Office.Excel.Server.CalculationServer.LocalDiskCache.ReserveCachedFileAndMarkUsed(FileId fileId, ICachedFileProvider fileProvider, Boolean replaceExistingFile)
at Microsoft.Office.Excel.Server.CalculationServer.BaseWorkbook.ReserveCachedFileAndMarkUsed(FileLoader fileLoader, SessionId previousSessionId)
at Microsoft.Office.Excel.Server.CalculationServer.BaseWorkbook.<FileStreamJob>b__e(IssueLoadThreadArg arg)
at Microsoft.Office.Excel.Server.CalculationServer.BaseWorkbook.ExecuteWorkbookJob(WorkbookJobDelegate workbookJob, Object param) 24e5bd9c-6708-8070-314e-c1443430d9e0
Looking at the Excel Services file cache for a working request we were seeing this.
but for a non working request we were seeing this.
the only commonality seemed to be that the non-working web applications were using RBS for BLOB storage.
Digging through the ULS logs some I finally found the following error.
System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object ‘rbs_fn_get_blob_reference’
A quick google turned up some blogs about database permissions for service accounts, following this blog http://blog.sharepointsite.co.uk/2014/01/sp-2013-ssrs-failing-after-rbs-enabled.html
I added the db_rbs_admin database role to the Excel Services service account for each RBS enabled database and Excel services sprang into life.
SharePoint (and Project Server) Shenanigans 