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 | 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___
