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:
- text file, with a file extension of .txt
- comma separated delimited file, with a file extension of .csv.
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.