Roy, I am not on a windows server so have not tested this on, but have done this on unix. The tricky part is you want only the text entered as part of the update rather than whats already been saved (if this is a SET operation). Not sure how you would just take the transaction value unless you saved whatever the user types into a seperate field and appended to the Long char field later.
For creating the file you could try using the simple redirect operators in DOS such as echo "Hello" > c:\temp\temp.txt in a run process action of a filter with a low exec order. Make sure you disable filter phase using the `! at the end of the filter name. This would look like echo $fieldname$ > <file-name> I am assuming that DOS will create the file if it doesn't already exist without throwing an error. Then have a second filter that runs at exec order 999 which does a Run Process with the PERFORM-ACTION-ADD-ATTACHMENT <field-id> <file-name>. (You already know what the file name and path is.) I have done this on UNIX and have not had any issues with this approach. Hope Windows is as giving as UNIX is :-) Regards, Saby > Original Message: > ----------------- > From: Ashcraft, Roy W. [EMAIL PROTECTED] > Date: Wed, 16 Aug 2006 12:34:14 -0700 > To: arslist@ARSLIST.ORG > 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 > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
