What's new

Importing Variable data sets with UTF 8 BOM japanese characters


mohad

New Member
Messages
2
Likes
1
Hi Guys,

I have an image template and have a xlsx file with Japanese characters wit two columns. I need to create images with this information by importing the CSV into variable data sets.

When I convert the xlsx into csv, I was seeing question marks instead of Japanese characters. So, I did some research on how to make it and work and found that we can save the file as txt with UTF 8 encoding and rename it as csv to retain the JP characters.

This is where the problem occurs. When I import this data, I get the error messageerror.JPG (refer error.jpeg). The spl character is not seen in the txt or csv file. Can someone plssss help me out here?
 

Paul MR

The Script Master
Messages
382
Likes
205
It works for me if the csv file is saved as UTF8.
Make sure when importing the dataset that you are importing as UTF8 as well.
2016-03-10_132121.jpg
I tested using フィールド1 as the field name
 

Top