This article will explain how to run the Library Update Research Help Appointment Request Table job in Jenkins.
Purpose
The purpose of this job is to update the database table that is used to determine which librarian to email regarding research help requests. This is done by uploaded a CSV (comma separated values) document into Jenkins which is used to update the database table.
Before you run the job
Before running the job, you'll need a CSV file that contains the list of departments, classes, or class sections that a librarian has been assigned to for research help. It does not matter the order that you put them in.
- NOTE: while a .csv file can be opened and edited in Excel it may have automatically format aspects of the file that may create undesirable results. For instance, a course section number of 003 might be changed to 3 because "003" and "3" aren't the same it may produce unexpected results. You might consider editing the .csv in a simple text editor like notepad if you encounter this issue.
What the CSV should look like
The CSV needs to look like the below (pay attention to the header names).
Note that an example file is attached to this article:
Subject,CourseNumber,CourseSection,EmailRoute
0000,,,librarian.email@cortland.edu
AAS,,,librarian.email@cortland.edu
ADV,100,101,librarian.email@cortland.edu
AED,200,,librarian.email@cortland.edu
AFS,,,librarian.email@cortland.edu
- NOTE: The row with the subject of "0000" must be included as this is the catch all/default case. Any requests that do not match anything else in the table will be routed to the librarian assigned in this row.
Acceptable Assignment Formats
The following names are the only acceptable names to be used:
- Assigned to all classes in the department
- ABC,,,librarian.email@cortland.edu
- Assigned to a specific class
- ABC,123,,librarian.email@cortland.edu
- Assigned to a specific section of a class
- ABC,123,456,librarian.email@cortland.edu
Uploading the file
After you have your file all set, in a web browser navigate to http://automation.cortland.edu:8080/.
Note: You must be on campus or connected to the campus VPN in order to access that web page. Once there, log in using your MyRedDragon credentials and follow these steps:
- Navigate to the job named “Library Update Research Help Appointment Request Table”.
- Click on the “Build with Parameters” icon on the left-hand side of the job window.
3. Upload the ceremony CSV by clicking on the “Choose File” button and selecting the file from your computer.
4. Click the blue “Build” button to run the job.
The job will run and should take 2 minutes or less to complete. In the Build History for the job (located in the bottom left of the job screen) you will see a green checkmark if the job ran successfully and a red X if it did not.
If there is a failure while running the job (a red X), an e-mail will automatically be sent to the person running the job with a description of what failed.
Once the upload is successful, The table will be set up to route emails to the proper librarian when research help is requested. If a mistake was made, simply update the csv and re-run the job with the new csv file.