USYVL Development Wiki - User contributions [en]

2025-Hours-Log

2025-10-05T01:58:39Z

Aaron: /* 2025-10-04 - Aaron Martin - 2.0h */

== 2025 ==
=== 2025-10 ===
==== 2025-10-01 - Aaron Martin - 1.0h ====
* scheduling:1h:Resolve issue with runTS.php script failing due to data issues (no teams setup in Advanced Juniors meant an empty division list which caused a php error)

==== 2025-10-02 - Aaron Martin - 1.0h ====
* scheduling:1h:Add in code to use the db to generate the tournament structures in runTS.php

==== 2025-10-04 - Aaron Martin - 3.0h ====
* mobile:1h:Fix issues with "Tournaments" link on the site/program pages where the link-throughs there did not work correctly and did not match the "Daily Summaries" links.
* mobile:0.5h:Fix issues with "Games" link on the site/program pages where link-throughs to individual days did not match the "Daily Summaries" links.
* mobile:0.25h:Identify some issues with tournament summary pages - Pool info not showing up on those pages.
* mobile:0.25h:Identify some issues with db (no records in "pool" db table) - related to above item.
* scheduling:1h:Code fixes to tournament XML harvesting to get some data available to mobile site...

2025-Hours-Log

2025-10-04T23:49:21Z

Aaron: /* 2025-10-04 - Aaron Martin - 2.0h */

== 2025 ==
=== 2025-10 ===
==== 2025-10-01 - Aaron Martin - 1.0h ====
* scheduling:1h:Resolve issue with runTS.php script failing due to data issues (no teams setup in Advanced Juniors meant an empty division list which caused a php error)

==== 2025-10-02 - Aaron Martin - 1.0h ====
* scheduling:1h:Add in code to use the db to generate the tournament structures in runTS.php

==== 2025-10-04 - Aaron Martin - 2.0h ====
* mobile:1h:Fix issues with "Tournaments" link on the site/program pages where the link-throughs there did not work correctly and did not match the "Daily Summaries" links.
* mobile:0.5h:Fix issues with "Games" link on the site/program pages where link-throughs to individual days did not match the "Daily Summaries" links.
* mobile:0.25h:Identify some issues with tournament summary pages - Pool info not showing up on those pages.
* mobile:0.25h:Identify some issues with db (no records in "pool" db table) - related to above item.

2025-Hours-Log

2025-10-04T23:48:16Z

Aaron: /* 2025-10-02 - Aaron Martin - 1.0h */

== 2025 ==
=== 2025-10 ===
==== 2025-10-01 - Aaron Martin - 1.0h ====
* scheduling:1h:Resolve issue with runTS.php script failing due to data issues (no teams setup in Advanced Juniors meant an empty division list which caused a php error)

==== 2025-10-02 - Aaron Martin - 1.0h ====
* scheduling:1h:Add in code to use the db to generate the tournament structures in runTS.php

==== 2025-10-04 - Aaron Martin - 2.0h ====
* mobile:1h:Fix issues with "Tournaments" link on the site/program pages where the link-throughs there did not work correctly and did not match the "Daily Summaries" links.
* mobile:0.5h:Fix issues with "Games" link on the site/program pages where link-throughs to individual days did not match the "Daily Summaries" links.
* mobile:0.25h:Identify some issues with db (no records in "pool" db table)
* mobile:0.25h:Identify some issues with tournament summary pages - Pool info not showing up on those pages.

MediaWiki:Sidebar

2025-10-04T23:42:02Z

Aaron:

2025-Hours-Log

2025-10-02T19:19:01Z

Aaron:

2025-Hours-Log

2025-10-02T19:15:24Z

Aaron: Created page with "# Yo"

# Yo

Development - ToDo

2025-04-23T22:11:50Z

Aaron: /* 2025=04-23 Thoughts on moving forward */

[[Category:Scheduling]]
== 2025 Dev ToDos ==
=== Scheduling - Location Processing ===
Need to dive deep into this and consolidate the location processing steps. Currently there are three different location processing steps that produce different datasets for use further down the scheduling processing stream.
==== 2025-04-23 DB table issue ====
* SB added an incomplete single location to the db (name only).
** This caused the locationProcessingNew.php script to hang and even clog the session

==== 2025=04-23 Thoughts on moving forward ====
* should try to duplication above issue that SB found and figure out how to prevent in future
* identify the 3 current location processing scripts/processes
** locationProcessingMobile.php - ? builds location db for mobile site ?
** locationProcessingNew.php - ? new DB based location setup ?
** locationProcessing.php - should be original that writes files out to filesystem
* identify all locations in current processing steps that use location information
** determine what the source is for each of those
** migrate each to use the current best system
*** identify that best system

== 2023 Dev ToDos ==
=== General ===
* come up with shell script (or something) that goes through and does pulls on all the repos
** alternatively pull the ext repos as well, but that might not be an always...
* update production links on scheduling, workflow and wiki to point at the right locations (not venom any more)

=== Engage ===
* sort out import functionality from workflow
* facilities export

=== Scheduling ===
==== Processing ====
* runTS.php - runTS - convert to db based loop instead of file based
** have started process
* runSI - see about doing schedule query further down the subcommands
** look for comments in runSI.php -> siteScheduleSection
* Sort out the multiple Instructional Summary Runs
==== Locations ====
* multiple (3) location processing steps
* runTI::loadProximityDistances
** currently file based, need to convert to db based - I think I started the proximity stuff somewhere
* proximity
** would be nice to have linear distance as well as drive time (minutes)

==== Support for Advanced Juniors and other oddities ====
* improving support for Advanced Juniors, Camps, Clinics
** check in with Veronica/Randy/Shirley about what that should look like
** need to sort out division designations
*** U13, U16 etc... vs 16 Under

==== Data Management ====
* xfering/exporting latest datasets/settings etc...
* Check for non-existent location to prevent map error
** this is for data Summer 2023-pass2
* clean up timestamp adds to schedule output
** need to verify that the new no-cache code is in all the files
* tool to clear old seasons from ftp server
** specify season from a pull down - loop over dir suffixes
* tooltip over sample data entries with description
** collapsible
* Sample Data Sets
** Add form to create sample data (from last updloaded or possibly other)
** Want to be able to save a copy of the most recent upload, rename it, and maybe even export the associated files (-ev.csv, -tm.csv, .meta) (tar? zip?), import it
* copy poolLayoutDb from tools to local dev (removed a row, I should not have).

==== HTML Pages/Schedules/HTML ====
* add time stamp to static site and tourn info sheets (like was done with PDFs)
** possibly more detail, branch and hash?
* add the no-cache goodies to all pages in schedules
* setup an xfer to a secondary location on the main system
** as opposed to an FTP xfer
** simple copy by php to s.usyvl.org
* NetLabel PDFs
** make watermark darker or maybe in color (usyvlFPDF.php:381)
** add the netlabel pdf to the TI html pages
** need to check handling of missing division
*** had an empty 7-8 division that created a blank page for the 7-8
*** had an overprint of the match grid for 7-8 and 9-10
*** example would be: 2023_C_Fall-ts/2023-10-28-Ventura-Goleta-Ojai.pdf
**** This was an unusual case since 10-14 match with Goleta/Ojai was OK, think maybe because of single 7-8 team moved into 9-10. So 7-8 pool was created, but not deleted after moving that one team to 9-10 pool
** add branch to bottom page label

==== Web Services ====
* repoint schedules.usyvl.org at linode
* remove extra index file variations, currently there are three, and one is supporting ancient forms
** explore options for altering colors: background, text etc... easily and modularly without having to have completely separate styles
* work on having dprint/print_pre - return vs print functionality be more consistent: ie: one is true for returning, the other false to return
** look for other php examples of WHAT that return value should be

=== Mobile ===
* fix or remove links for tournaments/games/etc...
** currently only daily schedules is correctly linked
* Sort order on epoch for daily schedules
** cover cases where there are two events in one day (rare, but it happens)
* remove or fix tournament listings on main site page
* make sure that tournament matches are in the match listings
** allow scorekeeping of those
* scorekeeper
** allow name editing?
** fix instructions (no - now)

==Auto Generated Report Data==
*It would be nice to copy the lastauto* files to the local development page...
**Not critical, but nice for testing
*web methods can get the data, but we lose the mtime...
**fetch at resetIODirectory time...
**preserve the mtime some other way for those files...
**maybe the meta file???
***That would require that we update the meta file each time we receive an entry...
***How would this work with testing/development work on the script?
*scp -p from home
**via cron from home might work
**via make target

Also need to figure out how to decide whether we should be copying this stuff and where we copy the stuff from

==2014-04 Dev thoughts==
*Mobile Prep
**resetTables during reset IO dir
**detect empty tables in mobile site and offer appropriate message
*Scheduling Processing
**consider storing php serialized objects in db for working with
*Want a general facelift to scheduling site
**HTML5 (with html5 shim for older browsers)
**CSS3
**HTML based nav menu
**More modern login/logout setup
***PHP session cookies, remember me setup
*Start working towards getting all scheduling data configured in the db
**Could feed both mobile site and a joomla module
*Change upload to import
*Incorporate the email check into the Import page
**Maybe an ajax request in a section of the page
*Maybe figure out a better way to do general progress display, old way produces lots of output (in HTML comments)..
**This would also possibly allow a way to do more of a template setup
*Consider moving scheduling into a drupal site
**Takes care of some of the role stuff I would like to do
**Or at least playing with a dev

==Scheduling v2 thoughts==
===Databases===
*access db - persistent data shared by all usyvl systems
**access
**settings?
*dynamic - data that is re-generated each time scheduling is run
**clear tables on resetIOdir
**Input data
***team report data (™)
***event report data (ev)
**derived data
***match table
**Consider saving serialized php objects across scripts???
**Want to square away the event id (evid) stuff
***Currently home and away tournaments have different evids, we need to clean that up
****Possibly establish evids for home tourns and then match away tourns to those

*static db - persistent data for scheduling
**location table - need some sort of a timestamp for new or updated entries to allow geocoding
**distance table - figure out how to manage this table that will store google distance api data between all of the sites

Development - ToDo

2025-04-23T22:11:13Z

Aaron:

[[Category:Scheduling]]
== 2025 Dev ToDos ==
=== Scheduling - Location Processing ===
Need to dive deep into this and consolidate the location processing steps. Currently there are three different location processing steps that produce different datasets for use further down the scheduling processing stream.
==== 2025-04-23 DB table issue ====
* SB added an incomplete single location to the db (name only).
** This caused the locationProcessingNew.php script to hang and even clog the session

==== 2025=04-23 Thoughts on moving forward ====
* identify the 3 current location processing scripts/processes
** locationProcessingMobile.php - ? builds location db for mobile site ?
** locationProcessingNew.php - ? new DB based location setup ?
** locationProcessing.php - should be original that writes files out to filesystem
* identify all locations in current processing steps that use location information
** determine what the source is for each of those
** migrate each to use the current best system
*** identify that best system

== 2023 Dev ToDos ==
=== General ===
* come up with shell script (or something) that goes through and does pulls on all the repos
** alternatively pull the ext repos as well, but that might not be an always...
* update production links on scheduling, workflow and wiki to point at the right locations (not venom any more)

=== Engage ===
* sort out import functionality from workflow
* facilities export

=== Scheduling ===
==== Processing ====
* runTS.php - runTS - convert to db based loop instead of file based
** have started process
* runSI - see about doing schedule query further down the subcommands
** look for comments in runSI.php -> siteScheduleSection
* Sort out the multiple Instructional Summary Runs
==== Locations ====
* multiple (3) location processing steps
* runTI::loadProximityDistances
** currently file based, need to convert to db based - I think I started the proximity stuff somewhere
* proximity
** would be nice to have linear distance as well as drive time (minutes)

