Way back when the world was young I submitted a suggestion to make the database diary field content readable to workflow. I never heard anything about it. Maybe if more people requested it it might happen. Or maybe there is some reason why it isn't a good idea.
Dwayne Martin James Madison University ---- Original message ---- >Date: Wed, 16 Jul 2008 17:46:00 -0400 >From: "Reiser, John J" <[EMAIL PROTECTED]> >Subject: Re: Send a Diary Field as an attachment. >To: arslist@ARSLIST.ORG > > ** > 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"
