#Project #MVP Award #ProjectServer #SharePoint #PS2013 #SP2013 #ProjectOnline #MVPBuzz

Paul Mather
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)

Some good news, I’m very pleased to announce that my Project MVP award was renewed for the second time after first being awarded in April 2013. I am really grateful for the recognition, especially as I enjoy helping out the Project and Project Server community so much. It is kind of a hobby of mine I guess, or maybe just an obsession!

Categories: Paul Mather, Work Tags:

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

March 31, 2014 Leave a comment
Paul Mather
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’ 3rd app is now available in the Microsoft App Store. The app is called “Work Viewer” and can be downloaded here:

http://bit.ly/1jP3G4j

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.

image

The app will quickly alert the user to over allocations and availability using the customisable colour formatting options which are fully configurable per user and are persistent.

image

By default, resource plan work and proposed bookings are excluded from the data. However, these assignments can be added back in by simply checking the relevant box to aid accurate resource management decisions. Assignment information is available in the tooltips detailing the availability, remaining availability, project name, task names, the assignment type and the booking type.

image

At the click of a button the user can also see the resource’s line manager (timesheet manager) and the project owner. The app features a host of additional innovative features including Lync integration. The user can quickly see the Lync presence and easily communicate to either the resource, the line manager or the project owner using the Lync integration feature.

image

image

Download today and take a look using the free trial.

To see the CPS app store click the link below:

http://bit.ly/1jP3EJC

Look out for more new apps coming soon.

Categories: Paul Mather, Work Tags:

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

March 26, 2014 Leave a comment
Paul Mather
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 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 / SharePoint 2013 box (only server I had available at the time). Once you have access to SQL Server data tools, download and install the ODATA SSIS component from the link below:

http://bit.ly/NSC8fs

Also if this isn’t on a SharePoint / Project Server 2013 server – which in reality it wont be, you will also probably need the SharePoint client DLLs, these can be downloaded here:

http://bit.ly/1dqRowf

When I tried the new SSIS component on the SQL 2012 Server the connection failed and it complained about the SharePoint.Client.Runtime.dll:

image

I didn’t test deploying the SharePoint client components to the SQL Server but I guess this should work.

Once everything is in place, launch SQL Server data tools for SQL Server 2012 and create a new Integration Services project:

image

Click OK and you will see the following screen:

image

On the control flow tab, at the bottom you will see Connection managers. Right click and create a new OLEDB Connection to the target database:

image

Before I created this, I did create a new empty SQL database:

image

Create another connection to the ODATA feed URL using the New Connection > ODATA option:

image 

Create the ODATA connection to your ODATA tenant:

image

Specify an account that has access to the ODATA feed. Notice the Service document location is just the base ProjectData ODATA URL.

Click the All button and change the Microsoft Online Services Authentication to True:

image

Test the connection to confirm it is successful then click ok.

Add a Data Flow Task to the control flow:

image

Double click the data flow task and you will go to the Data flow tab:

image

Drag ODATA source from the toolbox to the data flow sheet:

image

Double click the ODATA source to see the properties:

image

Complete the details, selecting the ProjectOnlineODATAFeed connection and you will see the Collection property load the collection, in this case it is the tables on the ODATA feed:

image

Once loaded you will see the familiar ODATA entities:

image

In this example we will only use the Projects feed:

image

Click the Columns page on the left hand side and select the columns you want:

image

Click OK.

Drag the Destination Assistant from the SSIS toolbox to the Data Flow sheet and the new destination window will open:

image

Select the previously created SQL Server OLE DB connection:

image

Click OK.

image

Double click the OLEDB Destination component to load the editor:

image

Click the New button next to to the table details to create a new table, give the table a name, replace “OLE DB Destination” with the table name you want:

image

Click OK. At this point if we look at the SQL database we will see the new table and columns:

image

Back in the SSIS package click the Mappings page, here you can see the field mappings from the ODATA feed to the SQL table:

image

Click OK and you will see the following flow:

image

Run the package using the green arrow:

image

Once run successfully you will see the following:

image

If we switch back to the SQL server and see what is stored in the table you will see the project data from your Project online tenant:

image

Now the data is local you can use SQL Server Reporting Services to create reports, you can integrate this data into other LOB systems or create a custom OLAP cube etc. Once you are happy with the package you can set the package to run on a schedule to periodically copy the data down. There are plenty of references on the web for creating SSIS packages so have a search.

This is a basic example but hopefully gives you the idea of what is now possible Smile

Categories: Paul Mather, Work Tags:

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

March 26, 2014 Leave a comment
Paul Mather
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)

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://bit.ly/NSC8fs

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, integrate into other LOB systems etc. Look out for more details soon.

Categories: Paul Mather, Work Tags:

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

Paul Mather
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)

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 to the client so I haven’t published that. The script can be downloaded from the script galley below:

http://bit.ly/1fZVPN8

The web service proxy URLs will need to be updated for your PWA instance, replace the http://vm753/pwa with the correct URL.

The script can be seen running and creating sites below:

From the PowerShell ISE:

image

From PowerShell:

image

Project Sites are created using the correct site template that is associated to the EPT.

If all projects have a site associated, the following is returned:

image

Test this on a test / dev farm before running a live production farm.

Categories: Paul Mather, Work Tags:

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

Paul Mather
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 Task Auditor app from CPS won first place for the “Most Business Value Project” App at the SharePoint Conference 2014 in Las Vegas:

clip_image001

This is a free Project task pane app, go try it out and see what you think Smile

See the links below for details:

App store: http://bit.ly/1n6Ciwu

Product site: http://bit.ly/1dlln6v 

Blog post: http://bit.ly/1dlln6y

Categories: Paul Mather, Work Tags:

Say hello to #Project and #ProjectServer 2013 Service Pack 1 #sp2013 #ps2013 #office2013

A quick note to spread the news that Service Pack 1 for SharePoint/Project Server 2013 and other 2013 office products is out now.

For Project Server 2013, you can download from below:

For Project 2013 client, 32bit or 64bit, you can download from below:

For SharePoint 2013 server, you can download from below:

Few important things to note here, that unlike previous versions, this time SP1 is not a roll-up version. Which means that Project Server SP1 doesn’t include SharePoint side of update, and vice verse.

http://bit.ly/OPdzBr

Also another important point, is that as part of lost resource fix if you have updated the required sproc, then you may need to update them again as SP1 will re-write those sprocs during installation/setup.

http://bit.ly/1dOZDgd

Also read the Project Client versioning details in Brians’s post (same link as above).

And in the end as always, try all the updates in test environment prior to apply to production.

Happy patching.

via All about Enterprise Project Management (EPM) http://bit.ly/OPdzBs

Khurram Jamshed
The author of the blog has an extensive experience of working as an EPM Consultant. Currently he is located in Dubai, UAE and working for Microsoft partner organization as Project Server specialist. He has a thorough experience of providing Project Management technical/functional consultancy to all sort of organizations. He is a certified PMP, a Project Server MCITP, and also received a MS community contributor award 2011.

This article has been cross posted from khurramjamshed.blogspot.com/ (original article)

Follow

Get every new post delivered to your Inbox.

Join 571 other followers

%d bloggers like this: