[WG: I18N & L10N] utf-8 & csv

[David Horwitz]

Great - the roster export is now xls and the Gradebook team is looking
at switiching those experts to xls too.

Maybe we need a note in the l18n docs about not using csv?

D

On 03/03/2010 10:36 AM, Nuno Fernandes wrote:
> Hi David!
>
> We also suffer from CSV/UTF-8 problems so, in the specific case of
> Gradebook, we went back and grab the code for exporting XLS. Yes, Gradebook
> did provide exportation for both CSV and XLS so we just inverted the
> commit(s) that disabled that on a previous release. I guess XLS export was
> disabled back on 2.5...?
>
> We are using this patch in our 2.6.x based instance:
> https://elearning.ufp.pt/sakai-patches/2.6.x/Gradebook_UFP-38.patch
>
> Overall, we do always prefer XLS instead of CSV because of poor/inexistent
> I18N support in CSV (mainly in Windows).
>
> Best regards,
> Nuno
>
> On Mon, Mar 1, 2010 at 4:20 PM, David Horwitz <david.horwitz at uct.ac.za>wrote:
>
>   
>> Hi All,
>>
>> (sorry for the cross posting) While investigating SAK-15480 & SAK-15479
>> that both deal with problems experiences with csv exports that contain
>> utf8 characters, I discovered the following:
>>
>> 1) The csv spec only specifies unicode
>> 2) Ms office (at least on Win) doesn't support utf8 in csv
>> 3) openoffice (at least on *nix) does support utf8
>>
>>
>> In the case of the roster it seemed that the easiest was to switch the
>> export to actually export a xls sheet, as this is probably what most
>> users expect. Does anyone see a problem with this? and any reason the
>> same solution shouldn't be used in gradebook?
>>
>> D
>> _______________________________________________
>> i18n mailing list
>> i18n at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/i18n
>>
>> TO UNSUBSCRIBE: send email to i18n-unsubscribe at collab.sakaiproject.orgwith a subject of "unsubscribe"
>>
>>     
>
>
>