none
Mapping Project Server Tasks to Project Client RRS feed

  • Question

  • I'm trying to find a somewhat reliable way of mapping tasks that I have loaded from Project Server back to Project client.  The TASK_UID field almost matches the GUID field in Project Client, however, they deviate in a subproject scenario.  WBS codes also can be duplicated when subs are inserted.  I'm really looking for an alternate "fingerprint" where I can map tasks with a high degree of confidence between server and client.  All ideas and suggestions are much appreciated.

    Thank you!

    Monday, July 25, 2011 8:29 PM

All replies

  • In the MSP_TASK table TASK_PARENT_UID column which can help you...
    Thanks, Parth
    Tuesday, July 26, 2011 9:35 AM
  • In the MSP_TASK table TASK_PARENT_UID column which can help you...
    Thanks, Parth

    Thank you for your response.  I don't understand how that field would help me map the tasks between the Project client and Project Server.  Can you explain it a little bit more?

    Thank you again.

    Tuesday, July 26, 2011 1:24 PM
  • Basically GUID column in the MSP refer to the TaskUID column to the msp_epmTask_USerView  in Reporting database...

    Basically this column can help you find the Parent Guid of the task...


    Thanks, Parth
    Wednesday, July 27, 2011 4:57 AM