Start collecting ideas on how to arrange the Shift Calendar.
Three Oracle tables have been created to collect shift taker information.
They are under the glastgen account on the glastp oracle instance. The table names are:
shift_category - contains the category types, currently there are 4 (Flare Advocate, GRB Advocate, CHS, Science Ops).
shifts - contains the time of day a shift starts/stops ( e.g. day 8am-4pm, swing 4pm-midnight, owl midnight to 8am) and the shift_type (owl, day, swing).
shift_signup - contains the shift taker's name, which shifts a person has signed up for, the type of shift and timestamp information.
profile_user * this table already existed and will be used to find the shift taker's user_name, email, etc.
The following is the table's diagram:
For displaying the shifts we can dynamically generate an ICalendar file from the database. A sample ical file is attached to this page. Here is a confluence calendar displaying the iCal file.
- EDIT THE CALENDAR
Customise the different types of events you'd like to manage in this calendar.
#legIndex/#totalLegs - RESTRICT THE CALENDAR
Optionally, restrict who can view or add events to the team calendar.
#legIndex/#totalLegs - SHARE WITH YOUR TEAM
Grab the calendar's URL and email it to your team, or paste it on a page to embed the calendar.
#legIndex/#totalLegs - ADD AN EVENT
The calendar is ready to go! Click any day on the calendar to add an event or use the Add event button.
#legIndex/#totalLegs - SUBSCRIBE
Subscribe to calendars using your favourite calendar client.
#legIndex/#totalLegs