Issue with Special Characters and Calibri on Mac

I don't know if anyone can help but if so, please let me know. I am trying to do addressing on letters for a customer and I have to use Calibri. Everything was fine until I got to addressing international letters and some of the special characters are defaulting to something else. I can manually go into the .csv file and change them and it works, but I've got over 1000 letters to do. I'm told that it's a Mac issue and the Calibri coding for those characters and that it should work on the PC but I don't have that capability. Does anyone know a workaround or a Calibri version that works? Thank You!

Well, without the job files, it's hard to diagnose what's going on. So you could post the collected template here. (Please do not post proprietary font files here, though.)

 

A couple other things that might help: You could check, or un-check, the "Limit processing to MacRoman text" box on the Advanced tab of the Composition Settings and see if that makes a difference. Also, some improvements to font handling have been made in later versions of FusionPro, so you could try version 9.3 or 10.0. (Contact Sales for a trial license of version 10.)

 

Though frankly, I'll bet this is really an encoding problem, not a font problem per se. So the answer is probably just to select the proper encoding of the data file in the Data Source Wizard:

http://forums.pti.com/attachment.php?attachmentid=1723&stc=1&d=1502823938

 

I suspect that the data file was created on Windows, and has Latin-1 encoding, but I can't be sure without seeing it.

 

The other solution is to save the file as Unicode, either UTF-8 or UTF-16, with a byte order mark. Unicode solves the ambiguity problem of the Tower of Babel of multiple 8-bit text encodings.

Edited August 15, 2017 by Dan Korn

Thanks Dan. We were able to save the Excel file out as a .csv and then open in Notepad and save as a text file (UTF-8). That seemed to resolve the problem. Sometimes you have to play around with it and see what works. Appreciate the help!