- Posts
Greetings,
I am having great difficulty with the latest set of CSV files I have been trying to test. Up to this point, I have had no problems whatsoever generating files, even with images. However, I have seen some info in other posts that MDM might have problems with certain characters, like parentheses (). Is this true? Are there any other characters I need to avoid? I am on Version 2.2.2 (11998) on Mac OS Sequoia 15.5.
Any help would be greatly appreciated.
Eric
Hi there
CSV has to be valid. This is the most important thing. That means linebreaks and other characters are not allowed.
Most problems arise cause of invalid CSV data. This is an international standard we follow.
Here are our best practices:
https://mydatamerge.com/knowledge-base/preparing-data/
And here is a validator (there are tons of tools out there)
https://toolkitbay.com/tkb/tool/csv-validator
You can use any character you like as long as it’s part of the encoding (UTF 8 or UTF 16) and for CSV critical characters they must be properly escaped. Usually systems that are able to export CSV follow these rules. But unfortunately not all. For example if your CSV separator is a ; but you also have a ; in some text then this text must be quoted.
As workaround you can import your CSV to Excel and go from there.
Regards
Pat
Official MyDataMerge Team
- You must be logged in to reply to this topic.