Students Import - CHANGES.md

Students Import module

2026-09-22 Do not display "Make sure you have backed up your database!" on rosariosis.com
2026-08-15 Fix PHP warning Undefined array key "people_join_contacts"
2026-08-06 Deprecated since RosarioSIS 13.0 SendEmail() function
2026-05-06 Add Delete existing students feature
2026-04-22 Add link to Change log
2026-04-18 Add Test Excel and CSV files
2026-03-19 Spanish: do not capitalize words & use "tú" instead of "usted"
2025-12-10 Add Russian and Ukrainian translations
2025-11-25 JS fix import form submit function was not called
2025-08-25 jQuery fix .ready() syntax is deprecated
2025-07-10 SQL convert to uppercase when checking username uniqueness
2025-07-04 Fix PHP deprecated fgetcsv(): the $escape parameter must be provided
2025-05-29 Fix PHP warning Undefined array key "mode" JS Add mode GET param to URL
2025-03-17 Rename module: Students Import > Student Import
2025-03-13 Fix generic password: username + extra
2025-02-12 JS Fix function called as many times as we browsed the page in AJAX / loaded this JS file
2025-02-12 Fix PHP8.4 deprecated the $escape parameter must be provided as its default value will change
2025-02-12 HTML remove contact_input_array hidden input, add data-array to links
2025-02-11 Fix contact input id
2025-02-11 Fix nested HTML inside hidden input
2025-02-11 JS fix onclick event when element not in DOM right away
2025-02-11 JS add semicolon after var declaration
2025-02-11 Fix Password Field Generic JS
2025-02-11 Fix _contactFields() HTML
2025-02-11 Fix nested HTML inside hidden input
2025-02-11 Fix JS error use this scope when calling function
2025-02-11 JS fix error $(...).chosen is not a function
2025-02-11 Fix PHP syntax error
2025-02-11 Fix contact_field_html hidden input
2025-02-11 Add composer.json
2025-02-11 Since RosarioSIS 12.5 CSP remove unsafe-inline Javascript
2024-11-18 Update screenshots, remove Premium screenshots
2024-09-11 Fix PHP warning Trying to access array offset on value of type null
2024-08-21 Security: use FileDelete() instead of unlink()
2024-06-17 Fix screenshot URL
2024-06-17 Fix SQL error: truncate name > 50 chars
2024-05-07 Fix PHP fatal error allow calling Menu.php alone
2024-02-28 Fix PHP Notice Undefined offset
2024-02-25 JS compatibility with Use FormData instead of jQuery Form Plugin
2024-01-25 Add new Excel test file: Students_No_Addresses_but_Phone_RosarioSIS_test.xlsx
2024-01-25 SQL Check for CITY, ZIPCODE & PHONE IS NULL when searching for existing Address
2024-01-25 Fix translation for "Zip Code"
2024-01-25 Fix PHP warning undefined array key
2024-01-25 Exclude custom fields of the "Files" type
2024-01-25 Include PHONE when searching for existing Address
2024-01-25 Omit DBQuery() call + short array notation
2024-01-16 Add Slovenian translation
2023-11-11 Fix PHP warning undefined array key
2023-10-11 Fix contact import: make "Relation" input required
2023-09-23 Replace PHPExcel with SimpleXLS & SimpleXLSX
2023-07-28 Fix PHP8.2 deprecated: mb_convert_encoding() + PHP warning "DOMDocument::loadHTML(): Tag [mytag] invalid in Entity"
2023-07-28 Catch PHPExcel exceptions & invite to convert file to CSV
2023-07-14 Fix PHP8.1 deprecated passing null to parameter of type string
2023-07-05 Fix grammar
2023-07-04 Create Food Service Account (and assign a Barcode)
2023-06-27 Add trailing slash to URL
2023-06-27 Fix detect https inside Docker or behind reverse proxy
2023-06-22 Fix PHP warning undefined array key
2023-06-22 Fix PHP Deprecated: use of "self" in callables
2023-06-21 Fix PHP Warning: Trying to access array offset on value of type int
2023-06-21 Fix PHP warning undefined variable $column
2023-06-20 Fix remove custom Menu position: conflict with Email Students
2023-06-13 Add Portuguese (Brazil) translation
2023-04-03 Use gettext (.po files) to translate help
2023-04-02 Add Error PHP zip extension required to open .xlsx or .ods file
2023-04-02 Fix PHP8.2 deprecated Creation of dynamic property
2022-12-23 Use Select2 input instead of Chosen, fix overflow issue
2022-12-23 Remove Chosen files
2022-12-02 Fix CSV encoding detection
2022-11-03 Fix PHP8.2 utf8_encode() function deprecated
2022-10-06 Fix PHP warning: "continue" targeting switch is equivalent to "break"
2022-08-20 Fix MySQL 5.6 syntax error WHERE without FROM, use nonexistent DUAL table
2022-08-18 Update DATA_PROCESSING.md
2022-08-18 Add MySQL support, version 10.0
2022-08-02 Fix PHP8.1 Deprecated
2022-08-02 Fix PHP8.1 deprecated errors
2022-06-30 Fix PHP8.1 deprecated errors
2022-05-30 Update French translation, remove intermediary capital letters
2022-05-19 Remove deprecated code when no RedirectURL()
2022-03-12 JS fix Send Notification disabled logic (enrollment date check)
2022-03-12 Fix require ProgramFunctions/SendNotification.fnc.php
2021-12-30 Add Bulgarian translation, thanks to Vanyo Georgiev
2021-08-09 Update screenshots
2020-11-28 Fix French help text
2020-07-14 Escape URL
2020-06-17 Place Students Import program right after Utilities separator
2020-05-24 Premium: Update Existing Students
2020-05-24 Fix mode check
2020-05-13 Add update mode
2020-04-20 Fix $_REQUEST['moodle_create_student'] set to false anymore in Moodle plugin response
2020-04-20 Fix typo empty $_REQUEST['PASSWORD']
2020-04-20 Create Student in Moodle
2020-04-16 Optionnally send email notification to Students
2020-04-16 Fix PHP deprecated curly brace syntax
2020-04-15 Custom Fields: exclude files type
2020-03-11 JS prevent submitting form
2020-03-11 Fix JS countdown
2020-02-20 Fix _checkNumeric() Respect format: NUMERIC(20,2)
2020-01-29 Fix SQL error escape quotes
2020-01-11 Fix Contact Info field increment
2020-01-11 Fix SQL error escape quote
2020-01-11 Unset STUDENTS_JOIN_ADDRESS before inserting
2020-01-11 Fix Add STUDENTS_JOIN_ADDRESS checkboxes to Addresses
2020-01-10 Add Residence, Bus, Mailing checkboxes to Addresses
2020-01-10 Fix SQL error escape quote
2020-01-10 Fix SQL error escape string
2020-01-10 Fix SQL error escape quote
2019-12-24 Update URL
2019-12-11 Fix SQL error on address import
2019-09-25 Fix SQL error when INSERT enrollment before student
2019-08-19 Fix SQL error set RosarioSIS ID maxlength to 9
2019-07-15 Version 1.9 update
2019-07-15 SQL Uses new serial ID sequence + 50000 chars textarea maxlength
2017-10-19 Fix SQL error due to comma (') in imported values
2017-10-10 Better explain Grade Levels import
2017-07-31 Fix PHP warnings
2017-06-13 Remove modfunc from URL using new RedirectURL function
2017-04-27 Add Data processing PDF
2017-04-21 SQL error fix on install: check if exists before INSERT
2017-02-03 Fix escape column identifier: lower case
2017-02-03 Version 1.5 update
2016-12-14 Fix checkbox checked test
2016-12-14 Rename screenshot_premium to screenshot.png
2016-11-03 Add test CSV files
2016-11-03 Add CSV files help + mention tests/ folder
2016-08-23 Fix Unset STUDENTS_JOIN_ADDRESS before inserting.
2016-08-23 Add second test XLS with parents adresses
2016-08-11 Do not use Student address if Contact address is empty + fix custom person fields
2016-08-11 Fix (empty) Addresses & add Custom People fields
2016-08-11 Fix existing relations/titles + _insertContactFields()
2016-08-08 Add php_zip extension requirement
2016-08-02 Use array_replace_recursive for PEOPLE_JOIN_CONTACTS
2016-08-01 Fix various addresses & people arrays issues
2016-08-01 Fix Javascript error in addContactField() (double escape in new RegExp!)
2016-07-29 Remove misplaced files & update DATA_PROCESSING + README
2016-07-28 Update French & Spanish translations, add fr/es screenshots
2016-07-28 Update version, add link
2016-07-22 Attendance Start Date this School Year field not required
2016-07-18 Add User Checkbox fields checked state + Add Student's Address link
2016-07-13 Add Original file name, # rows + Fix when same CSV column used for 2 different fields.
2016-07-08 Render spaces for trim examples
2016-07-08 Add Data Processing reference + various small import fixes
2016-07-08 Optimization: Stack SQL INSERTs & execute them at once
2016-07-07 Add Alert message & Stop button 5 seconds before importing
2016-07-06 Add index to PEOPLE_JOIN_CONTACTS array (TOFIX) + fill $addresses & $people arrays
2016-07-06 Fix cotactid when adding dynamic fields & move Add Contact to Header
2016-07-06 Add Contact's Address dynamic form.
2016-07-06 Change license for MIT + update README.md
2016-07-05 Dynamically add Contacts & their information
2016-06-30 Add JS addContact() function + fixes + _makeCheckboxInput()
2016-06-30 Add Addresses & People (Contacts) Import functions; Help texts; jquery.chosen; locales;
2016-06-24 Generic Password extra + Database Backup link
2016-06-20 Display Warnings + Fix generic Username / Password + Sanitize input
2016-06-17 Various fixes: 1st tests for Students Import working!
2016-06-15 Move
2016-04-28 Change workflow to 1. Upload CSV or Excel file, 2. Associate CSV columns to Student Fields, 3. Import students / addresses / contacts
2016-04-11 1st commit + add PHPExcel 1.8 class

https://www.rosariosis.org/fr