Highlighted

%0D being added to all URL's

Community Beginner ,
Feb 20, 2019

Copy link to clipboard

Copied

Hi, I have a problem that I can't find the anwser to, so I'm hoping that you can help.

I'm making a new manual at work, and I have about 600 URL's that I've transfered over from excel.

When I export the file to PDF (Interactive) it auto adds %0d to my URL's so insted of sending the user to: https://www.mysite.eu/the_file.pdf the URL will say http://www.mysite.eu/the_file.pdf%0D

If I then go and delete the %0D from the browser line, the URL workes just fine.

So my question is, how do I get rid of the %0D when exporting to pdf ??

Here is a list of things that I've tried already:

- Export with "Shared destination" checked

- Export with "Shared destination" un-checked

- Checking in excel that the URL don't have any line breaks

- Checking in excel that the URL don't have "carriage return"

- Copying the URL to notepad, and from there to InDesign

- Typing the URL in InDesign manual

Nothing of this has worked for my.. Please help if you can.. The manual will be send out to our customers world wide, so it needs to work..

Most Valuable Participant
Correct answer by BobLevine | Most Valuable Participant

Try to place the Excel file into InDesign instead of pasting it.

Views

2.7K

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

%0D being added to all URL's

Community Beginner ,
Feb 20, 2019

Copy link to clipboard

Copied

Hi, I have a problem that I can't find the anwser to, so I'm hoping that you can help.

I'm making a new manual at work, and I have about 600 URL's that I've transfered over from excel.

When I export the file to PDF (Interactive) it auto adds %0d to my URL's so insted of sending the user to: https://www.mysite.eu/the_file.pdf the URL will say http://www.mysite.eu/the_file.pdf%0D

If I then go and delete the %0D from the browser line, the URL workes just fine.

So my question is, how do I get rid of the %0D when exporting to pdf ??

Here is a list of things that I've tried already:

- Export with "Shared destination" checked

- Export with "Shared destination" un-checked

- Checking in excel that the URL don't have any line breaks

- Checking in excel that the URL don't have "carriage return"

- Copying the URL to notepad, and from there to InDesign

- Typing the URL in InDesign manual

Nothing of this has worked for my.. Please help if you can.. The manual will be send out to our customers world wide, so it needs to work..

Most Valuable Participant
Correct answer by BobLevine | Most Valuable Participant

Try to place the Excel file into InDesign instead of pasting it.

Views

2.7K

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
Feb 20, 2019 1
Most Valuable Participant ,
Feb 21, 2019

Copy link to clipboard

Copied

How are moving this info from Excel to ID? What version of ID? What version of Excel? What operating system?

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
Reply
Loading...
Feb 21, 2019 0
Community Beginner ,
Feb 21, 2019

Copy link to clipboard

Copied

I'm using:

Windows 10 (64 bit)

InDesign CC version 14.0.1 x64

Excel 2013

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
Reply
Loading...
Feb 21, 2019 1
Most Valuable Participant ,
Feb 21, 2019

Copy link to clipboard

Copied

You still didn’t tell us how you’re moving from Excel to InDesign.

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
Reply
Loading...
Feb 21, 2019 0
Community Beginner ,
Feb 21, 2019

Copy link to clipboard

Copied

Oh sorry..

I'm just using simple copy paste.

Marking the text in excel and then using "Ctrl+C" to copy, and then inserting it in InDesign using the "Insert new hyperlink" function.

I don't know if it makes a diffrence, but I'm inserting my hyperlink on an image insted of a text.

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
Reply
Loading...
Feb 21, 2019 0
Most Valuable Participant ,
Feb 21, 2019

Copy link to clipboard

Copied

Try to place the Excel file into InDesign instead of pasting it.

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
Reply
Loading...
Feb 21, 2019 0
Community Beginner ,
Feb 21, 2019

Copy link to clipboard

Copied

It might be me not being totaly clear about what it is I'm after, but the excel file will not be included in what I'm doing, it's only the means in wich I've gotten the URL's from our marketing department, so I just need to get the links out of excel and into InDesign.

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
Reply
Loading...
Feb 21, 2019 0
Most Valuable Participant ,
Feb 21, 2019

Copy link to clipboard

Copied

Again, place the file. Then copy paste the URLs to where you need them in InDesign.

See if that works.

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
Reply
Loading...
Feb 21, 2019 0
Community Beginner ,
Feb 21, 2019

Copy link to clipboard

Copied

I did not know that you have the posibility to import excel files into inDesign by placing them like an image !!

That's for the help. It's working 100%

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
Reply
Loading...
Feb 21, 2019 1
Community Beginner ,
Nov 05, 2019

Copy link to clipboard

Copied

Hello Bob

I've been looking for a solution for the same problem and found only this discussion over the web.

Unfortunately, the solution written here doesn't work for me.

I'm placing a docx file and upon exporting the links been added with %0D.

What could it be?

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
Reply
Loading...
Nov 05, 2019 1
Adobe Community Professional ,
Nov 05, 2019

Copy link to clipboard

Copied

Hi InbalZissu,

I think this is a very old issue.

 

See into this thread from 2012 to test the scripting solution ( ExtendScript/JavaScript )

