Jump to content
You must now use your email address to sign in [click for more info] ×

Search the Community

Showing results for tags 'data merge source file'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Affinity Support
    • News and Information
    • Frequently Asked Questions
    • Affinity Support & Questions
    • Feedback & Suggestions
  • Learn and Share
    • Tutorials (Serif and Customer Created Tutorials)
    • Share your work
    • Resources
  • Bug Reporting
    • V2 Bugs found on macOS
    • V2 Bugs found on Windows
    • V2 Bugs found on iPad
    • Reports of Bugs in Affinity Version 1 applications
  • Beta Software Forums
    • 2.4 New Features and Improvements
    • Other New Bugs and Issues in the Betas
    • Beta Software Program Members Area
    • [ARCHIVE] Reports from earlier Affinity betas

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Website URL


Location


Interests


Member Title

Found 3 results

  1. 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
  2. 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
  3. 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
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.