0 votes

We are looking for a Way to automate the updating of users' attributes based off CSV extract from Human Resources.

by (3.2k points)

1 Answer

0 votes
by (270k points)
selected by
Best answer

Hello,

Have a look at the following script in our repository: http://www.adaxes.com/script-repository ... e-s246.htm.

0

Willy-Wally,

I would also be interested in something like this. I would need something that reads a CSV that would contain information like Employee Number, First Name, Last Name, Phone Number, Office Number, Address, etc and then go into AD and update those fields. I don't think the script support referenced would do the trick.

0

Hello Ben,

The script updates all the user account properties from the CSV file. It totally meets your requirements.

0

Hello Ben,

The script we referenced will work correctly only if the CSV file contains user sAMAccountName property. If you need to update users from a CSV that does not contain the property you will need to use another script.

Also the script will not work if the column headers contain properties Display Names (e.g. First Name), they should contain properties LDAP names (e.g. givenName).

If you need a script that will work around these requirements, could you provide us with all the information about the CSV file you will use for updating users?

For more information about importing user accounts from CSV files, check the following tutorial: http://www.adaxes.com/tutorials_ActiveD ... SVFile.htm.

0

Oops... I replied to the wrong thread.

Related questions

0 votes
1 answer

We are working with an HR package that will send us a CSV file every 4 hours with a list of users that need to be created, modified or deleted from our environment. The CSV ... change, etc.) Is there a script that can manage all of that on a scheduled basis?

asked Sep 2, 2020 by RayBilyk (230 points)
0 votes
1 answer

hello i'm new with Adaxes i'm try to creat schuadle task to import a spefice user list by thier username id after that just update City for them by bulk updating . kinly advise

asked Aug 29, 2023 by sudox (20 points)
0 votes
1 answer

I have created a template user account for each job role in my company. I copy these users to create users so that all new users are assigned all required groups. I want to ... want to then add or remove all users with a matching job role from the same group.

asked Apr 11, 2023 by scohen (20 points)
0 votes
1 answer

Hallo Everyone I'm attempting to import a CSV list to Update Current users. I Used the Script 2 from Repostitory https://www.adaxes.com/script-repository/ ... "employeeNumber") # TODO: modify me Test file: sAMAccountName,employeeNumber, Peter.Muster,AB052

asked Jul 13, 2021 by Sandberg94 (340 points)
0 votes
1 answer

Thanks for the info. I'm now grabbing the %adm-ManagerUserName% value, but need to remove the final 21 characters of it so it contains only their username and not our ... this in the PowerShell Script Editor for my business rule, I get the following error:

asked Mar 11, 2021 by mkvidera (60 points)
3,326 questions
3,026 answers
7,727 comments
544,681 users