[Building Sakai] Gradebook import/export features

[DAVID ROLDAN MARTINEZ]

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> 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; 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100309/e2b6fe0c/attachment.html