Interview Weekends - Faculty Upload (Season) Template and Instructions


Introduction

To set up an Interview Weekend season, faculty members must be added. This is done via uploading a properly formatted CSV file containing basic faculty details.

File Upload Template (with Header Row): FacultyUploadTemplate.csv

NOTE: The uploaded file needs to follow a very specific format (as specified below). It is required that there be a header row. Each row after will be assumed to contain all the necessary information for each faculty member. Once uploaded, the file will be checked for compliance to this format; if any errors are found, the entire upload is cancelled -- the errors must be corrected in the CSV file, and the file re-uploaded. Once there are no errors, the file will be accepted by the system and its contents recorded in the database.

Instructions

Required Format (with examples):

FACULTY_UNIQNAME_OR_UMID

DEP-INT
DEP-INT-2
DEP-INT-3
DEP-INT-4
DEP-INT-5

DELETE_RECORD

12345678

BIOI

 BIOP HG MICRO


johndoe

BIOP

 MICRO


delete

Notes about uploading, changing, and deleting:

  • Uploads can contain as many or as few rows as desired; once uploaded, the information will stay in the database (i.e. the CSV file you uploaded does not need to be preserved).
  • More faculty members can be added to the same season by either creating and uploading a new list, or adding the new faculty members to your previously uploaded CSV file and reuploading.
  • When a given faculty member is already found in the database, the system will overwrite their current department/interests with the newly specified department/interests.
  • An existing record (identified by the Faculty UMID or uniqname) can be deleted by typing 'delete' in the Delete_Record column for that row in your spreadsheet and uploading the file.
    • If you do not have an existing CSV file with the record you want to delete, you must first recreate the file with the faculty member and department/interest.

Field Definitions

Name

Length

Rule

Notes

FACULTY_UNIQNAME_OR_UMID

8

Required
8 digit UMID/Emplid or uniqname


DEP-INT

10

Required (No restrictions)

Must exactly match the departments/interests (SHORT FORM) entered during Season setup.
The first department/interest entered will be considered the 'primary' one for this faculty member.
DEP-INT-2 10 Optional (same as above)
DEP-INT-3 10 Optional (same as above)
DEP-INT-4 10 Optional (same as above)
DEP-INT-5 10 Optional (same as above)

DELETE_RECORD

6

Optional Type 'delete'

Must be used in conjunction with an existing record, identified by FACULTY_UNIQNAME_OR_UMID