Search the Community
Showing results for tags 'csv'.
Found 4 results
cansik posted a topic in Discussions and Suggestions for Affinity Publisher Beta on DesktopIt would be great if the Table Text Tool would support pasting of data (they are usually tab separated) from a spreadsheet like Google Sheets oder Microsoft Excel. At the moment this is not possible and leads to a huge amount of work to create e.g. offers. Another, more advanced feature would be to link an existing spreadsheet table or at least CSV data directly to the Table Text Tool. What do you think about it?
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.
The new UX features in the 1.5 release are phenomenal, and bring Affinity Designer MUCH closer to a total solution for front end design. What I'd love to see in a future release is support for linking/importing data from external sources such as a JSON file, spreadsheet, or CSV. A great implementation of such a feature can be found in the Craft plugin for Sketch. If this were available natively in Affinity Designer, I think I'd be ready to make a full cutover to AD as my primary environment for all UX work.
I realize that this is not a typical Designer or Photo tutorial; however, Designer/Photo content can be created/edited and used within the context of this process. The narrator is creating business cards. A user could create a background in Photo and the logo in Designer and export them to PDF (among other formats) for use in this type of production scenario using Scribus. As I've stated many times before, I use Scribus in conjunction with AD/AP (until Publisher comes out) mainly because Designer and Scribus share the same Color Management engine, LittleCMS. Here's the tutorial: https://www.youtube.com/watch?t=10&v=kMsRn38TOiQ Hope this helps.