none
Project Server Enterprise Text1-40 task level fields in Database? RRS feed

  • Question

  • Hello,

    There are some custom enterprise text fields available for each entity, such as Enterprise Text fields 1-40 for Tasks or Resource etc.

    documented here:

    http://office.microsoft.com/en-us/project-help/available-fields-reference-HA010370279.aspx#BM2

    more:

    http://office.microsoft.com/en-us/project-help/enterprise-text1-40-fields-HP001023958.aspx?CTT=5&origin=HA010370279

    Now user can easily insert these fields to Project views and insert/modify data of this field. however these fields are not available within reporting databases to be queried for custom reporting.

    understanding is that you can only use enterprise custom fields for reporting, but at the same time these fields are also available to be included in views and knows as Enterprise fields and not local fields. the only additional caption available for these fields is that "Project Professional only". but its for PP only, then why are they available within views? which means this data is also available somewhere in database.

    Now, based on this assumption, does any one knows that how to retrieve this task level Enterprise Text1 field using query?

    thanks.



    Khurram Jamshed - MBA, PMP, MCTS, MCITP ( Blog, Twitter, Linkedin )
    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”.

    Thursday, March 13, 2014 11:00 AM

Answers

  • please see the screen shot below, there are text1-text30 fields available within project view of type Task to be selected. where i can find this field within the database?

    Hi there.

    In Project Server 2013, these values are stored, but are not moved to the reporting schema, so running queries for them is strictly speaking not supported - however, that being said, if you look in the [pub].[MSP_TASK_CUSTOM_FIELD_VALUES] table and filter for the TaskUID you are interested in, you might find what you are looking for ;)

    Cheers,

      James.


    James Boman - http://www.boman.biz Software Consultant for IPMO - http://www.ipmo.com.au

    Friday, March 14, 2014 12:39 AM

All replies

  • Hi Khurram,

    The 1st URL points to Project 2000, and the 2nd states it applies to all versions of Project.  I think the applicable products for the 2nd URL is incorrect.  There are no such thing (anymore) as Enterprise Text1 - 40 fields (From memory they disappeared after 2003 version, I remember custom field 30 was the RBS).  From 2007 onwards you can have local custom fields, and Enterprise Custom fields.  I will mail MS to ask them to correct the incorrect product versions.


    Ben Howard [MVP] | web | blog | book

    Thursday, March 13, 2014 1:32 PM
    Moderator
  • Hi Ben,

    although the 1st URL is saying Applies to: Project and Project SErver 2010, but thats not exactly my question :)

    please see the screen shot below, there are text1-text30 fields available within project view of type Task to be selected. where i can find this field within the database?


    Khurram Jamshed - MBA, PMP, MCTS, MCITP ( Blog, Twitter, Linkedin )
    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”.

    Thursday, March 13, 2014 1:41 PM
  • Ah, sorry, not I understand.  I used these once when I set the local fields in a template and these were then utilised to change the bars on a gantt chart.  However, I have not I reported on them, so I can't comment further.

    Ben Howard [MVP] | web | blog | book

    Thursday, March 13, 2014 2:19 PM
    Moderator
  • please see the screen shot below, there are text1-text30 fields available within project view of type Task to be selected. where i can find this field within the database?

    Hi there.

    In Project Server 2013, these values are stored, but are not moved to the reporting schema, so running queries for them is strictly speaking not supported - however, that being said, if you look in the [pub].[MSP_TASK_CUSTOM_FIELD_VALUES] table and filter for the TaskUID you are interested in, you might find what you are looking for ;)

    Cheers,

      James.


    James Boman - http://www.boman.biz Software Consultant for IPMO - http://www.ipmo.com.au

    Friday, March 14, 2014 12:39 AM
  • Hi , thanks James for pointing out to the rite source, i already reached to this table prior to ur reply though :)

    i agree that its not supported to read from published database, and i always stick with the recommendation to customers all the time. However you can understand that there are times when envrionmental factors are unavoidable :)

    on other note, what i do not really understand is that why these fields are even available to be used in views??

    may be someone able to shed light on this, for now i am marking ur reply as an answer closing this thread.

    thanks again, cheers mate.


    Khurram Jamshed - MBA, PMP, MCTS, MCITP ( Blog, Twitter, Linkedin )
    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”.

    Tuesday, March 18, 2014 11:39 AM