Jump to content
You must now use your email address to sign in [click for more info] ×

[Implemented] Data merge


Recommended Posts

I still use PagePlus for data merge and DrawPlus for trace. In fact there is a whole list of features that I call upon the Serif programs for because they are still, after all these years, missing from the Affinity suite. Nearly every job we start in Affinity has to be ultimately exported and finished in Serif.

So my advice would be try and get you hands on the legacy Serif programs. They will be super cheap now and will have the features we have been waiting for.

Link to comment
Share on other sites

I'm really pleased that Data Merge has been added. Now all I have to do is fathom out how it works! 😉

Acer XC-895 : Core i5-10400 Hexa-core 2.90 GHz :  32GB RAM : Intel UHD Graphics 630 : Windows 10 Home
Affinity Publisher 2 : Affinity Photo 2 : Affinity Designer 2 : (latest release versions) on desktop and iPad

Link to comment
Share on other sites

16 minutes ago, ajpearceUK said:

We need a howto.

There will surely be some documentation and probably some videos once the feature is released. For the moment, as it is in its first beta appearance, we can expect things to be rough. Betas are not released so people can use the features early, but rather for those who are willing find the bugs and report them. And not just bugs, but also feedback about how something is implemented.

Link to comment
Share on other sites

21 minutes ago, ajpearceUK said:

Agreed! We need a howto.

Perhaps you can give the developers a moment of breath to come up with some explanations 😉  But there is nothing wrong to gather together some insights on how this works by us forumsters.

Actually it is worth going over to the Mac and Windows beta forums, because there are already some things to read (and learn). Among them it turns out that merging image paths seems not to work on Windows, currently. But there is also a short video showing how that works on the Mac.

Basically it works like this:

  1. There's a new menu entry 'Data Merge Manager...' where you first set up different (or just one) data sources. These can be .csv or .json files or Excel tables.
  2. Then you go to 'Studio > Fields' where you find at the bottom of the list these data sources and their fields.
  3. Double clicking on a field name (this is important) inserts a field placeholder into a text element (text frame or artistic text). Note: this also works for image frames if the source contains absolute paths to image files (but with a bug on Windows).
  4. Finally, once your design is finished, you return to the 'Data Merge Manager...' and click on 'Generate'. This creates a new and unnamed document with the merged data.

There is also an additional new tool called 'Data Merge Node Tool'. With this you can create grid layouts that exactly distribute mulitple repeats of one base layout. It is very similar to a label printing setup in a word processor.

Cheers,
d.

Affinity Designer 1 & 2   |   Affinity Photo 1 & 2   |   Affinity Publisher 1 & 2
Affinity Designer 2 for iPad   |   Affinity Photo 2 for iPad   |   Affinity Publisher 2 for iPad

Windows 11 64-bit - Core i7 - 16GB - Intel HD Graphics 4600 & NVIDIA GeForce GTX 960M
iPad pro 9.7" + Apple Pencil

Link to comment
Share on other sites

50 minutes ago, garrettm30 said:

There will surely be some documentation and probably some videos once the feature is released. For the moment, as it is in its first beta appearance, we can expect things to be rough. Betas are not released so people can use the features early, but rather for those who are willing find the bugs and report them. And not just bugs, but also feedback about how something is implemented.

Indeed, but to be fair, it is going to be hard to test if people don't know how it works yet. Some pointers are always appreciated. ^-^

Link to comment
Share on other sites

29 minutes ago, garrettm30 said:

but I also think the process of trying to figure it out is of value for UX and UI feedback.

I completely agree. My first experience was that it seemed to be really a little hard to figure out even if it looked simple. This first implementation has rough edges but essentially it works (apart from the image path merge bug on Windows). It will be interesting to put it to some thorough testing with multiple data sources and more complex layouts like catalogs (which is something I personally have no experience).

d.

Affinity Designer 1 & 2   |   Affinity Photo 1 & 2   |   Affinity Publisher 1 & 2
Affinity Designer 2 for iPad   |   Affinity Photo 2 for iPad   |   Affinity Publisher 2 for iPad

