All board posts in Project

Re: Active Directory Enterprise Resource Pool Synchronization and Power automate

NLuu-020321 — Mon, 01 Mar 2021 23:09:11 GMT

Hi Paul, only for clicking the Save and Synchronize Now button. Adding resources we still do it manually. Thx for the info.

Microsoft Developer Tenant and Microsoft Project

Mike Dumka — Mon, 01 Mar 2021 19:10:22 GMT

Hi There,

I have a tenant as part of the Microsoft Developer program, but I am trying to explore the possibilities with Project for the Web (Project Plan 1) and Project Online (Project Plan 3&5) and also how that interacts with Project Roadmap and Power BI.

The problem is I can seem to find anything to do with Project in my tenant. Is this not possible?

Thanks

Re: Project Online ReST API fetch recently updated tasks, assignments

Paul Mather — Sat, 27 Feb 2021 19:13:04 GMT

Hi ,

I think you will still get newly created data but the best way to see if the logic is correct is to test every single scenario in Project Online and executing your application.

Paul

Re: Project Online ReST API fetch recently updated tasks, assignments

rohanw24 — Sat, 27 Feb 2021 18:44:59 GMT

Hi ,

While filtering projects I'm using this API uri:

https://example.sharepoint.com/sites/pwa/_api/ProjectServer/Projects?$filter=lastSavedDate gt $DateCriteria&isCheckedOut=true

$DateCriteria will contain timestamp when the application was successfully executed. So that it will consider only those projects that were saved after provided $DateCriteria and which are checked out. Could you please let me know your thoughts on this logic?

Thanks & Regards,
Rohan

Re: Active Directory Enterprise Resource Pool Synchronization and Power automate

Paul Mather — Fri, 26 Feb 2021 11:23:20 GMT

Hello ,

I have not come across a customer who finds the Resource AD sync only running once a day being an issue. If there are urgent additions needed in the Enterprise Resource pool, those customers request with their IT team that the users are added to the correct AD group for the sync but they also manually add the resources to the enterprise resource pool.

Regarding syncing using Power Automate, are you looking to add the resources via Power Automate or trigger the built in Resource AD sync via Power Automate? I dont think triggering the built in Resource AD sync will be possible via a normal Power Automate flow. You might be able to do it via a Power Automate UI flow by automating the clicking of the "Save and Synchronize Now" button in PWA.

Paul

Active Directory Enterprise Resource Pool Synchronization and Power automate

NLuu-020321 — Thu, 25 Feb 2021 14:57:14 GMT

We have a need to sync our AD resources group more than 1 time a day (MS default). I was wondering if anyone has tried the Power Automate to help with Active Directory Enterprise Resource Pool Synchronization task.

Once a day is not practical for us at all, as we have hundreds ongoing projects with multiple times resources access requirement daily. Wonder how you manage yours for those who are in the same situation using AD group sync.

Thank you,

NLuu

Re: how can MS Project license transfer to another machine ?

NLuu-020321 — Thu, 25 Feb 2021 14:45:45 GMT

It really depends how each company assigns license to its member. For my company, I uninstall the app from the old machine, order installation to be pushed to my new machine (company internal order) and inform our software personnel that my computer has changed. If you don't have layer of software personnel who can act, might as well contact MS directly and inform them.

How to customize Timesheet views

Francois_CPD — Thu, 25 Feb 2021 08:46:03 GMT

Hello,

We are currently using MS PRoject Central and timesheets.

The main feedback, we are receiving from users is about the user interface from Timesheet and Approval.

Users are losing focus,

- they do not have the key information they need ( being able to order and add fields would be great )

- they need to scroll until they find time to approve or gaps all along the calendar

Did you ever experience this on your implementation ?

What can be done to improve user experience ?

Thanks a lot for your insights.

Francois

Planning resource without redistributing what is not consumed

Francois_CPD — Thu, 25 Feb 2021 08:39:07 GMT

Hello,

In MS Project, I wish I could schedule a resource without redistributing the remaining time.

Ex: A person is planned at 50% over a year (i.e. 10 days per month)
In January, the resource only worked 2 days.

MS Project behavior => the system redistributes 8 days until the end of the year after the days entered

Desired behavior => the system must consider 2 days past in January and must not redistribute the 8 days considered as past or lost.

What are the possible options on the tasks in order to be able to simulate the desired behavior?

Thank you in advance for your feedback or answers

Francois

how can MS Project license transfer to another machine ?

fikretaydemir — Thu, 25 Feb 2021 06:10:36 GMT

Hello friends,

After user's laptop change , i need to install ms project to new machine and user should licensed ms project.

What is the steps to follow about the transfer ms project with license. I checked but can not find anythng .

Could anyone help me ?

Regards..

Re: "We Couldn't Open Your Project"

nasal8412 — Wed, 24 Feb 2021 20:07:59 GMT

Please find the below

0cdbf6cb-93f2-482a-bdcd-3200e0fcc019

Re: "We Couldn't Open Your Project"

priyankapuranik — Wed, 24 Feb 2021 19:42:43 GMT

Could you give us the details with the correlation id? (You should see if if you click on details in the error screen)

Re: Migrating from Project Server 2010 to 2016

Paul Mather — Wed, 24 Feb 2021 17:46:55 GMT

Hello ,

Giving a cost estimate here is not going to be possible as we would need to understand specifics around the set up. One of the big factors would be if you are doing the upgrade yourself or working with a 3rd party.

To upgrade from Project Server 2010 to Project Server 2016, the 2010 database needs to be upgraded to Project Server 2013 first then Project Server 2016. How come you are not upgrading to Project Server 2019? Project Server 2016 mainstream support ends in July this year: https://docs.microsoft.com/en-gb/lifecycle/products/project-server-2016

where as Project Server 2019 mainstream support ends in Jan 2024: https://docs.microsoft.com/en-gb/lifecycle/products/project-server-2019

Many thanks

Re: "We Couldn't Open Your Project"

nasal8412 — Wed, 24 Feb 2021 17:30:34 GMT

could you please share the fix for this issue as one of my customers also facing the same issue

need to unblock this

thanks in advance

Re: OData Project Schema TaskStatusManagerUID Not Synchronized

GhisC — Wed, 24 Feb 2021 17:09:21 GMT

Hello ,

I am actually facing the same issue where the TaskStatusManagerUID in the plan is not reflecting the same from the oData feeds.

Have you figured it out?

Thanks,

GhisC

Migrating from Project Server 2010 to 2016

Komal_Agarwal — Wed, 24 Feb 2021 06:51:12 GMT

Hi All,

We are having an instance of Project Server 2010 which we need to migrate to Project Server 2016. There are around 655 projects and 1550 users in this instance. Please could you help us in calculating the cost estimation for this upgrade.

Re: POL report for linked projects...

James_Price — Tue, 23 Feb 2021 14:37:45 GMT

Thanks for this Paul.

James

Error Message: Resources have items checked out to them and could not be deleted.

NLuu-020321 — Mon, 22 Feb 2021 23:48:27 GMT

A resource left my company but I can't delete him from PWA with this warning message "Resources have items checked out to them and could not be deleted".

I went to force check-in area, I couldn't find him there either. I also queried the entire database, he isn't there either. What is the next step? I hate to just leave him in the PWA, if he is no longer with us.

Thank you,

NLuu

Re: We are sorry, can't open your project

bgroslouis — Mon, 22 Feb 2021 14:30:14 GMT

Hi, thanks for the response. For unknown reason, it came back working properly a few hours after posting this message. Not sure what was the issue but it is working now.

Thanks.

Re: Limitation of Size/Complexity of Project Plans within MS Project Online???

Dale Howard — Mon, 22 Feb 2021 13:36:00 GMT

-- Yes, Project Online can handle a project with 5,000 tasks. If you have dozens or hundreds of resources assigned TO EACH TASK, that can slow down the saving and publishing operations where it might take the software a minute to save or publish your project. But yes, the software can easily handle a project of your size. Hope this helps.

Limitation of Size/Complexity of Project Plans within MS Project Online???

pmikota — Sun, 21 Feb 2021 19:14:24 GMT

My company is moving from a dedicated MS Project server to SAAS MS Project Online. I am wondering if there is going to be any performance issues due to the size of some of the project plans we will be migrating over. Microsoft does not post any project size recommendations that I can find for MS Project Online. Example of a project I am concerned about. Project is approx. 5000 lines, fully resource loaded Can MS Project Online handle projects that are that big?

Re: We are sorry, can't open your project

Paul Mather — Sat, 20 Feb 2021 09:14:39 GMT

Hello ,

Does this project open for any user? There isn't a lot we can recommend from this support forum for this other than opening a support ticket from your Microsoft 365 tenant so that Microsoft can investigate.

Paul

Problem with activation, it says that the project server 2016 preview is activated

nikolainikitin — Sat, 20 Feb 2021 04:08:14 GMT

Good afternoon, we have a license for project server 2016 (PrjctSvr 2016 RUS OLP NL Acdmc), installed everything according to the instructions (sql server 2017 enterprise, sharepoint 2016 enterprise), after installation, when you try to activate the project server, it shows that the preview version is activated, please help understand.

how to activate olp version?

We are sorry, can't open your project

bgroslouis — Sat, 20 Feb 2021 01:02:06 GMT

Hi, I've been working on a Project all day until I got this message with correlation ID: c528723e-9f4f-4f67-a1a0-64690d8b0e5f What can be done to get this fixed? Thanks!!

Re: MS Project Timeline Displaying Incorrectly

Dale Howard — Thu, 18 Feb 2021 23:00:49 GMT

-- You are more than welcome for the help, my friend!

RE: No projects are not opening

horstpichler — Thu, 18 Feb 2021 21:30:11 GMT

what did you do in order to fix this issue. I am experiencing the same since yesterday.

Any help is appreciated

Horst

Why must I specify a search direction when using the search tool in Project?

schaefda — Thu, 18 Feb 2021 21:17:35 GMT

