data merge with hyperlinks

Guru ,
May 09, 2022 May 09, 2022

Copy link to clipboard

Copied

Hello,

 

i looked this up and it seems such thing can't be done. However i wanted to double check.

 

I have some certificates:

Screen Shot 2022-05-09 at 11.37.41 AM.png

Every year i make these, i run a data merge from a .csv file and place a unique number in each text field where you see "your unique access url" ... that used to say serial number...

 

this year they want a serial number there, however, there is a unique hyperlink associated with it. This is what i have in the excell sheet:

Screen Shot 2022-05-09 at 11.37.48 AM.png

 

however, when i save a .csv file the url is gone:

Screen Shot 2022-05-09 at 11.37.56 AM.png

 

How can  i turn a data merge and keep that hyperlink?

 

thank you

jonathan

TOPICS
How to

Views

154

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
May 09, 2022 May 09, 2022

Copy link to clipboard

Copied

Hi Jonathan,

one should be able to do this with postprocessing the result of that data merge with a custom script.

 

Regards,
Uwe Laubender

( ACP )

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guru ,
May 09, 2022 May 09, 2022

Copy link to clipboard

Copied

hello Uwe, can you elaborate. I do not understand.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
May 09, 2022 May 09, 2022

Copy link to clipboard

Copied

Here we go: There is no way in the GUI or in the core functionality of data merge itself to do what you want.

So one could develop a script that relies on a list of texts and their corresponding URLs to search for the text instances in the result InDesign document that is merged and that adds hyperlinks according to that list to the found texts.

 

Regards,
Uwe Laubender

( ACP )

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
May 09, 2022 May 09, 2022

Copy link to clipboard

Copied

LATEST

In Excel, you will need to convert the hyperlink to URL. There are a few way to do this, some methods are listed in this link

 

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines