Archive

Archive for the ‘Work’ Category

Microsoft Releases SharePoint Framework Developer Preview!

August 18, 2016 Leave a comment

Microsoft just made the SharePoint Framework Developer Preview available via GitHub which was originally announced back in May 2016.  Please see the links below for more details:

Dev Center announcement: http://bit.ly/2bAkSKC
GitHub repository: http://bit.ly/2bq2ENg

The post Microsoft Releases SharePoint Framework Developer Preview! appeared first on blog about technology….

from blog about technology… http://bit.ly/2bAkmMJ

Jin Kang
I am an ECM Solutions Architect with over 7 years of experience envisioning, architecting, and implementing enterprise solutions using various technologies including Azure, Office 365, and SharePoint.

Currently I work at ConocoPhillips, providing problem resolution capabilities for systemic environment faults and outages, assist with automating and improving operational process, and collaborate with Operations and Support teams to evaluate, design, and introduce technologies to solve real business problems. I also provide subject matter expertise support to customers.

This article has been cross posted from jinkang.us (original article)

OneDrive for Business – Configurable Retention Period for Orphaned OneDrives!

August 11, 2016 Leave a comment

Hello again! It’s a well-known fact in On-Premise SharePoint world that ever since SharePoint 2010, My Site Clean Up Timer Job is set up 14 days before the MySite is deleted, and there’s nothing you can do about that other than disable the timer job and/or write your own timer job. Matter of fact, I recall countless SP conferences recommending you disable this timer job and handle retention via custom process where you have more visibility and control. In SharePoint Online world, this was changed to 30 days and if you’re like me and have corporate retention policies that are longer than 30 days, you would have to go thru series of workarounds to extend the retention period by leaving the Office 365 account active one way or another.

Well let me tell you that the days of that for SharePoint Online are gone now! I was surprised to see that the May 2016 release of the SharePoint CSOM (v 16.1.5312.1200) introduced ad new property called OrphanedPersonalSitesRetentionPeriod that allows you to get or set the default retention days to OneDrive for Business sites. Even better, the values can be set between 30 to 3650. That’s measured in DAYS! Which means max value is 10 years!!

I’m glad Microsoft has added this option as it now gives a lot of flexibility for organizations to ensure OneDrive retention meets their corporate retention policies.

Easiest way to change the retention is via SharePoint Online PowerShell commands:
…and you can download the latest SharePoint Online PowerShell from here

#Connect to SharePoint Online Admin (change URL to your SPO tenant Admin URL)
Connect-SPOService -Url http://bit.ly/2bkvM95-Credential (Get-Credential)

#Set Retention period – change the value of ‘3650’ to value you prefer
Set-SPOTenant -OrphanedPersonalSitesRetentionPeriod 3650

#Run the following command to confirm value has been applied
(Get-SPOTenant).OrphanedPersonalSitesRetentionPeriod

Here are some links to where you can find out more about this:

Good luck!

The post OneDrive for Business – Configurable Retention Period for Orphaned OneDrives! appeared first on blog about technology….

from blog about technology… http://bit.ly/2bkvHCr

Jin Kang
I am an ECM Solutions Architect with over 7 years of experience envisioning, architecting, and implementing enterprise solutions using various technologies including Azure, Office 365, and SharePoint.

Currently I work at ConocoPhillips, providing problem resolution capabilities for systemic environment faults and outages, assist with automating and improving operational process, and collaborate with Operations and Support teams to evaluate, design, and introduce technologies to solve real business problems. I also provide subject matter expertise support to customers.

This article has been cross posted from jinkang.us (original article)

Code based Sandbox solutions finally on their way out in #O365 MT

August 10, 2016 Leave a comment

This is just a short post to remind myself later when this occured.

From speaking to colleagues etc. advise from Microsoft went out to customers a couple of weeks ago and recently this article was published.

Link: https://dev.office.com/blogs/removing-code-based-sandbox-solutions-in-sharepoint-online

In particular, this should be noted:

Detailed below are recent actions taken and what to expect next:

  • As part of the removal process, activation of new code-based sandbox solutions, as well as updates of existing solutions are no longer available.
  • In the coming weeks, running code-based sandbox solutions in SharePoint Online multi-tenant environments also will be disabled. Customers with these solutions should watch the Message Center and Service Health Dashboard (SHD) for details, timelines, and exception processes.

