Karen_ Posted September 7 Share Posted September 7 Hi everyone, I'm using affinity publisher data merge tool and it seems to be having some trouble reading my CSV file as columns (ex. table 1 - list of names, etc). When I click the preview button, the auto populated version is correct, however the generated version is missing values. Please see attached images. Thank you. Quote Link to comment Share on other sites More sharing options...
Karen_ Posted September 7 Author Share Posted September 7 Quote Link to comment Share on other sites More sharing options...
anto Posted September 7 Share Posted September 7 Could you attach file afpub and csv, at least some part of data? Quote Link to comment Share on other sites More sharing options...
Old Bruce Posted September 7 Share Posted September 7 I think your spreadsheet is sideways. It looks like this and it should look like this (please excuse the autofill names, these are not real people) Karen_ 1 Quote Mac Pro (Late 2013) Mac OS 12.7.1 Affinity Designer 2.2.1 | Affinity Photo 2.2.1 | Affinity Publisher 2.2.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...
Karen_ Posted September 7 Author Share Posted September 7 Yes! Attached it here.Seating Chart_Example.csvExample.afpub Quote Link to comment Share on other sites More sharing options...
Karen_ Posted September 7 Author Share Posted September 7 @Old Bruce If I do it this way, I'm not able to list the names as columns under the proper table number it seems. The fields aren't showing up correctly as "table 1, table 2, table 3" etc. Quote Link to comment Share on other sites More sharing options...
Old Bruce Posted September 7 Share Posted September 7 @Karen_, each row is a record. You are having them in columns. Here is how I would do it. Note that I have some Blank rows in the CSV Spreadsheet, this is to isolate the Wedding Table. After you generate the file you will have to go in and delete the empty text frames and move the head table to the centre as per your first screenshot. Seating chart etc.zip Quote Mac Pro (Late 2013) Mac OS 12.7.1 Affinity Designer 2.2.1 | Affinity Photo 2.2.1 | Affinity Publisher 2.2.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...
Karen_ Posted September 7 Author Share Posted September 7 @Old Bruce Thank you! I can see how laid it out. It's much simpler than what I have been doing and much less time consuming. Much much appreciated. Quote Link to comment Share on other sites More sharing options...
anto Posted September 7 Share Posted September 7 You can use also as you have created. Change only Record offset to -6, -8, -7 Look at video. I get one more line, i do not know why. 2023-09-07 19-01-45.mp4 Quote Link to comment Share on other sites More sharing options...
Karen_ Posted September 7 Author Share Posted September 7 @anto Thank you very much. I'm not sure what the offset does exactly. If I'd also like to include letters beside each name, would I be able to do so using the same table I created? Quote Link to comment Share on other sites More sharing options...
anto Posted September 7 Share Posted September 7 36 minutes ago, Karen_ said: If I'd also like to include letters beside each name What do you mean? Could you give example? Quote Link to comment Share on other sites More sharing options...
Karen_ Posted September 7 Author Share Posted September 7 @anto Yes, I'd like to use the same format as @Old Bruce however, in this case there are three parameters. Example, the alphabet, number, and name. Currently, I am creating individual data frames. TEST.csv Quote Link to comment Share on other sites More sharing options...
anto Posted September 7 Share Posted September 7 For now it is very difficult to create catalog in Publisher. Maybe in future it will be possible. You can create this in 5 clicks in Word using Catalog option and then Place your document in Publisher. Look at video 2023-09-07 21-37-32.mp4 Quote Link to comment Share on other sites More sharing options...
lacerto Posted September 7 Share Posted September 7 In these kinds of situations it might be more flexible and versatile just using simple text flows with column breaks (and possibly tabs), using the text frame features of Publisher. This kind of workflow would allow easier editing after the initial flow has been done. Wedding.docx Wedding_textflow_with_column_breaks.afpub Quote Link to comment Share on other sites More sharing options...
Karen_ Posted September 7 Author Share Posted September 7 @anto @lacerto Thank you both for your input. @lacerto Interesting way of going about it. I have not tested this feature. It may definitely be easier. Quote Link to comment Share on other sites More sharing options...
lacerto Posted September 7 Share Posted September 7 4 minutes ago, Karen_ said: Interesting way of going about it. I have not tested this feature. It may definitely be easier. It is pretty easy to create the source as it basically only needs to be a list where table names are marked with a paragraph style (the guests can just be left as "Normal" style or renamed as "Guest"). When imported, each paragraph will be tagged with a paragraph style, and you would modify the styles as you wish in Publisher (e.g., I changed the font size to 48 points and centered all paragraphs, made spacing tighter by using smaller paragraph leading, and made table names bold. TableName paragraph style has a column break Flow setting defined so that text will automatically flow from table to table (four columns of table text frames) when the text is flown across the frames. Quote Link to comment Share on other sites More sharing options...
Karen_ Posted September 7 Author Share Posted September 7 @lacerto If possible, would you be able to create a short video demo? Thank you. Quote Link to comment Share on other sites More sharing options...
lacerto Posted September 7 Share Posted September 7 13 minutes ago, Karen_ said: If possible, would you be able to create a short video demo? Thank you. Here is a demonstration of creating a column-based text flow in Publisher by placing a Word document containing table and guest names as paragraph styles. ColumnFlow.mp4 I also attached a Publisher document I created earlier to replace your Publisher example file with data merge layout controls. It has document history saved so you can use the History panel to see gradual changes I made to create a column-based layout. Wedding_textflow_with_column_breaks_with_history.afpub Karen_ 1 Quote Link to comment Share on other sites More sharing options...
Karen_ Posted September 7 Author Share Posted September 7 @lacerto This is amazing. Thank you so much. 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.