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"

Reply via email to