Search the Community
Showing results for tags 'data merge source file'.
Hi everyone, I make a calendar every year for my large extended family with all the birthdays and anniversaries printed on their respective dates. I started this custom several years ago, and at that time used Microsoft Publisher 2007 to whip up a calendar template for the year, and then added text boxes with all the holidays and special dates. Needless to say, that was not a very efficient way of doing things... Every year I had to manually move every single text box to the new calendar and make sure they all were more or less lined up and evenly spaced. This year I suddenly realized that I had Affinity Publisher at my disposal! So I went searching about these forums to find out a better, more automated way to publish calendars. A few posts, such as this one on calendar automation, and this one on data merges gave me some guidance in the right direction, and eventually I figured out a way to make a calendar in AfPub using the power of data merge to do the heavy lifting of inputting the dates and the power of text styles to make it all look right. Needless to say, this will save me a lot of time in the future! I'm attaching an AfPub template and a sample .csv file. Anyone is welcome to use/customize these if they would like. I'm sure there are more efficient ways of doing things that I might have missed, so I'd appreciate any constructive feedback you might have to offer! Enjoy! If you have questions about how (or why) I did something the way I did, feel free to ask! Downloading the samples and running the data merge correctly should give you results that look like this: Other resources that were useful: Ubuntu Font: https://design.ubuntu.com/font/ Affinity Publisher Data Merge Tutorial: https://www.youtube.com/watch?v=aU98GmaQsFQ Deep Dive Data Merge in Affinity Publisher: https://www.youtube.com/watch?v=wav8wuucZUY 2022-afpub-calendar.csv 2022-afpub-calendar-template.afpub
Hi. Client asked me to create labels with serial number that contain fixed number and variable number. Variable must contain zeros before actual number. The numbering is from 0001 to 2500. Serial number looks like SN 202116-01-0001. The problem is that publisher in data merge dont show zeros before number it shows SN 202116-01-1. I create numbering in Numbers as my format. Any idea what is wrong? cislovanie 2021.numbers cislovanie 2021.xlsx
I've attempted to create a spreadsheet (numbers converted to CSV) and my stumbling block is file path for images. My Mac Harddrive is called MacintoshHD and the folder is called Documents2 within is a folder called Jewelry and another folder called images I've tried: MacintoshHD/Documents2/Jewelry/images but the images do not get linked. MacintoshHD:Documents2/Jewelry/images Can you help? What is the correct way to write a file path on MacOS? A tutorial file on creating a data merge spreadsheet would be fantastic. I'd write one if I could figure out the path problem, first. I did not find anything in forums & the help video and document is incomplete. thank you