https://community.adobe.com/t5/InDesign/CS6-hyperlink-problem/m-p/4218626#M14486

 

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
Reply
Loading...
Nov 05, 2019 1
Community Beginner ,
Nov 05, 2019

Copy link to clipboard

Copied

Thank you for your reply, but it's not old at all.

This discussion is from Feb this year.

I didn't find an answer in the link you've sent me.

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
Reply
Loading...
Nov 05, 2019 1
Adobe Community Professional ,
Nov 05, 2019

Copy link to clipboard

Copied

Hi InbalZissu,

well, you are right. The issue discussed in this thread is: Something, %0D is added to a URL hyperlink destination.

We could try a scripting solution similar to the one in the other thread I linked to.

 

I'd like to write a script that is doing this: Remove the extra %0D off the end of the URL if this %0D is already visible in the URL of the hyperlink in InDesign. At least I can test if something, a special character perhaps, is added at the end and when exported to PDF transfers to %0D in the link. Can you provide a sample InDesign document for testing some script code? Together with the exported PDF?

 

Upload the documents zipped to Dropbox or a similar service and provide the download link.

 

Thanks,
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
Reply
Loading...
Nov 05, 2019 0
Community Beginner ,
Nov 11, 2019

Copy link to clipboard

Copied

Hi

When I look at the links in the indesign file I don't see that addition, but here are the files:

INDD: https://drive.google.com/file/d/1J9sucLAinWpq3k1KTtvNXnnSTJUVF040/view?usp=sharing

PDF: https://drive.google.com/file/d/1JMLNKQJc8-8HaASAVomFsSx9BzyWGDvP/view?usp=sharing

 

Thank you

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
Reply
Loading...
Nov 11, 2019 0
Adobe Community Professional ,
Nov 11, 2019

Copy link to clipboard

Copied

Sorry. I have no Google Account and I'm not willing to add one.

So I cannot download your files.

 

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
Reply
Loading...
Nov 11, 2019 0
Community Beginner ,
Nov 11, 2019

Copy link to clipboard

Copied

Ok, try this one:

https://we.tl/t-U4AdbZjEOZ

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
Reply
Loading...
Nov 11, 2019 0
Adobe Community Professional ,
Nov 14, 2019

Copy link to clipboard

Copied

Hi InbalZissu,

it's hard for me to check your Hebrew document, but as far as I can see there is no issue with the hyperlinks of your buttons in this document. Exported a PDF (Interactive) with my German version of InDesign CC 2019. All buttons are working, means if the are clicked they will lead me to a web page. If they are working as expected I cannot tell, because I cannot read or understand any Hebrew.

 

Below an example from page 15 with Button 60.

In the layout:

Button60-InDesign-Layout.png

 

Web page opened with Firefox on Windows 10 from my exported PDF opened in my German Adobe Reader:

Button60-PDF-WebPage.png

The same page will be addressed if I open your PDF and click the same button.

FWIW: I cannot see any %0d characters added to the URLs as the original poster of this thread has seen.

 

So: What exact issue do you have with that document?

Maybe a bug with the Hebrew version of Adobe Reader?

 

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
Reply
Loading...
Nov 14, 2019 1
Community Beginner ,
Nov 18, 2019

Copy link to clipboard

Copied

Thank you very much for taking the time of looking into this.

I can not see the web address of the screenshot you've sent, you said there's no %0D added but - the page shows an error. "There's no page".

Have you tried couple of links? none of them adds %0D at the end?

Maybe it's a problem in the middle eastern version then, but still, you've got an error too.

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
Reply
Loading...
Nov 18, 2019 0
Adobe Community Professional ,
Nov 18, 2019

Copy link to clipboard

Copied

Hi InbalZissu,

ok, then we have an issue.

I've seen into this again.

 

If I copy the URL of button 60 to a text frame, copy the contents to my browser I get this web page:

 

Button60-REAL-TARGET.PNG

 

If I then assign the contents of this text frame as URL to a button's target and export as Adobe PDF Interactive I can see the same URL in Acrobat Pro with a different notation of the individual Hebrew glyphs, their corresponding Unicode codes:

 

Burron-URL-From-AcrobatPro.PNG

 

As far as I can tell there is no glyph added.

The last one in the URL is <05EA> that corresponds with InDesign's contents of the text frame above the button:

Burron-URL-From-InDesign.PNG

 

However if I click the button with my Adobe Reader the following web page will open:

ButtonPressedWithAdobeReader-WRONG-TARGET.png

 

So I conclude this is a different issue that we are seeing here.

My German InDesign will export the Hebrew glyphs as Unicode codes and my browser is not able to translate them back to Hebrew glyphs like my copy/paste action is doing this OK when coming from the contents of my text frame.

 

No extra code is added, but the result is far from working.

I have no idea what to do to get this right.

 

Uwe Laubender

( ACP )

 

EDITED: Fixed a typo

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
Reply
Loading...
Nov 18, 2019 1
Adobe Community Professional ,
Nov 18, 2019

Copy link to clipboard

Copied

I said: "I have no idea what to do to get this right".

This is meant in the context of InDesign.

With Acrobat Pro I could copy the URL to the button to maintain the Hebrew glyphs:

 

ChangeTheURLwithAcrobatPro.PNG

 

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
Reply
Loading...
Nov 18, 2019 0