OL Learn

Datamapper - sort does not preserve encoding


If I enable sorting in datamapper (XLSX file), cyrillic characters in file becomes “???” after sort.

Data before sort

Data after sort

Is there a solution for this problem beside “sort file manually before sending it to datamapper”?


That seems like an undesirable issue. I suggest you open a technical support ticket through our website.
A technician will be able to try and reproduce the issue, look with you for a workaround and report the issue to our R&D.

We have checked in the source code and there appears to be an issue with the sorting algorithm for XLS files. We will have to fix it in a future version.

In the meantime, if you save your file as a CSV (UTF-8) in Excel, then it works fine in the DataMapper.

@hamelj: I will create a ticket myself.

Internal ticket number: SHARED-84119.