Exporting attendance

Menu Schedule & Attendance3 min read

The "Export" menu
  1. Exportin the toolbar.
  2. To Excelthe attendance table.
  3. To J+Sthe two files for the BDNS of Youth+Sport, for Swiss clubs.

To Excel

The "Export to Excel" window
  1. From and Tothe period, by default the month displayed in the calendar.
  2. Exportdownloads the file.

The table has one row per person and one column per session whose attendance list has been opened: 1 for present, 0 for absent. The last row adds up the present of each session.

To J+S

The J+S export prepares the files for the BDNS, the national sports database. It requires three preparations:

  • the club is Swiss and the Club affiliated to J+S box is ticked in Settings › General settings;
  • each event of the course carries its code in J+S course;
  • each member of the course, coaches included, has their J+S number on their record (chapter 3: Contacts).
The "Export to Youth & Sport" window
  1. J+S coursethe course to export, among the codes entered in the events.
  2. From and Tothe period exported.
  3. Activitiesthe first file: one row per session of the course, with the date, the time, the duration and the location.
  4. Attendancethe second file: one row per person marked Present, with their J+S number. The coaches appear in it as instructors.

In the BDNS, import in this order: the people, with the J+S export from Contacts (chapter 3: Exporting contacts, part "Exporting to J+S"), then the activities file in the course's activity planning tab, and finally the attendance file in its attendance check tab.