And more importantly for No Code Sandbox Solutions

    Note that currently, we do not plan to deprecate or remove support for declarative (no-code) sandboxed solutions. 

Sandbox Solutions have been deprecated (code based ones at least) for a long time now.

Relevant article from 2014:

Sympmarc.com provides guidance on the usage of the PowerShell script from the PnP including installation of the right modules (Azure, O365 etc.) for Windows…

More info is available here:

And lastly, Rencore also have a free tool to help you find those solutions (I haven’t tried this however):

    They state that as of today (10th August), Code based Sandbox Solutions will not be allowed within 21 days…

image

Keep SharePointin’

I’ve discovered Open Live Writer!!! + new bloggers coming…

August 10, 2016 Leave a comment

Hello internet world!

I has been a long time since I have blogged again (life keeps taking over)… I think the last time was either during Ignite last year or perhaps my sessions or RMS / IRM… I can’t remember.

Anyway… things have changed a lot of me… I have a new position working for EY and I am now firmly based in Austin rather than travelling between Austin (TX), Houston (TX) and Barlesville (OK) as I had been doing for the last few years.

So without further ado, here’s an update…

As you will have seen, other bloggers on this site have kept things going on a semi-regular basis… they either write directly or the posts are cross posted from their blog sites…

Well I have a few more bloggers to add to the mix, so stay tuned.  You may or may not be aware but all bloggers on this site are people that I have personally worked with in my past / present positions or met via internet means… so this is not your usual SharePoint blog aggregator!

Lastly, as I am starting to ramp up on the blogging front again… I have noticed that in February this year, someone has open sourced and updated Windows Live Writer and created Open Live Writer.

Finally a decent blogging tool that is going to see continued development Smile

Here’s the link: http://openlivewriter.org/ 

openlivewriter-purpleheader

Now, if someone wants to do the same for Expression 4.0 Screen Recorder and Windows Live Movie Maker… I will be a very happy man… hint hint…

Anyway… stay tuned and till the next time…

Keep SharePointin’

PS. this post was written with Open Live Writer

#ProjectServer and #SharePoint 2013 / 2016 August 2016 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject

August 9, 2016 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)

The Office 2016 August 2016 updates and cumulative updates are now available, please see the links below:

http://bit.ly/2aDN4JS

Project 2016 August 2016 update:
http://bit.ly/2aPUSvh

SharePoint Server 2016 August 2016 update – Project Server 2016 fixes:  
http://bit.ly/2aDNi3y & http://bit.ly/2aPUWLB

The Office 2013 August 2016 updates and cumulative updates are now available, please see the links below:

http://bit.ly/2aDN4JS

Project Server 2013 August 2016 CU Server Roll up package:
http://bit.ly/2aDNdx1

Project Server 2013 August 2016 update:
http://bit.ly/2aPULQv – link not live at time of writing

Project 2013 August 2016 update:
http://bit.ly/2aDMGv3 – link not live at time of writing

Also worth noting, if you haven’t done so already, install Service Pack 1 http://bit.ly/1uorn2C first if installing the August 2016 CU.

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

Categories: Paul Mather, Work Tags:

#ProjectOnline / SharePoint CSOM updated to include Resource Engagements #Office365 #SharePointOnline

August 8, 2016 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)

Just a quick post to highlight the latest SharePoint Online / Project Online CSOM version (16.1.5521.1200) now includes the Resource Engagement classes and properties:

image

http://bit.ly/2bedgMM

Categories: Paul Mather, Work Tags:

#ProjectOnline #PowerBI report with hyperlinks #Office365 #PPM #SharePoint #PowerQuery #BI

August 5, 2016 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)

In this post we will look at creating a very basic Power BI report that includes hyperlinks to various entities in Microsoft’s Office 365 PPM Project Online PWA site. The report created here will be purely to show you how to create links to the Project Site, Project Detail Page, Issues and Risks items.

