Successfull documents sharing - WebDAV and linked MS Excel problems

[xcerv]

Dear all,

I would like to hear some ideas about our approach and possible ways how to improve our situation.
We are using Livelink for sharing documents. We share them inside separate departments (folders), but some documents are shared across the whole corporation.
The key functionality we use is the ability to use linked MS Excel sheets. (linked data across multiple documents – 2-4 levels deep) This is done through WebDAV and it works if the user have the correct permissions on all the linked documents and their parent containers. There lies the problem. When you want to add permission to specific user to edit the document you have to set the permission on the document and on the parent folder. (at least see permission is required on the parent for WebDAV to work)

This is something we and our users are not happy about and we are trying to come with a better solution to accomplish this.

Using separate workspaces for groups outside the boundaries of the departments will not solve all our problems. There are still many documents shared between users for one time purposes.

Is there a better way how to share documents to accomplish this?
Is there another possibility how to use linked MS Excel sheets in Livelink?

Regards
xcerv

 

[appnair]

I really don't think you can do much in this case unless you want to obey both livelink's business rules and excel's business rules both are say rigid.Now in my mind all you can do is basically understand the fact that excel while it is very simple and suffices to do most of the typical chores business communities want you are pretty much extending a desktop product to do enterprise stuff.Obviously a database driven application will perhaps understand and perform much better.Obviously this may work but it may require programming to a certain extent.assume you have one parent webdav document and two child webdav documents who are the links.You would come up with a bundle so you would checkout either manually or programmatically these three into a zip file.At this point they are file system files which will obey excel on the desktop.Once finished you could reverse the process and do this.I say this but it is probably a programming hack coming from me

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair