We offer you the option of importing the attendance list from Force8 Coach into the National Database Sport (NDS) from Youth + Sport. This means that it is sufficient to keep a clean attendance list in Force8 Coach. There is no need to keep an additional list in the NDS.
To be able to use the attendance control export, your club needs the “Fields Configurator”.
Important: In the NDS, you (or your Y+S coach) register your offer as usual with the corresponding courses and activities. Make sure that all coaches and participants are assigned to the respective courses.
Follow this step-by-step guide to import your attendance list from Force8 Coach into the NDS.
Step 1: Set up the detailed configurator (Club Admin only)
To query the Y+S number of the coaches, the club admin must create a field for the Y+S number under CLUB – ADMINISTRATION – FIELDS CONFIGURATOR. We explain how new fields can be created in the fields configurator in the article Fields configurator.
Very important: The field must have the name “J+S Personen Nummer” and be assigned to the user type “Coach”.
All coaches can then enter their “Y+S person number” themselves in their “Coach profile” under “Club Details”. This information is mandatory for the attendance control export.
Step 2: Activities and participants
In the menu, click on ANALYSES – ADVANCED and then on J+S EXPORT. On the left, select the desired season, your user group, and the desired training group. Since the export file requires a location, you can enter a location here if it is not already stored in the activities. Finally, you can remove individual athletes from the selection if necessary.
Switch to the “Activities” tab. On the left-hand side, you will see all activities, and on the right-hand side, all participants in the selected training group. You can see at a glance which participants have not yet filled in the mandatory fields. If mandatory fields are left blank, the AWK export will not work later.
You can export both lists as CSV files to import activities and participants into the NDS.
Athletes can enter their Y+S number/personal number in their athlete profile under “Personal Details” in the “Y+S Number” field.
You can also fill in this information yourself in the respective athlete profile.
Step 3: Export presence list
Switch to the “Y+S presence list” tab at the top. All those present (participants and coaches) for all activities are displayed here.
All participants and coaches who have the event status “available” in the respective activity are marked as present. In the case of a session with several activities, the status of the first activity is used.
Click on the “CSV download icon” below the list. A CSV file with the name “awk_Name of practice group” will be saved on your computer.
Very important: The date, duration and start time of the activity in Force8 Coach must match the previously entered activity details in the Y+S NDS! Otherwise the import will not work!
You can also edit individual entries in the table at a later date. To do this, click on “Editable dataframe Y+S presence list” below the list. The same list will appear again, in which you can change each field as required. You can then also download the edited list.
Step 4: Import the attendance control into the NDS
In the NDS, go to the desired course and select the “Attendance monitoring” tab at the top. Under “Actions”, click on “Import attendance control”. In the window that appears, you can then upload the file previously exported from Force8 Coach and click on “Import”.
Very important: As the NDS always overwrites all existing attendances of a course during an import, it is important that you import the attendances of all trainings of a course TOGETHER!
The import is now complete and the attendance control in the NDS is now synchronized with the data from Force8 Coach.