SAP Knowledge Base Article - Public

3486070 - Import excel files with custom widget fails when dimension IDs contain Chinese characters.

Symptom

When importing dimension IDs with Chinese, the import failed.

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. Upload the custom widget.
  2. Open a story, add this widget to story.
  3. Click on import, upload excel file for importing.
  4. The import failed.
  5. Check failed rows, for dimension IDs with Chinese characters, it is displaying garbled codes.

Cause

The issue lies with parsing the Excel file in the Widget itself. When you upload a file to the widget, the widget parses the data within it and sends it to the Data Import API, which imports the data to your model. The library used to parse excel files is reading the string incorrectly.

Resolution

Custom Widgets are out of our support scope, so we do not deliver a fix. Refer: 3411460 - Case processing related to Custom Widgets, Custom Add-Ons or CSS classes

As workarounds, we suggest:

  1. Import the data as CSV. 
  2. Implement the encoding yourselves. We have designed this custom widget in such a way that it is easily extendable by customers who want to implement their own logic. More information on how to do this can be found in this blog post: File Upload Widget – How to develop custom widgets with the react framework.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

file upload xlsx, import API, import from widget. , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , Problem

Product

SAP Analytics Cloud all versions