Your Achievements
Level 1
0% to
Level 2
Next /
to gain points, level up, and earn exciting badges like the new Applaud 5 BadgeLearn more!
View All BadgesSign in to view all badges
Open Alert Bar
SOLVED

Importing leads in non-Western fonts Japanese, Chinese etc.

Go to solution
Anonymous
Not applicable
‎06-03-2013 05:09 PM
‎06-03-2013 05:09 PM

Importing leads in non-Western fonts Japanese, Chinese etc.

We received a few lead lists from our partner in Japan. It's an Excel file with all Japanese fonts. When I convert it into .CSV, everything is lost (Japanese fonts are converted into a bunch of underscores). Has anyone ever imported leads listed in Japanese (or Chinese or Korean) fonts in Marketo before? Any work around that you can think of? My view is that it will create several complications in Salesforce as well but I would like to know if someone has already tried this before.

Thanks,
Franco
Labels:
Tags (1)
0 Likes
1,294
Reply
1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable
‎06-04-2013 03:35 AM
‎06-04-2013 03:35 AM

Re: Importing leads in non-Western fonts Japanese, Chinese etc.

Using the following process helped me in some cases in the past:
  • prerequisite - have a google drive account.
  • upload csv to said account
  • open on google drive, then select download as csv. by default, google drive encodes csv files in utf-8.
  • without opening the csv in a local program, try loading to marketo

View solution in original post

0 Likes
1,104
Reply
5 REPLIES 5
Anonymous
Not applicable
‎06-04-2013 01:33 AM
‎06-04-2013 01:33 AM

Re: Importing leads in non-Western fonts Japanese, Chinese etc.

The original file either needs to be exported in Unicode (UTF-8) character set or, if done already, you need to set your spreadheet to use that character set.

OpenOffice handles multiple character sets very cleanly. MS-Excel is supposed to do that reasonably well.
0 Likes
1,104
Reply
Anonymous
Not applicable
‎06-04-2013 01:40 AM
‎06-04-2013 01:40 AM

Re: Importing leads in non-Western fonts Japanese, Chinese etc.

Talend Open Studio (free edition available at http://www.talend.com/) is a good resource if the original files cause consistent conversion problems.

Your computer must have Unicode (UTF-8) characetr set installed. By default Mac OS X and Liniux have, MS-Windows may need to have it enabled.
0 Likes
1,104
Reply
Anonymous
Not applicable
‎06-04-2013 03:35 AM
‎06-04-2013 03:35 AM

Re: Importing leads in non-Western fonts Japanese, Chinese etc.

Using the following process helped me in some cases in the past:
  • prerequisite - have a google drive account.
  • upload csv to said account
  • open on google drive, then select download as csv. by default, google drive encodes csv files in utf-8.
  • without opening the csv in a local program, try loading to marketo
0 Likes
1,105
Reply
Anonymous
Not applicable
‎06-04-2013 02:37 PM
‎06-04-2013 02:37 PM

Re: Importing leads in non-Western fonts Japanese, Chinese etc.

Thank you everyone for your answers, I was able to solve these issue. Unfortunately OpenOffice has some weird behaviors with the Mac version (it worked well on Windows). Both Talend and Google Drive solved this issue, even though I would recommend Talend for larger data set (we only had a couple of hundreds leads).

Franco
0 Likes
1,104
Reply
Anonymous
Not applicable
‎06-05-2013 01:59 AM
‎06-05-2013 01:59 AM

Re: Importing leads in non-Western fonts Japanese, Chinese etc.

Talend is indeed the most suitable option for large data sets. I used it successfully in a previous job as Oracle DBA with really big data sets, typical of most Oracle environments.

It is sad OpenOffice for Mac did not work well for you. I am proudly an Unix hardliner. Mac OS X is my desktop of choice (it is based on FreeBSD, a POSIX). OO is not perfect yet. LibreOffice is a step ahead.
Still, I agree, Idan's sugegstion and Talend are the way to go!

0 Likes
1,104
Reply
Home