Thanks for all posters for giving the valuable inputs. One more question on this.
I am trying the implementation of Dave's and Lisa' suggestion I have created one button called "Add", after click that button i set an run process command action PERFORM-ACTION-ADD-ATTACHMENT As per remedy, if we pass the attachment field ID it takes which pool is empty first and add the attachment in it. If I pass the attachment name field id it adds the attachment on it. Is there any possibility to add attachment to what i have selected at that time? (ie) Is there any way to find which attachment field that i selected currently? Assume that i am having 4 attachments in my attachment pool. Thanks, Meenakshinathan On Aug 3, 1:30 pm, Hugo Visser <[EMAIL PROTECTED]> wrote: > Stephen, > > That's very clever, thanks for sharing :) Maybe BMC should put some kind of > PERFORM-ACTION-FOOBAR to do this in a DB independent way. > > Hugo > > On 8/2/07, Heider, Stephen <[EMAIL PROTECTED]> wrote: > > > > > > > > > ** Hugo, > > > Your post got me thinking: How can you determine if the file contents have > > changed? I have wanted to create something like this for a while... so I > > just wrote this SQL Server 2000 function that returns the checksum of an > > attachment field (actually any field of Image data type. The current and > > new values could be compared to see if it changed. You can also use this to > > find duplicates in the attachment fields in your system. > > > CREATE FUNCTION dbo.udf_GetImageChecksum > > ( > > @ImageField IMAGE > > ) > > RETURNS INT > > AS > > BEGIN > > DECLARE @Len BIGINT, > > @Pos BIGINT, > > @CheckSum VARCHAR(8000) > > > SET @Len = DATALENGTH(@ImageField) > > SET @Pos = 1 > > SET @CheckSum = '' > > > WHILE @Pos < @Len > > BEGIN > > > SET @CheckSum = @CheckSum + CONVERT(VARCHAR, > > BINARY_CHECKSUM(SUBSTRING(@ImageField, @Pos, 8000))) > > > IF LEN(@CheckSum) > 7900 > > SET @CheckSum = CONVERT(VARCHAR, CHECKSUM(@CheckSum)) > > > SET @Pos = @Pos + 8000 > > END > > > RETURN CHECKSUM(@CheckSum) > > END > > > In a Set Fields SQL command: > > > SELECT dbo.udf_GetImageChecksum(c536880912) > > FROM b611c536880912 > > WHERE entryId = 'ATTACH000016929' > > > HTH someone. > > > Stephen > > > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > > [EMAIL PROTECTED] *On Behalf Of *Hugo Visser > > *Sent:* Thursday, August 02, 2007 5:15 AM > > *To:* [EMAIL PROTECTED] > > *Subject:* Re: Attachement Updation > > > ** 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" > > > __20060125_______________________This posting was submitted with HTML in > > it___ > > __20060125_______________________This posting was submitted with HTML in > > it___ > > _______________________________________________________________________________ > 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"