Maybe if instead of: to-file: x:\remedy\filename$TIMESTAMP$.csv you use
to-file: x:\remedy\filename$Tm$.csv and pass the parameter Tm set to $TIMESTAMP$ then this might work? Cheers Peter > Thanks Peter and others, > > I tried modifying the macro with $TIMESTAMP$, but when the report was > produced it had report$TIMESTAMP$ as the name. > > I will try the other suggestion. > > > > Again, thanks to all. > > > > ________________________________ > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of P Romain ARSlist > Sent: Tuesday, September 02, 2008 4:29 PM > To: arslist@ARSLIST.ORG > Subject: Re: Automated Reports > > > > If you can alter the macros then try adding the timestamp to the > 'to-file' parameter, eg to-file: x:\remedy\filename$TIMESTAMP$.csv > > > > If you don't like the timestamp format you could build the path and > filename in a separate field and pass it to the macro as a parameter. > > Then the to-file parameter would be, eg to-file: $Filename$ where the > Filename variable is set to, for example, x:\remedy\filename > 20080902.csv > > > > Cheers > > > > Peter > > > > ________________________________ > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W > Sent: 02 September 2008 20:29 > To: arslist@ARSLIST.ORG > Subject: Re: Automated Reports > > > > Another way would be to rename the file after generating. This way you > would not have to change any of your macros. You can generate date info > using Set Fields and the MONTH, DAY, and YEAR functions and pass them > into a routine that renames the output file. > > > > ________________________________ > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing > Sent: Tuesday, September 02, 2008 2:21 PM > To: arslist@ARSLIST.ORG > Subject: Re: Automated Reports > > I have done this type of thing via perl scripting...create your > 'template' macro and have it contain a unique value for the report > name...then have perl generate the timestamp that you are looking > for...make a copy of the template macro, edit the copy to have a > different report name, then execute runmacro with the new macro instead > of the template...then you can delete today's macro file. > > > > ________________________________ > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Randy Simon > Sent: Tuesday, September 02, 2008 1:11 PM > To: arslist@ARSLIST.ORG > Subject: Automated Reports > > I run a report each day via macros and escalations. > > The report has a name and it overwrites the previous report every day. > > Is there a way to have the name of the report end in something like > TIMESTAMP so it does not overwrite the older report? > > > > CSS 5.0 > > ARS 6.0 > > SQL 2005 > > > > Randy Simon > > Remedy Admin > > Online Resources Corporation > > ________________________________________________________________________ > > STATEMENT OF CONFIDENTIALITY: > > The information contained in this message or any attachments to this > message are intended only for the person(s) or entity to which it is > addressed and may contain confidential and/or privileged material as > well as being protected from disclosure. > Any review, retransmission, dissemination or other use of, or taking of > any action in reliance upon, this information by persons or entities > other than the intended recipient is strictly prohibited. If you > received this in error, please contact us immediately and delete the > material from any computer. > > Thank You. > > > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the > Answers Are" html___ > > ________________________________________________________________________ > > STATEMENT OF CONFIDENTIALITY: > > The information contained in this message or any attachments to this > message are intended only for the person(s) or entity to which it is > addressed and may contain confidential and/or privileged material as well > as being protected from disclosure. > Any review, retransmission, dissemination or other use of, or taking of > any action in reliance upon, this information by persons or entities other > than the intended recipient is strictly prohibited. If you received this > in error, please contact us immediately and delete the material from any > computer. > > Thank You. > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
