Project
702 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 Sub38Views0likes3Commentstask 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?30Views0likes1CommentRetrieve 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!Solved34Views0likes3CommentsAccess 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 administrators10Views0likes0CommentsNotification 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?Solved42Views0likes2CommentsExcel 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!Solved63Views0likes5CommentsNew Flow Templates for Project for the web
We have released two new Power Automate Flow templates for Project Managers and Team Members to help you be more productive with Project for the web. You can also use these templates to explore how to build more Flows with data from Project for the web.25KViews5likes36CommentsProject 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.1KViews0likes10Comments