Windows 11 64-bit - Core i7 - 16GB - Intel HD Graphics 4600 & NVIDIA GeForce GTX 960M
iPad pro 9.7" + Apple Pencil

Link to comment
Share on other sites

I think I've got it figured out now, thanks to dominik's guide above. Hopefully Serif will get the photo merge (or whatever they call it!) working on Windows soon. It will be interesting to see if it will be possible to combine data and photo merge in the same document.

Acer XC-895 : Core i5-10400 Hexa-core 2.90 GHz :  32GB RAM : Intel UHD Graphics 630 : Windows 10 Home
Affinity Publisher 2 : Affinity Photo 2 : Affinity Designer 2 : (latest release versions) on desktop and iPad

Link to comment
Share on other sites

7 minutes ago, dominik said:

... It will be interesting to put it to some thorough testing with ... more complex layouts like catalogs (which is something I personally have no experience).

The method used will not work for anything resembling a "real" product catalog. Only simple "product listing" types of catalogs.

This is also true of native InDesign, QXP and PagePlus, et al, catalogs. Which is why true add-ons for catalog creation and maintenance exist for ID/QXP. Which cost from $750 and up.

Even the types of merges I do cannot be made in the current APub implementation--and I haven't even downloaded the beta.

Link to comment
Share on other sites

3 minutes ago, MikeW said:

Even the types of merges I do cannot be made in the current APub implementation

I know (or at least assume from reading your posts) you have a lot of experience with complex publications like catalogs and other complex publications. I would be interested what 'types of merges' you are refering to. Really out of interest.

d.

Affinity Designer 1 & 2   |   Affinity Photo 1 & 2   |   Affinity Publisher 1 & 2
Affinity Designer 2 for iPad   |   Affinity Photo 2 for iPad   |   Affinity Publisher 2 for iPad

Windows 11 64-bit - Core i7 - 16GB - Intel HD Graphics 4600 & NVIDIA GeForce GTX 960M
iPad pro 9.7" + Apple Pencil

Link to comment
Share on other sites

2 hours ago, dominik said:

Perhaps you can give the developers a moment of breath to come up with some explanations 😉  But there is nothing wrong to gather together some insights on how this works by us forumsters.

Actually it is worth going over to the Mac and Windows beta forums, because there are already some things to read (and learn). Among them it turns out that merging image paths seems not to work on Windows, currently. But there is also a short video showing how that works on the Mac.

Basically it works like this:

  1. There's a new menu entry 'Data Merge Manager...' where you first set up different (or just one) data sources. These can be .csv or .json files or Excel tables.
  2. Then you go to 'Studio > Fields' where you find at the bottom of the list these data sources and their fields.
  3. Double clicking on a field name (this is important) inserts a field placeholder into a text element (text frame or artistic text). Note: this also works for image frames if the source contains absolute paths to image files (but with a bug on Windows).
  4. Finally, once your design is finished, you return to the 'Data Merge Manager...' and click on 'Generate'. This creates a new and unnamed document with the merged data.

There is also an additional new tool called 'Data Merge Node Tool'. With this you can create grid layouts that exactly distribute mulitple repeats of one base layout. It is very similar to a label printing setup in a word processor.

Cheers,
d.

Is the only option to create a new document in Publisher? No direct to PDF?

I know in Indesign you can do both. I find making a new Indesign document from the merged file can take a lot longer then exporting a merged file to PDF. 

 

Link to comment
Share on other sites

1 minute ago, wonderings said:

Is the only option to create a new document in Publisher? No direct to PDF?

Currently 'Generate' generates a new APub file. Of course that one you can eyport to PDF 😉

The new 'Data Merge' feature really is in its early stages, though.

d.

Affinity Designer 1 & 2   |   Affinity Photo 1 & 2   |   Affinity Publisher 1 & 2
Affinity Designer 2 for iPad   |   Affinity Photo 2 for iPad   |   Affinity Publisher 2 for iPad

Windows 11 64-bit - Core i7 - 16GB - Intel HD Graphics 4600 & NVIDIA GeForce GTX 960M
iPad pro 9.7" + Apple Pencil

Link to comment
Share on other sites

4 minutes ago, MikeW said:

