Lori,
You could program something that would run on the
server and create the csv. I wrote something like that here, except it
takes a csv file and converts it to an Excel spreadsheet:
The user clicks a button to generate a tab-delimited
report, the report is pushed to a command form as an attachment. A filter
runs the VB.Net application which performs the conversion, the filter
then attaches the converted file to the record. Back at the client,
the next command in the active link retrieves the file from the command
form. The user can then save, open or email the file.
VB.Net wouldn't work on your SunOS server. Yet
there are probably many other scripting tools (ie. Perl + Excel libraries) that
should be able to do the same thing.
HTH
Stephen
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lori Gumbiner
Sent: Thursday, August 31, 2006 1:52 PM
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___
