AAU Club Manager

← All help guides

How to upload trainees via Excel

Club Admin · Bahasa Melayu below

Bulk import lets you register dozens or hundreds of trainees at once. AAU Club Manager provides a template Excel file you fill in and upload.

Steps

  1. Sidebar → Bulk Import (/bulk-import/)
  2. Pick Trainee as the role.
  3. Click Download Template — saves a .xlsx file to your computer with the correct columns.
  4. Open the template in Excel / Google Sheets / Numbers.
  5. Fill in one row per trainee. Do NOT change the column headers. Required columns are marked with * in the template: - full_name* — as on IC / birth cert - date_of_birth* — DD/MM/YYYY - gender* — M or F - id_type* — mykad, birth_cert, passport, etc. - id_number* — the actual ID number - school_name — leave blank for adult trainees - parent_email* — the parent's email (used to link/create the parent account) - parent_phone* — parent's contact - category — the category name to enrol into (must match an existing category exactly) - Others: emergency contact, medical info, etc. — fill what you have.
  6. Save as .xlsx.
  7. Back in AAU Club Manager → Bulk Import → Upload File → choose your .xlsx.
  8. AAU Club Manager parses it and shows a preview: how many rows are valid, how many will be skipped, and why.
  9. Review any errors (e.g. wrong date format, unknown category). Fix in Excel and re-upload if needed.
  10. Leave Email each person a link to set their own password ticked (it is on by default) if you want new trainees, members, coaches and staff who have a real email to choose their own password. Untick it to hand out the passwords from the result file yourself.
  11. Click Confirm Import. Trainees are created and (if category was filled) enrolled automatically.

What happens under the hood

After import

Common errors


Cara upload pelatih guna Excel

Untuk Admin Kelab

Bulk import untuk daftar berpuluh/beratus pelatih sekali gus.

Langkah

  1. Menu sisi → Bulk Import (/bulk-import/)
  2. Pilih role Trainee
  3. Klik Download Template — simpan fail .xlsx
  4. Buka template dalam Excel
  5. Isikan satu baris per pelatih. Jangan ubah header column. Yang wajib ditanda *: - full_name* - date_of_birth* — DD/MM/YYYY - gender* — M atau F - id_type* — mykad, birth_cert, passport - id_number* - parent_email* - parent_phone* - category — nama kategori (mesti padan tepat)
  6. Save sebagai .xlsx
  7. Kembali ke AAU Club Manager → Upload File
  8. AAU Club Manager tunjuk preview — baris betul dan yang salah
  9. Betulkan error dalam Excel jika perlu, upload semula
  10. Biarkan E-melkan setiap orang pautan untuk menetapkan kata laluan sendiri ditanda (asalnya ditanda) supaya pelatih, ahli, jurulatih dan kakitangan baharu yang ada e-mel sebenar boleh pilih kata laluan sendiri. Buang tanda jika anda mahu beri kata laluan daripada fail keputusan sendiri.
  11. Klik Confirm Import (Sahkan Import)

Selepas import

Error biasa