Managing student list by spreadsheet (Feature #45)

Teachers often manage student lists using spreadsheet software such as Excel/OpenOffice, they will be happy if AMC accepts "proper" CSV files generated by such software. Here, "proper" means that fields may be enclosed in double-quotes (" "), double-quote itself is escaped by another double-quote, and fields may include commas and line-breaks (CRLF or LF? or CR?). Also some software precede zero-padded numbers with single-quote for text format.

AMC seems to remove enclosing double-quotes, but does not handle special characters in fields.

I am not a perl expert, but I think most of the process may be done by Text::CSV module.

Further, column names for student names will vary in such lists on the spreadsheet, for example, firstname, lastname, fullname, and even in other languages. Is it possible to specify the column names representing student names, which is used in the manual association window?