Shawn, Two comments...
A) You should be able to remove the field label from an *.rpt output file by defining the report definition without a string for the label of the field. or for even more flexibility... B) You also could opt to output the data in XML format then post process the XML into whatever form you want it in via some other command line utility. ( Like using XSLT for example.) HTH -- 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 Thu, Jul 17, 2008 at 9:02 AM, Pierson, Shawn <[EMAIL PROTECTED]> wrote: > ** > > 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: [email protected] > 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: [email protected] > 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___ > > Private and confidential as detailed here. If you cannot access hyperlink, > please e-mail sender. > __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"
