[Building Sakai] Gradebook import/export features

[Mark Norton]

While CSV may have I18N problems, I don't think you an eliminate support 
for it. Too many other applications support it - like Excel. Supporting 
other interoperability formats is fine, but don't take away CSV.

- Mark Norton

DAVID ROLDAN MARTINEZ 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> 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
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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"