I don't know if it would work but there is always the option of using the Notify Action. If you change the Mechanism to Other and put in an Other Code > 4 it will put the notify output in a file on the server. I use the Perl Plugin to do something silimiar. In your case I think the filter would look something like: Action 1: Set Fields Set DO Character Field with Perl code to save field to file Set DO Character Field with name of perl array used in perl code Set DO Character Field with diary field (This will translate the dates) Action 2: Set Fields calling Perl Plugin passing values as above and returning file name of created file Action 3: Set Fields calling $PROCESS$ PERFORM-ACTION-ADD-ATTACHMENT field_ID "file_name" into a DO field Action 4: Run Process to delete file Fred
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Wednesday, July 16, 2008 4:46 PM To: arslist@ARSLIST.ORG Subject: Re: Send a Diary Field as an attachment. ** Jason, I also run simple .csv reports. I was looking for a way to just dump one field from one record into one attachment without the runmacro and the batch file for cleaning the directory. I was concerned about putting a large diary field into the body of an email so I thought I'd use the Attachment. I guess I'll just have to grab that old set of escalations and make them filters. Thanks, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason Miller Sent: Wednesday, July 16, 2008 4:48 PM To: arslist@ARSLIST.ORG Subject: Re: Send a Diary Field as an attachment. ** Hi John, That sounds like pretty good solution. I have done something similar to automate emailing some basic reports (csv files) natively with only Remedy and OS commands. One note on your clean up, running an PERFORM-ACTION-DELETE-ATTACHMENT will not delete an attachment on the harddrive, only out of a Remedy attachment field. You can either do a run process that like "RUN PROCESS del <path>\<file.txt>" or create a small batch file that you can call from a filter and pass the file name to it. Another option would be to use Crystal Reports if you have them. Crystal Server can send various format attachments (pdf, doc, xls) on a schedule or on an event (but it takes a kind of hokey work around to make events work). If you have Crystal Reports but not Crystal Server you can use CRexporter (http://www.rainforestnet.com/crexport-download.htm). It is a free tool that can run a Crystal reports, export it in various formats. You can easly call it from a filter to run the report and email it. HTH, Jason On Tue, Jul 15, 2008 at 1:50 PM, Reiser, John J <[EMAIL PROTECTED]> wrote: Hello Listers, ARS 6.3 Patch 21 MS SQL Server 2000 MS Windows 2000 Am I missing something basic? I have been asked to forward the Call Log (Diary Field) along with a notification email as an attachment. The only way I can think of doing this is to 1. Use a RUN PROCESS runmacro.exe which runs a report to save the diary field to a text file. 2. Use a RUN PROCESS PERFORM-ACTION-ADD-ATTACHMENT <attachment fieldID> <Path>\<File.txt> 3. Use the Attachment field in the filter action that loads and sends a message from the AR System Email Messages form. It doesn't need to be in one filter. It just has to be transparent to the user and clean up after itself. RUN PROCESS PERFORM-ACTION-DELETE-ATTACHMENT and delete the <path>\<file.txt> Am I on the right path or do it follow the twisty path into the gnarled woods. go west Thanks, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"