Why doesn't the search tool just wrap around if it finds nothing below? I've observed that sometimes the search-wrapping does occur, but more often than not it doesn't. Does anyone know the secret to make it happen always?

Re: MS Project Timeline Displaying Incorrectly

johnsojj — Thu, 18 Feb 2021 20:47:29 GMT

please disregard my previous comment. I think it is because the project timeline is so long. Thanks for your help.

Re: MS Project Timeline Displaying Incorrectly

johnsojj — Thu, 18 Feb 2021 20:42:27 GMT

this fixed this issue on a couple projects, but it does not help on others. It looks like it is set to Quarters. I checked the Timescale and tried setting it to days and months.

What are different options or variations in Timesheet in Project Server 2019

M.A. Farooqui — Thu, 18 Feb 2021 13:23:04 GMT

Hi,

For Timesheet In Project Server 2019 on prem,

For Project Level Reporting or Top Level Reporting
I have 2 questions :

1 - Unless I assign the resource against task, he is not getting timesheet generated for him
For Top Level reporting- I thought resource assignment is not needed against task

2.1- What is the benefit of this piece of functionality ? any scenarios if someone can share ?

2.2 - Where can I see the summary of report generated by this approcah...

Appreciate any suggestions...

Re: POL report for linked projects...

Paul Mather — Wed, 17 Feb 2021 22:47:11 GMT

Hi ,

This post might help https://pwmather.wordpress.com/2018/10/13/projectonline-reporting-on-task-predecessors-and-successors-o365-msproject-ppm-pmot-excel-powerbi-odata/

Paul

POL report for linked projects...

James_Price — Wed, 17 Feb 2021 14:18:54 GMT

Hi team

Can anyone recommend a way of showing, in a Power BI report, projects with inter-project dependencies?

Many thanks

James

Re: Tasks in Project for the Web...

James_Price — Wed, 17 Feb 2021 14:14:50 GMT

Good point Dale. Thanks

Re: Tasks in Project for the Web...

Dale Howard — Wed, 17 Feb 2021 13:44:23 GMT

-- Since I do not work for Microsoft, I am only speculating. But I suspect the functionality you seek will never be added to Project for the Web. This is because the your functionality is not available in Project Online, which is a much bigger and more robust project management system from Microsoft. If the feature is not in Project Online, I do not think it will be added to Project for the Web. But again, I am only speculating, and I certainly could be wrong. Hope this helps.

Re: How do I report (Power BI) on vacation days in Resource Calendar (Project Online)

Alison Howes — Wed, 17 Feb 2021 09:09:01 GMT

Thanks Paul, I'll check that out! :)
Alison

Re: Project Online ReST API fetch recently updated tasks, assignments

Paul Mather — Wed, 17 Feb 2021 09:02:49 GMT

Hello ,

Can you used the created date to filter out newly created projects / tasks / assignments?

Paul

Re: How do I report (Power BI) on vacation days in Resource Calendar (Project Online)

Paul Mather — Wed, 17 Feb 2021 08:59:58 GMT

Hello ,

This data is available in the ProjectServer API (_api/ProjectServer). For example:

{pwaSiteUrl}/_api/ProjectServer/EnterpriseResources('{resouceGuid}')/ResourceCalendarExceptions

Replace the {resouceGuid} with the resource GUID for the resource you want to check.

Paul

Re: Tasks in Project for the Web...

pschneider — Wed, 17 Feb 2021 08:38:44 GMT

https://microsoftproject.uservoice.com/forums/914203-project-for-the-web/suggestions/38922199-two-way-integration-with-microsoft-planner-and-mic

Quite important feature!
Looking forward for a status update by Microsoft, please.

Tasks in Project for the Web...

James_Price — Wed, 17 Feb 2021 08:28:02 GMT

Hi team

In the PfW tasks, do you think it will be possible in the near future that in a project, for team A to see all their tasks and team B to see all their tasks, with team A not able to see team B's tasks and visa versa?

Many thanks

James

Project Online ReST API fetch recently updated tasks, assignments

rohanw24 — Tue, 16 Feb 2021 18:38:55 GMT

Hello Everyone,

I want to fetch recently updated tasks, assignments from Project Online. Currently I've included a filter to fetch projects and related tasks, assignments by published date time. But when I execute it also includes newly created project and related tasks, assignments. Project, task, assignment creation module executes before update module. How this scenario can be handle? Is it possible to create a flag in the Project Online that will auto-update to 1 whenever a user makes any manual changes in the task, assignment?

Thanks & Regards,

Rohan

How do I report (Power BI) on vacation days in Resource Calendar (Project Online)

Alison Howes — Tue, 16 Feb 2021 18:26:17 GMT

Hi,

I'm trying to report on remaining vacation days in Power BI when connected to Project Online.

Resources report their requested vacation days via their timesheet, and once approved, their resource calendar gets updated automatically. We have a resource field which shows the annual entitlement, so as these entitlement days are consumed I want to then report on the remaining days that each resource would have available. However I am really struggling to find the right data in the tables that would provide me with the approved vacation days taken/booked so far. Any advice greatly appreciated. Thanks
Alison

