What's new
By:
Photoshop Gurus Forum

Welcome to Photoshop Gurus forum. Register a free account today to become a member! It's completely free. Once signed in, you'll enjoy an ad-free experience and be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

Data Merge Newbie


M

mcnicolh

New Member
Messages
1
Likes
0
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:

[TABLE="width: 1725"]
[TR]
[TD]File[/TD]
[TD]name[/TD]
[TD]nominals[/TD]
[TD]course[/TD]
[TD]uni[/TD]
[TD]year[/TD]
[TD]personalised message[/TD]
[/TR]
[TR]
[TD]T:\Order Fulfilment\Order Crew Member - Manufacturing\Order Fulfilment Documents\Order Design Artwork Files\MUG39B.psd[/TD]
[TD]Daniel Tierney[/TD]
[TD]Bsc[/TD]
[TD]Biomedical Science[/TD]
[TD]Northumbria University[/TD]
[TD="align: right"]2016[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]T:\Order Fulfilment\Order Crew Member - Manufacturing\Order Fulfilment Documents\Order Design Artwork Files\MUG39-PM.psd[/TD]
[TD]Tom Mulligan[/TD]
[TD]BSc (Hons)[/TD]
[TD]Economics[/TD]
[TD]University of York[/TD]
[TD="align: right"]2016[/TD]
[TD]Congratulations Tom Love Mum and Dad x[/TD]
[/TR]
[TR]
[TD]T:\Order Fulfilment\Order Crew Member - Manufacturing\Order Fulfilment Documents\Order Design Artwork Files\MUG39-PM.psd[/TD]
[TD]John Acantilado[/TD]
[TD]BA (Hons)[/TD]
[TD]English, Lang & Education[/TD]
[TD]University of Leeds[/TD]
[TD="align: right"]2016[/TD]
[TD]Philippians 4:13! Congrats on your 1st! Love, Abi[/TD]
[/TR]
[TR]
[TD]T:\Order Fulfilment\Order Crew Member - Manufacturing\Order Fulfilment Documents\Order Design Artwork Files\MUG40-R-PM.psd[/TD]
[TD]Mial Lewis[/TD]
[TD]MEng[/TD]
[TD]Mechanical Engineering[/TD]
[TD]Cardiff[/TD]
[TD="align: right"]2016[/TD]
[TD]Congratulations on achieving First Class Honours[/TD]
[/TR]
[TR]
[TD]T:\Order Fulfilment\Order Crew Member - Manufacturing\Order Fulfilment Documents\Order Design Artwork Files\MUG40-PU-PM.psd[/TD]
[TD]Kathryn McIntyre[/TD]
[TD]BA (Hons)[/TD]
[TD]Media Studies[/TD]
[TD]Bangor University[/TD]
[TD="align: right"]2016[/TD]
[TD]What a star!/ Love/ Mum, Dad/ Eleanor & Philip[/TD]
[/TR]
[/TABLE]

My hope is then, that it would run through the files, open them and amend as per the data set. Is this possible?
 
I doubt you'll be able to do this as simple as you indicate but as a workround...

You could have all your 'designs' in the same PSD file as groups.

You can then 'define' the visibility of each group, in effect defining which 'design' to use.

This may cause other issues if the 'design' sizes are different but you may be able to include that also in the data set if needs be, 'Pixel Replacement' has the 'Method' option.

Regards.
MrToM.
 
Back
Top