Trapping these scenarios is not easy. What we are doing is removing the choices from the attachment pool and adding buttons for that functionality. Then when the button is pushed we copy the attachment to an audit form and log who made the change.
Dave -------------------------- [EMAIL PROTECTED] (Wireless) ----- Original Message ----- From: Action Request System discussion list(ARSList) <arslist@ARSLIST.ORG> To: arslist@ARSLIST.ORG <arslist@ARSLIST.ORG> Sent: Thu Aug 02 07:57:19 2007 Subject: Re: Attachement Updation Hi Hugo, Let me explain the scenario. (A). First user attached a file name called test.txt which contains characters "Test". The second user overwrite this file into new filename called test2.txt which containts "Test2". No both file name and number of characters are changed. I wrote one filter which run on modify and the run if qualification is 'TR.FormAttachment' ! = 'DB.FormAttachment'. When i check the filter log, after above action (A) that filter has been failed. I don't know what the wrong in it was. Please let me know if i need to change anything. One more constraint in this, suppose the second user modify the same test.txt file with the characters "Rome" and reattaching the file. Now the same file name with same number of characters. This time database shows that, there is no change in the existing record. Anyhow the file has been updated with the new contents. Can you please let me know how can i check in this case? Thanks, Meenakshinathan On Aug 2, 2:15 pm, Hugo Visser <[EMAIL PROTECTED]> wrote: > You cannot compare the file contents, but using TR you should be able to > detect that a file was attached again (if the DB value wasn't $NULL$). The > "value" contains the file size in bytes, the compressed size in the DB and > the full filename on the client. > > Also note that user cannot change the attachment from the attachment field > without re-attaching it. Just changing the attachment (open->edit->save) > doesn't update the DB, it only updates the local temporary copy of the file. > > Hugo > > On 8/2/07, Meenakshinathan <[EMAIL PROTECTED]> wrote: > > > > > > > > > Hi Robert, > > > Thanks for the information. > > > Anyhow this solution is not working. Remedy stores the attachments in > > the following way <number of characters>,<no of bytes>(i am sure. but > > it might bytes),<filename with extenstion>. > > > I am not user this TR and DB can apply for attachement fields. > > > can any one give me a alternative solution on this? Looking for your > > inputs. > > > Thanks, > > Meenakshinathan > > > On Jul 28, 2:36 am, Robert Halstead <[EMAIL PROTECTED]> wrote: > > > I'm not entirely sure on this, but couldn't you do a filter on modify > > > with a run-if condition as: 'TR.Attachment' != 'DB.Attachment' ?? I'm > > > not entirely sure how remedy stores the attachments. It might > > > work.... > > > > Anyone else ?? > > > > On 7/27/07, Meenakshinathan <[EMAIL PROTECTED]> wrote: > > > > > Hi Listers, > > > > > In my application, at first stage users can attach 3-4 files. when the > > > > request assinged to next stage, that next stage user can edit or > > > > modify the attachment and can upload it again. In this stage my client > > > > has an requirement like, first stage user to be notified whenever any > > > > attachement is updated. If anybody came throrough this , can you > > > > please let me know how do i implement this? > > > > > Thanks, > > > > Meenakshinathan > > > _______________________________________________________________________________ > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where > > the Answers Are" > > > > -- > > > "A fool acts, regardless; knowing well that he is wrong. The ignoramus > > > acts on only what he knows, but all that he knows. > > > The ignoramus may be saved, but the fool knows that he is doomed." > > > > Robert Halstead > > > _______________________________________________________________________________ > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where > > the Answers Are" > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where > > the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the > Answers Are"- Hide quoted text - > > - Show quoted text - _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
