How do I make my data UTF-8 encoded when I export to CSV?

Zerhar commented 2 years ago

When I export my data from a chart that contains the characters "å", "ä" or "ö" it does not get converted correctly and the characters get replaced with other special characters. The question is therefore how I make the data from the chart UTF-8 encoded. Thank you in advance.

martynasma commented 2 years ago

We'll add a CSV export option addBOM in the next version. It'll be set to true by default, so you won't need to do anything - just ugrade.

Will let you know here when the new version is out.

Thanks for bringing it to our attention!

martynasma commented 2 years ago

Implemented in 5.1.0.

[5.1.0] - 2022-01-20

Added

New Root setting: timezone. E.g. "America/Vancouver", "Australia/Sydney", "UTC".
New export CSV option: addBOM (default: true). Indicates whether to add BOM characters at start of CSV output so that data viewer (e.g. Excel) knows we're exporting UTF-8 data.
New methods for Adapters: remove(key), disable(key), and enable(key).
GaplessDateAxis added. It's a version of DateAxis that removes data-less intervals from its scale. CategoryAxis is being deprecated in favor of GaplessDateAxis. More info.
Timezone support added. More info.
New Component method: markDirtyValues(). Will re-evaluate elements of the component that are data-reliant, such as axis labels.

Fixed

Clearing axis ranges from Axis and Series was not working properly.
Slice with negative arc was ignoring cornerRadius property.
groupDataDisabled on XYSeries was not working if set to true.
Axis header was not updating its position if axes were stacked and size of an axis was updated.
Disposing of charts with a lot of elements was quite slow.
Series stacks with all-zero values could cause all stacks to disappear on zoom.

Full change log.

Download options.

Make sure you clear your browser cache after upgrading. And feel free to contact us again if you are still experiencing this issue.

amcharts / amcharts5