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 (180 points)

1 Answer

0 votes
by (208k 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

During the creation of a new user I want to be able to select the job title from a drop-down list which populates different values based on which Department is selected. Is there a way to achieve this? Thanks. Dario.

asked Oct 2, 2020 by winstonsmith (40 points)
0 votes
1 answer

We used to run AD Audit and it would provide additional details on what was locking a user's account (workstation name, application, etc...). Is there are way with Adaxes ... on what is locking an account? Or a way to pull historical data on locked accounts?

asked Nov 16, 2020 by pulsifers (20 points)
0 votes
1 answer

I would like users to use Adaxes to add themselves or others to a group, but instead of it just working, it has to go thru an approval process and be approved by the group owner before they are added. Thanks!

asked Jun 30 by RayBilyk (180 points)
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 (60 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, 2020 by rmedeiros (360 points)
2,575 questions
2,317 answers
767,542 users