I have created a Data Extract activity exports a .csv file containing records from my Data Extension.
The file is in the wrong File Format so I have requested Salesforce activate additional encoding options in my Data Extract activity which they have. They advised using the "Custom UTF16 to UTF8 Encoding" to convert to the correct csv format.
After my initial Data Extract, I created another Data Extract activity which follows straight after to convert the file (not sure why this cant just be done in the same step to be honest), but either way the second Activity which is supposed to convert the file fails. The file is exported straight to the safe house so I'm not sure if its a location issue, and i can confirm the file name patterns are correct.
Any ideas?
Best Answer
I did a file export from a dataextension like this:
DataExtract Activity1:
DataExtract Activity2:
File Transfer Activity:
It is very important that your column delimiter on step1 is the delimiter in your local settings of your operating system. When the operating system has a different defined you might end up with problems on excel (if you use it).
Does this help or do you really have to use the UTF16 to UTF8 Feature?