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: [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___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
