Forum: Event Management System

Tool to preprocess list of competitors for RRS

P
Tom Björkholm
Nationality: Sweden
Certifications:
  • National Race Officer
  • National Umpire
  • National Judge
When I use www.racingrulesofsailing.org at events I often ended up manually editing the excel file with competitors before being able to import it. The excel file I get usually have incorrect column headings, some extra columns, columns in the wrong order and telephone numbers in local/national format not in international format. If the event allows competitors to register late for the event this editing can be stressful.

To avoid this stress I have created a Python application that transforms the list of competitors as specified in a configuration file. Then I can during the week before the event ask for a list of early registered competitors to see the format of the excel list I will get. With this I can adjust the configuration file so that at the start of the event I only have to run the application on the list I receive then and import into www.racingrulesofsailing.org. I find this very useful.

If you are comfortable running a Python command line application and if you are willing to edit a configuration file (JSON text) I encourage you to try the application.
It is available at https://pypi.org/project/excel-list-transform/ . There is also a little information about how to get started using it.

Feedback is very welcome, and if I receive feedback it will help me make the next version better. 

Created: 24-Sep-11 05:40

Comments

[You must be signed in to add a comment]
Cookies help us deliver our services. By using our services, you agree to our use of cookies. Learn more