- Interview Weekends - Candidate Faculty Choices Upload Template and Instructions

Introduction

While candidates will be selecting their weekend and faculty choices via the Candidate Faculty Choices mini-site, their faculty choices (for a given weekend) can also be set internally via upload (such as in the case where a candidate requests to switch a weekend and all slots are currently filled). This is done via uploading a properly formatted CSV file containing details about which faculty they are interested in.

File Upload Template (with Header Row): candidate-faculty-choices.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 candidate. 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):

CANDIDATE_UMID	FACULTY_1_UNIQNAME_OR_UMID	FACULTY_2_UNIQNAME_OR_UMID	FACULTY_3_UNIQNAME_OR_UMID	FACULTY_4_UNIQNAME_OR_UMID	FACULTY_5_UNIQNAME_OR_UMID	FACULTY_6_UNIQNAME_OR_UMID	FACULTY_7_UNIQNAME_OR_UMID	FACULTY_8_UNIQNAME_OR_UMID	FACULTY_9_UNIQNAME_OR_UMID	FACULTY_10_UNIQNAME_OR_UMID	FACULTY_11_UNIQNAME_OR_UMID	FACULTY_12_UNIQNAME_OR_UMID	DELETE_RECORD
12345678	23456789	13579042	13579042	13579042	13579042	13579042	13579042	13579042	13579042	13579042	13579042	13579042
45678901	13579042	23456789	67890123	23456789	13579042	67890123	98765432	98765432	98765432	98765432	98765432	98765432
34567890	67890123	98765432	98765432	98765432	98765432	98765432	98765432	13579042	23456789	13579042	23456789	67890123	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 candidate-faculty choices can be added to the weekend by either creating and uploading a new list, or adding the new information to your previously uploaded CSV file and reuploading.
When a candidate's choices are already found in the database, the system will do one of two things:
- if the candidate's choices are all the same, it will skip this row
- if any of the candidate's choices are different, it will replace the candidate's choices with the new values from the file
A candidate (identified by candidate UMID) can be removed from the weekend 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 record identified by the candidate's UMID.

Field Definitions

Name	Length	Rule	Notes
CANDIDATE_UMID	8	Required	8 digit UMID.
FACULTY_#_UNIQNAME_OR_UMID (1-12)	8	Optional*	8 digit UMID/Emplid or uniqname. The same faculty member cannot be specified more than once per candidate. (*This is optional only for the scenario when you want to pre-select a weekend for a candidate but still let them choose their faculty.)
DELETE_RECORD	6	Optional Type 'delete'	Must be used in conjunction with a candidate (identified by candidate UMID) who is already associated with this weekend.

Name

Length

Rule

Notes

CANDIDATE_UMID

Required

8 digit UMID.

FACULTY_#_UNIQNAME_OR_UMID

(1-12)

Optional*

8 digit UMID/Emplid or uniqname. The same faculty member cannot be specified more than once per candidate.
(*This is optional only for the scenario when you want to pre-select a weekend for a candidate but still let them choose their faculty.)

DELETE_RECORD

Optional
Type 'delete'

Must be used in conjunction with a candidate (identified by candidate UMID) who is already associated with this weekend.