Hello everyone, Our project is one of many using the Enterprise version of MS Project. We have individuals responsible for updating the status of the tasks in the project. They put the status of their task into PWA, where the PM reviews the status and either approves or disapproves the update.
Is there a way to put the status into a file and have PWA read that file and have the information ready for the PM to review?
Can you clarify the problem you are trying to solving as adding an additional step in the overall process is likely to complicate things more than simplify them.
Sure, I didn't want to get into too much detail if no one was going to answer :)
We currently use JIRA to track our work. The activities in the project schedule are associated with JIRA tickets. We were looking at having the team update their JIRA tickets, Export the changes to a file (probably .csv), and then input that file into PWA. Otherwise, each member of the team will need to go into PWA and update the information manually, essentially doing double work.
That does make sense - however, I'd question why there is a 1:1 mapping of JIRA tickets to project activities. In cases where both tools are used, I've seen the schedule be at a higher level reflecting the work across multiple JIRA tickets (e.g. single MS Project activity represents a sprint or an epic).
If this granularity of integration is required, using the MS Project web API in conjunction with the JIRA API or a third-party product such as https://www.ceptah.com/ might be needed.