IN THIS ARTICLE:
Learn about the Gymnastics Australia Club Import Report (STU-19), its filter options, and how to generate it.
- What is the Gymnastics Australia Club Import Report?
- Available Formats
- Available Filters
- Important Notes
- Uploading the Report
What is the Gymnastics Australia Club Import Report?
The Gymnastics Australia Club Import Report has been specially designed to make it easy to export your student information from iClassPro in a format to be imported into Gymnastics Australia.
NOTE: This report must be enabled by a member of the iClassPro support team and requires staff permission to access it. If you are a non-admin user and cannot see the report under REPORTS>STUDENTS, please check with your administrator to be that you have been granted appropriate permissions.
If you are an admin user and do not see the report listed under REPORTS>STUDENTS, please reach our to our support team for assistance with enabling the report for your account.
Available Formats
Per Gymnastics Australia specifications, this report is only available in XLS format.
Available Filters
General Filters
- ENROLLMENT ACTIVE START/END DATE: setting a date range will limit results to only students with an ACTIVE or SINGLE DAY-type enrollment within this date range.
- STATUS (Class/Camp)
- ACTIVE will consider only classes/camps that are active as of the defined Enrollment date range.
- INACTIVE will consider only classes/camps that are inactive as of the defined Enrollment date range.
- LOCATIONS: selecting one or more Location(s) to be included in the report output.
-
(Optional) PROGRAM: selecting one or more Program(s) will limit results to only students with an ACTIVE type enrollment as of the defined Enrollment date range.
- Leaving this blank will pull all students relative to your status filter.
-
(Optional) LEVEL: selecting one or more Level(s) will limit results to only students with an ACTIVE type enrollment in a class/camp with that Level assigned as of the defined Enrollment date range.
- Leaving this blank will pull all students relative to your status filter.
-
(Optional) CHOOSE CLASS: selecting one or more Class(es) will limit results to only students with an ACTIVE type enrollment as of the defined Enrollment date range.
- Leaving this blank will pull all students relative to your status filter.
-
(Optional) CHOOSE CAMP: selecting one or more Camp(s) will limit results to only students with an ACTIVE type enrollment as of the defined Enrollment date range.
- Leaving this blank will pull all students relative to your status filter.
Charge Filters
- PAYMENT START/END DATE: setting a date range will limit results to only students in a family with charges that have been paid within this date range.
-
(Optional) CHARGE CATEGORY: selecting one or more specific charge categories will limit the results only to charges assigned to the selected charge category/categories that have been paid within the specified date range.
- Leaving this filter blank will include all charges that have been paid within the specified date range.
NOTE: The system only considers charges with the Line Item Type of "Anniversary" when applying these filters.
Important Notes
When you run the report for the first time, the system will create any student custom fields it needs for the report that do not exist in iClassPro. After they are created, you can input data into these as needed on the Student profile and those fields will automatically populate with data the next time you run the report.
To input information into these custom fields, go to the STUDENTS page, click the pencil/edit icon next to the student in question, then go to the CUSTOM FIELDS tab to input the information in these fields:
- First Name
- Middle Name
- Last Name
- Birth Date
- Gender
- Alternate Email
- Phone
- Mobile Phone
- Street Address 1
- Street Address 2
- Suburb
- State
- Postal Code
- Country
- Parent Guardian First Name
- Parent Guardian Last Name
- Parent Guardian Email
- Parent Guardian Birth Date
- Gymnastics For All (GFA) 1
- Gymnastics For All (GFA) 2
- Gymnastics For All (GFA) 3
- Acrobatic Gymnastics (ACR)
- Aerobic Gymnastics (AER)
- Aerodance (AERD)
- Double Mini Trampoline (DMT)
- Men’s Artistic Gymnastics (MAG)
- Parkour (PK)
- Rhythmic Gymnastics (RG)
- Trampoline Gymnastics (TRP)
- Tumbling (TUM)
- Women’s Artistic Gymnastics (WAG)
Note that there may be other custom fields; however, these are the only fields referenced by the current version of this report.
The names of these custom student fields are very important – if you rename the field or delete one, the system will re-create a new field with the default name. Any data stored in the renamed field will no longer map to the report that is generated; it will use the fields with the default name instead.