In this example:

  1. The headings (here, Diffuser Supplies & Essential Oils) are exported from the database for each entry but only once appear at the beginning of their section.
  2. The repeating text shading repeats. However, the darker text shading always begins anew after a new section starts.

Thanks, that is a very good example to understand what you mean. It's a good starting point to poke into APubs data merge and see if that can be achieved (I'm sceptical at the moment).

d.

Affinity Designer 1 & 2   |   Affinity Photo 1 & 2   |   Affinity Publisher 1 & 2
Affinity Designer 2 for iPad   |   Affinity Photo 2 for iPad   |   Affinity Publisher 2 for iPad

Windows 11 64-bit - Core i7 - 16GB - Intel HD Graphics 4600 & NVIDIA GeForce GTX 960M
iPad pro 9.7" + Apple Pencil

Link to comment
Share on other sites

12 minutes ago, undercovergypsy said:

Thank you Dominik - I don't see the Excelf file that I chose in the Data Manager - can someone tell me what i am doing wrong?

I just tried and a Excel file shows up just as a .csv did.

Make sure you save in .XLSX format.

d.

Affinity Designer 1 & 2   |   Affinity Photo 1 & 2   |   Affinity Publisher 1 & 2
Affinity Designer 2 for iPad   |   Affinity Photo 2 for iPad   |   Affinity Publisher 2 for iPad

Windows 11 64-bit - Core i7 - 16GB - Intel HD Graphics 4600 & NVIDIA GeForce GTX 960M
iPad pro 9.7" + Apple Pencil

Link to comment
Share on other sites

4 minutes ago, MikeW said:

Without scripting that can have logic applied to the incoming data

This is why I am sceptical at the moment 😉

I'll try and see if I can find something with sections and master page elements. But not today ... (yawn ... sorry).

d.

Affinity Designer 1 & 2   |   Affinity Photo 1 & 2   |   Affinity Publisher 1 & 2
Affinity Designer 2 for iPad   |   Affinity Photo 2 for iPad   |   Affinity Publisher 2 for iPad

Windows 11 64-bit - Core i7 - 16GB - Intel HD Graphics 4600 & NVIDIA GeForce GTX 960M
iPad pro 9.7" + Apple Pencil

Link to comment
Share on other sites

Thanks — I finally got it to show up and the fields. I jumped the “generate” gun and it was not showing up. That being said, — I have double-clicked each field and it does nothing. I tried clicking the text tool first and still nothing? I am an idiot...and so for now,  it is not idiot-proof. I will however keep, as someone else said, “poking away” at it. It is so great to have this opportunity! 

Link to comment
Share on other sites

6 minutes ago, MikeW said:

Speaking of Master pages, in this example (which was adapted from a real job), I need to switch master pages during the merge.

Thank you for sharing.

I think it will take a long time (and a lot of expertise) until it will be - with APub - possible to achieve such a workflow.

Cheers,
d.

Affinity Designer 1 & 2   |   Affinity Photo 1 & 2   |   Affinity Publisher 1 & 2
Affinity Designer 2 for iPad   |   Affinity Photo 2 for iPad   |   Affinity Publisher 2 for iPad

Windows 11 64-bit - Core i7 - 16GB - Intel HD Graphics 4600 & NVIDIA GeForce GTX 960M
iPad pro 9.7" + Apple Pencil

Link to comment
Share on other sites

15 minutes ago, MikeW said:

Speaking of Master pages, in this example (which was adapted from a real job), I need to switch master pages during the merge.

prod-tags.jpg.96864ff7d20624cbe167c71252bccadd.jpg

I think I've used this example, too. Here I've included a screen shot of the simple code required. The logic sets the master page(s) and the first three words of the blurb to the company's color. The top background color and company logos are master page elements.

Would be nice to have an "if this then that" feature in the data merge but I think it is probably very early for that. You can do that in Indesign but it is a round about way as it is not directly supported. Think you are basically creating scripts in the csv file that then turns on the layer you need and the other layers off.

What are you currently using to accomplish this? If I need to do something like this I have SmartStream Designer. Fairly knew to it at this stage but it is pretty powerful and can do what you are asking really easily. Of course that comes with a price tag :D

 

Link to comment
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • 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.