Sorry to take the original discussion off on a tangent, but do you know if runmacro can be used to output to any other format that isn't specified on the reports? My idea was to create a .ics file (iCalendar, which outlook can use), but I couldn't find a good way to create a plain text file with no formatting in ARS. Specifically, if I were to output the "report" as an ICS file it would still have the field name at the beginning of the file. I'd like to avoid that if possible.
Any suggestions? Thanks, Shawn Pierson 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]<mailto:[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<http://www.arslist.org> Platinum Sponsor: www.rmsportal.com<http://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___ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
