Re: OT: Attachement Updation - File Contents Changed - Resolved ::)
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: Attachement Updation
Kathy, Here is one approach but it will take a little time to implement... create a separate form to store all of the attachments. On the tickets use either a table field to display the attachments linked to the ticket or a dialog. I use a dialog here. Users click a button and a popup is displayed. From this popup users [based on permissions] can add, view, save to disk or delete attachments. The 'delete' option does not really delete the attachment record but marks it as disabled. There is a checkbox on the screen to show 'deleted' attachments. Each attachment on this dialog displays the user and the timestamp of when they added it and/or deleted it. This approach preserves the attachments and tracks who did what when. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris Sent: Tuesday, August 07, 2007 9:48 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation This has been a SOX requirement for us. When a Change has been approved based upon certain conditions, we do not want someone modifying the attachments later. Get a sneak peek of the all-new AOL.com http://discover.aol.com/memed/aolcom30tour/?ncid=AOLAOF0002000982 . __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Attachement Updation
Is there a way to keep the users from modifying the attachments? We have a similar issue. Our business requirement is that only the submitter can modify his/her own attachment. No other user should be able to modify an attachment or locking the attachment after the submission. ** Get a sneak peek of the all-new AOL at http://discover.aol.com/memed/aolcom30tour ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Attachement Updation
Hi Kathy, You can control access to attachments in two ways. One use permissions like any other field. Set the permissions for the Attachment Field to Submitter to allow only the Submitter to update the field. In the Attachment Pool you can adjust the functions that are displayed to prevenet people from saving to disk or deleting the attachment as well. See the attached document. Ed LeBlanc, RAC, ITIL Senior Consultant RIGID Systems, LLC 10440 little Patuxent Parkway Suite 200 Columbia, MD 21044 Phone 904-607-9387 Fax 410-715-0848 From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Tue 8/7/2007 2:56 AM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation ** Is there a way to keep the users from modifying the attachments? We have a similar issue. Our business requirement is that only the submitter can modify his/her own attachment. No other user should be able to modify an attachment or locking the attachment after the submission. Get a sneak peek of the all-new AOL.com http://discover.aol.com/memed/aolcom30tour/?ncid=AOLAOF0002000982 . __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Attachement Updation
I think he is looking to restrict it to the submitter of the attachment...not necessarily the submitter of the record -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ed LeBlanc Sent: Tuesday, August 07, 2007 10:00 AM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation Hi Kathy, You can control access to attachments in two ways. One use permissions like any other field. Set the permissions for the Attachment Field to Submitter to allow only the Submitter to update the field. In the Attachment Pool you can adjust the functions that are displayed to prevenet people from saving to disk or deleting the attachment as well. See the attached document. Ed LeBlanc, RAC, ITIL Senior Consultant RIGID Systems, LLC 10440 little Patuxent Parkway Suite 200 Columbia, MD 21044 Phone 904-607-9387 Fax 410-715-0848 From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Tue 8/7/2007 2:56 AM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation ** Is there a way to keep the users from modifying the attachments? We have a similar issue. Our business requirement is that only the submitter can modify his/her own attachment. No other user should be able to modify an attachment or locking the attachment after the submission. Get a sneak peek of the all-new AOL.com http://discover.aol.com/memed/aolcom30tour/?ncid=AOLAOF0002000982 . __20060125___This posting was submitted with HTML in it___ ___ 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: Attachement Updation
Even if you adjust the function so that saving to disk is not displayed, a user can still save the attachment to their hard drive if they select View right? Once the attachment is opened the customer could print it or save it. Is there anyway to allow the user to only View and that's it? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ed LeBlanc Sent: Tuesday, August 07, 2007 12:00 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation Hi Kathy, You can control access to attachments in two ways. One use permissions like any other field. Set the permissions for the Attachment Field to Submitter to allow only the Submitter to update the field. In the Attachment Pool you can adjust the functions that are displayed to prevenet people from saving to disk or deleting the attachment as well. See the attached document. Ed LeBlanc, RAC, ITIL Senior Consultant RIGID Systems, LLC 10440 little Patuxent Parkway Suite 200 Columbia, MD 21044 Phone 904-607-9387 Fax 410-715-0848 From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Tue 8/7/2007 2:56 AM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation ** Is there a way to keep the users from modifying the attachments? We have a similar issue. Our business requirement is that only the submitter can modify his/her own attachment. No other user should be able to modify an attachment or locking the attachment after the submission. Get a sneak peek of the all-new AOL.com http://discover.aol.com/memed/aolcom30tour/?ncid=AOLAOF0002000982 . __20060125___This posting was submitted with HTML in it___ ___ 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: Attachement Updation
I meant to say Display and not View. When a customer selects Display they will still be able to save it to their hard drive. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Tuesday, August 07, 2007 1:41 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation Even if you adjust the function so that saving to disk is not displayed, a user can still save the attachment to their hard drive if they select View right? Once the attachment is opened the customer could print it or save it. Is there anyway to allow the user to only View and that's it? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ed LeBlanc Sent: Tuesday, August 07, 2007 12:00 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation Hi Kathy, You can control access to attachments in two ways. One use permissions like any other field. Set the permissions for the Attachment Field to Submitter to allow only the Submitter to update the field. In the Attachment Pool you can adjust the functions that are displayed to prevenet people from saving to disk or deleting the attachment as well. See the attached document. Ed LeBlanc, RAC, ITIL Senior Consultant RIGID Systems, LLC 10440 little Patuxent Parkway Suite 200 Columbia, MD 21044 Phone 904-607-9387 Fax 410-715-0848 From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Tue 8/7/2007 2:56 AM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation ** Is there a way to keep the users from modifying the attachments? We have a similar issue. Our business requirement is that only the submitter can modify his/her own attachment. No other user should be able to modify an attachment or locking the attachment after the submission. Get a sneak peek of the all-new AOL.com http://discover.aol.com/memed/aolcom30tour/?ncid=AOLAOF0002000982 . __20060125___This posting was submitted with HTML in it___ ___ 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: Attachement Updation
As far as I know as long as an extenal program (i.e. Word, Excel, Acrobat, ...) is used to display the attachment then it would be a function of those programs to not allow saving to the user's local machine. Even if the user can save the attachment to their local machine, would preventing them from changing the one in Remedy meet your requirements? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Tuesday, August 07, 2007 12:47 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation I meant to say Display and not View. When a customer selects Display they will still be able to save it to their hard drive. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Tuesday, August 07, 2007 1:41 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation Even if you adjust the function so that saving to disk is not displayed, a user can still save the attachment to their hard drive if they select View right? Once the attachment is opened the customer could print it or save it. Is there anyway to allow the user to only View and that's it? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ed LeBlanc Sent: Tuesday, August 07, 2007 12:00 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation Hi Kathy, You can control access to attachments in two ways. One use permissions like any other field. Set the permissions for the Attachment Field to Submitter to allow only the Submitter to update the field. In the Attachment Pool you can adjust the functions that are displayed to prevenet people from saving to disk or deleting the attachment as well. See the attached document. Ed LeBlanc, RAC, ITIL Senior Consultant RIGID Systems, LLC 10440 little Patuxent Parkway Suite 200 Columbia, MD 21044 Phone 904-607-9387 Fax 410-715-0848 From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Tue 8/7/2007 2:56 AM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation Is there a way to keep the users from modifying the attachments? We have a similar issue. Our business requirement is that only the submitter can modify his/her own attachment. No other user should be able to modify an attachment or locking the attachment after the submission. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Attachement Updation
I can prevent the user from changing the one in Remedy with workflow, but my customers get SO confused when I tell them that a user with read access can download and print the attachment. They think read access should only be able to read the attachment and that's it. I keep telling them (and documenting and telling them again, and documenting some more) that once the attachment is opened, then the attachment is on their local machine and is opened with the external programs that are loaded on their local machine. They just can't seem to get this.and I don't think there is anything that I can do to stop these users from saving it or printing it. Am I correct? The attachments on the forms are contracts and can be very sensitive. They want the users to be able to read them, but not print them out and take them somewhere or save them to a different place. Ugh. Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Tuesday, August 07, 2007 2:07 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation As far as I know as long as an extenal program (i.e. Word, Excel, Acrobat, ...) is used to display the attachment then it would be a function of those programs to not allow saving to the user's local machine. Even if the user can save the attachment to their local machine, would preventing them from changing the one in Remedy meet your requirements? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Tuesday, August 07, 2007 12:47 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation I meant to say Display and not View. When a customer selects Display they will still be able to save it to their hard drive. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Tuesday, August 07, 2007 1:41 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation Even if you adjust the function so that saving to disk is not displayed, a user can still save the attachment to their hard drive if they select View right? Once the attachment is opened the customer could print it or save it. Is there anyway to allow the user to only View and that's it? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ed LeBlanc Sent: Tuesday, August 07, 2007 12:00 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation Hi Kathy, You can control access to attachments in two ways. One use permissions like any other field. Set the permissions for the Attachment Field to Submitter to allow only the Submitter to update the field. In the Attachment Pool you can adjust the functions that are displayed to prevenet people from saving to disk or deleting the attachment as well. See the attached document. Ed LeBlanc, RAC, ITIL Senior Consultant RIGID Systems, LLC 10440 little Patuxent Parkway Suite 200 Columbia, MD 21044 Phone 904-607-9387 Fax 410-715-0848 From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Tue 8/7/2007 2:56 AM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation Is there a way to keep the users from modifying the attachments? We have a similar issue. Our business requirement is that only the submitter can modify his/her own attachment. No other user should be able to modify an attachment or locking the attachment after the submission. ___ 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: Attachement Updation
Lisa, Not that I love these ideas... but maybe you can find some solution down one of these trails... ( The real issue appears to not be a technical problem. Rather the users do not like reality. :( ) What if you add a View button that actually launches a URL? That would _hopefully_ tell your client that it is the browsers job to keep the user from editing the content and not ARS's job. Or... as another thought... If you can know the types of files that the users will be attaching then maybe you can find a way to convert them into a PDF and store the PDF instead of the original attachment. Yes this takes some programming skills, but if you can convert the document into a format that the users can not write to then you should be ok too. Obviously if every user in the company has a full version of Adobe, or some other PDF editor then they might still be able to edit it too. However I find that a lot less likely that finding a way to tell MS Word, MS Excel, and every other document handler out there to open the file as read only too. -- 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/7/07, Kemes, Lisa [EMAIL PROTECTED] wrote: I can prevent the user from changing the one in Remedy with workflow, but my customers get SO confused when I tell them that a user with read access can download and print the attachment. They think read access should only be able to read the attachment and that's it. I keep telling them (and documenting and telling them again, and documenting some more) that once the attachment is opened, then the attachment is on their local machine and is opened with the external programs that are loaded on their local machine. They just can't seem to get this.and I don't think there is anything that I can do to stop these users from saving it or printing it. Am I correct? The attachments on the forms are contracts and can be very sensitive. They want the users to be able to read them, but not print them out and take them somewhere or save them to a different place. Ugh. Lisa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Attachement Updation
What about setting a view field to the contents of the attachment? -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Carey Matthew Black [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 08/07/2007 02:08 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Attachement Updation Lisa, Not that I love these ideas... but maybe you can find some solution down one of these trails... ( The real issue appears to not be a technical problem. Rather the users do not like reality. :( ) What if you add a View button that actually launches a URL? That would _hopefully_ tell your client that it is the browsers job to keep the user from editing the content and not ARS's job. Or... as another thought... If you can know the types of files that the users will be attaching then maybe you can find a way to convert them into a PDF and store the PDF instead of the original attachment. Yes this takes some programming skills, but if you can convert the document into a format that the users can not write to then you should be ok too. Obviously if every user in the company has a full version of Adobe, or some other PDF editor then they might still be able to edit it too. However I find that a lot less likely that finding a way to tell MS Word, MS Excel, and every other document handler out there to open the file as read only too. -- 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/7/07, Kemes, Lisa [EMAIL PROTECTED] wrote: I can prevent the user from changing the one in Remedy with workflow, but my customers get SO confused when I tell them that a user with read access can download and print the attachment. They think read access should only be able to read the attachment and that's it. I keep telling them (and documenting and telling them again, and documenting some more) that once the attachment is opened, then the attachment is on their local machine and is opened with the external programs that are loaded on their local machine. They just can't seem to get this.and I don't think there is anything that I can do to stop these users from saving it or printing it. Am I correct? The attachments on the forms are contracts and can be very sensitive. They want the users to be able to read them, but not print them out and take them somewhere or save them to a different place. Ugh. Lisa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Attachement Updation
It's not a problem with editing, it's the problem of being able to print or saving the doc to their hard drives. I added workflow that a user with read access cannot add or overwrite attachments. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Tuesday, August 07, 2007 3:09 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation Lisa, Not that I love these ideas... but maybe you can find some solution down one of these trails... ( The real issue appears to not be a technical problem. Rather the users do not like reality. :( ) What if you add a View button that actually launches a URL? That would _hopefully_ tell your client that it is the browsers job to keep the user from editing the content and not ARS's job. Or... as another thought... If you can know the types of files that the users will be attaching then maybe you can find a way to convert them into a PDF and store the PDF instead of the original attachment. Yes this takes some programming skills, but if you can convert the document into a format that the users can not write to then you should be ok too. Obviously if every user in the company has a full version of Adobe, or some other PDF editor then they might still be able to edit it too. However I find that a lot less likely that finding a way to tell MS Word, MS Excel, and every other document handler out there to open the file as read only too. -- 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/7/07, Kemes, Lisa [EMAIL PROTECTED] wrote: I can prevent the user from changing the one in Remedy with workflow, but my customers get SO confused when I tell them that a user with read access can download and print the attachment. They think read access should only be able to read the attachment and that's it. I keep telling them (and documenting and telling them again, and documenting some more) that once the attachment is opened, then the attachment is on their local machine and is opened with the external programs that are loaded on their local machine. They just can't seem to get this.and I don't think there is anything that I can do to stop these users from saving it or printing it. Am I correct? The attachments on the forms are contracts and can be very sensitive. They want the users to be able to read them, but not print them out and take them somewhere or save them to a different place. Ugh. Lisa ___ 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: Attachement Updation
I just tried this. I did a set fields action to set View Field with the value of $First Attachment$. That's not working. Should I set it with the value of the field id? Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Tuesday, August 07, 2007 3:19 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation What about setting a view field to the contents of the attachment? -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Carey Matthew Black [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 08/07/2007 02:08 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Attachement Updation Lisa, Not that I love these ideas... but maybe you can find some solution down one of these trails... ( The real issue appears to not be a technical problem. Rather the users do not like reality. :( ) What if you add a View button that actually launches a URL? That would _hopefully_ tell your client that it is the browsers job to keep the user from editing the content and not ARS's job. Or... as another thought... If you can know the types of files that the users will be attaching then maybe you can find a way to convert them into a PDF and store the PDF instead of the original attachment. Yes this takes some programming skills, but if you can convert the document into a format that the users can not write to then you should be ok too. Obviously if every user in the company has a full version of Adobe, or some other PDF editor then they might still be able to edit it too. However I find that a lot less likely that finding a way to tell MS Word, MS Excel, and every other document handler out there to open the file as read only too. -- 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/7/07, Kemes, Lisa [EMAIL PROTECTED] wrote: I can prevent the user from changing the one in Remedy with workflow, but my customers get SO confused when I tell them that a user with read access can download and print the attachment. They think read access should only be able to read the attachment and that's it. I keep telling them (and documenting and telling them again, and documenting some more) that once the attachment is opened, then the attachment is on their local machine and is opened with the external programs that are loaded on their local machine. They just can't seem to get this.and I don't think there is anything that I can do to stop these users from saving it or printing it. Am I correct? The attachments on the forms are contracts and can be very sensitive. They want the users to be able to read them, but not print them out and take them somewhere or save them to a different place. Ugh. Lisa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. ___ 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: Attachement Updation
A View field is still using the associated application so usually a Right Click would still allow printing and saving. If the Documents were saved as Adobe PDF then you might be able to tell the creator to set the options inside the PDF to not allow printing but even Adobe Reader can save a copy of the document locally. Microsoft used to have viewer(s) for each of it's type of documents, but I'm not sure if they would stop printing and saving locally. FYI: As long as it is displayed on the screen a person can capture it to send it to the printer using Alt-PrintScreen. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Tuesday, August 07, 2007 2:09 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation Lisa, Not that I love these ideas... but maybe you can find some solution down one of these trails... ( The real issue appears to not be a technical problem. Rather the users do not like reality. :( ) What if you add a View button that actually launches a URL? That would _hopefully_ tell your client that it is the browsers job to keep the user from editing the content and not ARS's job. Or... as another thought... If you can know the types of files that the users will be attaching then maybe you can find a way to convert them into a PDF and store the PDF instead of the original attachment. Yes this takes some programming skills, but if you can convert the document into a format that the users can not write to then you should be ok too. Obviously if every user in the company has a full version of Adobe, or some other PDF editor then they might still be able to edit it too. However I find that a lot less likely that finding a way to tell MS Word, MS Excel, and every other document handler out there to open the file as read only too. -- 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/7/07, Kemes, Lisa [EMAIL PROTECTED] wrote: I can prevent the user from changing the one in Remedy with workflow, but my customers get SO confused when I tell them that a user with read access can download and print the attachment. They think read access should only be able to read the attachment and that's it. I keep telling them (and documenting and telling them again, and documenting some more) that once the attachment is opened, then the attachment is on their local machine and is opened with the external programs that are loaded on their local machine. They just can't seem to get this.and I don't think there is anything that I can do to stop these users from saving it or printing it. Am I correct? The attachments on the forms are contracts and can be very sensitive. They want the users to be able to read them, but not print them out and take them somewhere or save them to a different place. Ugh. Lisa ___ 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: Attachement Updation
FYI: As long as it is displayed on the screen a person can capture it to send it to the printer using Alt-PrintScreen. Fred, this is very true as well. They could also paste the capture screen into a Word Document. I might bring this up if they continue to make this an issue. Thanks! Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Tuesday, August 07, 2007 4:15 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation A View field is still using the associated application so usually a Right Click would still allow printing and saving. If the Documents were saved as Adobe PDF then you might be able to tell the creator to set the options inside the PDF to not allow printing but even Adobe Reader can save a copy of the document locally. Microsoft used to have viewer(s) for each of it's type of documents, but I'm not sure if they would stop printing and saving locally. FYI: As long as it is displayed on the screen a person can capture it to send it to the printer using Alt-PrintScreen. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Tuesday, August 07, 2007 2:09 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation Lisa, Not that I love these ideas... but maybe you can find some solution down one of these trails... ( The real issue appears to not be a technical problem. Rather the users do not like reality. :( ) What if you add a View button that actually launches a URL? That would _hopefully_ tell your client that it is the browsers job to keep the user from editing the content and not ARS's job. Or... as another thought... If you can know the types of files that the users will be attaching then maybe you can find a way to convert them into a PDF and store the PDF instead of the original attachment. Yes this takes some programming skills, but if you can convert the document into a format that the users can not write to then you should be ok too. Obviously if every user in the company has a full version of Adobe, or some other PDF editor then they might still be able to edit it too. However I find that a lot less likely that finding a way to tell MS Word, MS Excel, and every other document handler out there to open the file as read only too. -- 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/7/07, Kemes, Lisa [EMAIL PROTECTED] wrote: I can prevent the user from changing the one in Remedy with workflow, but my customers get SO confused when I tell them that a user with read access can download and print the attachment. They think read access should only be able to read the attachment and that's it. I keep telling them (and documenting and telling them again, and documenting some more) that once the attachment is opened, then the attachment is on their local machine and is opened with the external programs that are loaded on their local machine. They just can't seem to get this.and I don't think there is anything that I can do to stop these users from saving it or printing it. Am I correct? The attachments on the forms are contracts and can be very sensitive. They want the users to be able to read them, but not print them out and take them somewhere or save them to a different place. Ugh. Lisa ___ 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
FW: Attachement Updation
How about converting everything to 3D, which then requires the red/blue glasses :) http://heuristicresearch.com/media/convertto3d.html Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Tuesday, August 07, 2007 4:21 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation FYI: As long as it is displayed on the screen a person can capture it to send it to the printer using Alt-PrintScreen. Fred, this is very true as well. They could also paste the capture screen into a Word Document. I might bring this up if they continue to make this an issue. Thanks! Lisa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are image001.jpg
Re: Attachement Updation
But you could put the view field behind a transparent box... :-) And preventing printscreen, well. Good luck with that. :P -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Grooms, Frederick W [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 08/07/2007 03:15 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Attachement Updation A View field is still using the associated application so usually a Right Click would still allow printing and saving. If the Documents were saved as Adobe PDF then you might be able to tell the creator to set the options inside the PDF to not allow printing but even Adobe Reader can save a copy of the document locally. Microsoft used to have viewer(s) for each of it's type of documents, but I'm not sure if they would stop printing and saving locally. FYI: As long as it is displayed on the screen a person can capture it to send it to the printer using Alt-PrintScreen. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Tuesday, August 07, 2007 2:09 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation Lisa, Not that I love these ideas... but maybe you can find some solution down one of these trails... ( The real issue appears to not be a technical problem. Rather the users do not like reality. :( ) What if you add a View button that actually launches a URL? That would _hopefully_ tell your client that it is the browsers job to keep the user from editing the content and not ARS's job. Or... as another thought... If you can know the types of files that the users will be attaching then maybe you can find a way to convert them into a PDF and store the PDF instead of the original attachment. Yes this takes some programming skills, but if you can convert the document into a format that the users can not write to then you should be ok too. Obviously if every user in the company has a full version of Adobe, or some other PDF editor then they might still be able to edit it too. However I find that a lot less likely that finding a way to tell MS Word, MS Excel, and every other document handler out there to open the file as read only too. -- 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/7/07, Kemes, Lisa [EMAIL PROTECTED] wrote: I can prevent the user from changing the one in Remedy with workflow, but my customers get SO confused when I tell them that a user with read access can download and print the attachment. They think read access should only be able to read the attachment and that's it. I keep telling them (and documenting and telling them again, and documenting some more) that once the attachment is opened, then the attachment is on their local machine and is opened with the external programs that are loaded on their local machine. They just can't seem to get this.and I don't think there is anything that I can do to stop these users from saving it or printing it. Am I correct? The attachments on the forms are contracts and can be very sensitive. They want the users to be able to read them, but not print them out and take them somewhere or save them to a different place. Ugh. Lisa ___ 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 CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Attachement Updation
This has been a SOX requirement for us. When a Change has been approved based upon certain conditions, we do not want someone modifying the attachments later. ** Get a sneak peek of the all-new AOL at http://discover.aol.com/memed/aolcom30tour ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
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
Re: OT: Attachement Updation - File Contents Changed
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
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
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 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] 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
Re: OT: Attachement Updation - File Contents Changed
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 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 at www.arslist.org ARSlist:Where the Answers Are
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 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] 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
Re: OT: Attachement Updation - File Contents Changed
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 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
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 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] 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
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 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
Re: OT: Attachement Updation - File Contents Changed
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
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 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 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: Attachement Updation - File Contents Changed
Just a thought, but instead of attaching the files directly to the request you are on, what if it was a child form, with a Submit-Only, single field, attachment pool? This way, to upload a new attachment, a new child record has to be created, and you know who when did it. This would also keep historical records, you could compare the file at each and every stage/change that took place, or if you don't need this, you could simply delete the previous records. I've not worked through this completely, so I'm not sure what complications might arise (though, immediately I can think of the fact users will have to open the child record before they can get to the attachment) . HTH Shawn Stonequist EMNS, Inc. _ 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] 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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: OT: Attachement Updation - File Contents Changed
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 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] 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
Re: Attachement Updation - File Contents Changed
Shawn, There is a free utility available on ARS Wiki that will assist in setting up and populating an Attachments form like you describe - ARS_CreateAttachmentsForm. http://arswiki.org/projects/dotnetutil Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist Sent: Friday, August 03, 2007 8:19 AM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation - File Contents Changed ** Just a thought, but instead of attaching the files directly to the request you are on, what if it was a child form, with a Submit-Only, single field, attachment pool? This way, to upload a new attachment, a new child record has to be created, and you know who when did it. This would also keep historical records, you could compare the file at each and every stage/change that took place, or if you don't need this, you could simply delete the previous records. I've not worked through this completely, so I'm not sure what complications might arise (though, immediately I can think of the fact users will have to open the child record before they can get to the attachment) . HTH Shawn Stonequist EMNS, Inc. 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] 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
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
:)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: Attachement Updation
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 at www.arslist.org ARSlist:Where the Answers Are
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 at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
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
Re: Attachement Updation
Meenakshinathan, Just to verify ( Because Attachments in ARS are a special thing when compared to the other ARS data types.) There is an attachment Pool field named What on this form? How many attachment fields are in this pool and what are their names? Is it possible that your filter it trying to test for a data change in the Attachment Pool instead of the correct attachment field? -- 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/2/07, Meenakshinathan [EMAIL PROTECTED] wrote: 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Attachement Updation
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
OT: Attachement Updation - File Contents Changed
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 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] 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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: OT: Attachement Updation - File Contents Changed
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 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]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
Re: Attachement Updation
I had to create a tmp field and push the name of the attachment to this temp field (if the tmp field was empty). Then if the user tried to overwrite this attachment, I was able to check if tmpfield = new attachment, if it did not match then I would not let them overwrite the field. I would make the user delete the attachment first, click on save and then add a new attachment. Then I would fire a push fields in my filter if (NOT ( 'TR.First Attachment' = $NULL$ )) AND ( 'First Attachment' != 'DB.First Attachment'). (this is where you could send an email) Other than using buttons as well like Dave said, there is no easy way to capture an overwrite of an attachment. I'm not sure why, but it's a pain! Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Thursday, August 02, 2007 8:17 AM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation Meenakshinathan, Just to verify ( Because Attachments in ARS are a special thing when compared to the other ARS data types.) There is an attachment Pool field named What on this form? How many attachment fields are in this pool and what are their names? Is it possible that your filter it trying to test for a data change in the Attachment Pool instead of the correct attachment field? -- 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/2/07, Meenakshinathan [EMAIL PROTECTED] wrote: 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 ___ 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: Attachement Updation
Also, This will only work if the name of the file changes, I'm not looking to see if the data inside of the attachment has changed... Lisa -Original Message- From: Kemes, Lisa Sent: Thursday, August 02, 2007 4:01 PM To: 'arslist@ARSLIST.ORG' Subject: RE: Attachement Updation I had to create a tmp field and push the name of the attachment to this temp field (if the tmp field was empty). Then if the user tried to overwrite this attachment, I was able to check if tmpfield = new attachment, if it did not match then I would not let them overwrite the field. I would make the user delete the attachment first, click on save and then add a new attachment. Then I would fire a push fields in my filter if (NOT ( 'TR.First Attachment' = $NULL$ )) AND ( 'First Attachment' != 'DB.First Attachment'). (this is where you could send an email) Other than using buttons as well like Dave said, there is no easy way to capture an overwrite of an attachment. I'm not sure why, but it's a pain! Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Thursday, August 02, 2007 8:17 AM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation Meenakshinathan, Just to verify ( Because Attachments in ARS are a special thing when compared to the other ARS data types.) There is an attachment Pool field named What on this form? How many attachment fields are in this pool and what are their names? Is it possible that your filter it trying to test for a data change in the Attachment Pool instead of the correct attachment field? -- 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/2/07, Meenakshinathan [EMAIL PROTECTED] wrote: 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 ___ 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
Attachement Updation
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: Attachement Updation
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 -- 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 at www.arslist.org ARSlist:Where the Answers Are