#ProjectServer / #ProjectOnline Publish All projects #JavaScript #jQuery #SharePointOnline #Office365 #PS2013

April 17, 2014 at 6:51 pm | Posted in Add-on, Administration, Configuration, Customisation, Functionality, Information | Leave a comment
Tags: , , , , , , ,

This post covers a new script I have written that publishes all projects the user has access to. I do have a PowerShell script that does this perfectly but only works for Project Server on-premise. This is detailed here:

http://pwmather.wordpress.com/2012/05/31/updated-publish-all-projects-in-projectserver-using-powershell-msproject-ps2010-sp2010/

http://gallery.technet.microsoft.com/scriptcenter/Server-2010-Publish-all-45ba385b

The new script is JavaScript so will work for Project Server 2013 and Project Online. The publish all JavaScript file can be downloaded here:

http://gallery.technet.microsoft.com/scriptcenter/Server-2013-Online-Publish-15215a56

To get the script to work you will need to download the following jQuery library:

jquery-1.8.3.min.js – jQuery download

A later 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 assets library as you can see in the code below:

image

Also note the references to the default SharePoint / ProjectServer JavaScript libraries.

Once the script is uploaded, save this to the PWA site collection. I uploaded the JavaScript file to the style library:

image

Now create a new page, I called mine PublishAll and saved this in the Site Collection Documents Library library. The name of the page and the location of the page can be changed, just make sure the users have access to it. Then add a content editor web part on the page and reference the publishallprojects.js file. After clicking save you should see the following load:

image

Clicking the Publish Projects button will fire of a publish job for all the projects you have access to. You will see the following pop disappear once all the projects have been sent to the queue for publishing:

image

There are several publish all type apps available in the app store but this method does not require you to install and configure the app store or download and install an app.

Want to see Risks and Issues on a #ProjectOnline / #ProjectServer project detail page? #PS2013 #SharePointOnline #SP2013 #Office365 #JavaScript #jQuery

April 11, 2014 at 2:03 pm | Posted in Add-on, Administration, Configuration, Customisation, Functionality, Information, Reporting | Leave a comment
Tags: , , , , , , ,

Over the last few weeks when I have had a spare 5 minutes I have been playing with JavaScript /jQuery. It is something I have wanted to learn for a while and finally thought I would give it ago and see what I could do with SharePoint / Project data. After lots of reading and researching (lots of examples out there!) I came across some very useful jQuery libraries. This post covers the usage of a script I put together to display risks and issues on a project detail page from the associated project site. The full script can be downloaded from the Microsoft script gallery below:

http://gallery.technet.microsoft.com/scriptcenter/Server-Risks-and-Issues-on-65dcbe0e

The script only uses default Project Server Issues and Risks columns so it will work as is but it can easily be updated to include other columns.

To get the script to work you will need to download the following jQuery libraries:

jquery-1.8.3.min.js – jQuery download

knockout-3.1.0.js – knockout jQuery download

ko.sp-1.0.min.Ex.js – knockout JS binder library – Extended Version (Includes Moment Js and numeral Js)

Later versions of these libraries may work but these were the ones I used / tested with.

Upload these to your PWA site collection then update the script file with the correct location. I uploaded these files to the site assets library as you can see in the code below:

image

Also note the references to the default SharePoint / ProjectServer JavaScript libraries.

Once the script is uploaded, save this to the PWA site collection. I uploaded the JavaScript file to the style library:

image

Now create a new PDP page, I called mine Risks and Issues. Then add a content editor web part on the page and reference the riskandissueonPDP.js file. After clicking save you should see the following message above the grids:

image

This is because the current page is not an actual projects project details page. Add the new PDP to the correct EPT/s. Now navigate to the Project Center and click on a project that contains risks and / or issues on the associated project site. Click the new Risks and Issues PDP and you will see the the risks and issues displayed:

image

The script is just an example I put together and should really be improved for a production environment  – error handling, update the displayed columns, visualise processing etc. Watch this space for more JavaScript examples as I dabble further! Smile

#ProjectServer and #SharePoint 2010 / 2013 April 2014 Cumulative Update #PS2010 #SP2010 #PS2013 #SP2013 #MSProject

April 9, 2014 at 9:35 pm | Posted in Administration, CU, Fixes, Functionality, Information, Installation | Leave a comment
Tags: , , , , , , ,

The Office 2013 April 2014 Cumulative Updates are now available, please see the links below:

http://support.microsoft.com/kb/2953733

***There is no Project Server 2013 Server Roll up package for April 2014 CU***
Project Server 2013 April 2014 CU:
http://support.microsoft.com/kb/2863881
Project 2013 April 2014 CU:
http://support.microsoft.com/kb/2878276

