mattiasvdlbe/Azure Active Directory/UpdateUserData
After updating the user data of a big list of users in Active Directory, we noticed the Usage Location was not updated in Azure Active Directory.
For this I created another script which goes over the same .csv file as the script did which updated the AD information.
See my post about the script which I created to update the Active Directory User data.
This script loads in the same .csv file and loops over all users in the file and updates the necessary fields.
I had to make a bulk update of data for a list of users, and instead of opening each user profile one by one and changing the values, I decided to write a script which could do this in bulk for me. It saved me a lot of time and avoided typing and other user errors.
I only needed to make sure the input csv was set up correctly.
I started of with an export of all necessary fields from the Active directory, made this a bit more readable for the people responsible for determining the data which needs to be updated, and provided the file to them for correction of the data.
When I received the file back, I made sure all necessary data was filled in, generated the necessary codes for the countries, and generate the .csv file this script needs to make the updates.
This script loads in the .csv file and loops over all users in the file and updates the necessary fields.
- The titles in the .csv file are the names used in AD.
You can look these up in the “Attribute Editor” tab.
- For the Country details:
- “c” = 2-character ISO-3166 country code (ex.: BE)
- “co” = the name of the country as a text string (ex.: Belgium)
- “countryCode” = the country code for the user’s language of choice (ex.: 56)
List of ISO 3166 country codes – Wikipedia
- In this script I only changed a couple of fields, as more where not required in this case.
I also just cleared some attributes, without replacing them.
You should be able to edit the code based on this example in case you need to edit more attributes.