#ProjectServer #PS2010 / #PS2013 bulk #Project site creation using #PowerShell 3.0 or later #SP2013 #SP2010
|
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:
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:
From PowerShell:
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:
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
|
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:
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://bit.ly/1n6Ciwu
Product site: http://bit.ly/1dlln6v
Blog post: http://bit.ly/1dlln6y
Say hello to #Project and #ProjectServer 2013 Service Pack 1 #sp2013 #ps2013 #office2013
For Project Server 2013, you can download from below:
For Project 2013 client, 32bit or 64bit, you can download from below:
- 32 bit – http://bit.ly/1dOZBoq
- 64 bit – http://bit.ly/OPdBJq
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.
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.
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
|
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) |
How to validate string.format within Visual Studio
In writing code we use string.format a lot to create strings for error reporting or sending to the screen. Some of these will only ever get created if an error occurs so they become difficult to test to make sure the don’t throw an error. Take the following example
The following code would fail at runtime but is fine in the compiler
string.Format("{0} This is valid but will error {1}", this.siteURL);
So how do we catch these. Well we all use the code analysis tools built into visual studio. Don’t we?
Well this has a nice test case that will catch and highlight this problem.
Run code analysis on your project Alt+F11 or select “Run Code Analysis on …” from the Analyse menu.
Then once this has finished you can search for issue CA2241. This will show any and all string.formats that would fail at run time.
It would be nice if the compiler caught these but this is still a good approach.
via Buzz Blog http://bit.ly/1hYG3FD
|
Paul is a an expert SharePoint and Project Server developer and is responsible for designing and implementing custom solutions on client systems using the latest SharePoint and .NET technologies.
Paul has extensive experience with SharePoint systems across all sizes of implementation, ranging from small to large farms and has an excellent understanding of all the elements of SharePoint. This article has been cross posted from paulbuzzblog.wordpress.com (original article) |
#ProjectServer #PS2013 #SharePoint #SP2013 #Office 2013 Service Pack 1 is released #SP1
|
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) |
Service Pack 1 has been released today for Office 2013, the links can be seen below:
SharePoint 2013 SP1:
http://bit.ly/1c5sXUw
Project Server 2013 SP1:
http://bit.ly/1o3Vc5N
Project 2013 SP1:
http://bit.ly/1c5sVvV
SharePoint 2013 and other server related SP1:
http://bit.ly/1c5sVvX
A list of the fixes for Office 2013 SP1:
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
|
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 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:
Firstly navigate to the Project Web App homepage:
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:
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:
Here you will see all the Project Center views that you have access to. Click a different view and the page will refresh:
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:
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:
Select the task or tasks and click OK:
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:
The colour formatting of the bars and fonts can be changed, the data / information displayed and how the information is displayed (callouts etc.):
Clicking the project name will load the project detail pages for that project:
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:
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
The project then checks out to you and the ribbon buttons are active:
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:
Clicking either the Tasks tile or the Tasks quick launch link takes you to the Tasks page below:
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:
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:
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:
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:
You will then see the two end buttons on the ribbon become active. Click the Resource Assignments button to see the assignments:
From this page I can also click the Resource Availability button to see the resource availability:
Different view options can be set to see data. Below the graph is a table displaying the details:
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:
Then scroll down to subsites:
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”:
Another method is from the project details view, click the project site link under the PDPs:
Once on the project site you will see the following:
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:
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:
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:
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:
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:
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.
Opening emails in SharePoint
As part of a recent project we used SharePoint to store emails, both via incoming emails and one of the 3rd party drag and drop tools.
Most users were happy with the solution once we had updated the MIME types to allow emails to be opened rather then downloaded, but some still mentioned they would rather that email opened directly from SharePoint rather than seeing the yellow download bar that Internet Explorer puts up.
A bit of digging around on the internet came up with the solution from this Microsoft KB article
http://support.microsoft.com/kb/2678934
To enable emails to be opened directly from SharePoint the trick is to disable the Internet Explorer download bar for email file types, to do this add the following registry key to your local machine.
HKEY_CURRENT_USER\Software\Microsoft\Windows\Shell\AttachmentExecute\{0002DF01-0000-0000-C000-000000000046}
then run the assoc command below to get your .msg file extension type (mine is for Office 2013)
Now add that file type as a zero length binary value to the key created above.
Emails will open directly from SharePoint.
#ProjectServer 2013 Build OLAP Cube via #PowerShell #SP2013 #PPM #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) |
One potential issue for many organisations with Project Server 2013 is that users need access to Central Admin if they want to build the OLAP Cube. Usually the PMO / PWA Admins would not have access to Central Admin, they only have access to Project Web App. If they want to build the OLAP Cube on demand, they would need to raise a request to the team that manages SharePoint Central Admin. To get around this, they can use PowerShell! The script can be downloaded from the script gallery below:
Once the script is downloaded, the uri will need to be updated to use the correct URL, update the http://vm753/pwa part of the URL. You will also need to update the cube GUID. You can get the cube GUID from the URL in Central Admin when you access the OLAP cube settings page. See the highlighted URL below:
Obviously someone with access to Central Admin will need to get the OLAP Cube GUID for you.
The users running the script will need to correct permissions in Project Server. They will need Manage Cube Build service and Mange Site Services.
Infopath Namespace manager creation code
I have had to create some code this week that reads the xml created by InfoPath. I then found that if you try and xpath on something you get a null return until the namespace manager has all of the correct entries. In the past I have created these manually but after a bit of google fo I have come up with the below piece of code. It takes an XMLDocument that you have created based on the form file (or any XML document really) and returns you a newly created namespace manager that can be used along side you xpath queries to get the data you want.
public static XmlNamespaceManager GetNameSpaceManager(XmlDocument xmlDoc) { XmlNamespaceManager ns = new XmlNamespaceManager(xmlDoc.NameTable); foreach (XmlAttribute att in xmlDoc.DocumentElement.Attributes) { if (att.Prefix == "xmlns") { ns.AddNamespace(att.LocalName, att.Value); } } return ns; }
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, “Courier New”, courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }
via Buzz Blog http://bit.ly/MuMAtl
|
Paul is a an expert SharePoint and Project Server developer and is responsible for designing and implementing custom solutions on client systems using the latest SharePoint and .NET technologies.
Paul has extensive experience with SharePoint systems across all sizes of implementation, ranging from small to large farms and has an excellent understanding of all the elements of SharePoint. This article has been cross posted from paulbuzzblog.wordpress.com (original article) |
#ProjectServer and #SharePoint 2010 February 2014 Cumulative Update #PS2010 #SP2010 #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) |
There are no cumulative updates for any of the Office 2013 products this month as SP1 is due this quarter.
The Office 2010 February 2014 Cumulative Updates are now available, please see the links below:
Project Server 2010 Server Roll up package February 2014 CU (Recommended):
http://bit.ly/1g2ynwn
Project Server 2010 February 2014 CU (Included in the Server Roll up package):
http://bit.ly/1b05m75 & http://bit.ly/1g2ynwq
Project 2010 February 2014 CU:
http://bit.ly/1b05m78
Remember SP1 or SP2 is a pre-requisite for the Office 2010 February 2014 CUs.
As always, test these updates on a replica test environment before deploying to production.
For more details see:
SharePoint (and Project Server) Shenanigans 
You must be logged in to post a comment.