I should correct myself - they are referenceable in
the Run If, but not in the sub field associated with the Gain/Lose focus
actions.
Rick
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, August 31, 2006 12:26 PM
To: [email protected]
Subject: Re: Attachment Format Conversion?
Do You
mean slots in an attachmentspool? Yes, I have wf checking if 'file1'!= $NULL$
for example, works. /L ars
__20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___-----Original Message-----**
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Grooms, Frederick W
Sent: Thursday, August 31, 2006 9:19 PM
To: [email protected]
Subject: Re: Attachment Format Conversion?You can reference the individual attachment fields in the Run-If
**
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick cook
Sent: Thursday, August 31, 2006 2:12 PM
To: [email protected]
Subject: Re: Attachment Format Conversion?The only problem from a workflow perspective is that individual attachment fields can't be referenced in Run If qualifications. But that's kind of a big problem. If you went to an attachment form methodology, I bet you would have more flexibility, and I think it might work that way. You could automate the process of opening the attachment, create an Excel macro that did the conversion, and then save the new one. I haven't done it, but I think it could work.Comments?Rick
**
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lori Gumbiner
Sent: Thursday, August 31, 2006 10:52 AM
To: [email protected]
Subject: Re: Attachment Format Conversion?
The open, detach, save, reattach process is viewed as labor-intensive to use, and would require training and support..
The thought is that a slick button would solve several concerns.
*Lori
*************************************
Lori Gumbiner
IT Systems Architecture - Process Automation Initiatives
Walgreens Co.
847.914.5796
Rick cook <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" <[email protected]>08/31/2006 12:24 PM
Please respond to arslist
To: [email protected]
cc:
Subject: Re: Attachment Format Conversion?
**
Why not just allow the users to open it, save it locally as a .csv, and reattach the .csv?
Rick (at RUG after all)
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lori Gumbiner
Sent: Thursday, August 31, 2006 9:15 AM
To: [email protected]
Subject: Attachment Format Conversion?
**
Hi guys! the WAG Remedy team all stayed home from "RUG in a BUG" this year, too.
And, we are trying to do a nifty trick:
User opens a record with an attachment file that is an Excel worksheet, formatted *.xls
Can we give the User a button on the Remedy form that will convert that attachment to *.csv format?
We have brainstormed all sorts of ideas (some feasible, some wishful thinking) , e.g. calling a converter utility, or using OLE to run a macro in the xls to save it as csv.
Thought we'd bring the List's creativity to the problem. Any ideas?
Oh, and any utility needs to be credible and free.
ARS System Specs:
Remedy: 6.3, patch 17
SunOS 5.9
Oracle 9.2.0.4.0
*Lori
*************************************
Lori Gumbiner
IT Systems Architecture - Process Automation Initiatives
Walgreens Co.
847.914.5796 __20060125_______________________This posting was submitted with HTML in it___
__20060125_______________________This posting was submitted with HTML in it___
__20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___
