Error on form submit when school year name has accented characters

[Ricardo]

Error trying to import courses from a simple CSV file.

This is the content of the CSV file
"Matematicas.,,
Geografía.,,
Biología.,,
Educación Física.,,
Historia.,,
Teatro.,,"

and I get this:

Ha ocurrido un error del servidor interno. Esto probablemente significa que ha encontrado un fallo en SchoolTool. Por favor reportelo a la seccion de fallos..
Excepción

UnicodeEncodeError: 'ascii' codec can't encode character u'\xf1' in position 45: ordinal not in range(128)

Traza

File "/usr/lib/python2.7/dist-packages/zope/publisher/publish.py", line 132, in publish
  result = publication.callObject(request, obj)
File "/usr/lib/python2.7/dist-packages/zope/app/publication/zopepublication.py", line 207, in callObject
  return mapply(ob, request.getPositionalArguments(), request)
File "/usr/lib/python2.7/dist-packages/zope/publisher/publish.py", line 107, in mapply
  return debug_call(obj, args)
Extra information: <schooltool.skin.flourish.zcml_content.FlourishCourseCSVImportView_csvimport.html object at 0x7f98142e7d10>
File "/usr/lib/python2.7/dist-packages/zope/publisher/publish.py", line 113, in debug_call
  return obj(*args)
File "/usr/lib/python2.7/dist-packages/schooltool/skin/flourish/page.py", line 77, in __call__
  self.update()
File "/usr/lib/python2.7/dist-packages/schooltool/app/browser/csvimport.py", line 167, in update
  return BaseCSVImportView.update(self)
File "/usr/lib/python2.7/dist-packages/schooltool/app/browser/csvimport.py", line 127, in update
  self.request.response.redirect(next_url)
File "/usr/lib/python2.7/dist-packages/zope/publisher/browser.py", line 759, in redirect
  return super(BrowserResponse, self).redirect(location, status, trusted)
File "/usr/lib/python2.7/dist-packages/zope/publisher/http.py", line 877, in redirect
  location = str(location)

[Tom Hoffman (tom-hoffman)]

Please use the XLS import sheet for courses.

[Gediminas Paulauskas (menesis)]

The import succeeds, only redirect back to the courses list fails.

[Ricardo (ricardoeureka)]

El 03/10/13 11:01, Tom Hoffman escribió:
> Please use the XLS import sheet for courses.
>
Dear Tom

Thank you very much for your response. I will try XLS import, but, I'd
really like to make the CSV import work.
Is it possible? Is this a known bug to be solved in future versions or
I'm doing something wrong?
Thanks in advance for your support and help

[Ricardo (ricardoeureka)]

El 03/10/13 11:03, Gediminas Paulauskas escribió:
> The import succeeds, only redirect back to the courses list fails.
>
> ** Changed in: schooltool
> Status: New => In Progress
>
> ** Changed in: schooltool
> Importance: Undecided => High
>
> ** Changed in: schooltool
> Assignee: (unassigned) => Gediminas Paulauskas (menesis)
>
Dear Gediminas,
That's not correct. The import is failing: data is not loaded into the
database

[Tom Hoffman (tom-hoffman)]

Generally, we're moving toward removing these CSV imports and just supporting the XLS imports.

[Gediminas Paulauskas (menesis)]

I reproduced this same error with a school year name with accented characters, e.g. vacación

the URL would be http://localhost:7080/schoolyears/vacación/courses/csvimport.html and it fails to get back to courses list.

Maybe you need to choose a different encoding, e.g. ISO-8859-1 for Spanish? But I get a red error message saying "Could not convert data to Unicode (incorrect charset?)" instead of an exception.

What version of SchoolTool are you running? Look at the bottom of the page.

[Ricardo (ricardoeureka)]

El 03/10/13 12:52, Gediminas Paulauskas escribió:
> I reproduced this same error with a school year name with accented
> characters, e.g. vacación
>
> the URL would be
> http://localhost:7080/schoolyears/vacación/courses/csvimport.html and it
> fails to get back to courses list.
>
> Maybe you need to choose a different encoding, e.g. ISO-8859-1 for
> Spanish? But I get a red error message saying "Could not convert data to
> Unicode (incorrect charset?)" instead of an exception.
>
> What version of SchoolTool are you running? Look at the bottom of the
> page.
>
I'm running version 2.1 on Ubuntu 12.04, but I think that the situation
you reproduced is not exactly the same:
- I have no accent on the yearschool
- I used ISO-8859-1 with same result
- I tried to load both CSV and on the screen without any accent with the
same result.

I figured out the problem: I entered "Año 2013" for the school year's
name. It seems that the "ñ" is the issue. I created a new schoolyear,
named only "2013" and I succeeded to load a CSV both from file and in
the screen manually.
Thanks for your time

[Gediminas Paulauskas (menesis)]

Yes, accented characters in school year name have caused this issue.

I have fixed similar problem in several other pages. Additionally, made sure that selected school year is preserved when navigating and submitting forms inside the School tab.

This will be in 2.6.0 release next week.