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

DataMerge with special characters and QR code

Community Beginner ,
Sep 25, 2020 Sep 25, 2020

Copy link to clipboard

Copied

Hi there, 

 

I use DataMerge to make business-cards with czech special characters (š, ř, č...) including QR codes for the vcards. To import these characters right, I use UTF-16 encoding for the data source. But when scanning the QR code with my iphone, it just says „No usable data found“. Is there any solution to this?

 

Thanks for any suggestions!

Ingo

TOPICS
How to

Views

1.6K

Likes

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

Community Expert , Oct 01, 2020 Oct 01, 2020

Hi Ingo,

me again. Inspected the result of data merge with your data source.

 

As I can see now from the Text field of the result code a lot of data is missing:

 

Vizitka_DataMerge_RESULT-UCS-2-LE-BOM-Source-15.1.2.226.indd.PNG

 

If I copy/paste the code from your text file ( without the quotes ) I get a different QR Code that should work:

 

Vizitka_DataMerge_HandTyped-v3-UCS-2-LE-BOM-Source-15.1.2.226.indd.PNG

 

Now, what could be the solution to your problem?

[1] Scripting the merge where the functionality of data merge is not used.

[2] Finding a way to insert the right text for the QR Code. Currently I cannot tell if that w

...

Likes

Translate

Translate
Community Expert ,
Sep 26, 2020 Sep 26, 2020

Copy link to clipboard

Copied

Are you inserting the Qr code in the source file as an image?? 

Try to convert the xls sheet to UTF-8 comma delmated (.CSV)

i had some issues when using .txt data source

 

Likes

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 ,
Sep 26, 2020 Sep 26, 2020

Copy link to clipboard

Copied

Thanks for your reply, manal_shanableh,

nothing else than an UTF-16 encoded .txt will import the czech special characters correctly to DataMerge. So UTF-8 is not really the point for me I guess. 

Likes

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 ,
Sep 26, 2020 Sep 26, 2020

Copy link to clipboard

Copied

Have you tried decoding the QR code with any online readers or any other apps besides the one that is used? They don't always use the same framework.

Likes

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 ,
Sep 26, 2020 Sep 26, 2020

Copy link to clipboard

Copied

Hi Colin, 

I tried three online readers, all recognize the QR code as vcard, but none displays the czech characters right. Still waiting for response from some android users...

 

Likes

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 ,
Sep 26, 2020 Sep 26, 2020

Copy link to clipboard

Copied

So I shorty summarize:

Imported UTF-16 TXT to DataMerge. Czech special characters themselves display well on the business-cards. The QR-codes nevertheless do not show the special characters in online readers and android phones. iPhone even worse does not recognize the vcard at all.

Likes

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
Engaged ,
Sep 26, 2020 Sep 26, 2020

Copy link to clipboard

Copied

You say reader, what about generator/creator?
Did you create the QR code on-the-fly with InDesign or are those created before and just linked images?
Maybe try another QR code generator out there.

Likes

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 ,
Sep 27, 2020 Sep 27, 2020

Copy link to clipboard

Copied

Hi Jens, 

I get a XLS from my client and using a QR code generator online is, what I did at the beginning. But as it is rather annoying doing every single QR code manually, I need them to be done automatically with DataMerge together with the printed contact infos on the business cards themselves. 

 

Likes

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
Engaged ,
Sep 28, 2020 Sep 28, 2020

Copy link to clipboard

Copied

Hi Ingo,

so I just tried creating a QR code via InDesign using your mentioned characters (š, ř, č), reading it via Android using 3 different readers – works fine.

You could try creating your QR codes via InDesign, see (apparently there is a mistake on Adobe's help site, so I link this)
https://indesignsecrets.com/data-merge-qr-codes-explained.php

Likes

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 ,
Sep 28, 2020 Sep 28, 2020

Copy link to clipboard

Copied

That's what I already do, Jens,

of course there's nothing wrong with adding a QR code in InDesign (Object > Generate QR code), the special characters work. But that's just as inefficient as using an online-generator manually for every QR code. Therefore I want to use DataMerge and include the QR codes right away. But the codes via DataMerge won't display the czech characters (Android) respectively the QR code is not recognized at all (iPhone). Feel free to download the XLSX and INDD from my CC-account and give it a try, maybe I do not see the forest for the trees...

 

Likes

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
Engaged ,
Sep 28, 2020 Sep 28, 2020

Copy link to clipboard

Copied

Ah I'm sorry, I misunderstood – I thought you were still using an online QR generator.

So I did try different options with your data and played around here and there, I couldn't get it to work either:
my best guess is you found a bug within the data merge function…

Since the QR code generator itself does support those character (because it does work if you create a QR code manually) the issue must be with data merge...
If nobody else has some insight or solution I would post this @ InDesign Uservoice 
 

Likes

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 ,
Sep 29, 2020 Sep 29, 2020

Copy link to clipboard

Copied

Anyway, thank you for trying and the advice : )

