Martin Savel Posted May 13, 2021 Share Posted May 13, 2021 Hi there, i have some certificates fed from *XLSX via Data Merge. In table there are four columns: name, date of birth, certificate number and date of issue. No matter how many people in rows i have, last certificate is generated with last two fields filled. If i have 10 people there, 9 are ok, last one is generated without cert. nr. and date of issue. If i have only single one, last two fields are missing again. Quote Link to comment Share on other sites More sharing options...
walt.farrell Posted May 13, 2021 Share Posted May 13, 2021 Can you provide a sample XLSX file, perhaps with dummy data, and a sample .afpub file (before the merge) that illustrate this? Quote -- Walt Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases PC: Desktop: Windows 11 Pro, version 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 Laptop: Windows 11 Pro, version 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU. iPad: iPad Pro M1, 12.9": iPadOS 17.3, Apple Pencil 2, Magic Keyboard Mac: 2023 M2 MacBook Air 15", 16GB memory, macOS Sonoma 14.3 Link to comment Share on other sites More sharing options...
Martin Savel Posted May 13, 2021 Author Share Posted May 13, 2021 here Archiv.zip Quote Link to comment Share on other sites More sharing options...
walt.farrell Posted May 13, 2021 Share Posted May 13, 2021 Thanks. Worked fine for me, so may be a Mac-specific issue. What release of MacOS are you running, and what release of Publisher? Quote -- Walt Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases PC: Desktop: Windows 11 Pro, version 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 Laptop: Windows 11 Pro, version 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU. iPad: iPad Pro M1, 12.9": iPadOS 17.3, Apple Pencil 2, Magic Keyboard Mac: 2023 M2 MacBook Air 15", 16GB memory, macOS Sonoma 14.3 Link to comment Share on other sites More sharing options...
Martin Savel Posted May 13, 2021 Author Share Posted May 13, 2021 all latest versions Quote Link to comment Share on other sites More sharing options...
Old Bruce Posted May 13, 2021 Share Posted May 13, 2021 Not sure why it worked for walt but here on my Mac the problem was that there was an initial serial number and Issued Date (not date of birth) missed. This is due to the fields being outside, not inside, the Data Merge Layout layer. Move them inside and all is well. For this type of thing I wouldn't use the Data Merge Layout, I would only use that for things that need several records on a page/sheet of paper. Quote Mac Pro (Late 2013) Mac OS 12.7.2 Affinity Designer 2.3.1 | Affinity Photo 2.3.1 | Affinity Publisher 2.3.1 | Beta versions as they appear. I have never mastered color management, period, so I cannot help with that. Link to comment Share on other sites More sharing options...
Martin Savel Posted May 14, 2021 Author Share Posted May 14, 2021 Got it, thank you! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.