You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@jmeter.apache.org by bu...@apache.org on 2017/07/20 20:04:27 UTC
[Bug 61317] Since 3.2 exporting aggregate report to .csv no longer
supports "non UTF-8"
https://bz.apache.org/bugzilla/show_bug.cgi?id=61317
Philippe Mouawad <p....@ubik-ingenierie.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
CC| |p.mouawad@ubik-ingenierie.c
| |om
OS| |All
--- Comment #1 from Philippe Mouawad <p....@ubik-ingenierie.com> ---
(In reply to LinardAtTenForce from comment #0)
> Step to reproduce:
> 1. Create a .jmx file with a request containing a typical ISO-8859-1
> character, for example "Kopiëren" (Dutch for 'to copy')
> 2. Run the JMeter test to produce a .jtl file
> 3. Open the .jtl in an Aggregate Report listener.
> 4. Export the table to .csv
> 5. Open the .csv file in a spreadsheet editor (e.g. Excel)
How do you do that ? Are you sure you respect encoding of file ?
https://stackoverflow.com/questions/6002256/is-it-possible-to-force-excel-recognize-utf-8-csv-files-automatically
> 6. Notice that the label has become "Kopiëren"
Are you sure it's not the way you open it in excel that is broken ?
>
> Expected:
> 6. The label remains "Kopiëren" and is readable.
>
> This scenario works in version 2.13, 3.0 and 3.1, but broke in 3.2.
>
> I expect that the scenario broke since this commit:
> 24e22e433 ("sonar: fix errors and false-positive Fix missing Encoding issue
> by saving in UTF-8", 2016-12-28)
> git-svn-id: https://svn.apache.org/repos/asf/jmeter/trunk@1776330
> 13f79535-47bb-0310-9956-ffa450edef68
>
> It seems that the bug is still present on trunk:
> https://svn.apache.org/viewvc/jmeter/trunk/src/components/org/apache/jmeter/
> visualizers/StatVisualizer.java?view=markup#l220
>
> I don't know the project well enough to define the best solution. But if it
> helps, these are 3 alternative approaches to resolve the issue:
>
> * Revert line that introduced the hardcoding of UTF-8 character set.
>
> * Replace it by using the existing property "_file_encoding" specified in
> "saveservice.properties" (According to the documentation: Character set
> encoding used to read and write JMeter XML files and CSV results)
> By default it is set to "_file_encoding=UTF-8", but can be configured to be
> "_file_encoding=ISO-8859-1"
> This property is already used for reading/writing to .jmx and .jtl file
> (Steps 1-3) but not in reading/writing this .csv (Step 4).
>
> * Provide the Byte Order Mark when writing in UTF-8, so that other program
> that consumes the .csv file can be sure that the text stream is in Unicode.
I tested your scenario, it works fine for me with LibreOffice.
I don't have Excel.
--
You are receiving this mail because:
You are the assignee for the bug.