Data merge initial thoughts (split)

[MickRose]

I can't work it out either. I have a 10 record xlsx file called Book1.xlsx which has loaded okay. But how do I show where the data is meant to go?

[Joachim_L]

Have a look at the Fields panel. Mark your text where your data should go and double-click the appropriate field in the Fields panel. For better visualization Menu -> Text -> Highlight Fields.

[Patrick Connor]

@MickRose

I think this question should be in the beta forum, but....

I have used Text > Insert > Field > More... and inserted the xlsx column titles using double click from the list (like other Fields can be added in text).

[MickRose]

Thanks Patrick & Joachim_L

[wonderings]

I briefly checked it out and was left scratching my head. I am sure it will make more sense when I actually research how it works in Publisher. It was not clear or evident though as I thought it should be when looking at it. I am not new to this so thought I could/should be able to figure it out quickly. I tried loading a csv file with a little over 9000 records. It did not show me the fields available for merge. I thought maybe I need to hit generate to bring that up. Well that was not the right move, took ages for it to go through the data and was left with a large publisher file with I am assuming 9000+ pages. Again going in completely blind so it may work well once I understand Affinities method, but it certainly did not stand out obviously.

[Patrick Connor]

@wonderings & @MickRose

I think leaving this in that old feature request thread was going to lead to lots more posts in the wrong place, so I have put your posts here

[undercovergypsy]

I really appreciate  - in my software on Windows 10 it does not have typical field choices or database selection. It looks like this (ignore cursor) I am just trying to show my workspace and the choices:

[dominik]

14 minutes ago, undercovergypsy said:

in my software on Windows 10 it does not have typical field choices or database selection.

 

You set up the data connection in the Data Merge Manager:

 

Fields are inserted from 'View > Studio > Fields'

Cheers,
d.

[Dazmondo77]

Working great for me for 8up business cards - made a template - tested - NICE!