A script to determine username from MYSQL database of students provided in the CSV file and add those usernames to a new file
Clash Royale CLAN TAG#URR8PPP
up vote
-2
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 1 hour ago
Srys96
11
New contributor
Srys96 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
-2
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 1 hour ago
Srys96
11
New contributor
Srys96 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
To be answerable, many more details are needed. Imagine someone on the other end of your question and trying to answer it.
– Jeff Schaller
46 mins ago
Hello Jeff. What more details do you need?
– Srys96
43 mins ago
All of them. An Excel spreadsheet in CSV form is confusing; do you have a CSV file on a Unix system, ready to go, or do you need to transfer it? What is its filename and structure? What database are you connecting to, and do you have its credentials? What is the database structure? Do you know what SQL query you'll use, or do you need help with that? Do you know the Linux command to add a user to a group? Do you know how to check the members of a group?
– Jeff Schaller
38 mins ago
Yes I do have the CSV file and its called miniproject.csv. I'm connecting to to a database called tele5600 and have the credentials. I do not know the rest of the things you mentioned.
– Srys96
30 mins ago
You should edit in any clarifying details to your post. Without these details, I'm not sure how your question can be answered.
– Jeff Schaller
27 mins ago
add a comment |Â
up vote
-2
down vote
favorite
up vote
-2
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 1 hour ago
Srys96
11
New contributor
Srys96 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 1 hour ago
Srys96
11
New contributor
Srys96 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 1 hour ago
Srys96
11
New contributor
Srys96 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 20 mins ago
asked 1 hour ago
Srys96
11
New contributor
Srys96 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 1 hour ago
Srys96
11
asked 1 hour ago
Srys96
11
11
New contributor
Srys96 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Srys96 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Srys96 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
To be answerable, many more details are needed. Imagine someone on the other end of your question and trying to answer it.
– Jeff Schaller
46 mins ago
Hello Jeff. What more details do you need?
– Srys96
43 mins ago
All of them. An Excel spreadsheet in CSV form is confusing; do you have a CSV file on a Unix system, ready to go, or do you need to transfer it? What is its filename and structure? What database are you connecting to, and do you have its credentials? What is the database structure? Do you know what SQL query you'll use, or do you need help with that? Do you know the Linux command to add a user to a group? Do you know how to check the members of a group?
– Jeff Schaller
38 mins ago
Yes I do have the CSV file and its called miniproject.csv. I'm connecting to to a database called tele5600 and have the credentials. I do not know the rest of the things you mentioned.
– Srys96
30 mins ago
You should edit in any clarifying details to your post. Without these details, I'm not sure how your question can be answered.
– Jeff Schaller
27 mins ago
add a comment |Â
To be answerable, many more details are needed. Imagine someone on the other end of your question and trying to answer it.
– Jeff Schaller
46 mins ago
Hello Jeff. What more details do you need?
– Srys96
43 mins ago
All of them. An Excel spreadsheet in CSV form is confusing; do you have a CSV file on a Unix system, ready to go, or do you need to transfer it? What is its filename and structure? What database are you connecting to, and do you have its credentials? What is the database structure? Do you know what SQL query you'll use, or do you need help with that? Do you know the Linux command to add a user to a group? Do you know how to check the members of a group?
– Jeff Schaller
38 mins ago
Yes I do have the CSV file and its called miniproject.csv. I'm connecting to to a database called tele5600 and have the credentials. I do not know the rest of the things you mentioned.
– Srys96
30 mins ago
You should edit in any clarifying details to your post. Without these details, I'm not sure how your question can be answered.
– Jeff Schaller
27 mins ago
To be answerable, many more details are needed. Imagine someone on the other end of your question and trying to answer it.
– Jeff Schaller
46 mins ago
To be answerable, many more details are needed. Imagine someone on the other end of your question and trying to answer it.
– Jeff Schaller
46 mins ago
Hello Jeff. What more details do you need?
– Srys96
43 mins ago
Hello Jeff. What more details do you need?
– Srys96
43 mins ago
All of them. An Excel spreadsheet in CSV form is confusing; do you have a CSV file on a Unix system, ready to go, or do you need to transfer it? What is its filename and structure? What database are you connecting to, and do you have its credentials? What is the database structure? Do you know what SQL query you'll use, or do you need help with that? Do you know the Linux command to add a user to a group? Do you know how to check the members of a group?
– Jeff Schaller
38 mins ago
All of them. An Excel spreadsheet in CSV form is confusing; do you have a CSV file on a Unix system, ready to go, or do you need to transfer it? What is its filename and structure? What database are you connecting to, and do you have its credentials? What is the database structure? Do you know what SQL query you'll use, or do you need help with that? Do you know the Linux command to add a user to a group? Do you know how to check the members of a group?
– Jeff Schaller
38 mins ago
Yes I do have the CSV file and its called miniproject.csv. I'm connecting to to a database called tele5600 and have the credentials. I do not know the rest of the things you mentioned.
– Srys96
30 mins ago
Yes I do have the CSV file and its called miniproject.csv. I'm connecting to to a database called tele5600 and have the credentials. I do not know the rest of the things you mentioned.
– Srys96
30 mins ago
You should edit in any clarifying details to your post. Without these details, I'm not sure how your question can be answered.
– Jeff Schaller
27 mins ago
You should edit in any clarifying details to your post. Without these details, I'm not sure how your question can be answered.
– Jeff Schaller
27 mins ago
add a comment |Â
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Srys96 is a new contributor. Be nice, and check out our Code of Conduct.
Srys96 is a new contributor. Be nice, and check out our Code of Conduct.
Srys96 is a new contributor. Be nice, and check out our Code of Conduct.
Srys96 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-determine-username-from-mysql-database-of-students-provided-in-the-c%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
To be answerable, many more details are needed. Imagine someone on the other end of your question and trying to answer it.
– Jeff Schaller
46 mins ago
Hello Jeff. What more details do you need?
– Srys96
43 mins ago
All of them. An Excel spreadsheet in CSV form is confusing; do you have a CSV file on a Unix system, ready to go, or do you need to transfer it? What is its filename and structure? What database are you connecting to, and do you have its credentials? What is the database structure? Do you know what SQL query you'll use, or do you need help with that? Do you know the Linux command to add a user to a group? Do you know how to check the members of a group?
– Jeff Schaller
38 mins ago
Yes I do have the CSV file and its called miniproject.csv. I'm connecting to to a database called tele5600 and have the credentials. I do not know the rest of the things you mentioned.
– Srys96
30 mins ago
You should edit in any clarifying details to your post. Without these details, I'm not sure how your question can be answered.
– Jeff Schaller
27 mins ago