Firstly I will create my OData URLs I need for my datasets, these can be seen below:

  • Projects: <PWA site URL>/_api/ProjectData/Projects()?$filter=ProjectType ne 7
  • Issues: <PWA site URL>/_api/ProjectData/Issues
  • Risks: <PWA site URL>/_api/ProjectData/Risks

Now launch the Power BI desktop and click Get Data > OData Feed as seen below:

image

Enter the Projects URL and click OK:

image

On the next screen click Edit:

image

In the Query Editor window click Choose Columns:

image

In the Choose Columns window, uncheck all of the columns – quickest way is the uncheck Select All Columns:

image

Now select the following columns: ProjectId, ProjectName, ProjectWorkspaceInternalUrl

Click OK and the query will only contain those columns:

image

Rename ProjectName to “Project Name” and ProjectWorkspaceInternalUrl to “Project Site URL”, this is done by right clicking on the column heading and selecting Rename:

image

I have also changed the query name to Projects:

image

Now click Add Column > Add Custom Column:

image

Enter the name “Project Link” and the formula:

"<PWA site URL>/project%20detail%20pages/schedule.aspx?projuid=" & [ProjectId]

Update the PWA site URL to your Project Online PWA site URL and update the PDP if required, this one uses the Schedule PDP.

image

Click OK. The Projects dataset table is now ready, we now need to add in the Issues data. From within the Query Editor window, click New Source > OData Feed:

image

Enter the Issues URL and click OK:

image

Click OK on the preview window then you will see the 2nd query added:

image

Now we need to Choose Columns, remove them all and select the following: ProjectId, IssueId, ItemRelativeUrlPath, Title

Click OK. Rename the query to Issues then that dataset table is complete:

image

We now need to add in the Risks data. From within the Query Editor window, click New Source > OData Feed:

image

Enter the Risks URL and click OK, click OK on the preview window then you will see the 3rd query added:

image

Now we need to Choose Columns, remove them all and select the following: ProjectId, RiskId, ItemRelativeUrlPath, Title

Click OK. Rename the query to Risks then that dataset table is complete:

image

Now we need to merge the Issues table with the Projects table so that we can get the Project Site URL in the the Issues table. Select the Issues dataset table then click the Merge Queries option:

image

In the Merge window select the Projects table and ProjectId from both as seen below:

image

Click OK and you will see a new column appear:

image

Click the button on the new column to choose the columns to expand from the joined table:

image

Select just the Project Site URL:

image

Click OK and you will see the Project Site URL appear:

image

Rename the column to remove the NewColumn. prefix. Now click Add Column > Add Custom Column:

image

Enter a name “Issue Link” then enter the formula for the new column:

[Project Site URL] & "/" & Text.Range([ItemRelativeUrlPath],0,13) & "DispForm.aspx?ID=" & Text.Range([ItemRelativeUrlPath],13,1)

image

Click OK. Click on a row and ensure the URL is correct – copy in the browser to test:

image

Now select the Risks dataset table to repeat the steps. Click Merge Queries with the same steps as before and click OK. In the new column expand the Project Site URL then rename the column to remove the NewColumn. prefix. Add the custom column called “Risk Link” with the following formula:

[Project Site URL] & "/" & Text.Range([ItemRelativeUrlPath],0,12) & "DispForm.aspx?ID=" & Text.Range([ItemRelativeUrlPath],12,1)

image

Click OK then click on a row and ensure the URL is correct – copy in the browser to test:

image

Then click Close & Apply:

image

Then the Apply Query Changes window will load whilst the data model loads:

image

Once loaded, check the table relationships are ok and change if needed:

image

Now you are ready to build the Project links report as you would normally build a Power BI report. One additional step that you will need to do it make the URL columns into Web Urls. For example, select the “Project Site URL” from the Projects dataset then click the Modelling ribbon and under the Data Category option chose Web URL:

image

Repeat this for the three custom columns created: Issue Link, Risk Link and Project Link.

A very simple report has been created below to show the hyperlinks:

image

This is a very plain report as you can see, but this demonstrates how to create hyperlinks to keys areas of the project from a Power BI report.

Categories: Paul Mather, Work Tags:
Follow

Get every new post delivered to your Inbox.

Join 498 other followers

%d bloggers like this: