Forum Discussion
Add, Edit, Delete Project Online data using Excel
Team,
I am aware/comfortable accessing our Project Online data using the ODATA - I set up connections/queries using Excel 365 and Power Query etc..
What I'd like to do - is after loading the data from let's say the Projects object - I'd like to modify the project data values in excel - much easier than doing it in MS Project. For example, what if I wanted to change the Start and Finish Dates to be the value they are now PLUS 75 days. Easy in Excel to do a formula, then update the values.
I've done this with other tools for applications like SalesForce etc
What I'm wondering is if/how - after I make these edits - what can I do to then PUSH the edits back into Project online.
Hopefully, my question makes sense?
Hello MonteStJohns,
You could probably automate this import if you have consistent source data across all the Excel files but this would be custom code - potentially VBA / VSTO add-in for Excel / Project. Out of the box you do have the ability to import Excel data to Project too https://support.office.com/en-us/article/import-excel-data-into-project-cb3fb91a-ad05-4506-b0af-8aa8b2247119
Paul
5 Replies
Hello MonteStJohns
Copied my reply from TechNet:
It feels like you could be over engineering something here, what's the issue with project managers maintaining their project schedules in Microsoft Project / PWA? Depending on what difficulties your users are having, it might be easier to build an add-in for Microsoft Project using VBA and keep it all in Project as you then do not have any data syncing challenges https://docs.microsoft.com/en-us/office/vba/api/overview/project
Paul
Thanks for your prompt reply.
At this time - I'm in the embryonic stage of trying to use PWA/PO for initially Portfolio Management - with first focus on Resource Management and Portfolio Prioritization. We don't even have enough licenses NOR have we trained PMs to use any MS Project suite of tools.
So first thing I'm trying to do - is get the "single-source" of data out from 100's of separate XLS files into PWA/PO. So, me and my first EPPM team member are doing ALL the work by ourselves - and it will be that way for at least the next 90-120 days as we first have to SELL the approach, then assuming it works, then we have licensing, training etc until we're at the point we're 30-45 individuals are creating/maintaining the content.
Here's a link (https://www.xappex.com/#/Enabler4Excel) to the tool I've used in my past to do similar work at different organization when we were using SFDC as the primary development platform for many business process (including EPPM).
I'll be at the office in an hour or so and will look closely at the links you provided.
As always, appreciate your prompt/candid feedback.
Monte
Hello MonteStJohns,
You could probably automate this import if you have consistent source data across all the Excel files but this would be custom code - potentially VBA / VSTO add-in for Excel / Project. Out of the box you do have the ability to import Excel data to Project too https://support.office.com/en-us/article/import-excel-data-into-project-cb3fb91a-ad05-4506-b0af-8aa8b2247119
Paul
