Participating Frequently

Question

VCard with Excel and Data Merge (QR-Code) to txt or csv

Forum|Forum|6 years ago
March 14, 2019
2 replies
14552 views

Hey guys,

I have about 2000 different business cards witch must be updated with a CR-code containing a VCard.

I am already using an excel-sheet with data-merge (Company, Title, FName, LName, Phone, E-Mail, etc.)

I would like to generate an auto-QR-code (VCard) on the business cards by using my excel-sheet and data merge.

The VCard/QRcode must contain these categories:

Company

Title

FName

LName

Phone

E-Mail

I have already added a new column "#CRcodes" but i don't know how to implement the categories correctly.

I have found this from adobe:

BEGIN:VCARD\nVERSION:2.1\nN:Smith;John\nFN:John Smith\nORG:Adobe \nTITLE:Ingenieur\nTEL;CELL:+919876543210\nTEL;WORK;VOICE:123456789\nADR;WORK:;;Straße ABC;Seattle;Washington;98101;USA\nEMAIL;WORK;INTERNET:abc@adobe.com\nURL:www.adobe.com\nEND:VCARD

So I simply tried this - but I guess its for a .txt and not for my excel-sheet:

BEGIN:VCARD\nVERSION:2.1\Company\Title\FName\LName\Phone\E-Mail\nEND:VCARD

I dont know what nVERSION:2.1 means?
Or what the n stands for?

Its a bit complicated i know but i hope somebody can help me out here!

This topic has been closed for replies.

Colin Flashman

Community Expert

Sorry I'm late.

I think I can help. I'd written an article on how to do this over at InDesignSecrets: https://indesignsecrets.com/data-merge-qr-codes-explained.php

The linked article explains that in Adobe's help page for the issue, there's a typo and information that isn't required. The article also explains how to use the concatenate feature in Microsoft Excel, though upon reflection the concatenate feature could just be replaced by using ampersands to join text strings together. Combine text from two or more cells into one cell - Office Support

If the answer wasn't in my post, perhaps it might be on my blog at colecandoo!

JensPassothAuthor

Participating Frequently

Okay thx Guys,

I will try this out this weekend and give a report - and hopefully a solutions

J

Jose305300467l56

Participant

I'm not quite clear on your problem - that a plain text QR code is not being recognized as a vCard entry?

You may find this useful:

https://www.nitrosyncretic.com/DPR/dpr_qrcodes.php

It is very much possible to get readers to recognize any valid data type, from a plain text structure, but the details of the encoding must be exact.

>From the excel Data Merge, the code for the vCard appears in the QR
dialogue as Plain Text. So, even if a QR appears, the QR reader does not
open a vCard.

D

DBLjan

Legend

I found this. You could batch/create the codes upfront, and link into Excel/InDesign as image.

http://goqr.me/api/doc/

D

DBLjan

Legend

https://qrcode.tec-it.com/API/QRCode?data=BEGIN%3aVCARD%0d%0aVERSION%3a2.1%0d%0aN%3aMax+Muster%0d%0aTEL%3bHOME%3bVOICE%3a0043-7252-72720%0d%0aTEL%3bWORK%3bVOICE%3a0043-7252-72720%0d%0aEMAIL%3aemail%40example.com%0d%0aORG%3aTEC-IT%0d%0aURL%3ahttp%3a%2f%2fwww.example.com%0d%0aEND%3aVCARD

Found a better one, whos doing VCARDs also:

Gratis QR-Code Generator. QR-Codes kostenlos online erstellen!

JensPassothAuthor

Participating Frequently

Thx for your answer

Maybe I am getting it wrong but it seems like I would have to input all information 1 by 1 for all Employers.

I have 2000 employers with information already listed in my excel-sheet. Also we have our own business-card-design.

This is why i am looking for a rather easy way to include a QR-code on my master-layout (indesign) and simply import my excel-sheet via data merge.

I don't really want to necessarily input all 2000 employers manually to accomplish a VCard-link on our new business-cards . Would be nice if the QRcode could grab all info (Company, Title, FName, LName, Phone, E-Mail) from my excel-sheet and plop it in via data merge.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded