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
