#ProjectServer #PS2010 / #PS2013 delete #Project site using #PowerShell #SP2013 #SP2010

June 26, 2015 at 9:13 am | Posted in Add-on, Administration, Configuration, Customisation, Functionality, Information, PowerShell | Leave a comment
Tags: , , , , , , ,

Following on from a post / script I created a year or so ago to bulk create project sites, there have been requests to be able to bulk delete projects sites. I have been reluctant to do that as i am always cautious when “bulk” deleting! The script i have created reads the list of projects from a text file so that the user running the script knows exactly what project sites they are going to be delete. The script can be downloaded from the Microsoft Script gallery below:

https://gallery.technet.microsoft.com/projectserver/Delete-Server-Sites-9c3d3e95

The text file will need to be created with a list of projects names from your PWA instance – ONLY INCLUDE project names for the project sites you want to delete – all site data (lists, documents etc.) will be deleted as the site will be deleted! The only scenario I would really use a script like this is if I wanted to delete all of my project sites, if I only needed to remove a handful I would do it manually via the UI. The example text file can be seen below:

image

Update the location of the text file and text file name for the Get-Content command.

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

image

The script can be seen running and deleting sites below:

From the PowerShell ISE:

image

All data from the project sites will be lost so please use this with care and only enter project names in the text file for projects sites and project site data you no longer need.

Run the script with a PWA administrator account.

Fully test this script on a test / non-production PWA instance before running on any production environment. As a precaution, take full database backups (PWA and SharePoint Content) before running the script on the production environment so that you can roll back if needed.

The script is provided "As is" with no warranties etc.

#ProjectOnline / #ProjectServer 2013 update Owner label on PDP #JavaScript #jQuery

June 12, 2015 at 3:41 pm | Posted in Add-on, Administration, Configuration, Customisation, Functionality, Information | Leave a comment
Tags: , , , , ,

A quick post to support a very simple script to change the Owner display label on a Project Detail Page page. Quite often clients request to change the Owner to something else such as Project Manager. The script can be downloaded from the script gallery below:

http://gallery.technet.microsoft.com/Online-Server-update-Owner-7ef2671a

This code will replace “Owner” with “Project Manager” but can easily be updated.

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

image

Alternatively you can reference a CDN if preferred.

Once the script is downloaded, upload this to the PWA site collection, in this example it was uploaded to the shared documents library. Select the PDP that has the Owner field displayed, then reference the uploaded script using the content editor web part:

image

In this example it is the Project Information PDP.

Once loaded, Owner will display as Project Manager:

image

This is a very simple script but do test this before rolling out to production etc.

The script is provided “As is” with no warranties etc.

#ProjectServer and #SharePoint 2010 / 2013 June 2015 Cumulative Update #PS2010 #SP2010 #PS2013 #SP2013 #MSProject

June 9, 2015 at 7:55 pm | Posted in Administration, Configuration, CU, Fixes, Functionality, Information, Installation | Leave a comment
Tags: , , , , , , ,

The Office 2013 June 2015 Cumulative Updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/3068507

Project Server 2013 June 2015 Server Roll up package:
https://support.microsoft.com/en-us/kb/3054865

Project Server 2013 June 2015 CU:
https://support.microsoft.com/en-us/kb/3054869

Project 2013 June 2015 CU:
https://support.microsoft.com/en-us/kb/3054830

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

The Office 2010 June 2015 Cumulative Updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/3068507

Project Server 2010 June 2015 Server Roll up package:
https://support.microsoft.com/en-us/kb/3054877

Project Server 2010 June 2015 CU:
https://support.microsoft.com/en-us/kb/3054887

Project 2010 June 2015 CU:
https://support.microsoft.com/en-us/kb/3017816

SP2 is a pre-requisite for the Office 2010 June 2015 CUs.

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

Announcing #Project Virtual Conference for #Microsoft #MSProject, #ProjectOnline and #ProjectServer #PPM #ProjectVconf

June 8, 2015 at 12:47 pm | Posted in Administration, Functionality, Information | 2 Comments
Tags: , , , , , ,

Announced today is the “Project Virtual Conference”, which is a free online conference on 22nd October 2015 that will run for 24 hours – get the date in your calendars :)

The conference is focused on Microsoft Project, Project Online and Project Server and is being organised by a volunteers with a lot of support from a few Project MVPs.

To stay updated follow the Project Virtual Conference site here: http://projectvirtualconference.com 

Follow the Twitter @ProjectVConf handle and use the #ProjectVconf hashtag for all Twitter activity.

CPS’ PS+ solution is an Award Finalist at the #Microsoft Partner Awards #WPC15 for #PPM #ProjectOnline / #ProjectServer

June 6, 2015 at 9:06 pm | Posted in Add-on, Administration, Configuration, Customisation, Functionality, Information, Installation | Leave a comment
Tags: , , , ,

