[Building Sakai] Gradebook import/export features
DAVID ROLDAN MARTINEZ
darolmar at upvnet.upv.es
Wed Mar 10 13:19:39 PST 2010
Hi,
Thanks for your suggestion Feliz. I know that is not a problem from Sakai but I have to adapt Sakai to work with CSV generated by whichever application because CSV import, as it is now, are genereted lots of complaints from our users. That's why I though in implementing import also from Excel file and not only from CSV.
David
________________________________________
De: Feliz Gouveia [fribeiro at ufp.edu.pt]
Enviado el: miércoles, 10 de marzo de 2010 16:20
Para: sakai-dev
CC: DAVID ROLDAN MARTINEZ
Asunto: Re: [Building Sakai] Gradebook import/export features
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<mailto: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<http://darolmar@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]
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<http://darolmar@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]
Enviado el: lunes, 08 de marzo de 2010 14:44
Para: DAVID ROLDAN MARTINEZ
CC: arwhyte at umich.edu<http://arwhyte@umich.edu>; Berg, Alan; jean-francois.leveque at upmc.fr<http://jean-francois.leveque@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<http://darolmar@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<mailto: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<mailto: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<mailto:fribeiro at ufp.edu.pt>
P-4249-004 Porto
More information about the sakai-dev
mailing list