This project provides a searchable database/web site containing up-to-date CTST Points Registry data. For now, the web site is hosted on GitHub Pages at: https://ctstpoints.github.io/
This project can be linked-to from the official CTST web site, https://countrytwosteptour.com/ (see https://countrytwosteptour.com/index.php/ctst-points-registry/).
Initially, only data from the legacy CTST Points Registry (dated January 14, 2020) was used, which included all CTST events up to and including the 2020 UCWDC World Championships. Subsequently, data from later CTST events has been added. Going forward, the data will be updated as soon as new Contest result data has been obtained for each Event.
DISCLAIMER: The data contained herein for events up to 2020 has been obtained from publically-accessible sources, primarily data published by the Country Two Step Tour. This data is not the “official” contest result data. The respective Event Directors and their official score-keepers maintain the “official” contest results. Therefore, expect errors and omissions in the CTST data used by this project. Going forward, the data used should be as accurate as the data provided to the CTST from the respective event directors.
This is the development repository, https://github.com/ctstpoints/ctst-dev. Other GitHub repositories are used to host web sites on GitHub Pages:
countrytwosteptour.com
web siteSummary of steps involved in creating the project:
db_tables_MASTER
) (Excel/Save As)ctstpoints\ctst-dev\generate_website\www\*
) to the production web root repository (ctstpoints\ctstpoints.github.io\
)git push
)create_csv_new
directory is used to store a CSV file for each event, from which new
Competitor IDs are assigned, files combined, then merged into the master database using PowerQuery. [README]For further detailed explanation of the steps involved, see the README files in each directory.