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

[Nuno Fernandes]

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"
>



-- 
Nuno Fernandes

Profile    | http://facebook.com/nfgrilo | http://linkedin.com/in/nfgrilo
Web      | http://codingwithcoffee.com | http://twitter.com/nfgrilo
Work     | Analyst/Programmer @ UFP-UV [http://elearning.ufp.pt]
             | Analyst/Programmer @ Sakai Foundation [
http://sakaiproject.org]
             | Sakai Fellow 2008 @ Sakai Foundation [
http://confluence.sakaiproject.org//x/6oCTAQ]
Address | Universidade Fernando Pessoa  [http://www.ufp.pt]
             | Praça 9 de Abril, 349    | 4249-004 Porto
             | tel: + 351 22 507 13 00 | fax: + 351 22 550 82 69
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/i18n/attachments/20100303/e6ec9d93/attachment.html