topic Re: Problems with utf-8 in All Apps and Add-ons

Problems with utf-8

gpburgett — Tue, 17 Jan 2012 07:01:57 GMT

I'm trying to export some data with Korean characters, but when I click to export I get a txt file with the following trace:

Unrecoverable error in the server.
Traceback (most recent call last):
  File "/Users/notgary/Splunk/Sites/XX_splunk/lib/python2.6/site-packages/cherrypy/_cpwsgi.py", line 163, in next
    chunk = self.iter_response.next()
  File "<string>", line 189, in generate_from_stream
  File "/Users/notgary/Splunk/Sites/XX_splunk/etc/apps/excel_export/bin/xlwt/Worksheet.py", line 1003, in write
    self.row(r).write(c, label, style)
  File "/Users/notgary/Splunk/Sites/XX_splunk/etc/apps/excel_export/bin/xlwt/Row.py", line 231, in write
    StrCell(self.__idx, col, style_index, self.__parent_wb.add_str(label))
  File "/Users/notgary/Splunk/Sites/XX_splunk/etc/apps/excel_export/bin/xlwt/Row.py", line 150, in insert_cell
    raise Exception(msg)
Exception: Attempt to overwrite cell: sheetname=u'splunk_results' rowx=0 colx=0

Everything works fine when everything is English. I'm going to keep trying, but please let me know if you have any ideas about what might be going wrong. Thanks.

Re: Problems with utf-8

araitz — Tue, 17 Jan 2012 21:27:50 GMT

EDIT: see answer below, my initial suspicions were off.

Re: Problems with utf-8

araitz — Tue, 17 Jan 2012 21:58:44 GMT

This was just a lame error on my part. In appserver/controllers/excel.py, this:

186         # write the header
187         for field in fieldNames:
188             result_sheet.write(0,i,field)
189         i = i + 1

should be this (notice the indent):

186         # write the header
187         for field in fieldNames:
188             result_sheet.write(0,i,field)
189             i = i + 1

The fixed version is available on Splunkbase right now (version 1.1.1). You can also just make the above change (add 4 spaces on line 189) and then restart Splunk to get the same result.

Re: Problems with utf-8

araitz — Thu, 19 Jan 2012 03:09:51 GMT

I made a few more tweaks in 1.2 which is available today.