Re: Attachment Format Conversion?

[Dave Barber]

**

James,

 

I'll agree with OLE.  I did something very similar many years back (in my old Visual Foxpro developer days), using OLE automation to do a lot of processing in Excel that would have just been too painful (or impossible) to perform in VFP (the data that I was using was supplied in Excel format, it would have been a good idea in hindsight to convert it back over to CSV and store that as well, it would have been quite a simple process).

 

But as that was maybe 10 years back, exact details are somewhat vague ...

 

Good luck with it!

Regards

 

Dave

 

On 31/08/06, McKenzie, James J C-E LCMC HQISEC/L3 <[EMAIL PROTECTED]> wrote:

**

Lori:
 
I think you are on the correct track with OLE.  I'm not totally familiar with all of the available functions, but I think it is possible to open a file/template with an embedded macro that reads in the .xls file and then can save it as the same named .csv file.  Sadly, I cannot try this today.

 
James McKenzie
L-3 GSI
 

________________________________

From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Lori Gumbiner
Sent: Thursday, August 31, 2006 9:15 AM
To: arslist@ARSLIST.ORG
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___