John Garrett explains how to indicate images in your spreadsheet, including naming the header correctly, and discusses the procedure vs. the similar procedure for InDesign. He then shows how to best add the image names in to the spreadsheet using the Mac Finder, with a brief demonstration of how to sort the rows in Excel.
- [Voiceover] In this video, we're gonna concentrate…on column D, which is our images column,…and I'll show the best way to get these in here.…plus a few tips and tricks.…If you're familiar with InDesign's data merge feature,…you already know that it uses the at symbol…to indicate image variables.…The variable importer uses the same symbol,…and we can see it at the top of the column…in the hero_image header.…That's the first thing to really nail down.…If you forget to add this symbol…to the front of the variable name,…importer script will just treat it as plain old text.…
Another important note to make is that the at symbol…only appears in the spreadsheet…and not in your Illustrator file.…I'll switch back over to Illustrator quickly to demonstrate.…Checking my layers panel, I'll open the image layer,…which reveals the image object named hero_image.…It doesn't have the at symbol preceding it here.…That symbol is only for the importer script to understand…that it's dealing with image data, so make sure…you leave it out of your Illustrator object names.…
Designer John Garrett appreciates the many different types of variables and their practical uses, including generating business cards and direct mailers. In this course, he explains how to use variable data including managing linked images, graphics, tables of data, and graphs. He covers the entire workflow, from setup to exporting dynamic batches.
- Setting up Illustrator files
- Using Appearances
- Setting up data sources
- Importing data
- Managing linked variables
- Binding and using prepend paths and presets
- Using the Variables panel
- Naming data sets
- Generating multiple versions with batch exporting
Skill Level Advanced
1. Exploring Variable Data
2. Setting up Illustrator Files
3. Setting up a CSV Document
4. Importing using Variable Importer Script
5. Working with the Variables Panel
6. Exporting and Reviewing
Creating a save action3m 25s
Next steps1m 12s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.