Re: OT: Attachement Updation - File Contents Changed - Resolved ::)

2007-08-30 Thread Meenakshinathan 
Hi Lister,

I have resolved this subject by tracking the changes in the attachment
pool.

I wrote some custom code in the clientcore.js file to track the
attachment updation,deletion and modification. This custom code has a
varibale which holds the attachment label name and the action
performed by the user. A separate user defined function return that
varibale to remedy workflow. Using
window.F(fieldid).DoSet(functionname()) javascript code get the value
in the workflow form field and send the notification to the submiitter
of the request. Now iinstead of finding the file contents changed in
the attachment, i have traced all the actions performed in all the
attachments in the single attachment pool. The result will be
Attachment #1 - Modified
Attachment #2 - Added
Attachment #3 - Deleted and Added
Attachment # 4 - Deleted.

This will give a more information to the user on attachments.

Thanks for all your help ::)
Meenakshinathan



On Aug 4, 12:30 am, "L. J. Head" <[EMAIL PROTECTED]> wrote:
> :)that's why I was thinking that FooBar was a programming joke...hehehe
>
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
>
> [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
> Sent: Friday, August 03, 2007 12:29 PM
> To: [EMAIL PROTECTED]
> Subject: Re: OT: Attachement Updation - File Contents Changed
>
> Wikipedia.com also has a definition for most things.
> And that list does include fubar too. But I will not repeat the definition
> in polite company. :) So reader beware if you go looking for it.
>
> Maybe Kinetic Data can have a survey to find out if people think more of
> FooBar or Fubar when they think about ARS? ( It is time for some Friday
> Humor right? )
>
> Have a great weekend all.
>
> --
> Carey Matthew Black
> Remedy Skilled Professional (RSP)
> ARS = Action Request System(Remedy)
>
> Love, then teach
> Solution = People + Process + Tools
> Fast, Accurate, Cheap Pick two.
>
> On 8/3/07, Shellman, David <[EMAIL PROTECTED]> wrote:
> > **
>
> > From Wikipedia
> > "Foobar is a common placeholder name also referred to as metasyntactic
> > variable used in computer programming or computer related documentation."
>
> ___­_
> ___
> 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"

Re: OT: Attachement Updation - File Contents Changed

2007-08-03 Thread L. J. Head 
:)that's why I was thinking that FooBar was a programming joke...hehehe 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Friday, August 03, 2007 12:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: OT: Attachement Updation - File Contents Changed

Wikipedia.com also has a definition for most things.
And that list does include fubar too. But I will not repeat the definition
in polite company. :) So reader beware if you go looking for it.

Maybe Kinetic Data can have a survey to find out if people think more of
FooBar or Fubar when they think about ARS? ( It is time for some Friday
Humor right? )

Have a great weekend all.

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.



On 8/3/07, Shellman, David <[EMAIL PROTECTED]> wrote:
> **
>
> From Wikipedia
> "Foobar is a common placeholder name also referred to as metasyntactic 
> variable used in computer programming or computer related documentation."


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: OT: Attachement Updation - File Contents Changed

2007-08-03 Thread Carey Matthew Black 
Wikipedia.com also has a definition for most things.
And that list does include fubar too. But I will not repeat the
definition in polite company. :) So reader beware if you go looking
for it.

Maybe Kinetic Data can have a survey to find out if people think more
of FooBar or Fubar when they think about ARS? ( It is time for some
Friday Humor right? )

Have a great weekend all.

-- 
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.



On 8/3/07, Shellman, David <[EMAIL PROTECTED]> wrote:
> **
>
> From Wikipedia
> "Foobar is a common placeholder name also referred to as metasyntactic
> variable used in computer programming or computer related documentation."

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: OT: Attachement Updation - File Contents Changed

2007-08-03 Thread Bob Rowe 
At times, Wikipedia suffers from obfuscatory prolix where style is
concerned.

On 8/3/07, Shellman, David <[EMAIL PROTECTED]> wrote:
>
> ** From Wikipedia
> "Foobar is a common placeholder name also referred to as metasyntactic
> variable used in computer programming or computer related documentation."
>
>  --
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: OT: Attachement Updation - File Contents Changed

2007-08-03 Thread Shellman, David 
>From Wikipedia
"Foobar is a common placeholder name also referred to as metasyntactic
variable used in computer programming or computer related
documentation."



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of L. J. Head
Sent: Friday, August 03, 2007 11:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: OT: Attachement Updation - File Contents Changed


** 
Ah...well I'm familiar with FOO but I didn't know about FOOBAR...must be
a programmer jokesorry I didn't get it the first time...:)



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David
Sent: Friday, August 03, 2007 9:39 AM
To: arslist@ARSLIST.ORG
Subject: Re: OT: Attachement Updation - File Contents Changed


