Gabriel G. Roy Posted June 28, 2023 Share Posted June 28, 2023 Hi, I just started working at a place that uses Affinity Publisher and the data merge functionality. The files are generating correctly. The issue is that only the images are showing in preview mode, but not the text. (it stays in the <lorem ipsum> format instead of getting replaced by the data. I asked a colleague if they knew how to correctly display the text in preview mode, but he said he wasn't unaware it was supposed to work. So, I assume no one at the organization has ever made that work. I did see a video tutorial online where the preview also displays text. Are there any known limitations that make it so text won't correctly preview in the Data Merge preview? Quote Link to comment Share on other sites More sharing options...
Print Monkey Posted June 28, 2023 Share Posted June 28, 2023 (edited) This was working for me, except when I had something set wrong like CSV/TSV delimeters etc. Which input format are you using? (CSV, JSON, XML?) Edited June 28, 2023 by Print Monkey add image Quote pRiNt! mOnKeY! 🖨️🙊💻Lenovo Legion 5 Pro*, Intel(R) Core(TM) i7-12700H, 2300 Mhz, 14 Core, 32GB DDR5-4800, nVidia RTX 3070 Ti 8GB, Windoze 11 💻*Sometimes gets used for something other than games. Link to comment Share on other sites More sharing options...
Gabriel G. Roy Posted June 28, 2023 Author Share Posted June 28, 2023 I'm using a CSV file. When generating the files, it works properly, though. Only in the preview, it doesn't work. Quote Link to comment Share on other sites More sharing options...
Print Monkey Posted June 28, 2023 Share Posted June 28, 2023 sounds like it could be a bug. how long is the csv? Quote pRiNt! mOnKeY! 🖨️🙊💻Lenovo Legion 5 Pro*, Intel(R) Core(TM) i7-12700H, 2300 Mhz, 14 Core, 32GB DDR5-4800, nVidia RTX 3070 Ti 8GB, Windoze 11 💻*Sometimes gets used for something other than games. Link to comment Share on other sites More sharing options...
Gabriel G. Roy Posted June 28, 2023 Author Share Posted June 28, 2023 130 records Probably 100+ columns too Quote Link to comment Share on other sites More sharing options...
Old Bruce Posted June 28, 2023 Share Posted June 28, 2023 1 hour ago, Gabriel G. Roy said: The issue is that only the images are showing in preview mode, but not the text. (it stays in the <lorem ipsum> format instead of getting replaced by the data. I never see "Lorem ipsom" in previews of Data Merge fields. Could you share a bit of the CSV file here? Say the first three or four lines of it. Quote Mac Pro (Late 2013) Mac OS 12.7.6 Affinity Designer 2.5.5 | Affinity Photo 2.5.5 | Affinity Publisher 2.5.5 | 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...
Gabriel G. Roy Posted June 28, 2023 Author Share Posted June 28, 2023 Sure! Here is the first line of the file. (with headers) Merge Table-Grid view copy.csv Quote Link to comment Share on other sites More sharing options...
Oufti Posted June 28, 2023 Share Posted June 28, 2023 7 minutes ago, Gabriel G. Roy said: 130 records Probably 100+ columns too I am not sure what it is for you, but if you are showing the master pages instead of the pages in the Pages panel, you won't have any preview of the merge result, only the field name. If you select Pages instead of Master pages, the preview is correct. Quote Affinity Suite 2.5 – Monterey 12.7.5 – MacBookPro 14" 2021 M1 Pro 16Go/1To I apologise for any approximations in my English. It is not my mother tongue. Link to comment Share on other sites More sharing options...
Print Monkey Posted June 28, 2023 Share Posted June 28, 2023 (edited) It looks like your CSV doesn't using quoting, but it contains quotation marks and you have "Quote" set to '"' in the data merge manager. That could be confusing something. Try setting Quote to "None" in the data merge manager. Rainbow CSV (VSCode CSV extension) didn't read the file properly for me until I removed the quote character from the read options. Edit: actually I'm wrong, it's still not reading the file properly. maybe it does use quoting? This file is a little hard to figure out. Perhaps there's just a bug in the import related to the large number of fields/columns. Edited June 28, 2023 by Print Monkey oops Quote pRiNt! mOnKeY! 🖨️🙊💻Lenovo Legion 5 Pro*, Intel(R) Core(TM) i7-12700H, 2300 Mhz, 14 Core, 32GB DDR5-4800, nVidia RTX 3070 Ti 8GB, Windoze 11 💻*Sometimes gets used for something other than games. Link to comment Share on other sites More sharing options...
Gabriel G. Roy Posted June 28, 2023 Author Share Posted June 28, 2023 (edited) 1 hour ago, Oufti said: I am not sure what it is for you, but if you are showing the master pages instead of the pages in the Pages panel, you won't have any preview of the merge result, only the field name. If you select Pages instead of Master pages, the preview is correct. Ah, yes, okay. Thanks. I guess I need to do a little bit of research of the Pages vs Master Pages Edited June 28, 2023 by Gabriel G. Roy Quote Link to comment Share on other sites More sharing options...
Oufti Posted June 28, 2023 Share Posted June 28, 2023 2 hours ago, Gabriel G. Roy said: I guess I need to do a little bit of research of the Pages vs Master Pages Yes, it seems that this is as important and useful as it is confusing at first. I sometimes struggle with it too, because I'm not very experienced yet... Quote Affinity Suite 2.5 – Monterey 12.7.5 – MacBookPro 14" 2021 M1 Pro 16Go/1To I apologise for any approximations in my English. It is not my mother tongue. 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.