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

[Shoji Kajita]

Hi there,

We are also facing the same problem. So +1

Shoji, East Asia

At Wed, 3 Mar 2010 10:12:57 +0100,
DAVID ROLDAN MARTINEZ wrote:
> 
> +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"
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> 
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"