TOMUSS: The Online Multi User Simple Spreadsheet

TOMUSS is an interactive web application (groupware) allowing multiple concurrent users to edit data tables as in google spreadsheet. TOMUSS est une application web interactive permettant à plusieurs utilisateurs de modifier ensemble des tableaux de données partagées comme avec google spreadsheet.

Screenshots

UE edition
Édition UE
Home page
Accueil
Accueil
Student resume
Le suivi d'un étudiant
Accueil
Justified leaves management
Gestion des ABJ
Facebook
Trombinoscope
Statistics
Statistiques
Personnal mailing
Publipostage
Forms editor
Editeur de formulaire
Table copy
Copie de tableaux
Column filling
Remplissage de colonne
Problems display
Affichage des plantages
Realtime server state
Etat temps réel du serveur
Printing and exporting
Impression et exportation
Justified leaves
Absences justifiées

Goals

Some goals of this spreadsheet are :
  • Simple to use.
  • Minimize human error.
  • An unobstructive and intuitive security model.
  • Be extensible and integrable in an existing environment.
Quelques buts de ce tableur :
  • Simple d'utilisation.
  • Minimise les risques d'erreur humaine.
  • Gestion intuitive des droits d'accès qui ne bloque pas les utilisateurs.
  • Être extensible et intégrable dans un système d'information existant.

Student management

The spreadsheet has been designed in the context of student ranking management.
  • There is a table per course and semester.
  • Student lists are retrieved from official ones.
  • Students see all the informations about them.
  • Teachers can send mails to students.
  • Teachers can print table of student pictures.
  • TOMUSS manages students with special examination condition, justified leaves, assiduity exemption.
  • Students may answer questions to fill the table.
More details on the functionnalities list (in french language)
Le tableur a été conçu afin d'être utilisé pour gérer les notes des étudiants.
  • Il y a une table par UE et par semestre.
  • Les listes d'étudiants sont extraites des listes officielles.
  • Les étudiants peuvent voir toutes les informations les concernant.
  • Les enseignants peuvent envoyer des mails aux étudiants.
  • Les enseignants peuvent afficher les trombinoscopes.
  • TOMUSS gère les étudiants avec des conditions spéciales d'examen, les justificatifs d'absences et les dispenses d'assiduité.
  • Les étudiants peuvent répondre à des questions dont les réponses s'insèrent dans les tableaux.
Vous voulez plus de détails : regardez la liste des fonctionnalités

Requirements

The TOMUSS server needs only the Python/Unix environment to run. And the users browsers can be recent version of Firefox, Opera, Chrome, Internet Explorer. Le serveur TOMUSS nécessite seulement un environnement Python/Unix pour fonctionner. Les utilisateurs peuvent utiliser une version récente de Firefox, Opera, Chrome, Internet Explorer.

History

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.

Try it now!

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.

Localization

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.

User Documentation

All in french:

Tout en français (et lié à l'enseignement en France) :

Technical Documentation

All in English:

Tout en anglais :

Diapos PyConFR 2014

Download sources

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.

5.5.6.tar.bz2 2014-12-18 The previous release contains a show stopper bug: it only works with unix socket and not internet socket.
5.5.5.tar.bz2 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.tar.bz2 2014-12-09 Very big changes and not fully stable:
  • Filters and computed columns are now defined in Python and translated into JavaScript. In some rare case the computed value may change.
  • The rank is displayed on 'suivi' for average columns.
  • It is possible to dynamicaly extract an average column from another table.
  • There is now a column filter defining which cells are modifiable in the column. The default value does not change current behaviour: = | @
  • It is possible to hide columns to the teachers in the 'suivi' page. There is now a menu to do so, the '.' in the column title is no more mandatory.
  • Non numerical values in computed column as NaN are now modifiable by the teacher.
  • TOMUSS support OpenSearch protocol.
  • The attendance can be easely entered on phone/tablet with the facebook button.
  • Clean of the client/server communication.
And many many bug fixes.
5.3.19.tar.bz2 2014-11-08 Bug fixes release.
5.3.18.tar.bz2 2014-09-29 Many bug fixes and a big security problem. Upgrading is required.
5.3.17.tar.bz2 2014-07-28 The display of modified cells was broken on column filter change.
5.3.15.tar.bz2 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.tar.bz2 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.tar.bz2 2014-06-28 New functionnalities:
  • There is now a ☆ on table editor to add the table in 'your tables' on the home page.
  • It is now possible to import line break by replacing them by ⏎ before importing.
  • Column roundings is now applied on print page and on column export.
  • It is now possible to edit multi line cell values using the ✎ tab.
And many bug fixes.

This release is stable.

5.3.9.tar.bz2 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.tar.bz2 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.tar.bz2 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.tar.bz2 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:

  • if you have redefined 'referents_students.py' in LOCAL_TEMPLATES, you need to patch it.
  • if you use 'more_on_suivi', you should dispatch its contents in plugins. By default 'more_on_suivi' is inserted into the right column menu.
5.2.26.tar.bz2 2014-03-04 Bug fixes release. It will be the last stable of the 5.2.X
5.2.25.tar.bz2 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.tar.bz2 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.tar.bz2 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.tar.bz2 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.tar.bz2 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.tar.bz2 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.tar.bz2 2013-09-15 Bug fix release. TOMUSS works again on mobile devices.
5.2.8.tar.bz2 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.tar.bz2 2013-08-21 Unstable. There is now a completion menu for enumeration, auto-completion and the edition of 'columns' input header.
5.2.3.tar.bz2 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.tar.bz2 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.tar.bz2 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.tar.bz2 2013-07-25 In templates, there is now a hook called on comment change. More accurate grades on the bilan page.
5.1.15.tar.bz2 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.tar.bz2 2013-05-27 Virtual tables can be used to send mails. Table templates can have a 'css' attribute.
5.1.13.tar.bz2 2013-05-13 Documentation search are diacritics unsensitive. Ctrl-F allow to enter the line filter. Fix the tip positionning.
5.1.12.tar.bz2 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.tar.bz2 2013-04-07 ABJ and DA outside the semester time span are filtered in the student 'suivi'.
5.1.10.tar.bz2 2013-04-04 New column export interface, it allows to export cell comments.
5.1.9.tar.bz2 2013-03-26 This is a bug fix release.
5.1.8.tar.bz2 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.tar.bz2 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.tar.bz2 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.tar.bz2 2012-12-23 Less Python error backtraces are sent by mail. There is web page to navigate into the backtraces.
5.0.13.tar.bz2 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.tar.bz2 2012-10-29 Bug fixes release
5.0.10.tar.bz2 2012-10-17 Bug fixes release
5.0.6.tar.bz2 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.tar.bz2 2012-09-19 Fix problems with IE.
5.0.2.tar.bz2 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.tar.bz2 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.

Contact, forum, bug tracker

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.