Project
664 TopicsExtract 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 Sub98Views0likes9Commentstask 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?32Views0likes1CommentRetrieve the original Project end-date
Good day! When creating a new project, I can choose the Project End date. Now, it's not uncommon that this date changes along the line. For instance, this change when one of the timelines changes in the Gantt-view. I was wondering if the end-date that was originally set and saved in the project, can be retreived somewhere so we can take it into account in a report? So we can report on the difference between the origin value and the most recent value? Thanks in advance!Solved36Views0likes3CommentsAccess 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 administrators13Views0likes0CommentsNotification not working on projects for the web
Hello! My team of 12 part-time employees and I recently switched from MS Planner to Projects on the web. As they have been updating/combining Planner and Projects we have found we are no longer receiving notifications when a task/project is complete in Projects. We have checked our settings to no avail. Any tips?Solved43Views0likes2CommentsExcel Reporting : Can't connect to calendars with OData anymore (v2)
Hello everyone, Some of you may remember my previous thread about the same-ish issue (https://techcommunity.microsoft.com/t5/project/excel-reporting-can-t-connect-to-calendars-with-odata-anymore/m-p/4132119) that ended up being solved by a Project Online patch. But somehow, the issue returned. Not the same cause, since it has nothing to do with authentication this time, but the same symptoms : trying to fetch Calendar Exceptions data from an Excel OData query doesn't work anymore. When trying to get the data, I am getting "Error 400 : Cannot get a CSOM-compatible PJContext for an HTTP request that started outside of CSOM." It seems the issue started this morning on my client's tenant. Has anyone else experienced the same issue ?Solved266Views0likes8CommentsLimiting Resources
I have a project that has two types of resources. One can provide 100% effort to the project (Resource A), and another only 80% (Resource B). I am setting the work effort, and trying to ensure that the durations are appropriate. For example, an 80-hr task for Resource A should take 2wks, but the same task for Resource B should take 2.67wks based on the availability. I've tried setting various calendars (such as a 7hr day for Resource B), and availabilities in the resource tabs, but I'm guessing I'm doing those wrong as no matter what the duration remains at 2wks. Appreciate any help!Solved63Views0likes5CommentsProject Detail Page (PDP) in Project Online not saving added fields when Stop Editing clicked
Hello friends. I've encountered a strange situation in which I am editing a PDP in Project Online that I've customized in the recent past. I wish to add two Enterprise Custom Fields to a Basic Info web part. I follow the standard steps of Edit Page > Edit Web Part > click the Modify button for Displayed Project Fields > select the two fields and click the ">" button > click Apply and confirm they show in the web part > click OK to commit > click the Stop Editing button. The page then defaults back to the previous state. I logged into two different browsers, cleared cache, and turned on the Versioning settings for the library, using Check In and Out, then reverted back to No Versioning. I will be checking with other admins to see if they have the same outcome tomorrow, but wondered if anyone else had experienced this situation?Solved2.1KViews0likes10CommentsInconsistent Values from PWA Custom Field Formula
Hello community. Greetings from first time poster. I created the following formula (“FY Project Completion”) to assign a Financial Year value based on Project Finish Date (“Finish”): if the project ends on or before June 30, 2024, Financial year will be FY24, if the project end date falls between Jul 1, 2024 and June 30, 2025, the Financial Year will be FY25, and so on. IIf([Finish] >= CDate(#7/1/2024#) And [Finish] <= CDate(#6/30/2025#), "FY25", IIf([Finish] >= CDate(#7/1/2025#) And [Finish] <= CDate(#6/30/2026#), "FY26", IIf([Finish] >= CDate(#7/1/2026#) And [Finish] <= CDate(#6/30/2027#), "FY27", IIf([Finish] >= CDate(#7/1/2027#) And [Finish] <= CDate(#6/30/2028#), "FY28", "FY24")))) Surprisingly, the formula gives inconsistent FY values, even for projects with same Finish Date: sometimes it is blank, other times it assigns different FY values. I am attaching a representative listing of about 40 projects, 23 of which have wrong FY value. I will very much appreciate it if somebody can please guide me where I need to make change in the formula to get correct values? Dummy Project Name Start Finish FY Project Completion Project in Row 2 11/13/2018 4/30/2021 FY24 Project in Row 3 3/24/2023 3/24/2023 FY25 Project in Row 4 12/14/2020 3/29/2023 Project in Row 5 3/2/2020 7/31/2023 FY24 Project in Row 6 10/25/2023 11/22/2023 FY25 Project in Row 7 1/3/2022 12/31/2023 FY25 Project in Row 8 4/6/2020 2/9/2024 FY24 Project in Row 9 9/7/2023 3/1/2024 FY25 Project in Row 10 1/3/2023 3/29/2024 FY24 Project in Row 11 4/1/2024 4/1/2024 FY24 Project in Row 12 4/1/2024 4/1/2024 FY24 Project in Row 13 4/8/2024 4/8/2024 FY24 Project in Row 14 4/8/2024 4/8/2024 FY24 Project in Row 15 3/29/2024 5/9/2024 FY24 Project in Row 16 5/16/2024 5/16/2024 FY25 Project in Row 17 11/14/2023 5/28/2024 FY24 Project in Row 18 6/11/2024 6/11/2024 FY25 Project in Row 19 7/26/2023 6/28/2024 FY24 Project in Row 20 1/3/2023 6/28/2024 FY25 Project in Row 21 1/2/2024 6/28/2024 FY25 Project in Row 22 1/3/2023 6/28/2024 FY25 Project in Row 23 1/3/2023 6/28/2024 FY24 Project in Row 24 1/3/2023 6/28/2024 FY24 Project in Row 25 1/3/2023 6/28/2024 FY26 Project in Row 26 1/3/2023 6/28/2024 FY24 Project in Row 27 7/27/2023 6/28/2024 FY25 Project in Row 28 1/24/2024 6/28/2024 FY25 Project in Row 29 1/3/2023 6/28/2024 FY24 Project in Row 30 1/3/2023 6/28/2024 FY26 Project in Row 31 1/3/2023 6/28/2024 FY24 Project in Row 56 1/3/2023 6/28/2024 Project in Row 57 1/3/2023 6/28/2024 FY26 Project in Row 58 1/3/2023 6/28/2024 FY26 Project in Row 59 5/24/2023 6/28/2024 FY24 Project in Row 60 1/17/2023 6/28/2024 FY26 Project in Row 61 1/3/2023 6/28/2024 FY26 Project in Row 62 9/1/2022 6/28/2024 FY26 Project in Row 63 1/23/2023 6/28/2024 Project in Row 64 7/3/2023 6/28/2024 Project in Row 65 10/28/2020 6/28/2024 FY25Solved92Views0likes8Comments