Skip to main content
Known Participant
April 8, 2023
Question

Adobe Indesign - how to automatically update table cell values from our database

  • April 8, 2023
  • 2 replies
  • 1031 views

Hello all,

 

I am trying to learn how I can automatically update values in an Adobe InDesign template programatically. We have an Adobe Indesign template (.idml) that our design team creates and we then want to use it to populate the necessary values in specific cells for many countries directly from our database. I am looking to use R but also have familiarity with python. 

 

I am looking for a simple tutorial that shows me how I can get started to automate an output similar to what is described above. I'm looking for a very basic solution that shows how I can take a value from our database and write it to a specific cell in an Adobe InDesign table cell. Would you have a suggestion?

 

Thank you in advance,

Jeff

This topic has been closed for replies.

2 replies

Robert at ID-Tasker
Legend
April 9, 2023

In your other posts you mention using DataMerge - is it good enough, beside the clock glyph problem - or you are still looking for something else?

 

InDesign Tagged Text might be solution - depends on how complicated your template is. 

 

You could also try to build your IDML file - it's a text so fairly easy to modify - if you split it into parts and insert your values in between. 

 

Known Participant
April 9, 2023

Hi Robert, that's correct I have been using Data Merge but I am curious to see how I can automate our template updates using R and IDML. I am looking for a tutorial that can walk me through how to set up a very basic connection but can't seem to find anything that really gets me going. Hoping the community might be able to direct me to the right resource.

 

Thanks,
Jeff

Robert at ID-Tasker
Legend
April 9, 2023

Don't think you can directly connect from R to InDesign. 

 

My idea was to just "create" IDML from scratch - or if your "design" is just formatted text - InDesign Tagged Text would be best solution. 

 

Community Expert
April 9, 2023

Where are the values coming from? 

 

Known Participant
April 9, 2023

I'm using R to extract from a MariaDB; I'm looking for an example where I can link values extracted from our DB to an Adobe InDesign template.

Known Participant
April 9, 2023

Also using a Windows 11 Pro operating system