Happy Business Starts Here

Chinese characters exported using developer tool is un-readable

Highlighted
Zuora Support

Chinese characters exported using developer tool is un-readable

Problem: I have manually created some products and rate plans in this tenant. The product name and rate plan names are in Chinese. When I export them using developer tool, they are un-readable.

 

Solution:

The text changes to un-readable format due to the MS excel formatting condition.

We were able to change the un-readable text into Chinese text, please follow the steps provided below. 

Step 1: Open the file in Excel and go to the Data -> Get Data -> From File -> From Text/CSV
apiloader1 (2).png

Open the Same file Again in the Pop-Up window

Step 2:Select Unicode (UTF-8) in the File origin
api loader2.png


Step 3:
Once selected you will see the format change in the field, Click on load and save the sheet in the format - CSV UTF-8 (Comma delimited)(*.csv)

apiloader3 (2).png

Note : If suppose you are trying to make changes in the file and uploading it again in the API loader, we suggest you use the Text Editor instead of excel and save the file in .csv format.