Skip to main content
Bernhard Walzl
Bernhard Walzl
Inspiring
June 18, 2020
Answered

Data merge with special characters on Mac

  • June 18, 2020
  • 2 replies
  • 6481 views

Hello,

 

I want to create business cards using the data merge option in InDesign. I am working on Mac.

 

Indesign wants comma seperated data. I experienced troubles exporting this comma seperated file in Excel or Numbers. They tend to be semicolon seperated only. However, the easiest workaround was using Google Docs which allows the export of such comma seperated file.

 

Then, when importing my data using data merge, any special character gets replaced with wrong characters. Like é or à get replaced with ÅÃ etc.

 

Google told me it is an encoding issue. I downloaded the text editor Sublime which allows encoding in UTF-8, UTF-16, etc. However, any encoding different than UTF-8 results in an error when importing the data.

 

Any advice on this?

Thanks!

Correct answer boots_n_patches

stick with what works.

  • save your database *.numbers file
  • menu/file/export-to-csv
  • during the export process … window appears for advanced options … default text-encoding is unicode-utf8 … change to western-macos-roman
  • save as *.csv file

that's all there is to it … you surely don't need "sublime" or whatever it's called.

2 replies

B
boots_n_patchesCorrect answer
Inspiring
June 19, 2020

stick with what works.

  • save your database *.numbers file
  • menu/file/export-to-csv
  • during the export process … window appears for advanced options … default text-encoding is unicode-utf8 … change to western-macos-roman
  • save as *.csv file

that's all there is to it … you surely don't need "sublime" or whatever it's called.

    Bernhard Walzl
    Bernhard WalzlAuthor
    Inspiring
    June 19, 2020

    You, @boots_n_patches, are my hero of the day.

     

    This is exactly what there is to do: It works!

     

    Thanks a million!

    B
    boots_n_patches
    Inspiring
    June 19, 2020

    happy  to  share  my  knowledge … godspeed.

    P
    patMorita
    Inspiring
    June 18, 2020

    What is the error message reported? Can you break down your data file to 2 lines (title and one data record) and test that. If the error appears too might you share it here? Which version of InDesign are you using? If you are in a hurry you might also try MyDataMerge for mac which adds many features to InDesigns data merge and solves a lot of common issues automatically (we use it regularly) including encoding. They have a free version also.

     

    Bernhard Walzl
    Bernhard WalzlAuthor
    Inspiring
    June 18, 2020

    I am on MacOS Mojave 10.14.6. running InDesign 2020 15.0.3.

     

    The content of my txt file looks like this:

     

     

    A, B, C, D
1é, 2à, 3è, 4ù

     

     

     

    When choosing anything but UTF-8, I get "The data source cannot be opened. Confirm that the file exists nd you have the right to open it, then chose the select data source command again."

     

    I would love to get it done without any extra Software. It is a very simple thing I want to do.

    P
    patMorita
    Inspiring
    June 18, 2020

    Is your file located on a network drive? Try to copy it to the desktop for testing purposes.

    This usually occurs either if you don't have reading rights OR the file is opened by another application at the time InDesign tries to access it.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices