My wife and I are celebrating our 25th year of marriage this year—AND 25 years of working together as graphic designers, specializing in book design for independent authors.
We’ve used Macs and Adobe Systems software all along, and I’ve written various AppleScript scripts to automate various processes from time to time.
One of our products is a 1200-page directory of healthcare professionals, published about twice a year. About 1500 records from a customer-provided spreadsheet are imported into our database (QSA Toolworks’ Helix) where the data is collated and sorted by various criteria, and then output to a tab-delimited text file which is fed into an AppleScript which has Adobe inDesign generate the pages of the directory. I can’t imagine doing this book without that AppleScript script!
And now today, I finished another script for my wife to use on every book she designs which, again, generates inDesign pages while creating linked text frames placed outside of the pages on the pasteboard into which the manuscript is flowed. She’s done this by hand so far. But we just got a new customer who is going to have us create a legal case book of about 1000 pages. So we decided to spend the time writing this script which will make the page setup process take only a few minutes.