Japanese Kana (Japanese syllabary) are added when importing Excel file - Known Error

Japanese Kana (Japanese syllabary) are added when importing Excel file Description Japanese Kana (Japanese syllabary) are added when importing Excel (xlsx) file that includes Japanese. The Japanese Kana, which is the Japanese Katakana character of the Kanji imported, should not be added.

Steps to Reproduce

Download the attached Excel file named 20161011.xlsx. Open the Excel file. Confirm u_organization_name fields are: ID 管理 IS- 社員 Log in to your instance. Navigate to System Import Sets > Load Data .

Select Create table .

Type in a Label .

Select File . Click Chose File and navigate to the Excel file you downloaded in step 1.

Click Submit .

Click Load data .

Click one of the numbers in the Row column.

Confirm Japanese Kana ( シャイン ) is added to the Organization name field.

Workaround If using older version earlier than Washington DC.

>>This error is specific to the .xlsx format. In Microsoft Excel, convert the .xlsx file into .xls format. Then, import the file into the ServiceNow instance.

This issue is already fixed from Washington DC version.

1. To exclude Japanese Kana from source Excel file, will needs to set below system property to false

glide.excel.concat_phonetic_runes = false

2. run "cache.do" in instance "Filter Navigator" to make sure property change is applied at server side.