Jump to content

Recommended Posts

I read somewhere that you can use a data merge function in Affinity Publisher to create text variables, i.e. if I write "Gain 1 {gold}", I can make the text {gold} be exchanged for a gold icon. Could someone point out where in Publisher this function might be found? :) 

Link to post
Share on other sites

In the 1.9.0 beta.

And it is a bit more complicated, you need to work with a spreadsheet or CSV file to get the fields for replacement.

MacBook Pro (13-inch, Mid 2012) Mac OS 10.12.6 || Mac Pro (Late 2013) Mac OS 10.14.6

Affinity Designer 1.9.3 | Affinity Photo 1.9.3 | Affinity Publisher 1.9.3 | Beta versions as they appear.

Link to post
Share on other sites

Serif does not have any tutorials for it, but perhaps there are some by users on YouTube. The 1.9 beta Help has a page on Data Merge and another on the Data Merge Layout Tool.

No one outside of Serif knows when 1.9 will be formally released, and those in Serif who know won't say. The usual answer is "when it's ready".

-- Walt

Windows 10 Home, version 20H2 (19042.685),
   Desktop: 16GB memory, Intel Core i7-6700K @ 4.00GHz, GeForce GTX 970
   Laptop (2021-04-06):  32GB memory, Intel Core i7-10750H @ 2.60GHz
, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU
Affinity Photo 1.9.2.1035 and 1.9.4.1065 Beta   / Affinity Designer 1.9.2.1035 and 1.9.4.1065 Beta  / Affinity Publisher 1.9.2.1035 and 1.9.2.1024 Beta

Link to post
Share on other sites
  • 1 month later...

I'm starting to feel a bit annoying x) but after going through tutorials on data merge for Affinity Publisher 1.9 I still cannot find a way to create text variables the way I described in my initial post. I can import text and image sources from a spreadsheet, yes, but I still have to import them separately to text frames and image frames respectively. But the ability to import text as an image seems to be lacking. To be really clear, I want to create playing cards like these ones, where some text phrases can be seamlessly converted to game icons:

pic2686348_lg.jpg

Link to post
Share on other sites

I think what you're asking for isn't actually a data merge (which is typically used with structured data from a spreadsheet or database to create bulk mailings/form letters/labels etc etc). What you actually want is the ability to embed inline graphics (horses, planes, harps etc) in the text flow?

If so then I'm pretty certain the answer is that there is not really any way of automating this: Affinity Publisher doesn't have any straightforward way of importing or modifying tagged text :(.  It is possible to embed graphic documents into the text flow, but as far as I can see this would only work as a manual one-by-one cut-and-paste process. If on the other hand the graphics were characters in a specialised font, it might be possible to code them.up as character styles, but you'd need to use some mind-bogglingly complex search and replace routines to process the imported text.

(And you're not at all annoying...)

Cheers,

H

Affinity Photo 1.9.3,  Affinity Designer 1.9.3, Affinity Publisher 1.9.3, Mac OSX 11.2, 2018 MacBook Pro 15"

Betas as they happen... 

Link to post
Share on other sites

I think h_d is on the right track. Your example shows about a dozen 'glyphs' in the text in the descriptions which would need the replacement.

You could do a search  for the word Glyph_Artillary and step through pasting in the image, this could be a dozen times or hundreds of times which is not practical.

Font creation is beyond my pay grade but your best bet is to find a font with the glyphs you want to use, you may need to hire some one to create one. Then it is a simple find and replace for oddball characters to be replaced with a Character Style which uses that font.

MacBook Pro (13-inch, Mid 2012) Mac OS 10.12.6 || Mac Pro (Late 2013) Mac OS 10.14.6

Affinity Designer 1.9.3 | Affinity Photo 1.9.3 | Affinity Publisher 1.9.3 | Beta versions as they appear.

Link to post
Share on other sites

Inline icons is the term I am looking for, thank you h_d. I'm a bit surprised that Affinity does not have this, when they have so many other features! There are some much simpler programs that have this, so I am going to have to rely on one of these instead.

Cheers

Link to post
Share on other sites
On 1/2/2021 at 11:39 AM, Kijoli said:

I read somewhere that you can use a data merge function in Affinity Publisher to create text variables, i.e. if I write "Gain 1 {gold}", I can make the text {gold} be exchanged for a gold icon.

As long as the icons are just black you can create a font with ligatures which would automatically substitute the icons. What font are you using for the text?

Also, what game is this for? Often the game itself has a font included which displays the text icons. Or sometimes fans create their own fonts for writing about the game.

Link to post
Share on other sites

LibreTraining,

The game, Forces of History, is one that I am creating myself:

https://www.kickstarter.com/projects/1661241863/forces-of-history-a-world-history-simulation-game/preview

The card images above were just examples from the board game Through the Ages.

The font has not yet been decided upon. But creating a font of one's own seems difficult and some icons will probably have color in them. Thanks anyway!

 

Link to post
Share on other sites
35 minutes ago, Kijoli said:

But creating a font of one's own seems difficult and some icons will probably have color in them. Thanks anyway!

I was going to offer to create the font for you, if you could provide vector drawings of the black icons. But, if you must have color ... Affinity apps do not yet support color fonts so kinda pointless at this time.

Link to post
Share on other sites
10 minutes ago, LibreTraining said:

I was going to offer to create the font for you, if you could provide vector drawings of the black icons. But, if you must have color ... Affinity apps do not yet support color fonts so kinda pointless at this time.

But @Kijoli could choose an ink colour for that glyph.

Post Script: That is a very generous offer.

MacBook Pro (13-inch, Mid 2012) Mac OS 10.12.6 || Mac Pro (Late 2013) Mac OS 10.14.6

Affinity Designer 1.9.3 | Affinity Photo 1.9.3 | Affinity Publisher 1.9.3 | Beta versions as they appear.

Link to post
Share on other sites
  • 1 month later...

I am very late to this, but maybe look in to the pinning panel? The InDesign equivalent is the anchored object where you insert images within the text box that flows with the text.

Ignore this if this has been solved!

Link to post
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

Please note there is currently a delay in replying to some post. See pinned thread in the Questions forum. These are the Terms of Use you will be asked to agree to if you join the forum. | 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.