Jump to content
Our response time is longer than usual currently. We're working to answer users as quickly as possible and thank you for your continued patience.

Search the Community

Showing results for tags 'data merge'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • 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
    • macOS Beta Forums
    • Windows Beta Forums
    • iPad Beta Forums
    • [ARCHIVE] Reports from Affinity Version 1 Betas

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start




Website URL






Member Title

  1. I am creating a hyperlinked digital planner with a monthly, weekly and daily view. I want to be able to select a particular day on a monthly calendar (ie January 14) and have it redirect me to that corresponding page (ie January 14 daily view). I've figured out how to populate 12 months, 53 weeks, and 365 daily pages with unique anchors, by using the data merge feature on master pages. The issue I'm running into now is when those anchors populate, they all share the same name as you can see in the image below that I've attached. For example I want to have a unique anchor for the January 1, January 2, January 3 page.... and so on. So I've created a master page with my data merge inputs and added an anchor labeled "January <date> | Daily ". What I was hoping would happen is that when I select "generate" in the data merge window, that it would fill in each unique date but instead what I'm getting is 31 unique anchors to unique pages that are all titled "January <date> | Daily" . This is what the page looks like on the master page before I generate the data merge. I have an anchor on the master page so that when the dates get pushed through, each individual page has a unique anchor with a unique date. This is what it looks like once I generate the data merge. The date is filled in, the unique anchor appears for that particular page, but I get 31 anchors all titled "January <date> | Daily". But what I want is for it to say "January 1 | Daily, January 2 | Daily, January 3 | Daily, January 4 | Daily, January 5 | Daily, ....and so on" without me having to do it manually. *BTW the January 12 | Daily , January 13 | Daily , January 14 | Daily , I manually changed. They all read "January <date> | Daily".
  2. When you data merge a PDF file into a Picture Frame, it automatically gets placed with "Page Box: Trim Box" setting, which cuts off all bleed area, making any files with Trim Box defined unusable for data merge purposes. There needs to be a setting allowing you to choose the type of a PDF box in data merge settings, or if should be placed with either "Bleed" or "Crop" boxes selected instead.
  3. If I create a picture frame and then attempt to data merge a PDF into it, the scaling option of the picture frame will be ignored - if scaling: "None" is selected, merged PDF will still be scaled to something other than 100% and placed at the wrong size. This only seems to happen with data merge, when placing a PDF into Picture Frame manually the scaling option is respected.
  4. I tried to do the following: Create a 2-page document 90x50mm Create 2 master pages, on each page place one PDF page to serve as the static content, apply them to respective regular pages. PDF file size is 2.5MB Create a single text field on one of the pages, link it to a data field from a spreadsheet, this will be the only dynamic content present, 2000 records total Data merge -> create merged document, goes fast enough, under 10 seconds Export as PDF -> the export process didn't even move past 25% after 5 minutes. This is completely insane, as the only variable element is a single text field, it should be done in seconds. It also eats enormous amounts of disk space, dozens of gigabytes. At around 33% I ran out of disk space, and the job processing was cancelled with an error. PersonaBackstore.dat was 34 GB at the time the disk ran out of space. Seems like its trying to re-print the background from the linked PDF for every single record, rather than once. _____________________ I did the exact same steps in Adobe IdDesign CS5, and export to PDF for all 2000 records took 15 seconds. No additional disk space was consumed, barely any RAM was used. Same export settings. Didn't need to create the merged file too, export directly to PDF.
  5. This was originally posted as a reply to a PM related to version 1 related thread, but as it is relevant to versions 2, as well, I created a new post with a link to the original thread (I am not sure what would be the preferred procedure -- just continue an old related post?).
  6. Hi, I am working on game cards I need to populate using data merge (see "Cartes Observatoire RECTO" attached to this post). Not all cards have the same design so I made a page for each card in the original file (before merging). I am expecting to get the same amount of page after merging but the app repeats pages to have one of each for each field. In my case : 13 pages x 13 fields = 169 pages in the output file. My goal is to have only 13 pages. NB : This is a sample of the file I made to simplified the case. The real file I am working on is a 123 pages involving the creation of a nearly 17k pages after merging data … 😅 Is there a way to prevent AfPublisher to repeats pages? Data merge manager let me select all page or specified a range to repeat but it seems there is no possibility to doesn't repeat. What I do not understand is I have another similar project with same settings which works as expected : 65 pages turning into a 65 pages after merge. (see "Cartes Action version RECTO") What I am missing ? Cartes Action version RECTO.afpub Cartes Observatoire RECTO.afpub DATA Cartes Action VF.csv DATA cartes Observatoire CH.csv
  7. 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
  8. I have a 3.5MB PDF file which I use a background, placed with passthrough mode, and then data merge 2 text fields and 1 image frame onto it. There are total of about 400 records. Image frame has a PNG qr-code merged into it, average size of one such image is 3 KB, the size of all PNG images together - 1.16 MB - this is pretty much the only variable data which actually takes space. A total size of a merged file should not take more than around 5-10 MB. So, I go to export the file as a PDF - and get a 180MB file as a result. Why? Any way to get an actually reasonable filesize? Dropping the DPI doesn't really do much - with 192 DPI instead of 300 I still get a 140MB file, and further reduction would destroy image quality.
  9. If I open the file with V1 everything OK If I open the file with V2 I see many errors No changes to the file No changes to the .csv data source see attachments
  10. Hi Affinity Community. I am currently working on a portfolio that includes profiles of different people (Names, Stats, Etc). I have been using the data merge feature in Affinity Publisher to populate data in my profile template. The problem I have been having is that some names are too large for my text frame and are hidden. Is there a way to have text from a data merge automatically resize itself to fit a text frame?
  11. I have a pdf file with 1 page with the size of 62 KB I create a new AP document, place (link) that PDF on a master page, then create 2 pages with the master, and on each of them place a single text frame, populate it with 2 fields from data source file, then place a single picture frame, and also link it to a data merge field. Images are QR codes in PNG format around 700-800 bytes each. That's it, nothing else is there. You'd think it would be very fast to merge this right? Wrong. When I create a data merged document for 300 records, AP immediately runs out of memory (consuming 10GB RAM) and starts writing to disk. It writes over 30 GB to PersonaBackstore.dat file. And it take more than a minute to make the merged document. Meanwhile, when I save the merged afpub document, its size is 3.5 MB When I export the merged file as PDF with 300DPI, its total size is 11 MB What's going on, and how is this even possible? There is clearly something wrong here.
  12. When doing a data merge I'm unable to insert fields. I've selected a data source which is being previewed in the 'Fields' section. I then highlight the appropriate text in the document and double click on the data field to insert it & it does nothing. Is there a bug or am I doing something wrong? I purchased the software to specifically use this feature. Any ideas?
  13. Hi Affinity Team, Currently on Affinity Publisher one can have multiple sources for data merge but only one can be used at a time so they are interchangeable data sources. My feature request would be to be able to use multiple data sources concomitantly on data merge. For example: I created a catalog of people and services for a company. Each set {People, Services} has its own sub-set of characteristics {Name, Department, Expertise, Years of Experience, Etc} {Name, Department, Description, Duration, Etc}. Having to combine both into one data source leads to data duplication for one of the sets into the other one unnecessarily. If I chose to set my data on People, each line (person) will have a complete set of Services making the database unnecessarily big. The workaround today is to link the using formulas but its not ideal. Thank you, Daniel
  14. I'm looking at using Publisher with Data merge in order to make my content and I'm running into a bit of a roadblock with my conceptual understanding of how it works for my context. I have two types of entities, lets say people and items. There will be a data file for each, say people.csv and items.csv. Each record in people.csv will correspond to a single page, so that is easy enough and works very well with the data merge manager (can we call it DMM?). The hard part is that each person can have multiple different items. Ideally I could define all of my items once in items.csv, and specify for each person record which items it has, ie person A has items X,Y,Z. Person B has items W and Z, etc. I'm stuck on how to use DMM to do this. My best guess right now is doing a two step process of making another document that is purely items. I would use DMM here to generate docs which I would then export. I could then specify in the 'people' csv which item images to merge into each person record. The items could be formatted like table rows. Is there a better way of doing something like this?
  15. I am new to Affinity Publisher and have created a calendar layout master which I use a data merge from Excel to produce a photo calendar blank where I can choose year and language. I would like to be able to add background colours to the cells for Saturdays and Sundays. Can this be done directly in Affinity Publisher or can it be passed to Affinity Publisher from the Excel data merge file? Each month is a vertical list of days starting at 1st of the month so Saturdays and Sundays are different for each month and year.
  16. 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.)
  17. I am exploring the Affinity suite for the purpose of creating cards and assets (boards, rule books, etc.) for our design & development of Board Games. Many of the card use a standard design with spaces for data elements, so I think a data merge would be useful for us. I see the Data Merge capability within Publisher and am exploring it, but I keep encountering an issue. I've got an existing data source in XLSX and CSV formats (EDITED TO ADD: with header row). Here's the steps I'm following: Launch Affinity Publisher (purchased from the Affinity store) on my Windows 10 (64-bit) machine. Create a New document (Letter format). EDITED TO ADD: Using the Data Merge Layout Tool, drag out a 2x2 Data Merge Layout. EDITED TO ADD: Add Text Frame area(s) where the merged data will be displayed. Go to Document->Data Merge Manager... Add Data Merge Source, selecting the existing XLSX (or CSV) file. Click 'Generate'. A dialog appears that says 'The Data Merge Source has been updated since you imported it. Would you like to update before outputting?'. I click 'Yes'. The Data Merge panel remains, but the data source is not added (ie: the left side of the pane is blank). Additionally, under Fields, it's entirely blank. I read & followed the included help file, but don't know what I'm doing wrong. Can someone direct me, please? Thanks! EDITED TO ADD: If you follow the 8 steps as indicated above, it works!
  18. 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.
  19. Currently we have to work around this bug by limiting the page range because all value pairs are global. This could be fixed if the data sets would be referred to by their file name instead of loading all the files at once and telling the files where they can be loaded instead of referencing from where they're needed. Example: source.json:string_name This would also make the Data Merge more robust and enable it as a normal object that doesn't require everything to be baked into a new document.
  20. Hello, I would like to use the Affinity Publisher data merge function on several pages at the same time, so that on each initial page the data records are processed from the beginning. In my case, I want to generate double-sided vocabulary cards using the data merge layout tool, where the vocabulary name is on one side and the translation is on the other. In the data file each entry is a vocab with its information. How exactly can I do something like this? Thanks in advance!
  21. Hey! I recently discovered data merge and I'm putting it to good use. I want to be as efficient as possible and merge a lot of records but I'm hitting a wall. Currently, I'm trying to merge 270 records with two fields that are images. This eats up all my remaining memory and disk space. I have a 2017 Mac with 16 GB of memory and 250 GB of disk space running Big Sur. Normally about 7.5 GB of memory is available and 137 GB of disk space is available. When I do the data merge and hit generate, it might process 75% and then get stuck and my computer says there is no more memory. If I restart, it sometimes processes the data merge but I might get an error when exporting that there is no more disk space. And, sometimes I can do the data merge and exporting with no errors at all. I know I can do less records but I'd like to do as many as possible to be efficient, like I mentioned above. Is 270 records too much? Are my computer specs not good enough for that? I don't really know that much about computers but I could see why the app might take up the memory but I don't understand why it would take up disk space.
  22. Hi - How can I adjust formatting/styling (such as colors, or visibility of an element, on a per row basis) with a data merge? If it's possible, where is the documentation I missed?
  23. Hello, I am trying to design a photo book using Affinity Publisher. I have a csv with the path to the photos, captions, titles, city, date, etc. I used the Data merge layout tool to place a single picture frame and two text frames. The layout accommodated landscape pictures well, but not portrait pictures. After merging the data, I made a master page that works better with the portrait pictures. I made sure that the layer names match, and figured that I could utilized the smart master pages to apply the new layout to the pages containing the portrait pictures. Well, when I drag and drop the new master pages, the layout isn't applied to the existing content. Instead, new frames are added to the pages without modifying the page content. Am I missing something? Thanks in advance
  24. Maybe I'm not the first but I like to share this, I was working on a document doing my regular data merge thing, when it occurred to me that it will be great to use the tool to create patterns fast and without too much manual labor, here is the file as well as some screenshots as how is done. hope you like it and please leave a feedback on what other uses did you find for a tool that wasn't meant to do the art you doing it with. patterns.afpub
  25. I think I may be missing something really simple. I have a document where the same text is repeated on many pages. (it's a manual so the name of the client will appear 100 times, for example). I want to use the data merge so that the <company name> text throughout the document is populated with the data from the spreadsheet column/row without having to double click in the fields data merge for every instance. Is this possible? In otherwords, every time <company name> appears in the document the data in column 4 row 4 replaces it. Thanks.
  • 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.