==== Support for Advanced Juniors and other oddities ====
* improving support for Advanced Juniors, Camps, Clinics
** check in with Veronica/Randy/Shirley about what that should look like
** need to sort out division designations
*** U13, U16 etc... vs 16 Under

==== Data Management ====
* xfering/exporting latest datasets/settings etc...
* Check for non-existent location to prevent map error
** this is for data Summer 2023-pass2
* clean up timestamp adds to schedule output
** need to verify that the new no-cache code is in all the files
* tool to clear old seasons from ftp server
** specify season from a pull down - loop over dir suffixes
* tooltip over sample data entries with description
** collapsible
* Sample Data Sets
** Add form to create sample data (from last updloaded or possibly other)
** Want to be able to save a copy of the most recent upload, rename it, and maybe even export the associated files (-ev.csv, -tm.csv, .meta) (tar? zip?), import it
* copy poolLayoutDb from tools to local dev (removed a row, I should not have).

==== HTML Pages/Schedules/HTML ====
* add time stamp to static site and tourn info sheets (like was done with PDFs)
** possibly more detail, branch and hash?
* add the no-cache goodies to all pages in schedules
* setup an xfer to a secondary location on the main system
** as opposed to an FTP xfer
** simple copy by php to s.usyvl.org
* NetLabel PDFs
** make watermark darker or maybe in color (usyvlFPDF.php:381)
** add the netlabel pdf to the TI html pages
** need to check handling of missing division
*** had an empty 7-8 division that created a blank page for the 7-8
*** had an overprint of the match grid for 7-8 and 9-10
*** example would be: 2023_C_Fall-ts/2023-10-28-Ventura-Goleta-Ojai.pdf
**** This was an unusual case since 10-14 match with Goleta/Ojai was OK, think maybe because of single 7-8 team moved into 9-10. So 7-8 pool was created, but not deleted after moving that one team to 9-10 pool
** add branch to bottom page label

==== Web Services ====
* repoint schedules.usyvl.org at linode
* remove extra index file variations, currently there are three, and one is supporting ancient forms
** explore options for altering colors: background, text etc... easily and modularly without having to have completely separate styles
* work on having dprint/print_pre - return vs print functionality be more consistent: ie: one is true for returning, the other false to return
** look for other php examples of WHAT that return value should be

=== Mobile ===
* fix or remove links for tournaments/games/etc...
** currently only daily schedules is correctly linked
* Sort order on epoch for daily schedules
** cover cases where there are two events in one day (rare, but it happens)
* remove or fix tournament listings on main site page
* make sure that tournament matches are in the match listings
** allow scorekeeping of those
* scorekeeper
** allow name editing?
** fix instructions (no - now)

==Auto Generated Report Data==
*It would be nice to copy the lastauto* files to the local development page...
**Not critical, but nice for testing
*web methods can get the data, but we lose the mtime...
**fetch at resetIODirectory time...
**preserve the mtime some other way for those files...
**maybe the meta file???
***That would require that we update the meta file each time we receive an entry...
***How would this work with testing/development work on the script?
*scp -p from home
**via cron from home might work
**via make target

Also need to figure out how to decide whether we should be copying this stuff and where we copy the stuff from

==2014-04 Dev thoughts==
*Mobile Prep
**resetTables during reset IO dir
**detect empty tables in mobile site and offer appropriate message
*Scheduling Processing
**consider storing php serialized objects in db for working with
*Want a general facelift to scheduling site
**HTML5 (with html5 shim for older browsers)
**CSS3
**HTML based nav menu
**More modern login/logout setup
***PHP session cookies, remember me setup
*Start working towards getting all scheduling data configured in the db
**Could feed both mobile site and a joomla module
*Change upload to import
*Incorporate the email check into the Import page
**Maybe an ajax request in a section of the page
*Maybe figure out a better way to do general progress display, old way produces lots of output (in HTML comments)..
**This would also possibly allow a way to do more of a template setup
*Consider moving scheduling into a drupal site
**Takes care of some of the role stuff I would like to do
**Or at least playing with a dev

==Scheduling v2 thoughts==
===Databases===
*access db - persistent data shared by all usyvl systems
**access
**settings?
*dynamic - data that is re-generated each time scheduling is run
**clear tables on resetIOdir
**Input data
***team report data (™)
***event report data (ev)
**derived data
***match table
**Consider saving serialized php objects across scripts???
**Want to square away the event id (evid) stuff
***Currently home and away tournaments have different evids, we need to clean that up
****Possibly establish evids for home tourns and then match away tourns to those

*static db - persistent data for scheduling
**location table - need some sort of a timestamp for new or updated entries to allow geocoding
**distance table - figure out how to manage this table that will store google distance api data between all of the sites

2024-Hours-Log

2024-08-22T20:21:28Z

Aaron: /* 2024 */

== 2024 ==
=== 2024-08 ===
==== 2024-08-22 - Aaron Martin - 0.5h ====
* scheduling:30m:add in the seasons earliest datestamp to selective linking options. This should allow runner to shut off ALL tournament display.

=== 2024-06 ===
==== 2024-06-26 - Aaron Martin - 0.5h ====
* workflow:30m:fix Engage export file noted by SB, version updated
=== 2024-05 ===
==== 2024-05-20 - Aaron Martin - 1.0h ====
* scheduling:30m:updating poollayout db, dev and production sites
* scheduling:30m:fixing some code issues in custom tourn editor (errors floating around)

==== 2024-05-17 - Aaron Martin - 0.5h ====
* scheduling:30m:colorizing watermark (manual code update)

2024-Hours-Log

2024-06-26T19:13:49Z

Aaron: /* 2024 */

== 2024 ==
=== 2024-06 ===
==== 2024-06-26 - Aaron Martin - 0.5h ====
* workflow:30m:fix Engage export file noted by SB, version updated
=== 2024-05 ===
==== 2024-05-20 - Aaron Martin - 1.0h ====
* scheduling:30m:updating poollayout db, dev and production sites
* scheduling:30m:fixing some code issues in custom tourn editor (errors floating around)

==== 2024-05-17 - Aaron Martin - 0.5h ====
* scheduling:30m:colorizing watermark (manual code update)

2024-Hours-Log

2024-05-20T22:15:32Z

Aaron: /* 2024-05-18 - Aaron Martin - 0.5h */

== 2024 ==
=== 2024-05 ===
==== 2024-05-20 - Aaron Martin - 1.0h ====
* scheduling:30m:updating poollayout db, dev and production sites
* scheduling:30m:fixing some code issues in custom tourn editor (errors floating around)

==== 2024-05-17 - Aaron Martin - 0.5h ====
* scheduling:30m:colorizing watermark (manual code update)

2024-Hours-Log

2024-05-20T22:15:16Z

Aaron:

== 2024 ==
=== 2024-05 ===
==== 2024-05-20 - Aaron Martin - 1.0h ====
* scheduling:30m:updating poollayout db, dev and production sites
* scheduling:30m:fixing some code issues in custom tourn editor (errors floating around)

==== 2024-05-18 - Aaron Martin - 0.5h ====
* scheduling:30m:colorizing watermark (manual code update)

2024-Hours-Log

2024-05-20T22:13:04Z

Aaron: Created page with "== 2023 == === 2023-10 === ==== 2023-10-31 - Aaron Martin - 0.5h ==== * general:30m:making notes on todo page ==== 2023-10-20 - Aaron Martin - 4.0h ==== * workflow:1.0h:import of engage export * workflow:1.0h:work on UI/UX of the file import listing, adding management (deletion with confirmation and followup message) * workflow:0.5h:error reporting on import process * workflow:1.0h:data structure, framework for import ==== 2023-10-18 - Aaron Martin - 3.5h ==== * workflo..."

MediaWiki:Sidebar

2024-05-20T22:12:35Z

Aaron:

Development - ToDo

2023-11-04T21:44:17Z

Aaron: /* Scheduling */

[[Category:Scheduling]]
== 2023 Dev ToDos ==
=== General ===
* come up with shell script (or something) that goes through and does pulls on all the repos
** alternatively pull the ext repos as well, but that might not be an always...
* update production links on scheduling, workflow and wiki to point at the right locations (not venom any more)

=== Engage ===
* sort out import functionality from workflow
* facilities export

=== Scheduling ===
==== Processing ====
* runTS.php - runTS - convert to db based loop instead of file based
** have started process
* runSI - see about doing schedule query further down the subcommands
** look for comments in runSI.php -> siteScheduleSection
* Sort out the multiple Instructional Summary Runs
==== Locations ====
* multiple (3) location processing steps
* runTI::loadProximityDistances
** currently file based, need to convert to db based - I think I started the proximity stuff somewhere
* proximity
** would be nice to have linear distance as well as drive time (minutes)

==== Support for Advanced Juniors and other oddities ====
* improving support for Advanced Juniors, Camps, Clinics
** check in with Veronica/Randy/Shirley about what that should look like
** need to sort out division designations
*** U13, U16 etc... vs 16 Under

==== Data Management ====
* xfering/exporting latest datasets/settings etc...
* Check for non-existent location to prevent map error
** this is for data Summer 2023-pass2
* clean up timestamp adds to schedule output
** need to verify that the new no-cache code is in all the files
* tool to clear old seasons from ftp server
** specify season from a pull down - loop over dir suffixes
* tooltip over sample data entries with description
** collapsible
* Sample Data Sets
** Add form to create sample data (from last updloaded or possibly other)
** Want to be able to save a copy of the most recent upload, rename it, and maybe even export the associated files (-ev.csv, -tm.csv, .meta) (tar? zip?), import it
* copy poolLayoutDb from tools to local dev (removed a row, I should not have).

==== HTML Pages/Schedules/HTML ====
* add time stamp to static site and tourn info sheets (like was done with PDFs)
** possibly more detail, branch and hash?
* add the no-cache goodies to all pages in schedules
* setup an xfer to a secondary location on the main system
** as opposed to an FTP xfer
** simple copy by php to s.usyvl.org
* NetLabel PDFs
** make watermark darker or maybe in color (usyvlFPDF.php:381)
** add the netlabel pdf to the TI html pages
** need to check handling of missing division
*** had an empty 7-8 division that created a blank page for the 7-8
*** had an overprint of the match grid for 7-8 and 9-10
*** example would be: 2023_C_Fall-ts/2023-10-28-Ventura-Goleta-Ojai.pdf
**** This was an unusual case since 10-14 match with Goleta/Ojai was OK, think maybe because of single 7-8 team moved into 9-10. So 7-8 pool was created, but not deleted after moving that one team to 9-10 pool
** add branch to bottom page label

==== Web Services ====
* repoint schedules.usyvl.org at linode
* remove extra index file variations, currently there are three, and one is supporting ancient forms
** explore options for altering colors: background, text etc... easily and modularly without having to have completely separate styles
* work on having dprint/print_pre - return vs print functionality be more consistent: ie: one is true for returning, the other false to return
** look for other php examples of WHAT that return value should be

=== Mobile ===
* fix or remove links for tournaments/games/etc...
** currently only daily schedules is correctly linked
* Sort order on epoch for daily schedules
** cover cases where there are two events in one day (rare, but it happens)
* remove or fix tournament listings on main site page
* make sure that tournament matches are in the match listings
** allow scorekeeping of those
* scorekeeper
** allow name editing?
** fix instructions (no - now)

==Auto Generated Report Data==
*It would be nice to copy the lastauto* files to the local development page...
**Not critical, but nice for testing
*web methods can get the data, but we lose the mtime...
**fetch at resetIODirectory time...
**preserve the mtime some other way for those files...
**maybe the meta file???
***That would require that we update the meta file each time we receive an entry...
***How would this work with testing/development work on the script?
*scp -p from home
**via cron from home might work
**via make target

Also need to figure out how to decide whether we should be copying this stuff and where we copy the stuff from

