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

1 Answer

0 votes
by (251k 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 have a web portal set up specifically for password self service and I would like to include links to our security policies as well as list the password requirements and our support ... Is there a way to include links and/or plain text as a card or something?

asked May 10 by DA-symplr (80 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, 2021 by RayBilyk (220 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 (80 points)
3,077 questions
2,790 answers
7,162 comments
437,153 users