Hola lista!
Aqui estoy otra vez con un problema. Esta vez se trata de un problema al
momento de exportar información desde mi aplicacion a una planilla XLS.
Para generar el documento utilizo la gema ‘spreadsheet-excel’, y hasta
hace un tiempo todo funcionaba bien, pero cuando migré de S.O. (de
Windoze XP a Ubuntu 8.04) empecé con los problemas. Ahora cuando elijo
la opcion de “Generar” me envÃa el siguiente error:
Iconv::IllegalSequence in RepoController#xls_mineduc
“�a��”
|RAILS_ROOT: ./script/…/config/…|
Application Trace http://localhost:3000/repo/xls_mineduc# | Framework
Trace http://localhost:3000/repo/xls_mineduc# | Full Trace
http://localhost:3000/repo/xls_mineduc#
|/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/encodings.rb:23:in iconv' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/encodings.rb:23:in
internal’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/biff8.rb:34:in
_unicode_string' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:471:in
_write_sst’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/base.rb:1943:in
each_with_index' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:467:in
each’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:467:in
each_with_index' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:467:in
_write_sst’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:453:in
write_sst' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:403:in
write_from_scratch’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:568:in
write_workbook' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/writer.rb:14:in
write’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/writer.rb:13:in
open' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/writer.rb:13:in
write’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/workbook.rb:107:in
write' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel.rb:20:in
close’
/home/setzer/NetBeansProjects/elixir/app/controllers/repo_controller.rb:45:in
`xls_mineduc’|
|/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/encodings.rb:23:in iconv' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/encodings.rb:23:in
internal’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/biff8.rb:34:in
_unicode_string' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:471:in
_write_sst’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/base.rb:1943:in
each_with_index' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:467:in
each’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:467:in
each_with_index' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:467:in
_write_sst’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:453:in
write_sst' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:403:in
write_from_scratch’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:568:in
write_workbook' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/writer.rb:14:in
write’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/writer.rb:13:in
open' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/writer.rb:13:in
write’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/workbook.rb:107:in
write' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel.rb:20:in
close’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/base.rb:1101:in
send' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/base.rb:1101:in
perform_action_without_filters’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/filters.rb:696:in
call_filters' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/filters.rb:688:in
perform_action_without_benchmark’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/benchmarking.rb:66:in
perform_action_without_rescue' /usr/lib/ruby/1.8/benchmark.rb:293:in
measure’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/benchmarking.rb:66:in
perform_action_without_rescue' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/rescue.rb:83:in
perform_action’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/base.rb:435:in
send' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/base.rb:435:in
process_without_filters’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/filters.rb:684:in
process_without_session_management_support' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/session_management.rb:114:in
process’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/base.rb:334:in
process' /usr/lib/ruby/gems/1.8/gems/rails-1.2.6/lib/dispatcher.rb:41:in
dispatch’
/usr/lib/ruby/gems/1.8/gems/rails-1.2.6/lib/webrick_server.rb:113:in
handle_dispatch' /usr/lib/ruby/gems/1.8/gems/rails-1.2.6/lib/webrick_server.rb:79:in
service’
/usr/lib/ruby/1.8/webrick/httpserver.rb:104:in service' /usr/lib/ruby/1.8/webrick/httpserver.rb:65:in
run’
/usr/lib/ruby/1.8/webrick/server.rb:173:in start_thread' /usr/lib/ruby/1.8/webrick/server.rb:162:in
start’
/usr/lib/ruby/1.8/webrick/server.rb:162:in start_thread' /usr/lib/ruby/1.8/webrick/server.rb:95:in
start’
/usr/lib/ruby/1.8/webrick/server.rb:92:in each' /usr/lib/ruby/1.8/webrick/server.rb:92:in
start’
/usr/lib/ruby/1.8/webrick/server.rb:23:in start' /usr/lib/ruby/1.8/webrick/server.rb:82:in
start’
/usr/lib/ruby/gems/1.8/gems/rails-1.2.6/lib/webrick_server.rb:63:in
dispatch' /usr/lib/ruby/gems/1.8/gems/rails-1.2.6/lib/commands/servers/webrick.rb:59 /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in
gem_original_require’
/usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in require' /usr/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/active_support/dependencies.rb:495:in
require’
/usr/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/active_support/dependencies.rb:342:in
new_constants_in' /usr/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/active_support/dependencies.rb:495:in
require’
/usr/lib/ruby/gems/1.8/gems/rails-1.2.6/lib/commands/server.rb:39
/usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in
gem_original_require' /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in
require’
script/server:3|
|/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/encodings.rb:23:in iconv' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/encodings.rb:23:in
internal’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/biff8.rb:34:in
_unicode_string' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:471:in
_write_sst’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/base.rb:1943:in
each_with_index' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:467:in
each’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:467:in
each_with_index' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:467:in
_write_sst’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:453:in
write_sst' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:403:in
write_from_scratch’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:568:in
write_workbook' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/writer.rb:14:in
write’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/writer.rb:13:in
open' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/writer.rb:13:in
write’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/workbook.rb:107:in
write' /usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel.rb:20:in
close’
/home/setzer/NetBeansProjects/elixir/app/controllers/repo_controller.rb:45:in
xls_mineduc' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/base.rb:1101:in
send’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/base.rb:1101:in
perform_action_without_filters' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/filters.rb:696:in
call_filters’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/filters.rb:688:in
perform_action_without_benchmark' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/benchmarking.rb:66:in
perform_action_without_rescue’
/usr/lib/ruby/1.8/benchmark.rb:293:in measure' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/benchmarking.rb:66:in
perform_action_without_rescue’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/rescue.rb:83:in
perform_action' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/base.rb:435:in
send’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/base.rb:435:in
process_without_filters' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/filters.rb:684:in
process_without_session_management_support’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/session_management.rb:114:in
process' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/base.rb:334:in
process’
/usr/lib/ruby/gems/1.8/gems/rails-1.2.6/lib/dispatcher.rb:41:in
dispatch' /usr/lib/ruby/gems/1.8/gems/rails-1.2.6/lib/webrick_server.rb:113:in
handle_dispatch’
/usr/lib/ruby/gems/1.8/gems/rails-1.2.6/lib/webrick_server.rb:79:in
service' /usr/lib/ruby/1.8/webrick/httpserver.rb:104:in
service’
/usr/lib/ruby/1.8/webrick/httpserver.rb:65:in run' /usr/lib/ruby/1.8/webrick/server.rb:173:in
start_thread’
/usr/lib/ruby/1.8/webrick/server.rb:162:in start' /usr/lib/ruby/1.8/webrick/server.rb:162:in
start_thread’
/usr/lib/ruby/1.8/webrick/server.rb:95:in start' /usr/lib/ruby/1.8/webrick/server.rb:92:in
each’
/usr/lib/ruby/1.8/webrick/server.rb:92:in start' /usr/lib/ruby/1.8/webrick/server.rb:23:in
start’
/usr/lib/ruby/1.8/webrick/server.rb:82:in start' /usr/lib/ruby/gems/1.8/gems/rails-1.2.6/lib/webrick_server.rb:63:in
dispatch’
/usr/lib/ruby/gems/1.8/gems/rails-1.2.6/lib/commands/servers/webrick.rb:59
/usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in
gem_original_require' /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in
require’
/usr/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/active_support/dependencies.rb:495:in
require' /usr/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/active_support/dependencies.rb:342:in
new_constants_in’
/usr/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/active_support/dependencies.rb:495:in
require' /usr/lib/ruby/gems/1.8/gems/rails-1.2.6/lib/commands/server.rb:39 /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in
gem_original_require’
/usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in `require’
script/server:3|
Request
Parameters: {“fecha”=>{“fin”=>“2008-05-01”, “ini”=>“2008-01-01”},
“commit”=>“Generar”, “post”=>{“tipo”=>“XLS”},
“mineduc”=>{“peticion”=>“mineduc”}}
Show session dump http://localhost:3000/repo/xls_mineduc#
:empleado_region: 2
:empleado_nombre: Juan
:cadena:
- si
- “no”
- “no”
- “no”
- “no”
- “no”
- “no”
- “no”
- “no”
- “no”
- “no”
- “no”
- “no”
- “no”
- “no”
:col_id: 1
:empleado_apellido_p: “Ram\xC3\xADrez”
:empleado_id: 2
:empleado_rut: 15123625-1
flash: !map:ActionController::Flash::FlashHash {}
:ep: “77777777777788377”
Response
Headers: {“cookie”=>[], “Cache-Control”=>“no-cache”}
Revisando el log, me encontré con lo siguiente:
Iconv::IllegalSequence (“ña^@·”):
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/encodings.rb:23:in
`iconv’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/encodings.rb:23:in
`internal’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/biff8.rb:34:in
`_unicode_string’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:471:in
`_write_sst’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/base.rb:1943:in
`each_with_index’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:467:in
`each’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:467:in
`each_with_index’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:467:in
`_write_sst’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:453:in
`write_sst’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:403:in
`write_from_scratch’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/workbook.rb:568:in
`write_workbook’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/writer.rb:14:in
`write’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/writer.rb:13:in
`open’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/writer.rb:13:in
`write’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/workbook.rb:107:in
`write’
/usr/lib/ruby/gems/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel.rb:20:in
`close’
/home/setzer/NetBeansProjects/elixir/app/controllers/repo_controller.rb:45:in
`xls_mineduc’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/base.rb:1101:in
`send’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/base.rb:1101:in
`perform_action_without_filters’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/filters.rb:696:in
`call_filters’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/filters.rb:688:in
`perform_action_without_benchmark’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/benchmarking.rb:66:in
perform_action_without_rescue' /usr/lib/ruby/1.8/benchmark.rb:293:in
measure’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/benchmarking.rb:66:in
`perform_action_without_rescue’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/rescue.rb:83:in
`perform_action’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/base.rb:435:in
`send’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/base.rb:435:in
`process_without_filters’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/filters.rb:684:in
`process_without_session_management_support’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/session_management.rb:114:in
`process’
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/base.rb:334:in
process' /usr/lib/ruby/gems/1.8/gems/rails-1.2.6/lib/dispatcher.rb:41:in
dispatch’
/usr/lib/ruby/gems/1.8/gems/rails-1.2.6/lib/webrick_server.rb:113:in
handle_dispatch' /usr/lib/ruby/gems/1.8/gems/rails-1.2.6/lib/webrick_server.rb:79:in
service’
/usr/lib/ruby/1.8/webrick/httpserver.rb:104:in service' /usr/lib/ruby/1.8/webrick/httpserver.rb:65:in
run’
/usr/lib/ruby/1.8/webrick/server.rb:173:in start_thread' /usr/lib/ruby/1.8/webrick/server.rb:162:in
start’
/usr/lib/ruby/1.8/webrick/server.rb:162:in start_thread' /usr/lib/ruby/1.8/webrick/server.rb:95:in
start’
/usr/lib/ruby/1.8/webrick/server.rb:92:in each' /usr/lib/ruby/1.8/webrick/server.rb:92:in
start’
/usr/lib/ruby/1.8/webrick/server.rb:23:in start' /usr/lib/ruby/1.8/webrick/server.rb:82:in
start’
/usr/lib/ruby/gems/1.8/gems/rails-1.2.6/lib/webrick_server.rb:63:in
`dispatch’
/usr/lib/ruby/gems/1.8/gems/rails-1.2.6/lib/commands/servers/webrick.rb:59
/usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in
gem_original_require' /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in
require’
/usr/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/active_support/dependencies.rb:495:in
`require’
/usr/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/active_support/dependencies.rb:342:in
`new_constants_in’
/usr/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/active_support/dependencies.rb:495:in
require' /usr/lib/ruby/gems/1.8/gems/rails-1.2.6/lib/commands/server.rb:39 /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in
gem_original_require’
/usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in
`require’
script/server:3
Rendering
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.6/lib/action_controller/templates/rescues/layout.rhtml
(500 Internal Error)
Ahora, por lo que veo el problema claramente está en Iconv, pero no
logro entender que es lo que provoca este error ya que, como dije antes,
la aplicación funcionaba de maravillas…
¿Alguien tiene alguna idea de lo que puede estar sucediendo?
Desde ya, muchas gracias!!