Interview Weekends - Contacts Upload Template & Instructions


Introduction

In order to build and send out candidate itineraries for a given Interview Weekend, data about various topics must first be uploaded, one of them being Contacts (SSRs). This is done via uploading a properly formatted CSV file containing details about the contacts and which department/interest they are associated with.

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

DEP-INT

UNIQNAME_OR_UMID

PHONE

DELETE_RECORD

CMB

12345678

123-456-7890


Bioinformatics

45678901

123.456.7890


CellBio

sambrow


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 contacts can be added to the weekend by either creating and uploading a new list, or adding the new contacts to your previously uploaded CSV file and reuploading.
  • When a contact is already found in the database, the system will do one of two things:
    • if the ??? are the same, it will skip this row
    • if the ??? are different, it will replace the event with the new values from the file
  • An existing record (identified by ???) 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 record identified by the ???.

Field Definitions

Name

Length

Rule

Notes

DEP-INT

50

Required

Must exactly match the departments/interests entered during Season setup; only necessary for Dep-Int events

UNIQNAME_OR_UMID

8

Required

8 digit UMID/Emplid or Uniqname.

PHONE

14

Optional

Format: flexible (hyphens, dots, or spaces are allowed)

DELETE_RECORD

6

Optional
Type 'delete'

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