• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Data Merge, Encoding of CSV File, InDesign crash

Community Beginner ,
Dec 04, 2017 Dec 04, 2017

Copy link to clipboard

Copied

Hi,

I try to put data from a csv file into my document. I tried every encoding (Win 1252, ISO-8859-1, ISO-8859-15, UTF-8) for my csv file but the German special characters like ä, ö or ü are never displayed properly in preview mode. I am using SublimeText v3 to change the encoding of my csv file.

And in addition, InDesign crashes whenever I execute the data merge.

I am working with the latest InDesign CC on a MacBook Pro 15', Mid 2014 on MacOS HighSierra 10.13.1 for the German language.

Looking forward to your experiences or feedback.

Kind regards,

Mirco

Views

8.5K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

People's Champ , Dec 05, 2017 Dec 05, 2017
vinny38

Thanks fir the reference. Much appreciated.

I would also recommend tab delimited text but just to be useful, I have been told UTF-16 works better with CSV.

FWIW

Loic

Votes

Translate

Translate
Valorous Hero ,
Dec 04, 2017 Dec 04, 2017

Copy link to clipboard

Copied

When using UTF-8, are you using UTF-8 without BOM (Byte Order Mark)?

I don't have a rental at the moment and so cannot try the very latest version. But the last CC version I did use, it worked fine as an UTF-8 no BOM.

Mike

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Dec 04, 2017 Dec 04, 2017

Copy link to clipboard

Copied

Yes, it is UTF-8 plain. no BOM. Excel exports the BOM-version but Sublime stores in "real" UTF-8 format.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Valorous Hero ,
Dec 04, 2017 Dec 04, 2017

Copy link to clipboard

Copied

Could you open and strip the data out of the file with the exception of the data filed names, resave it and upload it to dropbox or the like and provide a download link? And though it will be a small KB file, if you would ZIP it before uploading it that would ensure the format doesn't change in any way.

And I agree with vinny--tab delimited is a more assured means of import but I wouldn't think that would be the issue here. But ya never know. ID's data merge hasn't changed in, well, forever so even the version of ID shouldn't matter.

Mike

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guide ,
Dec 04, 2017 Dec 04, 2017

Copy link to clipboard

Copied

Have you tried tab delimited .txt file instead of CSV?

Being French, I do deal with many funny characters such as ç, â, à,ù or œ... and tab delimited .txt are my friends.

Now, if you still experience trouble, maybe @Loic.Aigon can help you out there... He's a data merge specialist ^^

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
People's Champ ,
Dec 05, 2017 Dec 05, 2017

Copy link to clipboard

Copied

vinny38

Thanks fir the reference. Much appreciated.

I would also recommend tab delimited text but just to be useful, I have been told UTF-16 works better with CSV.

FWIW

Loic

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Dec 05, 2017 Dec 05, 2017

Copy link to clipboard

Copied

Thank you for your help!

Using UTF-16 with tab as the delimiter for the csv works perfect!

Kind regards,

Mirco

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Apr 24, 2018 Apr 24, 2018

Copy link to clipboard

Copied

Hi,

Here is what has worked for me on MacOS High Sierra:

Open Sublime (I am using Sublime editor version 3)

Paste text

File > Save with encoding > UTF-16 LE

Hope this helps.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Aug 01, 2024 Aug 01, 2024

Copy link to clipboard

Copied

LATEST

Thank youuuuuu!!

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines