Import Student File

Baslogue^{^®}

IMPORTING STUDENT FILE

If you already have a file with student information that you want to import (instead of manually create students one-by-one) you can do this via the "File | Import Student File" menu option on the Main Window.

The file must be in Comma Separated Values (CSV) format. You can create these by hand using a text editor, but it is much easier to create one by using a spreadsheet program such as Microsoft^® Excel and then save the file in CSV format using "Save As" and selecting the file type CSV, sometimes called "comma delimited" format.

Here is a file sample in its raw text form as would be viewed by a text editor (this example uses Notepad):

And here is the same file shown in Microsoft^® Excel:

In order to be a valid Import File, there are some characteristics which it must have:

The first row of the spreadsheet (row 1) must contain column headings, defining what data is stored in that column. The columns may appear in any order. Not all columns need to be in a file. Allowable column headings are

SURNAME
FIRST_NAME
ADDRESS (must be all on one line)
PHONE_NO
BARCODE_ID

Every other row in the spreadsheet must contain data - no blank lines are allowed. Each data row will be imported as a new student. If you have the same student repeated on more than one row, you will get one new student created for each row.
Each new student will automatically get a new Student ID
If you do not include the BARCODE_ID field, then the barcode will be automatically set to the Student ID, left padded with zeros to a length of 4 digits - e.g. an ID of 12 will get a Barcode ID of "0012".