What is the format of data when exported as .CSV or .TXT? Is it ISO-8859-1 or UTF-8. What I have seen is if the module is English only it outputs as ISO-8859-1 and if the module is Chinese, output is UTF-8. Can we have some clarity on this please? Thanks in advance.
That is what I thought too .. but when I imported back the same file I exported out (export format expected to be UTF-8), Anaplan auto detected it as ISO-8859-1 instead of UTF-8. Is it import or export that is getting it wrong?
The encoding character set is used to make possible to save special language characters in TXT files (extensions of files CSV TXT, etc.).
For instance, if the file is setup as "ISO-8859-1" you will not able to see correctly the Russian alphabet but if the file is saved as "UTF-8" the special characters are correct viewed.
Another particularity: "UTF-8" character set is including the "ISO-8859-1". "UTF-8" is just an extension of "ISO-8859-1".
So, simplifying: you can always setup the Anaplan import action with "UTF-8". If the file that you import it is saved with "ISO-8859-1" the file will still be able to be read correctly and loaded in Anaplan without an issue.
When creating an Anaplan import action if the file is recognized as "ISO-8859-1" I would always change it manually to "UTF-8" for the simple reason that the "UTF-8" includes the "ISO-8859-1".
If the Anaplan action is saved using "ISO-8859-1" and you try to load a "UTF-8" file - the import process will not work.
UTF means "Unicode Transformation Format".
To have a file in UTF-8 from Excel use the option "CSV UTF-8 (Comma delimited) (*.csv) option when saving a file.
However if from Excel, the file is saved using the option "Unicode Text(*.txt)" the encoding of the saved txt file will UTF-16LE. Even is still a UTF type encoding, the "UTF-16LE" and "UTF-8" encoding are not compatible between them.