I have a subroutine that works with both Accuterm and Wintegrate. It's fairly easy to integrate into an existing report. You can put column headings, set column widths, add formulas, multiple sheets, multiple books. It does quite a bit. I'd be glad to share it with the group if somebody would tell me where to put it. I should also put an example of a program that calls it. Let me know.
Ronnie -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce McAdoo Sent: Friday, February 27, 2004 3:26 PM To: 'U2 Users Discussion List' Subject: RE: UniVerse to excel feeds Don: If you have wIntegrate, terminal emulation and host-based application, you can accomplish your task. I did, but it was about five years ago. Maybe a current wIntegrate user could chime in. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 27, 2004 11:47 AM To: [EMAIL PROTECTED] Subject: RE: UniVerse to excel feeds Don: I have written a program called BEXCEL which takes in a command, formats a csv file, and then uses an ftp process (we have pi/open on hpux) to send this file to a place where the users can open it. For example, the command BEXCEL INMATE | LNAME FNAME MNAME DOB AKA.LN AKA.FN | IRPT1 | ALL | Y reads the INMATE file then outputs a file named "myloginIRPT1.csv" with columns LNAME, FNAME, MNAME, DOB, AKA.LN, and AKA.FN to the designated network site via an ftp transfer. The AKA fields are multivalued and are handled. All records were selected, but in the place of 'ALL' one could have put the name of a select list. The final parameter Y means to put a space between records in the csv file. I have the companion programs HEXCEL, which outputs a .htm file for your browser and has additional parameters to specify headlines, and TEXCEL which is the interactive version where users enter file name, fields desired, etc for Ad Hoc reporting. I have embedded calls to BEXCEL in a few programs ("send report to Excel") and it works fine. There is a little 'local' coding in each of these, but I will be happy to take that code out. You do need to set up a couple of VOC entries (easy) and also set up the ftp process to get the file automatically sent to the desired network directory (I needed my network guys to do this for me). Free if you would like to take a look. Harold Oaks Don Cutting wrote: Hi All, We are looking for a process, where a report run in UniVerse can feed direct into excel, with no human action being taken - or as little as possible. If you have a process or tool where you can do this, and are willing to share this information, please e-mail. We are on UniVerse 10.0.19 and AIX 5.2 Thank you in advance for your suggestions. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