Also worth noting, if you haven’t done so already, install the March 2013 Public update: http://support.microsoft.com/kb/2768001 if installing the April 2014 CU.

The Office 2010 April 2014 Cumulative Updates are now available, please see the links below:

http://support.microsoft.com/kb/2953732

***There is no Project Server 2010 Server Roll up package for April 2014 CU***
Project Server 2010 April 2014 CU:    
http://support.microsoft.com/kb/2878259 & http://support.microsoft.com/kb/2878266
Project 2010 April 2014 CU:
http://support.microsoft.com/kb/2878263
Remember SP1 or SP2 is a pre-requisite for the Office 2010 April 2014 CUs.

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

For more details see:

http://blogs.technet.com/b/projectsupport/archive/2014/04/09/microsoft-project-server-2010-and-2013-april-2014-cu-announcement.aspx

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

March 31, 2014 at 11:24 am | Posted in Add-on, Administration, App, Customisation, Functionality, Information, Reporting | Leave a comment
Tags: , , , , ,

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.

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://office.microsoft.com/en-us/store/dashboard.aspx?AssetId=PN104172071

Look out for more new apps coming soon.

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

March 26, 2014 at 1:24 pm | Posted in Add-on, Administration, Configuration, Customisation, Functionality, Information, Installation, Reporting, T-SQL | 6 Comments
Tags: , , , , , , , ,

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://www.microsoft.com/en-us/download/details.aspx?id=42280

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

http://www.microsoft.com/en-in/download/details.aspx?id=35585

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

Link the ODATA Source to the OLE DB Destination component using the blue data flow, then double click the OLEDB Destination component to load the editor – click yes to the warning / pop up:

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

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

March 26, 2014 at 9:16 am | Posted in Add-on, Administration, Configuration, Customisation, Functionality, Information, Reporting, T-SQL | 1 Comment
Tags: , , , , , ,

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

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

March 5, 2014 at 11:18 am | Posted in Add-on, Administration, Configuration, Customisation, Functionality, PowerShell, PSI | 2 Comments
Tags: , , , , , , , , ,

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://gallery.technet.microsoft.com/scriptcenter/Bulk-create-Server-Sites-784f7b29

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.

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

March 4, 2014 at 1:15 pm | Posted in Add-on, Administration, App, Functionality, Information | Leave a comment
Tags: , , , , ,

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://office.microsoft.com/en-gb/store/task-auditor-WA104172076.aspx

Product site: http://www.projectserverplus.com/apps.html 

Blog post: http://pwmather.wordpress.com/2013/12/12/free-project-2013-app-from-cps-office365-office-apps-projectserver-projectonline/

#ProjectServer #PS2013 #SharePoint #SP2013 #Office 2013 Service Pack 1 is released #SP1

February 25, 2014 at 8:05 pm | Posted in Administration, Configuration, Fixes, Functionality, Information, Installation, Service Pack | Leave a comment
Tags: , , , , , ,

Service Pack 1 has been released today for Office 2013, the links can be seen below:

SharePoint 2013 SP1:
http://support.microsoft.com/kb/2817429

Project Server 2013 SP1:
http://support.microsoft.com/kb/2817434

Project 2013 SP1:
http://support.microsoft.com/kb/2817433

SharePoint 2013 and other server related SP1:
http://support.microsoft.com/kb/2850035

Office 2013 and related desktop products SP1:
http://support.microsoft.com/kb/2850036

A list of the fixes for Office 2013 SP1:

http://download.microsoft.com/download/0/A/8/0A870358-D451-488E-BF54-9616292E19EC/Microsoft%20Office%20and%20SharePoint%202013%20Service%20Pack%201%20Changes.xlsx

As with all patches, deploy to a non production farm and fully test before deploying to a production system.

Getting started with #ProjectOnline Part 8 #PS2013 #Office365 #Project #PPM #SharePointOnline #PM #SP2013

February 24, 2014 at 7:11 pm | Posted in Administration, Configuration, Functionality, Information | Leave a comment
Tags: , , , ,

This is part 8 of the “Getting started with Project Online” series. I was hoping to get this post published before now, sorry for the delay. In this post we will look at the various places in the Project Web App that data can viewed and edited. In the last post we looked at populating the enterprise resource pool and various ways to create projects. If you missed the last post, see the link below:

http://pwmather.wordpress.com/2014/02/03/getting-started-with-projectonline-part-7-ps2013-office365-project-ppm-sharepointonline-pm-sp2013/

Firstly navigate to the Project Web App homepage:

image

As you can see there are various ways to get to certain areas in the Project Web App. You can use the quick launch or the tiles. We will look at the Project Center, the Tasks page, the Resource Center and the project site. The first area we will look at is the Project Center, this can be accessed either from the Projects link on the Quick Launch menu (left hand side of the page) or by clicking the Projects tile on the “Track your work” web part. This page will look something the image below:

