Are there example files for importing registrations?

Question

I would like to import registrations from Excel. What should such a table in Excel look like? What does Athletics.app support?

This has been automatically translated into English

Answer 1

You can import different types of tables for registering athletes. We will explain two common examples here. You do not have to use the exact column sequence or column names. Athletics.app will ask you per column what you have entered there when you import the table.

Example 1 (Excel file) 

Example 2 (excel file)

You can either fill in a complete performance with which you want to register the athlete or you can put a cross (x), indicating that the athlete should be registered for that event without specifying a best performance.

This has been automatically translated into English

Comments

When working with startgroups, the system gets stuck. Please, please, try to limit yourself to the license numbers and leave the rest to us, the registrants.

This has been automatically translated into English

---

We have just implemented a small update that fixes the problem you reported. You are now no longer required to specify Startgroups during import. You can now specify them after importing the Competitors by editing each Competitor :)

This has been automatically translated into English

---

Time and time again, my registration template for the CD competition fails. An error message for a category, or an error message without any explanation.

This has been automatically translated into English

---

We have just made a small update that fixes some reported problems. Would you try again or are you sure it is working now? If not, could you please share the file you are trying to upload here (or email it to support@Athletics.app)?

This has been automatically translated into English

---

What about Belgian athletes? They don't have an AU number, do they?
Should the VAL lifenumber be entered in the first column?

This has been automatically translated into English

---

Attempted to register a list of 38 athletes, but received the following error message for each athlete: "Could not create athlete (Janssen (Jan) (123456)), specifying a member number is mandatory for this association." and "Could not create athlete (Janssen (Jan) (123456)), specifying a member number is mandatory for this association." and "Could not create athlete (Janssen (Jan) (123456)), specifying a member number is mandatory for this association." and "Could not create athlete (Janssen (Jan) (123456)), specifying a member number is mandatory for this association." and "Could not create athlete (Janssen (Jan) (123456)), specifying a member number is mandatory for this association." and "Could not create athlete (Janssen (Jan) (123456)), specifying a member number is mandatory for this association." and "Could not create athlete (Janssen (Jan3333px">Could not create athlete (Janssen (Jan) (123456)), specifying a membership number is mandatory for this club."

and 

"The license number of 'Janssen (Jan) (123456)' does not match the person in the Dutch Athletics Federation membership database. Athlete is saved without a license number."

However, the combination of license number, name, etc. is correct as soon as I enter it manually. I have no idea why it doesn't work automatically via a table, it would be very nice if it did!

This has been automatically translated into English

---

Same problem, but only with a few of the list that I enter as a whole.

This has been automatically translated into English

---

When I import a file, I get a message that it was successful, but I do not see the athletes in the registrations, which means I still have to enter each competitor manually.

This has been automatically translated into English

---

The import works fine for me... with the exception of the startgroups. That's a bummer, because now it's still a lot of manual work.

This has been automatically translated into English

---

Dear Athletics.app, I have also experienced problems with names and numbers not being correct as described by some here, maybe I am doing something wrong? In the example shared here, is it really necessary to fill in all the following fields? Name, Gender, Club. I would expect that combining the AU number and date of birth should be enough to fill in/check the rest of the information. In my opinion, this would probably also solve the problems with names. Is work still being done on adding the startgroup to the import of the xls list? That would make a big difference.

 

Yours sincerely,

Marc

 

This has been automatically translated into English