I am doing a working semester right now, with the course of study bachelor of business computing. I am not an expert in coding (think got some OK basics) nor I am a 100% fluent in English as my 2nd language so be a bit gentle on mistakes or "bumpy" formulations.
My Task:
I am working on a template, which will be handed to the company's project managers to make it easier for them to "load up" backlogs into TFS and assign tasks via MS Project. The template itself is kinda finished right now, but I have one more problem to tackle.
Automatizing the "Create Relationship Process" between Backlog Items and Tasks
TFS cant create "Parent-Child-Relationships" with the "Parent Backlog" not published yet. This means, I have to find a way (thinking of a macro/VBA) to create the relationships AND to publish some items of MS Project first, then creating the relationship and publish the rest.
Macro Start --> publish all backlogs --> creating relationships --> publish relations + tasks --> Macro End
The tricky part for me is, that it has to be as simple and intuitive as possible to use.
I hope I managed to impress myself at least a little bit understandable and someone has a little help for me.
I used Google and the Stackoverflow Search, but didn't get a satisfying answer.