Forum Widgets
Latest Discussions
Extract Data with VBA in the Project
Hi guys, I need some help.I need to extract data from the project to connect to Power BI. I'm currently using the feature in the database model by going to Report>Visual Report>Save Data Select: Task SummaryField Picker (for custom fields) Save Database However, the chronogram is too large and I'm getting an error on this screen asking me to reduce/separate the project. I wanted to do this export in VBA, I even tried using the VBA code below, but I couldn't find a parameter to export the custom fields. Sub Macro1() VisualReportsSaveDatabase strNamePath:="C:\Users\tulio.oliveira\Downloads\Chronogram_Consolidated_V5.mdb", PjVisualReportsDataLevel:=pjLevelWeeks End SubProject for the web non-Default environment
Hi, A customer moved a project for the web data from default environment to a non-default environment. as expected they are noticing some different behaviour. they are very disappointed and cannot understand why is that the case (but thisis for a different discussion) the issues they are having at the moment and i hope someone have had some creative solution for those When a team member is added to a project a group is created, they get the email from group or project, but the link direct them to the accelerator of the power apps P4W instead of the original experience they were having where the link direct them to the typical P4W page Permissions with that group added all users are added to the restricted group where they can delete projects, they are aware of the plugin but still cant get over the shock that something as basic as this require a custom plugin I hope im missing something and there are solutions for both cases !
task drop down not working
I have a project running with a number of task sections with indents, one of these has stopped displaying the sub tasks when i click on the triangle icon ( hope this makes sense) . All others are working. Is there an easy fix or would it be better to re-write this section?
Auto schedule tasks with over-allocated resources
I need to manage a project using the Project tool. I can’t seem to get it to automatically adjust the resources assigned to tasks when tasks with the same resources overlap. Here’s a simplified example: Project Characteristics: No set end date -> The goal is to define the end date based on the total task duration (within certain limits). We have information on the hours each task should take and the start date. Based on these criteria and the resources assigned to each task, we’ll determine the project’s end date and adjust accordingly. 2 tasks (simplified example) 2 resources: “Player 1” and “Player 2,” both dedicated 100% to the project. Schedule: Monday to Thursday, 8:00 AM to 6:00 PM, and Friday, 8:00 AM to 2:30 PM. Spanish public holidays included. The task start dates are fixed. Task Details: Task 1 - "Breathe" Duration: 100 hours Start date: 12/02/2024 (a "Must Start On" constraint has been added) Assigned resources: Player 1 and Player 2 Task configuration: Duration: 6.25 days -> Estimated automatically by Project. I don’t have a days duration limitation, only by hours. The Estimated checkbox is also marked. Schedule mode: Auto Scheduled Resources: Player 1 (100% units) and Player 2 (100% units) -> This indicates that both resources can dedicate 100% of their time to the task, but if it overlaps with others, it should adjust automatically. In this simplified example, manual adjustments are possible, but this won’t be feasible in a real-world scenario with many tasks and resources. Task type: Fixed units, and Effort-driven is marked -> The goal is to adjust as needed when resources are added or removed, changing only the task's end date and the hours allocated per resource, not the total hours. Task 2 - "Complete Mission 1" Duration: 50 hours Start date: 12/02/2024 (a "Must Start On" constraint has been added) Predecessor: Task 1 ("Breathe") with a Start-to-Start dependency. Assigned resource: Player 1 Task configuration: Same as Task 1, except it has Task 1 as a predecessor. The Issue: Based on the setup, Tasks 1 and 2 will overlap. Both resources will dedicate 9 hours daily to each task, causing "Player 1" to work 9 hours on "Breathe" and 9 hours on "Complete Mission 1" simultaneously. This results in an 18-hour workday, exceeding their 9-hour limit. Attempted Solution: I tried to resolve the overlap by leveling resources through "Leveling Options" with the following configuration: Leveling calculations: Automatic Look for overallocations on a: Day-by-day basis Clear leveling values before leveling: Checked Level entire project: Checked Leveling order: Standard (no priorities assigned) Level only within available slack: Not checked Leveling can adjust individual assignments on a task: Checked Leveling can create splits in remaining work: Not checked Level resources with the proposed booking type: Checked Level manually scheduled tasks: Checked (even though all tasks are auto-scheduled) Desired Outcome: I need Project to automatically adjust the resource's available time (9 hours) between the daily tasks (in this case, two). It should delay the end dates and assign 4.5 hours to each task. This adjustment must be automatic because, in the real-world scenario, there are many tasks and resources in the project, making 100% manual adjustments unfeasible. If anyone knows what I might be doing wrong or if my approach is flawed, I’d greatly appreciate the help.
How to Submit a Timesheet on Behalf of Another User in Project Online using API?
I develop a flow that once a week submit timesheets for all users. Is there a way to submit a timesheet on behalf of another user? I have tried the endpoint:_api/ProjectServer/TimeSheetPeriods('periodid')/TimeSheet However, it works only in the current user's context. When I run a Power Automate flow as an Admin, the flow can only see the Admin's timesheets. Could you please advise how I can submit a timesheet for another user?
Access Project Online from Project desktop client
Hallo, I need your help please. I have Project online desktop client and can't connect to the Project Web App. Error says "Project was unable to establish a connection with [Project Server URL]. This could be caused by a loss of network connectivity or inadequate permissions to connect to Project Web App." The URL name is defined in Project online desktop client ashttps://xxxxxxx.sharepoint.com/sites/PM.MCO I have been granted P5 license and defined in the security groups of Project managers and administrators
