I don't think you can do it all in one step. CC has a new QR code generator module, but for older versions you might want to check out Adobe Community: [Ann] QR Code for InDesign CS4 and up.
Do you really do a 40,000 record merge, and print that, or do you have VDP capability on the printer?
Rorohiko.com has a new product called TaDa QR! It works for older versions as weell as CC. It is able to do a data merge to generate QR codes.
Oh, one more thing. The wizards at Rorohiko are available to customize any product to meet your needs.
Sandee, do you think it would do all I need to do at one time, or at least make it possible to do what I need to do?
Yes, I do believe it will do what you need to do all at once. Or, like I said, if you need a slight nuance, Kris Coppieters is most likely willing (for some compensation) to customize the product for your needs.
We downloaded TaDa QR! and we are trying to see if this will, in fact, work for us. The video is hard to follow mostly because we can't see what codes you are typing in the various places. Do you have any readme files or written out instructions for this extention?
I'm sorry to say at the time we don't have any in-depth documentation on Tada QR! as writing a vast amount of documentation takes a long time! We will add this in time.
Since Tada QR! handles bulk QRs by a search and replace, it means that if you can find a way to get the URLs into your InDesign document Tada QR can replace them with QRs.
The formula I used in the video in excel creates a new column that puts the data into the default format for Tada QRs search pattern.
It looks like this:
Where "A1" is the name of the cell of the data you want to format.
I then drag/repeat the cell containing the formula down the length of the spreadsheet so it is repeated for each data item.
For example if you have urls:
This should create a new column that looks like this
If you can get the data in this format and into your InDesign document,
you should be able to select "Entire Document" and hit the "Replace All" button without having to change any of the default settings.
This will replace the all the URLs in that format with QR codes.
so bulkqrcode.com allows you to paste in a list of data (urls? in your case) and nearly instantly create QR codes in bulk. you can then download the png files in a zip file. each file is named according to the data encoded in it.
once you have all the PNG files in a local directory i believe it should be easy enough to pull them into InDesign.
Hope that helps!
I am testing another QR code generator to create QR code in Excel files. Do you have any ideas about it? Or any good suggestion? But I am totally a green hand on this field. Any suggestion will be appreciated. Thanks in advance.
You cannot do all in one time. You need to design a template for where to put names, titles, company, address, etc. and QR Codes. For QR Code url, a Excel QR Code add-on is necessary, after you install the plug-in in Excel, when you choose urls and click generate QR code, the work will be done. But you have 40,000 urls, so I suggest you do this work partially in one time.
Since InDesign CC was introduced, creating Data Merges with QR codes is INDEED POSSIBLE without any third party plugins or scripts. I did a full write-up of it on InDesignSecrets:
What I will say is that it is not a simple process, and the Adobe InDesign Help site (concerning making QR codes via Data Merge) is still incorrect and will throw users off.