==2014-04 Dev thoughts==
*Mobile Prep
**resetTables during reset IO dir
**detect empty tables in mobile site and offer appropriate message
*Scheduling Processing
**consider storing php serialized objects in db for working with
*Want a general facelift to scheduling site
**HTML5 (with html5 shim for older browsers)
**CSS3
**HTML based nav menu
**More modern login/logout setup
***PHP session cookies, remember me setup
*Start working towards getting all scheduling data configured in the db
**Could feed both mobile site and a joomla module
*Change upload to import
*Incorporate the email check into the Import page
**Maybe an ajax request in a section of the page
*Maybe figure out a better way to do general progress display, old way produces lots of output (in HTML comments)..
**This would also possibly allow a way to do more of a template setup
*Consider moving scheduling into a drupal site
**Takes care of some of the role stuff I would like to do
**Or at least playing with a dev

==Scheduling v2 thoughts==
===Databases===
*access db - persistent data shared by all usyvl systems
**access
**settings?
*dynamic - data that is re-generated each time scheduling is run
**clear tables on resetIOdir
**Input data
***team report data (™)
***event report data (ev)
**derived data
***match table
**Consider saving serialized php objects across scripts???
**Want to square away the event id (evid) stuff
***Currently home and away tournaments have different evids, we need to clean that up
****Possibly establish evids for home tourns and then match away tourns to those

*static db - persistent data for scheduling
**location table - need some sort of a timestamp for new or updated entries to allow geocoding
**distance table - figure out how to manage this table that will store google distance api data between all of the sites

2023-Hours-Log

2023-10-31T17:02:34Z

Aaron: /* 2023-10 */

== 2023 ==
=== 2023-10 ===
==== 2023-10-31 - Aaron Martin - 0.5h ====
* general:30m:making notes on todo page

==== 2023-10-20 - Aaron Martin - 4.0h ====
* workflow:1.0h:import of engage export
* workflow:1.0h:work on UI/UX of the file import listing, adding management (deletion with confirmation and followup message)
* workflow:0.5h:error reporting on import process
* workflow:1.0h:data structure, framework for import
==== 2023-10-18 - Aaron Martin - 3.5h ====
* workflow:0.5h:incorporate PhpSpreadsheet into workflow to allow importing of xlsx files
* workflow:1.5h:implement uploading xlsx files and partially implement actual reading of data into
* workflow:1.0:implement revamped versioning setup like in scheduling
* portal:0.5h:implement revamped versioning setup like in scheduling
* scheduling:
==== 2023-10-16 - Aaron Martin - 4.0h ====
* scheduling:3h:Fix broken support for various divisions/netheight handling
* scheduling:1h:revamp versioning setup, now using .git files, so a commit updates automatically. Implement listing branch and commit hash on landing page.
==== 2023-10-06 - Aaron Martin - 2.0h ====
* scheduling:2h:implement support for uploading PDF files

=== 2023-09 ===
==== 2023-09-28 - Aaron Martin - 2.0h ====
* scheduling:1.5h:incorporate assistant coach field from engage (unsupported by previous backends) and set coach field from asstcoach field if coach field is empty. required adding support in a number of files.
* scheduling:0.5h:resolve issue with wrong google api key being used

==== 2023-09-25 - Aaron Martin - 0.75h ====
* scheduling:0.25h:update rules pdf file
* scheduling:0.5h:resolve issue with season name parsing

==== 2023-09-21 - Aaron Martin - ?.?h ====
==== 2023-09-18 - Aaron Martin - ?.?h ====

==== 2023-09-12 - Aaron Martin - 2.5h ====
* workflow:1.75h:demo workflow functionality
* workflow:0.25h:minor code fixes for schedules
* scheduling:0.5h:fix some issues with schedules output, SI pages index file, etc...

==== 2023-09-10 - Aaron Martin - 3.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:0.5:styling fixes, cleanup, neatening
* workflow:1.5h:siteinfo shell script to manage some imports/updates from engage export file
* workflow:0.5h:data harvesting, importing, updating for Fall 2023

==== 2023-09-09 - Aaron Martin - 4.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:1h:styling fixes, cleanup, neatening
* workflow:2h:data harvesting from xls spreadsheet and imports to db for Fall 2023
* workflow:0.5h:resolve some dbh issues that was blocking event table clearing

=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-22 ====
* portal:0.5h:extracting wiki version if underneath

==== 2023-06-21 ====
* portal:0.5h:futzing with formatting of display, "tab" stops

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

=== 2023-05 ===
==== 2023-05-31 -- Aaron Martin -- 1.0h ====
* portal:1.0h:restructure repo so that there is a public_html folder under the repo, futzing with sym links
==== 2023-05-30 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Work on getting versions into link tables
==== 2023-05-18 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, refinement. Catching some edge cases
==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working
==== 2023-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

Development - ToDo

2023-10-31T16:21:02Z

Aaron: /* Scheduling */

[[Category:Scheduling]]
== 2023 Dev ToDos ==
=== General ===
* come up with shell script (or something) that goes through and does pulls on all the repos
** alternatively pull the ext repos as well, but that might not be an always...
* update production links on scheduling, workflow and wiki to point at the right locations (not venom any more)

=== Engage ===
* sort out import functionality from workflow
* facilities export

=== Scheduling ===
==== Processing ====
* runTS.php - runTS - convert to db based loop instead of file based
** have started process
* runSI - see about doing schedule query further down the subcommands
** look for comments in runSI.php -> siteScheduleSection
* Sort out the multiple Instructional Summary Runs
==== Locations ====
* multiple (3) location processing steps
* runTI::loadProximityDistances
** currently file based, need to convert to db based - I think I started the proximity stuff somewhere
* proximity
** would be nice to have linear distance as well as drive time (minutes)

==== Support for Advanced Juniors and other oddities ====
* improving support for Advanced Juniors, Camps, Clinics
** check in with Veronica/Randy/Shirley about what that should look like
** need to sort out division designations
*** U13, U16 etc... vs 16 Under

==== Data Management ====
* xfering/exporting latest datasets/settings etc...
* Check for non-existent location to prevent map error
** this is for data Summer 2023-pass2
* clean up timestamp adds to schedule output
** need to verify that the new no-cache code is in all the files
* tool to clear old seasons from ftp server
** specify season from a pull down - loop over dir suffixes
* tooltip over sample data entries with description
** collapsible
* Sample Data Sets
** Add form to create sample data (from last updloaded or possibly other)
** Want to be able to save a copy of the most recent upload, rename it, and maybe even export the associated files (-ev.csv, -tm.csv, .meta) (tar? zip?), import it
* copy poolLayoutDb from tools to local dev (removed a row, I should not have).

==== HTML Pages/Schedules/HTML ====
* add time stamp to static site and tourn info sheets (like was done with PDFs)
** possibly more detail, branch and hash?
* add the no-cache goodies to all pages in schedules
* setup an xfer to a secondary location on the main system
** as opposed to an FTP xfer
** simple copy by php to s.usyvl.org

==== Web Services ====
* repoint schedules.usyvl.org at linode
* remove extra index file variations, currently there are three, and one is supporting ancient forms
** explore options for altering colors: background, text etc... easily and modularly without having to have completely separate styles
* work on having dprint/print_pre - return vs print functionality be more consistent: ie: one is true for returning, the other false to return
** look for other php examples of WHAT that return value should be

=== Mobile ===
* fix or remove links for tournaments/games/etc...
** currently only daily schedules is correctly linked
* Sort order on epoch for daily schedules
** cover cases where there are two events in one day (rare, but it happens)
* remove or fix tournament listings on main site page
* make sure that tournament matches are in the match listings
** allow scorekeeping of those
* scorekeeper
** allow name editing?
** fix instructions (no - now)

==Auto Generated Report Data==
*It would be nice to copy the lastauto* files to the local development page...
**Not critical, but nice for testing
*web methods can get the data, but we lose the mtime...
**fetch at resetIODirectory time...
**preserve the mtime some other way for those files...
**maybe the meta file???
***That would require that we update the meta file each time we receive an entry...
***How would this work with testing/development work on the script?
*scp -p from home
**via cron from home might work
**via make target

Also need to figure out how to decide whether we should be copying this stuff and where we copy the stuff from

==2014-04 Dev thoughts==
*Mobile Prep
**resetTables during reset IO dir
**detect empty tables in mobile site and offer appropriate message
*Scheduling Processing
**consider storing php serialized objects in db for working with
*Want a general facelift to scheduling site
**HTML5 (with html5 shim for older browsers)
**CSS3
**HTML based nav menu
**More modern login/logout setup
***PHP session cookies, remember me setup
*Start working towards getting all scheduling data configured in the db
**Could feed both mobile site and a joomla module
*Change upload to import
*Incorporate the email check into the Import page
**Maybe an ajax request in a section of the page
*Maybe figure out a better way to do general progress display, old way produces lots of output (in HTML comments)..
**This would also possibly allow a way to do more of a template setup
*Consider moving scheduling into a drupal site
**Takes care of some of the role stuff I would like to do
**Or at least playing with a dev

==Scheduling v2 thoughts==
===Databases===
*access db - persistent data shared by all usyvl systems
**access
**settings?
*dynamic - data that is re-generated each time scheduling is run
**clear tables on resetIOdir
**Input data
***team report data (™)
***event report data (ev)
**derived data
***match table
**Consider saving serialized php objects across scripts???
**Want to square away the event id (evid) stuff
***Currently home and away tournaments have different evids, we need to clean that up
****Possibly establish evids for home tourns and then match away tourns to those

*static db - persistent data for scheduling
**location table - need some sort of a timestamp for new or updated entries to allow geocoding
**distance table - figure out how to manage this table that will store google distance api data between all of the sites

Development - ToDo

2023-10-31T16:10:10Z

Aaron: /* Scheduling */

[[Category:Scheduling]]
== 2023 Dev ToDos ==
=== General ===
* come up with shell script (or something) that goes through and does pulls on all the repos
** alternatively pull the ext repos as well, but that might not be an always...
* update production links on scheduling, workflow and wiki to point at the right locations (not venom any more)

=== Engage ===
* sort out import functionality from workflow
* facilities export

=== Scheduling ===
* runTI::loadProximityDistances
** currently file based, need to convert to db based - I think I started the proximity stuff somewhere
* proximity
** would be nice to have linear distance as well as drive time (minutes)
* Sort out the multiple Instructional Summary Runs
* Sort out Location processing
* runSI - see about doing schedule query further down the subcommands
** look for comments in runSI.php -> siteScheduleSection
* improving support for Advanced Juniors, Camps, Clinics
** check in with Veronica/Randy/Shirley about what that should look like
** need to sort out division designations
*** U13, U16 etc... vs 16 Under
* xfering latest datasets/settings etc...
* Add form to create samle data (from last updloaded or possibly other)
* Check for non-existent location to prevent map error
** this is for data Summer 2023-pass2
* clean up timestamp adds to schedule output
** need to verify that the new no-cache code is in all the files
* tool to clear old seasons from ftp server
** specify season from a pull down - loop over dir suffixes
* add time stamp to static site and tourn info sheets (like was done with PDFs)
* remove extra index file variations, currently there are three, and one is supporting ancient forms
* tooltip over sample data entries with description
* collapsible
** explore options for altering colors: background, text etc... easily and modularly without having to have completely separate styles
* work on having dprint/print_pre - return vs print functionality be more consistent: ie: one is true for returning, the other false to return
* Sample Data Sets
** Want to be able to save a copy of the most recent upload, rename it, and maybe even export the associated files (-ev.csv, -tm.csv, .meta) (tar? zip?), import it
* copy poolLayoutDb from tools to local dev (removed a row, I should not have).

=== Mobile ===
* fix or remove links for tournaments/games/etc...
** currently only daily schedules is correctly linked
* Sort order on epoch for daily schedules
** cover cases where there are two events in one day (rare, but it happens)
* remove or fix tournament listings on main site page
* make sure that tournament matches are in the match listings
** allow scorekeeping of those
* scorekeeper
** allow name editing?
** fix instructions (no - now)

