Skip to main content
Inspiring
December 11, 2023
Question

Data Merge for Calendar

  • December 11, 2023
  • 2 replies
  • 1106 views

I have around 20 calendars with designs similar to the one I added in the image that need to be updated from 2024 to 2025. I am manually updating the dates one by one using the end nested style method. Is there a way to use data merge to change these calendars from the year 2024 to 2025, or do you know of a shorter method? 

Thank you so much. 

This topic has been closed for replies.

2 replies

Inspiring
December 12, 2023

What is your source and in what format? If it is a spreadsheet you could place as tables and keep the link to the spreadsheet.

Inspiring
December 12, 2023

Hello, sorry but I do not understand what you mean by format. I am using tables for dates. 

 

Inspiring
December 12, 2023

Sorry. I wasn't clear in my question. As you have planned to use Data Merge, you must have a source document to data-merge from. What is the source document?

Robert at ID-Tasker
Legend
December 11, 2023

If those TFs for days are linked - you could just place a new contents - best would be to use InDesign Tagged Text format.

 

But if they are separated and without any kind of labels to identify them - you would need to start from scratch... unless... can you share your document?

 

Inspiring
December 12, 2023
Of course, thank you for your assistance. I am sending you my document as an attachment.
Robert at ID-Tasker
Legend
December 12, 2023

As you are using Tables - so the only option is to replace contents of those tables... Much quicker than writing script.

 

You can use any website for days:

https://www.timeanddate.com/calendar/?year=2024&country=9

 

 

Then copy&paste month by month - but for some reason you have local Numbering turned on:

 

 

 ... so you would need to turn it off: