#ProjectOnline Publish all projects using #MSFLow #MicrosoftFlow #PPM #PMOT #Office365 #PowerPlatform part 1

December 6, 2018 at 12:00 am | Posted in Add-on, Administration, Configuration, Customisation, Functionality, Information, Performance, Reporting, Workflow | 1 Comment
Tags: , , , , ,

I recently had the opportunity to present at a Microsoft Tech Sync session where I presented a session on Project Online and Flow. During this session gave examples of how Microsoft Flow compliments Project Online by enabling no / low code solutions to extend the Project Online features. I plan to do several blog posts over the next month or so where I will share some of these Microsoft Flows. Hopefully this will give you some ideas of how Microsoft Flow can be used to simplify some of those customisations for Project Online.

The first Flow example I want to share with you is a publish all projects flow. I have published examples before for Project Server and Project Online as found here:

These all required a basic understanding of the Project Server / Project Online APIs and somewhere to run the code from – I thought this would be a good example to move over to a Microsoft Flow. In this blog post I will walkthrough the first example I have for publishing all projects as seen here:

image

This is built using only actions from the Project Online connector in Flow – so there is no need to understand the Project Online APIs! This Flow assumes you have setup the connection to Project Online using an account that has publish access to all projects. This Flow is triggered using a schedule as seen here:

image

When this Flow is triggered, the first action is to get all the Project Online projects using the List Projects action:

image

All you need to do is provide the PWA site URL. This List Projects action also includes project templates so these need to be filtered out, to do this we filter the results returned from the List Projects action using a Filter Array action:

image

In the From field we enter body(‘List_projects’)[‘value’] to get the data from the previous action, which in this case is the List projects action. In the filter we use item()[‘ProjectType’] is not equal to 1, Project Type 1 being the Project Templates. In advanced edit mode it looks like this:

image

Next we need to loop through all of the projects in the array to check them out, publish them then check them back in. To do this we need to use an Apply to each action:

image

In the output from the previous step we use body(‘Filter_array’) to use the data from the previous step which is all of our Project Online projects minus the project templates. Then for each project in the array we check out the project using the default Checkout project action:

image

Enter the Project Online PWA URL then in the Project Id property pass in the Project ID from the current item in the array using items(‘Apply_to_each’)[‘Id’]

The final action is to publish the project and check it in, this is done using the default Checkin and publish project action:

image

Enter the Project Online PWA URL then in the Project Id property pass in the Project ID from the current item in the array using items(‘Apply_to_each’)[‘Id’]

That is it, when this flow executes it will publish all of your Project Online projects. A simple no code serverless solution!

In part 2 we will look at two other variations for publishing all projects in Office 365 Project Online using Microsoft Flow.

Advertisements

#ProjectOnline Project Center updates #O365 #PPM #PMOT #MSProject

April 20, 2017 at 7:18 pm | Posted in Administration, Configuration, Customisation, Functionality, Information, Performance | Comments Off on #ProjectOnline Project Center updates #O365 #PPM #PMOT #MSProject
Tags: , , , ,

Further to the announcement the other week regarding great improvements coming to Microsoft’s Office 365 PPM tool Project Online : https://pwmather.wordpress.com/2017/04/03/awesome-update-for-projectonline-create-and-manage-up-to-30000-projects-ppm-o365-pmot-msproject/

You may have noticed that on your Project Online PWA instance you now have two new checkbox options on the Project Center Projects ribbon to improve page load times if needed:

image

Rollups: image

Gantt Chart: image

A small change but one that will help improve page load times for users.

Check server times for #SharePoint / #ProjectServer farms #PS2010 #SP2010 #MSProject #PowerShell

April 13, 2012 at 4:40 pm | Posted in Administration, Installation, Performance, PowerShell | 2 Comments
Tags: , , , ,

For a server farm it is important that all server times are in sync, for Project Server this is key. For example if the Application server has a different time to the SQL server you might see jobs in the Project Server queue that are in sleeping state. A useful PowerShell script to check all of the server times in the SharePoint farm can be seen below:

The script can be downloaded from the script center here:

http://gallery.technet.microsoft.com/scriptcenter/Check-server-time-for-all-76fdd4c0

#Script needs to be run on a SharePoint server
#Run script with account that has admin access to all servers
Add-PSSnapin Microsoft.SharePoint.PowerShell -EA 0
$servers = (Get-SPServer) | foreach {$_.Address}

foreach($server in $servers)
{

$time = Get-WmiObject Win32_LocalTime -computer $server  -EA 0

$hour = $time.Hour
$minute = $time.Minute
$second = $time.Second
Write-Host “$server current time is $hour : $minute : $second”

}
Write-host “If the server times are not in sync please adjust the time settings. Press any key to continue”
$null = $host.UI.RawUI.ReadKey(“NoEcho,IncludeKeyDown”)

An example output can be seen below:

image

#ProjectServer 2010 and #SharePoint 2010 performance analysis using PAL #paltool #PowerShell #PS2010 #SP2010 #Windows

March 21, 2012 at 4:12 pm | Posted in Administration, Performance, PowerShell | 2 Comments
Tags: , , ,

A really useful tool for analysing Performance Counter logs is PAL – Performance Analysis of Logs.

image

This is primarily a PowerShell tool with a GUI interference available to download from CodePlex:http://pal.codeplex.com/. The tool can be used to generate your Perfmon Templates, then to analyse the logs and create a nice HTML report output.

A quick overview of the tool and usage for monitoring Project Server can be found below.

From the Welcome tab switch to the Threshold tab as shown below:

image

There are preconfigured Threshold files including one specifically for Project Server. In this example I have created a custom threshold file that includes Project Server, IIS and SP2010:

image

Now export the threshold file out to a Perfmon template:

image

Now load the Performance Monitor and expand Data Collection Sets, right click on User Defined > New > Data Collection Set.

Give the data set a name and check the radio button “Create from template”

image

Click Next then Browse:

image

Navigate to the location of the new Template created earlier and open the template:

image

Click Finish. The new data collection set will appear under User defined.

Start the new data collection set when you are ready to monitor the performance counters:

image

Once the monitoring session has completed stop the data collection:

image

Now load PAL and click on the Counter Log tab and add the output file (blg file) from the counters data collection:

image

Now click on the Questions tab and answer the questions listed. Once answered, click on the Output Options tab and set the analysis interval, in this example I have left it to auto:

image

Now access the File Output tab to set the output directory and the chosen output format and file name:

image

Clicking on the Queue tab will display the variables used for the PowerShell script:

image

Click on the Execute tab and click Finish to Execute now:

image

The log will now be processed and generate the report:

image

image

Once completed the report will load in Internet Explorer:

image

image

Thanks to my colleague Chris Stretton who gave me a demo of this tool. For an excellent description of the options available on the GUI interface see Chris’s post here:

http://spchris.com/2012/03/20/analysing-performance-using-pal/

Create a free website or blog at WordPress.com.
Entries and comments feeds.