To help speed the task of data entry, a list of events can be uploaded from a file into 5-Star Students. Supported file types include Microsoft Excel (.xls/.xlsx), text (.txt), or comma-delimited (.csv).
The file must contain two required fields for each event. Additional fields can also be included as needed, but they must follow the formats described below.
If you need to add repeating events, you must include the Repeating Rule column that contains a valid repeating/recurrence rule. The are several rule generators available online to assist with creating valid rules.
A column description, or header row, may be included as the first row in the file. Make sure to indicate this option during the upload process, so the first row will be skipped during processing.
REQUIRED FIELDS
Name: the name of the event. This field is limited to 200 characters
Date: the date of the event. Must be in standard US date format. Any time included in this field will not be used. Use the Start Time field for the time component, if needed
OPTIONAL FIELDS
Start Time: the start time of the event. Must be in standard US date/time format. Any date included in this field will be disregarded
End Time: the ending time of the event. Must be in standard US date/time format. Any date included in this field will be disregarded
Repeating Rule: a valid iCalendar string that defines the recurring event schedule
Category: the category name associated with the event. The name must match to an existing event category in 5-Star Students. If the category name cannot be matched, this field will be skipped
Related Activity: the name of activity associated with the event. This name must match to an existing Activity in 5-Star Students. If the activity name cannot be matched, this field will be skipped
Description: a description of the event. This field is limited to 1,500 characters
Link: an external link that contains more information about the event. This field is limited to 500 characters
Location: a description of the location for the event. This field is limited to 250 characters
Contact: a contact for the event. This field is limited to 200 characters
Contact Email: a contact email address for the event. This field is limited to 200 characters
Contact Phone: a contact phone number for the event. This field is limited to 50 characters
Points: the point value of the event. This field must contain a number greater than or equal to 0
Guest Points: the guest point value of the event. This field must contain a number greater than or equal to 0
Gray Points: the gray point value of the event. This field must contain a number greater than or equal to 0
Gray Guest Points: the gray guest point value of the event. This field must contain a number greater than or equal to 0
Allow Unlimited Check Ins?: an indicator to allow or prevent unlimited check ins for the event. Valid values for this field are "Yes", "No", "Y", "N", "1", "0", "True", "False", "T", or "F". The default value for a new event is No
Include In Metrics?: an indicator to include this event in the calculation of student involvement metrics. Valid values for this field are "Yes", "No", "Y", "N", "1", "0", "True", "False", "T", or "F". The default value for a new event is Yes
Is Private?: an indicator to make this event only visible to authorized 5-Star Students users. Valid values for this field are "Yes", "No", "Y", "N", "1", "0", "True", "False", "T", or "F". The default value for a new event is No
Require Permissions?: an indicator to secure this event and require permissions for access by Operators. Valid values for this field are "Yes", "No", "Y", "N", "1", "0", "True", "False", "T", or "F". The default value for a new event is No
Check In Code: a check in code for creation of an event check in schedule, for use with the Student Mobile App. The code must be numeric and 5 digits or less
QR Code Check In? an indicator for creation an event check in schedule, for use with the Student Mobile App. Valid values for this field are "Yes", "No", "Y", "N", "1", "0", "True", "False", "T", or "F"
Beacon Name: the name of a beacon for creation of an event check in schedule, for use with the Student Mobile App. The name must match to an existing beacon registered to the school, otherwise this scheduling will be skipped
Check In Location Name: the name of a location for creation of an event check in schedule, for use with the Student Mobile App. The name must match to an existing location registered to the school, otherwise this scheduling will be skipped
Check In Start Time: the start date and time of the check in schedule(s) for the event. Must be in standard US date/time format. If this field is not included in the file, the event date and start time will be used if available
Check In End Time: the ending date and time of the check in schedule(s) for the event. Must be in standard US date/time format. If this field is not included in the file, the event date and end time will be used if available
Notification Message: the message to send to Student App users, letting them know event self-check in is available. This field is limited to 500 characters
Notification Send Date: the date/time to send the notification message. Must be in standard US date/time format. This field is required if including a notification message in the file