Generates commands from a given CSV file to create users in Active Directory via the command New-ADUser. Users can map CSV headers to given parameters.
Run this command using clang++, g++ or any other C++ compiler, with the current directory set to src:
clang++ *.cpp -c
clang++ *.o -o my_program
This will generate an executable file named my_program, that you can run.
Create a file that holds CSV header to parameter mappings, or commands regarding what values to put into specific parameters.
Two fields separated by a semicolon, first field is the CSV header field, second is the parameter to map.
For example, mapping the field First name to the -GivenName parameter:
First name;-GivenName
You can not map multiple fields to the same parameter, however you can map the same field to multiple parameters.
There can be unmapped fields and unmapped parameters.
First field contains a command and a value, the second field specifies the parameter to forward that value.
$OVERRIDE$ overrides all mappings to a parameter with a given value.
$FALLBACK$ gives the given value to the specified parameter, for which each row has an empty value, or if there is no mapping for the parameter.
Example for giving a description for all generated users:
$OVERRIDE$User generated by script;-Description
Example for giving a fallback password for users that have empty fields for their passwords, or if the mapfile has no binding for -AccountPassword:
$FALLBACK$Passw0rd;-AccountPassword
It is an error to not give a value after a command.
An $OVERRIDE$ is stronger than a $FALLBACK$.
Commented-out rows are not processed. The character to start a commentline is #.
Example for a commented-out row:
# This row won't be processed
#username;-Name this won't either
The program takes three mandatory command-line arguments: the input CSV file, a mapping file and an output file:
./my_program csvfile mapfile outfile
The first argument (after the program name) is the CSV file passed by filename. This file needs to have a valid header, containing header information for all subsequent rows.
This file must exist, or the program will fail to run.
The second argument is the mapping file, which contains mappings from CSV header fields to parameters.
This file must exist, or the program will fail to run.
The third argument is the output file, which all the commands will be printed into.
This file will be overwritten without warning if it exists, if it doesn't exist it will be created.
You must not mix the file order up.
./my_program names.csv mappings.txt output.txt
Generates random passwords containing lowercase, uppercase and numeric characters of size 12 for each user, bypassing any mapping and overrides for -AccountPassword.
Ignores rows in the mapfile having $OVERRIDE$ in their first field. Output in the outfile won't have any overridden values.
Ignores rows in the mapfile having $FALLBACK$ in their first field. Output in the outfile won't have any values for empty fields or unmapped parameters.
Generating commands with randomized passwords:
./my_program list.csv map.txt out.txt --randomized_passwords
Equivalent invocation:
./my_program list.csv map.txt out.txt -r
Mixing multiple arguments:
./my_program users.csv rules.txt out.txt -o -f -r
Parameters taking Strings have their arguments inside two quotation marks:
New-ADUser -Name "John Doe"
Parameters taking SecureStrings have their arguments placed into a ConvertTo-SecureString function:
New-ADUser -AccountPassword (ConvertTo-SecureString "Passw0rd" -AsPlainText -Force)
Parameters taking Booleans have a check if the string value contains either $true, $false, 0 or 1, if the check passes, numeric values are converted into the variable form, else it throws an error:
New-ADUser -Enabled $true
Parameters that take other types of arguments do no formatting and warn the user on the standard output with the affected typename. Other typenames are yet to be implemented:
warning: default formatting of arguments for parameters taking DateTime