==Auto Generated Report Data==
*It would be nice to copy the lastauto* files to the local development page...
**Not critical, but nice for testing
*web methods can get the data, but we lose the mtime...
**fetch at resetIODirectory time...
**preserve the mtime some other way for those files...
**maybe the meta file???
***That would require that we update the meta file each time we receive an entry...
***How would this work with testing/development work on the script?
*scp -p from home
**via cron from home might work
**via make target

Also need to figure out how to decide whether we should be copying this stuff and where we copy the stuff from

==2014-04 Dev thoughts==
*Mobile Prep
**resetTables during reset IO dir
**detect empty tables in mobile site and offer appropriate message
*Scheduling Processing
**consider storing php serialized objects in db for working with
*Want a general facelift to scheduling site
**HTML5 (with html5 shim for older browsers)
**CSS3
**HTML based nav menu
**More modern login/logout setup
***PHP session cookies, remember me setup
*Start working towards getting all scheduling data configured in the db
**Could feed both mobile site and a joomla module
*Change upload to import
*Incorporate the email check into the Import page
**Maybe an ajax request in a section of the page
*Maybe figure out a better way to do general progress display, old way produces lots of output (in HTML comments)..
**This would also possibly allow a way to do more of a template setup
*Consider moving scheduling into a drupal site
**Takes care of some of the role stuff I would like to do
**Or at least playing with a dev

==Scheduling v2 thoughts==
===Databases===
*access db - persistent data shared by all usyvl systems
**access
**settings?
*dynamic - data that is re-generated each time scheduling is run
**clear tables on resetIOdir
**Input data
***team report data (™)
***event report data (ev)
**derived data
***match table
**Consider saving serialized php objects across scripts???
**Want to square away the event id (evid) stuff
***Currently home and away tournaments have different evids, we need to clean that up
****Possibly establish evids for home tourns and then match away tourns to those

*static db - persistent data for scheduling
**location table - need some sort of a timestamp for new or updated entries to allow geocoding
**distance table - figure out how to manage this table that will store google distance api data between all of the sites

Development - ToDo

2023-10-31T16:08:04Z

Aaron: /* Mobile */

[[Category:Scheduling]]
== 2023 Dev ToDos ==
=== General ===
* come up with shell script (or something) that goes through and does pulls on all the repos
** alternatively pull the ext repos as well, but that might not be an always...
* update production links on scheduling, workflow and wiki to point at the right locations (not venom any more)

=== Engage ===
* sort out import functionality from workflow
* facilities export

=== Scheduling ===
* Sort out the multiple Instructional Summary Runs
* Sort out Location processing
* runSI - see about doing schedule query further down the subcommands
** look for comments in runSI.php -> siteScheduleSection
* improving support for Advanced Juniors, Camps, Clinics
** check in with Veronica/Randy/Shirley about what that should look like
** need to sort out division designations
*** U13, U16 etc... vs 16 Under
* xfering latest datasets/settings etc...
* Add form to create samle data (from last updloaded or possibly other)
* Check for non-existent location to prevent map error
** this is for data Summer 2023-pass2
* clean up timestamp adds to schedule output
** need to verify that the new no-cache code is in all the files
* tool to clear old seasons from ftp server
** specify season from a pull down - loop over dir suffixes
* add time stamp to static site and tourn info sheets (like was done with PDFs)
* remove extra index file variations, currently there are three, and one is supporting ancient forms
* tooltip over sample data entries with description
* collapsible
** explore options for altering colors: background, text etc... easily and modularly without having to have completely separate styles
* work on having dprint/print_pre - return vs print functionality be more consistent: ie: one is true for returning, the other false to return
* Sample Data Sets
** Want to be able to save a copy of the most recent upload, rename it, and maybe even export the associated files (-ev.csv, -tm.csv, .meta) (tar? zip?), import it
* copy poolLayoutDb from tools to local dev (removed a row, I should not have).

=== Mobile ===
* fix or remove links for tournaments/games/etc...
** currently only daily schedules is correctly linked
* Sort order on epoch for daily schedules
** cover cases where there are two events in one day (rare, but it happens)
* remove or fix tournament listings on main site page
* make sure that tournament matches are in the match listings
** allow scorekeeping of those
* scorekeeper
** allow name editing?
** fix instructions (no - now)

==Auto Generated Report Data==
*It would be nice to copy the lastauto* files to the local development page...
**Not critical, but nice for testing
*web methods can get the data, but we lose the mtime...
**fetch at resetIODirectory time...
**preserve the mtime some other way for those files...
**maybe the meta file???
***That would require that we update the meta file each time we receive an entry...
***How would this work with testing/development work on the script?
*scp -p from home
**via cron from home might work
**via make target

Also need to figure out how to decide whether we should be copying this stuff and where we copy the stuff from

==2014-04 Dev thoughts==
*Mobile Prep
**resetTables during reset IO dir
**detect empty tables in mobile site and offer appropriate message
*Scheduling Processing
**consider storing php serialized objects in db for working with
*Want a general facelift to scheduling site
**HTML5 (with html5 shim for older browsers)
**CSS3
**HTML based nav menu
**More modern login/logout setup
***PHP session cookies, remember me setup
*Start working towards getting all scheduling data configured in the db
**Could feed both mobile site and a joomla module
*Change upload to import
*Incorporate the email check into the Import page
**Maybe an ajax request in a section of the page
*Maybe figure out a better way to do general progress display, old way produces lots of output (in HTML comments)..
**This would also possibly allow a way to do more of a template setup
*Consider moving scheduling into a drupal site
**Takes care of some of the role stuff I would like to do
**Or at least playing with a dev

==Scheduling v2 thoughts==
===Databases===
*access db - persistent data shared by all usyvl systems
**access
**settings?
*dynamic - data that is re-generated each time scheduling is run
**clear tables on resetIOdir
**Input data
***team report data (™)
***event report data (ev)
**derived data
***match table
**Consider saving serialized php objects across scripts???
**Want to square away the event id (evid) stuff
***Currently home and away tournaments have different evids, we need to clean that up
****Possibly establish evids for home tourns and then match away tourns to those

*static db - persistent data for scheduling
**location table - need some sort of a timestamp for new or updated entries to allow geocoding
**distance table - figure out how to manage this table that will store google distance api data between all of the sites

Development - ToDo

2023-10-31T16:07:14Z

Aaron: /* Engage */

[[Category:Scheduling]]
== 2023 Dev ToDos ==
=== General ===
* come up with shell script (or something) that goes through and does pulls on all the repos
** alternatively pull the ext repos as well, but that might not be an always...
* update production links on scheduling, workflow and wiki to point at the right locations (not venom any more)

=== Engage ===
* sort out import functionality from workflow
* facilities export

=== Scheduling ===
* Sort out the multiple Instructional Summary Runs
* Sort out Location processing
* runSI - see about doing schedule query further down the subcommands
** look for comments in runSI.php -> siteScheduleSection
* improving support for Advanced Juniors, Camps, Clinics
** check in with Veronica/Randy/Shirley about what that should look like
** need to sort out division designations
*** U13, U16 etc... vs 16 Under
* xfering latest datasets/settings etc...
* Add form to create samle data (from last updloaded or possibly other)
* Check for non-existent location to prevent map error
** this is for data Summer 2023-pass2
* clean up timestamp adds to schedule output
** need to verify that the new no-cache code is in all the files
* tool to clear old seasons from ftp server
** specify season from a pull down - loop over dir suffixes
* add time stamp to static site and tourn info sheets (like was done with PDFs)
* remove extra index file variations, currently there are three, and one is supporting ancient forms
* tooltip over sample data entries with description
* collapsible
** explore options for altering colors: background, text etc... easily and modularly without having to have completely separate styles
* work on having dprint/print_pre - return vs print functionality be more consistent: ie: one is true for returning, the other false to return
* Sample Data Sets
** Want to be able to save a copy of the most recent upload, rename it, and maybe even export the associated files (-ev.csv, -tm.csv, .meta) (tar? zip?), import it
* copy poolLayoutDb from tools to local dev (removed a row, I should not have).

=== Mobile ===
* Sort order on epoch for daily schedules
** cover cases where there are two events in one day (rare, but it happens)
* remove or fix tournament listings on main site page
* make sure that tournament matches are in the match listings
** allow scorekeeping of those
* scorekeeper
** allow name editing?
** fix instructions (no - now)

==Auto Generated Report Data==
*It would be nice to copy the lastauto* files to the local development page...
**Not critical, but nice for testing
*web methods can get the data, but we lose the mtime...
**fetch at resetIODirectory time...
**preserve the mtime some other way for those files...
**maybe the meta file???
***That would require that we update the meta file each time we receive an entry...
***How would this work with testing/development work on the script?
*scp -p from home
**via cron from home might work
**via make target

Also need to figure out how to decide whether we should be copying this stuff and where we copy the stuff from

==2014-04 Dev thoughts==
*Mobile Prep
**resetTables during reset IO dir
**detect empty tables in mobile site and offer appropriate message
*Scheduling Processing
**consider storing php serialized objects in db for working with
*Want a general facelift to scheduling site
**HTML5 (with html5 shim for older browsers)
**CSS3
**HTML based nav menu
**More modern login/logout setup
***PHP session cookies, remember me setup
*Start working towards getting all scheduling data configured in the db
**Could feed both mobile site and a joomla module
*Change upload to import
*Incorporate the email check into the Import page
**Maybe an ajax request in a section of the page
*Maybe figure out a better way to do general progress display, old way produces lots of output (in HTML comments)..
**This would also possibly allow a way to do more of a template setup
*Consider moving scheduling into a drupal site
**Takes care of some of the role stuff I would like to do
**Or at least playing with a dev

==Scheduling v2 thoughts==
===Databases===
*access db - persistent data shared by all usyvl systems
**access
**settings?
*dynamic - data that is re-generated each time scheduling is run
**clear tables on resetIOdir
**Input data
***team report data (™)
***event report data (ev)
**derived data
***match table
**Consider saving serialized php objects across scripts???
**Want to square away the event id (evid) stuff
***Currently home and away tournaments have different evids, we need to clean that up
****Possibly establish evids for home tourns and then match away tourns to those

*static db - persistent data for scheduling
**location table - need some sort of a timestamp for new or updated entries to allow geocoding
**distance table - figure out how to manage this table that will store google distance api data between all of the sites

2023-Hours-Log

2023-10-21T20:32:42Z

Aaron: /* 2023-10 */

== 2023 ==
=== 2023-10 ===
==== 2023-10-20 - Aaron Martin - 4.0h ====
* workflow:1.0h:import of engage export
* workflow:1.0h:work on UI/UX of the file import listing, adding management (deletion with confirmation and followup message)
* workflow:0.5h:error reporting on import process
* workflow:1.0h:data structure, framework for import
==== 2023-10-18 - Aaron Martin - 3.5h ====
* workflow:0.5h:incorporate PhpSpreadsheet into workflow to allow importing of xlsx files
* workflow:1.5h:implement uploading xlsx files and partially implement actual reading of data into
* workflow:1.0:implement revamped versioning setup like in scheduling
* portal:0.5h:implement revamped versioning setup like in scheduling
* scheduling:
==== 2023-10-16 - Aaron Martin - 4.0h ====
* scheduling:3h:Fix broken support for various divisions/netheight handling
* scheduling:1h:revamp versioning setup, now using .git files, so a commit updates automatically. Implement listing branch and commit hash on landing page.
==== 2023-10-06 - Aaron Martin - 2.0h ====
* scheduling:2h:implement support for uploading PDF files

