Jaime reported issues when creating an import template record using the separator |
Found that using the String.split function is very brittle as it expects a regular expression there, and the validation would also fail with quoted strings, so is better to use SuperCSV for that purpose.
There are several potential improvements identified for the CSV Import Template:
EOL character configurable (the importer is failing when the file comes with windows EOL)
During development was found that EOL is managed properly reading DOS/Unix/MAC files, the problem is when the UTF-8 file comes with BOM character
Delimiter configurable
Quote delimiter configurable
Allow also import of XLS and XLSX