TOMUSS is an interactive web application (groupware) allowing multiple concurrent users to edit data tables as in google spreadsheet. TOMUSS is open source. | TOMUSS est une application web interactive permettant à plusieurs utilisateurs de modifier ensemble des tableaux de données partagées comme avec google spreadsheet. TOMUSS est un logiciel libre. |
Some goals of this spreadsheet are :
|
Quelques buts de ce tableur :
|
The spreadsheet has been designed in the context of student
ranking management.
|
Le tableur a été conçu afin d'être utilisé pour
gérer les notes des étudiants.
|
The TOMUSS server needs only the Python/Unix environment to run. And the users browsers can be recent version of Firefox, Opera, Chrome, Edge. | Le serveur TOMUSS nécessite seulement un environnement Python/Unix pour fonctionner. Les utilisateurs peuvent utiliser une version récente de Firefox, Opera, Chrome, Edge. |
TOMUSS is a stable product, it is in use since 2008. Hundreds of teachers and thousands of students use it at the university of Lyon 1. Graphics showing the usage evolution at Lyon 1 university | TOMUSS est une application stable utilisée depuis 2008. Des centaines d'enseignants et des milliers d'étudiants l'utilisent actuellement à l'université Lyon 1. Graphique montrant l'évolution de l'utilisation de TOMUSS à l'université Lyon 1. |
You can try TOMUSS on the
demonstration server. Beware, if you are freezed on a white page it is because your anti-virus don't like TOMUSS. |
Vous pouvez immédiatement essayer TOMUSS sur le
serveur de démonstration. Attention, si vous êtes bloqué sur une page blanche c'est que votre anti-virus n'aime pas TOMUSS. Si vous avez des identifiants dans une université/école française (enseignant, personnel ou étudiant), vous pouvez accéder à TOMUSS-FR (accès direct au service). |
The user interface works in english and french.
The tips provide all the necessary information
to use TOMUSS.
The user documentation and tutorials are only in french language. The technical documentations are only in english. |
L'interface utilisateur fonctionne en français
et en anglais.
Les bulles d'aides donnent toutes les informations
nécessaires pour utiliser TOMUSS.
Les documentations utilisateurs et cours sont seulement en français. La documentation technique est seulement en anglais. |
All in french:
|
Tout en français (et lié à l'enseignement en France) : |
All in English:
|
Tout en anglais :
|
The GPL copyrighted sources and their release notes. The GIT repository is hosted by SourceForge. |
Les sources (avec un licence GPL) ainsi que les informations sur les versions. Le dépôt GIT est hébergé par SourceForge. |
git clone git://git.code.sf.net/p/tomuss/code tomuss-code |
7.3.13 2024-02-17 |
Long time without news, but work continue. Only new features are described here. New column types:
The Dispatcher column type works nicely. Table editor:
Others:
|
7.2.7 2023-02-24 |
Teachers and P templates for global attendance managing:
Enumeration enhancements:
Table editor:
And many bug fixes. |
7.2.1 2023-01-08 |
The really big change: when the browser send multiple changes to the server they are merged and so it is very fast. Another big change: it is possible to allow students to edit some tables. The configuration is done in the «exceptions» line from the «config_table».
Add a «replace» column type to define for example: The «columns» attributes can now be equal to: «*», «*Note», «*Prst»... to operate on numerous columns. Beware: «*Note *Prst» is not allowed. QRCode Teachers table: it is possible to indicate that ABI are to be mailed to the teacher. The ABI must be indicated less than 24 hours after the course date. When dispatching students to a referent, allows to select only a group of students from a table. In the home page configuration, the «clean» plugin link must be updated to javascript:goto_url(add_ticket('clean/'+year_semester())) And many big fixes. |
7.1.10 2022-07-10 |
Stable release before a big change. |
7.1.9 2022-06-15 |
Stable release before a big change.
|
7.1.8 2022-05-24 |
Templates «Teachers» and «P» for QRCode attendance:
|
7.1.3 2022-02-20 |
Tons of bug fixes and small enhancements, and many new functionalities. About QRCode, Teachers and P templates :
New column types:
A virtual table with all the ABJ and DA can be loaded. «TMP/lastlog.py» contains the last TOMUSS log of each student. «SCRIPTS/run», load, configures and runs TOMUSS in a Docker |
7.1.1 2021-10-09 |
Stable (many bug fixes), except for the new functionalities.
|
7.1.0 2021-08-20 |
UNSTABLE: The first day in production raised many problems. do not use it without applying the last commits. Full rewrite of the tip management, press the Shift key and move the cursor to see the tips. There are no more tip popping everywhere when moving the cursor, There is a dotted underline to highlight the students with a justified leave. In order to make all the users aware of these new tips, it is possible to display a message the first time an user edit a table. The message is defined in «config_table», if it is modified, then it will be displayed one time to all the users. |
7.0.7 2021-08-20 |
This release is stable.
|
7.0.6 2021-05-23 |
This release is stable, but the memory usage seems strange. A necessary small API change: 'column_type.stat()' has a new parameter: 'grp_seq'.
|
7.0.3 2021-05-03 |
A necessary small API change: the entity attribute getters are now staticmethod. Many bug fixes and big changes:
|
7.0.1 2021-04-23 |
Full rewrite of user management. The new API is not 100% compatible with the old one, so some tweaking may be needed.
Some new functionnalities:
Some things to update for this new version:
|
6.7.6 2021-04-07 |
A couple of bug fix.
The 2021-04-19 the 7.0.0 version will be in production at Claude Bernard University. At the end of the month, if all is fine a version 7.0.1 will be released. |
6.7.5 2021-03-08 |
Many bug fixes, and not many new things:
This release is the last stable before the 7.0.0 where the internal API will change for user attributes access. |
6.7.4 2020-12-31 |
Many bug fixes and new functionnalities:
|
6.7.3 2020-11-22 |
Stable release! |
6.7.2 2020-11-14 |
DO NOT USE THIS RELEASE: THE TREE SUIVI IS BROKEN Many bug fixes. The mass mailing allows to add «noreply» to the sender email. And the biggest change: the annotator allows the students to upload a PDF. The teachers annotate and grade the PDF without having to download and upload it. |
6.7.1 2020-08-21 |
An 'Annotator' column type has been added to allow teachers and students to annotate graphicaly PDF document on the web page without needing to download and upload files. You can look the video of demonstration or read the documentation. The user documentation (french) has been fully rewritten (80 pages without counting the 78 screenshots). For the developpers: the javascript code has been reformated with VSCode default options. |
6.6.9 2020-07-10 |
Stable release, it fixes a huge bug introduced in the last release and add functionnalities. You should upgrade.
|
6.6.7 2020-06-23 |
Stable release: only bug and GUI fixes, except that :
|
6.6.6 2020-05-29 |
Unstable release (its the devil one, don't trust it). Wait a couple of days to have a production tested one.
|
6.6.3 2020-03-30 |
Changes:
|
6.5.3 2020-01-25 |
Stable release with many bug fixes and small enhancements:
|
6.5.2 2019-09-23 |
Stable release with many bug fixes and small enhancements.
|
6.4.5 2019-06-09 |
Stable release. The two visibles changes are :
|
6.4.3 2019-05-13 |
Stable release. The two main changes are :
|
6.4.2 2019-04-28 |
Stable release with many MCQ enhancements. |
6.4.0 2019-03-15 |
BEWARE: the last commits are untested in production. But this version fixes a great number of problems. API change for filters, if you have defined new filter types, they need to be fixed. New things:
|
6.2.1 2018-12-20 |
BEWARE: unstable One big change: the session ticket is kept at the end of the URL. There are two goals:
All the other change are bug or GUI fixing. |
6.1.15 2018-07-21 |
Stable release with many big bug fixes. Upgrading is highly recommended. The mirroring support has been removed to simplify the code. There is now a journal of user preference modification. It is done in order to keep the date of 'private_suivi' change. An hook can be defined to add any behavior on preference change. |
6.1.14 2018-07-05 |
Stable release with many bug fixes and:
|
6.1.11 2018-05-05 |
Stable release with many bug fixes and:
|
6.1.9 2018-03-20 |
Stable release with many bug fixes and:
|
6.1.8 2018-03-11 |
This release has not been tested in production.
|
6.1.6 2018-01-06 |
Many changes:
|
6.1.5 2017-11-27 |
Fix 2 important bugs. The 'min max' attribute can be defined for the 'Number of' column type. |
6.1.4 2017-11-26 |
A column may now be fully invisible to other table users, even to the table manager and TOMUSS administrator. The invisible column must not be used in formula. Automatic selection of the '✎' tab for long values. The cell history show colored diffs for long values. Uploaded files names may be replaced by 'url_title' if it is defined. The 'upload' column type can now contain URLs. The ABJ/DA/TT page takes now into account filtered lines. Rounding are parametrables. The default rounding for average is 3 digits. Many many bug fixes, upgrading is recommended. Another bug in rounding was fixed: Old averages should be fixed. |
6.1.0 2017-08-16 |
The rounding of average has changed, read the commit summary to understand how to fix the old averages so there values does not change. At our university it changed less than 1/1000 averages. The rule is: TOMUSS never computes an average greater than any other software, even after rounding. |
6.0.44 2017-07-02 |
Bug fixes and a new home page option: reduce menu height. |
6.0.42 2017-07-02 |
It is a stable release.
TOMUSS can now send mail using an Exchange server.
New functionalities:
|
6.0.41 2017-06-11 |
It is a stable release fixing many problems.
A new functionality: PDF import of one file containing multiple students sheets, there is an interactive tool to associate sheets to student. |
6.0.38 2017-04-30 |
It is a stable release fixing:
If you are in a french university, you can have access to TOMUSS-FR. |
6.0.37 2017-04-15 |
It is a stable release with many bug fixes
and some new features:
|
6.0.33 2017-03-05 |
It is a stable release with many bug fixes
and some new features:
|
6.0.32 2017-02-25 |
It is a stable release with many bug fixes
and some new big features:
|
6.0.28 2017-02-11 |
It is a stable release with many bug fixes.
New functionnalities:
|
6.0.24 2016-12-18 |
It is a stable release with many bug fixes.
New functionnalities:
|
6.0.22 2016-12-03 |
It is a stable release with many bug fixes.
New functionnalities:
|
6.0.18 2016-09-29 |
It is a stable release with many bug fixes.
New functionnalities:
|
6.0.14 2016-07-01 |
Bug fix release. Quite stable, but there is a memory leak in the ldap3 server pool. |
6.0.13 2016-06-16 |
The 'suivi' page has now a version for screen readers. So the page content is understandable when readed by any screen reader. The 'tt' table can now fully user defined, so it is easy to customize the special examination conditions. The members of 'grp:tt_masters' can see the 'suivi' page of all the students in the 'tt' table. The form table editor displays buttons if the column type is Enumeration. It is possible to display messages on the 'suivi' page only visible to an user group defined in the ACLS. The LDAP connector has been hugely modified, and not yet tested in production environment, so this release may not be stable. |
6.0.9 2016-05-08 |
The user can now choose a global theme in its preferences. The table owner can set a table theme to display the table, and the user can override it. The '5.0' filter will now find the '5' value. |
6.0.8 2016-04-27 |
Fix a race in the LDAP connector, it is a good idea to upgrade. Some other bug fixes. When filling a text in an empty column of type Grade, the user may choose to change the column type to Free text. For the developper: if 'my_template.js' or 'my_template.css' exists, they are automaticaly inserted in the table editor. If a javascript function 'template_init' is defined, it is called when the table editor if fully initialised. |
6.0.7 2016-04-06 |
Many bug fixes. It is recommended to upgrade
even if they are some new things:
The behaviour of 'repetition' changed for grouped students. If the repetition indicates the number of groups and not the number of students. For grouped students, the uploading overwrite the upload done by the first student of the group if it is possible. It is done so to not have 2 differents uploaded file for the same group of student. A new user option allows to automaticaly freeze the columns with a filter. Full rewrite of the backups. And normalize the dict repr in files so the backup diff is minimal. Beware: manage_key with 'append' no more returns the full file content because it can be large. |
6.0.4 2016-03-27 |
Bug fix release.
The behaviour of 'repetition' changed for grouped students. If the repetition is allowed for the first, it is allowed for the other of the group. The Notation column type (detailed grading) is nearly stable. |
6.0.2 2016-03-15 |
TOMUSS is now in Python3!
BEWARE: the script convert_2_to_3.py must be run to rewrite all the DB files in order to fix the strings encoding. Do a backup. This version is in production since 20 days. Do not use the new Notation column type, it does not works on Chrome. If you want to use it, take the sources from the repository. |
5.8.3 2016-02-26 |
Bug fixes.
This release is stable. |
5.8.2 2016-02-10 |
Fix the table print. |
5.8.1 2016-02-07 |
Full rewrite of the filters in order to test
values from other columns for example [A]<[B].
It is now possible to test the current date and the current
connected user.
Full rewrite of the column fill algorithm, it works now more nicely in the corner cases. |
5.7.6 2015-12-21 |
Stable release.
Better feedback on the suivi page for the last entered grades in the student view. |
5.7.5 2015-12-13 |
Requests pending for one hour are deleted and a mail is sent to the user and the admin with the unsaved data, this case never happen. The deletion is done to allow to cleanly stop the server at any time. And now the server restart and stop is fast. Users with many possible actions can now define their favorites actions. The TT information is hidden to unconcerned teachers. The ACLS group 'see_tt_suivi' defines the users allowed to see the TT information. This release fix some other small issues. |
5.7.3 2015-10-20 |
The column fill action was broken. This release fix some other small issues. |
5.7.2 2015-10-18 |
This release is stable and the new home page has been used in production since 2 weeks and so numerous problems had been fixed. Backward incompatibilities:
|
5.6.2 2015-08-13 |
This release contains an experimental new home page accessible via '.../homepage3' url. |
5.6.1 2015-08-01 |
This release is stable. Many bug fixes. An experimental upload column type has been added. Use with caution. |
5.5.28 2015-07-11 |
This release is stable. Many bug fixes. Full rewrite of the column filling interface, it is more powerful and user friendly. LDAPS is now supported. On the suivi page, the student can collapse the table grades. The suivi page is nicer on mobile display. The 'force student list update' now really do the the job even if many students are removed. There is a rounding preference for the whole table. The default is to perform all computation by rounding down all the values so TOMUSS will never find a value bigger than any average computed by other software. The root users can activate in their preference the debuging tip. |
5.5.20 2015-05-04 |
This release is stable. Many bug fixes. Extended table are loaded only once in memory, better index management for these tables. Contextual message on column type change. Fill column with room name and place number using a room definition table. The filling column interface will be fully rewrote for the next version. |
5.5.16 2015-03-16 |
This release is stable. Experimental new feature: 'config_login' contains a list of major logins and their minor logins. Possible usages :
|
5.5.15 2015-03-15 |
The student RSS stream has now the cell visibility date
in place of the cell modification date.
This release is stable. |
5.5.14 2015-03-08 |
Clicking on the column title no more sort the column.
You must click on the triangle,
but there is now a menu to sort by author, date, comment
and percentage of justified leave.
An overidable function defines if the update of the student list is allowed. The dynamic column import no more erase not imported cells. Unregistered students informations are only erasable by a table master. Not everybody. Except for the new sorting functionalities, this release is stable. |
5.5.13 2015-02-19 |
New functionalities:
And a huge number of bug fixes and small enhancements. This release is quite stable. |
5.5.8 2015-01-02 |
Preferences and help popup for the home page and table editor. More standard shortcut keys for the table editing. The preferences have been moved from TOMUSS table into the file with the 'suivi' preferences. Automatic ticket revalidation if the CAS allows it. Full rewrite of the key event management in tables, it is cleaner and easely extensible. |
5.5.6 2014-12-18 |
The previous release contains a show stopper bug: it only works with unix socket and not internet socket. |
5.5.5 2014-12-17 |
New functionnalities:
the table masters can erase the table history.
The tables containing modified values by a teacher
are now displayed on the 'suivi' page of the teacher.
Many bug fixes, upgrading from 5.5.3 is really a requirement. Not quite a stable release. |
5.5.3 2014-12-09 |
Very big changes and not fully stable:
|
5.3.19 2014-11-08 |
Bug fixes release. |
5.3.18 2014-09-29 |
Many bug fixes and a big security problem. Upgrading is required. |
5.3.17 2014-07-28 |
The display of modified cells was broken on column filter change. |
5.3.15 2014-07-16 |
The display of modified cells was broken on
horizontal scroll.
The logs of 'suivi' visits where broken, many students where not counted since the 'suivi' page rewrite. Refered students with a TT have now an icon on home page (a hook is provided to add more). And many bug fixes. |
5.3.14 2014-06-30 |
The previous version broke the display of modified cells.
It is now fine.
This version highlight the column whose attributes are being edited. |
5.3.13 2014-06-28 |
New functionnalities:
This release is stable. |
5.3.9 2014-06-01 |
For server side computed column type, the default way is to define the vectorized version of the method: get_all_values. It is possible to restart TOMUSS from the home page, the restart is done only if TOMUSS is not used. A memory leak has been fixed, 'import' is no more used to load tables data. |
5.3.8 2014-05-17 |
With this release the home page boxes in the right column are collapsable, no more scrolling is needed for the administrator. There is a new table tab to manage access rights, it is now possible to define a list of teachers allowed to edit the table. |
5.3.3 2014-04-14 |
With this release, the page with all the student grades has now many user display options because the students do not agree on the best way to display the page. The privacy toggle has been moved with the display options. It works more nicely with Internet Explorer. This version is not yet stable. |
5.3.1 2014-03-22 |
Full rewrite of the code generating the web page
with the student grades.
The page is cleaner, more readable,
works on mobile phones and is fully customizable with plugins.
BEWARE:
|
5.2.26 2014-03-04 |
Bug fixes release. It will be the last stable of the 5.2.X |
5.2.25 2014-02-05 |
Freezed column state is now recorded as the other attributes. It is possible to unhide columns from Table/Action menu. If a column is colored, the same colors will be applied to the cells in the student 'suivi' page. |
5.2.19 2013-12-24 |
It is possible to copy a table in the same semester. Easier to add new columns to the standard semester table. The 'referent' teachers can now take student from their 'suivi' page. The current student 'etape' is displayed in the 'suivi'. |
5.2.17 2013-12-08 |
It is possible to hide a plugin from home page even if the user has the right to use it. The mass mailing allows to use square brackets in the message. 'more_on_suivi' can take into account that the teacher want to see the 'student_view'. It is now possible to edit the plugin links from the table containing the home links. It is now possible to edit at run time the cache time to live. |
5.2.16 2013-11-19 |
Many bug fixes. There is now a hook to compute line CSS style from the line content. On column values or comments import, the character ⏎ is replaced by a linefeed. |
5.2.14 2013-10-13 |
This release adds a Facebook authenticator and fixes serious problems with XSS attacks. The table RSS stream works on any table. After a short connection loss, the table content is synchronized. It is now possible to open many tables at once because the server connection is closed if the user is inactive for one minute. A new table attribute allows to hide empty lines with a non empty history. And the table display options are now stored dynamically in the page URL. |
5.2.11 2013-09-22 |
This release fixes some serious bugs: the current cell was not saved when scrolling with the mouse. And the table editor was broken on Internet Explorer. An experimental OpenID authenticator has been implemented. |
5.2.9 2013-09-15 |
Bug fix release. TOMUSS works again on mobile devices. |
5.2.8 2013-09-08 |
This release fixes a zoom out bug in FireFox. The student lists extraction function can now have 'year' and 'semester' as parameter. A GUI user interaction recording framework has been added, by default the recording is disabled, it will be used to provide the users with targeted tips. |
5.2.5 2013-08-21 |
Unstable. There is now a completion menu for enumeration, auto-completion and the edition of 'columns' input header. |
5.2.3 2013-08-17 |
Unstable. Many modifications to make it more simple to install. Add the step by step installation procedure. Beware: default database name no more DBtest but DB. |
5.2.2 2013-08-16 |
Unstable. The static files can now be delivered by a web server. There is now a framework to send messages to student or make them sign contract. |
5.2.0 2013-08-11 |
EXPERIMENTAL. The 'suivi' servers use far less memory. It is possible to use only one server for all the semesters to simplify administration, but in this case, there is no parrallelism. You must run SCRIPT/bilan.py at least once to initialises indexes and restart 'suivi' servers. |
5.1.16 2013-07-25 |
In templates, there is now a hook called on comment change. More accurate grades on the bilan page. |
5.1.15 2013-06-27 |
Speedup of 'suivi' servers. ABI-3 is now ABI and not -3. The 'delete table' button moved from home page to the table 'Action' tab. |
5.1.14 2013-05-27 |
Virtual tables can be used to send mails. Table templates can have a 'css' attribute. |
5.1.13 2013-05-13 |
Documentation search are diacritics unsensitive. Ctrl-F allow to enter the line filter. Fix the tip positionning. |
5.1.12 2013-04-23 |
It is possible to import cell comments. The cell text can now be colored in red or green using filters. |
5.1.11 2013-04-07 |
ABJ and DA outside the semester time span are filtered in the student 'suivi'. |
5.1.10 2013-04-04 |
New column export interface, it allows to export cell comments. |
5.1.9 2013-03-26 |
This is a bug fix release. |
5.1.8 2013-03-14 |
With this release, the students can show their 'suivi' only to the minimum number of teachers. This functionnality must be enabled in the config table with the 'suivi_student_allow_private' attribute. In ACLS, 'see_private_suivi' user group can see the 'suivi' of any student. |
5.1.7 2013-02-26 |
This is a bug fix release. The '!' behaviour in ACLS has been fixed, and special characters in filters are now escapable with \ |
5.1.6 2013-02-10 |
This release, contains changes that may break your plugins:
Python sources now use relative imports,
the special characters in URL are escaped in a safer way
and ABJ storage is now per student (ABJ storage
translation is automaticaly done on the first run).
There is GUI enhancements for touch screens, and a new 'Info' tab for the tables. |
5.0.15 2012-12-23 |
Less Python error backtraces are sent by mail. There is web page to navigate into the backtraces. |
5.0.13 2012-11-30 |
Bug fixes release. There is now a 'Variables' class allowing to link a set of Python values to a TOMUSS table. So you can now edit your templates parameters using a TOMUSS table. |
5.0.11 2012-10-29 |
Bug fixes release |
5.0.10 2012-10-17 |
Bug fixes release |
5.0.6 2012-09-27 |
Fix problems with IE and Safari in the 'suivi'. Add a column type to compute the weighted percentage of filtered cells used in a formula. |
5.0.4 2012-09-19 |
Fix problems with IE. |
5.0.2 2012-09-15 |
Full rewrite of the requests handling in order to not freeze the server when a browser open a connection whithout sending the request. Allows to dynamicaly import a column from one table into another. |
5.0.1 2012-09-01 |
This major release change the way the users access rights are defined, it is far more powerful. It is fully compatible with older versions if you have not patched the source code. An utility was added to find 'strange' grades in the table. |
The TOMUSS author: thierry.excoffier@univ-lyon1.fr The discussion group and the bug traker are hosted by SourceForge. |
Créateur de TOMUSS : thierry.excoffier@univ-lyon1.fr Le forum de discussion et le gestionnaire de bugs sont hébergés par SourceForge. |