=== 2023-09 ===
==== 2023-09-28 - Aaron Martin - 2.0h ====
* scheduling:1.5h:incorporate assistant coach field from engage (unsupported by previous backends) and set coach field from asstcoach field if coach field is empty. required adding support in a number of files.
* scheduling:0.5h:resolve issue with wrong google api key being used

==== 2023-09-25 - Aaron Martin - 0.75h ====
* scheduling:0.25h:update rules pdf file
* scheduling:0.5h:resolve issue with season name parsing

==== 2023-09-21 - Aaron Martin - ?.?h ====
==== 2023-09-18 - Aaron Martin - ?.?h ====

==== 2023-09-12 - Aaron Martin - 2.5h ====
* workflow:1.75h:demo workflow functionality
* workflow:0.25h:minor code fixes for schedules
* scheduling:0.5h:fix some issues with schedules output, SI pages index file, etc...

==== 2023-09-10 - Aaron Martin - 3.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:0.5:styling fixes, cleanup, neatening
* workflow:1.5h:siteinfo shell script to manage some imports/updates from engage export file
* workflow:0.5h:data harvesting, importing, updating for Fall 2023

==== 2023-09-09 - Aaron Martin - 4.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:1h:styling fixes, cleanup, neatening
* workflow:2h:data harvesting from xls spreadsheet and imports to db for Fall 2023
* workflow:0.5h:resolve some dbh issues that was blocking event table clearing

=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-22 ====
* portal:0.5h:extracting wiki version if underneath

==== 2023-06-21 ====
* portal:0.5h:futzing with formatting of display, "tab" stops

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

=== 2023-05 ===
==== 2023-05-31 -- Aaron Martin -- 1.0h ====
* portal:1.0h:restructure repo so that there is a public_html folder under the repo, futzing with sym links
==== 2023-05-30 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Work on getting versions into link tables
==== 2023-05-18 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, refinement. Catching some edge cases
==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working
==== 2023-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

2023-Hours-Log

2023-10-18T21:58:00Z

Aaron: /* 2023-10 */

== 2023 ==
=== 2023-10 ===
==== 2023-10-18 - Aaron Martin - 3.5h ====
* workflow:0.5h:incorporate PhpSpreadsheet into workflow to allow importing of xlsx files
* workflow:1.5h:implement uploading xlsx files and partially implement actual reading of data into
* workflow:1.0:implement revamped versioning setup like in scheduling
* portal:0.5h:implement revamped versioning setup like in scheduling
* scheduling:
==== 2023-10-16 - Aaron Martin - 4.0h ====
* scheduling:3h:Fix broken support for various divisions/netheight handling
* scheduling:1h:revamp versioning setup, now using .git files, so a commit updates automatically. Implement listing branch and commit hash on landing page.
==== 2023-10-06 - Aaron Martin - 2.0h ====
* scheduling:2h:implement support for uploading PDF files

=== 2023-09 ===
==== 2023-09-28 - Aaron Martin - 2.0h ====
* scheduling:1.5h:incorporate assistant coach field from engage (unsupported by previous backends) and set coach field from asstcoach field if coach field is empty. required adding support in a number of files.
* scheduling:0.5h:resolve issue with wrong google api key being used

==== 2023-09-25 - Aaron Martin - 0.75h ====
* scheduling:0.25h:update rules pdf file
* scheduling:0.5h:resolve issue with season name parsing

==== 2023-09-21 - Aaron Martin - ?.?h ====
==== 2023-09-18 - Aaron Martin - ?.?h ====

==== 2023-09-12 - Aaron Martin - 2.5h ====
* workflow:1.75h:demo workflow functionality
* workflow:0.25h:minor code fixes for schedules
* scheduling:0.5h:fix some issues with schedules output, SI pages index file, etc...

==== 2023-09-10 - Aaron Martin - 3.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:0.5:styling fixes, cleanup, neatening
* workflow:1.5h:siteinfo shell script to manage some imports/updates from engage export file
* workflow:0.5h:data harvesting, importing, updating for Fall 2023

==== 2023-09-09 - Aaron Martin - 4.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:1h:styling fixes, cleanup, neatening
* workflow:2h:data harvesting from xls spreadsheet and imports to db for Fall 2023
* workflow:0.5h:resolve some dbh issues that was blocking event table clearing

=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-22 ====
* portal:0.5h:extracting wiki version if underneath

==== 2023-06-21 ====
* portal:0.5h:futzing with formatting of display, "tab" stops

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

=== 2023-05 ===
==== 2023-05-31 -- Aaron Martin -- 1.0h ====
* portal:1.0h:restructure repo so that there is a public_html folder under the repo, futzing with sym links
==== 2023-05-30 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Work on getting versions into link tables
==== 2023-05-18 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, refinement. Catching some edge cases
==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working
==== 2023-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

2023-Hours-Log

2023-10-18T21:57:09Z

Aaron: /* 2023 */

== 2023 ==
=== 2023-10 ===
==== 2023-10-18 - Aaron Martin - 2.0h ====
* workflow:0.5h:incorporate PhpSpreadsheet into workflow to allow importing of xlsx files
* workflow:1.5h:implement uploading xlsx files and partially implement actual reading of data into
* workflow:1.0:implement revamped versioning setup like in scheduling
* portal:0.5h:implement revamped versioning setup like in scheduling
* scheduling:
==== 2023-10-16 - Aaron Martin - 2.0h ====
* scheduling::Fix broken support for various divisions/netheight handling
* scheduling:1h:revamp versioning setup, now using .git files, so a commit updates automatically. Implement listing branch and commit hash on landing page.
==== 2023-10-06 - Aaron Martin - 2.0h ====
* scheduling:2h:implement support for uploading PDF files

=== 2023-09 ===
==== 2023-09-28 - Aaron Martin - 2.0h ====
* scheduling:1.5h:incorporate assistant coach field from engage (unsupported by previous backends) and set coach field from asstcoach field if coach field is empty. required adding support in a number of files.
* scheduling:0.5h:resolve issue with wrong google api key being used

==== 2023-09-25 - Aaron Martin - 0.75h ====
* scheduling:0.25h:update rules pdf file
* scheduling:0.5h:resolve issue with season name parsing

==== 2023-09-21 - Aaron Martin - ?.?h ====
==== 2023-09-18 - Aaron Martin - ?.?h ====

==== 2023-09-12 - Aaron Martin - 2.5h ====
* workflow:1.75h:demo workflow functionality
* workflow:0.25h:minor code fixes for schedules
* scheduling:0.5h:fix some issues with schedules output, SI pages index file, etc...

==== 2023-09-10 - Aaron Martin - 3.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:0.5:styling fixes, cleanup, neatening
* workflow:1.5h:siteinfo shell script to manage some imports/updates from engage export file
* workflow:0.5h:data harvesting, importing, updating for Fall 2023

==== 2023-09-09 - Aaron Martin - 4.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:1h:styling fixes, cleanup, neatening
* workflow:2h:data harvesting from xls spreadsheet and imports to db for Fall 2023
* workflow:0.5h:resolve some dbh issues that was blocking event table clearing

=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-22 ====
* portal:0.5h:extracting wiki version if underneath

==== 2023-06-21 ====
* portal:0.5h:futzing with formatting of display, "tab" stops

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

=== 2023-05 ===
==== 2023-05-31 -- Aaron Martin -- 1.0h ====
* portal:1.0h:restructure repo so that there is a public_html folder under the repo, futzing with sym links
==== 2023-05-30 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Work on getting versions into link tables
==== 2023-05-18 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, refinement. Catching some edge cases
==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working
==== 2023-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

2023-Hours-Log

2023-09-28T20:34:52Z

Aaron: /* 2022-05-00 -- Aaron Martin -- 10.0h */

== 2023 ==
=== 2023-09 ===
==== 2023-09-28 - Aaron Martin - 2.0h ====
* scheduling:1.5h:incorporate assistant coach field from engage (unsupported by previous backends) and set coach field from asstcoach field if coach field is empty. required adding support in a number of files.
* scheduling:0.5h:resolve issue with wrong google api key being used

==== 2023-09-25 - Aaron Martin - 0.75h ====
* scheduling:0.25h:update rules pdf file
* scheduling:0.5h:resolve issue with season name parsing

==== 2023-09-12 - Aaron Martin - 2.5h ====
* workflow:1.75h:demo workflow functionality
* workflow:0.25h:minor code fixes for schedules
* scheduling:0.5h:fix some issues with schedules output, SI pages index file, etc...

==== 2023-09-10 - Aaron Martin - 3.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:0.5:styling fixes, cleanup, neatening
* workflow:1.5h:siteinfo shell script to manage some imports/updates from engage export file
* workflow:0.5h:data harvesting, importing, updating for Fall 2023

==== 2023-09-09 - Aaron Martin - 4.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:1h:styling fixes, cleanup, neatening
* workflow:2h:data harvesting from xls spreadsheet and imports to db for Fall 2023
* workflow:0.5h:resolve some dbh issues that was blocking event table clearing

=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-22 ====
* portal:0.5h:extracting wiki version if underneath

==== 2023-06-21 ====
* portal:0.5h:futzing with formatting of display, "tab" stops

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

=== 2023-05 ===
==== 2023-05-31 -- Aaron Martin -- 1.0h ====
* portal:1.0h:restructure repo so that there is a public_html folder under the repo, futzing with sym links
==== 2023-05-30 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Work on getting versions into link tables
==== 2023-05-18 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, refinement. Catching some edge cases
==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working
==== 2023-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

2023-Hours-Log

2023-09-28T20:33:54Z

Aaron: /* 2023-09-12 - Aaron Martin - 2.0h */

== 2023 ==
=== 2023-09 ===
==== 2023-09-28 - Aaron Martin - 2.0h ====
* scheduling:1.5h:incorporate assistant coach field from engage (unsupported by previous backends) and set coach field from asstcoach field if coach field is empty. required adding support in a number of files.
* scheduling:0.5h:resolve issue with wrong google api key being used

==== 2023-09-25 - Aaron Martin - 0.75h ====
* scheduling:0.25h:update rules pdf file
* scheduling:0.5h:resolve issue with season name parsing

==== 2023-09-12 - Aaron Martin - 2.5h ====
* workflow:1.75h:demo workflow functionality
* workflow:0.25h:minor code fixes for schedules
* scheduling:0.5h:fix some issues with schedules output, SI pages index file, etc...

==== 2023-09-10 - Aaron Martin - 3.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:0.5:styling fixes, cleanup, neatening
* workflow:1.5h:siteinfo shell script to manage some imports/updates from engage export file
* workflow:0.5h:data harvesting, importing, updating for Fall 2023

==== 2023-09-09 - Aaron Martin - 4.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:1h:styling fixes, cleanup, neatening
* workflow:2h:data harvesting from xls spreadsheet and imports to db for Fall 2023
* workflow:0.5h:resolve some dbh issues that was blocking event table clearing

=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-22 ====
* portal:0.5h:extracting wiki version if underneath

==== 2023-06-21 ====
* portal:0.5h:futzing with formatting of display, "tab" stops

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

=== 2023-05 ===
==== 2023-05-31 -- Aaron Martin -- 1.0h ====
* portal:1.0h:restructure repo so that there is a public_html folder under the repo, futzing with sym links
==== 2023-05-30 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Work on getting versions into link tables
==== 2023-05-18 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, refinement. Catching some edge cases
==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working
==== 2022-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

2023-Hours-Log

2023-09-28T20:33:42Z

Aaron: /* 2023-09-12 - Aaron Martin - 2.0h */

== 2023 ==
=== 2023-09 ===
==== 2023-09-28 - Aaron Martin - 2.0h ====
* scheduling:1.5h:incorporate assistant coach field from engage (unsupported by previous backends) and set coach field from asstcoach field if coach field is empty. required adding support in a number of files.
* scheduling:0.5h:resolve issue with wrong google api key being used

==== 2023-09-25 - Aaron Martin - 0.75h ====
* scheduling:0.25h:update rules pdf file
* scheduling:0.5h:resolve issue with season name parsing

