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:
- 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?