raeburn raeburn at source.lon-capa.org
Sat Aug 20 15:26:08 EDT 2016

raeburn		Sat Aug 20 19:26:08 2016 EDT

Modified files:
Log:
- Document fields supported in CSV upload of slot definitions.

@@ -1,5 +1,33 @@

-	 Another way of entering slot is by uploading a comma delimited file. A comma delimited file is a text file that separates each field with a comma. An easy way to create comma delimited files is to use a spreadsheet application such as Microsoft Excel, and save the file as a comma separated value (CSV) file.
+	 Another way of entering slot information is by uploading a comma separated (CSV) file. An easy way to create this type of file is to use a spreadsheet application such as Microsoft Excel, and save the file as a comma separated value (CSV) file.

-	 To upload a file press the \textbf{Upload Slot List} button on top of the page. On the first page, select the file with the slot data to upload by pressing the \textbf{Browse button}. There is an option to ignore the first line. This is useful when the first line of your comma delimited file consists of headers for each field. You can also upload space and tab delimited file by changing the type combo box. Press \textbf{Upload} to upload the file
+	 To upload a file press the \textbf{Upload Slot List} button on top of the page. On the first page, select the file with the slot data to upload by pressing the \textbf{Browse button}. There is an option to ignore the first line. This is useful when the first line of your comma delimited file consists of headers for each field. You can also upload space and tab delimited file by changing the type combo box. Press \textbf{Upload} to upload the file.
+
+Once uploaded, you will be prompted to identify the contents of each column in your CSV data. The following fields are supported:
+\begin{itemize}
+\item Slot name
+\item Type of slot
+\item Start Time of slot
+\item End Time of slot
+\item Reservation Start Time
+\item Reservation End Time
+\item Message when reservation changed
+\item IP or DNS restriction
+\item Unique IP each student
+\item List of proctor ids
+\item Slot Description
+\item Maximum number of reservations
+\item Resource(s)/Map(s) Restriction
+\item Date range of slot exclusion
+\item Secret word proctor uses to validate
+\item Sections slot is restricted to
+\item Users slot is restricted to
+\end{itemize}
+
+The following fields: Slot name'', Type of slot'', Start Time of slot'' and End Time of slot'' are required.
+
+A Slot name may only contain letters, numbers and underscores.
+The Type of slot must be either preassigned or schedulable\_student.
+The four Time fields:  Start Time, End Time, Reservation Start Time, Reservation End Time permit a variety of formats.
+For example, the following formats are permitted: YYYYMMDDHHMNSS'' and MM/DD/YYYY HH:MM:SS''

`