https://tools.usyvl.org/wiki/index.php?action=history&feed=atom&title=2012-03-08-Teleconference 2026-05-14T13:10:36Z Revision history for this page on the wiki MediaWiki 1.39.3 https://tools.usyvl.org/wiki/index.php?title=2012-03-08-Teleconference&diff=19&oldid=prev 2023-06-21T00:25:40Z

<p>1 revision imported: Hopefully full import</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <tr class="diff-title" lang="en"> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 00:25, 21 June 2023</td> </tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div> </td></tr></table>

Aaron https://tools.usyvl.org/wiki/index.php?title=2012-03-08-Teleconference&diff=18&oldid=prev 2012-03-19T02:24:01Z

<p><span dir="auto"><span class="autocomment">Tournament Building - Grouping issue - distances are not completely reflective of distance to site</span></span></p> <p><b>New page</b></p><div>[[Category:Scheduling]]<br /> [[Category:Workflow]]<br /> <br /> ==Discussions==<br /> <br /> ==Todo==<br /> ===Scheduling===<br /> ====HTML form for doing custom game schedules====<br /> *This situation is starting to happen more often with indoor venues<br /> *Have the beginning of such a system in the Custom Game Editor - probably still needs work<br /> <br /> ====Resolve reasons for &quot;unable to resolve season&quot; messages from last uploaded file.====<br /> *&lt;s&gt;Need to copy file into a testing setup&lt;/s&gt;<br /> *&lt;s&gt;file name disagrees with data strings that we can see, but that should not be an issue &lt;/s&gt; - RESOLVED - the unicode fix was being missed<br /> <br /> ====Long team names and long Coaches names overflow the cell====<br /> *&lt;s&gt;Update code to check string length, if its longer than cell, work backwards to find where it fits and truncate there&lt;/s&gt; RESOLVED subject to review and testing<br /> *Once that is done, look into making font size a bit smaller to allow for longer names. Want to keep the font at least 12-14 if possible.<br /> **With a few column width tweaks, there are very few cases of required truncation for the fall 2011 data.<br /> <br /> ====Additional, possibly interactive, help for resolving common data problems.====<br /> *Maybe some javascript popups on hover?<br /> *Might need to implement some error/help codes to use<br /> <br /> ====Lone team in tournament division====<br /> *Merge only if there is only 1 team, threshold may be higher now, but we think this was resolved at the end of last season<br /> *Should verify that this is being done correctly<br /> <br /> ====Scheduling Page Cleanup====<br /> *&lt;s&gt;Move admin/dev scripts to their own page, no reason to have them on the front&lt;/s&gt; - RESOLVED - removed non-essential scripts to separate index page<br /> *Investigate loadRecent.php, possibly remove if this is truly not implemented and is not going to be implemented soon.<br /> <br /> ====Investigate selective activation/enabling of tournament info pages by date====<br /> *&lt;s&gt;Prevent people from downloading and printing schedules before they are ready&lt;/s&gt; - RESOLVED pending testing<br /> *Administrative staff still need access - I believe that ts.html still exists, just not linked in as it was before, could use that. Need to verify<br /> <br /> ===Workflow Tournament Building===<br /> ====Tournament Building - Grouping issue - distances are not completely reflective of distance to site====<br /> *Currently using Great Circla Path (GCP) calculations<br /> *Investigate google, yahoo or mapquest API for getting either travel distance or travel time between two location<br /> **http://code.google.com/apis/maps/documentation/distancematrix/ - this may well do it, first link that popped up in my search, appears to provide both distance and duration<br /> ***default is auto, but they have bicycle and walking!!<br /> **PHP function json_decode should help with the preferred output format (JSON)..<br /> **There are some limits for queries from individual domains. Need to to be especially careful in dev.<br /> **Need to now see how the location stuff is setup, I need to see if the structure lends itself to easy extension (adding travel distance, and duration)<br /> *Alternatively create a system for adding a distance penalty to a site pair to be more truly reflective of the real world &quot;distance&quot; between two locations.<br /> **Example are two sites separated by a mountain range... Only 7 miles apart, but a 20 mile drive to go from one to the other. <br /> ***Simi Valley, Agoura Hills<br /> =====Progress=====<br /> I have been able to use the Google distance Matrix API (// https://developers.google.com/maps/documentation/distancematrix/) to <br /> perform the calculation. But the execution time is slow, so I have to alter how I handle this. Some options:<br /> *Use a full matrix capability - I am running queries on just one src and one dst so that I get a single answer. Potentially, I can build an entire list and reduce the number of queries.<br /> **Not sure where the time lag is from though, it could be that will have little affect...<br /> *Alternatively, cache the data, and only fetch ones that have changed... <br /> **question there is how to manage that, how to key things so we know when they change... location name? Lat/Lon? Cache last run?<br /> <br /> ====Cleanup====<br /> *Move less used admin/dev tools into a separate index page</div>

Aaron