2

I'm having problems trying to export a data extension from Salesforce Marketing Cloud to FTP.

I created an Automation to extract this file, but I want to extract in UTF-8, my database only import files in this format.

So, how can I convert my data extract to UTF-8, instead of UTF-16?

I've tried to add a new Data Extract Activity, using ExtractType: Custom UTF-16 to UTF-8 Encoding. But that it isn't working, occur an error in this activity. I've fund that some guy did a File Convert, but I can not find that option in my Salesforce Marketing Cloud Business Unit.

4
  • Here is that guy :D with that file convert. It needs three steps: 1 dataextraxt of dataextension, 2: dataextraction option file convert, 3 File Export. Can you specify what you do not find? Commented Jul 1, 2019 at 20:52
  • Hi Johannes, thanks for the reply. I didnt get the "File Convert" step. When I created the second Data Extract, i can't find the option "File Convert" in Extract Type. There is 6 options: Data Extention Extract (step1), Security Action Audit Log, Zip, Security Event Audit Log, Custom UTF16 to UTF8 Encoding, Tracking Extract. Can you show me where can I find this "File Convert", please? Thank you.
    – Fabm
    Commented Jul 1, 2019 at 21:00
  • Data extract -> properties -> extract type = there you will find file convert. After that comes configuration where you can select utf8. Ask support when you do not see this option. Commented Jul 1, 2019 at 21:40
  • File Convert is something that Support enables as data extract type, along others. ( move, delete, gzip,...) Please let us know if File Convert to UTF8 it works, I have used it in the past but recently had an issue with it that I could not explain. Thanks! Commented Jul 2, 2019 at 6:51

1 Answer 1

3

Here are some screenshots of an UTF8 DataExtract Activity:

enter image description here enter image description here enter image description here

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .