1. Home
  2. Dashboards and Reports
  3. Multi Language Font Handling in Export & Import Reports

Multi Language Font Handling in Export & Import Reports

This page details the procedure for multi language font handling in Export & Import reports in Uniware.

Applicability:

Version: Standard, Professional and Enterprise

Traceability: None, SKU, ITEM

Scope:

  • Export reports can now support data of any language from any specific country.
  • Hassle of us converting individually for a singular language like arabic removed.

  • All major excel tools are able to auto-decode UTF-8 language.

  • our system is encoded the export reports data into language = UTF-8 in order to provide support for all languages across globe

    1. External tools like excel / sheets etc can automatically.

    2. PII data for users who doesn’t have unmasking rights shall remain masked.

Procedure

Once user take export from uniware by the defined way e.g export by report options. He can get auto language support and data will be visible in to the desried language.

Any user having a export report having PII Unmasked Data containing Arabic/Any Language Letters (Apart from english)

On MAC → Application = Numbers:

  1. It automatically publishes correct & decoded data (ie actual say arabic language data shall be shown)

On Windows → Application = Windows Excel

  1. Format = XLS

    • It automatically publishes correct & decoded data (i.e. actual say arabic language data shall be shown)

  2. Format = CSV → It shows UTF Encoded Data

Steps

Reference

Step-1 : Open a Blank Workbook

Step-2 : Go into Tab = Data

Step-3 : Click on bottom arrow beside GET Data (PowerQuery )
Then click on From Text (Legacy)

Step-4 : Select the file you want to convert

Step 5 : Change the file origin to UTF-8 & Delimit / keep it in fixed width as per your needs

Step-6 : Final Output file

Sheet after decoding:

Book3

On Web → Application = Google Sheets

  1. If we upload the CSV file in it

  2. It automatically publishes correct & decoded data (ie actual say arabic language data shall be shown)

 

PR-2780     2898493470

Related Articles