New Work Viewer #App for #ProjectOnline & #ProjectServer #PS2013 #SharePoint 2013 #Office365 #PM #PMO #Project #BI

CPS’ 3rd app is now available in the Microsoft App Store. The app is called “Work Viewer” and can be downloaded here: http://office.microsoft.com/en-us/store/work-viewer-WA104239103.aspx The Project Server Plus Work Viewer app will give users instant visibility of resource assignments and availability for the chosen resources over the selected timeframe. The app will quickly alert the user...

#ProjectOnline data via #ODATA and #SSIS in #SQL database table on-premise #MSProject #SharePointOnline #BI #SSRS #Office365 #Cloud

Following on from my post earlier today regarding the SSIS component that enables you to extract data from ODATA feeds in Office 365, I have created a blog post that demonstrates this new functionality. See the steps below: Firstly I installed the SQL Server data tools and Integration Services feature on my Test Project Server...

#Odata #SQL SSIS component now available for SQL Server 2012 #ProjectOnline #SSRS #SharePointOnline #SharePoint #BI

Quick post to let you know that the SSIS component to export data via ODATA that was mentioned here is now available for download, see the link below: http://www.microsoft.com/en-us/download/details.aspx?id=42280 This will enable you to copy data from Project Online into a custom SQL database, from there you can easily create SSRS reports, custom OLAP cubes,...

#ProjectServer #PS2010 / #PS2013 bulk #Project site creation using #PowerShell 3.0 or later #SP2013 #SP2010

I recently had to bulk delete and then bulk create project sites for a client. Rather than engaging one of our devs I wrote a PowerShell script to do this. This does need PowerShell 3.0 or later to work. This post covers the bulk create script as this is generic, the bulk delete was specific...

CPS’ #Office #Project Task Auditor #App wins first place at #SPC14 App #Awards #SharePoint

The Task Auditor app from CPS won first place for the “Most Business Value Project” App at the SharePoint Conference 2014 in Las Vegas: This is a free Project task pane app, go try it out and see what you think See the links below for details: App store: http://office.microsoft.com/en-gb/store/task-auditor-WA104172076.aspx Product site: http://www.projectserverplus.com/apps.html  Blog post:...