I am pleased to announce that CPS’ PS+ solution was an Award Finalist in the recent Microsoft Partner of the Year Awards 2015 in the Project and Portfolio Management Competency. This is the second year running that the PS+ solution has been an award finalist.

PS+ logo

For a full list of winners and finalists see:

https://mspartner.microsoft.com/en/us/Pages/WPC/awards.aspx

http://news.microsoft.com/2015/06/02/microsoft-announces-2015-partner-of-the-year-winners-and-finalists/

Great work to all the partners that received awards.

#ProjectServer and #SharePoint 2010 / 2013 May 2015 Cumulative Update #PS2010 #SP2010 #PS2013 #SP2013 #MSProject

May 14, 2015 at 8:14 am | Posted in Administration, Configuration, CU, Fixes, Functionality, Information, Installation | Leave a comment
Tags: , , , , , , ,

The Office 2013 May 2015 Cumulative Updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/3061974

Project Server 2013 May 2015 Server Roll up package:
https://support.microsoft.com/en-us/kb/3039753

Project Server 2013 May 2015 CU:
https://support.microsoft.com/en-us/kb/3054804

Project 2013 May 2015 CU:
https://support.microsoft.com/en-us/kb/2986246

Worth noting is that the SharePoint 2013 and Project Server 2013 updates are in Windows Updates: http://blogs.technet.com/b/projectsupport/archive/2015/05/13/sharepoint-and-project-server-2013-may-2015-updates-are-in-windows-update.aspx

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

The Office 2010 May 2015 Cumulative Updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/3061974

Project Server 2010 May 2015 Server Roll up package:
https://support.microsoft.com/en-us/kb/2999496

Project Server 2010 May 2015 CU:
https://support.microsoft.com/en-us/kb/2965314

Project 2010 May 2015 CU:
https://support.microsoft.com/en-us/kb/2553251

SP2 is a pre-requisite for the Office 2010 May 2015 CUs.

For more details on these patches see: http://blogs.technet.com/b/projectsupport/archive/2015/05/13/project-server-2010-and-2013-may-2015-pu-announcement.aspx

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

#ProjectOnline / #ProjectServer 2013 Access #SharePoint lists on PDPs #JavaScript #jQuery #Office365

May 12, 2015 at 5:04 pm | Posted in Administration, Configuration, Customisation, Functionality, Information | Leave a comment
Tags: , , , , , ,

A common requirement is to see and access the Issues and Risks lists on the Project Detail Pages in the PWA site for the associated project. Previously I wrote a script that displayed the Issue and Risks data in a table but this was read-only. This can be seen here: https://pwmather.wordpress.com/2014/04/11/want-to-see-risks-and-issues-on-a-projectonline-projectserver-project-detail-page-ps2013-sharepointonline-sp2013-office365-javascript-jquery/ 

This new script will display the Issues and Risks (or any other list for that matter – slight code change / update required) on the PDP but will allow you to create / edit the lists items providing you have the permissions of course. Martin did something similar here. The script can be downloaded from the script gallery below:

 http://gallery.technet.microsoft.com/Online-Server-2013-access-627b10ef

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

 image

Alternatively you can reference a CDN if preferred.

Once the script is downloaded, upload this to the PWA site collection, in this example it was uploaded to the shared documents library. Choose what PDP you want the script to be accessed, in this example I created a PDP called SharePoint Data, added a content editor web part on the new page then referenced the uploaded script using the content editor web part:

 image

Once loaded, the page will look like this:

 image

Don’t worry about the message – this is because there is no project UID available here.

Add the new PDP to the require Enterprise Project Types then navigate to the Project Center and access one of those projects from that EPT. Click the new PDP and you should see:

 image

Click one of the buttons and that list should load:

 image

You can also change the behaviour of the list form and use modal pop ups for a better experience:

 image

This currently includes Risks and Issues but can easily be updated to include other SharePoint lists.

The script is provided "As is" with no warranties etc.

#Microsoft #MSIgnite Day 5 #Office365 #Cloud #SharePoint #ProjectOnline

May 8, 2015 at 5:57 pm | Posted in Administration, Configuration, Functionality, Information | Leave a comment
Tags: , , , ,

The last day of the Microsoft Ignite conference I lined up three sessions, one on why trust Microsoft Enterprise cloud with your data, the next session was on auditing in Office 365 and the final session before we make our way home back to the UK was the Project Online / Project Server support.

The session on Office 365 and why trust Microsoft is a big topic and one with split views, Microsoft are working very hard to make customers data secure and also make the customers know their data is secure. There is lots of information on how Microsoft do this and the compliance standards etc. here: https://products.office.com/en-us/business/office-365-trust-center-cloud-computing-security. I believe the data is probably more secure in the Microsoft cloud than it is in your own network – obviously there would be some exceptions to this for government / highly secure sites etc. Also a key take away from that session was that it isn’t the cloud that isn’t secure, it is the devices that the end users use each day (connecting to on-prem or cloud). Microsoft do monitor unusual activity from devices and make this information available to the admins.