Re: impossible d'ouvrir ce fichier

Wapofa — Tue, 16 Feb 2021 14:11:31 GMT

I cant oppen my project it give me an error

Re: Project Online resource engagement is smoothed after being reassigned

Miles_Goodchild — Tue, 16 Feb 2021 09:50:41 GMT

Ah sorry, missed the fact that you're on Project for the web.

impossible d'ouvrir ce fichier

Wapofa — Tue, 16 Feb 2021 02:17:44 GMT

Bonjour, jai besoin d'aide afin de récupérer mon projet

Re: Display Task Name Next to Bars on Gantt Chart - MS Project ONLINE

SAEED1338 — Mon, 15 Feb 2021 21:40:59 GMT

thanks but that unfortunate.

should not the online be a copy of what the desktop is including all the functionalities.....?

Anyway thanks

Re: Display Task Name Next to Bars on Gantt Chart - MS Project ONLINE

Dale Howard — Mon, 15 Feb 2021 14:09:39 GMT

-- It is not possible to display text to the right of Gantt bars in PWA views. This is only possible in Microsoft Project. Sorry, but hope this helps.

Re: Project Online ReST API Check out and Publish

Malek Al-Shayeb — Mon, 15 Feb 2021 10:25:37 GMT

Hi, i belive for all of them you need to checkout and publish

Calendar templates in Project for the web

Knut Fredrik Berg — Mon, 15 Feb 2021 09:49:17 GMT

I'm trying to find out what realy happen with calendars in Projet for the web. I accept that 9-5 is the default and that I can't do anything about that. Just like the desktop version. So I have to set up my own default calendar template. I know the whole routine to add a new calendar template. So I don't need help with that. However, when I try to set up a new template I also have to change the time zone. Often I have to do this more than one time. (When I create the calendar resource and when I add it to the template) Also strange, the time zone I have to change from can be different. From Casablanca time to Beograd and even UTC. Where can I find the place where the time zone settings in Project for the web are located? Where are all this things connected. These problems seems a little odd to me. Please, anyone?

Display Task Name Next to Bars on Gantt Chart - MS Project ONLINE

SAEED1338 — Mon, 15 Feb 2021 03:34:15 GMT

I know how that's done on the desktop version but not the Project online version

https://project.microsoft.com/en-US

Does anyone know?

Project Online ReST API Check out and Publish

rohanw24 — Sun, 14 Feb 2021 05:11:11 GMT

Hello Everyone,

For which operations (Create, Update, Delete) I need to check out and publish the project for Project, Task, Assignment, Resource?

Thanks & Regards,

Rohan

Re: Differences between Project XML and MPP files

Estate_Master — Thu, 11 Feb 2021 23:04:34 GMT

I am exporting to XML, because we are developing a C# app that uses a .Net Gantt control. That control allows users to import MS Project XML files, not MPP format.

Re: Can't See the Detail and Tracking Gantt Charts

brennj4 — Thu, 11 Feb 2021 18:45:12 GMT

So simple, yet so frustrating to not see it. Thank you for this.

Project Online ReST API UTF-8 Encoding

rohanw24 — Thu, 11 Feb 2021 17:39:22 GMT

Hello Everyone,

I want to set project name containing some Norwegian characters while creating a new project. I'm using code samples available here:

https://github.com/OfficeDev/Project-Samples/tree/master/O365-Project-Online-REST-Samples

When I try to create a project having name with Norwegian characters it throws "The request was aborted: The request was cancelled." error.

Does anyone knows how to encode request body to UTF-8 in powershell?

Thanks & Regards,

Rohan

Re: Differences between Project XML and MPP files

Dale Howard — Thu, 11 Feb 2021 14:38:40 GMT

-- I am not surprised at all by the fact that you see differences between the original project and a new project created from the exported XML file. Based on my personal experience, the XML file does not capture the timephasing of task Work and Cost values on tasks. And I suspect your use of the 24 Hour calendar is at least partially the source of the errors.

For me, the Save to XML option is a last resort to try to fix a corrupted project. I know that using this feature will capture the "guts" of the project, but not the exact duplicate project. Out of curiosity, why are you using the Save to XML feature?

Please let us know and we will try to help you.

Differences between Project XML and MPP files

Estate_Master — Thu, 11 Feb 2021 06:49:37 GMT

I am using Project Standard 2016 (Version 1908 Build 11929.20300)

I have experienced an issue where I am getting differences in data between an original *.mpp file, and an *.xml that I exported from that mpp file. The differences then continue to occur if I then save the first XML file as an XML file again.

I have attached the 3 Project files in the .Zip file.

These are my steps:

Opened the "Sample.MPP", and took a screenshot of the first 23 tasks
Saved the file as "Sample.XML".
Opened that "Sample.XML" file, selecting 'Import as New Project' when prompted. Took a screenshot of the same Tasks.
Saved that as a second XML file "Sample_2".XML (no changes were made to it).
Opened that "Sample_2".XML file, selecting 'Import as New Project' when prompted. Took a screenshot of the same Tasks.

