none
MS Project 2007 is there a flag/field that shows that a Project needs publishing RRS feed

  • Question

  • As I'm sure you all do, we have Project Leaders who forget to publish their plans on a regular basis.  I have a small report that checks actual work in the Draft and Reporting databases and shows any where there is a difference, which works after a fashion.  But is there a field/flag somewhere in the project databases which indicates that a project needs publishing?

    Or should I just go ahead and write my own code to keep a records of saves and publishes to evaluate when changes are made but not published?

    John.

    • Changed type JohnHolding Tuesday, August 7, 2012 12:00 PM
    Tuesday, August 7, 2012 10:39 AM

Answers

  • Hi John--

    I agree with you & sounds like you will need to automate the process to publish the project(s) using the jobs or some other ways.

    Please see below Powershell script of publishing project based on name or all projects:
    http://gallery.technet.microsoft.com/scriptcenter/Server-2010-Powershell-6b3f730a
    http://gallery.technet.microsoft.com/scriptcenter/Server-2010-Publish-all-45ba385b

    As far as I know in my previous analysis,  you can get the following fields from Draft & published database MSP_PROJECTS table
    [PROJ_NAME] ,[PROJ_LAST_SAVED] ,[CREATED_DATE] ,[MOD_DATE]   ,[CREATED_REV_COUNTER]  ,[MOD_REV_COUNTER] 

    From  publsihed database > [PROJ_UID] ,[PROJ_NAME]  ,[PROJ_LAST_SAVED] ,[PROJ_PUBLISH_STATUS] ,[DELETED_FLAG] ,[PROJ_CURRENT_REV_COUNTER] ,[PROJ_CURRENT_REV_RANK],[CREATED_DATE] ,[MOD_DATE], [CREATED_REV_COUNTER] ,[MOD_REV_COUNTER].

    If you compare the values , MOD_REV_COUNTER field contain the active version number. The two revision counter numbers enable you to determine when the document was last edited by Project Professional or by another application. if both are same, I belive that project was saved & published.
    As we know that direct query of Draft/published database is not supported. You will need to find a PSI way to check the values to see which project needs a publish.
    http://msdn.microsoft.com/en-us/library/office/gg508876.aspx

    Hope this will give a start to analyze.

    Thanks,



    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    • Marked as answer by JohnHolding Tuesday, August 7, 2012 12:00 PM
    Tuesday, August 7, 2012 11:14 AM

All replies

  • Hi John--

    I agree with you & sounds like you will need to automate the process to publish the project(s) using the jobs or some other ways.

    Please see below Powershell script of publishing project based on name or all projects:
    http://gallery.technet.microsoft.com/scriptcenter/Server-2010-Powershell-6b3f730a
    http://gallery.technet.microsoft.com/scriptcenter/Server-2010-Publish-all-45ba385b

    As far as I know in my previous analysis,  you can get the following fields from Draft & published database MSP_PROJECTS table
    [PROJ_NAME] ,[PROJ_LAST_SAVED] ,[CREATED_DATE] ,[MOD_DATE]   ,[CREATED_REV_COUNTER]  ,[MOD_REV_COUNTER] 

    From  publsihed database > [PROJ_UID] ,[PROJ_NAME]  ,[PROJ_LAST_SAVED] ,[PROJ_PUBLISH_STATUS] ,[DELETED_FLAG] ,[PROJ_CURRENT_REV_COUNTER] ,[PROJ_CURRENT_REV_RANK],[CREATED_DATE] ,[MOD_DATE], [CREATED_REV_COUNTER] ,[MOD_REV_COUNTER].

    If you compare the values , MOD_REV_COUNTER field contain the active version number. The two revision counter numbers enable you to determine when the document was last edited by Project Professional or by another application. if both are same, I belive that project was saved & published.
    As we know that direct query of Draft/published database is not supported. You will need to find a PSI way to check the values to see which project needs a publish.
    http://msdn.microsoft.com/en-us/library/office/gg508876.aspx

    Hope this will give a start to analyze.

    Thanks,



    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    • Marked as answer by JohnHolding Tuesday, August 7, 2012 12:00 PM
    Tuesday, August 7, 2012 11:14 AM
  • Perfect Amit, that tells us exactly what we need.

    As to the mothod of delivery, we have Crystal Reports Server here, any passive reporting like this gets done through that.  We have a whole suite of reports for helping the Project Leaders run their Projects, and an even bigger suite of governance reports to help us keep the system healthy.

    Many thanks

    John.

    Tuesday, August 7, 2012 12:00 PM
  • You are most welcome :) John!!!

    Happy to hear that I was able to help.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Tuesday, August 7, 2012 12:03 PM