Previous icon

Next icon

Adding new students to classes using student class import

Use the Student Class Import function to import a list of students from a file created in another application into Synergetic. For example, Microsoft Excel. Before you import the file into Synergetic, you need to save it as a delimited text file, either a:

A delimited text file is simply a file that contains all your data, with each field separated by a delimiter. The separator between fields can be anything you define. The default is a comma.

This function is useful if you have a list of students that need to be added into a class in bulk. This avoids having to manually load each student record and add them into the class.

Example of importing classes

One of your music teachers maintains an Excel spreadsheet containing a list of all the students who have joined up for the new trumpet class. This class is chargeable and is to be charged out using the Synergetic debtor's system. The music teacher needs to be able to access the student records so that she can extract contact details.

With delimited text files you can easily extract data from any Microsoft Office application into a format that Synergetic can recognise. The information about how your data is organised is preserved.

Your Excel or Access database may look something like this:

Field Name

StudentName

PhoneNumber

ID

ClassCode

Record 1

Brooke Peters

03 9455 2448

104445

TRUMPET01

Record 2

Mark Jones

03 9455 1234

15477

TRUMPET01

Record 3

Daniel Egan

03 9455 5678

11452

TRUMPET01

Synergetic requires the ID and ClassCode fields formatted as follows: ID,ClassCode.

Last modified: 16/04/2012 4:15:47 PM

See Also

Maintaining classes

Searching for classes

Creating new classes

Class Maintenance - General tab

Class Maintenance - Timetable tab

Class Maintenance - Students tab

Class Maintenance - Staff tab

Class Maintenance - Charges tab

Class Maintenance - Courses tab

Class Maintenance - Result Groups tab

Class Maintenance - User Forms tab

Class Maintenance - Markbook tab

Class Maintenance - Documents tab

Class Maintenance - Print Flags tab

Class Maintenance - Schedule tab

Class Maintenance - DocMan tab

© 2013 Synergetic Management Systems. Published 15 October 2013.

Top of page