Import from KSIS
You've been running registration (or the whole meet) in KSIS and you want to bring that data into Gym Art Meets. The KSIS importer accepts files you've already exported and creates your meet, roster, and optionally your sessions in one pass.
There are two paths, and the difference matters:
KSIS Entries File (
.csvor.xlsx). Use this when you finished registration in KSIS but want to do scheduling and scoring in Gym Art Meets.KSIS Scoring File (
.sql). Use this when you already built sessions and rotations in KSIS and just want Gym Art Meets to handle scoring.
Both live inside the new meet dialog. You pick which one you have, drop the file in, confirm the meet details, and start the import.
Prerequisites
A club in Gym Art Meets. If you don't have one yet, create one first.
A KSIS export file from your current meet. Entries exports are
.csvor.xlsx. Full scoring backups are.sql.
Pick your import type
From your club dashboard, click New meet.
The "How would you like to create your meet?" screen appears with four options.
Choose one:
KSIS - Entries File if you have a
.csvor.xlsxexport.KSIS - Scoring File if you have a
.sqlbackup.
The rest of the flow is the same for both. The difference is what lands in your meet at the end (see What you get below).
Steps
Step 1: Select in the file
Click to pick it from your computer. Entry files accept .csv and .xlsx. Scoring files accept .sql.
Gym Art Meets reads the file and shows you a preview card with the filename.
Step 2: Review meet details
Below the file card you'll see the meet details form:
Meet name. For
.sqlfiles, the name is pulled from the KSIS metadata. For.csv/.xlsx, type it in.Dates. Same rule:
.sqlfills these in from metadata,.csv/.xlsxask you. The start date is also used as the reference date for calculating age-group birth-date ranges, so it needs to be close to the real event date.Sport type. WAG, MAG, or WAG+. For
.sqlfiles, this is auto-detected from the KSIS sport code (ARTW,ARTM,ARTW+). For.csv/.xlsx, pick it from the dropdown.
Edit anything that doesn't look right. You can still change all of this after the import.
Step 3: Start the import
Click Create Meet & Import. Gym Art Meets creates the meet first, then runs the import in phases. You'll see a progress bar with a description of what's happening (parsing, creating levels, creating gymnasts, and so on).
When it finishes, you get a result card with counts: levels created, gymnasts imported, coaches, competitions, sessions if applicable. The dialog closes and takes you to your new meet.
What you get
This is the full list of what lands in your meet from each path.
Entity in Gym Art Meets
KSIS .sql
KSIS .csv / .xlsx
Meet (name, dates, sport)
Auto from file
You enter
Levels
Yes
Yes
Age groups (with birth-date ranges)
Yes
Yes
Subdivisions (A, B, C groupings)
Yes
Yes
Gymnasts (with DOB, club, email)
Yes
Yes
Coaches
Yes
Yes
Sessions
Yes
No
Rotations
Yes
No
Competitions (Level + Age + Subdivision)
Yes
Yes
Scores
No
No
Judges / panels
No
No
Scores and judge data are never imported from KSIS, regardless of file type. Scoring starts fresh in Gym Art Meets.
Common stumbling blocks
A gymnast is missing from the roster. KSIS entries without a full name or without a date of birth are dropped silently. Open the file and check that every row has first name, last name, and DOB before importing.
Age groups look wrong. Age ranges come from the event start date. If you picked the wrong date, fix the meet start date and re-run the import, or edit the age groups in the level settings.
The sport type is empty on a .sql file. The KSIS sport code didn't match anything we recognize (we map ARTW, ARTM, ARTW+). Pick it manually from the dropdown.
No sessions showed up from my .csv file. That's expected. Only .sql files carry session and rotation data. Build sessions in the app using Create a session.
An age group label like "10 & over" didn't import. The parser only understands numeric formats like "Age 9", "Age 7&8", or "Age 10+". Rename the label in the source file and try again, or add the age group manually after import.
I re-imported and now I have duplicates. Gymnasts are matched by first name, last name, and club name. If you re-ran the import after renaming someone, the importer treats them as a new gymnast. Delete the duplicate in the roster.
What's next
Configure levels and categories if you need to tweak pricing or capacity
Create a session if you imported a
.csvor.xlsxfile and need to build the scheduleSet up judge profiles to prepare for scoring
Related
KSIS concept map for terminology mapping
Last updated