Skip to main content
C
Cédric5CDC20899915
Participant
February 2, 2023
Question

Automation for QR CODE insertion ?

  • February 2, 2023
  • 2 replies
  • 1204 views

Hi folks,

Is there a way to create multiple qr codes using an excel file?
My goal is to add several qr codes in a catalog, there are a hundred pages with several qr codes. it's very long especially since I have to change the links after translating the catalog.

Thanks

Cedric

This topic has been closed for replies.

2 replies

Brito Haroldo
Brito Haroldo
Inspiring
February 2, 2023

Hi  Cédric,

 

@Loic.Aigon is right. A script is a very good way to do this. I can generate a script for you. This is great training for me. A question is a deadline for the task. I'll send you my contacts in a private message if you want to share the task.

 

In time: a few months ago I made a poster for a design exhibition — which I was invited to exhibit — using about 120 QRs and assembled the piece using a script I made. It turned out amazing and they were random as a destination and also the colors applied to the QRs.

Robert at ID-Tasker
Robert at ID-Tasker
Legend
February 2, 2023

Script for that is a few minutes job 😉 it would already be sorted, unfortunately, I'm not JS guy and OP is on a Mac  😞

 

    Brito Haroldo
    Brito Haroldo
    Inspiring
    February 2, 2023

    I have no doubts about such minutes and I admire that. At some point I get there. But at the moment I'm already out of the starting line but there's still a lot of ground for me to reach, in my dream so much: "a few minutes". Not to mention the other demands here at the office that cannot stop. I liked this metric... I'll get there. 😃

    Robert at ID-Tasker
    Robert at ID-Tasker
    Legend
    February 2, 2023

    Not sure if DataMerge can do it - but you probably need to place those QR codes in some specific places - so script should be the only solution - what platform? How do script should find destinations for the QR codes ? 

     

    C
    Cédric5CDC20899915Author
    Participant
    February 2, 2023

    Hi Robert! Thanks for your interes.
    Yes I thought of DataMerge, but this solution is not suitable because it generates a new file, in my case these are unique qr codes and which are not all placed in the same places on the pages.
    I don't know anything about scripting, I don't know if it's still possible.
    If anyone has a solution, I'm all ears!

    Loic.Aigon
    Loic.Aigon
    Legend
    February 2, 2023

    Hi,

    You can create QRcodes with Datamerge, see here for details (https://creativepro.com/data-merge-qr-codes-explained/)

    Once that is said, yes, it will create a new document no matter what. And it's a totally separate process. In your case, I am sorry but you basically need a script if you want to automate this. I am certain that you can find people that will either deliver the code for free or ask for a relatively small fee. But the ROI may be profitable if you compare it to the time you will spend adding those QRCodes manually (and maintain them).

    If you don't know to script, it may be worth buying the script from someone. Or you learn it and it's free, apart from your time 😉

    And I can't prevent myself from remembering that those issues can be easily managed with Catalog automation plugins 😉

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices