none
How to just read the Custom Fields , task and assignment related to a projects only. RRS feed

  • Question

  • I am new to PSI ,suggest me how to get above information and can I convert it to xml data
    Nur Mondal
    Thursday, October 6, 2011 5:20 AM

All replies

  • Much quicker than PSI is reading the data directly from the reporting db. MSDN site has a fre Proejct SDK for download that has teh full reporting db schema. Pay particular attention to some of teh View because they have all custom fields appended automatically.

    Rod Gill

    The one and only Project VBA Book Rod Gill Project Management
    Thursday, October 6, 2011 6:23 AM
    Moderator
  • Agreed with Rod that  reading the project related data is easy using the Project server reporting database. All the information will be in _userViews.

    To read data using PSI, You will need to use the project web service:
    http://msdn.microsoft.com/en-us/library/websvcproject_di_pj14mref.aspx
    You can use the Project class, which contains a method ReadProjectEntities which gets one or more types of information within a project, such as tasks, resources, and assignments.
    http://msdn.microsoft.com/en-us/library/gg204413.aspx
    You can pass the ProjectEntityType which is type of Int32 & can get the desired data in ProjectDataSet & which is a normal .NET dataset. You can play around.
    The ProjectEntityType takes the following values:

    • Project = 1

    • Task = 2

    • Resource = 4

    • Assignment = 8

    • Dependency = 16

    • ProjectCustomFields = 32

    • TaskCustomFields = 64

    • ResourceCustomFields = 128

    • AssignmentCustomFields = 256

    • AssignmentCore = 512

    • ProjectDefaults = 1024

    • AssignmentOwnerDefaults = 2048

    • AssignmentCustomFieldsNoRolldown = 4096


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Friday, October 7, 2011 5:22 AM