I compared the screenshots between all 3 files, and noticed that Dates and Durations were continuously changing from the original MPP file (see attached file Differences.png)

I checked the Calendar Options and Working Time settings after each file is opened, and they seem all the same: https://www.screencast.com/t/7RdF3B0BdW

I also check what the Calendar Options were for 'New Projects' and they were slightly different: https://www.screencast.com/t/3DOPdG9y

What is causing these differences?

Does the XML Export have certain limitations / not support certain settings?
Is there something else that is adjusting the dates when the XML file is being opened/imported as a new Project?

Updates:

I also tested in MS Project 2019, and the issue still happens.
I think it may be related to the fact that the project is using the '24 Hour' calendar. I had another 2 Project files which were exporting / loading XMLs fine, but as soon as i changed the calendar in the MPP files to use "24 Hour", and then exported the XML, once that XML was opened in Project again, the dates/times changed.

Re: Project online: Status Manager Field

NLuu-020321 — Wed, 10 Feb 2021 23:29:14 GMT

Also I would like to expand a bit more to help those who maybe new to Project and PBI.

To get Status manager's name, you will need to compare two datasets 1) Resources and 2) Tasks.

I used PBI, and get data via OData feed selection (put in your URL:

https://yoursharepointsite.com/sites/yoursitename/_api/Projectdata)

In the Resources dataset retrieve ResourcesId and ResourceName.

In the Tasks dataset, retrieve Task name, Project Name, and Task status manager UID.

Then merge two datasources to find the Status manager's name residing in what project and which task.

With that information, you know where to go make change and replace former status manager who left the company with the new one.

Project Online ReST API create project Error 500

rohanw24 — Wed, 10 Feb 2021 18:10:18 GMT

Hello Everyone,

When I try to execute create project PowerShell script through .Net application, it throws 500 internal server error. I'm using code samples available here:

https://github.com/OfficeDev/Project-Samples/tree/master/O365-Project-Online-REST-Samples

Thanks & Regards,

Rohan

Re: Project hyperlink minimize behavior

Dale Howard — Wed, 10 Feb 2021 13:28:38 GMT

-- I tested this with Microsoft Project 2016 and can pretty much confirm what you are experiencing. When I click a hyperlink on a task, the Windows system sends Microsoft Project into the background while launching my default web browser. I also tested using hyperlinks in both Microsoft Word 2016 and Microsoft Excel 2016, and saw the same behavior as Microsoft Project 2016. Based on that, I suspect that this is the default behavior of Microsoft Office products, and that there is no way to change this behavior. Sorry for the bad news, but hope this helps.

Adding users to project using "Project Permissions" through CSOM

ramkanumuri — Tue, 09 Feb 2021 09:34:51 GMT

Hi,

Is it possible to provide permissions to users on project using "Project Permissions" through CSOM in project online?

RE: Project Online Custom Field auto-update value

ben_project — Tue, 09 Feb 2021 08:02:41 GMT

Hi, Alas there is no event that flags when a task is modified. https://docs.microsoft.com/en-us/office/vba/api/project.task

Project Online Custom Field auto-update value

rohanw24 — Tue, 09 Feb 2021 06:01:45 GMT

Hello Everyone,

I'm having a custom field called "Sync Status" under Task. Is it possible to auto-update it's value let say to 1 whenever a Task gets modified? Just like a trigger?

Thanks & Regards,

Rohan

Project hyperlink minimize behavior

JeffA86 — Mon, 08 Feb 2021 16:28:02 GMT

Hello,

When I click a hyperlink from the hyperlink field, project immediately minimizes while opening the browser link. If I right click the hyperlink field, select Hyperlink, then Open in New Window, Project does not minimize. I've searched on the topic and normally the answer is pointed to browser or OS settings. It's a pain. Is there anyway to modify the behavior of the click on the hyperlink within project to simply do the same thing that the right click procedure does? It would be most beneficial.

Thanks,

Jeff

Re: Projects are shared with me even though I am not a member...?

Lisa Stebbins — Mon, 08 Feb 2021 13:33:20 GMT

I figured it out. Because I have the Project license that permits Project Online features and functions (Plan 3), I am able to access and interact with other people's projects even though I am not a member of their group. We have an old PWA site collection and a few people with the Project licenses (don't know what their license level is though) who have 'played' with the app but because it requires all the group members to pay for a Plan 1 license at least, the users did not continue using the app and did not delete what they'd created. As a result, there were a few past projects listed (the old PWA) and few new abandoned ones (Project for the Web).

I didn't know that having a Project Plan 3 license not only gives you admin level access to the old PWA sites but also gives you access to the new Project for the Web projects for which you have no affiliation nor do you want it. Not the functionality I expected, obviously. Really through me off!

Re: project Site creation failure

pauleast — Mon, 08 Feb 2021 09:49:23 GMT

thanks, found it! Unfortunately no luck, it fails to build a site with the default template.

