Jump to content

Search the Community

Showing results for tags 'data merge layout'.

  • 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
    • Report a Bug in Affinity Designer V2
    • Report a Bug in Affinity Photo V2
    • Report a Bug in Affinity Publisher V2
    • Report a Bug in Affinity Version 1 applications
  • Beta Software Forums
    • 2.1 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


MSN


Website URL


Skype


Facebook


Twitter


Location


Interests


Member Title

Found 4 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 guys, ich habe ein Problem mit der Datenzusammenfassung. Ich habe die Exceltabelle wie im Bild zu sehen. Nun möchte ich in Spalte 1 die werte aus der Spalte 1 aus dem Excel. Das funktioniert auch einwandfrei. Bei Spalte 2 setzt die Datenzusammenfassung dann aber schon aus. Ich habe jeweils Spalte 1 das Feld "Breite 1000" zugeordnet und Spalte 2 das Feld "Breite 2000". Habe ich einen Gedankenfehler? Würde mich um Hilfe sehr freuen. (Hi guys, I have a problem with the data merge. I have the excel table as shown in the picture. Now I want in column 1 the values from column 1 from the excel. This also works perfectly. But in column 2 the data merge stops. I have assigned the field "Width 1000" to column 1 and the field "Width 2000" to column 2. Do I have a thought error? I would be very happy for help.)
  3. I'm having some trouble figuring out the data merge functionality for multiple page documents. What I need to do: Create a set of two sided cards, with text on both sides. I have an excel spreadsheet with a line for each card, with fields for the text for both sides (ie I don't have separate lines for side A and side B). The help guide explicitly mentions using the Record Origin for double sided sheets, so it seems that it should be possible to achieve. I have tried to use the Data Merge Layout Tool, and have laid out four cards per page. This works fine for the first side, and puts the correct data in subsequent cards. However, when I add the Data Merge Layout Tool on the second page, it doesn't seem to work. I am able to get it to reverse the layout order for the card flip to work, but on the second page either none of my data is inserted, or it continues sequentially from the previous page (So I get the side B text for records 5-8, not the side B text for records 1-4). To illustrate, what I need to get is: Page 1 Record 1 Side A Text Record 2 Side A Text Record 3 Side A Text Record 4 Side A Text Page 2 Record 2 Side B Text. Record 1 Side B Text. Record 4 Side B Text. Record 3 Side B Text. Page 3 Record 5 Side A Text. Record 6 Side A Text Record 7 Side A Text Record 8 Side A Text etc What I get is: Page 1 Record 1 Side A Text Record 2 Side A Text Record 3 Side A Text Record 4 Side A Text Page 2 Record 6 Side B Text. Record 5 Side B Text. Record 8 Side B Text. Record 7 Side B Text. Page 3 Record 9 Side A Text Record 10 Side A Text Record 11 Side A Text Record 12 Side A Text.
  4. When learning a new technique, I much prefer using a written tutorial to watching a video, so when I first used Data Merge to create a set of mailing labels, I turned to the Publisher Help system. It told me all about how to describe my data layout with rows, columns and gutters etc, but not how to actually create the layout on my page! I had to resort to watching the video which indeed demonstrated how to do it. Easy when you know how, but I would never have guessed from the Help file. I was not sure where I should be posting this, but it ended up here. John
×
×
  • Create New...

Important Information

Please note there is currently a delay in replying to some post. See pinned thread in the Questions forum. These are the Terms of Use you will be asked to agree to if you join the forum. | 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.