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

[DAVID ROLDAN MARTINEZ]

+1 I agree. CSV are giving us anything but terrible headaches. :)

But, in the case of gradebook, if you disable CSV, for example, you also have to change the template teachers download to import grade into gradebook because this template is for CSV and you also will have to change message bundles and help files.

-----Mensaje original-----
De: i18n-bounces at collab.sakaiproject.org [mailto:i18n-bounces at collab.sakaiproject.org] En nombre de David Horwitz
Enviado el: miércoles, 03 de marzo de 2010 9:53
Para: Nuno Fernandes
CC: i18n at collab.sakaiproject.org; sakai-dev
Asunto: Re: [WG: I18N & L10N] utf-8 & csv

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"
>>
>>     
>
>
>   
_______________________________________________
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.org with a subject of "unsubscribe"