Happy Business Starts Here

Highlighted
Master

When importing a CSV file to Zuora, be careful with character codes

I and my customers are Japanese. We may use Japanese as Units of Measure (UOM).

For example, we use "回" which means "times".

 

By the way, I know that the world standard character code is UTF.
Meanwhile, in Japan, it is still often to use something specific to our country as the character code of the text file (Shift JIS, etc.).

The default setting of the text editor is often Shift JIS.

 

Well, I encountered an error trying to import the CSV file of Usage that written Japanese UOM into Zuora.
Yes, the problem was in the character code.

The UOM "回" set on Tenant UI was recognized by Zuora as UTF-8,

and Zuora did not regard the same "回" of the character code Shift JIS I wrote in the CSV file.

I received the following error message about UOM (So-called "Mojibake"):

id,Message,ACCOUNT_ID,UOM,QTY,STARTDATE,ENDDATE,SUBSCRIPTION_ID,CHARGE_ID,DESCRIPTION
"",The UOM does not match,A00098284,��,1,2017/10/1,2017/10/1,A-S00280829,C-00280841,

I set the character code to UTF-8 in my text editor setting and avoided this error.

 

I call attention to people who are not in English speaking countries.
When importing a CSV file to Zuora, be careful with character codes.