CentOS creating users from CSV file script

Question

I want to write a script in CentOs 7 that creates a new user for every CSV file row.

My csv file looks like this:

username;firstname;lastname;password
username2;firstname2;lastname2;
...
...

First column is the username, second is the first name, third is the last name and last column stands for password. If there isn't a password, it creates a user with some default value.

My code:

#!/bin/bash 

export IFS=";" 

cat users.csv | while read username name surname password; do 
    useradd "$username" -c "${name} ${surname}" -p "$password"
done

How do I create users from each column?

Try something first, show some effort. For starters, read about read and while commands and how to read files with them. — PesaThe
– PesaThe, Commented Jan 13, 2018 at 17:28
#!/bin/bash export IFS=";" cat users.csv | while read username name surname password; do useradd "$username" -c "${name} ${surname}" -p "$password" ; done — hrii00
– hrii00, Commented Jan 13, 2018 at 17:32
it just creates users but I don't know how to set null columns into something else — hrii00
– hrii00, Commented Jan 13, 2018 at 17:33

Konstantin Vustin · Accepted Answer · 2018-01-17 05:21:45Z

1

Try this:

$ su - newuser
No passwd entry for user 'newuser' 

$ IFS=";" && echo "newuser;New;User;testpass" | while read username name surname password; do sudo useradd "$username" -c "${name} ${surname}" -p `openssl passwd -1 $password` -m; done

$ su - newuser
Password: 
newuser@my-desktop:~$ logout

$ cat /etc/passwd | grep newuser
newuser:x:1002:1002:New User:/home/newuser:

answered Jan 17, 2018 at 5:21

Konstantin Vustin

7,9382 gold badges21 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

CentOS creating users from CSV file script

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related