From Dokeos

Contents 1 Current features 1.1 Users 1.2 Courses 1.3 Classes 1.4 Users - Courses 2 Modificiations and enhancements 2.1 Create, delete,update 2.2 Administrate relationships between several parts 2.3 Export

Current features

In the summary below we list alle options that are present now for the platform administrators to upload CSV files.

Users

Present: Create new user by uploading a CSV file with structured data. When the UserName and Password filed are not present these will be generated automatically. You can set multiple courses so the new users are subscribed immediately. You can set 1 classname where alle users are subcribed.

LastName;FirstName;UserName;Password;Email;OfficialCode;PhoneNumber;Status;Courses;ClassName

Future: You should be albe to export userlists. You can limit the list to users of a specific course. The password is not included in the export file if it is encoded in the database. The result of the export file:

UserId;LastName;FirstName;UserName;Password;Email;OfficialCode;PhoneNumber;Status;AuthSource

Courses

New courses are created by uploading a CSV file:

Code;Title;CourseCategory;Teacher

Classes

New classes are created by uploading a CSV file with one classname on each line. Creating classes with the same name is not possible.

ClassName

Users - Courses

Subscription of users in courses can be updated by uploading a CSV file with the structure below. For each user-course record in the file their will be a valid subscription for that user in that specific course. All his other subcriptions in courses will be stopped.

UserName;CourseCode;Status

Modificiations and enhancements

Create, delete,update

For the moment it's only possible to create new users,courses and classes. It is useful to enhance all these modules so we can also update and delete users, courses and classes.

The actions below show be available for:

• Users
• Courses
• Classes

A list of possible actions:

• Create: create new users/courses/classes based on the upload CSV file
• Delete: delete existing users/courses/classes based on the uploaded CSV file
• Update: update existing users/courses/classes based on the uploaded CSV file

Administrate relationships between several parts

Examples

• User - Course
• User - Class
• Class - Course

When uploading these files following actions should be available:

• Create relationships: All relationships in the uploaded file will be created in the system if they don't exist yet.
• Remove relationships: All relationships in the uploaded file will be removed from the system of they exist.
• Synchronize:
  • All relationships in the uploaded file and which don't exist in the system will be created.
  • All relationships in the system and which don't exist in the uploaded file, will be removed.

Export

Wherever it's possible to import data, it should be possible to export data. Both import and export files should use the same format so exported files can be used as source files for import. Where useful, additional filters can be defined to determine which data should be exported.