none
PWA 2003: Hidden Tasks not appearing in Views RRS feed

Answers

All replies

  • Jonathan --
     
    Wow, your question takes me back more than a few years in time!  I believe the PMs of the projects containing hidden tasks would need to do the following to make the hidden tasks to reappear:
    1. Open a project in which a team member hid tasks on the My Tasks page.
    2. Click View > Resource Usage.
    3. Select the task assignments assigned to the resource who hid his/her tasks in the My Tasks page.
    4. Click Collaborate > Publish > Republish Assignments.
    5. In the Republish Assignments dialog, click the Republish Assignments For pick list at the top of the dialog and choose the Selected Items option.
    6. Click the OK button.
    Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Tuesday, July 31, 2012 8:40 PM
    Moderator
  • Dale,

    Thanks for your quick response. 

    The Resource Usage View is not in our list of Views, even under Admin->Manage Views.

    I don't see Collaborate either, does that appear just for the Resource Usage View?

    I read something else by Gaurav Wason, about going into the database and doing something like this:

    UPDATE [myprojdb].[dbo].[MSP_WEB_ASSIGNMENTS]
    SET [WASSN_REMOVED_BY_RESOURCE] = 0
       ,[WASSN_LOCKDOWN_BY_MANAGER] = 1
    WHERE [WASSN_ID] = <ID for hidden task>

    But that may be too much work on our part and will not work if the Project containing the Task was also hidden.


    Jonathan M Beck




    • Edited by Beta Star Tuesday, July 31, 2012 9:10 PM
    Tuesday, July 31, 2012 9:07 PM
  • Jonathan --
     
    The Resource Usage view and the Collaborate menu are found in Microsoft Project Professional 2003, and NOT in PWA.  Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Tuesday, July 31, 2012 10:04 PM
    Moderator
  • Dale,

    The PM I spoke with knows about that solution and doesn't want to do that because there are hundreds of Projects and Tasks in this organization.  Too much work!

    I found a SQL script "sp_psactualsbyweek.sql" in the MS Office Project 2003 SDK under "Extract TimephasedData".  We can export the results as CSV to Excel and then that gives them the totals they need.

    Here's what I found in the readme:

    Extracting Timephased Data

    Instructions for using the Timephased Data files are in the following topic, which is in the section Programming Tasks of the HTML Help file pj11sdk2003.chm.

    Extracting Timephased Data from the Microsoft Office Project 2003 or Project Server 2003 Database

    The HTML Help file is included in the complete Project 2003 Software Development Kit (SDK).


    Jonathan M Beck




    • Edited by Beta Star Wednesday, August 1, 2012 5:43 PM
    Wednesday, August 1, 2012 5:41 PM
  • Jonathan --
     
    The SQL script sure sounds like the easiest solution.  Go for it, my friend!

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    • Marked as answer by Beta Star Thursday, August 2, 2012 2:15 PM
    Wednesday, August 1, 2012 9:01 PM
    Moderator