[Building Sakai] Gradebook import/export features
Feliz Gouveia
fribeiro at ufp.edu.pt
Wed Mar 10 07:20:19 PST 2010
Sorry to come late on this.
We are running 2.6.1 and our gradebook export seems to be doing fine (with
accents, cedille,...).
I can export in xls and csv formats, and I'm using OpenOffice and Notepad
(or some other utf8 capable editor). Everything is ok. I'm not sure if they
are out of the box, or modifed by us, but Nuno can comment on that.
If a client does not understand utf8 (NoteTab for example doesn't -- I think
Excel does not too) I get wrong characters. But if I use utf8-capable
applications, then information comes ok. What people need to be aware is
that most of the time they are using computers in another encoding than utf8
(normally iso8859-1 or cp1252) and some applications cannot translate
between the two. There's no way for Sakai to know which application we are
going to use, so no way to switch the enconding.
If you use the applications I mentioned do you get the same weird results?
would you like to test our export functions?
greetings
Feliz
On 10 March 2010 12:55, Wagner, Michelle R. <wagnermr at iupui.edu> wrote:
> Hi David,
> How are you going to handle the existing data in the CONTENT column of the
> GB_SPREADSHEET_T table? Are you envisioning adding a new column for the xml
> format?
>
> Thanks,
> Michelle
>
>
>
> On 3/9/10 8:26 AM, "DAVID ROLDAN MARTINEZ" <darolmar at upvnet.upv.es> wrote:
>
> Hi all,
>
> As it has been intensely discussed in this list last week, CSV doesn’t
> support UTF-8 characters and this causes problems from a i18n point of view.
>
> I’m currently working on improving import/export gradebook features but I
> have some doubts and I would appreciate any help you can give me.
>
> At GB_SPREADSHEET_T table there is a field, CONTENT, to store a csv-like
> file. Instead I propose to store spreadsheet data in XML format. For
> example:
> <sheet>
> <header_row>
> <headers>
> <header assignmentId=”ref1”
> value=”ASSIGNMENT 1”/>
>
> …..
> <header assignmentId=”refN”
> value=”T&Q 5”/>
> </headers>
> </header_row>
>
> <data>
> <row userId=”user1”>
> <grades>
> <grade assignmentId=”ref1”
> value=”8.5”/>
>
> …..
> <grade assignmentId=”refN”
> value=”50”/>
> </grades>
> </ row>
>
> …..
> <row userId=”userX”>
> <grades>
> <grade assignmentId=”ref1”
> value=”5”/>
>
> …..
> <grade assignmentId=”refN”
> value=”10”/>
> </grades>
> </ row>
> </data>
> </sheet>
>
> In this way, we can easily parse the XML into a HSSFSheet POI element,
> which has no problem with UTF-8.
>
> Before to start to coding, I would like to know what do you think about
> this. Of course, I would appreciate any help or guidance to solve this
> problem.
>
> Thank you very much in advance.
>
> David
>
>
>
>
> *De:* Wagner, Michelle R. [mailto:wagnermr at iupui.edu <wagnermr at iupui.edu>]
>
> *Enviado el:* lunes, 08 de marzo de 2010 14:52
> *Para:* DAVID ROLDAN MARTINEZ
> *Asunto:* Re: http://jira.sakaiproject.org/browse/SAK-15480
>
> Thanks for your help, David! Are you still able to use the import
> spreadsheet functionality?
>
>
> On 3/8/10 8:50 AM, "DAVID ROLDAN MARTINEZ" <darolmar at upvnet.upv.es> wrote:
> Hi Michelle,
>
> I’m currently working on it because we’re receiving lots of complaints from
> our users. I’ve completely disabled CSV export/import capabilities. As soon
> as I’ve finished and tested it in our production environment, I’ll provide a
> patch for 2.6.x so that you can merge it in trunk or 2.7.
>
> Regards,
> David
>
>
> *De:* Wagner, Michelle R. [mailto:wagnermr at iupui.edu <wagnermr at iupui.edu>]
>
> *Enviado el:* lunes, 08 de marzo de 2010 14:44
> *Para:* DAVID ROLDAN MARTINEZ
> *CC:* arwhyte at umich.edu; Berg, Alan; jean-francois.leveque at upmc.fr
> *Asunto:* Re: http://jira.sakaiproject.org/browse/SAK-15480
>
> I am looking into this solution further. I talked with David Horwitz about
> this recently, and I verified with our designer and some of our functional
> users that they would be fine dropping the csv export and instead utilize
> the xls export. I am concerned that this will affect the ability to import
> the spreadsheet, but I’m just starting to look into it.
>
> Thanks,
> Michelle
>
>
> On 3/6/10 4:38 PM, "DAVID ROLDAN MARTINEZ" <darolmar at upvnet.upv.es> wrote:
>
>
> Hi Michelle,
>
> As you may know, we are reviewing all i18n bugs in Sakai to try
> to solve them as soon as possible. The issue SAK-15480 is related with CSV
> and UTF-8. The suggested solution is to disable CSV export capability from
> Gradebook as CSV doesn't support UTF-8 characters (
> http://drupal.org/node/172996). We would like to know your thoughts about
> that.
>
> Thank you very much in advance.
>
> David
>
>
> _______________________________________________
> 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"
>
--
Feliz Ribeiro Gouveia
Universidade Fernando Pessoa http://www.ufp.pt
Centro de Recursos Multimediaticos Tel 351-22.507.13.06
M.I.N.D. Lab Fax 351-22.550.82.69
Pr 9 de Abril 349 fribeiro at ufp.edu.pt
P-4249-004 Porto
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100310/0706a28b/attachment.html
More information about the sakai-dev
mailing list