[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference iosg::all-in-1_v30

Title:*OLD* ALL-IN-1 (tm) Support Conference
Notice:Closed - See Note 4331.l to move to IOSG::ALL-IN-1
Moderator:IOSG::PYE
Created:Thu Jan 30 1992
Last Modified:Tue Jan 23 1996
Last Successful Update:Fri Jun 06 1997
Number of topics:4343
Total number of notes:18308

2783.0. "Unreserve a document and who was it ..." by VNABRW::EHRLICH_K (Health & a long life with you) Tue Jun 01 1993 17:27

Hi all,

	a question came up during a short presentation of the new features
of ALL-IN-1 V3.0-1 (german) at a customer site.

Having a SHARED Drawer (regular or advanced) with some users.

USERB reserves a document (from USERA drawer).
The CIB is correctly updated with State: RESERVED. 

USERA now wants to know who has reserved the document. So you can do a
Edit and you'll get the message who has this document reserved.
(I've built a menuoption for this, with parts of WP_RESERVE_DOCUMENT.SCP)

BUT, there's no way to do this AFTER the document is being 'unreserved'.

I'm really interested, how can we get a 'history', who was the last user
of this document. There's no change in DOCDB (the author is the person who only
created a document and the record in RESERVE_LIST is deleted).
The only 'guy' who obtain this info, must be the FCS?!?!?!?
 
Have you an idea, maybe you can put it on a *WISHlist* for a PFR.

Best regards
Charly_from_CSC_Vienna
    
T.RTitleUserPersonal
Name
DateLines
2783.1Asked before I believeAIMTEC::WICKS_AAlphatraz - Coming Summer 93Tue Jun 01 1993 18:498
    Charly,
    
    Amongst other matches STARS shows me note 453 - it seems like the
    same question.
    
    Regards,
    
    Andrew.D.Wicks
2783.2I don't think so, but ...VNABRW::EHRLICH_KHealth & a long life with youWed Jun 02 1993 10:3037
Dear Andrew,

I've looked in STARS and here in this conference before I wrote this one, 
but with no success. The only note I've found is 436, which gives you an 
info about RESERVATIONS.DAT and RESERVE_LIST. Note 453 has nothing to do 
with my 'challenge'.

Again, maybe my explanation is not the best, so I try it once more.

The CIB of WP for my document:

[USERA]MAIN
TEST
Testdocument
Karl Ehrlich
01.Jun.1993
000001		RESERVED

USERB is doing an E or RSV and gets the message:
Already reserved by Karl Ehrlich on node VNADC on 02-Jun-1993 09:59am

Then I unreseve this document with URV.

So, now my question again, is there any possibility to find out, who has
done the last reservation of this document. (It is really neccessary because
the customer would like to see who has done the last modification of this
document!!!)

And AFTER an unreservation the entry in RESERVE_LIST and RESERVATION.DAT is
deleted and there happens no change to DOCDB.DAT. Therefore you never can
find this info. 

I hope it's now clear and easy to understand what I (and the customer)
really want to know. 

Best regards
Charly_from_CSC_Vienna
2783.3IOSG::MAURICENight rolls in, my dark companionWed Jun 02 1993 12:0315
    Hi,
    
    After the UNRESERVE the information about who last reserved the
    document is deleted. To provide the information you want, and possibly
    extending to allow full auditing, would require a significant
    unplanned development to the File Cabinet Server. 
    
    No workround is going to be satisfactory. If your users are WPS-PLUS
    users then they can keep their own audit trail within a document by use
    of a COMMENT control block. A UDP could be done to make this a bit
    easier.
    
    Cheers
    
    Stuart
2783.4That's what I've thought...VNABRW::EHRLICH_KHealth & a long life with youWed Jun 02 1993 12:5719
    Hi Stuart,
    
    	thank you very much for taking advice of this. Yes, that's what
    I've thought when I was looking for reservation in Tonys Book.
    
    It will also be a hard work NOT to delete the records in RESERVE_LIST
    only setting the TYPE to soemthing like F (for free again). Then you
    can get the info 'who was the last reservator'. This was in my mind
    yesterday night.
    
    But will this ever work, I don't know.
    
    Best regards
    Charly
    
    Ps: I've built a new menu option to get the owner of a reserved
    document and it works fine. So you need not do an Edit or RSV to
    get the message.
     
2783.5GOLD VIEW shows who reserved documentIOSG::MAURICENight rolls in, my dark companionWed Jun 02 1993 14:3516
    Hi Charly,
    
    Changing RESERVE_LIST.DAT would not help, since that is a list of
    documents that a user has reserved. In this case it's who reserved the
    document, and this is held in RESERVATIONS.DAT. This file is
    exclusively accessed by the File Cabinet Server.
    
>    Ps: I've built a new menu option to get the owner of a reserved
>    document and it works fine. So you need not do an Edit or RSV to
>    get the message.
    
    GOLD V already does this!
    
    Cheers
    
    Stuart
2783.6There's always something to learn!VNABRW::EHRLICH_KHealth & a long life with youWed Jun 02 1993 15:359
    Stuart,
    
    	oh, what a good feature. It's really nice!
    
    Best regards
    Charly
    
    
    
2783.7I do it in an other way...VNABRW::EHRLICH_KHealth & a long life with youThu Jun 03 1993 11:3717
    Hi Stuart,
    
    	yesterday I was looking for an easy solution for this 'challange'.
    Well, if customer will pay for it, why not.
    
    I will save the the entry from RESERVE_LIST (but not all values, only
    docnum,owner,maybe date) in an other file. This will happen, if the
    user is doing the UNRESERVE menuoption, before all info in
    RESERVE_LIST and RESERVATIONS.dat is going to be deleted.
    
    And of course it's nice to have an own ENTRY&INDEX form for this file
    where the user can have a info who has ever reserved documents.
    
    Hopefully I haven't forgotten something, have I ??
    
    Best regards
    Charly
2783.8A thorny pathIOSG::MAURICENight rolls in, my dark companionThu Jun 03 1993 12:5625
    Hi Charly,
    
    The information about who reserved, unreserved, or replaced a document
    will need to be recorded on the system where the document lives. You
    may have a scenario where a remote user edits a document and then it's
    no good recording this information on the remote system, since the
    local users would not be able to access it.
    
    Ideally there would be an audit file per drawer and a drawer attribute
    asking for auditing. But who would have the privilege to write to a file
    in another user's directory, perhaps on another system? Answer - the
    File Cabinet Server. For this reason I believe that the problem can
    only really be solved by an extension to the File Cabinet Server.
    
    If you want to provide a local-only solution then you are slighly
    better off. You could provide an audit file, either per drawer or per
    system, that would be written to local users. But you would need to
    worry about file protections, since you will not want to provide world
    write files. This may lead you into the world of code level
    integrations, where you can use ALL-IN-1's installed privileges to get
    round the problem.
    
    Cheers
    
    Stuart
2783.9Oh dear, not CLI!VNABRW::EHRLICH_KHealth & a long life with youThu Jun 03 1993 13:1915
    Dear Stuart,
    
    	my thoughts were so easy, but after reading your reply, I'm
    'voiceless' and great surprised now.
    
    Well, the best will be, that I join to you (IOSG).
    
    Stuart, it was very very kind to bring me some light in my darkness.
    In most cases, easy wishes can be very difficult to implement, when you
    don't know what's exactly behind the scene.
    
    CLI is another story!
    
    Bye for now
    Charly_the_darkside... 
2783.10Don't forget non-VMS systemsCHRLIE::HUSTONThu Jun 03 1993 15:167
    
    
    and don't forget TeamLinks. Any solution you do that does not
    involve the FCS runs the risk of TeamLinks not working with it.
    
    --Bob