Likes

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 ,
Sep 30, 2020 Sep 30, 2020

Copy link to clipboard

Copied

I had a look at the InDesign Uservoice... At least two users report the same issue in October 2018 and July 2019... So probably no soon solution in sight...

Likes

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
Contributor ,
Sep 29, 2020 Sep 29, 2020

Copy link to clipboard

Copied

Hi there,

i got it to work with MyDataMerge - its a tool that controls InDesigns data merge and extends its functionality a lot.

I know that it uses InDesigns QR-Code functions to create and merge QR-Codes (but i think its more a scripting interface kind of thing)

 

The uploaded file (indd) is a proof of concept.

https://www.dropbox.com/s/rb2gm0yfbkqfo0a/%C5%99eh%C5%AFlka%20ji%C5%99%C3%AD.indd.zip?dl=0

 

I can read the QR-Code without issues with the built in QR-Code Scanner of my Galaxy S10 (Android).

 

In addition to standard QR-Codes:

  • You can color front and background color easily to get colored QR-Codes
  • You can customize filenames based on database (see uploaded example).

 

I just removed the other placeholders to speed up things. It's a mac only tool and has a free forever version to use with small amount of placeholders. But its a solution (we use regularly).

Likes

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 ,
Sep 30, 2020 Sep 30, 2020

Copy link to clipboard

Copied

Thanks for the tip,

the result on the iphone isn't much encouraging : ( see the attached screenshot. But I will surely have a look at the tool.IMG_77C73BD84FB5-1.jpeg

Likes

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
Engaged ,
Sep 30, 2020 Sep 30, 2020

Copy link to clipboard

Copied

My guess would be that MyDataMerge creates the QR code via scripting (which is in fact pretty easy). The issue is with InDesign's data merge.


I just tested the QR code from comDesignSHi on Android as well, it does work... my collegue tested it on an iPhone 8 with iOS 13 – also all fine.

Likes

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 Expert ,
Sep 30, 2020 Sep 30, 2020

Copy link to clipboard

Copied

Hi Ingo,

can you provide the data source file as well?

 

In your InDesign document's Links panel "QR_datamerge_QUELLE_UTF8.csv" is showing up as data source.

I guess, this is not the right one; you said you need a UTF16 encoded text file.


Just one line of text in the data source should work for additional tests.

Your Excel file gives no hint what's going wrong, I think.

 

Hm. That said:

Perhaps the issue is that Excel or your saved data source is using two glyphs to compose the special characters when one glyph for the special characters is needed to work as QR code?

 

Regards,
Uwe Laubender

( ACP )

Likes

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 ,
Sep 30, 2020 Sep 30, 2020

Copy link to clipboard

Copied

Hi Uwe, 

you are right, that's not the right data source (just the last one of several tries). Now I updated the ZIP including the INDD, XLSX and UTF-16 TXT as data source. 

Thanks so much for having a look at it

Ingo

 

Likes

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 Expert ,
Oct 01, 2020 Oct 01, 2020

Copy link to clipboard

Copied

Hi Ingo,

thank you for the new files. At first glance I cannot see a problem in your data source file.

 

I'm on Windows 10 and opened the QR_datamerge_TEST.txt file with my Notepad++ application.

Notepad++ suggests the encoding of the file is UCS-2 LE BOM. That is compatible with UTF-16.

 

Also did a datamerge with the one entry of your data source document. For that I built a new template document.

And I converted the encoding of your text file to UCS-2 BE BOM. The result was exactly the same as with UCS-2 LE BOM.

A conversion to UTF-8 did not work, the merged results were garbled.

A conversion to UTF-8-BOM did not work, because InDesign did not accept that encoding as the right one for a data merge source.

 

