Return to Slot_CommaDelimited.tex CVS log

Up to [LON-CAPA] / loncom / html / adm / help / tex

Annotation of loncom/html/adm/help/tex/Slot_CommaDelimited.tex, revision 1.3

1.1       rezaferr    1: 	 \label{Slot_CommaDelimited}
                      2: 	 
1.2       raeburn     3: 	 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.
1.1       rezaferr    4: 	 
1.2       raeburn     5: 	 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.
                      6: 
                      7: Once uploaded, you will be prompted to identify the contents of each column in your CSV data. The following fields are supported:
                      8: \begin{itemize}
                      9: \item Slot name
                     10: \item Type of slot
                     11: \item Start Time of slot
                     12: \item End Time of slot
                     13: \item Reservation Start Time
                     14: \item Reservation End Time
                     15: \item Message when reservation changed
                     16: \item IP or DNS restriction
                     17: \item Unique IP each student
                     18: \item List of proctor ids
                     19: \item Slot Description
                     20: \item Maximum number of reservations
                     21: \item Resource(s)/Map(s) Restriction
                     22: \item Date range of slot exclusion
                     23: \item Secret word proctor uses to validate
                     24: \item Sections slot is restricted to
                     25: \item Users slot is restricted to
                     26: \end{itemize}
                     27: 
                     28: The following fields: ``Slot name'', ``Type of slot'', ``Start Time of slot'' and ``End Time of slot'' are required.
                     29: 
                     30: A Slot name may only contain letters, numbers and underscores.
                     31: The Type of slot must be either preassigned or schedulable\_student.
                     32: The four Time fields:  Start Time, End Time, Reservation Start Time, Reservation End Time permit a variety of formats.
1.3     ! raeburn    33: For example, the following formats are permitted: `YYYYMMDDHHMMSS'' and ``MM/DD/YYYY HH:MM:SS''