I need to get all the AD users in the Resource name in MPP

10y1.5k

I need to get all the AD users in the Resource name when assigning activity in Microsoft Project Plan(MPP) it means it need to get sync with particular domain in sharepoint 2013 and gettting all the users when clicked on assign resources.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rupali Shinde10y ago
Hi Destiny,

i will suggest below steps for you :
1. as you said above you got user names from AD.
2. try to save those user details either in Database or Excel sheet.
3. Using C# code read data from DB or Excel and create dropdown in resource sheet.

http://www.c-sharpcorner.com/UploadFile/kbpatel/how-to-create-a-dropdown-list-to-an-excel-using-C-Sharp/

if it help you out, please accept the ans
0
10y ago
Small Help wil be big asset me..Kindly please help me out
0
10y ago
There is a column which is known as "Resources Names" how can i bind all the users which are in excel sheet into the users info so that administrator can assign the tasks to the selected resources wise

PFA
0
Rupali Shinde10y ago
Hi Destiny,

what do you mean by resource sheet ??
can you please give me some example so that i can work on this thing ??
0
10y ago
Thanks Rupali i got all the users from AD but how can i show case those users in the resource sheet..I need to showcase only usernames(Like testing(Firstname in AD))) into resource sheet name of MPP..Kindly please sort me out on this
0
Rupali Shinde10y ago
Hi Destiny,

there are two ways in which you can get AD user details.
1. Powershell

Export AD user to CSV file and read that csv file in you code.
https://gallery.technet.microsoft.com/scriptcenter/Powershell-script-to-5edcdaea
http://www.morgantechspace.com/2014/11/Export-AD-Users-to-CSV-using-Powershell.html

2. C# code
http://www.codeproject.com/Tips/599697/Get-list-of-Active-Directory-users-in-Csharp
http://stackoverflow.com/questions/5162897/how-can-i-get-a-list-of-users-from-active-directory

if it help you out, please accept the ans
0