How to sync from a SharePoint list data to the projects in PWA Project Center? RRS feed

  • Question

  • Dear all,

    I got a requirement from my leader, and after looking and studying a lot of materials in the internet, I haven’t got the answer yet.


    I have a project server 2010 and already created some project plans. Also I have created some business intelligence reports by obtaining the data from Project Server Reporting DB.

    Since it is difficult for everyone to update the resource and task info in the PWA. (We haven’t let the PWA use for everyone.) We thought might be we can just create a simple list, then other users who may not familiar with the PWA can update the work time to every tasks. Obviously, we can achieve this easily. However how to let the list info sync to the project plans in Project Center is a headache for me now.

    I know that we can sync the project plan to task list in SharePoint through using office Project Professional 2010. But, when the project pro connects the server, it doesn’t work anymore. So I wonder if there is another way to solve my concern.

    Any thoughts will be much appreciated!

    Thanks in advance.

    Well, maybe you need extra info; I am waiting here for your reply.

    Skype: abcdedandan

    With great power comes great responsibility.
    Wednesday, November 23, 2011 6:42 AM


All replies

  • Hi Vicky,
    You might like to try posting on the server forum selected from here:
    Mike Glen
    MS Project MVP (97-11)
    See for my free Project Tutorials
    Wednesday, November 23, 2011 8:40 AM
  • Hi Mike,

    I don't think the web site can solve my problem, I don't like the style of it actually.

    Just an idea of this question, it seems it can't be achieved.

    Refer to this:

    Thanks all the same.
    With great power comes great responsibility.
    • Marked as answer by Vicky.Z Wednesday, November 23, 2011 10:54 AM
    • Unmarked as answer by Vicky.Z Thursday, November 24, 2011 11:51 AM
    Wednesday, November 23, 2011 10:54 AM
  • Vicky --

    I cannot imagine there is any easy way for your organization to make your leader's requirement work.  I think you would be far better off teaching all of your team members how to enter progress in the Tasks page in PWA and then teaching your project managers how to approve progress in the Approval Center in PWA.  In the long run, I think you would get a lot more benefit out of using Project Server in this manner.  Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    "We write the books on Project Server"

    Wednesday, November 23, 2011 9:34 PM
  • Hi Dale,

    I am very appreciate you opinion, consider in the long run you are absolutely  right. But as you can see, the Project Server is very powerful for project management and a little complex at the same time. Even my leader and I just begin to use it not a long time, there are some features we haven't got a clue yet. Anyway, we will put PWA to use public in the future. Thanks for concern.

    Since you have put your point on Approval Center. I wonder if you know more than this. I hope you can solve my some doubts here:

    1. How to define a project manager in PWA after I build a team for a project?

    2. Is the default assignment owner is the project manager for every team members?

    3. When a team member wants to submit his task progress, actually, it displays that he submit to his project manager. Well, who is his project manager on earth? The default assignment owner? In my situation, I changed the default assignment owner in the Resource Center first, but after the one submits his status, turn out it need the other one who is the system account to approval the status, the task appears in his approval center. Is this is a coincidence or maybe other logic or design I don't know.

    Hope you can provide some tips for my doubts. Probably, I need to ask in other topic forums? Fine by  me.

    Thanks a lot.

    With great power comes great responsibility.
    Thursday, November 24, 2011 12:50 AM