Forum: Event Management & Forum System (Q's, Comments & Suggestions)

Tool to preprocess list of competitors for RRS

P
Tom Björkholm
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

Format:
Robert Youle
Nationality: United Kingdom
Is there somewhere in RRS that you can specify the fields to be output in the Competitors List? My first attempt included both Competitors and Crew. My intention was to import into Sailwave and like you, there' a lot of editing and mapping to get rid of some fields and combine others.
Created: Today 16:17
[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