==== 2023-09-12 - Aaron Martin - 2.0h ====
* workflow:1.75h:demo workflow functionality
* workflow:0.25h:minor code fixes for schedules
* scheduling:0.5h:fix some issues with schedules output, SI pages index file, etc...

==== 2023-09-10 - Aaron Martin - 3.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:0.5:styling fixes, cleanup, neatening
* workflow:1.5h:siteinfo shell script to manage some imports/updates from engage export file
* workflow:0.5h:data harvesting, importing, updating for Fall 2023

==== 2023-09-09 - Aaron Martin - 4.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:1h:styling fixes, cleanup, neatening
* workflow:2h:data harvesting from xls spreadsheet and imports to db for Fall 2023
* workflow:0.5h:resolve some dbh issues that was blocking event table clearing

=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-22 ====
* portal:0.5h:extracting wiki version if underneath

==== 2023-06-21 ====
* portal:0.5h:futzing with formatting of display, "tab" stops

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

=== 2023-05 ===
==== 2023-05-31 -- Aaron Martin -- 1.0h ====
* portal:1.0h:restructure repo so that there is a public_html folder under the repo, futzing with sym links
==== 2023-05-30 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Work on getting versions into link tables
==== 2023-05-18 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, refinement. Catching some edge cases
==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working
==== 2022-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

2023-Hours-Log

2023-09-28T20:31:29Z

Aaron: /* 2023-09-28 - Aaron Martin - 2.0h */

== 2023 ==
=== 2023-09 ===
==== 2023-09-28 - Aaron Martin - 2.0h ====
* scheduling:1.5h:incorporate assistant coach field from engage (unsupported by previous backends) and set coach field from asstcoach field if coach field is empty. required adding support in a number of files.
* scheduling:0.5h:resolve issue with wrong google api key being used

==== 2023-09-25 - Aaron Martin - 0.75h ====
* scheduling:0.25h:update rules pdf file
* scheduling:0.5h:resolve issue with season name parsing

==== 2023-09-12 - Aaron Martin - 2.0h ====
* workflow:1.75h:demo workflow functionality
* workflow:0.25h:minor code fixes for schedules

==== 2023-09-10 - Aaron Martin - 3.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:0.5:styling fixes, cleanup, neatening
* workflow:1.5h:siteinfo shell script to manage some imports/updates from engage export file
* workflow:0.5h:data harvesting, importing, updating for Fall 2023

==== 2023-09-09 - Aaron Martin - 4.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:1h:styling fixes, cleanup, neatening
* workflow:2h:data harvesting from xls spreadsheet and imports to db for Fall 2023
* workflow:0.5h:resolve some dbh issues that was blocking event table clearing

=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-22 ====
* portal:0.5h:extracting wiki version if underneath

==== 2023-06-21 ====
* portal:0.5h:futzing with formatting of display, "tab" stops

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

=== 2023-05 ===
==== 2023-05-31 -- Aaron Martin -- 1.0h ====
* portal:1.0h:restructure repo so that there is a public_html folder under the repo, futzing with sym links
==== 2023-05-30 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Work on getting versions into link tables
==== 2023-05-18 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, refinement. Catching some edge cases
==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working
==== 2022-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

2023-Hours-Log

2023-09-28T20:29:20Z

Aaron: /* 2023-09-28 - Aaron Martin - 2.0h */

== 2023 ==
=== 2023-09 ===
==== 2023-09-28 - Aaron Martin - 2.0h ====
* scheduling:1.5h:incorporate assistant coach field from engage (unsupported by previous backends) and set coach field from asstcoach field if coach field is empty. required adding support in a number of files.
* scheduling:0.5h:resolve issue with wrong google api key being used

==== 2023-09-12 - Aaron Martin - 2.0h ====
* workflow:1.75h:demo workflow functionality
* workflow:0.25h:minor code fixes for schedules

==== 2023-09-10 - Aaron Martin - 3.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:0.5:styling fixes, cleanup, neatening
* workflow:1.5h:siteinfo shell script to manage some imports/updates from engage export file
* workflow:0.5h:data harvesting, importing, updating for Fall 2023

==== 2023-09-09 - Aaron Martin - 4.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:1h:styling fixes, cleanup, neatening
* workflow:2h:data harvesting from xls spreadsheet and imports to db for Fall 2023
* workflow:0.5h:resolve some dbh issues that was blocking event table clearing

=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-22 ====
* portal:0.5h:extracting wiki version if underneath

==== 2023-06-21 ====
* portal:0.5h:futzing with formatting of display, "tab" stops

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

=== 2023-05 ===
==== 2023-05-31 -- Aaron Martin -- 1.0h ====
* portal:1.0h:restructure repo so that there is a public_html folder under the repo, futzing with sym links
==== 2023-05-30 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Work on getting versions into link tables
==== 2023-05-18 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, refinement. Catching some edge cases
==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working
==== 2022-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

2023-Hours-Log

2023-09-28T20:28:38Z

Aaron: /* 2023-09-12 - Aaron Martin - 2.0h */

== 2023 ==
=== 2023-09 ===
==== 2023-09-28 - Aaron Martin - 2.0h ====
* scheduling:1.5h:incorporate assistant coach field from engage (unsupported by previous backends) and set coach field from asstcoach field if coach field is empty.
* scheduling:0.5h:resolve issue with wrong google api key being used

==== 2023-09-12 - Aaron Martin - 2.0h ====
* workflow:1.75h:demo workflow functionality
* workflow:0.25h:minor code fixes for schedules

==== 2023-09-10 - Aaron Martin - 3.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:0.5:styling fixes, cleanup, neatening
* workflow:1.5h:siteinfo shell script to manage some imports/updates from engage export file
* workflow:0.5h:data harvesting, importing, updating for Fall 2023

==== 2023-09-09 - Aaron Martin - 4.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:1h:styling fixes, cleanup, neatening
* workflow:2h:data harvesting from xls spreadsheet and imports to db for Fall 2023
* workflow:0.5h:resolve some dbh issues that was blocking event table clearing

=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-22 ====
* portal:0.5h:extracting wiki version if underneath

==== 2023-06-21 ====
* portal:0.5h:futzing with formatting of display, "tab" stops

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

=== 2023-05 ===
==== 2023-05-31 -- Aaron Martin -- 1.0h ====
* portal:1.0h:restructure repo so that there is a public_html folder under the repo, futzing with sym links
==== 2023-05-30 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Work on getting versions into link tables
==== 2023-05-18 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, refinement. Catching some edge cases
==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working
==== 2022-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

2023-Hours-Log

2023-09-13T16:11:17Z

Aaron: /* 2023-09 */

== 2023 ==
=== 2023-09 ===
==== 2023-09-12 - Aaron Martin - 2.0h ====
* workflow:1.75h:demo workflow functionality
* workflow:0.25h:minor code fixes for schedules
==== 2023-09-10 - Aaron Martin - 3.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:0.5:styling fixes, cleanup, neatening
* workflow:1.5h:siteinfo shell script to manage some imports/updates from engage export file
* workflow:0.5h:data harvesting, importing, updating for Fall 2023

==== 2023-09-09 - Aaron Martin - 4.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:1h:styling fixes, cleanup, neatening
* workflow:2h:data harvesting from xls spreadsheet and imports to db for Fall 2023
* workflow:0.5h:resolve some dbh issues that was blocking event table clearing

=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-22 ====
* portal:0.5h:extracting wiki version if underneath

==== 2023-06-21 ====
* portal:0.5h:futzing with formatting of display, "tab" stops

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

=== 2023-05 ===
==== 2023-05-31 -- Aaron Martin -- 1.0h ====
* portal:1.0h:restructure repo so that there is a public_html folder under the repo, futzing with sym links
==== 2023-05-30 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Work on getting versions into link tables
==== 2023-05-18 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, refinement. Catching some edge cases
==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working
==== 2022-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

Main Page

2023-09-10T22:52:33Z

Aaron: /* Workflow System */

== USYVL Development Wiki ==
Fresh wiki install. Will start porting content over manually.

Consult the [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents User's Guide] for information on using the wiki software.

[[Category:General]]
[[Category:Scheduling]]
[[Category:Workflow]]
==USYVL Development Wiki==
This private wiki was created on 2011-10-10 and is designed to track/document development and deployment of the USYVL Software Systems initially developed by [[User:Aaron|Aaron Martin]].
[[Overview of Services under Rainier]].

The major development efforts are described in the following sections:

===[[:Category:Scheduling|Scheduling System]]===
This was the system originally developed in 200? by Aaron Martin to:
*make the pool and game sheets look more professional
*reduce the man hours that USYVL staff spent creating the sheets by hand
*streamline and automate the process of creating the intrasite and intersite game schedules

===[[:Category:Workflow|Workflow System]]===
This was a system that started out as a quick attempt at finding a more customized way to track all the Site/Program tasks that need to happen over the course of a season. The idea
was to get away from the shared Excel spreadsheet that was being used and transition to something with a database to allow tracking tasks and producing reports.

While it has not yet been used for its original purpose, the system has ended up being incredibly useful for a few other tasks that other backend systems do not cover well:
* Organizing season wide intersite tournament schedules - when one site hosts one or more other usyvl sites for a tournament.
* Automating creation of the initial event list to import into Rainier software.

For a couple seasons in about 2009, it took on a more pivotal role when the Rainier system was dropped for some business related issues, producing confirmation letters and being the primary source of Program/Site data for USYVL.

Currently (2023) we are looking at using workflow to generate "Important Dates" for the current backend system, Engage. Some of the challenges here:
* Program/Site ids change each season as they are entered
** so there is no carryover
** no clean way to get those ids without having "Important Dates" already entered.
*** another report or some automated way to pull the data would be handy.
* facilities do stay stable

===Donation System===
The purpose of this system was to automate creation of a Donor's page for the original USYVL static web site using data from the CMI Admin tool.
Since migrating http://www.usyvl.org to the Joomla website, this is done differently, so this is not longer under active development.

===[[:Category:YouthVB|YouthVB website]]===
This is a data driven feeder website for USYVL. It is a php driven system that produces data driven pages based on the subdomain requested (ie: california.youthvolleyball.com). The same data (and some shared code) drives the location portion of the main usyvl site.

===[[:Category:Mobile|Mobile website]]===
This is the mobile presence for USYVL.

== Getting started ==
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Configuration settings list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/postorius/lists/mediawiki-announce.lists.wikimedia.org/ MediaWiki release mailing list]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Localise MediaWiki for your language]
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Learn how to combat spam on your wiki]

2023-Hours-Log

2023-09-10T22:39:40Z

Aaron: /* 2023-09 */

== 2023 ==
=== 2023-09 ===
==== 2023-09-10 - Aaron Martin - 3.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:0.5:styling fixes, cleanup, neatening
* workflow:1.5h:siteinfo shell script to manage some imports/updates from engage export file
* workflow:0.5h:data harvesting, importing, updating for Fall 2023

==== 2023-09-09 - Aaron Martin - 4.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:1h:styling fixes, cleanup, neatening
* workflow:2h:data harvesting from xls spreadsheet and imports to db for Fall 2023
* workflow:0.5h:resolve some dbh issues that was blocking event table clearing

=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-22 ====
* portal:0.5h:extracting wiki version if underneath

==== 2023-06-21 ====
* portal:0.5h:futzing with formatting of display, "tab" stops

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

=== 2023-05 ===
==== 2023-05-31 -- Aaron Martin -- 1.0h ====
* portal:1.0h:restructure repo so that there is a public_html folder under the repo, futzing with sym links
==== 2023-05-30 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Work on getting versions into link tables
==== 2023-05-18 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, refinement. Catching some edge cases
==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working
==== 2022-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

2023-Hours-Log

2023-09-10T00:27:06Z

