Changes between Version 13 and Version 14 of BluePrint/Importer/Excel


Ignore:
Timestamp:
10/27/15 11:20:22 (6 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • BluePrint/Importer/Excel

    v13 v14  
    22[[TOC]]
    33
    4 We have an [UserGuidelinesImporter Importer] which uses CSV files and works very well when the correct data is entered.
     4We have an [UserGuidelines/Importer Importer] which uses CSV files and works very well when the correct data is entered.
    55
    66The 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 (e.g. Dates).
    77
    8 To overcome that, we're looking for a pre-processor that converts XLS (MS Excel) sheets into CSV before importing.
     8To overcome that, we looked for a pre-processor that converts XLS (MS Excel) sheets into CSV before importing.
    99
    10 NB This should also help us with ensuring that imported data is properly UTF-8. MS Excel tends to save CSVs as ANSI whilst it defaults to UTF-8 from 97+ & provides the encoding sed for older versions which can be picked up by xlrd:
     10NB This should also help us with ensuring that imported data is properly UTF-8. MS Excel tends to save CSVs as ANSI whilst it defaults to UTF-8 from 97+ & provides the encoding used for older versions which can be picked up by xlrd:
    1111
    1212  * https://secure.simplistix.co.uk/svn/xlrd/trunk/xlrd/doc/xlrd.html