image

Different views can be configured for this page, we covered this in part 4, we created a new Project Center view called “Project Status by Programme”. To switch to this view or another view click the PROJECTS tab at the top of the page then click the drop down menu next to view:

image

Here you will see all the Project Center views that you have access to. Click a different view and the page will refresh:

image

The data is now grouped by our Programme field. The view filtering and grouping can be changed on the fly using the filter and group by options on the ribbon. You will see there is also a timeline that currently contains no projects. Projects and tasks can be added to the timeline using the two buttons on the ribbon, Add Project and Add Tasks. To add a project, select the project row and click the Add Project button:

image

To add a task, select the project and click the Add Tasks button. A new window will appear that will allow you to select the tasks:

image

Select the task or tasks and click OK:

image

We now have the project and two of the project tasks on the timeline. The timeline can be formatted. Selecting the timeline will show a TIMELINE ribbon tab:

image

The colour formatting of the bars and fonts can be changed, the data / information displayed and how the information is displayed (callouts etc.):

image

Clicking the project name will load the project detail pages for that project:

image

On the left hand side menu you will see the different PDP’s associated with this enterprise project type (EPT’s). We covered PDP’s and EPT’s in part 5. Clicking one of the PDP’s will load different information and display different information that can be edited. Below shows the Project Status Information PDP:

image

The project plan can be edited on the schedule PDP, click the Task tab then Edit > In Browser to edit in the Project Web App

image

The project then checks out to you and the ribbon buttons are active:

image

Once the changes are complete you have the save and publish options.

We will now take a look at the Tasks page, this is where team members see their assignments. Starting on the Project Web App homepage, there are two links to the Tasks page, either the Tasks link on the quick launch or the Tasks tile. The tasks tile will also give a count of new tasks, notice “Tasks: 1 New” below on the 3rd tile on the “Track your work” web part:

image

Clicking either the Tasks tile or the Tasks quick launch link takes you to the Tasks page below:

image

Here team members can either just view the assignments using the different views, update progress or even delete assignments. Any changes such as updating progress or deleting has to be approved by the task status manager, they will get notified of the change. Clicking the task name loads the task details page:

image

Next we look at the Resource center page, from the Project Web App homepage click the Resources link on the quick launch menu. The following page will then load:

image

Here you can create new resources or edit existing resource providing you have the correct permissions. Different views are available here, we will switch to the “Full Time Resources” view that we created in part 4:

image

image

From the Resource center we can quickly see resource availability and assignment details. Check the resource/s that you want to review, in this case I will look at myself:

image

You will then see the two end buttons on the ribbon become active. Click the Resource Assignments button to see the assignments:

image

From this page I can also click the Resource Availability button to see the resource availability:

image

Different view options can be set to see data. Below the graph is a table displaying the details:

image

The next area we will look at is the project site. There are several ways which the project site can be access. Either from the Project Web App site site cog > Site contents option:

image

Then scroll down to subsites:

image

The second method is from the project center, click the ellipsis next to the project then click the ellipsis on the pop up then click “Go to Project Site”:

image

Another method is from the project details view, click the project site link under the PDPs:

image

Once on the project site you will see the following:

image

You will see different lists etc. based on the template you created \ chose, this example site is based on the site template created in part 6. Here you can update the lists and documents related to the project. Below a new Issue has been created, set to active and assigned to myself:

image

The Issues and Risks list tie in closely to the project in the Project Web App. If I look at the Project Web App homepage I will see 1 Active Issue now:

image

Notice the 4th tile on the “Track your work” web part. I edited the “Track your work” web part to display Issues and Risks. Clicking the Issues or Risks tile loads the follow page:

image

You can click the project name to load either the issues or risks lists on that project site.

Also the project center will display an icon next to the project to indicate an issue:

image

You can click the icon to load the issues list for that project site. The same functionality exists for risks and documents. Issues, risks and documents can also be linked to tasks or other list items, I have covered that previously here.

Next up, we look at creating reports to surface data in Excel / Excel Web App. I have previously covered creating Project Online reports, the links are below:

http://pwmather.wordpress.com/2013/08/01/projectserver-projectonline-highlight-report-example-ps2013-sp2013-excel-bi-office/

http://pwmather.wordpress.com/2013/09/16/projectserver-projectonline-example-report-ps2013-sp2013-office365-bi-excel-powerpivot/

The next post will look at creating the ODATA feed URLs then using the same process described in the links above we will create reports.

Next Page »

Blog at WordPress.com. | The Pool Theme.
Entries and comments feeds.

Follow

Get every new post delivered to your Inbox.

Join 582 other followers