Aaron: /* 2023-09-09 - Aaron Martin - 6h */

== 2023 ==
=== 2023-09 ===
==== 2023-09-09 - Aaron Martin - 4.5h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:1h:styling fixes, cleanup, neatening
* workflow:2h:data harvesting from xls spreadsheet and imports to db for Fall 2023
* workflow:0.5h:resolve some dbh issues that was blocking event table clearing

=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-22 ====
* portal:0.5h:extracting wiki version if underneath

==== 2023-06-21 ====
* portal:0.5h:futzing with formatting of display, "tab" stops

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

=== 2023-05 ===
==== 2023-05-31 -- Aaron Martin -- 1.0h ====
* portal:1.0h:restructure repo so that there is a public_html folder under the repo, futzing with sym links
==== 2023-05-30 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Work on getting versions into link tables
==== 2023-05-18 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, refinement. Catching some edge cases
==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working
==== 2022-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

2023-Hours-Log

2023-09-10T00:24:01Z

Aaron: /* 2023-09-09 - Aaron Martin - 6h */

== 2023 ==
=== 2023-09 ===
==== 2023-09-09 - Aaron Martin - 6h ====
* workflow:1h:code fixes to resolve errors, updates for php-8.x
* workflow:1h:styling fixes, cleanup, neatening
* workflow:2h:data harvesting from xls spreadsheet and imports to db for Fall 2023
* workflow:0.5h:resolve some dbh issues that was blocking event table clearing

=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-22 ====
* portal:0.5h:extracting wiki version if underneath

==== 2023-06-21 ====
* portal:0.5h:futzing with formatting of display, "tab" stops

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

=== 2023-05 ===
==== 2023-05-31 -- Aaron Martin -- 1.0h ====
* portal:1.0h:restructure repo so that there is a public_html folder under the repo, futzing with sym links
==== 2023-05-30 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Work on getting versions into link tables
==== 2023-05-18 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, refinement. Catching some edge cases
==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working
==== 2022-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

2023-Hours-Log

2023-09-10T00:22:01Z

Aaron: /* 2023 */

== 2023 ==
=== 2023-09 ===
==== 2023-09-09 - Aaron Martin - 6h ====
* workflow:1h:code fixes to resolve errors
* workflow:1h:styling fixes, cleanup, neatening
* workflow:2h:data harvesting from xls spreadsheet and imports to db for Fall 2023

=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-22 ====
* portal:0.5h:extracting wiki version if underneath

==== 2023-06-21 ====
* portal:0.5h:futzing with formatting of display, "tab" stops

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

=== 2023-05 ===
==== 2023-05-31 -- Aaron Martin -- 1.0h ====
* portal:1.0h:restructure repo so that there is a public_html folder under the repo, futzing with sym links
==== 2023-05-30 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Work on getting versions into link tables
==== 2023-05-18 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, refinement. Catching some edge cases
==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working
==== 2022-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

2023-Hours-Log

2023-07-08T00:10:08Z

Aaron: /* 2023-05 */

== 2023 ==
=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-22 ====
* portal:0.5h:extracting wiki version if underneath

==== 2023-06-21 ====
* portal:0.5h:futzing with formatting of display, "tab" stops

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

=== 2023-05 ===
==== 2023-05-31 -- Aaron Martin -- 1.0h ====
* portal:1.0h:restructure repo so that there is a public_html folder under the repo, futzing with sym links
==== 2023-05-30 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Work on getting versions into link tables
==== 2023-05-18 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, refinement. Catching some edge cases
==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working
==== 2022-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

2023-Hours-Log

2023-07-08T00:09:06Z

Aaron: /* 2023 */

== 2023 ==
=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-22 ====
* portal:0.5h:extracting wiki version if underneath

==== 2023-06-21 ====
* portal:0.5h:futzing with formatting of display, "tab" stops

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

=== 2023-05 ===
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working

==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working

==== 2023-05-18 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, refinement. Catching some edge cases

==== 2023-05-30 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Work on getting versions into link tables

==== 2023-05-31 -- Aaron Martin -- 1.0h ====
* portal:1.0h:restructure repo so that there is a public_html folder under the repo, futzing with sym links

==== 2022-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

2023-Hours-Log

2023-07-08T00:08:29Z

Aaron: /* 2023-06-20 */

== 2023 ==
=== 2023-05 ===
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working

==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working

==== 2023-05-18 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, refinement. Catching some edge cases

==== 2023-05-30 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Work on getting versions into link tables

==== 2023-05-31 -- Aaron Martin -- 1.0h ====
* portal:1.0h:restructure repo so that there is a public_html folder under the repo, futzing with sym links

==== 2022-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-22 ====
* portal:0.5h:extracting wiki version if underneath

==== 2023-06-21 ====
* portal:0.5h:futzing with formatting of display, "tab" stops

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

2023-Hours-Log

2023-07-08T00:05:34Z

Aaron: /* 2023-05 */

== 2023 ==
=== 2023-05 ===
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working

==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working

==== 2023-05-18 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, refinement. Catching some edge cases

==== 2023-05-30 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Work on getting versions into link tables

==== 2023-05-31 -- Aaron Martin -- 1.0h ====
* portal:1.0h:restructure repo so that there is a public_html folder under the repo, futzing with sym links

==== 2022-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

2023-Hours-Log

2023-07-08T00:01:25Z

Aaron: /* 2023-05 */

== 2023 ==
=== 2023-05 ===
==== 2023-05-14 -- Aaron Martin -- 0.75h ====
* portal:0.75h:Updates to portal code, getting it working

==== 2023-05-16 -- Aaron Martin -- 0.5h ====
* portal:0.5h:Updates to portal code, getting it working

==== 2022-05-00 -- Aaron Martin -- 10.0h ====
* scheduling:1.0h:updating php code for php-8.1
* workflow:1.0h:updating php code for php-8.1
* wiki:1.0h:update mediawiki to 1.34.4
* maybe have wiki up to 1.35.8 now - or not hhhmmmm spotty - OK, modify to add wgMessageCacheType = CACHE_NONE
* maybe have wiki up to 1.38.4 now - hopefully memcache issues and other are resolved - menu fonts get bigger at times. During edit they are OK - seems sporadic, so may be nothing

=== 2023-06 ===
==== 2023-06-00 - Aaron Martin - 12h ====
* portal:2h:restructuring of portal code, improvements (adding versioning, etc...), porting to php-8.2.x
* scheduling:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* workflow:2h:move scheduling from UCSB to linode, get setup and conf worked out, some code updates to make that more transferrable
* scheduling:3h:restructuring code so that docroot is one level down, will leverage symlinks to move things under
* mwf:1h:add mwf install to linode as mwf8.usyvl.org, initial setup and config
* mobile:1h:move mobile to linode, initial setup and config
* mobile:1h:restructuring code so that docroot is one level down, will leverage symlinks to move things under

==== 2023-06-20 ====
* wiki:2h:move wiki from UCSB to linode. Fresh install of mediawiki-1.39.3. Export/Import pages. Add Green_check.png back in (different than before). Setup Template for '''<nowiki>{{done}}</nowiki>''' using checkmark.

Development - ToDo

2023-07-04T01:50:33Z

Aaron: /* Scheduling */

[[Category:Scheduling]]
== 2023 Dev ToDos ==
=== General ===
* come up with shell script (or something) that goes through and does pulls on all the repos
** alternatively pull the ext repos as well, but that might not be an always...
* update production links on scheduling, workflow and wiki to point at the right locations (not venom any more)

=== Engage ===
* sort out import functionality from workflow

=== Scheduling ===
* Sort out the multiple Instructional Summary Runs
* Sort out Location processing
* runSI - see about doing schedule query further down the subcommands
** look for comments in runSI.php -> siteScheduleSection
* improving support for Advanced Juniors, Camps, Clinics
** check in with Veronica/Randy/Shirley about what that should look like
** need to sort out division designations
*** U13, U16 etc... vs 16 Under
* xfering latest datasets/settings etc...
* Add form to create samle data (from last updloaded or possibly other)
* Check for non-existent location to prevent map error
** this is for data Summer 2023-pass2
* clean up timestamp adds to schedule output
** need to verify that the new no-cache code is in all the files
* tool to clear old seasons from ftp server
** specify season from a pull down - loop over dir suffixes
* add time stamp to static site and tourn info sheets (like was done with PDFs)
* remove extra index file variations, currently there are three, and one is supporting ancient forms
* tooltip over sample data entries with description
* collapsible
** explore options for altering colors: background, text etc... easily and modularly without having to have completely separate styles
* work on having dprint/print_pre - return vs print functionality be more consistent: ie: one is true for returning, the other false to return
* Sample Data Sets
** Want to be able to save a copy of the most recent upload, rename it, and maybe even export the associated files (-ev.csv, -tm.csv, .meta) (tar? zip?), import it
* copy poolLayoutDb from tools to local dev (removed a row, I should not have).

=== Mobile ===
* Sort order on epoch for daily schedules
** cover cases where there are two events in one day (rare, but it happens)
* remove or fix tournament listings on main site page
* make sure that tournament matches are in the match listings
** allow scorekeeping of those
* scorekeeper
** allow name editing?
** fix instructions (no - now)

==Auto Generated Report Data==
*It would be nice to copy the lastauto* files to the local development page...
**Not critical, but nice for testing
*web methods can get the data, but we lose the mtime...
**fetch at resetIODirectory time...
**preserve the mtime some other way for those files...
**maybe the meta file???
***That would require that we update the meta file each time we receive an entry...
***How would this work with testing/development work on the script?
*scp -p from home
**via cron from home might work
**via make target

Also need to figure out how to decide whether we should be copying this stuff and where we copy the stuff from

==2014-04 Dev thoughts==
*Mobile Prep
**resetTables during reset IO dir
**detect empty tables in mobile site and offer appropriate message
*Scheduling Processing
**consider storing php serialized objects in db for working with
*Want a general facelift to scheduling site
**HTML5 (with html5 shim for older browsers)
**CSS3
**HTML based nav menu
**More modern login/logout setup
***PHP session cookies, remember me setup
*Start working towards getting all scheduling data configured in the db
**Could feed both mobile site and a joomla module
*Change upload to import
*Incorporate the email check into the Import page
**Maybe an ajax request in a section of the page
*Maybe figure out a better way to do general progress display, old way produces lots of output (in HTML comments)..
**This would also possibly allow a way to do more of a template setup
*Consider moving scheduling into a drupal site
**Takes care of some of the role stuff I would like to do
**Or at least playing with a dev

==Scheduling v2 thoughts==
===Databases===
*access db - persistent data shared by all usyvl systems
**access
**settings?
*dynamic - data that is re-generated each time scheduling is run
**clear tables on resetIOdir
**Input data
***team report data (™)
***event report data (ev)
**derived data
***match table
**Consider saving serialized php objects across scripts???
**Want to square away the event id (evid) stuff
***Currently home and away tournaments have different evids, we need to clean that up
****Possibly establish evids for home tourns and then match away tourns to those

*static db - persistent data for scheduling
**location table - need some sort of a timestamp for new or updated entries to allow geocoding
**distance table - figure out how to manage this table that will store google distance api data between all of the sites

MediaWiki:Sidebar

2023-07-03T23:10:22Z

Aaron:

Development - ToDo

2023-07-03T23:09:52Z

Aaron: Aaron moved page Scheduling-ToDo to Development - ToDo without leaving a redirect

[[Category:Scheduling]]
== 2023 Dev ToDos ==
=== General ===
* come up with shell script (or something) that goes through and does pulls on all the repos
** alternatively pull the ext repos as well, but that might not be an always...
* update production links on scheduling, workflow and wiki to point at the right locations (not venom any more)

=== Engage ===
* sort out import functionality from workflow

