For importing data from a CSV file select Data | Import data from CSV file in the menu.
Data on the following items can be imported from a CSV file:
| • | rooms, |
| • | lecturers, |
| • | courses and |
| • | students. |
CSV File preparation
Data in the CSV file have to be in the first sheet.
You can prepare your data in an Excel file and then transform the file to a CSV file.
- Open the Excel file with student data (data have to be arranged as described above).
- Select File and then Save as.
- Choose the folder in which you want to save the file.
- Save as type CSV (the extension of the file will be renamed into .csv).
- Press the Save button and then Ok and Yes.
1. Import rooms
The following data are imported:
| - | room name, |
| - | number of seats and |
| - | equipment. |
Data example:
Room name |
Number of seats |
Equipment |
R – 01 |
282 |
|
R – 02 |
40 |
Computers, Phono equipment |
R – 03 |
20 |
Laboratory equipment |
R – 04 |
36 |
Computers |
Find an example of a CSV file on www.wisetimetable.com (DATA IMPORT).
Data for one room are written in one row. The room name is written in the first column, the number of seats in the second, and the equipment in third and the following columns.
When the CSV file is prepared, choose Data | Import data from CSV file | Import rooms in the menu.
2. Import lecturers
The following data are imported:
| - | name |
| - | surname and |
| - | lecturer's code. |
Data example:
Surname |
Name |
Code |
Scott |
Nelly |
SN |
Rogers |
Tom |
|
Meyers |
Nicole |
MN |
Find an example of a CSV file on www.wisetimetable.com (DATA IMPORT).
Data for one lecturer are written in one row. The lecturer’s name is written in the first column, the surname in the second, and the code in the third (the code is not obligatory).
When the CSV file is prepared, choose Data | Import data from CSV file | Import lecturers in the menu.
3. Import courses
The following data are imported:
| - | program name, |
| - | program code, |
| - | year, |
| - | subject area name, |
| - | subject area code, |
| - | course name, |
| - | course code, |
| - | course type, |
| - | first week of execution, |
| - | last week of execution, |
| - | number of hours per week, |
| - | lecturer’s surname and |
| - | lecturer’s name. |
Data example:
No. |
Program name |
Program code |
Year |
Subject area name |
Subject area code |
Course name |
1 |
Business sciences |
BS |
1 |
Management |
MNG1 |
Introduction to Business |
2 |
Business sciences |
BS |
1 |
Management |
MNG1 |
Introduction to Organization |
3 |
Business sciences |
BS |
1 |
Management |
MNG1 |
Introduction to Organization |
4 |
Business sciences |
BS |
3 |
Management |
MNG3 |
Business Communication |
(continuation)
No. |
Course code |
Type |
Lecturer’s name |
Lecturer’s surname |
First week |
Last week |
Hours per week |
1 |
IB |
lecture |
Peter |
Smith |
1 |
15 |
2+2 |
2 |
IO |
lecture |
Daryl |
Miller |
1 |
15 |
3 |
3 |
IO |
tutorial |
Jamie |
Cornelius |
1 |
6 |
4 |
4 |
BC |
lecture |
Jack |
Black |
1 |
15 |
2 |
Find an example of a CSV file on www.wisetimetable.com (DATA IMPORT).
When the CSV file is prepared, choose Data | Import data from CSV file | Import courses in the menu.
4. Import students
The following data is imported:
| - | student number, |
| - | surname and |
| - | name. |
Data example:
Student No. |
Surname |
Name |
19375211 |
AMMONS |
ABBIE |
19375212 |
AUMAN |
KAYLYN |
19375213 |
BAILEY |
KAROLYN |
19375214 |
BAKER |
PHYLLIDA |
Find an example of a CSV file and a format description on www.wisetimetable.com (DATA IMPORT).
Data for one student are written in one row. The student's number is written in first column, the surname in the second, and the name in the third.
There are two manners of importing student data:
| 1. | When the CSV file is prepared, select View By Student in the main window and select the Program, Year and Subject Area to which you want to import students. Then choose Data | Import Data From CSV File | Import Students in the menu and load the prepared CSV file. |
| 2. | When the CSV file is prepared, choose Edit | Students in the menu and select the Program, Subject Area and Year to which you want to import students. Then click the Import button and choose the CSV file. |