(soft, ringing tones)…- [Voiceover] So here's my solution…to the variable data import challenge.…First, I need to add the images…and graph to the spreadsheet,…so I'll switch to the Finder…and then copy the files directly…from their respective folders.…I'll make sure they're sorted alphabetically…before I do this.…Then, I'll paste those names…into the columns in Excel.…It doesn't matter which one of these columns I paste into.…As long as I add the correct header later,…it'll work fine.…Now I'll paste these graphs in.…
Next, since my spreadsheet headers…are no longer matching my objects,…I can't use auto binding at this point.…I have to solve this problem first.…To do this, I'm gonna change these headers…to match the object names in Illustrator.…If I wanted, I could do the reverse;…change the object names in Illustrator…to match the headers I have here,…except two things are wrong.…These headers have spaces in them,…so they wouldn't work.…Remember, the header in variable names…can't have any spaces or special characters in them…
Author
Released
4/26/2016Designer 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
Duration
Views
Related Courses
-
Print Production: Digital and Variable Data Printing
with Claudia McCue59m 43s Intermediate
-
Introduction
-
1. Exploring Variable Data
-
What Is Variable Data?1m 12s
-
Different types of variables4m 16s
-
-
2. Setting up Illustrator Files
-
Naming objects4m 25s
-
Using area type2m 32s
-
Using point type1m 57s
-
Using variable data graphics4m 50s
-
-
3. Setting up a CSV Document
-
Setting up data in Excel3m 25s
-
Saving a CSV file3m 11s
-
-
4. Importing using Variable Importer Script
-
Opening Variable Importer3m 19s
-
Creating and using presets1m 32s
-
Testing and importing a CSV2m 22s
-
-
5. Working with the Variables Panel
-
Uploading data sets4m 8s
-
Dealing with overset text3m 41s
-
6. Exporting and Reviewing
-
Creating a save action3m 25s
-
-
Conclusion
-
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.
CancelTake 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.
Share this video
Embed this video
Video: Solution: Hero Cards Challenge