none
Cross Project Linking and Predecessors in Project Server 2010 RRS feed

  • Question

  • Hi all,

    I cannot seem to find the Predecessor column in Task User View. Does it even exist in the Reporting database? Or is in the published database which I really didn't want to query?

    I wanted to get info on cross project links in project server.

    Thanks!

    SJ


    • Edited by SJ_PPM Monday, September 17, 2012 5:19 AM
    Monday, September 17, 2012 5:06 AM

Answers

  • yeah, my fault on that one. My suggestion will not work. Sorry.

    You might be able to do something with this code. it will put the predecessor info into the enterprise field of your choice. That will put it  into the RDB where your query could parse it up a bit.

    it would have some limits due to field length but it might get you where you want to be.

    just replace 'text2' with the name of your enterprise field

    Sub externalworkaround()
    Dim t As Task
    Dim p As Task
    For Each t In ActiveProject.Tasks
        If Not (t Is Nothing) Then
            For Each p In t.PredecessorTasks
                If p.ExternalTask = True Then
                    t.SetField Application.FieldNameToFieldConstant("Test2", pjTask), t.Predecessors
                    
                End If
            Next p
        End If
    Next t
    End Sub


    Brian Kennemer - Project MVP
    DeltaBahn Senior Architect
    endlessly obsessing about Project Server…so that you don’t have to.
    Blog | Twitter | LinkedIn

    • Marked as answer by SJ_PPM Monday, September 17, 2012 1:32 PM
    Monday, September 17, 2012 7:03 AM
    Moderator

All replies

  • No predecessor or successor data in the RDB.

    you might be able to get some of what you need by looking at TaskIsExternal and then TaskParentUID. I think that if TaskIsExternal is true then TaskParentUID is the guid to the project where it came from. At least this would tell you which task is from another project and what project it is from.


    Brian Kennemer - Project MVP
    DeltaBahn Senior Architect
    endlessly obsessing about Project Server…so that you don’t have to.
    Blog | Twitter | LinkedIn

    Monday, September 17, 2012 5:47 AM
    Moderator
  • Thanks for that.

    Something that we thought would be easy to report on as it is one the expected features of any EPM system, but I guess that is not the case.

    Anyway.

    I think TaskParentUID is more to do with summary tasks and not linking of tasks.

    Thanks for your help.

    SJ


    • Edited by SJ_PPM Monday, September 17, 2012 8:37 AM
    Monday, September 17, 2012 6:32 AM
  • yeah, my fault on that one. My suggestion will not work. Sorry.

    You might be able to do something with this code. it will put the predecessor info into the enterprise field of your choice. That will put it  into the RDB where your query could parse it up a bit.

    it would have some limits due to field length but it might get you where you want to be.

    just replace 'text2' with the name of your enterprise field

    Sub externalworkaround()
    Dim t As Task
    Dim p As Task
    For Each t In ActiveProject.Tasks
        If Not (t Is Nothing) Then
            For Each p In t.PredecessorTasks
                If p.ExternalTask = True Then
                    t.SetField Application.FieldNameToFieldConstant("Test2", pjTask), t.Predecessors
                    
                End If
            Next p
        End If
    Next t
    End Sub


    Brian Kennemer - Project MVP
    DeltaBahn Senior Architect
    endlessly obsessing about Project Server…so that you don’t have to.
    Blog | Twitter | LinkedIn

    • Marked as answer by SJ_PPM Monday, September 17, 2012 1:32 PM
    Monday, September 17, 2012 7:03 AM
    Moderator
  • Thanks Brian!

    Will try and let you know.

    Since you are a MVP, can you please ask MSFT to make this such an important feature of program management to be easily reportable :-)

    Thanks again!

    SJ

    Monday, September 17, 2012 8:41 AM
  • Thanks Brian for your help! That gave me a good starting point.

    Monday, September 17, 2012 1:32 PM