Generating Gallery Labels

Overview

This tutorial will show you how to generate and print gallery labels using the LabelGenerator program provided by the Imaging Center. The tutorial is primarily intended for Imaging Center staff members preparing labels for shows in the Jannotta Gallery.

Typically, students and faculty will submit label requests using the Gallery Label Requests form located on the Imaging Center website. Submitted requests will be recorded in this spreadsheet. The LabelGenerator program looks at this spreadsheet to retrieve label data, so it is a good idea to double-check the spreadsheet for any errors (such as misspellings or data entered in the wrong field) before generating the labels.

Generating Labels

  1. The LabelGenerator script is written in the Processing programming language. First download and install Processing from this link: https://processing.org/download. Note that Processing may already be installed if you are using an Imaging Center computer.
  2. Next download the LabelGenerator script from the Imaging Center Shared Drive. You may need to click the download button after clicking this link.
  3. Double-click the LabelGenerator.pde file you downloaded. It should open in Processing.
  4. In Processing, click the “Run” button to run the script (the button looks like a “Play” button).
  5. The script will reference the spreadsheet automatically and create a PDF of labels in the same directory as the Processing script. It will create a label for any spreadsheet row that does not have a “1” in the “Printed?” column.
  6. Review the PDF. If there are any errors, go into the spreadsheet and make the necessary changes. Click “Run” again in Processing to make a new spreadsheet.
  7. Once you have a satisfactory PDF, print it on Avery 18863 2″ x 4″ clear labels.
  8. Lastly, go back into the spreadsheet and put a “1” in the “Printed?” column for each of the labels you just printed so that these labels are not re-generated next time someone runs the script.