Forum Discussion

PhilHeron's avatar
PhilHeron
Qrew Trainee
2 years ago

Exporting QR Codes in bulk for label making and inventory

Hello All,
I use quickbase to keep track of industrial equipment as well as inspect and keep records of said equipment.  Each piece of equipment has QR code linked to it directly in quickbase.  I am trying to export both the data and the images so II can print them out with a Brady labeler.  My issue right now is the only file format offered is CSV which does support images.  I am curious if anyone else has run into this issue and has a solution. 



------------------------------
Phil Heron
------------------------------

8 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger

    I don't know anything about Brady labelers, but perhaps they have the ability to print a QR code if you feed it the string that you want encoded?

    But in the new world order, Chat GPT, like The Borg knows all.  Resistance is futile, you will be assimilated.  This is what Chat GPT Suggests:

    how to print a QR code on a Brady label device

    To print a QR code on a Brady label device, you will need to follow these general steps:

    1. Connect your Brady label device to your computer and ensure that the device is properly installed and recognized by your computer.

    2. Open the label creation software provided by Brady. This software will allow you to design and customize your label with text, images, and barcodes, including QR codes.

    3. Select the label size and type you want to use, and create a new label template.

    4. Add a QR code to your label design by selecting the QR code option from the list of available barcode types.

    5. Enter the information you want to encode into the QR code, such as a website URL, contact information, or a product code.

    6. Customize the appearance of the QR code by adjusting its size, color, and style.

    7. Preview your label design to ensure that the QR code appears correctly and is readable.

    8. Send your label design to the Brady label device and print your label.

    Note that the specific steps to print a QR code on a Brady label device may vary depending on the model of your device and the software you are using. It's always a good idea to consult the user manual or online documentation for your specific device for more detailed instructions.

    can i import a list of labels to be created in a csv format and have the Brady label device create QR codes

    Yes, many Brady label devices and software applications support importing data from a CSV (comma-separated values) file to automatically generate multiple labels with QR codes. Here are the general steps:

    1. Create a CSV file with the data for each label. The CSV file should have a row for each label and a column for each piece of information you want to include on the label, such as label text, barcode type, and QR code data.

    2. Open the label creation software provided by Brady and create a new label template.

    3. In the software, select the option to import data from a CSV file.

    4. Browse to the location of the CSV file on your computer, and select it to import the data.

    5. Map the fields from your CSV file to the corresponding fields in your label design, such as text boxes and barcode fields.

    6. If your label design includes a QR code, make sure to map the QR code data field from your CSV file to the QR code field in your label design.

    7. Preview your label design to ensure that the QR codes are generating correctly for each label.

    8. Send the label design to the Brady label device and print your labels.

    Note that the specific steps to import data from a CSV file may vary depending on the software and device you are using. It's always a good idea to consult the user manual or online documentation for your specific device for more detailed instructions.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------

    • PhilHeron's avatar
      PhilHeron
      Qrew Trainee

      THanks Mark.
      I see that Brady is making its own QR that is not a duplicate of the QR generated by api.qrserver.com.  But if I copy the URL for the piece of equipment directly from my browser it works.  So as a work around could I have a field in quickbase that gave me the unique URL in a report?  



      ------------------------------
      Phil Heron
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew #1 Challenger

        I don't that you would want to be copying a Quickbase URL.  It sounded to me, according to Chat GPT, that you can feed what you want presented in a QR code in a exported CSV column to the Brady printer and configure the Brady printer to print that string as a QR code.   



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------
  • I was looking into this. Never settled on the solution I liked best, but if you use Juiced Add-ons, their Exact Form Plus Add-On can download and present QR codes in many different ways, I suspect one would work for your use case.



    ------------------------------
    Mike Tamoush
    ------------------------------
    • QBJuiced's avatar
      QBJuiced
      Qrew Trainee

      Thank Mike!  Yes Exact Forms Plus can do exactly that.  See the attached PDF created using Exact Forms Plus.

      You can test this in our demo app as well:  https://juicedtech.quickbase.com/db/bknf8jnve?a=dr&r=g&rl=zcf
      From this record, click on the Labels tab and then click the "Create Task Labels" button
      The QRCode is designed to display the associated task record in this app when scanned.



      ------------------------------
      QB Juiced
      Juiced Technologies
      ------------------------------