none
Project Server 2010 PSI capabilities question RRS feed

  • Question

  • Hello,

    We have the following scenario:

    - Starting with a Plan made with Microsoft Project.

    - A major industrial enterprise needs to track tasks in real time during a month (~3000 taks, 24h shifts, 1 month planned).

    - These tasks' progress are feeded using PDA's, Smartphones and Barcodes to a SQL Server.

    - The original Plan needs to be updated with the information afore mentioned, and viewed in real time.

    - Modifications will be made to the updated plan in order to rearrange future tasks according to new risks and incidents that rose.

    And my question is, if we adopted a Project Server 2010 solution:

    - Could we update the tasks' time (a task finished late, hence it's duration changed, or started early) using PSI so that it updates the entire plannification? (dependencies...). I have read the article "What PSI Can do and Can Do Not" and I couldn't figure an accurate picture.

    - Also, could the Project Professional aplication be used to checkout the plan and update it while Tasks updates arrive (PDA, Smartphones...)? so that when the file is checked in again, the queued udpates will execute? (Obviously storing the updates in a propiertary designed database, and triggered manually to be queued with PSI in the checked out Project File).

    - Last but not least, is it possible somehow to use the Project Web App Gantt chart feature or the Gantt WebPart in visual studio for a ASP.NET Solution outside Sharepoint?

    Thank you very much for your time, and I hope the question is asked in the right forum.

    Cheers.

    Wednesday, August 1, 2012 11:14 AM

Answers

  • Hi There,

    Please see the below response. This is the right forum for projects erver related customizations.

    - Could we update the tasks' time (a task finished late, hence it's duration changed, or started early) using PSI so that it updates the entire plannification? (dependencies...). I have read the article "What PSI Can do and Can Do Not" and I couldn't figure an accurate picture.
    --> Since the project tasks are more than 1000, You will reach the PSI limitations. 
    When you create or update a project, the PSI can process up to 1000 rows of data at the same time. If the total number of rows of new or updated data in all tables of ProjectDataSet exceeds 1000, the PSI returns the ProjectExceededItemsLimit
    R
    ef:
    http://msdn.microsoft.com/en-us/library/office/gg204248
    You will need to use MS project Pro client.

    --Could the Project Professional aplication be used to checkout the plan and update it while Tasks updates arrive (PDA, Smartphones...)? so that when the file is checked in again, the queued udpates will execute? (Obviously storing the updates in a propiertary designed database, and triggered manually to be queued with PSI in the checked out Project File).
    - Once the Project Manager approves/reject the Task updates & then a checkout is required if updating the plan. Post SP1, You have the Auto publish rule which publishes the project plan based on the rule configuration. Even if the project is checked out in MS project, 
    Tasks updates will have no issues. It can be approved/reject later.

    --is it possible somehow to use the Project Web App Gantt chart feature or the Gantt WebPart in visual studio for a ASP.NET Solution outside Sharepoint?
    The JS Grid control renders tabular data on a web page. It renders a grid view in one pane, and it can optionally render a pivoted grid or a Gantt chart in a second pane. The control is used in Microsoft SharePoint 2010, Microsoft Project 2010, and web applications such as Microsoft Access 2010.
    http://msdn.microsoft.com/en-us/library/ee535898.aspx
    http://msdn.microsoft.com/en-us/library/ee536561.aspx

    There are third party webparts that can be used for mobile/PDA apps.
    I hope that I was able to give you my 2 cents.

    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 Mario Mira Thursday, August 2, 2012 8:45 AM
    Wednesday, August 1, 2012 11:53 AM

All replies

  • Hi There,

    Please see the below response. This is the right forum for projects erver related customizations.

    - Could we update the tasks' time (a task finished late, hence it's duration changed, or started early) using PSI so that it updates the entire plannification? (dependencies...). I have read the article "What PSI Can do and Can Do Not" and I couldn't figure an accurate picture.
    --> Since the project tasks are more than 1000, You will reach the PSI limitations. 
    When you create or update a project, the PSI can process up to 1000 rows of data at the same time. If the total number of rows of new or updated data in all tables of ProjectDataSet exceeds 1000, the PSI returns the ProjectExceededItemsLimit
    R
    ef:
    http://msdn.microsoft.com/en-us/library/office/gg204248
    You will need to use MS project Pro client.

    --Could the Project Professional aplication be used to checkout the plan and update it while Tasks updates arrive (PDA, Smartphones...)? so that when the file is checked in again, the queued udpates will execute? (Obviously storing the updates in a propiertary designed database, and triggered manually to be queued with PSI in the checked out Project File).
    - Once the Project Manager approves/reject the Task updates & then a checkout is required if updating the plan. Post SP1, You have the Auto publish rule which publishes the project plan based on the rule configuration. Even if the project is checked out in MS project, 
    Tasks updates will have no issues. It can be approved/reject later.

    --is it possible somehow to use the Project Web App Gantt chart feature or the Gantt WebPart in visual studio for a ASP.NET Solution outside Sharepoint?
    The JS Grid control renders tabular data on a web page. It renders a grid view in one pane, and it can optionally render a pivoted grid or a Gantt chart in a second pane. The control is used in Microsoft SharePoint 2010, Microsoft Project 2010, and web applications such as Microsoft Access 2010.
    http://msdn.microsoft.com/en-us/library/ee535898.aspx
    http://msdn.microsoft.com/en-us/library/ee536561.aspx

    There are third party webparts that can be used for mobile/PDA apps.
    I hope that I was able to give you my 2 cents.

    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 Mario Mira Thursday, August 2, 2012 8:45 AM
    Wednesday, August 1, 2012 11:53 AM
  • Thank you very much for your information, I had no clue about the 1000 limitation and probably would have discovered it too late.

    So, in order to manipulate in visual studio a project file with more than 1000 affected updated tasks... what should I do? Directly add references to dlls like Microsoft.Office.Project.Server.Library? Use Interop? (I'm trying to avoid it since MSoft doesn't recommend it on a server) or that kind of automation is not possible at all? (If this is the case then we'll have to code our own plannification tool, which will be a real pain in the ***).

    Any ideas?

    Thursday, August 2, 2012 8:13 AM
  • Hi Mario--

    In order to update a project plan having more than 1000 tasks, You will need to use MS project pro client. If you are really looking for the project updates using PSI to update Tasks level proprties, would suggest the plan to break into smaller projects & then shouldn't be an issue for PSI.


    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

    Thursday, August 2, 2012 8:34 AM
  • Thanks again for the answer.

    We can't use MS project pro client because it would involve human interaction, and the tasks' updates need to be automated. Breaking the project file into smaller pieces would be great, but I don't think the client will accept it. So I guess our only choice is to build our own plannification engine to meet our requirements :(

    Thursday, August 2, 2012 8:52 AM
  • In case anybody finds this post usefull I'll post the approach taken in the end:

    Although it's true that the PSI can't update a project with more than 1000 tasks, that doesn't mean it can't send a status update about 1 task (which was the need we had).

    We didn't read enough about Project Server 2010 and Sharepoint 2010, they're truly some impresive applications. Project Server 2010 offers enough customization so that any approach that an enterprise needs (like the one posted) can be implemented with new project templantes, custom web parts and the PDP pages mentioned in the reply (this is called a Project Server Solution, I wish someone had taught me that before).

    For mobile updates, just send the status report via PSI, do not re-schedule the project getting al the task from the server in a DataSet.

    In any case, now that Project Server 2013 will be released, we're thinking about adopting this version since it offers all the mobile capabilities that we need, as well as the integration with the new Microsoft Surface tablet (clients see tablet-management of their work as an eye-candy feature they wish to use, and I'm sure will help A LOT in selling web based office solutions).

    Hope it was useful!

    Wednesday, September 12, 2012 7:31 AM