Script for this exercise

• Open a text editor
  You can use the editor built into IDLE or use a program like Sublime.
• Copy the text below into the file

• Save the file as ex16.py
  
• Copy the file umb.db from /home/ghoffman/course_files/it117_files
  Use FileZilla to do this.
• Run this script in IDLE
  Open the script file in IDLE. Under the Run menu, select Run Module.
• You should see something like
  

  ('09329034', 'Jane', 'Adams', 'Jane.Adams001@umb.edu', 'jadams', 'CSM')
  ('03687480', 'Alexander', 'Smith', 'Alexander.Smith001@umb.edu', 'bigboy', 'CM')
  ('05431692', 'Christopher', 'Cannon', 'Christopher.Cannon001@umb.edu', 'ccannon', 'CSM')
  ('07511379', 'Joseph', 'Malloney', 'Joseph.Malloney001@umb.edu', 'jmal', 'CSM')
  ('07518979', 'Fatih', 'Jones', 'Fatih.Jones001@umb.edu', 'fjones', 'CM')
  ('04175276', 'James', 'Reynolds', 'James.Reynolds001@umb.edu', 'jr', 'CSM')
  ('04686471', 'Joe', 'Riley', 'Joe.Reily003@umb.edu', 'reily', 'CM')
  (1, 'it116', 1, 's17', '05431692')
  (2, 'it116', 1, 's17', '09329034')
  (3, 'it116', 1, 's17', '07518979')
  (4, 'it244', 1, 's17', '07511379')
  (5, 'it244', 1, 's17', '09329034')
  (6, 'it244', 1, 's17', '04175276')
  (7, 'it116', 1, 'sum17', '03687480')
  (8, 'it116', 1, 'sum17', '07511379')
  (9, 'it116', 1, 'sum17', '07518979')
  (10, 'it117', 1, 'f17', '07518979')
  (11, 'it117', 1, 'f17', '05431692')
  (12, 'it117', 1, 'f17', '09329034')
  (13, 'it244', 1, 'f17', '04686471')

Copy the file to Unix

• Open FileZilla and connect to pe15.cs.umb.edu
  You will have to connect using your Unix username and password.
• Go to your 117 directory
• Go to your ex directory
• Inside this directory create the directory ex16
  Right-click in the whitespace inside the ex directory.
  Click and drag down to Create directory.
  Add ex16 to the path in the dialog box.
  Click OK.
• Copy your ex16.py
  Click and drag the script from your machine to the ex16 directory.
• Make your script executable
  Right-click on the file and select "Permissions" from the menu.
  Enter 755 in the box provided.
  Click OK.
  This will make the script executable.
• Copy umb.db to pe15
  Click and drag the file from your machine to the ex16 directory

Running my test script on your script

• If you want to run my text script on your Class Exercise script do the following
• Connect to pe15.cs.umb.edu
  Use an ssh client.
• Run my test code on your script
  

  ~ghoffman/it117_test/ex16.sh

  The script will prompt you for your Unix username.