[rt-users] Linking to RT from MS Excel
I'm trying to set up a link from a MS Excel spreadsheet to an RT ticket. I've tried the "hyperlink" function and also a directl link; no matter what I do RT only goes to the home page. Hyperlinking directly to a ticket seems to work otherwise. Is there something particular about excel that makes it break? Does anyone know where to look? -- If you have eight hours to chop down a tree spend six sharpening your axe. --Abraham Lincoln
[rt-users] Linking to RT from MS Excel
Install firefox and set it as your default browser, then check if the problem get solved or not. I think I had experienced the same thing before with ms IE On Thursday, May 5, 2011, Yan Seiner wrote: > > On Wed, May 4, 2011 3:48 pm, Yan Seiner wrote: >> >> I'm trying to set up a link from a MS Excel spreadsheet to an RT ticket. >> I've tried the "hyperlink" function and also a directl link; no matter >> what I do RT only goes to the home page. >> >> Hyperlinking directly to a ticket seems to work otherwise. Is there >> something particular about excel that makes it break? Does anyone know >> where to look? > > Here's the apache logs of the exchange: > > 140.211.84.66 - - [04/May/2011:16:06:26 -0700] "GET > /Ticket/Display.html?id=9 HTTP/1.1" 302 439 "-" "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; Media Center PC 6.0; MDDS; .NET4.0C; > InfoPath.2)" > 140.211.84.66 - - [04/May/2011:16:06:28 -0700] "GET > /NoAuth/Login.html?next=e7071bf98bd712fceaa850abf5cc00e6 HTTP/1.1" 200 > 5559 "-" "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; Media > Center PC 6.0; MDDS; .NET4.0C; InfoPath.2)" )" > >> > > Anyone have any clue what's going on? > > It looks like a failed login, but the user is logged in on the machine, > and RT opens up on the user's dashboard. >
Re: [rt-users] Linking to RT from MS Excel
On Wed, May 4, 2011 3:48 pm, Yan Seiner wrote: > > I'm trying to set up a link from a MS Excel spreadsheet to an RT ticket. > I've tried the "hyperlink" function and also a directl link; no matter > what I do RT only goes to the home page. > > Hyperlinking directly to a ticket seems to work otherwise. Is there > something particular about excel that makes it break? Does anyone know > where to look? Here's the apache logs of the exchange: 140.211.84.66 - - [04/May/2011:16:06:26 -0700] "GET /Ticket/Display.html?id=9 HTTP/1.1" 302 439 "-" "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; Media Center PC 6.0; MDDS; .NET4.0C; InfoPath.2)" 140.211.84.66 - - [04/May/2011:16:06:28 -0700] "GET /NoAuth/Login.html?next=e7071bf98bd712fceaa850abf5cc00e6 HTTP/1.1" 200 5559 "-" "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; Media Center PC 6.0; MDDS; .NET4.0C; InfoPath.2)" 140.211.84.66 - - [04/May/2011:16:06:31 -0700] "GET /Ticket/Display.html?id=9 HTTP/1.1" 302 439 "-" "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; Media Center PC 6.0; MDDS; .NET4.0C; InfoPath.2)" 140.211.84.66 - - [04/May/2011:16:06:32 -0700] "GET /NoAuth/Login.html?next=f6e5ec0408aa263848c49978088df779 HTTP/1.1" 200 5559 "-" "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; Media Center PC 6.0; MDDS; .NET4.0C; InfoPath.2)" 140.211.84.66 - - [04/May/2011:16:06:35 -0700] "GET /NoAuth/Login.html?next=f6e5ec0408aa263848c49978088df779 HTTP/1.1" 302 384 "-" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)" 140.211.84.66 - - [04/May/2011:16:06:36 -0700] "GET / HTTP/1.1" 200 38925 "-" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)" > Anyone have any clue what's going on? It looks like a failed login, but the user is logged in on the machine, and RT opens up on the user's dashboard. This is repeatable on both my home server and on the Gossamer hosted installation we have. -- If you have eight hours to chop down a tree spend six sharpening your axe. --Abraham Lincoln
Re: [rt-users] Linking to RT from MS Excel
On May 5, 2011, at 7:10 AM, Yan Seiner wrote: > On Wed, May 4, 2011 3:48 pm, Yan Seiner wrote: >> >> I'm trying to set up a link from a MS Excel spreadsheet to an RT ticket. >> I've tried the "hyperlink" function and also a directl link; no matter >> what I do RT only goes to the home page. >> >> Hyperlinking directly to a ticket seems to work otherwise. Is there >> something particular about excel that makes it break? Does anyone know >> where to look? > > Here's the apache logs of the exchange: > Anyone have any clue what's going on? > > It looks like a failed login, but the user is logged in on the machine, > and RT opens up on the user's dashboard. I've encountered similar problems with other sort of websites if hyperlinked from Office (not necessarily Excel, but also Word and PowerPoint). It's very irritating. I understand the issue is that Office programs will make an initial web request NOT using your favourite web browser, where it does not have the correct login credentials (or cookies of a pre-existing logged in session), and thus ends up with the wrong web content. If that initial web request results in a HTTP 403 error (forbidden), the Office program will just pop-up an error dialog without even launching the browser (this happens on my Drupal website). I would love to know if there's a solution to this too. Regards, .lzs
Re: [rt-users] Linking to RT from MS Excel
On Wed, May 4, 2011 4:53 pm, Lai Zit Seng wrote: > On May 5, 2011, at 7:10 AM, Yan Seiner wrote: > >> On Wed, May 4, 2011 3:48 pm, Yan Seiner wrote: >>> >>> I'm trying to set up a link from a MS Excel spreadsheet to an RT >>> ticket. >>> I've tried the "hyperlink" function and also a directl link; no matter >>> what I do RT only goes to the home page. >>> >>> Hyperlinking directly to a ticket seems to work otherwise. Is there >>> something particular about excel that makes it break? Does anyone know >>> where to look? >> >> Here's the apache logs of the exchange: > > > >> Anyone have any clue what's going on? >> >> It looks like a failed login, but the user is logged in on the machine, >> and RT opens up on the user's dashboard. > > I've encountered similar problems with other sort of websites if > hyperlinked from Office (not necessarily Excel, but also Word and > PowerPoint). It's very irritating. I understand the issue is that Office > programs will make an initial web request NOT using your favourite web > browser, where it does not have the correct login credentials (or cookies > of a pre-existing logged in session), and thus ends up with the wrong web > content. If that initial web request results in a HTTP 403 error > (forbidden), the Office program will just pop-up an error dialog without > even launching the browser (this happens on my Drupal website). OK, for posterity, here's the solution, provided by our very helpful IT department: This MSKB article http://support.microsoft.com/kb/899927 explains the nature of the problem and which makes reference to the registry fix described in this article http://support.microsoft.com/kb/218153. I can vouch for the fact that applying the fix does resolve the link problem. -- My daughter is racing a triathlon to raise money for her swim club. Want to help? http://akari.seiner.com