Is there a way to create new users, modify existing users or terminate users based on a scheduled CSV file received?

Question

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?

Answer 1

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.