Vanish Posted December 1, 2014 Share Posted December 1, 2014 One of my tasks requires quickly regenerating a set of images (sometimes hundreds) based on a template. This is currently accomplished either with Adobe Indesign or Adobe Photoshop with Data Merge. I set up a CSV with columns which are attached to layers within the document. There are three options: 1.) Set the Text content of a Layer 2.) Set the Visibility of a Layer On/Off 3.) Set the contents of a Layer to a File Once you have the layers attached to columns and the CSV imported, you can preview each row, set the display to a specific row and export one/all images based on the data in each row. I could identify several more options that I would love to have (set the fill color of a layer) but the minimum needed would be Visibility and Text. Unfortunately, I cannot abandon the Adobe products until I have another way to accomplish this merging of data. I have not found any alternative software to accomplish this merging, so I am willing to bet there is a market for it. Inkscape has a plugin that nearly does it, but it is not implemented well and does not work with all shapes. debiant 1 Quote Link to comment Share on other sites More sharing options...
Vanish Posted December 1, 2014 Author Share Posted December 1, 2014 On a side note, currently PSD files with Data Sets attached cannot be loaded into Affinity Designer. The file could not be parsed. Quote Link to comment Share on other sites More sharing options...
Staff Ben Posted December 1, 2014 Staff Share Posted December 1, 2014 If you have an example PSD file, we can take a look. Quote SerifLabs team - Affinity Developer Software engineer - Photographer - Guitarist - Philosopher iMac 27" Retina 5K (Late 2015), 4.0GHz i7, AMD Radeon R9 M395 MacBook (Early 2015), 1.3GHz Core M, Intel HD 5300 iPad Pro 10.5", 256GB Link to comment Share on other sites More sharing options...
Vanish Posted December 1, 2014 Author Share Posted December 1, 2014 I have uploaded an example file, attached to this post. 1846-shares.psd Quote Link to comment Share on other sites More sharing options...
Vanish Posted January 2, 2015 Author Share Posted January 2, 2015 Its obvious this request is not attractive to many folks using Affinity Designer, but I'd love to at least be able to open my data merge PSD's in Affinity Designer so I can manually work with them. Thanks for your hard work on this program. Quote Link to comment Share on other sites More sharing options...
Staff MEB Posted January 2, 2015 Staff Share Posted January 2, 2015 Hello Vanish, It may be a niche request, but that doesn't mean we will do nothing about it. I believe we can at least try to parse the files correctly. Last month (December) was quite busy with a new beta release (Designer) and the work being done on Affinity Photo (a little delayed). With Christmas and, New Year celebrations / holidays some things got postponed. Just hold on a little more. I'm sure Ben will pick this again as soon as he returns to work. Quote A Guide to Learning Affinity Software | Affinity Quick Reference Link to comment Share on other sites More sharing options...
Staff Ben Posted January 5, 2015 Staff Share Posted January 5, 2015 I'm back from Christmas break. Will take a look when I get chance. I can't say now how much of this we will support though. This is a niche Photoshop feature, and we have a lot of other features on the roadmap that need to be done first. Quote SerifLabs team - Affinity Developer Software engineer - Photographer - Guitarist - Philosopher iMac 27" Retina 5K (Late 2015), 4.0GHz i7, AMD Radeon R9 M395 MacBook (Early 2015), 1.3GHz Core M, Intel HD 5300 iPad Pro 10.5", 256GB Link to comment Share on other sites More sharing options...
Jens Krebs Posted January 5, 2015 Share Posted January 5, 2015 I always considered data merge and CSV import a feature that's more interesting for Publisher; currently using several Plugins on InDesign for this. Quote Link to comment Share on other sites More sharing options...
Vanish Posted May 21, 2015 Author Share Posted May 21, 2015 Hey folks, I now completely understand is is a niche feature ( I didn't realize it was at the time :D ) and I will be supporting Publisher when it arrives. Consider that part of my request null. Today I grabbed the latest release as I saw it contained updates for importing files, hoping my issue would be resolved. Unfortunately, I still cannot open any of my PSD files containing data merge information. Dang! Maybe next time. Quote Link to comment Share on other sites More sharing options...
Quarian Posted May 22, 2015 Share Posted May 22, 2015 I used this feature in InDesign all the time on my old job laying out catalogs. We would get spreadsheets for new products and accessories from the pricing department as .xls files (and, later, .csv files) and would have to incorporate the entries into the layouts in tables. We still use it on my current job for map entries and other intermittent things. Hopefully, Data Merge (or whatever it will be called) will be one of the key things that makes it into the first version of APub. If you'd be able to apply styles to placeholders, so much the better. Quote Link to comment Share on other sites More sharing options...
Quarian Posted May 22, 2015 Share Posted May 22, 2015 If it helps, Scribus DOES have this feature implemented by way of a Python script called "Scribus Generator." I mention this because--until Publisher arrives--I'm using Scribus in conjunction with Designer (as they both work with littleCMS for Color Management) for my multipage publication development. The original page on Scribus Generator is here: http://www.ekkehardwill.de/sg/ and the GIthub page for it is here (it has since had newer features added to it; the Github page houses the newest incarnation): https://github.com/berteh/ScribusGenerator Hopefully this helps the community and the Devs. Jens Krebs, debiant and Vanish 3 Quote Link to comment Share on other sites More sharing options...
Vanish Posted July 24, 2015 Author Share Posted July 24, 2015 Woohoo, I can now open my files that had data merge information in them! Quote Link to comment Share on other sites More sharing options...
Quarian Posted July 28, 2015 Share Posted July 28, 2015 This tutorial for Scribus Generator just came across my Google+ feed. Hope this helps. https://www.youtube.com/watch?t=10&v=kMsRn38TOiQ Quote Link to comment Share on other sites More sharing options...
Janwinard Posted April 5, 2018 Share Posted April 5, 2018 I cannot fully shift to this product without data merge like photoshop data merge feature. This feature helped graphic artist creates id and calling cards. Consider how many artists out there using this feature in photoshop and indesign or illustrator. Quote Link to comment Share on other sites More sharing options...
edeguzman Posted June 29, 2018 Share Posted June 29, 2018 I concur with Janwinard’s comment. I’ve been designing and teaching design for many years. Data merging is an extremely powerful and efficient way of managing dynamically changing content. The absence of this feature has been the primary reason I’ve kept from carrying my instruction over from Adobe to Affinity. I see Affinity in many ways potentially giving Adobe Photoshop and Illustrator a run for their money. That is to say with single or one off designs. However, Adobe’s Pipeline and Data nerge features are still a dealbreaker for me. debiant 1 Quote Link to comment Share on other sites More sharing options...
slvJoe Posted July 3, 2018 Share Posted July 3, 2018 I'm looking for Data Merge also! debiant 1 Quote Link to comment Share on other sites More sharing options...
MelanieD Posted July 15, 2018 Share Posted July 15, 2018 Just signed up for the forum to say that I'm requesting this feature, too! debiant 1 Quote Link to comment Share on other sites More sharing options...
Tom P. Posted August 20, 2018 Share Posted August 20, 2018 yes, nice feature...but more important: find and replace, actions, plugins, scripting. (each of those could also be used in some way for variable data). If all that you want is to fill in names into a placeholder and export/save your artwork automatically, you could give Apple's Automator a try. Works fine for me. Quote Link to comment Share on other sites More sharing options...
debiant Posted September 12, 2018 Share Posted September 12, 2018 On 8/20/2018 at 12:09 PM, Tom P. said: yes, nice feature...but more important: find and replace, actions, plugins, scripting. (each of those could also be used in some way for variable data). If all that you want is to fill in names into a placeholder and export/save your artwork automatically, you could give Apple's Automator a try. Works fine for me. With DM for InDesign, you can insert images from cvs along with text fields. I've tried several scripts to accomplish this. None I found, accomplished what I could do in InDesign near as well. Though, I do understand that everyone has different use cases. Quote Link to comment Share on other sites More sharing options...
MikeW Posted September 12, 2018 Share Posted September 12, 2018 InDesign's merge really isn't a good model to copy. It really isn't even as good as Word's is. While a bit more involved, Em Software's merge for QuarkXPress and InDesign is vastly more capable. Which is why I plunk down the money for it. Quote Link to comment Share on other sites More sharing options...
OlaHaldor Posted March 5, 2019 Share Posted March 5, 2019 Here to raise my voice as well. Datasets from csv is highly required in part of my tasks. I'm making lower thirds for a live event these days (we're talking about 80 graphics with names, song titles or activity etc). I've previously done lower thirds for sports events where we've had up to 300 graphics that'd be presented over the course of two days. CSV, export dataset as image files.. Highly required. OH! And TGA.. because the ATEM video mixer takes TGA with alpha.. Quote Link to comment Share on other sites More sharing options...
Pixel Prof Posted June 2, 2023 Share Posted June 2, 2023 Just popping this up as another vote for the need for this feature. Is there any API for Affinity Photo's Batch system that could allow for development of this? This has been a critical feature to me in the photo app from that big "A" company that I really can't do without. Like OlaHaldor above, I use this for lower thirds graphics for video production all the time. Allow a spreadsheet of names, titles, even colors/graphic import images to be swapped for long lists of people to easily generated quickly. Also, I used to run a youth sports photography company that would shoot portrait photos of hundreds of kids per weekend. The ability to use CSV Data Merge allowed for the rapid creation highly profitable, personalized print products like "Trading Cards", Personalized "Memory Mates", Posters and more that could all have team-color & logo themes and personalization including name, position, stats, etc. With CSV Data Sets, hundreds of these highly personalized product images could be generated in minutes from a template and spreadsheet, with each file having a profit margins of $10-$50 per file. Would love any input on if there could be a way for a code-savvy user to develop something if this isn't high enough of a priority to get attention from the primary developers. Quote Link to comment Share on other sites More sharing options...
walt.farrell Posted June 2, 2023 Share Posted June 2, 2023 Welcome to the Serif Affinity forums, @Pixel Prof. This very old thread was about adding a Data Merge function, and that's since been implemented in the Affinity Publisher application. if it doesn't suit your needs, you should make a new topic in the V2 Feature Requests part iyf the forum and describe in detail what's missing that you need. Quote -- Walt Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases PC: Desktop: Windows 11 Pro, version 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 Laptop: Windows 11 Pro, version 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU. iPad: iPad Pro M1, 12.9": iPadOS 17.4.1, Apple Pencil 2, Magic Keyboard Mac: 2023 M2 MacBook Air 15", 16GB memory, macOS Sonoma 14.4.1 Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.