Scott, That's interesting. I did not realize you could directly create a file in a Filter. This is good know. Thanks.
Regarding renaming attachments, another option that may be useful in certain circumstances is to rename it in the table. There is a thread from Aug 2005 entitled "PERFORM-ACTION-RENAME-ATTACHMENT" that includes a stored procedure to do this (SQL Server 2000). Stephen -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, August 16, 2006 3:57 PM To: [email protected] Subject: Re: Putting a Character Field into an Attachment Field Roy, There are many ways to do this, but I usually prefer to use the Notify action in a filter. Using the Notify action you can specify "Other" as the mechanism and then provide a number in the "Other Code" field. In the Notify text reference your long character field. This will create a file in your <server path>/arserver/db directory with the Other Code entry as the name and an extension of .arm. So if the Other Code field were 50, the final name would be 50.arm. Because notify actions occur in Phase 3, it's best to end this filter with `! to execute in Phase 2. Since you know what the file is going to be named and where it's stored, you can then run another filter executing a run process or a set fields $PROCESS$ action to attach the file. Myself, I would execute a dos command in a run process first to rename the file and make it meaningful in the attachment field then execute another at the end of the process to delete the field. Others may have easier or more economical ways of doing this. Scott Parrish IT Prophets Original Message: ----------------- From: Ashcraft, Roy W. [EMAIL PROTECTED] Date: Wed, 16 Aug 2006 12:34:14 -0700 To: [email protected] Subject: Putting a Character Field into an Attachment Field Racking my brain here, fruitless, I know. On submit/modify of a record, I need to take the contents of a long character field on the current record (transactional value) and place them into an attachment field as a text file, in filter actions, preferably. In active links, using the Open Window action, you can report to file, however, this will generate a report of the db values of the field, not the current transactional values. Will this require an external script, or is there something that can be done with Remedy workflow to accomplish this? Server is Win2k3, ARS v6.3 patch 17. Database is SQL 2k SP4. Any ideas would be appreciated. Thanks, Roy Roy Ashcraft Systems Analyst SAIC [EMAIL PROTECTED] (402) 293-5218 ________________________________________________________________________ ____ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org -------------------------------------------------------------------- mail2web - Check your email from the web at http://mail2web.com/ . ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
