Forum Discussion
Edit Adressbook in Exchange online
- Oct 10, 2020
It's up to you, and what is the information stored in the HR, for me I used the EmployeeID from the HR and map it to my AD as this ID is unique and wont be duplicated in their side.
As you said, you can generate a CSV with the attribute you need and send it to them, let them update the information and send it back to you, then simply import it, but keep in main that this process should be performed every time a new employee join your company so the HR will need to send you an employee profile to update in your side.
---------------------
If you find this answer helpful, then please select Best Response 🙂
What is the best way to edit the data. There should be a person who edits the data. This person should have little IT knowledge. I also don't want to leave you direct to the internal AD.
The best way is to automate it with an integration with the HR system, in my case, I wrote a script that integrates with the ERP system and fetches the user information and updates it based on what the HR has in their database.
If it's too complicated, then you can delegate someone from the HR to update the basic user information
The person doesn't need to have any technical background, and with a proper delegation, you can be safe. you can delegate to view a certain OU only.
Also, please note that each organization is different, so what may apply in my case might not apply in your case.
In the end, you need the data to be filled, the best way is proper automated integration or a delegated person how is willing to spend his time filling the information.
BTW, a quick way to do it is to request the HR to provide you with a CSV with all the missing information in your Directory and then simply import it to the directory using Powershell.
tell me which approach you want so I can try to help guide you what to do next.
- StefanKiOct 09, 2020Iron Contributor
I think the best way is to use Powershell to create an export from AD to CSV and a CSV import into AD. HR has to fill out the CSV file. As key I use the SID or Email, because they are unique.
Thanks a lot
- farismalaebOct 10, 2020Steel Contributor
It's up to you, and what is the information stored in the HR, for me I used the EmployeeID from the HR and map it to my AD as this ID is unique and wont be duplicated in their side.
As you said, you can generate a CSV with the attribute you need and send it to them, let them update the information and send it back to you, then simply import it, but keep in main that this process should be performed every time a new employee join your company so the HR will need to send you an employee profile to update in your side.
---------------------
If you find this answer helpful, then please select Best Response 🙂