Hi all,
I am wanting to set up quite a number of data merges, across many different photoshop files (and illustrator files actually) to help to "automate" personalised details in our designs.
I understand the concept of the data merge, and have done a few tests that seem to work. My question is this: is there a way to have the data for all designs in one spreadsheet (.CSV for example) with a column to enter the file name of the .PSD that it needs to link to? So, for example, the spreadsheet could look something like the following:
My hope is then, that it would run through the files, open them and amend as per the data set. Is this possible?
I am wanting to set up quite a number of data merges, across many different photoshop files (and illustrator files actually) to help to "automate" personalised details in our designs.
I understand the concept of the data merge, and have done a few tests that seem to work. My question is this: is there a way to have the data for all designs in one spreadsheet (.CSV for example) with a column to enter the file name of the .PSD that it needs to link to? So, for example, the spreadsheet could look something like the following:
File | name | nominals | course | uni | year | personalised message |
T:\Order Fulfilment\Order Crew Member - Manufacturing\Order Fulfilment Documents\Order Design Artwork Files\MUG39B.psd | Daniel Tierney | Bsc | Biomedical Science | Northumbria University | 2016 | |
T:\Order Fulfilment\Order Crew Member - Manufacturing\Order Fulfilment Documents\Order Design Artwork Files\MUG39-PM.psd | Tom Mulligan | BSc (Hons) | Economics | University of York | 2016 | Congratulations Tom Love Mum and Dad x |
T:\Order Fulfilment\Order Crew Member - Manufacturing\Order Fulfilment Documents\Order Design Artwork Files\MUG39-PM.psd | John Acantilado | BA (Hons) | English, Lang & Education | University of Leeds | 2016 | Philippians 4:13! Congrats on your 1st! Love, Abi |
T:\Order Fulfilment\Order Crew Member - Manufacturing\Order Fulfilment Documents\Order Design Artwork Files\MUG40-R-PM.psd | Mial Lewis | MEng | Mechanical Engineering | Cardiff | 2016 | Congratulations on achieving First Class Honours |
T:\Order Fulfilment\Order Crew Member - Manufacturing\Order Fulfilment Documents\Order Design Artwork Files\MUG40-PU-PM.psd | Kathryn McIntyre | BA (Hons) | Media Studies | Bangor University | 2016 | What a star!/ Love/ Mum, Dad/ Eleanor & Philip |
My hope is then, that it would run through the files, open them and amend as per the data set. Is this possible?