Grumpy Curmudgeon
Grumpy Curmudgeon

Reputation: 137

How to store custom (non-task) data in MS-Project file?

I'm writing a Project add-on (VSTO) using C#, to programatically generate an Earned Value Chart (Planned effort vs. Actual effort vs. Actual work completed), and I want to store weekly actual effort data within the Microsoft Project 2016 (MSP) file (.mpp).

In MSP: we don't need to know how much effort was spent on each activity. For this chart, I only require the actual effort for entire project for each week. We use different systems for measuring planned effort versus actual effort for each dev activity.

Sample dataset that I want to store: Week# Hrs per week 2018-W16 900.00 2018-W17 1038.50 2018-W18 811.25

I've got solutions for deriving/storing "Planned effort" and "Actual work completed". The final piece would be solved if I could store this "Weekly actual effort" data in the MSP file.

AFAIK, and to avoid XY problem: the contraints listed below are preventing me from using built-in MSP features (to generate graph) or datastore (to store my custom data).

Constraints

What I've tried

Upvotes: 1

Views: 431

Answers (1)

Jerred S.
Jerred S.

Reputation: 376

Sounds like your core problem is: I want to store project-level (so not task/resource/assignment data) somewhere in the .mpp flie. Take a look at a similar discussion Where can I save the settings entered by the user? ; there's expanded information about custom fields which I think may solve your problem.

Upvotes: 1

Related Questions