Hyperlinks from Excel and Word

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
elpakko
Posts: 10
Joined: 10 Jun 2010, 05:42

Hyperlinks from Excel and Word

Post by elpakko »

Hello.

Hyperlinks to Mantis issues from MS Excel and Word are not working correctly. For example if I have the following link inside a Word document or a Excel cell:

http://mantis/view.php?id=1824

For some reason clicking the link will redirect to http://mantis/my_view_page.php which is the default view when logging in to Mantis.

The strange thing here is that if I have the same hyperlink for example in my Outlook email editor, it works fine. Also if I click the link from this forum site it works perfectly. So I know there is nothing wrong with the link url itself. I have tested this behaviour with IE8, IE9, Mozilla Firefox -browsers and Office 2003, 2010 -products. This happens in both of my two Mantis versions: 1.2.1 and 1.1.1. So apparently this is a problem with Excel and Word.

Other users claim that this worked in our very old Mantis version 0.19.4 but I really don't know if that's true...

Have anyone experinced the same problem and is there possibly someone who could help? Any help much appreciated!

Thanks.
atrol
Site Admin
Posts: 8531
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Hyperlinks from Excel and Word

Post by atrol »

You can check the access log files of your webserver to find the difference between Outlook and Word
Please use Search before posting and read the Manual
elpakko
Posts: 10
Joined: 10 Jun 2010, 05:42

Re: Hyperlinks from Excel and Word

Post by elpakko »

Ok, thanks. Here's what I see:

Apache access log - a successfull attempt (from outlook mail editor):

[28/Oct/2010:13:46:24 +0300] "GET /view.php?id=1824 HTTP/1.1" 200 14104 "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Tablet PC 2.0)"

Apache access log - an unsuccessful attempt (from excel cell):

[28/Oct/2010:13:44:21 +0300] "GET /view.php?id=1824 HTTP/1.1" 302 - "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Tablet PC 2.0; ms-office)"
[28/Oct/2010:13:44:21 +0300] "GET /login_page.php?return=view.php%3Fid%3D1824 HTTP/1.1" 200 3758 "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Tablet PC 2.0; ms-office)"
[28/Oct/2010:13:44:22 +0300] "GET /login_page.php?return=view.php%3Fid%3D1824 HTTP/1.1" 302 - "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Tablet PC 2.0)"
[28/Oct/2010:13:44:22 +0300] "GET /my_view_page.php HTTP/1.1" 200 33489 "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Tablet PC 2.0)"


So there is some differences in the get-command. Does someone know how to fix this? Thanks.
elpakko
Posts: 10
Joined: 10 Jun 2010, 05:42

Re: Hyperlinks from Excel and Word

Post by elpakko »

Still banging my head with this one... Help anyone?
atrol
Site Admin
Posts: 8531
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Hyperlinks from Excel and Word

Post by atrol »

Please use Search before posting and read the Manual
Lapinkiller
Posts: 408
Joined: 28 Jan 2011, 18:47
Location: France
Contact:

Re: Hyperlinks from Excel and Word

Post by Lapinkiller »

Hello

Sherlock Holmes is here ! :mrgreen:

Mantis uses cookies for authentication (to know if user is authenticated or not, mantis look a cookie)

When you click on a link in an office document, office try to open link instead of just giving the link to the web-browser

if IE ( :evil: ) is the default browser, at each link you will have to login and link will works
else, first time you will have to login and link will works, but after, mantis will not prompt you to login and will redirect you to my_view_page.php

http://support.microsoft.com/kb/899927
Lapinkiller,
French PHP developer
New look for your mantis : http://www.mantisbt.org/forums/viewtopi ... =4&t=20055
elpakko
Posts: 10
Joined: 10 Jun 2010, 05:42

Re: Hyperlinks from Excel and Word

Post by elpakko »

Ok, that seems to be the problem here. So i guess we just have to live with it...

Thanks!
Lapinkiller
Posts: 408
Joined: 28 Jan 2011, 18:47
Location: France
Contact:

Re: Hyperlinks from Excel and Word

Post by Lapinkiller »

I have corrected this bug !

Patch attached on bug : http://www.mantisbt.org/bugs/view.php?id=13060
related to : http://www.mantisbt.org/bugs/view.php?id=13065
Lapinkiller,
French PHP developer
New look for your mantis : http://www.mantisbt.org/forums/viewtopi ... =4&t=20055
elpakko
Posts: 10
Joined: 10 Jun 2010, 05:42

Re: Hyperlinks from Excel and Word

Post by elpakko »

Thanks a ton! Hope this is fixed in the next version of Mantis.
funta
Posts: 2
Joined: 10 Aug 2006, 13:15

Re: Hyperlinks from Excel and Word

Post by funta »

@Lapinkiller

I installed your patch to mantis 1.2.8, but unfortunately it does not resolve the issue.

Now all links clicked in an external application (excel, word, desktop shortcut etc) got to this url:

http://mantis.my.domain.com/mantis//man ... php?id=123

instead to

http://mantis.my.domain.com/mantis/view.php?id=123
Lapinkiller
Posts: 408
Joined: 28 Jan 2011, 18:47
Location: France
Contact:

Re: Hyperlinks from Excel and Word

Post by Lapinkiller »

take a look a my response on the bugtracker ;)
Lapinkiller,
French PHP developer
New look for your mantis : http://www.mantisbt.org/forums/viewtopi ... =4&t=20055
dregad
Developer
Posts: 94
Joined: 26 Jul 2010, 14:24

Re: Hyperlinks from Excel and Word

Post by dregad »

I have just committed LapinKiller's patch.
Post Reply