All templates and results of my tests can be downloaded from my Dropbox account:

https://www.dropbox.com/s/flarrun3cxa87po/Vizitka_DataMerge-201001-1.zip?dl=1

I embedded the data source file in the template.

 

Regarding the QR code I get exactly the same result as you.

So working on Windows 10 with data merge makes no difference.

And also a conversion of the data source to UCS-2 BE BOM makes no difference.

 

What actually made a difference:

If I copy/paste the text from the source text file, QR_datamerge_TEST.txt , to the text entry field of the QR Code feature in InDesign. You can download the result here:

https://www.dropbox.com/s/95mrqvfwkzeac66/Vizitka_DataMerge_HandTyped-UCS-2-LE-BOM-Source-15.1.2.226...

I have no idea if this will work on any device with a QR Code reader.

 

Away from all that:

Is there a special requirement on your side to compose your template with the data merge placeholders on a master page?

The result in that case are XML tagged texts and frames. Also the QR Code container frame is XML tagged.

 

Regards,
Uwe Laubender

( ACP )

Likes

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 Expert ,
Oct 01, 2020 Oct 01, 2020

Copy link to clipboard

Copied

Did a mistake with the "hand typed" VCard entries. Copy/pasted both of the enclosing " characters from the source to the entry field of option Text.

 

And I am not sure if entry VERSION3.0 is the right one.

I saw an example of a VCard that had VERSION2.1 as entry:

http://imagesmithblog.com/2014/07/18/qr-codes-indesign-cc-2014-data-merge/

 

Regards,
Uwe Laubender

( ACP )

Likes

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 Expert ,
Oct 01, 2020 Oct 01, 2020

Copy link to clipboard

Copied

Hi Ingo,

me again. Inspected the result of data merge with your data source.

 

As I can see now from the Text field of the result code a lot of data is missing:

 

Vizitka_DataMerge_RESULT-UCS-2-LE-BOM-Source-15.1.2.226.indd.PNG

 

If I copy/paste the code from your text file ( without the quotes ) I get a different QR Code that should work:

 

Vizitka_DataMerge_HandTyped-v3-UCS-2-LE-BOM-Source-15.1.2.226.indd.PNG

 

Now, what could be the solution to your problem?

[1] Scripting the merge where the functionality of data merge is not used.

[2] Finding a way to insert the right text for the QR Code. Currently I cannot tell if that will work, if I made an error, if you made an error in the data source, if InDesign has a bug with that.

 

Regards,
Uwe Laubender

( ACP )

Likes

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 ,
Oct 02, 2020 Oct 02, 2020

Copy link to clipboard

Copied

Hi Uwe, 

I really appreciate what you tried and will need some time to work me through that (and to understand 🙂 Up to now it didn't come up to my mind, that the generated QR code from DataMerge is editable as plain text in InDesign. So perhaps there might be a work-around without DataMerge, that will be at least a little bit more efficient than entering all data manually. I will let you know.

Likes

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 Expert ,
Oct 02, 2020 Oct 02, 2020

Copy link to clipboard

Copied

Hi Ingo,

in the end a datamerged QR code is nothing but a QR code done manually.

So it is fully editable after the merge.

 

Regards,
Uwe Laubender

( ACP )

Likes

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 Expert ,
Oct 06, 2020 Oct 06, 2020

Copy link to clipboard

Copied

Hi Ingo,

with the following screenshot I tried to illustrate the issue:

SourceTextProvided-as-Table.indd.PNG

 

I also tested to script adding a QR Code with character Ř (LATIN CAPITAL R WITH CARON).

That worked as expected: All the QR Code's text was visible in the Text field of InDesign's QR Code user interface. So I really think, there is a severe bug with InDesign's data merge of QR Codes and some "special characters" ( that are not special at all if you are Czech-born. ). Especially with Ř (LATIN CAPITAL R WITH CARON)

 

Regards,
Uwe Laubender

( ACP )

Likes

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
New Here ,
Feb 04, 2022 Feb 04, 2022

Copy link to clipboard

Copied

Hello,

I have the same problem with special characters if I generate the QR-Code with data merge (InDesign 2022). Is there any automated solution available to generate a QR-code with InDesigns auto merge with this special characters? Or is Uwes Script-Adding available?

 

Thank you,
KR ismael

Likes

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