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

1 Answer

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

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)
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, 2020 by RayBilyk (120 points)
2,490 questions
2,237 answers
6,010 comments
392,284 users