A script to take information from MYSQL database and CSV file and add to a group
Clash Royale CLAN TAG#URR8PPP
up vote
0
down vote
favorite
Hey I'm super new to bash scripting. My work needs me to do something like this:
Add a list of students to the gsenstudents group, retaining the accounts that are already in the group. The list of students is in an Excel spreadsheet in CSV form, consisting of Studentid, Lastname, and Firstname of each student to be added.
I am required to write a bash script to use a MySQL database to determine the Linux username of each student in the provided CSV file. Add the username of each student with an account to a file called gsenstudents_groupadd.sh.
a. Each line that is added should have the command to add the username to the gsenstudents group.
b. Check to make sure not to add a username that is already in the group.
CSV file contains Student ID, last name and first name as three fields.
MYSQL database contains username, ID, last and first name.
Any help is appreciated.
shell-script mysql csv
asked 3 mins ago
user319135
1
New contributor
user319135 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |Â
up vote
0
down vote
favorite
Hey I'm super new to bash scripting. My work needs me to do something like this:
Add a list of students to the gsenstudents group, retaining the accounts that are already in the group. The list of students is in an Excel spreadsheet in CSV form, consisting of Studentid, Lastname, and Firstname of each student to be added.
I am required to write a bash script to use a MySQL database to determine the Linux username of each student in the provided CSV file. Add the username of each student with an account to a file called gsenstudents_groupadd.sh.
a. Each line that is added should have the command to add the username to the gsenstudents group.
b. Check to make sure not to add a username that is already in the group.
CSV file contains Student ID, last name and first name as three fields.
MYSQL database contains username, ID, last and first name.
Any help is appreciated.
shell-script mysql csv
asked 3 mins ago
user319135
1
New contributor
user319135 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |Â
up vote
0
down vote
favorite
up vote
0
down vote
favorite
Hey I'm super new to bash scripting. My work needs me to do something like this:
Add a list of students to the gsenstudents group, retaining the accounts that are already in the group. The list of students is in an Excel spreadsheet in CSV form, consisting of Studentid, Lastname, and Firstname of each student to be added.
I am required to write a bash script to use a MySQL database to determine the Linux username of each student in the provided CSV file. Add the username of each student with an account to a file called gsenstudents_groupadd.sh.
a. Each line that is added should have the command to add the username to the gsenstudents group.
b. Check to make sure not to add a username that is already in the group.
CSV file contains Student ID, last name and first name as three fields.
MYSQL database contains username, ID, last and first name.
Any help is appreciated.
shell-script mysql csv
asked 3 mins ago
user319135
1
New contributor
user319135 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Hey I'm super new to bash scripting. My work needs me to do something like this:
Add a list of students to the gsenstudents group, retaining the accounts that are already in the group. The list of students is in an Excel spreadsheet in CSV form, consisting of Studentid, Lastname, and Firstname of each student to be added.
I am required to write a bash script to use a MySQL database to determine the Linux username of each student in the provided CSV file. Add the username of each student with an account to a file called gsenstudents_groupadd.sh.
a. Each line that is added should have the command to add the username to the gsenstudents group.
b. Check to make sure not to add a username that is already in the group.
CSV file contains Student ID, last name and first name as three fields.
MYSQL database contains username, ID, last and first name.
Any help is appreciated.
shell-script mysql csv
shell-script mysql csv
asked 3 mins ago
user319135
1
New contributor
user319135 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 3 mins ago
user319135
1
New contributor
user319135 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 3 mins ago
user319135
1
New contributor
user319135 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 3 mins ago
user319135
1
asked 3 mins ago
user319135
1
1
New contributor
user319135 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
user319135 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
user319135 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |Â
add a comment |Â
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
user319135 is a new contributor. Be nice, and check out our Code of Conduct.
user319135 is a new contributor. Be nice, and check out our Code of Conduct.
user319135 is a new contributor. Be nice, and check out our Code of Conduct.
user319135 is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f479513%2fa-script-to-take-information-from-mysql-database-and-csv-file-and-add-to-a-group%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password