Tips for Creating the Family Import File

This guide will walk you through setting up a family import file including tips to  ensure a smooth import process.

What You Can Import

You can import the following details into our system:

• Location
• Class Name
• Day of the Week
• Room
• Instructors
• Start Time
• End Time
• Student First and Last Name
• Parent or Contact First Name
• Parent or Contact Last Name
• Cell Phone Number
• Email Address
• Gender
• Birthdate

Required Fields

The following fields are mandatory for a successful import:

• Location
• Room (can be the same as Location)
• Class Name
• Day of the Week
• Start Time and End Time
• Student First and Last Name
• Gender
• Birthdate

Notes on Required Fields

• Birthdate must be formatted as dd.mm.yyyy.
• Times should be formatted as 8:00 AM (with AM/PM capitalized and a space between the time and AM/PM).
• Day of the Week must be abbreviated to the first three letters and capitalized (e.g., Mon, Tue, Wed).

Optional Fields

You may also include the following optional fields if desired:

• Program (add this in Column C)
• Level (add this in Column D)

Important Notes

• Instructors: The import file will not add new instructors unless they have already been added to your site. Make sure your instructors are set up before performing the import.
• Program and Level: These must be created in your site prior to importing for them to be successfully imported.
• Blank Columns: The following columns must remain empty and no data can be added to these columns in the spreadsheet except for C and D only if you are importing myskillchart program data as well.
  
  C (unless importing program data)
  D (unless importing level data)
  E
  G
  J
  K
  P
  Q
  R
  W
  
  

Troubleshooting

If you encounter issues:

1. Check Formatting: Ensure all fields meet the formatting requirements, especially date and time.
2. Add Data to blank fields: Make sure all required columns have data in every cell. 
3. Verify Instructor Entries: Confirm that all instructors are pre-added to your system.
4. Review Optional Fields: Make sure programs and levels are set up in advance if included.

For additional assistance, please contact MSC support at help@myskillchart.com