Skip navigation
cololitho
Currently Being Moderated

QR Codes generated and placed in Indesign from an Excel file

Aug 10, 2013 8:13 AM

Tags: #merge #printing #print

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!

 
Replies
  • Currently Being Moderated
    Aug 10, 2013 8:20 AM   in reply to cololitho

    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?

     
    |
    Mark as:
  • Currently Being Moderated
    Aug 10, 2013 8:29 AM   in reply to Peter Spier

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Aug 10, 2013 8:32 AM   in reply to Sandee Cohen

    Oh, one more thing.  The wizards at Rorohiko are available to customize any product to meet your needs.

     
    |
    Mark as:
  • Currently Being Moderated
    Aug 10, 2013 8:52 AM   in reply to cololitho

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Aug 10, 2013 2:18 PM   in reply to cololitho

    Hi cololitho,

     

    This might be helpful - it shows how Tada QR! handles bulk QR code generation:

     

    http://rorohiko.tv/tadaQR/bulk

     

    Cheers,

     

    Kris

     
    |
    Mark as:
  • Currently Being Moderated
    Aug 13, 2013 3:56 PM   in reply to cololitho

    Hi Cololitho,

     

    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:

     

    ="<%"&A1&"%>"

     

    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:

    http://www.urlone.com

    http://www.urltwo.com

     

    This should create a new column that looks like this

    <%http://www.urlone.com%>

    <%http://www.urltwo.com%>

    ...

     

    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.

    Screen_Shot_2013-08-14_at_10.52.00_AM.png

     
    |
    Mark as:
  • Currently Being Moderated
    Aug 27, 2013 9:52 PM   in reply to cololitho

    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!

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points