Re: Project Server 2019 Schedule.aspx Load Error only in edit mode

harunkara — Mon, 08 Feb 2021 06:24:23 GMT

Hi Paul, I opened a ticket about this isssue and we got it resolved. I found some files in C drive root which were called Program Files and its derivatives from P to Program Files x86. Apparently these files appeared because of an anti virus software in the servers.

The specific reason for the error was caused by Claims to Windows Token Service not being able to start due to their path being corrupted by the awkward files I mentioned above. Once i cleared the c drive root of those files and started C2WTS service the error disappeared.

Project Online ReST API Get Projects related tasks, assignments, resources

rohanw24 — Mon, 08 Feb 2021 04:48:09 GMT

Hello Everyone,

Does anyone knows the endpoint to fetch a project it's related tasks, assignments, and resources in one go? Basically I want a summary view of projects and it's related tasks, assignments and resources.

Thanks & Regards,

Rohan

Re: Project For The Web - access restrictions

Paul Mather — Sun, 07 Feb 2021 14:36:38 GMT

Hello ,

Project for the web doesn't have a granular access model unfortunately. A view access license is possible at the tenant level but not project per project: https://docs.microsoft.com/en-us/project-for-the-web/office-365-user-view-access-to-project-and-roadmap

Paul

Re: Project Server 2019 Schedule.aspx Load Error only in edit mode

Paul Mather — Sun, 07 Feb 2021 14:33:18 GMT

Hello ,

Are you able to ask IT what changed? Did they apply a new SharePoint / Project Server update to the farm? Any other updates on the farm?

Paul

Re: project Site creation failure

Paul Mather — Fri, 05 Feb 2021 15:37:26 GMT

Hello ,

On the EPT in the Site Template option in Project Online, there will be "Project Site" - that is the OOB project site template.

Paul

Re: project Site creation failure

pauleast — Fri, 05 Feb 2021 15:34:17 GMT

we don't have an OOB template:( do you know if this exists online and we can add?

Re: Project for the Web: Stop team members changing the duration of their tasks...

James_Price — Fri, 05 Feb 2021 10:57:32 GMT

Re: Project for the Web: Stop team members changing the duration of their tasks...

Dale Howard — Fri, 05 Feb 2021 10:56:29 GMT

-- That is exactly why Project for the Web needs a view or page where team members can enter task progress. So, I do understand your need and concern.

Re: Project for the Web: Stop team members changing the duration of their tasks...

James_Price — Fri, 05 Feb 2021 05:50:59 GMT

Hi Dale

Understood but the problem with view only is that they cannot update progress. Unless I'm missing something :)

Cheers

James

Re: Project for the Web: Stop team members changing the duration of their tasks...

James_Price — Fri, 05 Feb 2021 05:47:32 GMT

OK. Thanks for that Paul

James

Re: Basic Question - "Cost Variance" always equals "Cost"

TrevorATperfectproject — Fri, 05 Feb 2021 05:46:22 GMT

That's how it works. if you input the actual duration which is less than the scheduled duration, then MSP will truncate the task to that lesser duration, there is no remaining duration, and there is now an actual start and an actual finish which replace the scheduled start and scheduled finish. If you input an actual duration greater than scheduled duration, the task is extended, and so on.

Re: Basic Question - "Cost Variance" always equals "Cost"

TrevorATperfectproject — Fri, 05 Feb 2021 05:40:03 GMT

, I can see that you are well on your way to the typical new user experience of using MSP. Before you go round and round in circles, here's a few tips.

Don't assume that you know the meaning and definition of a field/column. You can check for precisely what it is by hovering the cursor over the column heading. The variance of something is simply the difference between the current something and the baseline something. If there is no baseline then there is no difference. Baseline values are set when you set a baseline. They can be edited manually as well (don't).

You need a rock solid approach to updating progress and re-scheduling as required. Start by practicing with (auto scheduled) tasks which have duration only, so no resource assignments, no work, no cost. You will need to set a status date. Display the status date as a vertical red line on the chart (format, gridlines). The status date will be earlier than a task start, or it goes through the middle, or it is after the task finish. A task has a scheduled/planned start and a scheduled/planned duration and a scheduled/planned finish. After some or all of the task has actually occurred (as at the status date/time), they all turn out to be different than what was scheduled/planned. Use the tracking table to input the actuals, and they will replace the as scheduled/planned. This will take some practice. Once you have that nailed down, then you can try the same thing with work and cost. Use the task usage and resource usage views.

Any help so far?

Re: Basic Question - "Cost Variance" always equals "Cost"

esmitheccit — Thu, 04 Feb 2021 22:38:07 GMT

I apologize, clearly I'm still learning this. if I set the "baseline duration" column to display, that one at least does NOT change even after I set "remaining work" to zero, which is good enough for my purposes I think. And then the "Duration Variance" column seems to be based directly on what I enter in Baseline Duration.

Re: Basic Question - "Cost Variance" always equals "Cost"

esmitheccit — Thu, 04 Feb 2021 22:22:46 GMT

