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 Hosts. This is done via uploading a properly formatted CSV file containing details about the hosts and which candidates they are assigned to.
File Upload Template (with Header Row): hosts.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):
|
CANDIDATE_UMID |
HOST_UNIQNAME_OR_UMID |
HOST_CELL |
HOST_WORK_PHONE |
HOST_NOTES |
DELETE_RECORD |
|---|---|---|---|---|---|
|
12345678 |
34567890 |
123-456-7890 |
456-789-0123 |
Notes go here |
|
|
56789012 |
ckevans |
(123)456-7890 |
(456)789-0123 |
Notes go here |
|
|
45678901 |
mperiard |
123.456.7890 |
456.789.0123 |
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 hosts can be added to the weekend by either creating and uploading a new list, or adding the new hosts to your previously uploaded CSV file and reuploading.
- When a host 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 host 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 ???.
Field Definitions
|
Name |
Length |
Rule |
Notes |
|---|---|---|---|
|
CANDIDATE_UMID |
8 |
Required |
8 digit UMID/Emplid |
|
HOST_UNIQNAME_OR_UMID |
8 |
Required |
8 digit UMID/Emplid or Uniqname. |
|
HOST_CELL |
14 |
Cell or Work Phone Required |
Format: flexible (hyphens, dots, or spaces are allowed); not required if Work Phone provided. |
|
HOST_WORK_PHONE |
14 |
Cell or Work Phone Required |
Format: flexible (hyphens, dots, or spaces are allowed); not required if Cell Phone provided. |
|
HOST_NOTES |
100 |
Optional |
Approximately 20 words or fewer. |
|
DELETE_RECORD |
6 |
Optional |
Must be used in conjunction with an existing record, identified by ??? |