** 
Hugo had it correct.  He is referring to FOOBAR which is a reference
often used with perl and probably most of the older programming
languages.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of L. J. Head
Sent: Friday, August 03, 2007 11:19 AM
To: arslist@ARSLIST.ORG
Subject: Re: OT: Attachement Updation - File Contents Changed


** 
Entirely off of this topic...but it would be PERFORM-ACTION-FUBAR
 
:)



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Hugo Visser
Sent: Friday, August 03, 2007 2:31 AM
To: arslist@ARSLIST.ORG
Subject: Re: OT: Attachement Updation - File Contents Changed


** 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 = 'ATTACH16929'
 
 
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: arslist@ARSLIST.ORG
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 ,(i
am sure. but
it might bytes),. 

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 su

Re: OT: Attachement Updation - File Contents Changed

2007-08-03 Thread Rick Cook 
And FUBAR is a term coined by the military for...well, ask a vet.

Rick

On 8/3/07, Shellman, David <[EMAIL PROTECTED]> wrote:
>
> ** Hugo had it correct.  He is referring to FOOBAR which is a reference
> often used with perl and probably most of the older programming languages.
>
>  --
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *L. J. Head
> *Sent:* Friday, August 03, 2007 11:19 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: OT: Attachement Updation - File Contents Changed
>
>
> ** Entirely off of this topic...but it would be PERFORM-ACTION-FUBAR
>
> :)
>
>  --
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Hugo Visser
> *Sent:* Friday, August 03, 2007 2:31 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: OT: Attachement Updation - File Contents Changed
>
>
> ** 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 = 'ATTACH16929'
> >
> >
> > 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:* arslist@ARSLIST.ORG
> > *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 ,(i am sure. but
> > > it might bytes),.
> > >
> > > 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 at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: OT: Attachement Updation - File Contents Changed

2007-08-03 Thread L. J. Head 
Ah...well I'm familiar with FOO but I didn't know about FOOBAR...must be a
programmer jokesorry I didn't get it the first time...:)

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David
Sent: Friday, August 03, 2007 9:39 AM
To: arslist@ARSLIST.ORG
Subject: Re: OT: Attachement Updation - File Contents Changed


** 
Hugo had it correct.  He is referring to FOOBAR which is a reference often
used with perl and probably most of the older programming languages.

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of L. J. Head
Sent: Friday, August 03, 2007 11:19 AM
To: arslist@ARSLIST.ORG
Subject: Re: OT: Attachement Updation - File Contents Changed


** 
Entirely off of this topic...but it would be PERFORM-ACTION-FUBAR
 
:)

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Hugo Visser
Sent: Friday, August 03, 2007 2:31 AM
To: arslist@ARSLIST.ORG
Subject: Re: OT: Attachement Updation - File Contents Changed


** 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 = 'ATTACH16929'
 
 
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: arslist@ARSLIST.ORG
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 ,(i am sure. but
it might bytes),. 

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]
<mailto:[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

Re: OT: Attachement Updation - File Contents Changed

2007-08-03 Thread Shellman, David 
Hugo had it correct.  He is referring to FOOBAR which is a reference
often used with perl and probably most of the older programming
languages.



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of L. J. Head
Sent: Friday, August 03, 2007 11:19 AM
To: arslist@ARSLIST.ORG
Subject: Re: OT: Attachement Updation - File Contents Changed


** 
Entirely off of this topic...but it would be PERFORM-ACTION-FUBAR
 
:)



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Hugo Visser
Sent: Friday, August 03, 2007 2:31 AM
To: arslist@ARSLIST.ORG
Subject: Re: OT: Attachement Updation - File Contents Changed


** 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 = 'ATTACH16929'
 
 
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: arslist@ARSLIST.ORG
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 ,(i
am sure. but
it might bytes),. 

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]
<mailto:[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 clien

Re: OT: Attachement Updation - File Contents Changed

2007-08-03 Thread L. J. Head 
Entirely off of this topic...but it would be PERFORM-ACTION-FUBAR
 
:)

  _  

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Hugo Visser
Sent: Friday, August 03, 2007 2:31 AM
To: arslist@ARSLIST.ORG
Subject: Re: OT: Attachement Updation - File Contents Changed


