It is highly recommended that you use Lapio's registration. The seamless integration with Lapio's timing software reduces handling errors and saves valuable time. With that said, we understand that as race directors and timers you need flexibility when it comes to your software.
If you are not using Lapio's registration you can easily import your registration list into Lapio software.
- Go to Participants --> Action --> Import Participants
- Download the template by clicking on the tab “Download template”.
- A CSV file will open up as shown above. Here you will need to fill in all your participant information EXACTLY as stated in this tutorial. You can either cut and paste or modify your registration vendor’s exported registration CSV file to look exactly like the above. Be thorough when entering all information, as it will save you from unwanted import issues.
- This document will help you understand the names and codes of all headers: https://dl.dropboxusercontent.com/u/336059845/Particiapnt%20Upload%20Template.xls
Some helpful hints:
- Eliminate as many nonessential columns as possible.
- No blank rows in the file. You can remove a row by highlighting the row, right click, delete. For a more advanced tutorial for this can be found here: https://dl.dropboxusercontent.com/u/336059845/How%20to%20remove%20Rows%20in%20Excel%20CSV%20File.pdf
- Format entire file to be AutoFit Column Width.
- Enter proper name with ONLY first letter of first and last name in CAPITAL. All other letters have to be lower case. Help can be found here: https://dl.dropboxusercontent.com/u/336059845/Change%20Names%20to%20Proper%20Format.pdf
- First and last name have to be separated into two (2) columns as shown here: https://dl.dropboxusercontent.com/u/336059845/Excel%20-%20Splitting%20Last%20%26%20First%20Name%20into%202%20Columns.pdf
- When entering category, enter category CODE and NOT the name of your category. For example M40.
In case of an incorrect data upload or error in participant information follow below steps:
If you accidentally upload an entire participant list with the wrong category codes or another mistake you can move all participants to a “dummie” race you have created.
- Create New Event à Name it “Example: dummie/trash/moveto”.
- In your real race go to Participants à Action à Move participants to… And then select your newly created race.
- You can use the newly created “dummie” to store participant information from all your races. You only need ONE (1) “dummie” race.
Remember we move and NEVER delete information to protect your race data! By moving data instead of deleting, we can always retrieve data if needed.
The option to unconfirm a participant is a tool used for more individual occasions. For example if a participant cancels or if information has been uploaded multiple times for that one participant.
- Go to Participants à click on the “editing pen” to the right of the participant name
- At the bottom, you can choose to unconfirm the participant.
- The participant’s information will always be in the system, simply unconfirmed to this race.
If you need additional help, contact Lapio support at firstname.lastname@example.org.