需要在PPM中自动创建资源 [英] Need to automate resource creation in PPM

问题描述

您好

我正在使用Project Server 2013，我们实际上是在尝试自动化PPM中的资源设置。

I am working on Project Server 2013 and we are actually trying to automate the resource set up in PPM.

我们通常会获得一张excel表，其中包含需要在PPM中设置的所有新资源，但逐个设置资源会占用大量的生产时间，因此我们正在尝试自动化资源创建过程。

We usually get a excel sheet with all new resources who need to be set up in PPM, but setting up resources one by one takes away lot of productive time, hence we are trying to automate the resource creation process.

寻找一些自动化，以便解决方案从excel / csv文件中获取资源详细信息并在PPM中创建资源。并且每周安排一次这种自动化（非工作时间）。

Looking for some automation such that the solution fetches the resources details from an excel/csv file and creates resources in PPM. And schedule this automation once in a week (Off business hours).

如果有人遇到这样的要求，你能推荐/指导吗？寻找详细的解决方案。

Can you pls suggest/guide if anyone has come across such a requirement? Looking for a detailed solution.

谢谢。

推荐答案

假设您只是在谈论资源池，而不是权限，

Assuming you are only talking about resources pool and not permissions,

有几种方法可以实现这一点，但最简单的方法是使用AD同步，创建AD组并将组添加到Project Server安全组/资源池同步，但请注意，它可能不会显示所有资源属性，另一个
选项是手动创建它们，使用Project Pro，在Project pro中打开资源中心，并且几乎可以复制并粘贴但请注意，此方法不会自动分配权限，最后一个是
使用PSI / CSOM开发自定义程序（检查SDK相同） 从excel导入资源并将其添加到资源池子，大声思考，我相信自定义程序也可以用PowerShell编写，或者你可以使用.NET 

There are several ways to achieve this, however the most simplistic would be to use AD Sync, Create an AD group and add the group to the Project Server Security Group / Resource Pool sync, however note it may not bring up all resource attributes, another option would be to create them manually using Project Pro, open the resource center in Project pro and pretty much you can copy and paste the resources however note this method would not assign the permissions automatically, the last would be to develop a custom program using PSI/CSOM(Check SDK for the same) to import resources from excel and add them to the Resource pool, thinking loud, i believe custom program may also be written in PowerShell or you can use .NET 

如果有这个帮助，请告诉我s

Let me know if this helps

  

  

这篇关于需要在PPM中自动创建资源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！