The second session was on auditing options in Office 365. This covered the compliance center, the audit activity reports, the API available to for activity management and the centralised compliance auditing store. All the work Microsoft are doing around auditing shows how seriously they are taking security and how they are making this data available to admins.

The final session of the day was the Project Online / Project Server support session by Brian Smith. This was a great session and gave good insights on how the Project escalation engineers support project. Brian blogged about this session earlier: http://blogs.msdn.com/b/brismith/archive/2015/05/07/my-ignite-session-brk3146-troubleshooting-tips-and-tricks.aspx

Time for me to head to the airport now to head home back to the UK. It’s been a great week here in Chicago with lots of things to understand and digest. Top marks for Microsoft, a great conference :)

#Microsoft #MSIgnite Day 4 #Office365 #Cloud #SharePoint #ProjectOnline #ITPro

May 8, 2015 at 4:31 pm | Posted in Administration, Configuration, Functionality, Information | Leave a comment
Tags: , , , ,

Day 4 of the Microsoft Ignite conference was spent at the following sessions. The first was on how to strategically evolve your role as an IT pro, then a session on best practices on design and performance for SharePoint Online, the next session was on BI for Project Online and Project Server 2013. The session after that was around the experiences Microsoft IT had in migrating from on-prem to Office 365 and the final session of the day was the Project Online customisation best practices.

I didn’t know what to expect from the first session of the day as it wasn’t really a specific technology session but it was a very good session and one I’m glad I went to. This covered how the role of the IT Pro is changing and the role will continue to evolve. As you can imagine this is a big topic and one with many split views. In summary, in my opinion the role of an IT Pro is evolving to more of a business / IT strategic role – I guess an internal IT consultant to the business.

The second session of the day was best practices for design and performance for SharePoint Online. I felt this was a good session as the concepts for SharePoint are applicable PWA. Firstly the branding was side of things was covered. This summarised every thing from the very basic changes such as the composed looks / theme, the next level up with the designer and CSS and to the higher end with custom master pages and layouts. The very basics have a low impact with upgrades etc. where as the more complex changes can be high impact and the customisation may stop working with updates to SharePoint Online etc. With customising the UI /UX one key factor is to think about the users and devices, make the designs responsive, an example can be found here for making Seattle.master responsive: http://blog.sharepointexperience.com/2015/03/making-seattle-master-responsive/

If you are not familiar with custom master pages, a good place to start is here: http://startermasterpages.codeplex.com/

The next part of this session covered performance considerations. The top 5 reasons for slow loading sites are: site structure and navigation (publishing sites), content roll up (expensive queries), large files (large high res images and videos), lots of different requests on the pages (JavaScript, CSS, images etc.) and lots of different web parts on pages. The session then gave some ideas and examples of pages load times by make changes. Some of the changes included: Navigation optimisation using search etc., Content by search web part for content roll up instead of content by query, Optimise images – correct resolution etc., Load content that is displayed on the visible part of the page rather than the whole page, download remaining images etc. as the user scrolls the page and those images need to be visible. Look to use CDNs for jQuery etc. For guidance see the Performance Tuning guides: http://aka.ms/tune

The third session after lunch on BI for Project Online / Project Server, this was a great session demonstrating the tools available, Excel, Power Pivot, Power Query and Power BI. There were some announcements around performance improvements to OData, things like increasing the row limit for timephased data from 200 rows to 2000 rows which has increased performance – other endpoints have also been optimised and Microsoft will continue to monitor and optimise the service.

The fourth session was around the experiences that Microsoft had when migrating from On-prem to Office 365. This discussed some approaches that they used with some tools and custom PowerShell scripts.

The last session of the day was the Project Online customisation session which followed a similar theme to the SharePoint design and best practices. Consider what is displayed on the pages, only have web parts you need, only have columns in the views that you need etc. It was also mentioned that Microsoft are constantly monitoring performance logs and optimising the service, many improvements are in the service already and more will be coming. The changes will also be in Project Server 2016, one interesting overhead / improvement Microsoft have made is to drop the Project Service Application in SharePoint as this was an overhead that has been re-engineered. Project Server 2016 will still have the windows services (queue, event, calculation) etc. For performance considerations for Project Online see: http://aka.ms/projectonlineperf

Lastly I dropped by the Ignite party to grab a beer and have a chat with some familiar faces. Another great day at the Ignite conference. :)

#Microsoft #MSIgnite Day 3 #Office365 #Cloud #SharePoint #ProjectOnline #Apps / #Add-ins

