Body
This article will explain how to run the Banner Update SHBDIPL Dates job in Jenkins.
Purpose
The purpose of this job is to update the Shbdipl_Order_Date column and optionally the Shbdipl_Mailed_Date column for specified students in the Shbdipl table. This is done by uploading a CSV (comma separated values) document into Jenkins which is used to which students row to update in the Shbdipl table.
Before you run the job
Before running the job, you'll need a CSV file that contains the list of student C#'s and Shbdipl_Dgmr_Seq_No of the rows to update in Shbdipl. This csv should be created from the Excel file that was generated from Argos and uploaded to the diploma vendor.
- NOTE: while a .csv file can be opened and edited in Excel it may have automatically formatted aspects of the file that may create undesirable results. Opening the file in notepad or a simple editor is preferable.
What the CSV should look like
The CSV needs to look like the below. Pay attention to the header names as the process is case sensitive so the headers must match this example.
Student_ID,Seq_No
C00736744,1
C00725921,1
C00690982,2
C00725287,1
C00747187,1
Running the job
After you have your file all set, in a web browser navigate to http://automation.cortland.edu:8080/.
Note: You must be on campus. Once there, log in using your MyRedDragon credentials (do not put @cortland.edu after your username) and follow these steps:
- Navigate to the job named “Banner Update SHBDIPL Dates”.
- Click on the “Build with Parameters” icon on the left-hand side of the job window.
3. After clicking the Build with Parameters button, you will see this screen:
4. Upload the CSV of students to be updated in Shbdipl by clicking on the “Choose File” button and selecting the file from your computer.
5. Enter the date the diploma order was placed in the Order_Date field. This is a required field for the job to run. Be sure to follow the on screen guide for formatting the date. As an example, June 9, 2026 should be formatted as: 2026-06-09
6. If you also want to update the mailed date, you can enter a date in the Mailed_Date field. This is not a required field. Follow the date formatting guidelines in the step above when using this field.
7. After uploading the CSV, filling out the Order_Date field and optionally the Mailed_Date field, click the green Build button at the bottom to start the process.
After the job runs
Depending on the number of rows in the CSV, the job should take 5 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 check mark 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. Note: If a student record can not be found in the Shbdipl table for that student/sequence number combination, it will get flagged as an error. Any problem processing a student, including if they were not found in Shbdipl, will not stop the process from updating the other students.
Once the process completes, the students that did not have any errors will have their Shbdipl_Order_Date field updated and optionally their Shbdipl_Mailed_Date updated to what was entered at the start of the job. If a wrong date was entered, or to update the Shbdipl_Mailed_Date after running the process to fill in the Shbdipl_Order_Date field, simply run the job again. There is no limit to the number of times this job can be run for an individual CSV. It will update the Shbdipl table for the students in the CSV with whatever dates were entered into the job.
Additional Shbdipl fields updated
When this process updates a row in Shbdipl, it also updates the Shbdipl_Activity_Date column to be the time the row was updated and the Shbdipl_User_Id field to be JENKINS_AUTOMATION. These can be modified/updated by putting in a ticket using the Automation Support button in the upper right.