buddingphotographer

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 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 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 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 there,
I believe there is a bug that must be ironed out before Publisher is released to the public. When a glyph is missing from a font, but the respective character is inserted in a text frame, Publisher will perform a font substitution. And glyphs will be substituted from a variety of different fonts, most notably
Lucida Grande, Apple Symbols, Geeza Pro, Hiragino Mincho Pro. While I am already very sceptical about automatic glyph substitution (I don’t want the application to do my work in this case), I think it is even more problematic that substituted glyphs aren’t highlighted in a text frame. Given the current implementation, it is all too easy to end up with a document that contains unwanted glyphs. The little exclamation mark preceding the font name in the font dropdown menu cannot really count as a sufficient indicator for a missing glyph, for you will have to select the glyph in order to see it.
In short, I would strongly suggest that you either stop doing glyph substitutions (use the .notdef glyph instead) or highlight a substituted glyph in a text frame.
Thanks for your consideration,
Alex 

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 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 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 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 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

If you were starting a new book project for a ~150 page book, how would you set up the Master Pages/layout?
Background: I've published 2 books now (such as they are), and I kept running into issues when trying to add/delete pages in the middle of the book. It's usually not too bad if I add/delete a 2-page spread, but adding/deleting 1 page causes AfPub to completely repaginate and my Master Pages get all confused and layered on top of each other in a hopeless mess. (I was using running headers, and they got ALL messed up, because the left headers then got applied to the right side...) 
Another related issue was that I had each chapter in it's own set of (linked) text frames, so I had to manually paste in each chapter from the source document. If the author wanted to make some changes that affected the length of the chapter, I had to manually insert pages and try to make everything work out. Lots of tedious work shifting things around, and making sure nothing broke. 
The author later decided she didn't want all the chapters to start on a right-side page, but it was too late to change, because deleting all the blank pages on the left caused the issues mentioned above (overlapping running headers, etc)
Here is what the Master Pages looked like:
A 2-page spread for "chapter beginnings" [Blank on the left / Chapter Title and first paragraphs on the right] A basic 2-page spread for chapter text. (With page numbers and running headers) A 1-page "special" chapter beginning for when the left page isn't blank I'm thinking maybe I should have put the running headers on separate Masters that are added later? Surely there's a better way of doing things? What should I have done initially in my Master Page setup that would have avoided these undesirable scenarios?
Summary. Here are the basic questions I'm wondering about:
What is a good, simple master page layout that won't "break" when I need to add/delete pages in the middle of the book?  Is there a good way to make the entire book "flow" without breaking it up into different frames per chapter? i.e. Copy and paste the entire manuscript all at once instead of chapter-by-chapter.  (or better yet, is there a way to "place/link" the text into the book from the source doc so that when I update the text in the doc, it automatically updates in Publisher similar to the way linked images work?) I'm open to all ideas for a better workflow that causes fewer issues in the future. Thanks in advance! 

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 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

Every single time I want to export a publication to PDF I need to remember to select "All Pages" rather than "All Spreads". Is there any way of making "All Pages" the default for this?

I third this!

Ok, I guess that works, thanks! I still think it should be a simple enough thing to implement though. Having to "place" an image takes a whole lot longer than just dragging it into Affinity. I'm not asking for precise placement or dimensions; I just want to bring in the image at the DPI that my canvas/document is set to. 

https://forum.affinity.serif.com/index.php?/topic/30168-cropping-staying-within-the-boundaries-of-the-image/ is the post that first refers to this.
 
As explained there, the necessity to make at least four additional move-and-click actions, one for each "edge", could be avoided if the crop marks always "automatically" stayed within the boundaries of the image.