Camp Clock

Release History, older versions known as Camp Scheduler

5/17/2024

• Added Slack integration
• Added cutoff date for automatic camper scheduling to ignore events prior to cutoff
• Changed format of saved connection files, old ones no longer work

3/7/2024

• Camper list in Event screen can be copied to clipboard via right click
• Event Type has new separate name to appear on Bunk schedules
• Added to Activities:
  • additional name to print on schedules
  • new option for MaxCampers - hard limit, if over will be an error (use this for equipment or safety limits
• Camper Schedule Issues report runs faster
• Camper barcodes work differently - Prepare Signup screen shows missing or duplicates
• Menus: Database renamed to Supporting Data

7/29/2023

• Select All Activities only selects those with Select with All option set
• Department restriction on users are enforced
• Added scheduling grid sets, can add tabs by Event Type and Department

6/1/2023

• New Report: Department Activity Summary

5/27/2023 Bug Fixes:

• Fixed problem in Batch Events screen where changed or copied event ends up on the wrong day
• In Database Connection screen, importing a connection no longer overwrites the current connection
• Enabled drag and drop for tabs on MacOS
• Fixed problem where a dropped tab might disappear

5/21/2023

• Events and Batch Events screens allow typing in dropdowns
• Added navigation buttons between various screens under Database menu

5/2/2023

• Open Activity tabs by event type
• Grid right-click menu has Paste & Continue
• New report for staff: Department Mix: for staff in multiple departments, shows how many activities in each department
• New Edit Activity button on main screen

4/3/2023

Functional change:
New Maximum Bunks option for each Activity. This will likely need to be adjusted for several activities. For example, Basketball probably should be set to 2. Existing error reports will show any problems. Make the change in the Activities screen. No need to change bunk schedules unless you have too many bunks in the activity. Note this evaluates each event individually, you can have bunks split into multiple events if the Location allows it.

Other changes:

• Improved security for saved passwords
• Option to restore open grids next time the program runs

2/3/2023

• Set Days screen added previous and today buttons
• Event screen, Staff tab, shows regular and alternate skills
• All events on location is default
• Select camper event shows available events in bold
• Option to schedule unqualified camper
• Import staff & camper names doesn't overwrite name if duplicate
• Removed maximum number of tabs, and tabs no longer "time out" and get reused
• Tabs can be moved with drag/drop; right-click menu and close button on each tab
• Added to Special: show unused activity locations
• Allow non binary gender for camper and staff names import
• Staff Skills import
• Cancel button on login screen offers useful options
• Errors tab is displayed if any errors, switches back to event detail automatically

4/29/2022 5.5.00

• Windows version upgraded to 64 bits, requires Windows 64 bit system
• Scheduling grid: new option to show all Events in Department
• Multiple Events screen: added Show Activity button
• Updated Time Off Plans to use day of camp in place of week/day
• Bug fixes in several reports
• Linux specific fixes, tested with Linux Mint
• Support for newer versions of MySQL database

5/19/2021 5.4.09 Update:

• Report Viewer allows selection of days
• Bug fixes in Date Picker and Report Viewer

1/29/2021 5.4.08 Update:

• Support for MacOS Big Sur
• Support for Mac M1 systems

5/12/2020 5.4.07 Update:

• Grid tabs upgraded: right click a tab to move or close it
• Grids menu removed, all functions available by right-clicking individual tabs
• Live search: right click a grid tab and enable Search to highlight matching events
• Select campers for an event who requested the activity but haven't gotten in
• Reports showing how camper requests were filled
• Enhancements and fixes to Find Time for Bunk/Cabin schedules

4/10/2020 5.4.06 Update:

• Added custom rules
• Remember automatic refresh settings
• Bug fixes

4/3/2020 5.4.05 Update:

• Set Days custom buttons can have custom labels
• Date picker opens faster
• Bug fixes

3/23/2020 5.4.04 Update:

• Added Camper Requests screen to show all requests for a camper. Button on main screen to show it. Also when selecting a camper in the Schedule Campers screen.
• Bug fixes

3/17/2020 5.4.03 Update:

• Schedule Campers screen, Phase 2 (manual selection):
  • When clicking on a camper, show choice number (1,2,3,etc) to list of scheduled activities
  • Added "Select Top" button
• Events with boys and girls, specify minimum number of each gender. Can apply to event type or activity.
• New screen for entering camper authorization (or permission) for an activity
• Added Signups tab in Activity screen containing information to display in the Signup App
• Signup App - show ? on button to show additional information

3/4/2020 5.4.02 Update:

• Additional work on reports to support specified days.
• Bug fixes

2/10/2020 5.4.01 Update:

• Functional Changes:
• Camp sessions have previously always been defined by weeks, such as session 1 is weeks 1 and 2. This is changing to allow definition by date, which allows a session to run an arbitrary number of days. The "Week - Day - Period" definition for an event changes to "Date - Period." But both definitions can work simultaneously. Deep inside, the date is actually stored as day-of-camp, allowing the events to transfer to subsequent summers the same way they do now.
• The screen for automatic camper scheduling has been reviewed and updated. It looks pretty much the same, but works better. And you can make adjustments to the scoring method when manually selecting campers.
• The current day is highlighted in the schedule grid.
• Other Changes:
• Schedule grid will update faster - most noticable when using a remote database.
• Updated install and update processes on Windows and Mac.
• Lots of bug fixes.

7/14/2019 5.3.021 Update:

• Additional options for Events report
• New: full page placards with camper names
• Select staff or campers by arrival and/or departure dates
• Camper errors includes continued events where not all campers are in each event

6/30/2019 5.3.020 Update:

• Batch Events allows selection by presense of lack of bunks, staff or campers
• Camper error report includes detection of different campers on connected events
• Added optional startup screen CheckIn

6/21/2019 5.3.019 Update:

• Autogroup now ignores Areas
• Bug fixes with importing campers
• Support for Signups app
• Option to open Camp Scheduler in Check In screen
• New report showing campers with incomplete signups

6/5/2019 5.3.018 Update:

• Prepare Signups screen:
• List accepts multiple selections
• New report shows all Camper Requests
• Bug fixes including Autogroup All and Activty Reports

5/10/2019 5.3.017 Update:

• Don't allow multiple Activities with the same Name or Abbreviation.
• Batch Events can change additional Event elements.
• Bunk schedules will show the red frown if there are multiple activities on the same location.
• Database connect screen shows list of connections in alphabetical order.

5/5/2019 5.3.016 Update:

• Lightning Mode indicator is more obvious (so you know when you're in this mode.)
• Removed automatic event continuation after paste.

4/17/2019 5.3.015 Update:

• New elements for each event:
  • Notes - up to 2000 character note can be added to each event.
  • Secret Signup option - keeps this event off the signup pages.
• Improved Travel Rule processing - Unit and Camp default events are evaluated.
• Complete display of bunk and staff errors in active list.
• Bug Fixes

4/4/2019 5.3.014 Bug Fixes

4/3/2019 5.3.013 Update:

• Support for online signups: changes to Event screen and new Signup Descriptions.
• Address issues with automatic update on Mac - this version has the fix but the automatic update won't work until the next release.
• Added Show Staff to Multiple Events screen.
• Plural forms for unit and bunk terms.
• Missing people includes information from Out of Camp list.
• Show camper requests when selecting events.
• Additional work for Dark Mode.
• Pull version information and updates from new website www.camp-scheduler.com

2/14/2019 5.3.012 Update:

• Event Quality (staffing, gender) is displayed.
• Mac version is now 64 bits. There may be differences in installation. And the automatic updater needs additional testing. You can manually download the latest version if the automatic updater doesn't work.
• Support for Dark Mode on Mac. There are still some objects that don't display properly in Dark Mode, but most of it works. Dark Mode for the scheduling grid can be manually set in Windows and Linux.
• Added Show Staff, similar to Show Campers, in the context menu of the schedule grid. This opens a grid for each staff member assigned to the event.

7/4/2018 5.3.011 Independence Day Bug Fixes

6/26/2018 5.3.010 Bug Fixes

6/15/2018 5.3.009 Bug Fixes

5/23/2018 5.3.008 Fixes:

• Bunk Activity Summary prints bunk names in approximately the correct location. There is a known problem in the framework, waiting for vendor to fix. Workaround gets pretty close.
• Expose number of free periods for staff on Configuration screen.
• Allow event continuation across week boundary.

5/11/2018 5.3.007 Update:

• Added Event Type sub-types. This allows signup event types to overlap. For example a camper might select a Clinic or a Choice.
• Bug fixes

4/30/2018 5.3.006 Update:

• In the Activities screen, Location Names tab, controls behave more like the rest of the system
• Camper and staff check out/in screens
• Travel Rules apply to bunks (in addition to individuals)
• New Travel Rules that can apply to any periods
• Import Camper Names - Bunk names are matched to the External Name by session
• Periods screen: multiple Periods with the same Display Order will issue a warning
• Users screen: list can include active or all; duplicate usernames will issue a warning
• New report of activities camper did - this is targeted for parents but still needs fine tuning
• Event screen shows date of event
• Bug fixes

4/23/2018 5.3.005 (Update cancelled due to technical issues)

2/19/2018 5.3.004 Update:

• Camper and staff check out/in screens (still a work in progress.)
• Bug fixes

2/8/2018 5.3.003 Bug fixes related to latest version of MySQL

2/7/2018 5.3.002 Update:

• Fixes in Staff Skills and various changes needed for latest version of MySQL
• Event Quality cache to make Activity screens update much faster

1/27/2018 5.3.001 Functional Release:

• Staffing rules have been changed. Old Min/Max/Target has been replaced with these:
  • Minimum skill level to lead activity
  • Minimum number of staff with this skill level
  • Ratio: 1 staff for each __ campers
  • Minimum total staff (not necessarily skilled)
  • Option for at least one staff member same gender as campers
  Check the settings for each activity as you may need to adjust the default values. Note that an event that is properly staffed may show errors if campers are added.
• Support for camper and staff gender in bunks and events.
• Travel rules and restrictions implemented.

7/23/2017 5.2.016 Update:

• Added printing options for camper names labels and sociograms
• Bug fixes

6/27/2017 5.2.015 Update:

• New labels with camper names
• New Sociogram report
• Bug fixes

6/19/2017 5.2.014 Bug fixes in Staff Selection; Mac version works again

6/13/2017 5.2.013 Update:

• Mobile App: Options to enable email login and additional custom button on login screen
• Bug fixes in main program

6/3/2017 5.2.012 Update:

• Added Grid/Tab functions to Remove to End, Move to Beginning, Reset Timer
• Added 'Findable' option to Location Names, Find Event only finds these
• Added Find Time button for Bunks - finds times when Bunk and Activity/Location are both available
• Select Staff by Inactive or number of years inactive
• Extra campers or staff at an event can be reported like missing campers or staff
• Mobile version has alternate login with just email to show that person's schedule

5/6/2017 5.2.011 Update:

• Added Group indicator to schedule grid (enable it in Options)
• Changed layout of Event screen to include Event Group
• Error reports can be directed to a list instead of printing, clicking an item in the list opens the schedule
• Added Campers button to Multiple Events screen

7/31/2016 5.2.010 Update:

• Added "Schedule with Bunk" to the grid context menu (right-click)
• Staff & Campers select allows sorting by name, or by unit and bunk
• Find Staff form updates its list automatically
• Bug fixes:
  • Barcode labels and signup sheets formatting
  • Events with Staff Issues error report didn't detect certain events
  • Headings in medical reports

7/17/2016 5.2.009 Update: Improved handling of campers in event chains.

7/5/2016 5.2.008 Update:

• Added Find Staff to Multiple Events screen and main screen
• Added Camper Requests screen to manage wait lists
• Add Show Campers to schedule grid context menu

6/19/2016 5.2.007 Bug fixes

6/19/2016 5.2.006 Update:

• Activity and department schedules show day and date
• Added External Name to Bunks to make importing camper names easier
• Bug fixes in several screens and reports

6/19/2016 5.2.005 Bug fixes:

• Automatic program update
• Staff import
• Typing in selection screen

6/5/2016 5.2.004 Update:

• In Batch Events screen, added button to reset Minimum, Target and Maximum values for events
• Fixed bug where it sometimes ignored your choice of Portrait or Landscape printing

5/7/2016 5.2.003 Update:

• Additional features:
  • Quick-print (File/Print or CTRL-P) prints the current schedule grid.
  • Names can be searched by first or last name.
  • Added Update-Weeks button to viewer.
  • New report: People Reported Missing. Report can be given to unit leaders for follow up.
  • Automatic version update - can detect that a new version is available, and optionally download and install it.
• Fixes:
  • Fixed Bunk Activity Summary report.
  • Windows will not appear off-screen if the number of monitors or their resolution changes.
  • Fixed problems with backup and restore of database. Init Views will properly reset and fix all views.

3/6/2016 5.2.002 Update:

• Import and Export database configuration settings
• Visual fixes for Mac
• Fixes for data entry in Medications screen
• Improvements in Meal Preparation screen

2/12/2016 5.2.001 Functional Release:

• The big stuff:
  • For all reports and schedules, the screen viewer allows you to refresh and print.
  • Any report or schedule can be saved to a CSV (Spreadsheet) format.
  • Added Meal Preparation screen and report to manage campers and staff scheduled for events with special meals (campouts, trips, time off, etc.)
• Other updates:
  • New report: Events without Bunk Counselor.
  • Time Off reports have an option to adjust for part-time (split) staff.
  • Significant performance improvement in Medical screen.
  • Visual updates, just making it look pretty.

12/1/2015 5.1.012 Update:

• Removed department percentages from staff schedules.
• Show secondary and tertiary (General Counselor) designations on staff schedules and scheduling grid.
• For Mac:
  • Visual fixes, various spacing and character set issues
  • Fixed crash when viewing reports on screen
  • Fixed grid drawing for first grid
• For activities, optionally include skills from another activity.
• New report: Counselor Coverage Summary - shows how many events each counselor has by primary, secondary and tertiary (CG).
• Previous versions updated the database silently. From here forward users are warned and the database ID is also updated. This prevents undo or redo of previous operations into the updated database with a different schema, preventing database corruption.
• Added button in Special screen to delete all camper requests.
• When manually scheduling campers, unschedule existing event before scheduling new event.
• Select staff by unit - returns results sorted by bunk.
• Department schedules by time (the usual grid) or by staff (like the campers by bunk report.)

6/8/2015 5.1.011 Update:

• Corrected several issues with Event Sets
• Corrected minor visual issues
• If a record cannot be deleted, show more information about related records
• Added toolbar button for Prepare Signups
• Added Remember Me checkbox to login screen

4/25/2015 5.1.010 Update:

• Added ExternalID for staff & campers
• Ability to import list of campers for an event using ExternalID (in progress)
• In Department option for Find Event for staff
• Find Staff excludes staff that are not in camp during the event
• Fixes to medications screen
• Event reports show ending period when continued
• Formating improvements to department event reports
• Fixes to handling of hidden events

6/28/2014 5.1.009 Update:

• Improved Staff Errors report to detect both skills and staff counts.
• Fixed bunk lists in several areas to show only current bunks.
• Fixed medication reports to include campers in bunks and campers assigned to the event.

6/15/2014 5.1.008 Bug fixes for importing staff

6/13/2014 5.1.007 Functional update:

• New grid color for warnings. Default is grey, change it in Tools/Options.
• Grid activities show colors for errors (insufficient skilled staff) and warnings (not enough staff.)
• Function to reset Min Target Max on all events. See Scheduling/Special Functions.

6/8/2014 5.1.006 Bug Fixes: Fixed errors in setting time off and counselor follow.

6/6/2014 5.1.005 Update:

• Function changes:
  • Display bunk number for General Counselors in most reports.
  • Skill Quick-entry accepts skill abbreviation or unique portion of name. Requires MySQL Server 5.6 or later.
  • Multiple Events window closes itself after 2 minutes of inactivity.
  • Paste Event sets continuation where possible.
• Cosmetic fix: Improved screen updates removing flicker and multiple updates.
• Known issues:
  • MySQL Server versions prior to 5.6:
    • may give errors in Skill Quick-entry screen.
    • recurrance indicators (number of times a bunk has the activity in a session) don't always show.
  • Staff screen does not show bunk numbers if the bunk does not exist in the active weeks.

5/3/2014 5.1.004 Update:

• Function changes:
  • New report in Errors group: Overloaded locations ignoring events that don't require staff.
  • Check and Repair Database finds (and fixes) bunks that are scheduled outside of their sessions.
• Experimental feature: (This might change or be replaced by something different, feedback is welcome.)
  • Live Report - a report on the screen that updates automatically each time the window becomes active, usually by clicking on it. The only Live Report at this time is a Bunk Activity Summary for a single activity. Look in the Scheduling menu to find this feature.
• Known issue:
  • A bunk in non-consecutive sessions will appear available at times between the sessions.

4/20/2014 5.1.003 Update:

• Functional changes:
  • Added Medications Needed to Locations. Events that need medications prepared can be tagged by Activity or Location.
• Fixes:
  • Fixed deleting a person.

4/19/2014 5.1.002 Update:

• Additional features:
  • Medication Labels
  • Improvements to Check and Repair Database
  • Merge Bunks: combines schedules of 2 bunks into one. Use Database Repair after a merge to remove any duplicate assignments to the same activity.
  • Continue All added to right-click popup menu in grid. Sets continuation for all applicable events.
  • Deleting a Bunk - if campers or staff are still in the bunk, the program tells you who.
  • Automatic Login is attempted after switching databases.
• Fixes:
  • List of Bunks presented will better match with active weeks.
  • Various issues in Medications.
  • Button icons on Linux are fixed.

4/5/2014 5.1.001 Functional Release:

• Tablet Edition: a program designed for mid-size screens with a touch interface. This program is a portable version of the Camp Scheduler for department heads and other leadership staff. It has screens for viewing schedules, taking attendance, and flagging missing campers or staff. Any tablet with network access and a web browser should work. A server is required to host the application.
• Sessions: A session has a begin and end week. Each bunk is assigned to one or more sessions. The system displays only appropriate bunks based on current weeks.
• Missing campers and staff are tracked. When a person is flagged as missing, a warning popup appears.
• Medications are tracked for campers. Reports are available to indicate medications needed for out of camp trips. Most of this is invisible unless the user has the Medical box checked.
• Published Weeks in Database/Customize replaces Begin and End Weeks for individual users. Weeks are restricted to the published weeks unless the user has the Set Weeks box checked.
• Event attendance tracking: system can show which events need to be checked.
• Reports and schedules:
  • Activity and Department schedules show number of campers for a signup event.
  • Schedules and Event reports can show the number of times this event occurs in the session. Optional based on tag in Department or Activity.
  • Duplicate camper names.
  • Medication List for counselors (shows which campers need medications and at what times, does not show actual medications.)
• Staff Data import
• Event Data export

Outstanding issues in this release:

• On Linux, many buttons do not show their icon/image. Bug in the compiler, being fixed by the vendor.
• This version has not been tested on a Mac. Minimum Mac OS version supported is 10.7 Lion.
• Staff Data import needs further testing.
• Labels for medications for trips.
• Tablet Edition not available at this time because the web server is not set up.