asked on

document link on server

I have a script that when selected from the navigator, it takes you to the lan server and accesses either a word doc or excel spreadsheet schedule. It works great... the problem I am now encountering is people not being able to open the documents at different times and able to other times. I'm thinking it has to do with the document being locked by someone updating it at that time.
There is only a select group of individuals that have update authority and read only for others.
here is the script .
Do you see any other way to do this to ensure everyone can read the link spreadsheets no matter what, and only the select group update by the server security.
Sub Click(Source As Button)
Dim workspace As New NotesUIWorkspace
Dim rc As Integer
Dim Tranlink As Variant

Dim tempList(4) As String
tempList(0) = "eMedNY Inbound"
tempList(1) = "eMedNY Outbound"
templist(2) = "MMIS Inbound"
templist(3) = "MMIS Outbound"
templist(4) = "eMedNY 24-7 Interface Timeline"

Tranlink = workspace.Prompt( PROMPT_OKCANCELLIST,"Interfaces", "Please Select an Interface Type from the list below or cancel ", "", tempList )

If Tranlink = "eMedNY Inbound" Then
'Msgbox "cmd/C ""\\20.20.128.39\CSC\SDG DOC Repository\"& X &"\GIST0008 - Xcom File Transfers.xls"" ",,"Please Note path:"
rc = Shell ("cmd /C ""\\20.20.128.39\CSC\teams\implementation\deployment\estar link\eMedNYin.xls"" ")
Else
If Tranlink = "eMedNY Outbound" Then
rc = Shell ("cmd /C ""\\20.20.128.39\CSC\teams\implementation\deployment\estar link\eMedNYout.xls"" ")
'rc = Shell ("cmd /C ""\\20.20.128.39\CSC\teams\implementation\claims\scheduling\flowcharts\getreceive.bat"" ")
Else
If Tranlink = "MMIS Inbound" Then
rc = Shell ("cmd /C ""\\20.20.128.39\CSC\teams\implementation\deployment\estar link\MMISin.xls"" ")
'rc = Shell ("cmd /C ""\\20.20.128.39\CSC\teams\implementation\claims\scheduling\flowcharts\gettransmit.bat"" ")
Else
If Tranlink = "MMIS Outbound" Then
rc = Shell ("cmd /C ""\\20.20.128.39\CSC\teams\implementation\deployment\estar link\MMISout.xls"" ")
'rc = Shell ("cmd /C ""\\20.20.128.39\CSC\teams\implementation\claims\scheduling\flowcharts\getreceive.bat"" ")
Else
If Tranlink = "eMedNY 24-7 Interface Timeline" Then
rc = Shell ("cmd /C ""\\20.20.128.39\CSC\teams\implementation\deployment\estar link\247time.xls"" ")
'rc = Shell ("cmd /C ""\\20.20.128.39\CSC\teams\implementation\claims\scheduling\flowcharts\getreceive.bat"" ")
End If
End If
End If
End If
End If
End Sub

HemanthaKumar

You mean it is timing out ?

~Hemanth

pratigan

ASKER

I'm not sure.... I think its locking people out. I don't know if its a contention problem that people are locking others out. It seems to be sparatic. When they select the document link it works some time and others it does nothing. It doesn't give a message just doesn't open a link. It doesn't do anything. Just wondering if there is any thing I can do from a design standpoint.
:)

zvonko

Hello,

there is a better way of doing this but it is extremely complicated. You can configure your Domino server to fetch the files from directories for you. You have the ACL support for this. It works for web and for Notes clients. Are you interested in this?

pratigan

ASKER

Hello Zvonko,
I may be interested. However, If there is server work to do I would need to forward that on to the server admin group. How complicated ??? and how many points ???
:)
Thanks !

ASKER CERTIFIED SOLUTION

zvonko

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jean Marie Geeraerts

Hm, sounds interesting.

zvonko

<|:-)

pratigan

ASKER

Hello Zvonko,
Sound fairly straight forward. I think there will be a few problems with access to the server and rebot server functions as the server admin group are very security oriented. I will look further into this and get back to you.
Thanks !! :)

zvonko

This NET USE line can be fired also in an scheduled or web agent. Afterwards is this drive letter available for all processes on Domino. But the reboot part is important for this map and file documents. They are evaluated only at http start time. So you have at least to restart http task. You see?

zvonko

And by the way, such experiments are only allowed on test machine :-)

pratigan

ASKER

Hello Zvonko,
I have checked into this further and I have determined that it would be a nightmare in dealing with the server admin group. They are very security conscience and I would not be able to work with this or test it as they do not have a test server for use outside of the admin group. Thank You for the proposed solution anyways. I will grant you the initial points for your feedback.
Thanks Again !!
Paul

zvonko

You are right: don’t wake up sleeping dogs :-)

Tell to these dogs: what is a bigger hole in their security, features controlled by Domino or those batch shell spaghetti code?

pratigan

ASKER

LOL... I agree.
Thanks !
Paul

pratigan

ASKER

Your Time and Effort is much appreciated !!
Thanks Again !
Paul

zvonko

Thank you for the points and for the feedback :-)

pratigan

ASKER

HEllo Zvonko,
Just a quick followup question. I have this link working very well. However.. when the document is locked or password protected... the link gives back no message... Is there a way to have it provide a read only access if the document is currently locked by someone else ???

Zvonko

This is an old one and I missed the last comment.
Anyway, from my point of view is there not an easy solution.
The upper access is controlled by a feature simmelar to Notes ACL.
Therefore it is not possible to modify the access rights on the fly and reduce it to Read access in case of problems.