I think I spoke too soon. This seemed to work fine when I had individual projects but once I created subprojects it stopped working.

Right now I have two subprojects part of a master project. I have baselined the entire thing again and zeroed out all "actual duration" entries.

If I have a task that has a "Duration" of 1 hour but I enter in the "Actual Duration" as 0.5 hours and then set "Remaining Work" to zero, it then changes my "Duration" value back to 0.5 hours and it makes the "Duration Variance" positive 0.5 hours.

Perhaps there's a different column/metric I should be using to indicate how much work/time WAS spent on a task (vs what was originally scheduled)?

Re: Project for the Web: Stop team members changing the duration of their tasks...

Dale Howard — Thu, 04 Feb 2021 16:12:33 GMT

- In addition to Paul's excellent reply, you need to know that if your team members have a Project Plan 1 license, they are allowed to edit the projects in which they are team members, as well as to be able to create and edit their own projects. On the other hand, if the team members DO NOT have a Project Plan 1 license, they are granted "view only" access to the projects in which they are team members, and they CANNOT change anything. So, based on your description, your team members do have a Project Plan 1 license, which means that Paul gave you the correct answer.

If I were you, I would simply ask my team members NOT to make any changes to their projects without involving me in the decision to make the change. Hope this helps.

Re: Project for the Web: Stop team members changing the duration of their tasks...

Paul Mather — Thu, 04 Feb 2021 08:02:40 GMT

Hi ,

Unfortunately not, once a user has edit access to the project for the web project, they have full edit access.

Paul

Project for the Web: Stop team members changing the duration of their tasks...

James_Price — Thu, 04 Feb 2021 06:46:47 GMT

Hi Team

Can you tell me if it possible stop team members changing the duration of their tasks?

Many thanks

James

Re: Projects are shared with me even though I am not a member...?

Paul Mather — Wed, 03 Feb 2021 21:32:03 GMT

Hi ,

For those Project for the web projects, I guess you are a member of the associated Group / have access to the Group. Access one of those projects and click the Group members in the top right hand corner / access the Group.

Paul

Re: Project online: Status Manager Field

NLuu-020321 — Wed, 03 Feb 2021 17:57:29 GMT

Thank you very much Paul. Cheers!

Re: Project online: Status Manager Field

Paul Mather — Wed, 03 Feb 2021 16:59:52 GMT

Hello ,

Using the Task endpoint in the ProjectData API, you will have the TaskStatusManagerUID.

Paul

Re: project Site creation failure

Paul Mather — Wed, 03 Feb 2021 16:53:06 GMT

Hi ,

As a test, can you set one EPT to use the OOB Project Site template and create a Project from the pipeline list to see if it repros there?

Paul

Re: Basic Question - "Cost Variance" always equals "Cost"

esmitheccit — Wed, 03 Feb 2021 15:34:44 GMT

Thanks so much, this seemed to do the trick. For me the two keys were to set the baseline and to display the "remaining work" column and zero that out. Once I did that it changed percent complete to 100% automatically, and my cost variance fields displayed properly as well.

Project online: Status Manager Field

NLuu-020321 — Wed, 03 Feb 2021 15:11:14 GMT

Upon deleting resources, I got this message "The resource is the assignment owner for .... and cannot be deleted." I am unable to query Status manager unlike other custom fields. This allows me to see info. I need across all projects and know where to go and replace old resource/status manager with new person.

Currently, I query using task name which is time consuming and not productive.

How do I query Status Manager and whether this is searchable. Thank you.

Re: project Site creation failure

pauleast — Wed, 03 Feb 2021 11:59:51 GMT

we don't have a default one as in OOB from Microsoft as we have a custom build. What does seem to be happening is the failure of the site build doesn't happen when we create a project from 'new' whereas using our pipeline list does...this links list items to custom fields in the project details.

Re: Basic Question - "Cost Variance" always equals "Cost"

Guillaume Rouyre — Wed, 03 Feb 2021 09:02:57 GMT

Hi ,

The variance is a calculation between a data (start, finish, work, cost, duration) and the baseline data. The baseline is a snapshot of your project so you can at any time measure the difference between what was planned and what is happening.

So basically you need to schedule your project, save a baseline. From that the variances will be equal to 0 before you do any update. As soon as you'll update any tasks, you'll see variance.

Now about progress tracking. The best practice is not to update the % complete. Because if you update the %complete to 100%, it will consider that the task took the planned work to be completed, which might not be the case. I advice that you update the actual work. Then if the actual work is less than the planned work but the task is complete, just set the remaning work to 0. It will automatically update the % complete to 100%.

Basic Question - "Cost Variance" always equals "Cost"

esmitheccit — Tue, 02 Feb 2021 22:14:21 GMT

Apologies if this is a dumb question, but I'm fairly new to Project. I've noticed whenever I have a task that takes less time to complete than is scheduled/specified (actual duration vs duration) it always changes the "% complete" fields and my cost variance is always listed as the same as my "cost".