May 7, 2015 at 3:34 am | Posted in Administration, Functionality, Information | Leave a comment
Tags: , , , ,

Day 3 of Microsoft’s Ignite conference I went to sessions covering what’s next for SharePoint 2016 for an IT Pro, a session on App /Add-in provisioning and deployment, planning for Internet performance and capacity, how to deploy Project: online and server and the final session was on a developer session for Project.

The first session of the day was on what’s was new for SharePoint 2016 for an IT Pro covered all of the new features and changes in SharePoint 2016 that will improve the performance, deployment and availability of SharePoint. As most of you know, my focus is Project / Project Server / Project Online (the site title gives that away :)) so I was keen to hear about what was going to change in the SharePoint world as that will directly impact Project Server too. All of these great new features that the SharePoint product team are introducing in SharePoint 2016, Project Server 2016 also benefits from these.

The key changes mentioned this morning were that SharePoint 2016 requires Windows Server 2012 R2 or Windows Server 10 for the OS and SQL Server 2014 SP1 x64 or SQL Server vNext x64. SharePoint 2016 no longer supports a standalone install using SQL Express, SQL Server will need to be installed on the box. The upgrade path from previous version is the database upgrade approach. If the SharePoint farm is earlier than 2013, the databases will need to be upgraded to SP 2013 before SP 2016.

SharePoint 2016 uses a MinRole approach for User roles / services, Robot services and cache services. The user services are for all user generated requests such as page loads, project, excel and one note etc. The robot service all for all system generated requests such as timer jobs and provisioning. I’m sure you can guess what the cache role is for :). The roles are setup on the install using the configuration wizard, you can choose whether the server is a web front end, application server, search, distributed cache or a specialised role. The specialised role option enables you to determine the server role by starting / stopping the services running on the farm (like 2007, 2010 and 2013). There is a new health analyser for the MinRole feature. This health rule will check that the correct services are running on that server based on the role selected on the install. If the specialised role is selected that particular server will be ignored by the new health check.

Patching of SharePoint 2016 has greatly been improved as mentioned here. There is now zero down time for build to build patches with SharePoint 2016 as this a an online process where as before the process took services offline. The patches are also a lot smaller, with a lot less MSI and MSP files so the patching process is quicker.

The software boundaries have not yet been confirmed but will be increased, the indicated boundaries are content DBs in the Terabytes, 100,000 site collections per content DB, the list threshold will be great than 5000, the max file size has been increased to 10 GB and character limit restrictions removed, index items increased to 500 million items.

Other key changes include, a change to the user profile service to remove the built in FIM service, this is now possible to use an external FIM server. The Project Server database has been merged into the SharePoint content DB but it is still licensed separately. Links are now durable so that if a link to a document is emailed to a colleague then at a later date the document name changes or the document is moved in 2013 the link would be broken but in 2016 the link would still work as the links are based on resource ID based URLs. There are options to view how the systems is used, browsers, sites accessed etc. to give you insight and have a better understanding of trends. There are improvements to the “Follow” functionality so that it works across on-premise and online. Hybrid deployment configuration is now possible via the UI rather than PowerShell.

The second session I went to was around app / add-in provisioning and deployment, nothing new here in the technology just an overview of what can currently be done. Only new (ish) change is the name, apps are now known as add-ins.

The third session I went to was planning for Internet performance and capacity with Office 365. This session covered the things your network admins should be aware of. If migrating from on-prem to Office 365 (or any cloud based solution for that matter), it is key that you have good baseline information for the network bandwidth usage so that you can work out if you need a more bandwidth. For Exchange / Outlook: http://gallery.technet.microsoft.com/Exchange-Client-Network-8af1bf00 for Skype for Business (Lync): http://www.microsoft.com/en-us/download/details.aspx?id=19011 for OneDrive for Business: http://www.microsoft.com/en-us/download/details.aspx?id=44541&751be11f-ede8-5a0c-058c-2ee190a24fa6. Other general recommendations for SharePoint are around caching with proxies, also considering using WAN accelerators and for working with documents using the Office Web App rather than the rich clients. For Outlook it is recommended to use Cache mode and by pass any proxies and also use the latest version of the Outlook client.

The fourth session was on Project Online and Project Server – an intro into deployment for both environments.

The last session of the day for me was the developer session for project. This covered general best practice for developing add-ins for Project and Project Online. A demo of the new Project client JavaScript APIs that now allow you to write back to the project plan from the task pane – a great improvement for the task pane add-ins for Project. You can also get all tasks in one go too which is.

This evening finished with an MVP social event at the House of Blues which was great.

That’s it for today.

Next Page »

Create a free website or blog at WordPress.com. | The Pool Theme.
Entries and comments feeds.

Follow

Get every new post delivered to your Inbox.

Join 812 other followers