For a full list of contributors, see "credits.txt". The full license can be read in "license.txt". This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. See the GNU General Public License for more details. Contact: Dokeos, rue du Corbeau, 108, B-1030 Brussels, Belgium, info@dokeos.com ============================================================================== */ /** ============================================================================== * This tool allows platform admins to create courses by uploading a CSV file * @todo Add some langvars to DLTT * @package dokeos.admin ============================================================================== */ /** * Validates imported data. */ function validate_data($courses) { global $_configuration; global $purification_option_for_usernames; $dbnamelength = strlen($_configuration['db_prefix']); //Ensure the prefix + database name do not get over 40 characters $maxlength = 40 - $dbnamelength; $errors = array (); $coursecodes = array (); foreach ($courses as $index => $course) { $course['line'] = $index +1; // 1. Check whether mandatory fields are set. $mandatory_fields = array ('Code', 'Title', 'CourseCategory', 'Teacher'); foreach ($mandatory_fields as $key => $field) { if (!isset($course[$field]) || strlen($course[$field]) == 0) { $course['error'] = get_lang($field.'Mandatory'); $errors[] = $course; } } // 2. Check current course code. if (isset ($course['Code']) && strlen($course['Code']) != 0) { // 2.1 Check whether code has been allready used by this CVS-file. if (isset ($coursecodes[$course['Code']])) { $course['error'] = get_lang('CodeTwiceInFile'); $errors[] = $course; } // 2.2 Check course code length. elseif (api_strlen($course['Code']) > $maxlength) { $course['error'] = get_lang('Max'); $errors[] = $course; } // 2.3 Check whether course code has been occupied. else { $course_table = Database :: get_main_table(TABLE_MAIN_COURSE); $sql = "SELECT * FROM $course_table WHERE code = '".Database::escape_string($course['Code'])."'"; $res = Database::query($sql); if (Database::num_rows($res) > 0) { $course['error'] = get_lang('CodeExists'); $errors[] = $course; } } $coursecodes[$course['Code']] = 1; } /* // 3. Check whether teacher exists. if (!UserManager::is_username_empty($course['Teacher'])) { $teacher = UserManager::purify_username($course['Teacher'], $purification_option_for_usernames); if (UserManager::is_username_available($teacher)) { $course['error'] = get_lang('UnknownTeacher').' ('.$teacher.')'; $errors[] = $course; } } */ // 4. Check whether course category exists. if (isset ($course['CourseCategory']) && strlen($course['CourseCategory']) != 0) { $category_table = Database :: get_main_table(TABLE_MAIN_CATEGORY); $sql = "SELECT * FROM $category_table WHERE code = '".Database::escape_string($course['CourseCategory'])."'"; $res = Database::query($sql); if (Database::num_rows($res) == 0) { $course['error'] = get_lang('UnkownCategory').' ('.$course['CourseCategory'].')'; $errors[] = $course; } } } return $errors; } /** * Saves imported data. * @param array List of courses */ function save_data($courses) { global $_configuration, $firstExpirationDelay; global $purification_option_for_usernames; $user_table = Database::get_main_table(TABLE_MAIN_USER); $msg = ''; foreach ($courses as $index => $course) { $course_language = api_get_valid_language($course['Language']); $keys = define_course_keys($course['Code'], '', $_configuration['db_prefix']); $titular = $uidCreator = $username = ''; // get username from name (firstname lastname) if (!UserManager::is_username_empty($course['Teacher'])) { $teacher = UserManager::purify_username($course['Teacher'], $purification_option_for_usernames); if (UserManager::is_username_available($teacher)) { $sql = "SELECT username FROM $user_table WHERE ".(api_is_western_name_order(null, $course_language) ? "CONCAT(firstname,' ',lastname)" : "CONCAT(lastname,' ',firstname)")." = '{$course['Teacher']}' LIMIT 1"; $rs = Database::query($sql); $user = Database::fetch_object($rs); $username = $user->username; } else { $username = $teacher; } } // get name and uid creator from username if (!empty($username)) { $sql = "SELECT user_id, ".(api_is_western_name_order(null, $course_language) ? "CONCAT(firstname,' ',lastname)" : "CONCAT(lastname,' ',firstname)")." AS name FROM $user_table WHERE username = '".Database::escape_string(UserManager::purify_username($username, $purification_option_for_usernames))."'"; $res = Database::query($sql); $teacher = Database::fetch_object($res); $titular = $teacher->name; $uidCreator = $teacher->user_id; } else { $titular = $course['Teacher']; $uidCreator = 1; } $visual_code = $keys['currentCourseCode']; $code = $keys['currentCourseId']; $db_name = $keys['currentCourseDbName']; $directory = $keys['currentCourseRepository']; $expiration_date = time() + $firstExpirationDelay; prepare_course_repository($directory, $code); update_Db_course($db_name); fill_course_repository($directory); fill_Db_course($db_name, $directory, $course_language, array()); register_course($code, $visual_code, $directory, $db_name, $titular, $course['CourseCategory'], $course['Title'], $course_language, $uidCreator, $expiration_date); $msg .= ''.$code.' '.get_lang('Created').'
'; } if (!empty($msg)) { Display::display_normal_message($msg,false); } } /** * Read the CSV-file * @param string $file Path to the CSV-file * @return array All course-information read from the file */ function parse_csv_data($file) { $courses = Import :: csv_to_array($file); return $courses; } $language_file = array ('admin', 'registration','create_course', 'document'); $cidReset = true; include '../inc/global.inc.php'; $this_section = SECTION_PLATFORM_ADMIN; api_protect_admin_script(); require_once api_get_path(LIBRARY_PATH).'fileManage.lib.php'; require_once api_get_path(LIBRARY_PATH).'import.lib.php'; require_once api_get_path(LIBRARY_PATH).'usermanager.lib.php'; require_once api_get_path(CONFIGURATION_PATH).'add_course.conf.php'; require_once api_get_path(LIBRARY_PATH).'add_course.lib.inc.php'; require_once api_get_path(LIBRARY_PATH).'formvalidator/FormValidator.class.php'; $defined_auth_sources[] = PLATFORM_AUTH_SOURCE; if (is_array($extAuthSource)) { $defined_auth_sources = array_merge($defined_auth_sources, array_keys($extAuthSource)); } $tool_name = get_lang('ImportCourses').' CSV'; $interbreadcrumb[] = array ('url' => 'index.php', 'name' => get_lang('PlatformAdmin')); set_time_limit(0); Display :: display_header($tool_name); if ($_POST['formSent']) { if (empty($_FILES['import_file']['tmp_name'])) { $error_message = get_lang('UplUploadFailed'); Display :: display_error_message($error_message, false); } else { $file_type = $_POST['file_type']; $courses = parse_csv_data($_FILES['import_file']['tmp_name']); $errors = validate_data($courses); if (count($errors) == 0) { //$users = complete_missing_data($courses); save_data($courses); //header('Location: user_list.php?action=show_message&message='.urlencode(get_lang('FileImported'))); //exit (); } } } if (count($errors) != 0) { $error_message = ''; Display :: display_error_message($error_message, false); } ?>

:

Code;Title;CourseCategory;Teacher;Language
BIO0015;Biology;BIO;username;english