Forum Widgets
Latest Discussions
End dates of Subtask are appearing wrong
Hi there, I'm facing issue with import of xml file. When I import the file, Finish date of task having subtask, gets disturb. I am attaching the screenshot from xml file indicating the dates that I have set in it Heres the screenshot from Microsoft Project when I import the xml file After going through multiple solution, I found one of them partially working which suggested that i should turn off project calculation after each edit After applying this setting and re-loading the xml, Finish date of parent task appear corrected but for its subtasks which has duration greater than one, it still appears wrong Can someone please suggest me a solution for this ?
Project web app- No up to date data via OData feed
Hi all, we are working with the project web app. The Data stored in the project web app is pulled via the OData feed connector into a PowerBI report. The project web app is hosted on https://company.sharepoint.com/sites/pwa, the data is pulled from https://company.sharepoint.com/sites/pwa/_api/projectdata. The connection and data refresh was working for months without an issue, last week I have added two enterprise custom fields in the PWA and made some changes to the Enterprise Global. When opening the enterprise global a cache limit error appeared in Project Desktop, which was resolved by deleting the cache. I had to do a forced check in of the enterprise global in the PWA settings. I also got an error when loading the "Tasks" table in Power BI, an issue with one of the newly added enterprise custom fields was reported. This issue just appeared once, seems now to be resolved. Since then, I have not gotten any up to data from the PWA via the OData feed into PowerBI. When looking directly in the PWA the data gets updated, but gets not submitted via the OData feed anymore, some "old" versoin of the data gets submitted, I can run the data refresh against the OData feed without any issue but returns only "old" data. I also have 2 "Project Save from Project Professional" jobs under "Manage queue jobs" with job type "Cancelled" which I cannot remove / cancel from the list. How can I solve this? Thanks in advanceProject Web App can't delete PDP despite custom scripting being enabled
Hi everyone, Currently trying to set up a Project Web App system and I've encountered this problem. When trying to delete/remove a project detail page from a project nothing happens. My organisation has custom scripting enabled and I can remove fields and other stuff from projects but when I try to remove a page it doesn't work. I've removed all fields from the page I'm trying to delete so I don't think its anything to do with a required field or existing workflow, and I get no error message when I try to delete the page. I simply click "Delete Page", stop editing and the page is still there with no change. Anyone have any ideas on what could be causing the issue?
Change date formatting for PWA
Hi there, I'm wondering how to change the date format for task lists in PWA. Following a quick google, I have tried to follow the instructions in this link, by changing the personalised settings but it hasn't workedhttps://integent.com/changing-project-web-app-to-display-in-your-language-or-date-format/ According to this link this only works for the power app version of Project:https://support.microsoft.com/en-us/office/set-your-language-and-date-format-in-project-for-the-web-75771fd6-3de4-49cf-9ed0-3dd26ab995a2#:~:text=Set%20language%20and%20date%20format,the%20format%20of%20your%20choice. Is there any way for this to work in Project Web App for Enterprise Projects, either using PWA site settings or each team member user personalising their own settings? Also somewhat related - is there a way for the tasks to show in the order of Task ID they are input into project without having a custom view of the Task ID and sorting by ascending etc.? Thanks in advance
MS Project Professional - VBA Color row based on field value
I have a master project with code below. What it does it: whenever I change the field Text12 to "OK" or "NOK" (and other words) it colors the whole row with a specific color (seeModule1). It works great at a master project level, that is, in tasks directly in this master project. (How it works: It checks for changes in the Text12 column and sets a bool to true. Then, in Proj_Change, it applies the colors to the correct task row) However, it doesn't work at a Subproject level. I've addedDebug.Printto each sub, and when I edit a Subproject's task, it only calls up toApp_ProjectBeforeTaskChange. Is there a way to solve this? Detect changes in Subprojects and color the rows? I've tried running the ApplyColor sub directly from the App_ProjectBeforeTaskChange sub, but VBA says "this method is not available in this situation". Also tried using a Timer, didn't work, same error. (PS: I also posted this on Stack Overflow but I couldnt get help, so I'm posting this on other forums) ThisProject: Private Sub Project_Open(ByVal pj As Project) InitializeEventHandler End Sub Module1:Regular Module Option Explicit Dim EventHandler As EventClassModule Sub InitializeEventHandler() Set EventHandler = New EventClassModule Set EventHandler.App = Application Set EventHandler.proj = Application.ActiveProject End Sub Sub ApplyColor() Dim t As Task Set t = EventHandler.ChangedTask If Not t Is Nothing Then SelectRow Row:=t.UniqueID, RowRelative:=False Select Case EventHandler.NewValue Case "OK" Font32Ex CellColor:=14282722 'green Case "NOK" Font32Ex CellColor:=11324407 'red Case "PROGRESS" Font32Ex CellColor:=65535 'blue Case "REPEAT" Font32Ex CellColor:=15652797 'yellow Case Else Font32Ex CellColor:=-16777216 'no color End Select End If End Sub EventClassModule:ClassModule Public WithEvents App As Application Public WithEvents proj As Project Public NewValue As String Public ChangePending As Boolean Public ChangedTask As Task Private Sub App_ProjectBeforeTaskChange(ByVal tsk As Task, ByVal Field As PjField, ByVal NewVal As Variant, Cancel As Boolean) If Field = 188743998 Then 'Custom field Text12 Set ChangedTask = tsk NewValue = NewVal ChangePending = True End If End Sub Private Sub Proj_Change(ByVal pj As Project) If ChangePending Then ApplyColor ChangePending = False End If End SubMS Project master plan with many projects
Hello, I did a big master plan where i have almost 20 projects with many rows. One project has approximately 70 rows. What i need to now is to share with my coworkers a master plan which shows only 8 rows from each project, Typically only assembly and testing activity. The rest should be hidden. They are not expert to use this software, so i need to prepare for them a new master file where will be shared from actual master plan the activity what they want to see only... Does somebody know how to set it? I would definitely not go in way of using some filters. So my idea is to make a new master plan which will display only some activity from actual master plan. But how to do it? How to link it. Is there any special feature for that? Thank you to all who has some idea how to solve it.
Planned / actual progress
Dear Community, A more simple question where I need your comments. What is the principle difference between the (1) Progress Line and the (2) Tracking Gantt in terms of showing the planned and actual progress .. ? The Progress Line shows for a defined activity the gap between the current date (planned) and the progress (actual), while the Tracking Gantt shows the gap between the "planned activity" and the "actual activity". Many thanks SteveProject for web generic resources not bookable
Hi, on Project for Web i've created some generic resources as you can see: Each of it with a hours calendar and bookable. Then i've added each resource in its own plan, for example: Pianificazione UDVC is my plan with my generic reource "Generica UDVC" The issue is that if i try to assign a task i can only find "Member of team x" instead of "Generica UDVC" , why that name instead of the name that i wrote? Also in some other plan i can't see any new bookable resource despite i can see the generic one from the "team" tab in Project admin portal. Why? Thanks!
