I'm in prepress for a printing company, and we have a project that I'm not sure how to handle. I have an Excel file with 40,000 names, titles, company, address, etc. AND the url for a QR code. I need to generate postcards with all the variable data in place, and use the URL info in the excel sreadsheet to generate a QR code AND place it - all in one action so I can print on the postcards the way I do all my data merge files.
Does anyone know how to do this? Is it even possible with InDesign? I would love to hear any solutions to this problem!
Thanks in advance!
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?
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!