Interview Weekends - Candidate Upload (Season) Template and Instructions


Introduction

To set up an Interview Weekend season, candidates who have been invited to the season must be added. This is done via uploading a properly formatted CSV file containing basic candidate details.

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

DEP-INT
CANDIDATE_PHONE
CANDIDATE_EMAIL
CANDIDATE_XACTID

DELETE_RECORD

12345678

Bioinformatics
name@email.com C83734239235


87654321

Biophysics

 123-456-7890
C14135236255

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 candidates can be added to the same season by either creating and uploading a new list, or adding the new candidates to your previously uploaded CSV file and reuploading.
  • When a given candidate's UMID is already found in the database, the system will do one of two things:
    • if the department/interest is the same, it will skip this row
    • if the department/interest is different, it will replace the candidate's department/interest with the new file's value
  • An existing record (identified by the Candidate UMID) 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 candidate's UMID and department/interest.

Field Definitions

Name

Length

Rule

Notes

CANDIDATE_UMID

8

Required
8 digit UMID/Emplid


DEP-INT

50

Required
(No restrictions)

Must exactly match the departments/interests entered during Season setup.
CANDIDATE_PHONE 14 Optional

Format: flexible (hyphens, dots, or spaces are allowed); expecting this will be manually exported from CollegeNet Admit.
CANDIDATE_EMAIL 50 Optional

Expecting this will be manually exported from CollegeNET Admit.
CANDIDATE_XACTID 20 Required CollegeNET Admit "XACTID" for this candidate.

DELETE_RECORD

6

Optional
Type 'delete'