=== Scheduling ===
* Sort out the multiple Instructional Summary Runs
* Sort out Location processing
* runSI - see about doing schedule query further down the subcommands
** look for comments in runSI.php -> siteScheduleSection
* improving support for Advanced Juniors, Camps, Clinics
** check in with Veronica/Randy/Shirley about what that should look like
** need to sort out division designations
*** U13, U16 etc... vs 16 Under
* xfering latest datasets/settings etc...
* Add form to create samle data (from last updloaded or possibly other)
* Check for non-existent location to prevent map error
** this is for data Summer 2023-pass2
* clean up timestamp adds to schedule output
** need to verify that the new no-cache code is in all the files
* tool to clear old seasons from ftp server
** specify season from a pull down - loop over dir suffixes
* add time stamp to static site and tourn info sheets (like was done with PDFs)
* remove extra index file variations, currently there are three, and one is supporting ancient forms
* tooltip over sample data entries with description
* collapsible
** explore options for altering colors: background, text etc... easily and modularly without having to have completely separate styles
* work on having dprint/print_pre - return vs print functionality be more consistent: ie: one is true for returning, the other false to return
* Sample Data Sets
** Want to be able to save a copy of the most recent upload, rename it, and maybe even export the associated files (-ev.csv, -tm.csv, .meta) (tar? zip?), import it

=== Mobile ===
* Sort order on epoch for daily schedules
** cover cases where there are two events in one day (rare, but it happens)
* remove or fix tournament listings on main site page
* make sure that tournament matches are in the match listings
** allow scorekeeping of those
* scorekeeper
** allow name editing?
** fix instructions (no - now)

==Auto Generated Report Data==
*It would be nice to copy the lastauto* files to the local development page...
**Not critical, but nice for testing
*web methods can get the data, but we lose the mtime...
**fetch at resetIODirectory time...
**preserve the mtime some other way for those files...
**maybe the meta file???
***That would require that we update the meta file each time we receive an entry...
***How would this work with testing/development work on the script?
*scp -p from home
**via cron from home might work
**via make target

Also need to figure out how to decide whether we should be copying this stuff and where we copy the stuff from

==2014-04 Dev thoughts==
*Mobile Prep
**resetTables during reset IO dir
**detect empty tables in mobile site and offer appropriate message
*Scheduling Processing
**consider storing php serialized objects in db for working with
*Want a general facelift to scheduling site
**HTML5 (with html5 shim for older browsers)
**CSS3
**HTML based nav menu
**More modern login/logout setup
***PHP session cookies, remember me setup
*Start working towards getting all scheduling data configured in the db
**Could feed both mobile site and a joomla module
*Change upload to import
*Incorporate the email check into the Import page
**Maybe an ajax request in a section of the page
*Maybe figure out a better way to do general progress display, old way produces lots of output (in HTML comments)..
**This would also possibly allow a way to do more of a template setup
*Consider moving scheduling into a drupal site
**Takes care of some of the role stuff I would like to do
**Or at least playing with a dev

==Scheduling v2 thoughts==
===Databases===
*access db - persistent data shared by all usyvl systems
**access
**settings?
*dynamic - data that is re-generated each time scheduling is run
**clear tables on resetIOdir
**Input data
***team report data (™)
***event report data (ev)
**derived data
***match table
**Consider saving serialized php objects across scripts???
**Want to square away the event id (evid) stuff
***Currently home and away tournaments have different evids, we need to clean that up
****Possibly establish evids for home tourns and then match away tourns to those

*static db - persistent data for scheduling
**location table - need some sort of a timestamp for new or updated entries to allow geocoding
**distance table - figure out how to manage this table that will store google distance api data between all of the sites

Development - ToDo

2023-07-03T23:08:16Z

Aaron: /* Scheduling */

[[Category:Scheduling]]
== 2023 Dev ToDos ==
=== General ===
* come up with shell script (or something) that goes through and does pulls on all the repos
** alternatively pull the ext repos as well, but that might not be an always...
* update production links on scheduling, workflow and wiki to point at the right locations (not venom any more)

=== Engage ===
* sort out import functionality from workflow

=== Scheduling ===
* Sort out the multiple Instructional Summary Runs
* Sort out Location processing
* runSI - see about doing schedule query further down the subcommands
** look for comments in runSI.php -> siteScheduleSection
* improving support for Advanced Juniors, Camps, Clinics
** check in with Veronica/Randy/Shirley about what that should look like
** need to sort out division designations
*** U13, U16 etc... vs 16 Under
* xfering latest datasets/settings etc...
* Add form to create samle data (from last updloaded or possibly other)
* Check for non-existent location to prevent map error
** this is for data Summer 2023-pass2
* clean up timestamp adds to schedule output
** need to verify that the new no-cache code is in all the files
* tool to clear old seasons from ftp server
** specify season from a pull down - loop over dir suffixes
* add time stamp to static site and tourn info sheets (like was done with PDFs)
* remove extra index file variations, currently there are three, and one is supporting ancient forms
* tooltip over sample data entries with description
* collapsible
** explore options for altering colors: background, text etc... easily and modularly without having to have completely separate styles
* work on having dprint/print_pre - return vs print functionality be more consistent: ie: one is true for returning, the other false to return
* Sample Data Sets
** Want to be able to save a copy of the most recent upload, rename it, and maybe even export the associated files (-ev.csv, -tm.csv, .meta) (tar? zip?), import it

=== Mobile ===
* Sort order on epoch for daily schedules
** cover cases where there are two events in one day (rare, but it happens)
* remove or fix tournament listings on main site page
* make sure that tournament matches are in the match listings
** allow scorekeeping of those
* scorekeeper
** allow name editing?
** fix instructions (no - now)

==Auto Generated Report Data==
*It would be nice to copy the lastauto* files to the local development page...
**Not critical, but nice for testing
*web methods can get the data, but we lose the mtime...
**fetch at resetIODirectory time...
**preserve the mtime some other way for those files...
**maybe the meta file???
***That would require that we update the meta file each time we receive an entry...
***How would this work with testing/development work on the script?
*scp -p from home
**via cron from home might work
**via make target

Also need to figure out how to decide whether we should be copying this stuff and where we copy the stuff from

==2014-04 Dev thoughts==
*Mobile Prep
**resetTables during reset IO dir
**detect empty tables in mobile site and offer appropriate message
*Scheduling Processing
**consider storing php serialized objects in db for working with
*Want a general facelift to scheduling site
**HTML5 (with html5 shim for older browsers)
**CSS3
**HTML based nav menu
**More modern login/logout setup
***PHP session cookies, remember me setup
*Start working towards getting all scheduling data configured in the db
**Could feed both mobile site and a joomla module
*Change upload to import
*Incorporate the email check into the Import page
**Maybe an ajax request in a section of the page
*Maybe figure out a better way to do general progress display, old way produces lots of output (in HTML comments)..
**This would also possibly allow a way to do more of a template setup
*Consider moving scheduling into a drupal site
**Takes care of some of the role stuff I would like to do
**Or at least playing with a dev

==Scheduling v2 thoughts==
===Databases===
*access db - persistent data shared by all usyvl systems
**access
**settings?
*dynamic - data that is re-generated each time scheduling is run
**clear tables on resetIOdir
**Input data
***team report data (™)
***event report data (ev)
**derived data
***match table
**Consider saving serialized php objects across scripts???
**Want to square away the event id (evid) stuff
***Currently home and away tournaments have different evids, we need to clean that up
****Possibly establish evids for home tourns and then match away tourns to those

*static db - persistent data for scheduling
**location table - need some sort of a timestamp for new or updated entries to allow geocoding
**distance table - figure out how to manage this table that will store google distance api data between all of the sites

MediaWiki:Sidebar

2023-07-03T23:05:07Z

Aaron:

Development - ToDo

2023-07-02T22:56:25Z

Aaron: /* 2023 Dev ToDos */

[[Category:Scheduling]]
== 2023 Dev ToDos ==
=== General ===
* come up with shell script (or something) that goes through and does pulls on all the repos
** alternatively pull the ext repos as well, but that might not be an always...
* update production links on scheduling, workflow and wiki to point at the right locations (not venom any more)

=== Engage ===
* sort out import functionality from workflow

=== Scheduling ===
* Sort out the multiple Instructional Summary Runs
* Sort out Location processing
* runSI - see about doing schedule query further down the subcommands
** look for comments in runSI.php -> siteScheduleSection
* improving support for Advanced Juniors, Camps, Clinics
** check in with Veronica/Randy/Shirley about what that should look like
** need to sort out division designations
*** U13, U16 etc... vs 16 Under
* xfering latest datasets/settings etc...
* Add form to create samle data (from last updloaded or possibly other)
* Check for non-existent location to prevent map error
** this is for data Summer 2023-pass2
* clean up timestamp adds to schedule output
** need to verify that the new no-cache code is in all the files
* tool to clear old seasons from ftp server
** specify season from a pull down - loop over dir suffixes
* add time stamp to static site and tourn info sheets (like was done with PDFs)
* remove extra index file variations, currently there are three, and one is supporting ancient forms
* tooltip over sample data entries with description
* collapsible
** explore options for altering colors: background, text etc... easily and modularly without having to have completely separate styles
* work on having dprint/print_pre - return vs print functionality be more consistent: ie: one is true for returning, the other false to return
=== Mobile ===
* Sort order on epoch for daily schedules
** cover cases where there are two events in one day (rare, but it happens)
* remove or fix tournament listings on main site page
* make sure that tournament matches are in the match listings
** allow scorekeeping of those
* scorekeeper
** allow name editing?
** fix instructions (no - now)

==Auto Generated Report Data==
*It would be nice to copy the lastauto* files to the local development page...
**Not critical, but nice for testing
*web methods can get the data, but we lose the mtime...
**fetch at resetIODirectory time...
**preserve the mtime some other way for those files...
**maybe the meta file???
***That would require that we update the meta file each time we receive an entry...
***How would this work with testing/development work on the script?
*scp -p from home
**via cron from home might work
**via make target

Also need to figure out how to decide whether we should be copying this stuff and where we copy the stuff from

==2014-04 Dev thoughts==
*Mobile Prep
**resetTables during reset IO dir
**detect empty tables in mobile site and offer appropriate message
*Scheduling Processing
**consider storing php serialized objects in db for working with
*Want a general facelift to scheduling site
**HTML5 (with html5 shim for older browsers)
**CSS3
**HTML based nav menu
**More modern login/logout setup
***PHP session cookies, remember me setup
*Start working towards getting all scheduling data configured in the db
**Could feed both mobile site and a joomla module
*Change upload to import
*Incorporate the email check into the Import page
**Maybe an ajax request in a section of the page
*Maybe figure out a better way to do general progress display, old way produces lots of output (in HTML comments)..
**This would also possibly allow a way to do more of a template setup
*Consider moving scheduling into a drupal site
**Takes care of some of the role stuff I would like to do
**Or at least playing with a dev

==Scheduling v2 thoughts==
===Databases===
*access db - persistent data shared by all usyvl systems
**access
**settings?
*dynamic - data that is re-generated each time scheduling is run
**clear tables on resetIOdir
**Input data
***team report data (™)
***event report data (ev)
**derived data
***match table
**Consider saving serialized php objects across scripts???
**Want to square away the event id (evid) stuff
***Currently home and away tournaments have different evids, we need to clean that up
****Possibly establish evids for home tourns and then match away tourns to those

*static db - persistent data for scheduling
**location table - need some sort of a timestamp for new or updated entries to allow geocoding
**distance table - figure out how to manage this table that will store google distance api data between all of the sites

Development - ToDo

2023-06-30T22:34:27Z

Aaron: /* Scheduling */

Development - ToDo

2023-06-30T21:44:16Z

Aaron: /* Scheduling */

Development - ToDo

2023-06-30T21:43:05Z

Aaron: /* Mobile */

Development - ToDo

2023-06-30T21:42:14Z

Aaron: /* Scheduling */