Skip to main content
M
mstrohFG
Participant
July 7, 2021
Answered

Can InDesign Data Merge handle basic HTML entities?

  • July 7, 2021
  • 2 replies
  • 1482 views

We have a cloud-hosted product information database where we store all of our product info and images. That database provides product info to our websites and, hopefully, to InDesign via Data Merge. I can't seem to find any resources to help with my problem, though, which is that I'd like to have InDesign somehow interpret basic HTML during the Data Merge process. For instance, if my data contains a reference to a periodical, that should be italicized. In the product info database, it's stored as <i>Magazine Name</i> (for example). 

 

Also, there is a need for bulleted lists. How can Data Merge interpret either <li></li> or separate fields that use InDesign bullets?

This topic has been closed for replies.
Correct answer mstrohFG

I'm just updating this thread with my own answer. I have found EasyCatalog to be the best bet for me. The way I can both set entire columns to use either basic or enhanced HTML interpretation sealed the deal. I'm concataniting all of my bullet points in Salsify as a group of bullets, then in InDesign the EasyCatalog field let me apply HTML interpretation to the field. So now if I have either 1 or dozens of bullets, the list always looks correct.

2 replies

L
Community Expert
LaubenderCommunity Expert
Community Expert
July 7, 2021

Hi mstrohFG,

you could prepare a template with all the formatting with paragraph styles for the list elements and character styles for the character formatting. After the merge you could use a script to apply the styles and getting rid of the "tags" with some GREP Find/Replace actions.

 

Read through the scripts Peter Kahrel did for GREP:

https://creativepro.com/files/kahrel/indesign/grep_matters.html

 

There are also scripts there that could help you to construct GREP queries and run them one after another automatically. Also see into Jongware's WhatTheGREP script and the GREP documentation:

http://www.jongware.com/idgrephelp.html

 

Regards,
Uwe Laubender

( ACP )

    M
    mstrohFGAuthor
    Participant
    July 7, 2021

    Hello Uwe and Eugene.

     

    Thanks for your reply. 

     

    I should have been slightly more clear. In our 'references' section those are actual publication references. So the name of the magazine is italicized within a block of text. Also, we sometimes use ingretients such as lactobacillus, which is always listed in italics because of it's latin roots.

     

    I've attached:

    1. A simplified data sheet called my-data.csv (ASCII Mac)
    2. The InDesign template that I'm using (basic-data-sheet-20210707.indd)
    3. And the output of that data sheet in InDesgin and PDF (basic-data-sheet-output-20210707.indd / .pdf)

     

    I think EasyCatalog might be the best move in that you can set on a column by column level how you want the data handled. It also has a 'basic html interpreter' built into it. But if there is a way to GREP this consistently, that could be interesting. 

    M
    mstrohFGAuthorCorrect answer
    Participant
    July 9, 2021

    I'm just updating this thread with my own answer. I have found EasyCatalog to be the best bet for me. The way I can both set entire columns to use either basic or enhanced HTML interpretation sealed the deal. I'm concataniting all of my bullet points in Salsify as a group of bullets, then in InDesign the EasyCatalog field let me apply HTML interpretation to the field. So now if I have either 1 or dozens of bullets, the list always looks correct.

      E
      Community Expert
      Eugene TysonCommunity Expert
      Community Expert
      July 7, 2021

      It might be possible via datamerge. 

       

      You will need to place a placeholder for each data merge field which will look like say

      Magazine Name (the first row on the CSV for import.

      When you insert that as a Field in InDesign it will look like;

      <<Magazine Name>>

      You can apply an Italic style to that so it looks like <<Magazine Name>>

       

      And when you do your Data Merge all the entries for Magazine Name will be italic. 

       

      Same for bulleted lists -  you will need a header row for the column in the CSV called Bullet List

      And insert that to the indesign file would look like

      • <<Bullet List>>

      And all entries using Bullet List would have the bullet style.

       

      But you'd need to insert the correct amount of bullet lists into the text for the data merge. 

       

       

      XML might be better for you - but I'm not proficient in that.

      https://www.adobe.com/devnet/digitalpublishingsuite/articles/using-xml-to-automate-production-of-digital-publications.html

       

      You can get plugins for InDesign

      https://www.65bit.com/software/easycatalog/

       

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices