CSV Conversion Utility – Useful for ElfScore Users

We have put up a generic CSV conversion utility – https://runsignup.com/Utilities/ElfScoreConversion. As the URL implies, these conversions are particularly useful for timers using the ElfScore scoring platform to easily import runner registration information. This joins our other CSV Merge Utility. It that helps convert the following formats:

CSV Conversion

You select a file to import, then on a per field basis do the above conversions. Here is a fuller explanation:

Elfscore CSV Conversion UtilityConvert mm/dd/yyyy to 3 columns for month, day and year. This is multi-column format is something required by ElfScore, a scoring package used by some timers.

Cut Zipcode to 5 digits – this helps when your CSV contains a 08057-2434 type of format.

Convert times to seconds – 5:23 become 323 for example.

Remove non-numeric characters – this is useful for stripping off a field that might have characters on it like “RegID 123” becomes “123”.

Author: RunSignUp

RunSignUp is the leading innovator of online tools for race registration, race day solutions, and running clubs. Services include RunSignUp for registration, RunSignUp Go for Race Day, RunSignUp RD Go for Timers, RunSignUp Clubs to enable membership management, and RaceJoy for mobile experiences. More than 10,000 race directors, timers, running club officers and running stores use these services today, including leading organizations like the Boilermaker Road Race, Crim Festival of Races, Pittsburgh Three Rivers Marathon, Inc., Fifth Third River Bank Run, Blacklight Run, Bubble Run, Night Nation, Mercedes Marathon, Kentucky Derby Festival, Leone Timing, KC Running Company, Compuscore Timing, Knoxville Track Club, Pikes Peak Road Runners, Gulf Coast Runners, Columbus Running Company, Playmakers Running Store and many more. In 2015, over 10,000 races used the system to register more than 2.7 million participants. In 2016 over 14,000 races will use the system to process over 4.3 million paid registrations. Services are free except for processing fees when conducting monetary transactions such as race registration or club membership renewal. RunSignUp is founded by runners for runners, using technical capabilities to bring the power of cloud computing to benefit the running community. For more information, visit www.RunSignUp.com.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s