Version 1 (modified by Fran Boon, 11 years ago) ( diff )


Import Excel

We have an Importer which uses CSV files and works very well when the correct data is entered.

The limitations of CSV, however, are that there is no client-side Validation or Online Help, so it is very easy for users to input incorrect data.

We'd like to allow deployers to build custom Excel workbooks which have protected fields for the core data inputs (like those used for feeding Assessments to the Survey module) and can then add additional Online Help & client-side Validation.

This project, therefore, is about designing a pre-processor for the current Importer back-end to allow .xls files to be uploaded & converting them to CSV before passing them to the current CSV importer.

Note: See TracWiki for help on using the wiki.