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
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.
Related Problem: PRB717095