none
Bulk resource loading RRS feed

  • Question

  • Hi ,

    I have to upload 1000 resources in the project server 2010, is there any way we can upload it through excel sheet by copying and pasting, adding one by one wll take lot's of time and will be a difficult task.


    Vinay Gupta
    Sunday, September 25, 2011 10:41 AM

Answers

  • Hi Vinay,

    Yes if you have the resources in Excel then you can open the Enterprise Resource Pool in Project Professional then copy and paste the resources in from the Excel sheet, just make sure that the columns match up in Excel and Project Professional. Please see this post for more details:

    http://phase2.com/blog/?p=1610

    thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    • Proposed as answer by Adil Hussain Sunday, September 25, 2011 7:35 PM
    • Marked as answer by Kvingupta Saturday, October 1, 2011 7:35 AM
    Sunday, September 25, 2011 10:52 AM
    Moderator
  • Hi Vinay,

    In addition to PWMather's excellent solution - you can also use the Active Directory Synchronization option of project server. your network engineer needs to map your resources in the respective groups and you have configure the sync mapping of project server groups with those AD groups.

    the additional benefit of having this sync enable will be that you dont have to manually manage your resources every time their details, such as email/login detail/status of the resource, will be updated.

    You can see this techNet article related to the resources AD sync settings in details: http://technet.microsoft.com/en-us/library/cc197571.aspx

    hope this also helps.


    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    • Proposed as answer by Adil Hussain Sunday, September 25, 2011 7:35 PM
    • Marked as answer by Kvingupta Saturday, October 1, 2011 7:35 AM
    Sunday, September 25, 2011 1:46 PM
  • Hi there,

    No there is no option to do that and wouldn't be supported. If you have the resources in another system / database you could use custom code and the Project Server PSI to sync the resources into Project Server.

    Hope that helps

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    • Marked as answer by Kvingupta Saturday, October 1, 2011 7:35 AM
    Monday, September 26, 2011 5:53 AM
    Moderator

All replies

  • Hi Vinay,

    Yes if you have the resources in Excel then you can open the Enterprise Resource Pool in Project Professional then copy and paste the resources in from the Excel sheet, just make sure that the columns match up in Excel and Project Professional. Please see this post for more details:

    http://phase2.com/blog/?p=1610

    thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    • Proposed as answer by Adil Hussain Sunday, September 25, 2011 7:35 PM
    • Marked as answer by Kvingupta Saturday, October 1, 2011 7:35 AM
    Sunday, September 25, 2011 10:52 AM
    Moderator
  • Hi Vinay,

    In addition to PWMather's excellent solution - you can also use the Active Directory Synchronization option of project server. your network engineer needs to map your resources in the respective groups and you have configure the sync mapping of project server groups with those AD groups.

    the additional benefit of having this sync enable will be that you dont have to manually manage your resources every time their details, such as email/login detail/status of the resource, will be updated.

    You can see this techNet article related to the resources AD sync settings in details: http://technet.microsoft.com/en-us/library/cc197571.aspx

    hope this also helps.


    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    • Proposed as answer by Adil Hussain Sunday, September 25, 2011 7:35 PM
    • Marked as answer by Kvingupta Saturday, October 1, 2011 7:35 AM
    Sunday, September 25, 2011 1:46 PM
  • Thanks for the reply,

    Is there any feasibility of uploading through sql server i.e can I upload directly in to project server database through sql scripts.

    Vinay


    Vinay Gupta
    Monday, September 26, 2011 1:45 AM
  • Hi there,

    No there is no option to do that and wouldn't be supported. If you have the resources in another system / database you could use custom code and the Project Server PSI to sync the resources into Project Server.

    Hope that helps

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    • Marked as answer by Kvingupta Saturday, October 1, 2011 7:35 AM
    Monday, September 26, 2011 5:53 AM
    Moderator