For example, User John has a task scheduled for 3 hours that only ends up taking him 1.5 hours to complete. At his rate of $190 per hour, the planned cost ("cost") for his task should be $570 but since it only took 1.5 hours the actual cost is $285. So far so good, except that when I display the "Cost variance" field Project lists my CV as $570. And worse, when I change the "actual duration" it automatically thinks the task is no longer at 100% completion.

So I kind of have two basic issues:

1. I want to be able to mark tasks at 100% completion even if they take less time than originally planned. And I want the actual time spent on that task to NOT get reset if I manually mark a task as 100% complete.

2. I need to figure out how the cost variance works in the sense that all my attempts thus far have never shown anything other than "cost variance" always being the same as "cost".

Projects are shared with me even though I am not a member...?

Lisa Stebbins — Tue, 02 Feb 2021 22:00:29 GMT

I am very new to Project for the web. I don't understand why I see other projects, with someone (not me) and the project lead for which there are no members, in my Shared with me list of projects. Why would something appeared shared with me when my name is not mentioned anywhere in the project or its tasks?

I have a Project Plan 3 license. We have a PWA/Project Online site collection but I'd really like to not have it anymore and only have Project for the web.

Re: project Site creation failure

Paul Mather — Tue, 02 Feb 2021 18:57:38 GMT

Hello ,

What happens when the EPT is set to use the default "Project Site" template - does that work?

Paul

project Site creation failure

pauleast — Tue, 02 Feb 2021 13:53:23 GMT

I get the attached error when trying to build a site from a template. This happens for all the templates in our library, new and old.

Project Online ReST API Http Errors

rohanw24 — Mon, 01 Feb 2021 17:10:29 GMT

Hello Everyone,
 
I'm trying to update an existing project using ReST API call as mentioned in:
https://github.com/OfficeDev/Project-REST-Basic-Operations/blob/master/updateproject.ps1
When I try to execute it I'm getting "Exception calling "GetResponse" with "0" argument(s): "The remote server returned an error: (412) Precondition Failed.""
Another error occurred when I tried to create a new project resource as well as when I try to delete existing tasks http://<SITECOLLECTION>/<SITE>/_api/ProjectServer/Projects('projectid')/Draft/Tasks('taskid')/deleteObject()
I was getting 409 Conflict error.
What can be the reason of these issues?

Thanks & Regards,
Rohan

Re: Project Online ReST API Resource

Paul Mather — Sun, 31 Jan 2021 22:21:47 GMT

Hello

Enterprise Resources (https://{pwaUrl}/_api/ProjectServer/EnterpriseResources ) is the API that allows management of the Project Online Enterprise Resource pool. Where as Project Resources (https://{pwaUrl}/_api/ProjectServer/Projects('{projectGuid}')/ProjectResources) are the resources added to that project team.

Here is an example adding resources to the project using the ProjectResources endpoint: https://github.com/OfficeDev/Project-Samples/blob/master/O365-Project-Online-REST-Samples/createproject.ps1

Here is an example using the EnterpriseResource pool endpoint: https://pholpar.wordpress.com/2016/07/26/creating-project-server-enterprise-resources-via-rest/

Paul

Project Online ReST API Resource

rohanw24 — Sat, 30 Jan 2021 12:58:59 GMT

Hello Everyone,

I've few questions in regards to resource:

1. What is the difference between the enterprise and project resource?

2. I want to update existing resource, what are the ReST endpoints for both types of resources?

Thanks & Regards,

Rohan

Re: Project Online ReST API get recently updated projects

Paul Mather — Fri, 29 Jan 2021 21:49:26 GMT

Hello , for the data in the following to APIs, the projects will need to be published to get updated:

You will find that the Saved / Modified dates match the published dates on these APIs apart from when a project summary publish happens. A project summary publish happens when you click Save from normal PDPs (not the Schedule PDP tasks ribbon). In that scenario you will find the modified / saved dates are later than the Published dates.

Paul

Project Online ReST API get recently updated projects

rohanw24 — Fri, 29 Jan 2021 18:04:27 GMT

Hello Everyone,

I want to filter a list of projects that are recently updated. Which project related property is useful in this? LastPublishedDate or LastSavedDate or any other property / criteria?

Thanks & Regards,

Rohan

Re: Project Online - How to filter projects in powershell?

rohanw24 — Fri, 29 Jan 2021 17:15:43 GMT

Issue has been resolved. Escaped $filter with back-tick `$filter.

Project Online - How to filter projects in powershell?

rohanw24 — Thu, 28 Jan 2021 14:03:16 GMT

Hello Everyone,

I want to filter projects on LastPublishedDate in power shell. How to include $filter query string in the endpoint.

For example,

https://example.sharepoint.com/sites/pwa/_api/ProjectServer/Projects?$filter=LastPublishedDate -ge datetime'28-01-2021'

When I open my URL with same format in browser it works fine. But when I include it in the power shell, all projects are returned.

I'm using these samples:

https://github.com/OfficeDev/Project-Samples/tree/master/O365-Project-Online-REST-Samples

Does anyone knows the correct way to include $filter query string in power shell script?

Thanks & Regards,

Rohan