[Building Sakai] Gradebook import/export features

[DAVID ROLDAN MARTINEZ]

Hi Mark,

If CSV doesn't work well in a i18n context, at least for our users and due to our particular environment, we cannot use it because it generates lots of complaints of our instructors and students. :-\

This is the reason to disable it and try to find/add other import/export options. What I was thinking is to introduce some configuration properfies at sakai.properties to be able to enable/disable import/export options.

What doy you think about the XML I proposed yesterday?

I would appreciate any comment or suggestion. Thank you very much in advance.

David
________________________________________
De: sakai-dev-bounces at collab.sakaiproject.org [sakai-dev-bounces at collab.sakaiproject.org] En nombre de David Horwitz [david.horwitz at uct.ac.za]
Enviado el: martes, 09 de marzo de 2010 15:14
Para: sakai-dev at collab.sakaiproject.org
Asunto: Re: [Building Sakai] Gradebook import/export features

Hi Mark,

Do you have a suggestion how csv can actually be made to work for users
of non-Unicode alphebets. BTW the reason for this is windows support of
utf8 in excel is so poor (Though its hard to knock MS as this is
consistent with the csv spec)

David

On 03/09/2010 04:03 PM, Mark Norton wrote:
> 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"
>>
> _______________________________________________
> 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"
>
_______________________________________________
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"