** 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 = 'ATTACH16929'
 
 
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: arslist@ARSLIST.ORG
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 ,(i am sure. but
it might bytes),. 

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]
<mailto:[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 at www.arslist.org ARSlist:"Where the
Answers Are"



__20060125___This posting was submitted with HTML in
it___
__20060125___This posting was submitted with HTML in
it___ 


__20060125___This posting was submitted with HTML in
it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: OT: Attachement Updation - File Contents Changed

2007-08-03 Thread Kemes, Lisa 
Does anyone know if this is in an enhancement somewhere? 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Friday, August 03, 2007 9:39 AM
To: arslist@ARSLIST.ORG
Subject: Re: OT: Attachement Updation - File Contents Changed

Unfortunately Gain Focus does not work with attachment fields
(buggers!!).  I tried this as well.   

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Friday, August 03, 2007 8:39 AM
To: arslist@ARSLIST.ORG
Subject: Re: OT: Attachement Updation - File Contents Changed

Meenakshinathan ,

Maybe.
   An active link that fires on "Gain Focus" for each attachment field
could put a flag in a hidden field so that the right attachment field
could be used in the active link on the button. The flag might even be
the FieldID keyword. But I have not tested it and I do not know if "gain
focus" workflow works for attachment fields.

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.


On 8/3/07, Meenakshinathan <[EMAIL PROTECTED]> wrote:
> 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


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: OT: Attachement Updation - File Contents Changed

2007-08-03 Thread Kemes, Lisa 
Unfortunately Gain Focus does not work with attachment fields
(buggers!!).  I tried this as well.   

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Friday, August 03, 2007 8:39 AM
To: arslist@ARSLIST.ORG
Subject: Re: OT: Attachement Updation - File Contents Changed

Meenakshinathan ,

Maybe.
   An active link that fires on "Gain Focus" for each attachment field
could put a flag in a hidden field so that the right attachment field
could be used in the active link on the button. The flag might even be
the FieldID keyword. But I have not tested it and I do not know if "gain
focus" workflow works for attachment fields.

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.


On 8/3/07, Meenakshinathan <[EMAIL PROTECTED]> wrote:
> 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


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: OT: Attachement Updation - File Contents Changed

2007-08-03 Thread Carey Matthew Black 
Meenakshinathan ,

Maybe.
   An active link that fires on "Gain Focus" for each attachment field
could put a flag in a hidden field so that the right attachment field
could be used in the active link on the button. The flag might even be
the FieldID keyword. But I have not tested it and I do not know if
"gain focus" workflow works for attachment fields.

-- 
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.


On 8/3/07, Meenakshinathan <[EMAIL PROTECTED]> wrote:
> 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

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: OT: Attachement Updation - File Contents Changed

2007-08-03 Thread Meenakshinathan 
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 = 'ATTACH16929'
>
> > 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 ,(i am sure. but
> > > it might bytes),.
>
> > > 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
>
> > > ___­­
> > > > UN

Re: OT: Attachement Updation - File Contents Changed

2007-08-03 Thread Heider, Stephen 
I agree.  I would like to see this built in to ARS - obtaining the
checksum is very simple in a compiled language such as C or .Net.  This
info should also be available on a display only form/field (eg. before
it gets pushed back to the server).
 
Along with checksums, the file size should be obtainable on a display
only form/field.  As it is now a file has to be pushed back to the
server in a form to get the file size.  In active links I would like to
know if a file is too large [for the user, based on permissions] prior
to pushing it back to the server.
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Hugo Visser
Sent: Friday, August 03, 2007 4:31 AM
To: arslist@ARSLIST.ORG
Subject: Re: OT: Attachement Updation - File Contents Changed


** 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 = 'ATTACH16929'
 
 
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: arslist@ARSLIST.ORG
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 ,(i
am sure. but
it might bytes),. 

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]
<mailto:[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

Re: OT: Attachement Updation - File Contents Changed

2007-08-03 Thread Hugo Visser 
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 = 'ATTACH16929'
>
>
> 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:* arslist@ARSLIST.ORG
> *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 ,(i am sure. but
> > it might bytes),.
> >
> > 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 at www.arslist.org ARSlist:"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 at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: OT: Attachement Updation - File Contents Changed

2007-08-02 Thread Meenakshinathan 
Hi Dave,

Can you please explain some more in detail when you are getting free
time, how did you implement that?. Becoz my application is accessed
via web browser. Users are adding attachments via display only form
and i am having an audit form (Regular form) to store this values. In
the properties of attachment field, if i delete add label the
attachments buttons are invisible. After i create our own customized
button, i don't know how I could precede further. It would be great
help for me if you share this info.

Hi Carry,

Attachment field name on the display only form and in regular form is
"EPW Table"

4 attachments in this pool, their names are
Purchase Approval
Quote
Order Form
Deviation Form

This is identical both is display only and regular form

 Is it possible that your filter it trying to test for a data change
in
 the Attachment Pool instead of the correct attachment field? Yes, i
am testing the particular attachment is updated or not.

Please let me know if you need any further input on this.

Thanks,
Meenakshinathan


On Aug 2, 7:16 pm, "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 = 'ATTACH16929'
>
> 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 ,(i am
> sure. but
> it might bytes),.
>
> 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] 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 h

OT: Attachement Updation - File Contents Changed

2007-08-02 Thread Heider, Stephen 
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 = 'ATTACH16929'
 
 
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: arslist@ARSLIST.ORG
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 ,(i am
sure. but
it might bytes),. 

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 at www.arslist.org
ARSlist:"Where the Answers Are"



__20060125___This posting was submitted with HTML in
it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"