tehhowch / apps-script

A collection of files used by Google Apps Script to develop and serve data via Google Sheets
0 stars 0 forks source link

Resolve "rank regression" when HT data unavailable for members in alternate sources #15

Closed tehhowch closed 5 years ago

tehhowch commented 6 years ago

Some (all?) users with intermittent / "stale" data in Jack's FusionTable experienced a rank regression after the fix for HT 502's went in: Old values of LastSeen were submitted as new records and then propagated to the Scoreboard.

After HT came back online, visiting these profiles with the HT extension would result in the restoration of expected crowns & rank.

TODO:

MAYBE:

tehhowch commented 5 years ago

Inspection of the Rank DB shows this has happened on more occasions than the 14-16 Oct, but went unnoticed.

tehhowch commented 5 years ago

Issue is suspected to be caused by the "courtesy insert" for members who have not had data inserted in the past 7 days. Will leave this open for the next week and re-run the regression-fixer then to determine if the issue is adequately addressed.

tehhowch commented 5 years ago

Re-ran regression fixer today, no detected regressions.