OpenURL (Urgent)

HCL Domino Domino Forum
1

I upgraded my mail server to 6.0.3 but it creating problem in opening from web.I have a page contaimig hotspot link to mailing database.On the click event of hotspot link i am calling an agent which opens the mail file of the user currently logged in.But instead of opening mail file it tries to open URL of the database containing page of hotspot link.

i have given formula in hotspot click

@URLOpen(“/”+@ReplaceSubstring(@Subset(@DbName;-1);“\”;“/”)+“/(getMail)?OpenAgent&”+@Name([Abbreviate];@UserName))

agent which i am calling is as above

Sub Initialize

Dim session As New NotesSession

Dim db As NotesDatabase

Dim view As NotesView

Dim doc As NotesDocument

Dim userdoc As NotesDocument







Set db=session.getDatabase("","names.nsf")

If Not db.isOpen Then

	status=db.open("","names.nsf")

End If



Set doc=session.DocumentContext

varString=doc.Query_String(0)





newString=Evaluate("@replaceSubstring('"+varString+"';'%20';'')")

varUserName=Strright(newString(0),"&")





Set view=db.getView("People")

Set userdoc=view.getFirstDocument

Do Until userdoc Is Nothing

	

	

	If Trim(Strleft(userdoc.columnValues(3),"@")) = Trim(varUserName) Then

	'If Trim(Strleft(userdoc.columnValues(5),"@")) = Trim(varUserName) Then	

		Exit Do

	End If

	

	Set userdoc=view.getNextDocument(userdoc)

Loop



varMail= Evaluate("@ReplaceSubString(MailFile;'\\';'/')",userdoc)



Print "[" + "/" +varMail(0) + ".nsf"+ "]"

'Print  "/" +varMail(0) + ".nsf"

End Sub

in people view i found that 5th column have e-mail id so i tried with fifth column but it also not work.

it was working well previously.I am in a serious trouble please help me who ever can.

its to urgent please reply as soon as possible

2

Subject: OpenURL (Urgent)

Does it work if you hardcode all values in @URLOpen(“/”+@ReplaceSubstring(@Subset(@DbName;-1);“\”;“/”)+“/(getMail)?OpenAgent&”+@Name([Abbreviate];@UserName)) ?Replace space characters in name to “+” characters. “/” character in abbreviated name might also be confusing for server.

What is the resulting incorrect URL? Does browser finds the agent at all?

I remember I had similar problem with @URLOPEN in R5, for some reason it couldn’t accept formulas but worked fine with hardcoded URL.

3

Subject: I recommend that you do this another way…

especially if you have a large NAB. Your loop processes all documents in the People view trying to find a match. I would suggest taking a look at view.GetDocumentByKey and making this a little faster. Sorry that I don’t have an answer to your problem. Also there is an out of the box template for a database that can do this for you in R6.5 and 6.0.3 called Domino Web Access Redirect (iwaredir.ntf).

4

Subject: RE: I recommend that you do this another way…

ThanksI hav solved it.

It was bcoz rearrangement of columns in people view in R6.Now this view has more columns than it had in R5. now email id is 5th column.