Re: Russian Characters import

Anonymous
Not applicable

Russian Characters import

Hello,

Does Marketo list import accept Russian language characters?

Thanks.

12 REPLIES 12
Josh_Hill13
Level 10 - Champion Alumni

Re: Russian Characters import

Yes. Use UTF8 for all imports. There are instructions in another thread.

I'm not so sure Marketo is good at displaying such characters, but it can use them.

Dan_Stevens_
Level 10 - Champion Alumni

Re: Russian Characters import

Anytime you work with a list with special characters like this, always export as "Unicode Text File".  Then during the import process, be sure to select "tab-delimited".  As long as you remember those two points, the data should import successfully into Marketo.

Anonymous
Not applicable

Re: Russian Characters import

Hi Dan

I want to know reason why the user have to select "tab-delimied".

In my similar case, marketo support recommend me "comma-delimita".

Dan_Stevens_
Level 10 - Champion Alumni

Re: Russian Characters import

A Unicode text file contains values separated by tabs, not commas.  Comma separated only works with CSV files. Perhaps they're referring to the more complex process that Josh referenced above - saving the file with UTF-8 encoding, manually entering the commas (using find/replace) and then saving the file as a CSV. But that process/effort isn't required. Just use what I explained and you'll be fine. We'be been importing list of names from Europe and APAC for years using this method, with no issues at all. ​

Anonymous
Not applicable

Re: Russian Characters import

Thank you Dan and Josh!

Anonymous
Not applicable

Re: Russian Characters import

Hi,

I saved as a tab delimited file in UTF8 format.

Still no luck importing Russian Characters, they appear on the import preview as "??????? ?????".

Please could you tell me how to find other threads about this, I have searched with no luck...

Thanks in advance.

Anonymous
Not applicable

Re: Russian Characters import

Hi Ruth

Dan's advice is unicode but not UTF8.

Could you try with unicode encoding?

Dan_Stevens_
Level 10 - Champion Alumni

Re: Russian Characters import

You need to save/export as "Unicode Text" file (which will produce a .txt file) - not UTF8.

SanfordWhiteman
Level 10 - Community Moderator

Re: Russian Characters import

To clarify some of the back-and-forth:

  • "Unicode Text" in an export dropdown is usually a confusing shorthand for UTF-16 (or in some old software, UCS-2) encoding
  • "UTF-8" means, well, UTF-8 encoding

Neither one is "Unicode" (since Unicode is an abstraction more than a data format).  So if the software you're using is giving you the literal choice of "UTF-16," that's your choice.  It may be that your app is only capable of outputting UTF-8, in which case you're going to need to convert it somehow.