0 votes

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 file will contain the following fields: companyID,employeeID,givenName,sn,initials,cnx,mail,telephoneNumber,company,department,title,physicalDeliveryOfficeName,HRSystem,EmailAddressneeded,EmployeeStatus,TerminationDate,HireDate,Username

  • The Email_Address_Needed field has the possible values Y or N.
  • If there is a value in the Termination_Date field, that is when the user is to be terminated. (Right now, we have a great Custom Command to do all of that, but it's a manual process to identify the user right now.)
  • If any data is in there, it should be updated/modified (name change, email address change, company change, etc.)

Is there a script that can manage all of that on a scheduled basis?

by (680 points)

1 Answer

0 votes
by (185k points)

Hello Ray,

Have a look at the following script from our repository: https://www.adaxes.com/script-repository/import-new-and-updated-users-from-csv-file-s246.htm. Should you have issues updating the script to meet your needs, please, send us (support[at]adaxes.com) a sample CSV file for import and a detailed description for each of the possible scenarios with live examples.

Related questions

0 votes
1 answer

is it possible to allow a user to enroll for both options, or even only one option out of the two available? I would like to give my users the choice to use either. Some users may not want an authenticator, but other's might do.

asked Nov 6, 2019 by mashworth (290 points)
0 votes
0 answers

I noticed that other identity management solutions have a way for new user to claim their account. This would be helpful so we can help all of our new students (who do not ... ) claim their account and reduce the burden on our help desk. Thanks for your help.

asked Aug 29 by rmedeiros (1.8k points)
0 votes
1 answer

Our Help Desk currently 'mirrors' the group membership of a new user based on another existing user in our AD. I'd like to be able to automate this so that the initiator ... and 'paste' it on the new user being created. Any help on this would be appreciated!

asked Apr 21 by RayBilyk (680 points)
0 votes
1 answer

I'm trying to schedule a report to look in a few specific OUs. Currently "Look in" location only allows for single instance or multiple drop downs. How do I schedule multiple OU locations without creating multiple reports?

asked Jul 2 by Al (250 points)
0 votes
0 answers

We have users with group memberships in multiple domain. All groups are type Universal. For example we have DOMAIN A and child domains for each dept, such as ... group memberships during user account copy, including memberships from other domains? Thank you,

asked Sep 10 by maliguinem (250 points)
2,294 questions
2,050 answers
5,586 comments
58,858 users