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

[Implemented] Data merge


Recommended Posts

  • 2 weeks later...

I have to keep my old PagePlus X9 just so that I can do Mail Merge jobs. 

(and, occasionally, to open PDF files with embedded fonts that Affinity can't open correctly!)

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

On 12/13/2019 at 12:18 PM, fde101 said:

They generally do not respond to feature requests, but they actually did respond to this one a few times: 

 

etc.

Yes they did but not to any satisfaction of the people requesting  this feature for the past two years.

It would be nice if the affinity developer team took this huge  community needing this feature seriously.

 

-pp-

 

Link to comment
Share on other sites

  • Staff

Hi petrpastor,
Welcome to Affinity Forums :)
We do take community feedback seriously but it doesn't mean we can fulfil all requests as soon/fast as people would like - even in two years. Affinity Publisher is on its infancy. There's still various areas that need some work (integration with the other two apps, file presets/templates, linked/embedded file management, PDF import/export improvements, preflight etc (besides bugs to fix) until we can add more features. As explained several times we have limited resources compared to other known companies and are also developing a design/vector application and RAW developer/photo editing app at the same time for three different platforms alongside with Publisher, not Publisher alone. All this requires time. I think the teams have achieved quite a lot considering some years ago there was nothing at all. Please bear with us. 

Link to comment
Share on other sites

  • 3 weeks later...
  • 3 weeks later...

And yet another person who does not feel that Affinity Publisher is complete without a Mail Merge ability. Please add this feature. PagePlus had it and it worked very well.

While you are at it, make sure that it can import .csv or and the very least .txt files into whatever database file it creates. Many times it is necessary to create and sort a merge list in a more robust program such as Excel so it is essential to be able to import the generic list.

This is a deal-breaker; your new program should have at least the same functionality as the one you have retired. I appreciate some of the new features (OpenType and the fact that you do not have to close and reopen the document when you load a new font to name a couple), but please don't sacrifice basic functions in the rage to have new features.

P.S. Though I am a 'newbie' to this forum, I have used PagePlus and DrawPlus almost from the beginning (when the program files were distributed on 3.5 inch floppies attached to tech magazines...) I used to be really impressed with Serif programs; it would be nice to feel that way again.

Edited by lois_wa
add comment
Link to comment
Share on other sites

I know a lot of people are frustrated with the lack of an integrated data merge feature in Affinity Publisher. I think we can all agree that while Adobe's InDesign had the feature, there was a lot of things even it could not do well at all.

Fortunately, my husband knows a bit of coding. He created a little program for me that takes a spreadsheet converted to a .tsv file, which does the data merge into a plain text document for me, resulting in one file that I could simply cut and paste into the text frame in Publisher, and with one click add as many pages as was need to fit all the text.

Yes, you could do this sort of data merge in Word if you owned Microsoft Office products, but there were variables in what I needed to do that even Word wouldn't have been able to handle. A few lines of code, and everything was done for me!

Adobe could only make individual text frames for me, of EACH entry (there are over 200 entries), which I then had to stitch back together into one text frame. If a cell was empty, it would ignore, but if I had specified a coma between two values pre-data merge, then I'd have a lonely coma I'd have to go back and delete. Imagine sifting through over 200 multiline entries to find all these straggling lonely items!

While Adobe's auto format during data merge is nice, the amount of time I took to set up some quick format keys in Affinity and format all the text created using my husband's few lines of code took me a LOT less time than the awkward process in Adobe.

If Affinity could read and apply formats based on text markup, my husband's code solution would be absolutely perfect. But the lack of data merge isn't going to stop me from using Publisher or encouraging others to do so. :)

Link to comment
Share on other sites

On 1/24/2020 at 3:29 PM, lois_wa said:

does not feel that Affinity Publisher is complete without

No software is complete, and no software ever will be.  If it was, it would consume an infinite amount of space and take an infinite amount of time to develop, so you would never have the opportunity to use it.

Link to comment
Share on other sites

On 1/31/2020 at 4:50 PM, undercovergypsy said:

I wonder if your husband is willing to sell it?  :)

Haha! I'm sure he'd give it for free... but it's hand-coded and was built specifically to my needs. You'd have to know the coding he used (don't ask me, I don't know!) and how to change it to suit your needs.

However, maybe there's a niche market for this? For a small fee, specific code to meet your specific needs? :-) If you're dead serious, I'll ask him if he's interested in a side job.

Link to comment
Share on other sites

  • 3 weeks later...
14 minutes ago, paull said:

it's starting to make me sad coming back to this topic just to see it's still not implemented :(

Me too! – But I really can't see it happening until at lease version 2! 🙁

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

I don't know if this is pertinent but for those who want to abandon Indesign can you use the Acrobat plugin Quite Imposing Plus 5. It now can take your Affinity PDF's (or any for that matter) and apply CSV merges to them.

I also am excited for the day when we can finally have mail merges. That and raster to vector conversions are the only thing I see needed just about! Maybe vector warping.

Link to comment
Share on other sites

  • 2 weeks later...

I agree mail merge is needed but not before the PDF import is fixed. Much of the data merge I do is on top of supplied PDF's. I can in no way shape or form trust Publisher with any PDF in its current state. If I was going to have an order it would be PDF import with NO attempts at editing the PDF then data merge capabilities. That along with preflight would make it a much more usable and pro like app. 

Link to comment
Share on other sites

On 3/7/2020 at 5:20 PM, Bright said:

Me too :(

+1 for DataMerge

I buy Affinity Products to support your development. I have not swiched however because mailings are most important and not possible without data merge. Please prioritize!

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.