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

  • 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

  1. 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.
  2. 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
  3. Attached find templates for a birthday \ appointment calendar... A very simple basic one done only with Excel \ Libreoffice Extremely deluxe calendars designed with a data merge into Affinity Publisher. Attached are templates for monthly calendar Monthly Planner six months on one page twelve months on a large page Would be glad to hear suggestions for improvement. Thanks! DIY Birthday and Appointment Calendars.pdf Monthly Calendar template.afpub Monthly Planner template.afpub six month template.afpub twelve month template.afpub Calendar Worksheet, legacy.xlsx Calendar Worksheet, libreoffice.ods Calendar Worksheet.xlsx
  4. "Data Merge Manager" Enhancements = make this window dockable as studio panel, and also right inside the DM Manager window add a button shortcut to open up the Fields Manager. These 2 enhancements would make the workflow so much easier. Please see my attached markup image to help clarify my text description here...
  5. EDIT: It's officially been solved! Thanks to everyone who downloaded the project to try and help and special thanks to Stokerg for finding the data merge layout I had left in the wrong spot. I'll leave the fixed version of the project here for anyone who might find it useful. I will also probably put it in "Share Your Work" with a guide. Thanks again! Hello friends from the Internet. I have been working on a calendar-generating tool in Affinity Publisher that has the following pages: A front cover page to be adjusted in post A page set up for data merge with a picture and text for the month, a grid of days with holidays setup to merge A back cover page with a data merge layout that shows each month's picture on the back Right now, if I go into the data merge manager and step through each record on the included excel sheet, everything appears to look normal, but when I click the merge button, I get the font cover page, a single month page for January, and a back cover page with the image for every month on it. I can't seem to get the data merge to give me calendar pages for each month. I've already checked the excel sheet for blank cells and can't find ones that should matter. I would love it if someone could help me figure this out. Thanks friends! Calendar Project FIXED.zip
  6. Hey guys, Data Merge is a really nice feature of Affinity Publisher, but unfortunately it doesn't support linking text content using the URL that is in the CSV. It would be wonderful to have this feature working, mainly because not even Acrobat Reader can do it at the moment, you would be at the forefront once again with such an amazing feature.
  7. Heya folks! So as I mentioned in the post for a different question I wrote 15 minutes ago, I'm working on a document I'm going to use with a data merge. There's an image for each item, stored in the input file (JSON, if it matters) using relative paths (in this case images/702366.jpg for example). When I use the preview in the layout document the images show fine, but when I use the data merge manager to generate the output file, all the picture frames are empty. Any thoughts or obvious things I'm missing? Edit: Just noticed in preflight for the generated document, it's full of this error: "img_local_url" is the name of the field in the JSON file that contains the relative path.
  8. Hi, Publisher, Data Merge. Original data are in Excel xlsx, formatted as hungarian phone number: When I merge data in Publisher, it shows the format code, not the number. (I know, there is an obvious workaround, if I would store the numbers in Excel unformatted, written exactly the characters I would like to see in Publisher. But I think, It should not work like this.) Why the format code is shown not the number itself? Thanks!
  9. 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
  10. Hello, I'm very new to this topic of data merge. I need this because I'm working on a Interslavic-German dictionary and I want to layout this with Publisher. So I found this function of data merge but now I get a problem with that. I'm still using Affinity Publisher 1.XX the last version. So I got this problem with layouting the dictionary. If you try to use data merge without this grid, the system puts me every single element on another page. If I try this with the grid - the problem at the end is, that the grid is not really good to make a normal layout after generation of the data merge. I don't get it. So you can have a look at the picture. If I just put the fields into a single text frame with copy and paste, it will just add the same row of the CSV to this page and put the next row on the next page. If I use the grid for data merge, it will use for every field another row from the CSV data but the problem is the layout. This grid is not really comfortable to use for layouts like this. For dictionary layout I would need a variation but the grid is just really rigid. Have a look on the second picture and you will see that I got problems with the baselines. I could manage it now with working with evey single texte frame again to put it like this that it works finely, but that will take too much time to do, when you have 18,000 words to layout handly. Maybe I don't get the system so well, but is there any possibility beside this grid system to force Publisher to get this done? Best regards reiki11
  11. I've created a multipage Affinity Publisher document (using the Generate option in Data Merge). I then have a single page poster design in Affinity Designer which places these pages, 1 through 16, into the layout. All is fine at this point. If I then re-run Generate because of an update to the underlying data it regenerates the AP document which then is "updated" when the AD document is opened. The problem is that Page 1 now becomes Master A and Page 2 becomes Page 1 i.e. all the pages are off by one. Master A is not used in the AD document and I can't delete it from the AP document. Placing a dummy Master A page into the layout doesn't stop this from happening. This is clearly a bug but any thoughts on how I can get past this for now?
  12. 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.
  13. Hi there, I want to localise my UI assets using the Data Merge feature, and the naming of the PNGs is part of the localisation too. Is there a way to name Layers/Groups/Artboards picking these from a CSV (just as I do with content) so I could easily auto-generate slices' names on creation from Export Persona?
  14. I’m trying to make 6 decks of 30 cards for a classroom activity, and unfortunately A4 is the only print size available to me. In order avoid having 6 massive cards per sheet and waste 30 sheets of paper, I’d like to have 18 smaller cards (3 different cards x6) per sheet, 10 pages total. In other words, I’d like to set up the data merge to repeat each field from the data source 6 times before incrementing to the next field. Is this possible? The only way I’ve managed to make this work is to make the data source include 6 duplicates of every card. This is manageable, but I’d much rather have a single entry for every card variant in the data set just to make editing and adding new cards a breeze. Attached below: Data Merge Example.afpub is my pre-merged document setup. Data Merge Example Source.xlsx is an example of the kind of data source I'd like to use for the afpub document. Data Merge Complete.afpub is how I would like the data merge to result. Honestly, I'll be surprised if there is actually a way to do this. Many thanks if anyone has an answer for this. Data Merge Example.afpub Data Merge Example Source.xlsx Data Merge Complete.afpub
  15. 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".
  16. 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.
  17. 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?).
  18. 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
  19. 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
  20. 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?
  21. 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.
  22. 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?
  23. 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?
  24. 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.
  25. 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.)
×
×
  • 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.